mirrors/sqlite
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
6,103 Commits 1,487 Branches 166 Tags
Commit Graph

2405 Commits

Author SHA1 Message Date
drh
ef731a7b84 Disable test case select2-2.0.3. This was a timing test that sometimes 
fails due to CPU contention with other processes on the same host. (CVS 6183)

FossilOrigin-Name: ffdf91fec93aed35cf3dde1edbe9d7f8a5d23ae8
 2009-01-15 15:23:59 +00:00
danielk1977
104f1fef2d Fix a problem with committing a transaction while there are other active statements. Sometimes, the database change counter was not being updated. (CVS 6176) 
FossilOrigin-Name: b7d2a477aa2c3dbbb81d18fba1faa6835711b5c3
 2009-01-14 17:45:57 +00:00
drh
94eb90c78b Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) 
FossilOrigin-Name: f5f5ef646bef6de6a744b565e089219d4e47397d
 2009-01-14 01:10:40 +00:00
drh
a7e770612b Make sure the OR-clause optimizer takes the cost of sorting into account. 
Reset the rowid cache on the OP_Rewind and OP_Last opcodes.  Bump the
version number so that we can do an emergency release.  Ticket #3581. (CVS 6173)

FossilOrigin-Name: d28b58209bf5eb575d0cad8dc71ac043395c6471
 2009-01-14 00:55:09 +00:00
danielk1977
838cce4382 Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169) 
FossilOrigin-Name: 5d88f8be7342acd2a7ed6f269bec615cd03e59e2
 2009-01-12 14:01:45 +00:00
danielk1977
c499bf1dc0 Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166) 
FossilOrigin-Name: b47ddefc772ee59aa1509ab8d8f229a3d7c4ddaf
 2009-01-11 05:54:40 +00:00
drh
487b51e65c The crash8.test depends on auto_vacuum being off. Make sure that is the 
case. (CVS 6165)

FossilOrigin-Name: 3538d2a981c5abfe2f88aec75175ae33475e6bcb
 2009-01-11 00:44:47 +00:00
drh
8a5268739e In io.test, reset the connection after manually deleting the journal file, 
so that the connection does not continue to use the old deleted journal file. (CVS 6164)

FossilOrigin-Name: 1e79f4f9e59469fb9e3e0007163de3e604dcf00f
 2009-01-11 00:42:02 +00:00
drh
f57cf606bc Adjust savepoint.test so that it can deal with SQLITE_TEMP_STORE=3. (CVS 6163) 
FossilOrigin-Name: 3cb910f0ce116af3f291cb913b32abc89493bcc5
 2009-01-11 00:18:38 +00:00
danielk1977
9393497826 Do not run crash8.test as part of the "journaltest" permutation. crash8.test uses "PRAGMA synchronous=off", which is incompatible with journaltest. (CVS 6162) 
FossilOrigin-Name: 5f184da6758327e0d5fefe61ac3be06a79cc8269
 2009-01-10 18:51:40 +00:00
danielk1977
7cbd589da0 Improve coverage of pager.c. (CVS 6158) 
FossilOrigin-Name: 855c4093cf331496d9ef508011ad814e91e3882f
 2009-01-10 16:15:09 +00:00
danielk1977
c87239fb32 Fix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL blocks. (CVS 6155) 
FossilOrigin-Name: 3d7a8de248ad5fba0e9c88f439cd2d988dcbab8c
 2009-01-10 11:13:39 +00:00
danielk1977
9585528844 Add a malloc failure test case that covers a few previously untested lines in pager.c (CVS 6154) 
FossilOrigin-Name: 000aedb0471b5f5a69e7b61f5e1d4b2644994f32
 2009-01-10 11:10:18 +00:00
drh
d2cb50b74c Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, 
which is available by default on Leopard. (CVS 6153)

FossilOrigin-Name: 64c56226b91e57883c8059f65330318e53376b8a
 2009-01-09 21:41:17 +00:00
danielk1977
0371f1b243 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
 2009-01-09 17:11:04 +00:00
drh
5807c4ccc5 Fix two problems in test instrumentation that show up on some fulltests. (CVS 6151) 
FossilOrigin-Name: c917961743e9ab60a096801c8910c6cd8367ee2f
 2009-01-09 14:29:35 +00:00
danielk1977
03ba3fa02c Add a couple of coverage tests. (CVS 6149) 
FossilOrigin-Name: 6a64109d1f9b63ac8b29ea2c77da02506387b4a1
 2009-01-09 10:49:14 +00:00
drh
1c767f0df3 More coverage improvements. (CVS 6148) 
FossilOrigin-Name: 6e171c0a64850013b26a223189d5bebcc0a01a8b
 2009-01-09 02:49:31 +00:00
drh
e2f02bacc1 Increased test coverage. (CVS 6147) 
FossilOrigin-Name: 45bb5703d7ef5e835b43a6fa7ee2a2d96db76939
 2009-01-09 01:12:27 +00:00
drh
103bd88cf7 Increased test coverage in where.c. (CVS 6146) 
FossilOrigin-Name: 1e5725c5179660277c2e8c321877d7ee3ca21808
 2009-01-08 21:00:02 +00:00
