database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
15,562 Commits 1,785 Branches 392 Tags
fts5-data-version
Commit Graph

5691 Commits

Author SHA1 Message Date
drh
892ffcc7fc Fix the query planner so that it is able to use the integer primary key 
from an index as part of a multi-column constraint.

FossilOrigin-Name: 96ea9909429f0b3b4a67002e8340ae3f7dc0b73f
 2016-03-16 18:26:54 +00:00
drh
0ff47e9e1b Implement FROM-clause subqueries as co-routines whenever they are guaranteed 
to be the outer-most loop of the join.

FossilOrigin-Name: c7bae50bdccb5bcf3bc22e8ac5bb6725ef13db39
 2016-03-15 17:52:12 +00:00
drh
82f525406a More test-case changes so that everything works when the reserved_bytes 
value in the header is non-zero.

FossilOrigin-Name: 2fd095b14b03a508169bba710d2e8e2addf4b8f5
 2016-03-15 12:37:08 +00:00
dan
089555c8e9 Fix the shellN.test test scripts so that they work with the --testdir option. 
FossilOrigin-Name: 051c61ebae921b70f843c55aacf046a9922cc187
 2016-03-15 09:55:44 +00:00
drh
a580936383 Fix the permutations.test script so that it works again. 
FossilOrigin-Name: 9f194f90c07d5415b1d6bb10ec049f74999d6885
 2016-03-14 21:26:25 +00:00
drh
4a8a646723 Changing page size using VACUUM or backup is not allowed with a codec attached. 
FossilOrigin-Name: 92be06c1a828d56652fa5269a3029f8cb029b2cd
 2016-03-14 20:49:24 +00:00
drh
05586c3284 Merge test script fixes from trunk. 
FossilOrigin-Name: ea1d2cddd59192251ee5fd912b190cded4959879
 2016-03-14 18:42:04 +00:00
drh
7da56b4f65 Many more test cases fixed. Only a few remain. 
FossilOrigin-Name: 99b9d7eef68fd6d5c9eecb5fbe3dfe002c1ca4a8
 2016-03-14 18:34:42 +00:00
drh
af3906a798 Many test cases fixed to work with encryption. 
FossilOrigin-Name: d866fffb8b1af5003a8730ce7029d1edddb24d46
 2016-03-14 17:05:04 +00:00
drh
7bd6b49a3e Test script changes to support testing the SQLite Encryption Extension. 
FossilOrigin-Name: 1c70aa5c014fc48ab06215992a61c6f92490abe4
 2016-03-14 16:16:43 +00:00
dan
de503eb166 Fix the backcompat.test script so that it works with the --testdir test option. 
FossilOrigin-Name: f7480e33eb82f2eae219d17ce46cd2d4edac07d2
 2016-03-14 15:43:03 +00:00
drh
e500f65a2c More file pathname normalization. 
FossilOrigin-Name: fa8c12921f8361f1889724bb7c5f7eca9c48b075
 2016-03-14 14:59:35 +00:00
drh
bea14132cf Normalize the $testdir and $argv0 paths so that they continue to work 
in the testing subdirectory.

FossilOrigin-Name: 19225b8130f1640772fc54250583b571a89063b6
 2016-03-14 14:28:43 +00:00
drh
d5704a8961 Run TCL tests in a subdirectory "testdir". 
FossilOrigin-Name: f632bba0d6ad3edc60f4127380ce8320378dac42
 2016-03-14 13:42:29 +00:00
drh
ffbb02a361 Do not allow the use of WAL mode with nolock=1 because it does not work. 
FossilOrigin-Name: 74f5d3b07f6e5e977858c73957c6f9337ae3ca3e
 2016-03-11 23:07:30 +00:00
drh
811f17bac0 Update spellfix1_scriptcode() to output 215 (latin) for pure numeric text. 
FossilOrigin-Name: df44308b862e932ff0ad25b6328d13be22047b96
 2016-03-11 14:30:18 +00:00
dan
57ebc84a6e Fix a problem in fts3/4 that was causing it to discard data cached in-memory if an 'optimize' command is run when there is no data on disk. The usual way this would happen is if the very first transaction that writes to the fts3/4 table also includes an 'optimize' command. 
FossilOrigin-Name: 79338b991bf01e81d336790ca87a0fa747da4ff3
 2016-03-09 18:17:42 +00:00
