]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
16 years agoRemove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c...
danielk1977 [Sat, 10 Jan 2009 17:57:48 +0000 (17:57 +0000)] 
Remove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c. (CVS 6161)

FossilOrigin-Name: 8f0672af8d7d46124d01e540eec7b43fc16dd552

16 years agoRemove an faulty assertion inserted a few days ago. (CVS 6160)
drh [Sat, 10 Jan 2009 17:02:02 +0000 (17:02 +0000)] 
Remove an faulty assertion inserted a few days ago. (CVS 6160)

FossilOrigin-Name: 495f017e03f32420e6a6a7685125a86929cef142

16 years agoWhen compiled with SQLITE_DEBUG (in other words, when assert() is enabled)
drh [Sat, 10 Jan 2009 16:15:20 +0000 (16:15 +0000)] 
When compiled with SQLITE_DEBUG (in other words, when assert() is enabled)
the ALWAYS and NEVER macros will throw an assertion if their arguments are
not true or false, respectively. (CVS 6159)

FossilOrigin-Name: 64a8dcd8d6152108809e4d10c459f1de5d36a435

16 years agoImprove coverage of pager.c. (CVS 6158)
danielk1977 [Sat, 10 Jan 2009 16:15:09 +0000 (16:15 +0000)] 
Improve coverage of pager.c. (CVS 6158)

FossilOrigin-Name: 855c4093cf331496d9ef508011ad814e91e3882f

16 years agoFix a bug caused by overzealous code test coverage simplifications.
drh [Sat, 10 Jan 2009 15:34:12 +0000 (15:34 +0000)] 
Fix a bug caused by overzealous code test coverage simplifications.
Bug found by TH3. (CVS 6157)

FossilOrigin-Name: 3da5578726cb22118dfca38a2098a1e378644387

16 years agoRemove some unused code from expr.c in order to increase test coverage. (CVS 6156)
drh [Sat, 10 Jan 2009 13:24:50 +0000 (13:24 +0000)] 
Remove some unused code from expr.c in order to increase test coverage. (CVS 6156)

FossilOrigin-Name: 2cbea64fb00a1b5b8aa0e9c958b2a09256ae59bc

16 years agoFix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL...
danielk1977 [Sat, 10 Jan 2009 11:13:39 +0000 (11:13 +0000)] 
Fix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL blocks. (CVS 6155)

FossilOrigin-Name: 3d7a8de248ad5fba0e9c88f439cd2d988dcbab8c

16 years agoAdd a malloc failure test case that covers a few previously untested lines in pager...
danielk1977 [Sat, 10 Jan 2009 11:10:18 +0000 (11:10 +0000)] 
Add a malloc failure test case that covers a few previously untested lines in pager.c (CVS 6154)

FossilOrigin-Name: 000aedb0471b5f5a69e7b61f5e1d4b2644994f32

16 years agoCoverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__,
drh [Fri, 9 Jan 2009 21:41:17 +0000 (21:41 +0000)] 
Coverage improvements in pragma.c.  Change the __DARWIN__ macro to __APPLE__,
which is available by default on Leopard. (CVS 6153)

FossilOrigin-Name: 64c56226b91e57883c8059f65330318e53376b8a

16 years agoIncrease pager.c coverage a bit. Fix an assert failure that can occur following a...
danielk1977 [Fri, 9 Jan 2009 17:11:04 +0000 (17:11 +0000)] 
Increase pager.c coverage a bit. Fix an assert failure that can occur following a "PRAGMA omit_readlock" command on a read-only database. (CVS 6152)

FossilOrigin-Name: 0f3f9011fa143f7b63c9bf79d3e411327d5c6f9d

16 years agoFix two problems in test instrumentation that show up on some fulltests. (CVS 6151)
drh [Fri, 9 Jan 2009 14:29:35 +0000 (14:29 +0000)] 
Fix two problems in test instrumentation that show up on some fulltests. (CVS 6151)

FossilOrigin-Name: c917961743e9ab60a096801c8910c6cd8367ee2f

16 years agoSimplifications to btree.c to improve test coverage. (CVS 6150)
drh [Fri, 9 Jan 2009 14:11:04 +0000 (14:11 +0000)] 
Simplifications to btree.c to improve test coverage. (CVS 6150)

FossilOrigin-Name: ac84f106d572e881136adc3434d00d70564f57cb

