database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-18 10:21:03 +03:00
Code Activity
29,836 Commits 1,610 Branches 185 Tags
json-opt
Commit Graph

9709 Commits

Author SHA1 Message Date
drh
e0d058c6d8 In the spellfix phonehash() function, add letter W into the same character 
class as V.

FossilOrigin-Name: 7536101317c00fbb5bf555120feb55b9bc40e8ba
 2012-08-31 14:55:05 +00:00
dan
7417cefec6 Update with latest trunk changes. 
FossilOrigin-Name: 87995dc9409482f0a7a367bfc51d78ac0f63b8c3
 2012-08-31 14:23:16 +00:00
drh
373cfbc760 Exclude the atof1.test test script from the valgrind permutations test since 
valgrind sets up the floating point hardware in an unusual way that makes
atof1 fail.

FossilOrigin-Name: d3cf6832a59fe4c5723761abb4c89614406b03db
 2012-08-30 20:24:39 +00:00
dan
67c70142d9 Fix a case where SQLite was failing to detect a syntax error in queries like "SELECT ... FROM (<select-1> UNION ALL <select-2>)" when <select-1> and <select-2> return different numbers of result columns. 
FossilOrigin-Name: 200a81358c3117401d2258dd06bb8d2ea4f0ef51
 2012-08-28 14:45:50 +00:00
mistachkin
d5578433ff Fix all known instances of 'repeated the' style typos in comments. No changes to code. 
FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c
 2012-08-25 10:01:29 +00:00
drh
310874ca00 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: aa62d6881b5aae64e15dbae70ce8e77bcc2a9f0b
 2012-08-25 01:21:36 +00:00
dan
606bb3a54e Another test for whereD.test. 
FossilOrigin-Name: 29d586178dcfdb99eaf7ce768668ab0aa9898c83
 2012-08-24 19:58:18 +00:00
dan
899339154e Add extra tests to whereD.test. 
FossilOrigin-Name: 7e961eef6b7260dd8deb8b3812218a874c382885
 2012-08-24 19:52:25 +00:00
drh
8fea5f3b97 More test cases for OR-optimization covering indices. 
FossilOrigin-Name: e5c3190c27b69dc50f348c849a81b79031b2fb67
 2012-08-24 17:52:54 +00:00
drh
2797c21639 Additional test cases for OR-optimization with covering indices, including 
one test case that currently fails.

FossilOrigin-Name: d8b7ab37120ac20e60b6a600cd0e5b34a09cf97a
 2012-08-24 15:29:03 +00:00
dan
bfca6a4066 Experimental change to support the covering index optimization for queries with OR terms in the WHERE clause that search a single index more than once. 
FossilOrigin-Name: 1dc8c7c741a82bb98a07f3fdb8142d8bc8d8a98b
 2012-08-24 10:52:35 +00:00
drh
ed551b95a4 Add test cases and fix bugs associated with the previous check-in 
enhancements to nested aggregate subquery processing.

FossilOrigin-Name: 00b1dc71be4c3420730b5f7840af824ea86165e7
 2012-08-23 19:46:11 +00:00
drh
030796df8d Further improvements to the processing of nested aggregate queries. 
FossilOrigin-Name: 3c3ffa901f5ce8a523028ff15563ce3e0f55a641
 2012-08-23 16:18:10 +00:00
dan
4dc3d73d69 Add the SQLITE_DISABLE_FTS4_DEFERRED compile time option. 
FossilOrigin-Name: e799222f3b8246e65657a758437914ece7069ba9
 2012-08-20 17:24:48 +00:00
drh
342ced4b92 Changes to the spellfix test script to make the results deterministic. 
FossilOrigin-Name: 31c07db2560ee867723c41cdb634e2aa7993634d
 2012-08-15 16:43:07 +00:00
drh
16de7f4d32 Merge all the latest trunk changes into the sessions branch. 
FossilOrigin-Name: fc07a4795e027108674d1d41eb4350df629ddc8b
 2012-08-15 16:21:55 +00:00
drh
c16eb6934d Update the spellfix virtual table to the latest development code. 
FossilOrigin-Name: 6954fef006431d153de6e63e362b8d260ebeb1c6
 2012-08-14 17:29:27 +00:00
dan
acf239b589 Change to securedel2.test so that it works even if SQLITE_DEFAULT_AUTOVACUUM=1 is defined. 
FossilOrigin-Name: 1e6f5ea48174e3cb59e6d9fe1293fd87bd9c78f5
 2012-08-08 10:14:10 +00:00