dan
ab8aa11b96 Add another test case for bug [5e3c8867]. 
FossilOrigin-Name: d91e57e49f23414ec9211b775eb11cd6230a4f96
 2016-03-09 15:14:54 +00:00
drh
90730c9e68 When optimizing expressions of the form "x IN (SELECT ...)" make sure that 
the subquery is not correlated.  Fix for ticket [5e3c886796e5512].

FossilOrigin-Name: 1ed6b06ea3c432f920fb2b66b6042be906c5d21c
 2016-03-09 15:09:22 +00:00
drh
c5644346b6 Disable the bestindex*.test modules when building without virtual table support. 
FossilOrigin-Name: e0bac2f3eed900d3a26de339fb7d5963f9b47724
 2016-03-09 11:59:16 +00:00
drh
9219bf9839 Add the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS 
compile-time options.  Automatically switch to the WAL_SYNCHRONOUS setting
when first opening a WAL-mode database if the synchronous setting has not
been previously set by the application.

FossilOrigin-Name: 5a847a676e756bbe33436596d4279f339bfb247c
 2016-03-08 15:47:47 +00:00
dan
c7dbce0f2a Update fts3/4 so that the 'merge=X,Y' command merges at least, instead of exactly, Y segments from a single level. This matches the documentation. 'merge=X,0' is, as it was in 3.11, an error. 
FossilOrigin-Name: 64b3cb29159491cbfab7e01844b54408541ece5e
 2016-03-08 15:37:48 +00:00
drh
e243de5cf5 If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as 
SQLITE_DEFAULT_SYNCHRONOUS and the application has not run
"PRAGMA synchronous", then set synchronous to the 
SQLITE_DEFAULT_WAL_SYNCHRONOUS setting when entering WAL mode for
the first time.

FossilOrigin-Name: 5791407b523abd24e832fc2361b3e9f01ee2f36a
 2016-03-08 15:14:26 +00:00
drh
6de32e7cdb Simplified error detection in the xBestIndex processing. 
FossilOrigin-Name: 82ca2131b670505578628687746135ac413d156b
 2016-03-08 02:59:33 +00:00
dan
108b7953ed Update fts3/4 so that the 'merge=X,0' command merges X pages from all segments of the first level in the fts index that contains 2 or more segments. 
FossilOrigin-Name: cddf69dbc46f10ee7e87538dd850e086386b544c
 2016-03-07 20:14:27 +00:00
dan
104ead923e Fix a problem in the previous commit affecting queries with three or more tables joined together to the right of a LEFT or CROSS JOIN operator. 
FossilOrigin-Name: d8d89d69a490a708b83147945f74134ae0e4b387
 2016-03-05 21:32:14 +00:00
dan
115305ff00 Change the way SQLite invokes the xBestIndex method of virtual tables so that N-way joins involving virtual tables work as expected. 
FossilOrigin-Name: ffc65968ede2c402e616147e6e3d737e6f9de21d
 2016-03-05 17:29:08 +00:00
drh
3ac9a86415 Update test cases to taken deferred statement-journal opening into account. 
FossilOrigin-Name: 5b2fe5219ab9ad15969e3374894a75979b65cb3c
 2016-03-04 14:23:10 +00:00
drh
2b33f6e775 Allow the left-hand side of IN operators on virtual tables to have the 
aConstraintUsage[].omit flag clear.

FossilOrigin-Name: 3eb74342740cd393e03aa38cd01690ccab173b76
 2016-03-03 20:42:18 +00:00
drh
5b38201708 Merge 3.11.1 changes into trunk. 
FossilOrigin-Name: 7abc2dd953477797fa05421b061d73596aa025fb
 2016-03-03 17:54:30 +00:00
dan
b78b83a2f6 Add new test script bestindex1.test to the utf16 permutation. 
FossilOrigin-Name: 5893e97244126c80762e55249461f21a4e81bb70
 2016-03-02 17:57:53 +00:00
dan
512c09b0bd Add an extra test for the change on this branch. 
FossilOrigin-Name: d2d28251566d2a0ec1a07fe5b8ed047136840bfd
 2016-03-02 16:13:53 +00:00
dan
9cc24c8002 Enhance test_bestindex.c so that it can be used to test plans generated by xBestIndex. 
FossilOrigin-Name: 3c15a9bf45cd7dae2fbd99123b8dd75ce278d6e4
 2016-03-02 16:01:41 +00:00
dan
341b20fb12 Fix a recently introduced problem in permutations.test causing an error when the QUICKTEST_OMIT environment variable is defined. 
FossilOrigin-Name: 45bc9557722cc2a1398a53fdb2acd8b6692f3121
 2016-03-02 15:37:50 +00:00