16 years agoAdd a couple of coverage tests. (CVS 6149)
danielk1977 [Fri, 9 Jan 2009 10:49:14 +0000 (10:49 +0000)] 
Add a couple of coverage tests. (CVS 6149)

FossilOrigin-Name: 6a64109d1f9b63ac8b29ea2c77da02506387b4a1

16 years agoMore coverage improvements. (CVS 6148)
drh [Fri, 9 Jan 2009 02:49:31 +0000 (02:49 +0000)] 
More coverage improvements. (CVS 6148)

FossilOrigin-Name: 6e171c0a64850013b26a223189d5bebcc0a01a8b

16 years agoIncreased test coverage. (CVS 6147)
drh [Fri, 9 Jan 2009 01:12:27 +0000 (01:12 +0000)] 
Increased test coverage. (CVS 6147)

FossilOrigin-Name: 45bb5703d7ef5e835b43a6fa7ee2a2d96db76939

16 years agoIncreased test coverage in where.c. (CVS 6146)
drh [Thu, 8 Jan 2009 21:00:02 +0000 (21:00 +0000)] 
Increased test coverage in where.c. (CVS 6146)

FossilOrigin-Name: 1e5725c5179660277c2e8c321877d7ee3ca21808

16 years agoFix a comment in pager.c. No actual code changes. (CVS 6145)
danielk1977 [Thu, 8 Jan 2009 18:04:13 +0000 (18:04 +0000)] 
Fix a comment in pager.c. No actual code changes. (CVS 6145)

FossilOrigin-Name: 44d3bfddf44b10b3744db6b41bc3f53c3903df5e

16 years agoAvoid an 'invalid cast' warning in test_osinst.c. (CVS 6144)
danielk1977 [Thu, 8 Jan 2009 17:57:31 +0000 (17:57 +0000)] 
Avoid an 'invalid cast' warning in test_osinst.c. (CVS 6144)

FossilOrigin-Name: 931f3a21bd4b6c5760ed64c23e8210cf2c3e3ab5

16 years agoFix a couple of potential corruption problems in pager.c. (CVS 6143)
danielk1977 [Thu, 8 Jan 2009 17:50:45 +0000 (17:50 +0000)] 
Fix a couple of potential corruption problems in pager.c. (CVS 6143)

FossilOrigin-Name: 5a39525ba3e65f1c6df3cf23fbfb57f6a0bf4b62

16 years agoAdd a test script for ticket #2565. Change the assert() in pager.c into
drh [Thu, 8 Jan 2009 15:24:01 +0000 (15:24 +0000)] 
Add a test script for ticket #2565.  Change the assert() in pager.c into
a testcase() macro. (CVS 6142)

FossilOrigin-Name: 1e53e382e5030de4d908098bf77af053dd81f0c5

16 years agoAllow database files to be created in the root directory on unix.
drh [Thu, 8 Jan 2009 14:36:20 +0000 (14:36 +0000)] 
Allow database files to be created in the root directory on unix.
Ticket #3570. (CVS 6141)

FossilOrigin-Name: 81014334ad57e380e21c47ad6eebe9f16b4ad24c

16 years agoClean up test_journal.c to make it easier to follow. (CVS 6140)
danielk1977 [Thu, 8 Jan 2009 12:05:56 +0000 (12:05 +0000)] 
Clean up test_journal.c to make it easier to follow. (CVS 6140)

FossilOrigin-Name: 5a28c7c7b45655dcfd0da4898e77d0240b511c5f

16 years agoIncrease test coverage of where.c. Make sure OR-optimization works on
drh [Thu, 8 Jan 2009 03:11:19 +0000 (03:11 +0000)] 
Increase test coverage of where.c.  Make sure OR-optimization works on
UPDATE and DELETE in addition to SELECT.  (Bug found by coverage tests.) (CVS 6139)

FossilOrigin-Name: 4b2c08e8984befb12fa2173ca89d9f54cf764d22

16 years agoAdd new test cases to increase coverage of where.c. (CVS 6138)
drh [Wed, 7 Jan 2009 20:58:57 +0000 (20:58 +0000)] 
Add new test cases to increase coverage of where.c. (CVS 6138)

FossilOrigin-Name: 2e1ab51f05447f9c1f291636b53b1ec584003841

16 years agoFix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137)
drh [Wed, 7 Jan 2009 18:24:03 +0000 (18:24 +0000)] 
Fix a bug in the LIKE query optimization.  (Found by coverage testing.) (CVS 6137)