danielk1977
112f752be8 Fix a couple of potential corruption problems in pager.c. (CVS 6143) 
FossilOrigin-Name: 5a39525ba3e65f1c6df3cf23fbfb57f6a0bf4b62
 2009-01-08 17:50:45 +00:00
drh
4fd18c4b31 Add a test script for ticket #2565. Change the assert() in pager.c into 
a testcase() macro. (CVS 6142)

FossilOrigin-Name: 1e53e382e5030de4d908098bf77af053dd81f0c5
 2009-01-08 15:24:01 +00:00
drh
171256c45c 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
 2009-01-08 03:11:19 +00:00
drh
7c2fbdeba2 Add new test cases to increase coverage of where.c. (CVS 6138) 
FossilOrigin-Name: 2e1ab51f05447f9c1f291636b53b1ec584003841
 2009-01-07 20:58:57 +00:00
drh
5bd98aef66 Fix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137) 
FossilOrigin-Name: fe90e9116b6e1e25cf3119d2777a8e9c135153ce
 2009-01-07 18:24:03 +00:00
danielk1977
be87104706 Add a "synchronous = off" variant to savepoint6.test. (CVS 6135) 
FossilOrigin-Name: 0f57011e3b21fa5f6a819ce5a7fd8d44ea70679f
 2009-01-07 17:06:52 +00:00
drh
f3c57015d8 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
 2009-01-07 15:52:54 +00:00
drh
ee03d629f5 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
 2009-01-07 15:33:45 +00:00
danielk1977
f90b7260b3 Fix for 'truncate file' operations on in-memory databases. (CVS 6131) 
FossilOrigin-Name: 83d1eafbde556f56969c6f285b6767d2c658dbfc
 2009-01-07 15:18:20 +00:00
danielk1977
1fab7b6664 Fix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint on an auto-vacuum database. (CVS 6129) 
FossilOrigin-Name: 3a4bb83235e9a79297e7d5d47ac7674c9df960bf
 2009-01-07 10:35:18 +00:00
danielk1977
fc158bf920 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
 2009-01-07 08:12:16 +00:00
drh
5093f6e5ee 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
 2009-01-06 18:43:51 +00:00
drh
04df18dce8 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
 2009-01-06 14:50:11 +00:00
danielk1977
f2c31ad8af Add some savepoint related test cases and fix a few problems. (CVS 6116) 
FossilOrigin-Name: 8c62ea4fded2251e9daf16f2a050f94359299d76
 2009-01-06 13:40:08 +00:00
drh
a6dbbacbcb Remove leftover "breakpoint" from the fuzz.test script. (CVS 6115) 
FossilOrigin-Name: c2482d8877a5f9e387b288377e410ae1b8267f3c
 2009-01-06 00:11:25 +00:00
drh
813f31eafe Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114) 
FossilOrigin-Name: a7015625610624be1645e918d0a62cf85bec86ce
 2009-01-06 00:08:02 +00:00
drh
de58ddb709 The fix in (6111) was not quite right. This version works better. (CVS 6113) 
FossilOrigin-Name: 5f80140a2df48fd43a7cbc0990de0205004541b0
 2009-01-05 22:30:38 +00:00
drh
66cd1822fe 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
 2009-01-05 19:36:30 +00:00
drh
8f51eb8fa0 Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) 
FossilOrigin-Name: 77dc19cfabca54353509ff346b12975044d416d5
 2009-01-05 17:19:03 +00:00
danielk1977
0d519ca883 Fix some test code problems in "permutations.test journaltest pager.test". (CVS 6109) 
FossilOrigin-Name: cf627752c4537f709acae26a1e335731d55bddb2
 2009-01-05 17:15:00 +00:00
danielk1977
7e445fbf33 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
 2009-01-03 15:06:38 +00:00
drh
853799a26e When the commit_hook calls a query recursively, make sure the commit_hook 
is not invoked recursively.  Ticket #3564. (CVS 6107)

FossilOrigin-Name: 27ae406537c07073db46ecde40c65c78fbb73170
 2009-01-03 14:04:38 +00:00
danielk1977
e7e6f12aaa Add test file savepoint6.test. Contains pseudo random tests of savepoint related commands. (CVS 6105) 
FossilOrigin-Name: 2946fbb7183d597b4db1db203eb5fd57c9762dc4
 2009-01-03 10:41:29 +00:00
drh
9f0bbf9cae 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
 2009-01-02 21:08:09 +00:00
danielk1977
cd38d520d1 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
 2009-01-02 17:33:46 +00:00
shane
d3fc21d1fd 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
 2009-01-02 15:45:47 +00:00
danielk1977
c81806f3ed Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096) 
FossilOrigin-Name: 9ff8598f3be123a244f71b45e77af913b836504a
 2009-01-01 15:20:37 +00:00
danielk1977
fc8c9f84ab Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095) 
FossilOrigin-Name: ccfe4580ac7ba9add0e69c786a9a3a43d69b7753
 2009-01-01 14:06:13 +00:00
drh
b39187ae89 Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094) 
FossilOrigin-Name: afac4293000f81410d105a99956605bf7102fa62
 2009-01-01 12:34:45 +00:00
danielk1977
758bc07c43 Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093) 
FossilOrigin-Name: 13146b34935d339d7b8379083e024647af07e2c1
 2009-01-01 07:42:49 +00:00