dan
2aba5d96f4 Add extra tests for secure-delete mode. 
FossilOrigin-Name: e380cd3ce34d509e184081ecccf27fda11ce1da7
 2012-08-07 17:41:50 +00:00
dan
81f0740e59 Do not run test script spellfix.test if SQLITE_OMIT_VIRTUAL_TABLE is defined. Fix walro.test so that it works if DEFAULT_AUTOVACUUM is defined. 
FossilOrigin-Name: 26428b459b45d0fa9fcad7eb5e58bd60b04a0f83
 2012-08-07 14:18:18 +00:00
dan
809badc93a Fix a bug in walthread.test causing intermittent failures. 
FossilOrigin-Name: a192a718d513002b58ad585fcb3d8b9b49b4b123
 2012-08-07 13:55:41 +00:00
dan
09ac7ec544 Merge the sorter-coalesce-writes branch into the trunk. This improves CREATE INDEX performance on some platforms. 
FossilOrigin-Name: e1e9cb08b011e67b767091e42225f22ec862fa64
 2012-08-06 19:28:20 +00:00
dan
428c218c90 When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. 
FossilOrigin-Name: d045f8b2d44e388d8c4549ff02d4ca7eff4e2038
 2012-08-06 18:50:11 +00:00
dan
3b2c9b3250 Modify the code in vdbesort.c so that most reads and writes to temporary files are aligned page-sized blocks. 
FossilOrigin-Name: 55e47ef338c42f95f0f071d6ec92cd2480f9f1fe
 2012-07-23 19:25:39 +00:00
dan
5373b76bdc Ensure that there is always at least one aReadMark slot usable by an unprivileged reader while a checkpoint is running. Also, if one or more transactions are recovered from a log file, initialize one of the aReadMark slots to contain mxFrame as part of the recovery process. 
FossilOrigin-Name: e4163596339c2166f9c4356ab824fff8bda8d0b0
 2012-07-17 14:37:12 +00:00
dan
5ad17e5d03 Merge trunk changes. 
FossilOrigin-Name: 90df64ab803001819b3ebbb41d596aedbd9961b1
 2012-07-16 10:25:54 +00:00
dan
5885e76269 If a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA quick_check" command, search for problems in the nominated database only. i.e. "PRAGMA main.quick_check" now only scans the main database, not all attached databases as before. 
FossilOrigin-Name: 4353e40b74f577f224f190c429bfe03cf6a5c6d6
 2012-07-16 10:06:12 +00:00
dan
8512752407 Add the "matchlen" column to the spellfix1 virtual table. 
FossilOrigin-Name: f24b9d87f6b0e8b4d26669d5c1191f9280ba14a3
 2012-07-13 19:26:34 +00:00
drh
ed68801b20 Add the sqlite3_close_v2() interface (from the deferred-close branch) that 
allows close operations to happen out-of-order in bindings to
garbage-collected langauges.

FossilOrigin-Name: fb8893abeefabe9de44e34dcf4327764481189f5
 2012-06-21 15:51:42 +00:00
drh
567520226a Merge changes to trunk that ensure that floating point values are exactly 
preserved on a round-trip through ".dump".

FossilOrigin-Name: 4cebd60704f92bb3689c126f46feadc3516d3d45
 2012-06-21 15:22:04 +00:00
mistachkin
f1c6bc5cd3 Remove more references to OS/2. 
FossilOrigin-Name: eebd594d6bd09c77727620a818d7dc0b091f55b4
 2012-06-21 15:09:20 +00:00
drh
c722a2c2e4 Disable the atof1.test module when compiling on MSVC. 
FossilOrigin-Name: 0f706acfc7181f2714a06b2c232677ebeede3a44
 2012-06-21 15:02:26 +00:00
dan
3aaa4cd9ed Add tests to check that the "unicode61" and "icu" tokenizers both identify white-space codepoints outside the ASCII range. 
FossilOrigin-Name: bfb2d4730cbbe18fb940e72f4fde9122d550734e
 2012-06-19 06:35:39 +00:00
drh
4aaf1552be Fix an incorrect testcase for the round() function. All tests are passing 
now, including new real->text->real round-trip tests.

FossilOrigin-Name: 963eb24f737f184d5fcdcd92ebf90466f818cfd8
 2012-06-19 03:59:30 +00:00