FossilOrigin-Name: fe90e9116b6e1e25cf3119d2777a8e9c135153ce

16 years agoMake the same change as (6121) (accidentally reverted). Also enhance test_journal...
danielk1977 [Wed, 7 Jan 2009 18:08:48 +0000 (18:08 +0000)] 
Make the same change as (6121) (accidentally reverted). Also enhance test_journal.c to catch this kind of bug. (CVS 6136)

FossilOrigin-Name: ccc9c211a285fd4da68b69e15594f080371be522

16 years agoAdd a "synchronous = off" variant to savepoint6.test. (CVS 6135)
danielk1977 [Wed, 7 Jan 2009 17:06:52 +0000 (17:06 +0000)] 
Add a "synchronous = off" variant to savepoint6.test. (CVS 6135)

FossilOrigin-Name: 0f57011e3b21fa5f6a819ce5a7fd8d44ea70679f

16 years agoChange SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket...
danielk1977 [Wed, 7 Jan 2009 16:15:42 +0000 (16:15 +0000)] 
Change SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket #3567. (CVS 6134)

FossilOrigin-Name: 1fe79ffd772900bdca85ec6cf072677be53cd5ff

16 years agoFor archival purposes, add the TCL script that was used to generate many
drh [Wed, 7 Jan 2009 15:52:54 +0000 (15:52 +0000)] 
For archival purposes, add the TCL script that was used to generate many
of the test cases for where7.test. (CVS 6133)

FossilOrigin-Name: 0e01cdc8d283acd2757d69bf6d8e36bb1f47d460

16 years agoConjecture: a journal header with nRec==0 must be the last header in the
drh [Wed, 7 Jan 2009 15:33:45 +0000 (15:33 +0000)] 
Conjecture: a journal header with nRec==0 must be the last header in the
journal.  Add asserts to make this conjecture explicit. (CVS 6132)

FossilOrigin-Name: 15b5b5f90c2ffa79155cdc2dbc4fb5583cb72017

16 years agoFix for 'truncate file' operations on in-memory databases. (CVS 6131)
danielk1977 [Wed, 7 Jan 2009 15:18:20 +0000 (15:18 +0000)] 
Fix for 'truncate file' operations on in-memory databases. (CVS 6131)

FossilOrigin-Name: 83d1eafbde556f56969c6f285b6767d2c658dbfc

16 years agoAdd a comment to the openSubjournal() function in pager.c. (CVS 6130)
danielk1977 [Wed, 7 Jan 2009 10:52:56 +0000 (10:52 +0000)] 
Add a comment to the openSubjournal() function in pager.c. (CVS 6130)

FossilOrigin-Name: 04387ae10ab3be24c93497f4af6f48d6832f37eb

16 years agoFix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint...
danielk1977 [Wed, 7 Jan 2009 10:35:18 +0000 (10:35 +0000)] 
Fix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint on an auto-vacuum database. (CVS 6129)

FossilOrigin-Name: 3a4bb83235e9a79297e7d5d47ac7674c9df960bf

16 years agoFix savepoint related bugs. A rollback caused by an IO error or "OR ROLLBACK" clause...
danielk1977 [Wed, 7 Jan 2009 08:12:16 +0000 (08:12 +0000)] 
Fix savepoint related bugs. A rollback caused by an IO error or "OR ROLLBACK" clause while one or more savepoints were open was leaving the sqlite3 structure in an invalid state. (CVS 6128)

FossilOrigin-Name: e5d42c69a3b325ca12f53184e33964230acbdd1f

16 years agoAdd a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging
drh [Wed, 7 Jan 2009 03:59:47 +0000 (03:59 +0000)] 
Add a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging
command in the test harness - to force calling pagerStress() more
frequently. (CVS 6127)

FossilOrigin-Name: e426860b94f5b47e3a265549dbac64a421cae425

16 years agoPager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126)
drh [Wed, 7 Jan 2009 02:03:35 +0000 (02:03 +0000)] 
Pager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126)

FossilOrigin-Name: 15b9dac455b3f457bb177fc4985b45957647cbec

16 years agoNow that we have permutations.test, it is really only necessary to run
drh [Tue, 6 Jan 2009 18:43:51 +0000 (18:43 +0000)] 
Now that we have permutations.test, it is really only necessary to run
all.test for a single cycle.  So make that the default. (CVS 6125)