drh
dbc49161c0 Allow the left-hand side of IN operators on virtual tables to have the 
aConstraintUsage[].omit flag clear.

FossilOrigin-Name: 1622623cbbfc4325c53d731aba78ca9c382ec612
 2016-03-02 03:28:07 +00:00
drh
7434b1dbf4 New test cases and infrastructure for testing the xBestIndex method of 
virtual tables.

FossilOrigin-Name: 1d41c161165006d6c2af47e476f05fb13039f8b8
 2016-03-01 22:48:00 +00:00
drh
4fb48e4eb1 Improved debugging output with wheretrace. Fix some typos in test script 
comments.

FossilOrigin-Name: 13a37fd487ce7d4f98a12f7a67a9c05dadc66557
 2016-03-01 22:41:27 +00:00
dan
a3a44dd379 Allow test_bestindex.c to set the omit flag for a constraint. 
FossilOrigin-Name: 759b9d5b22aa60cc1d6b606f81eb7366c28cbcbe
 2016-03-01 18:24:36 +00:00
dan
8e4251b633 Add test code useful for testing the planners use of teh virtual table xBestIndex() method. 
FossilOrigin-Name: de034c0db66298454ae8418949d58eb6e223c0de
 2016-03-01 18:07:43 +00:00
dan
e82126c9d0 Add -DSQLITE_ENABLE_FTS5 to one of the release-test configurations in releasetest.tcl. Run fts5 tests as part of "make test" if SQLITE_ENABLE_FTS5 is defined. 
FossilOrigin-Name: 3cee93716f2aece03bf9b835fb7b5294e4ddc176
 2016-03-01 16:02:57 +00:00
drh
fc1a84c57b Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. 
FossilOrigin-Name: f681d800340e0e710f73d0f7c09101f899249183
 2016-02-27 19:19:22 +00:00
drh
3478490332 Enhance the ".stats" command in sqlite3.exe to show one-time stats information 
if invoked with one argument.  Also show /proc/PID/io information if run on
Linux.

FossilOrigin-Name: 3c36948f16b58fe8042c37d0df634308b4e48217
 2016-02-27 17:12:36 +00:00
drh
4f8f5e4446 Fix a requirement mark to conform to a typo fix in the documentation. 
FossilOrigin-Name: d1392c627934b89cdb86d82e73d56e8f76952b30
 2016-02-27 14:04:27 +00:00
drh
d892ac97bb Enhance documentation of sqlite3_snapshot_open() to explain that the database 
connection must have participated in at least one read operation prior to
the beginning of the transaction for which the snapshot is to be opened.
Add test cases for this fact.

FossilOrigin-Name: 33dd671cb9c17f08dbc61aed91e80eaeb84bfaf5
 2016-02-27 14:00:07 +00:00
drh
88a1650859 Fix a potential buffer overflow in the ICU upper() function. 
FossilOrigin-Name: b8dc1b9f5d413000387bfe784b69f5d0ee5c0489
 2016-02-26 21:20:57 +00:00
drh
d42908fb0e Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to 
sqlite3_db_config() that can be used to activate the two-argument version
of fts3_tokenizer() for a specific database connection at run-time.

FossilOrigin-Name: 374b5108087a2eae03676c0f3469b37a272145bf
 2016-02-26 15:38:24 +00:00
drh
26bcc7cf40 Ephemeral tables used to hold manifested views may not be unordered since 
they might be subject to an ordered comparison if they are part of a join.

FossilOrigin-Name: 3ef6a3153267d5328202fea24fd29ff4d5409295
 2016-02-26 04:13:39 +00:00
drh
c9eaeef1fe Remove a debuggin "exit" command mistakenly left in the "where.test" module. 
FossilOrigin-Name: beda0b8c76c2c7328a44156257c978cf8f5df59b
 2016-02-26 04:04:07 +00:00
drh
8c098e61b6 Fix an incorrect cost computation for sorting (introduced just a few 
check-ins ago).  Should be NlogN, not NloglogN.

FossilOrigin-Name: 2459d3238853951bc3a507dd975e7ec921cf8446
 2016-02-25 23:21:41 +00:00
dan
aa9ffaba4a Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. 
FossilOrigin-Name: 9ffff484bb4b67c29dda6180d7d766ad13988fe1
 2016-02-25 20:17:55 +00:00