drh
4ef9413028 Round-trip conversions of real->text->real are now lossless on x64 with GCC. 
Untested on other platforms so far.  Still a corner-case problem with round().

FossilOrigin-Name: fd7bd4a59361be41b10522abc212cf56fb5e35b4
 2012-06-19 03:35:05 +00:00
drh
72b3fbc7b5 Improved accuracy on text-to-real and real-to-text conversions. Most 
conversions now round-trip correctly.  Still need to fix some corner
cases.

FossilOrigin-Name: 8ecffca900cd6a8922001fd458a266ce8c83fb66
 2012-06-19 03:11:25 +00:00
drh
89f15088f0 Improved rounding accuracy on test-to-float conversions. 
FossilOrigin-Name: 699b792c6a0e989994549959b11ec1bfad8bbd92
 2012-06-19 00:45:16 +00:00
dan
2ae26b759d Fix a problem with identifying white-space characters outside of the ascii range in the ICU tokenizer. 
FossilOrigin-Name: 892b74116a3b23268895b96433d18ef00c1433d8
 2012-06-18 20:52:32 +00:00
dan
618fea4830 Merge latest trunk changes with sessions branch. 
FossilOrigin-Name: 47f8f0711d63ef4166db9115db44b166959df14c
 2012-06-09 19:15:43 +00:00
dan
b6a69a66e5 Fix a problem in vtab1.test causing it to fail when run with any permutation that executes SQL within the tcl "sqlite3" command. 
FossilOrigin-Name: 006db555260273209933371d17afb33d557baa68
 2012-06-08 11:48:40 +00:00
drh
8973a04e3b Merge all trunk changes, including the WinRT enhancements, into the 
sessions branch.

FossilOrigin-Name: c62140398344fd1a68a3e6dfe8b4fab280731ebb
 2012-06-07 23:58:36 +00:00
drh
155812d318 Documentation and evidence mark updates. Remove a redundant assert(). 
FossilOrigin-Name: cfcbf9375fddd0aae0dd17bdc76a710ab77ef667
 2012-06-07 17:57:23 +00:00
dan
0b8dcfa2bd Fix a problem preventing a shared in-memory database from being attached to a read-only connection. 
FossilOrigin-Name: 7caca1939ce70d5b14ae8ca8ff6afb62f8aff361
 2012-06-07 17:16:04 +00:00
dan
25cdf46ae4 Add the "tokenchars=" and "separators=" options, for customizing the set of characters considered to be token separators, to the unicode61 tokenizer. 
FossilOrigin-Name: e56fb462aa1f11bb23303ae0dc62815c21e26a52
 2012-06-07 15:53:48 +00:00
dan
a879342b0e Fix a malloc/free mismatch in pager.c (sqlite3_free() called on a buffer allocated by sqlite3DbMalloc()). 
FossilOrigin-Name: 506008f000ba4af0b35da023b8c52f7a3f5033bd
 2012-06-07 07:24:04 +00:00
drh
cc71645bf7 Merge the changes need to compile on WinRT into trunk. 
FossilOrigin-Name: 61360ca6ca3448477d5c662d3642beef6dd2079e
 2012-06-06 23:23:23 +00:00
dan
754d3adf7c Have the FTS unicode61 strip out diacritics when tokenizing text. This can be disabled by specifying the tokenizer option "remove_diacritics=0". 
FossilOrigin-Name: 790f76a5898dad1a955d40edddf11f7b0fec0ccd
 2012-06-06 19:30:38 +00:00
drh
bae591a960 Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism 
in that branch.

FossilOrigin-Name: 42338e9e6979bb497823527f8f39e96f63623c59
 2012-06-05 19:20:03 +00:00
drh
98c78ea63f Add sqlite3_quota_ferror() and sqlite3_quota_file_available() interfaces to 
test_quota.c.  Change sqlite3_quota_fwrite() to use a const input buffer.

FossilOrigin-Name: 61669c95859e187618fb2fb4249306a947ae8d26
 2012-06-05 13:56:15 +00:00
drh
167cd6ab78 Revert sqlite3_close() to legacy behavior. Create a new sqlite3_close_v2() 
interface that exhibits the deferred-close behavior.  This minimizes the
chance of breakage in legacy apps.

FossilOrigin-Name: c4b8621125ce77308b06692d92f70586b10055a9
 2012-06-02 17:09:46 +00:00