FossilOrigin-Name: 3c2f292fb7c79ba9be32fe8f19e52b35b9cadf6a

16 years agoReduce the number of paths in btreeCopyFile(). (CVS 6124)
danielk1977 [Tue, 6 Jan 2009 18:21:08 +0000 (18:21 +0000)] 
Reduce the number of paths in btreeCopyFile(). (CVS 6124)

FossilOrigin-Name: df2c285cb99ac188c96dd1a4e6a30f689195a150

16 years agoModify test_journal.c to verify the page data being written to the journal file....
danielk1977 [Tue, 6 Jan 2009 17:52:43 +0000 (17:52 +0000)] 
Modify test_journal.c to verify the page data being written to the journal file. (CVS 6123)

FossilOrigin-Name: 0d258956f8971c0af7853b836a7d6e7f3a800c37

16 years agoCleanup of the PAGERTRACE macro. Other comment changes in pager.c. (CVS 6122)
drh [Tue, 6 Jan 2009 15:58:57 +0000 (15:58 +0000)] 
Cleanup of the PAGERTRACE macro.  Other comment changes in pager.c. (CVS 6122)

FossilOrigin-Name: ee7b4b60880e80e6fb0b2f93ebc6ee5ad6917f9d

16 years agoThe fix in (6120) wasn't quite right. This fixes it. (CVS 6121)
danielk1977 [Tue, 6 Jan 2009 15:28:34 +0000 (15:28 +0000)] 
The fix in (6120) wasn't quite right. This fixes it. (CVS 6121)

FossilOrigin-Name: ddc2ebfa529b15cdbdd3b6b6d4873cb085cfd3b9

16 years agoFix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120)
danielk1977 [Tue, 6 Jan 2009 15:20:58 +0000 (15:20 +0000)] 
Fix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120)

FossilOrigin-Name: 2cdbb468ed81d35a7e1a580683864de60e103083

16 years agoUpdate permutations.test so that it does not show an error when running
drh [Tue, 6 Jan 2009 14:50:11 +0000 (14:50 +0000)] 
Update permutations.test so that it does not show an error when running
the singlethread and multithread test cases on THREADSAFE=0 builds. (CVS 6119)

FossilOrigin-Name: 301b57b7bac949dd77037ad3175ba87c41c8c843

16 years agoFix a memory leak in test_journal.c (test code). Also remove function pager_truncate_...
danielk1977 [Tue, 6 Jan 2009 14:34:34 +0000 (14:34 +0000)] 
Fix a memory leak in test_journal.c (test code). Also remove function pager_truncate_cache(), a wrapper around sqlite3PCacheTruncate(), from pager.c. (CVS 6118)

FossilOrigin-Name: a64f3db0b39af53c8d8f80c242baa8aa4b5bd04e

16 years agoFix compiler warnings. (CVS 6117)
drh [Tue, 6 Jan 2009 14:19:36 +0000 (14:19 +0000)] 
Fix compiler warnings. (CVS 6117)

FossilOrigin-Name: da770a8dff183b28aca287cafb9c8b82b98ea968

16 years agoAdd some savepoint related test cases and fix a few problems. (CVS 6116)
danielk1977 [Tue, 6 Jan 2009 13:40:08 +0000 (13:40 +0000)] 
Add some savepoint related test cases and fix a few problems. (CVS 6116)

FossilOrigin-Name: 8c62ea4fded2251e9daf16f2a050f94359299d76

16 years agoRemove leftover "breakpoint" from the fuzz.test script. (CVS 6115)
drh [Tue, 6 Jan 2009 00:11:25 +0000 (00:11 +0000)] 
Remove leftover "breakpoint" from the fuzz.test script. (CVS 6115)

FossilOrigin-Name: c2482d8877a5f9e387b288377e410ae1b8267f3c

16 years agoFix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114)
drh [Tue, 6 Jan 2009 00:08:02 +0000 (00:08 +0000)] 
Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114)

FossilOrigin-Name: a7015625610624be1645e918d0a62cf85bec86ce

16 years agoThe fix in (6111) was not quite right. This version works better. (CVS 6113)
drh [Mon, 5 Jan 2009 22:30:38 +0000 (22:30 +0000)] 
The fix in (6111) was not quite right.  This version works better. (CVS 6113)

FossilOrigin-Name: 5f80140a2df48fd43a7cbc0990de0205004541b0

16 years agoReenable fuzz testing for all.test. Make sure the query flattener copies
drh [Mon, 5 Jan 2009 19:36:30 +0000 (19:36 +0000)] 
Reenable fuzz testing for all.test.  Make sure the query flattener copies
over aggregate information from expressions on outer query terms while
flattening. (CVS 6112)

FossilOrigin-Name: e02323b3629545a3e7e7db0d4edc76807ae903aa

16 years agoMake sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111)
drh [Mon, 5 Jan 2009 18:02:27 +0000 (18:02 +0000)] 
Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111)

FossilOrigin-Name: b2131e868a3a948ba81f7458270493085da1ae60

16 years agoInclude fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110)
drh [Mon, 5 Jan 2009 17:19:03 +0000 (17:19 +0000)] 
Include fuzz3.test in all.test.  Get fuzz3.test working again. (CVS 6110)

FossilOrigin-Name: 77dc19cfabca54353509ff346b12975044d416d5

16 years agoFix some test code problems in "permutations.test journaltest pager.test". (CVS 6109)
danielk1977 [Mon, 5 Jan 2009 17:15:00 +0000 (17:15 +0000)] 
Fix some test code problems in "permutations.test journaltest pager.test". (CVS 6109)

FossilOrigin-Name: cf627752c4537f709acae26a1e335731d55bddb2

16 years agoAdd some tests with attached databases to savepoint.test. Also tests of creating...
danielk1977 [Sat, 3 Jan 2009 15:06:38 +0000 (15:06 +0000)] 
Add some tests with attached databases to savepoint.test. Also tests of creating and dropping tables in auto-vacuum mode inside of a savepoint. (CVS 6108)

FossilOrigin-Name: ca7f11d50d1a73443d18c79dfe4223c975c6e20b

16 years agoWhen the commit_hook calls a query recursively, make sure the commit_hook
drh [Sat, 3 Jan 2009 14:04:38 +0000 (14:04 +0000)] 
When the commit_hook calls a query recursively, make sure the commit_hook
is not invoked recursively.  Ticket #3564. (CVS 6107)

FossilOrigin-Name: 27ae406537c07073db46ecde40c65c78fbb73170

16 years agoFix a typo in a comment. (CVS 6106)
drh [Sat, 3 Jan 2009 12:55:17 +0000 (12:55 +0000)] 
Fix a typo in a comment. (CVS 6106)

FossilOrigin-Name: 50f57cd1456f18919a8c90efa05da446ae12788d

16 years agoAdd test file savepoint6.test. Contains pseudo random tests of savepoint related...
danielk1977 [Sat, 3 Jan 2009 10:41:29 +0000 (10:41 +0000)] 
Add test file savepoint6.test. Contains pseudo random tests of savepoint related commands. (CVS 6105)

FossilOrigin-Name: 2946fbb7183d597b4db1db203eb5fd57c9762dc4

16 years agoMemory allocation failure in Bitvec are probably all benign. Still, add
drh [Fri, 2 Jan 2009 21:39:39 +0000 (21:39 +0000)] 
Memory allocation failure in Bitvec are probably all benign.  Still, add
code to check this, just to be sure. (CVS 6104)

FossilOrigin-Name: 4688e1c8b1203c3538aa862421ed344888059fe2

16 years agoReinitialize page 1 of the database file following a ROLLBACK TO of a
drh [Fri, 2 Jan 2009 21:08:09 +0000 (21:08 +0000)] 
Reinitialize page 1 of the database file following a ROLLBACK TO of a
transactional SAVEPOINT on an initially empty database. (CVS 6103)

FossilOrigin-Name: 3e9efb763875b20c856d748c19e449080a3ae97c

16 years agoFix compiler warnings in pager.c (CVS 6102)
drh [Fri, 2 Jan 2009 18:10:42 +0000 (18:10 +0000)] 
Fix compiler warnings in pager.c (CVS 6102)

FossilOrigin-Name: 78dd7909da15a9b2cbcdb9cbe86798cfc24f3230

16 years agoModify the (transaction) method of the tcl interface to use savepoints. This makes...
danielk1977 [Fri, 2 Jan 2009 17:33:46 +0000 (17:33 +0000)] 
Modify the (transaction) method of the tcl interface to use savepoints. This makes nested calls to (transaction) work more intuitively. (CVS 6101)

FossilOrigin-Name: f047758de9b499866aa4ddf16011498b12a7b963

16 years agoAdd fts_expr.* files to Makefile.in. (CVS 6100)
shane [Fri, 2 Jan 2009 15:47:01 +0000 (15:47 +0000)] 
Add fts_expr.* files to Makefile.in. (CVS 6100)

FossilOrigin-Name: 524c8634dfa5926f38fac8bac1da6a14178c7764

16 years agoMany of the boundary tests depend on a working 64-bit implementation of TCL, so skip...
shane [Fri, 2 Jan 2009 15:45:47 +0000 (15:45 +0000)] 
Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099)

FossilOrigin-Name: b1a4a17f8752d27f3b360019490ab3f15a1f629f

16 years agoIncrement the version number to 3.6.8. (CVS 6098)
drh [Fri, 2 Jan 2009 12:35:03 +0000 (12:35 +0000)] 
Increment the version number to 3.6.8. (CVS 6098)

FossilOrigin-Name: 7509641a4c410b1eaaf1edba259fbe01cd60b108

16 years agoDo not display matches against
drh [Fri, 2 Jan 2009 01:10:42 +0000 (01:10 +0000)] 
Do not display matches against
the right-hand side of a NOT operator in the output
of the FTS snippet() or offsets() functions. (CVS 6097)

FossilOrigin-Name: d44c84c0f77bd0fc4a9942177b6cae6d109b89b7

16 years agoFix a (benign) valgrind error that can occur following malloc failure while executing...
danielk1977 [Thu, 1 Jan 2009 15:20:37 +0000 (15:20 +0000)] 
Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096)

FossilOrigin-Name: 9ff8598f3be123a244f71b45e77af913b836504a

16 years agoFix some problems in the fts3 expression parser with mismatched parenthesis. (CVS...
danielk1977 [Thu, 1 Jan 2009 14:06:13 +0000 (14:06 +0000)] 
Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095)

FossilOrigin-Name: ccfe4580ac7ba9add0e69c786a9a3a43d69b7753

16 years agoAdditional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094)
drh [Thu, 1 Jan 2009 12:34:45 +0000 (12:34 +0000)] 
Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094)

FossilOrigin-Name: afac4293000f81410d105a99956605bf7102fa62

16 years agoAdd a couple of extra tests for the fts3 expression parser to improve mcdc coverage...
danielk1977 [Thu, 1 Jan 2009 07:42:49 +0000 (07:42 +0000)] 
Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093)

FossilOrigin-Name: 13146b34935d339d7b8379083e024647af07e2c1

16 years agoAdd pseudo-random tests of the fts3 expression parser. Revise the fix in (6091)....
danielk1977 [Thu, 1 Jan 2009 07:08:54 +0000 (07:08 +0000)] 
Add pseudo-random tests of the fts3 expression parser. Revise the fix in (6091). (CVS 6092)

FossilOrigin-Name: 11c2d4686197fb3f0d601651d5bbb3492af8f0dd

16 years agoFix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091)
danielk1977 [Thu, 1 Jan 2009 04:19:51 +0000 (04:19 +0000)] 
Fix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091)

FossilOrigin-Name: d1a6a2edd799d65ff88510df951e909919e35b6b

16 years agoAvoid surplus bytes at the end of the keyword string table.
drh [Wed, 31 Dec 2008 21:52:40 +0000 (21:52 +0000)] 
Avoid surplus bytes at the end of the keyword string table.
Add testcase() macros to make sure all keywords are used during
testing. (CVS 6090)

FossilOrigin-Name: 73958060aaf641d93bede3a42851e5b3451f5432

16 years agoFix the name in the documentation of the compile-time macro for
drh [Wed, 31 Dec 2008 19:27:53 +0000 (19:27 +0000)] 
Fix the name in the documentation of the compile-time macro for
enabling FTS3 parenthesis processing. (CVS 6089)

FossilOrigin-Name: ac8258da6ecd3ea37f394dc3b48834eb57832cf4

16 years agoFix the FTS3 expression parser so that it works in the amalgamation when
drh [Wed, 31 Dec 2008 16:27:58 +0000 (16:27 +0000)] 
Fix the FTS3 expression parser so that it works in the amalgamation when
FTS3 is disabled. (CVS 6088)

FossilOrigin-Name: 7e238e8604b9a9f786d84a47d21c6b42f1585755

16 years agoFix the FTS3 module with parenthesis syntax so that it will work in
drh [Wed, 31 Dec 2008 16:01:04 +0000 (16:01 +0000)] 
Fix the FTS3 module with parenthesis syntax so that it will work in
the amalgamation. (CVS 6087)

FossilOrigin-Name: c2b9891fc05ec05b270f108f61ab81b2df874e01

16 years agoFix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint"
drh [Tue, 30 Dec 2008 17:55:00 +0000 (17:55 +0000)] 
Fix a bug in the multi-index OR cost estimator.  Remove leftover "breakpoint"
commands from test scripts. (CVS 6086)

FossilOrigin-Name: b090d5736d7eaec17a39d3133e1587b1d2a42acb

16 years agoAdd LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)
drh [Tue, 30 Dec 2008 16:35:53 +0000 (16:35 +0000)] 
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085)

FossilOrigin-Name: 96f3b62914adde34079f08428b4e2fe81c193612

16 years agoGet EXPLAIN QUERY PLAN working with the multi-index OR optimization.
drh [Tue, 30 Dec 2008 16:18:47 +0000 (16:18 +0000)] 
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization.
Added new test script "where9.test". (CVS 6084)

FossilOrigin-Name: 4b6460221011e02bedb724169e8e4793e539e65a

16 years agoAdd further pseudo-randomly generated test cases to where8.test. (CVS 6083)
danielk1977 [Tue, 30 Dec 2008 16:13:04 +0000 (16:13 +0000)] 
Add further pseudo-randomly generated test cases to where8.test. (CVS 6083)

FossilOrigin-Name: e01f6ef9d981d50a70c05edc4ef8135dbc473ba1

16 years agoFix a bug in where8.test causing a tcl exception. (CVS 6082)
danielk1977 [Tue, 30 Dec 2008 15:51:40 +0000 (15:51 +0000)] 
Fix a bug in where8.test causing a tcl exception. (CVS 6082)

FossilOrigin-Name: 495b569a3921042c36667a415c1353201760fa17

16 years agoAdd a few more tests to where8.test. (CVS 6081)
danielk1977 [Tue, 30 Dec 2008 15:26:29 +0000 (15:26 +0000)] 
Add a few more tests to where8.test. (CVS 6081)

FossilOrigin-Name: ac28aa8b618d59628c5b8fc6fe649ec14f554b11

16 years agoStill more test cases in where7.test. (CVS 6080)
drh [Tue, 30 Dec 2008 14:40:06 +0000 (14:40 +0000)] 
Still more test cases in where7.test. (CVS 6080)

FossilOrigin-Name: eb9ba5fe70df56ee00828f7dbaf71ae6f825737d

16 years agoAdd many new test cases to where7.test. (CVS 6079)
drh [Tue, 30 Dec 2008 14:14:03 +0000 (14:14 +0000)] 
Add many new test cases to where7.test. (CVS 6079)

FossilOrigin-Name: 174985831f9c8f5c393556d3248b01852573abc7

16 years agoDo not run savepoint4.test (crash simulation tests) in permutations.test. It slows...
danielk1977 [Tue, 30 Dec 2008 13:21:50 +0000 (13:21 +0000)] 
Do not run savepoint4.test (crash simulation tests) in permutations.test. It slows things down too much. (CVS 6078)

FossilOrigin-Name: 2df02b543edd77282aabff08327c3ab102139a24

16 years agoAdd a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077)
danielk1977 [Tue, 30 Dec 2008 12:00:12 +0000 (12:00 +0000)] 
Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077)

FossilOrigin-Name: 35c87585b81866e73a58adffe6af79ddcac57cf6

16 years agoFix a bug in where.c causing a malfunction when an INDEXED BY clause specified an...
danielk1977 [Tue, 30 Dec 2008 09:45:45 +0000 (09:45 +0000)] 
Fix a bug in where.c causing a malfunction when an INDEXED BY clause specified an unusable index on other than the leftmost table in the FROM clause. Ticket #3560. (CVS 6076)

FossilOrigin-Name: f8ff0212129ce602a1e1e9ad702c47b9302f2f21

16 years agoFix a bug in README.tokenizers. Ticket #3559. (CVS 6075)
danielk1977 [Tue, 30 Dec 2008 06:36:50 +0000 (06:36 +0000)] 
Fix a bug in README.tokenizers. Ticket #3559. (CVS 6075)

FossilOrigin-Name: b8898d132e84888dc7c51b2f1ab67f78cc21f31b

16 years agoInvoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE...
danielk1977 [Tue, 30 Dec 2008 06:24:58 +0000 (06:24 +0000)] 
Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074)

FossilOrigin-Name: e49807b16f7f86d3f2290d6c1f7562f3db6330f9

16 years agoAlways make sure WhereClause objects are initialized to zero when they
drh [Mon, 29 Dec 2008 23:45:07 +0000 (23:45 +0000)] 
Always make sure WhereClause objects are initialized to zero when they
are first allocated. (CVS 6073)

FossilOrigin-Name: 7d0ae55d6b2d263382f034eb89bbc368fab6a9bc

16 years agoAdd test file where8.test. (CVS 6072)
danielk1977 [Mon, 29 Dec 2008 18:33:32 +0000 (18:33 +0000)] 
Add test file where8.test. (CVS 6072)

FossilOrigin-Name: bff460ec2c3e250de034a6b34312b897bb2f3749

16 years agoRemove an old variable declaration that was commented out using a C++ comment. (CVS...
danielk1977 [Mon, 29 Dec 2008 14:51:05 +0000 (14:51 +0000)] 
Remove an old variable declaration that was commented out using a C++ comment. (CVS 6071)

FossilOrigin-Name: 0b972f14f00340cbd4e310dea6d1a4f1c05f5628

16 years agoSet the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070)
danielk1977 [Mon, 29 Dec 2008 10:39:53 +0000 (10:39 +0000)] 
Set the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070)

FossilOrigin-Name: 03d0350441ef5fa5a9f22fcb0b760200614cf9f9

16 years agoMulti-index OR optimizer response to ORDER BY rowid.
drh [Sun, 28 Dec 2008 20:47:02 +0000 (20:47 +0000)] 
Multi-index OR optimizer response to ORDER BY rowid.
But fix in sqlite3_stmt_status(): report a full table scan
when "ORDER BY rowid" is used without constraints. (CVS 6069)

FossilOrigin-Name: 3464d369d3b6899ec726cf5b42b68b1dac2ba982

16 years agoOptimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands
drh [Sun, 28 Dec 2008 18:35:08 +0000 (18:35 +0000)] 
Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands
of an OR. (CVS 6068)

FossilOrigin-Name: 67cf24b30e087796cfb0fccf47328e72ade5ecdc

16 years agoSimplify the VM code that implements WHERE claues. (CVS 6067)
drh [Sun, 28 Dec 2008 16:55:25 +0000 (16:55 +0000)] 
Simplify the VM code that implements WHERE claues. (CVS 6067)

FossilOrigin-Name: fa95f843e179a38f663978d675607c4c3037928d

16 years agoFix a problem with savepoint and incremental-vacuum. (CVS 6066)
danielk1977 [Sat, 27 Dec 2008 15:23:13 +0000 (15:23 +0000)] 
Fix a problem with savepoint and incremental-vacuum. (CVS 6066)

FossilOrigin-Name: 08352f9ea9d2a1759320efc46e418079000855cb

16 years agoReset the column cache before coding each step of a trigger program. Candidate fix...
danielk1977 [Fri, 26 Dec 2008 07:56:39 +0000 (07:56 +0000)] 
Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065)

FossilOrigin-Name: a1b1f6cd7d2c060bd75ce39347e1220b872806ed

16 years agoFix a virtual table related assert() that can fail following a malloc failure. (CVS...
danielk1977 [Wed, 24 Dec 2008 11:25:39 +0000 (11:25 +0000)] 
Fix a virtual table related assert() that can fail following a malloc failure. (CVS 6064)

FossilOrigin-Name: c6fd3b8f29927c0fc634f82885f144c78f0105d9

16 years agoFix a couple of problems in test file test_journal.c that were causing segfaults...
danielk1977 [Wed, 24 Dec 2008 09:30:22 +0000 (09:30 +0000)] 
Fix a couple of problems in test file test_journal.c that were causing segfaults when running all.test. (CVS 6063)

FossilOrigin-Name: 416c9efb49ba207a9a79d06d0b13854695a8876c

16 years agoContinuing improvements to the multi-index OR-clause optimizer. Added a
drh [Tue, 23 Dec 2008 23:56:22 +0000 (23:56 +0000)] 
Continuing improvements to the multi-index OR-clause optimizer.  Added a
few simple test cases. (CVS 6062)

FossilOrigin-Name: 55d4f493e7df8515574a75caec9967d6c71b6012