/ Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants and 100 ancestors of [83d1eafb]

2009-02-02
17:30
Minor simplifications to SQL function implementations. (CVS 6231) check-in: 92e5c27f user: drh tags: trunk
16:32
Update the SUBSTR function so that works consistently when the 2nd parameter is 0. Ticket #3628. (CVS 6230) check-in: 5fc125d3 user: drh tags: trunk
01:50
Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229) check-in: b8b546b6 user: drh tags: trunk
2009-02-01
19:42
Fix SUBSTR() so that it returns NULL if any argument is NULL. Ticket #3626. (CVS 6228) check-in: 779fce82 user: drh tags: trunk
19:23
Fix the SUBSTR() function so that when the 3rd argument is negative, it counts backwards from the selected start point. Ticket #3625. (CVS 6227) check-in: 2217339b user: drh tags: trunk
18:08
Change the replace() function to return a copy of its first argument when the 2nd argument is an empty string. Ticket #3624. (CVS 6226) check-in: ffebf10f user: drh tags: trunk
00:29
Adjust comments in vdbe.c to use OP_MakeRecord instead of the obsolete OP_MakeIdxRec. Ticket #3619. (CVS 6225) check-in: 0d2abbbf user: drh tags: trunk
00:21
Add a new test command, sqlite3_mprintf_long, for testing the behavior of "long integer" printf formatting. Ticket #3621. (CVS 6224) check-in: 3ba1a17b user: drh tags: trunk
00:00
Make the TO keyword available even if SQLITE_OMIT_ALTERTABLE is defined. Ticket #3622. (CVS 6223) check-in: 3890985c user: drh tags: trunk
2009-01-31
22:28
Better error message when coalesce() has too few arguments. Ticket #3623. (CVS 6222) check-in: 9cd43c82 user: drh tags: trunk
14:54
Avoid a segfault when running vacuum on an in-memory database. Ticket #3620. (CVS 6221) check-in: 407830c6 user: danielk1977 tags: trunk
2009-01-30
17:27
Fix a round-off error when moving dates by negative modifier amounts. Ticket #3618. Enhance the "NNN years" modifier to accept fractional years. (CVS 6220) check-in: 86be908c user: drh tags: trunk
16:09
Made code to remove unused parameter warning part of the conditional. Ticket #3610. (CVS 6219) check-in: c5dca114 user: shane tags: trunk
06:11
Changes to setupLookaside() in main.c to better handle lookaside buffer configurations of zero-size. Ticket #3616. (CVS 6218) check-in: 0a2c7f74 user: shane tags: trunk
05:59
Implemented the SQLITE_LAST_ERRNO op in the xFileControl() method of os_win.c. Ticket #3615. (CVS 6217) check-in: 9ea871f3 user: shane tags: trunk
05:47
In test case incrvacuum-15.1 close both db handles (db and db2) before attempting to delete test.db. Ticket #3614. (CVS 6216) check-in: e764a7c5 user: shane tags: trunk
05:40
Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215) check-in: c74c78e4 user: shane tags: trunk
2009-01-29
19:27
Add test cases to make sure that keywords that we say can be used as identifiers really can be used as identifiers. These tests were inspired by ticket #3612, but they do not directly address ticket #3612. (CVS 6214) check-in: 6041ca87 user: drh tags: trunk
02:54
add a cvsignore file (CVS 6213) check-in: 68c8cdd7 user: vapier tags: trunk
2009-01-28
20:21
Fix a segfault that can occur when attempting to insert into a corrupt database file. Need a test case. (CVS 6212) check-in: 68957cf0 user: drh tags: trunk
04:46
regenerate autotools (CVS 6211) check-in: 813a3c96 user: vapier tags: trunk
04:46
unify TCLLIBDIR handling with libtclsqlite3.so and use libtool to install it rather than custom tclinstaller.tcl ... this integrates better with autotools and avoids relinking issues (RPATH pointing to builddir) (CVS 6210) check-in: 3a049ca7 user: vapier tags: trunk
02:55
Add testcase() macros for coverage in date.c. (CVS 6209) check-in: 90b42eba user: drh tags: trunk
2009-01-26
21:43
use AC_MSG_xxx funcs rather than `echo` (CVS 6208) check-in: ed08025a user: vapier tags: trunk
21:39
(#3449) search for tclConfig.sh first by asking tclsh itself where it is (CVS 6207) check-in: ff2912dc user: vapier tags: trunk
21:25
(#1428) installed shared libs with exec perms (CVS 6206) check-in: 3f2a3414 user: vapier tags: trunk
20:59
(#3583) add a rule for sqlite3.pc in case the .in file is updated (CVS 6205) check-in: 4d03b693 user: vapier tags: trunk
2009-01-24
15:23
Remove obsolete files from the tools subfolder. (CVS 6204) check-in: d7456080 user: drh tags: trunk
11:30
Fix some minor compiler warnings. Added sqlite3Isalpha() for use in the soundex() function. (CVS 6203) check-in: bfc71edc user: drh tags: trunk
09:56
Remove incorrect ALWAYS macro associated with empty IN() sets. Ticket #3602. (CVS 6202) check-in: f3c09a0c user: danielk1977 tags: trunk
2009-01-23
16:45
Optimization: When loading a new page into the cache, avoid redundant memset() calls to zero it. (CVS 6201) check-in: 9c0b9f88 user: danielk1977 tags: trunk
2009-01-22
23:04
Fix the VACUUM command so that it does not commit a transaction when it is mistakenly run within a transaction - it should leave the transaction open. (CVS 6200) check-in: 75cc709b user: drh tags: trunk
17:12
Silence a C++ builder warning by writing "if( (rc = function())!=SQLITE_OK )" instead of "if( (rc = function()) )" in two places in pager.c. Ticket #3605. (CVS 6199) check-in: 78ae96de user: danielk1977 tags: trunk
2009-01-21
17:45
Add a comment to fts3_tokenizer.h to make it clear how the xNext() method is supposed to set its output variables. Make sure the output variables of xNext() are only used if SQLITE_OK is returned. Ticket #3604. (CVS 6198) check-in: 5b3c075f user: danielk1977 tags: trunk
2009-01-20
17:06
Big change to make pager.c easier to follow. Unused variables removed, comments improved, etc. (CVS 6197) check-in: 12f7346c user: danielk1977 tags: trunk
16:53
When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) check-in: 1041abd6 user: danielk1977 tags: trunk
2009-01-19
20:49
Make sure the *pzErrMsg return from sqlite3_get_table() is aways zeroed. Ticket #3598. (CVS 6195) check-in: 7035c35d user: drh tags: trunk
18:18
Fix the --enable-tempstore option on the configure script. Ticket #3599 (CVS 6194) check-in: c2eabb99 user: drh tags: trunk
17:40
Make sure mutexes are fully enabled for thread001.test. Take steps to ensure that the thread tests run during regression testing. (CVS 6193) check-in: 6242f113 user: drh tags: trunk
2009-01-17
16:59
Fix a bug that was preventing SQLite from releasing locks properly under obscure circumstances. (CVS 6192) check-in: 502c66df user: danielk1977 tags: trunk
15:53
Back out the Makefile.in changes from check-in (6181) because of reports (ticket #3594) that they do not work on NetBSD. Separately, documentation is updated to make clear that configure and Makefile.in are unsupported. (CVS 6191) check-in: 2d79aaab user: drh tags: trunk
2009-01-16
23:47
Remove a harmless UMR that occurs inside some debugging code. (CVS 6190) check-in: 191c399f user: drh tags: trunk
16:40
Fix a change-counter bug similar to #3584. This one is much more obscure though, requiring a transient IO or malloc error to occur while running in exclusive mode. (CVS 6189) check-in: 9f07d2d9 user: danielk1977 tags: trunk
16:23
Revert (6187). (CVS 6188) check-in: a353c1ab user: danielk1977 tags: trunk
15:21
This commit is an error. Reverted by (6188). (CVS 6187) check-in: aa67fd0c user: danielk1977 tags: trunk
11:04
Allow recently added keywords 'savepoint' and 'release' to be used as database object names. Just as they could be prior to 3.6.8. Ticket #3590. (CVS 6186) check-in: 54ab8326 user: danielk1977 tags: trunk
2009-01-15
17:40
Treat "or" as an ANSI-C keyword, even though it is not. Ticket #3588. (CVS 6185) check-in: ed4e308c user: drh tags: trunk
17:04
Version 3.6.10 (CVS 6184) check-in: 21b720cc user: drh tags: trunk, release, version-3.6.10
15:23
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) check-in: ffdf91fe user: drh tags: trunk
04:30
Avoid using ENOTSUP on systems that do not define that symbol. Ticket #3512. (CVS 6182) check-in: fcb6c677 user: drh tags: trunk
2009-01-14
23:38
Make some changes requested by Fedora. (CVS 6181) check-in: 7bc08bc7 user: drh tags: trunk
23:17
Fix the shell so that the ".schema" command works regardless of the pragma settings. Ticket #3585. (CVS 6180) check-in: 6f6b638e user: drh tags: trunk
23:03
Add asserts to detect if a transaction commits without first incrementing the transaction counter. These asserts are intended to prevent future problems similar to ticket #3584. (CVS 6179) check-in: b676ccfd user: drh tags: trunk
18:59
Fix typos in comments in FTS3 implementation. (CVS 6178) check-in: b0f06663 user: drh tags: trunk
18:59
Increment the version number in preparation for yet another release. (CVS 6177) check-in: dce60ea7 user: drh tags: trunk
17:45
Fix a problem with committing a transaction while there are other active statements. Sometimes, the database change counter was not being updated. (CVS 6176) check-in: b7d2a477 user: danielk1977 tags: trunk
04:09
Version 3.6.9 (CVS 6175) check-in: b6ce8199 user: drh tags: trunk, release
01:10
Here is the test case to prove that ticket #3581 is fixed. (CVS 6174) check-in: f5f5ef64 user: drh tags: trunk
00:55
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) check-in: d28b5820 user: drh tags: trunk
2009-01-13
20:14
Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172) check-in: b5927213 user: drh tags: trunk
16:03
If the journal file is open when unlocking the database, close it just before unlocking the database file instead of just after. This may fix #3572. (CVS 6171) check-in: 36fe9a7a user: danielk1977 tags: trunk
2009-01-12
15:46
Version 3.6.8 (CVS 6170) check-in: 8ca0b7c1 user: drh tags: trunk, release
14:01
Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169) check-in: 5d88f8be user: danielk1977 tags: trunk
2009-01-11
18:24
Sometimes a single byte is written to the main database file. Make sure that journaltest knows this. (CVS 6168) check-in: e0af5a43 user: drh tags: trunk
17:00
Fix an assert() so that it works correctly with SQLITE_TEMP_STORE=3. (CVS 6167) check-in: fd2bbcf8 user: drh tags: trunk
05:54
Fix jrnlmode.test so that it does not run tests involving in-memory journals during the "journaltest" permutation. (CVS 6166) check-in: b47ddefc user: danielk1977 tags: trunk
00:44
The crash8.test depends on auto_vacuum being off. Make sure that is the case. (CVS 6165) check-in: 3538d2a9 user: drh tags: trunk
00:42
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) check-in: 1e79f4f9 user: drh tags: trunk
00:18
Adjust savepoint.test so that it can deal with SQLITE_TEMP_STORE=3. (CVS 6163) check-in: 3cb910f0 user: drh tags: trunk
2009-01-10
18:51
Do not run crash8.test as part of the "journaltest" permutation. crash8.test uses "PRAGMA synchronous=off", which is incompatible with journaltest. (CVS 6162) check-in: 5f184da6 user: danielk1977 tags: trunk
17:57
Remove the unused Pager.alwaysRollback flag. Fix a couple of comments in pager.c. (CVS 6161) check-in: 8f0672af user: danielk1977 tags: trunk
17:02
Remove an faulty assertion inserted a few days ago. (CVS 6160) check-in: 495f017e user: drh tags: trunk
16:15
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) check-in: 64a8dcd8 user: drh tags: trunk
16:15
Improve coverage of pager.c. (CVS 6158) check-in: 855c4093 user: danielk1977 tags: trunk
15:34
Fix a bug caused by overzealous code test coverage simplifications. Bug found by TH3. (CVS 6157) check-in: 3da55787 user: drh tags: trunk
13:24
Remove some unused code from expr.c in order to increase test coverage. (CVS 6156) check-in: 2cbea64f user: drh tags: trunk
11:13
Fix a bug in the previous commit - use SQL comments instead of Tcl comments in SQL blocks. (CVS 6155) check-in: 3d7a8de2 user: danielk1977 tags: trunk
11:10
Add a malloc failure test case that covers a few previously untested lines in pager.c (CVS 6154) check-in: 000aedb0 user: danielk1977 tags: trunk
2009-01-09
21:41
Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) check-in: 64c56226 user: drh tags: trunk
17:11
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) check-in: 0f3f9011 user: danielk1977 tags: trunk
14:29
Fix two problems in test instrumentation that show up on some fulltests. (CVS 6151) check-in: c9179617 user: drh tags: trunk
14:11
Simplifications to btree.c to improve test coverage. (CVS 6150) check-in: ac84f106 user: drh tags: trunk
10:49
Add a couple of coverage tests. (CVS 6149) check-in: 6a64109d user: danielk1977 tags: trunk
02:49
More coverage improvements. (CVS 6148) check-in: 6e171c0a user: drh tags: trunk
01:12
Increased test coverage. (CVS 6147) check-in: 45bb5703 user: drh tags: trunk
2009-01-08
21:00
Increased test coverage in where.c. (CVS 6146) check-in: 1e5725c5 user: drh tags: trunk
18:04
Fix a comment in pager.c. No actual code changes. (CVS 6145) check-in: 44d3bfdd user: danielk1977 tags: trunk
17:57
Avoid an 'invalid cast' warning in test_osinst.c. (CVS 6144) check-in: 931f3a21 user: danielk1977 tags: trunk
17:50
Fix a couple of potential corruption problems in pager.c. (CVS 6143) check-in: 5a39525b user: danielk1977 tags: trunk
15:24
Add a test script for ticket #2565. Change the assert() in pager.c into a testcase() macro. (CVS 6142) check-in: 1e53e382 user: drh tags: trunk
14:36
Allow database files to be created in the root directory on unix. Ticket #3570. (CVS 6141) check-in: 81014334 user: drh tags: trunk
12:05
Clean up test_journal.c to make it easier to follow. (CVS 6140) check-in: 5a28c7c7 user: danielk1977 tags: trunk
03:11
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) check-in: 4b2c08e8 user: drh tags: trunk
2009-01-07
20:58
Add new test cases to increase coverage of where.c. (CVS 6138) check-in: 2e1ab51f user: drh tags: trunk
18:24
Fix a bug in the LIKE query optimization. (Found by coverage testing.) (CVS 6137) check-in: fe90e911 user: drh tags: trunk
18:08
Make the same change as (6121) (accidentally reverted). Also enhance test_journal.c to catch this kind of bug. (CVS 6136) check-in: ccc9c211 user: danielk1977 tags: trunk
17:06
Add a "synchronous = off" variant to savepoint6.test. (CVS 6135) check-in: 0f57011e user: danielk1977 tags: trunk
16:15
Change SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket #3567. (CVS 6134) check-in: 1fe79ffd user: danielk1977 tags: trunk
15:52
For archival purposes, add the TCL script that was used to generate many of the test cases for where7.test. (CVS 6133) check-in: 0e01cdc8 user: drh tags: trunk
15:33
Conjecture: a journal header with nRec==0 must be the last header in the journal. Add asserts to make this conjecture explicit. (CVS 6132) check-in: 15b5b5f9 user: drh tags: trunk
15:18
Fix for 'truncate file' operations on in-memory databases. (CVS 6131) check-in: 83d1eafb user: danielk1977 tags: trunk
10:52
Add a comment to the openSubjournal() function in pager.c. (CVS 6130) check-in: 04387ae1 user: danielk1977 tags: trunk
10:35
Fix a problem with reverting a 'DROP TABLE' command executed inside of a savepoint on an auto-vacuum database. (CVS 6129) check-in: 3a4bb832 user: danielk1977 tags: trunk
08:12
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) check-in: e5d42c69 user: danielk1977 tags: trunk
03:59
Add a HIGHSTRESS parameter to the sqlite3_config_alt_pcache debugging command in the test harness - to force calling pagerStress() more frequently. (CVS 6127) check-in: e426860b user: drh tags: trunk
02:03
Pager changes attempting to verify that ticket #2565 cannot recur. (CVS 6126) check-in: 15b9dac4 user: drh tags: trunk
2009-01-06
18:43
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) check-in: 3c2f292f user: drh tags: trunk
18:21
Reduce the number of paths in btreeCopyFile(). (CVS 6124) check-in: df2c285c user: danielk1977 tags: trunk
17:52
Modify test_journal.c to verify the page data being written to the journal file. (CVS 6123) check-in: 0d258956 user: danielk1977 tags: trunk
15:58
Cleanup of the PAGERTRACE macro. Other comment changes in pager.c. (CVS 6122) check-in: ee7b4b60 user: drh tags: trunk
15:28
The fix in (6120) wasn't quite right. This fixes it. (CVS 6121) check-in: ddc2ebfa user: danielk1977 tags: trunk
15:20
Fix a recently introduced problem in "permutations.test autovacuum_crash". (CVS 6120) check-in: 2cdbb468 user: danielk1977 tags: trunk
14:50
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) check-in: 301b57b7 user: drh tags: trunk
14:34
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) check-in: a64f3db0 user: danielk1977 tags: trunk
14:19
Fix compiler warnings. (CVS 6117) check-in: da770a8d user: drh tags: trunk
13:40
Add some savepoint related test cases and fix a few problems. (CVS 6116) check-in: 8c62ea4f user: danielk1977 tags: trunk
00:11
Remove leftover "breakpoint" from the fuzz.test script. (CVS 6115) check-in: c2482d88 user: drh tags: trunk
00:08
Fix a problem in the WHERE clause generator when the FROM clause is empty. (CVS 6114) check-in: a7015625 user: drh tags: trunk
2009-01-05
22:30
The fix in (6111) was not quite right. This version works better. (CVS 6113) check-in: 5f80140a user: drh tags: trunk
19:36
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) check-in: e02323b3 user: drh tags: trunk
18:02
Make sure the MEM_Zero flags is cleared whenever removing MEM_Blob. (CVS 6111) check-in: b2131e86 user: drh tags: trunk
17:19
Include fuzz3.test in all.test. Get fuzz3.test working again. (CVS 6110) check-in: 77dc19cf user: drh tags: trunk
17:15
Fix some test code problems in "permutations.test journaltest pager.test". (CVS 6109) check-in: cf627752 user: danielk1977 tags: trunk
2009-01-03
15:06
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) check-in: ca7f11d5 user: danielk1977 tags: trunk
14:04
When the commit_hook calls a query recursively, make sure the commit_hook is not invoked recursively. Ticket #3564. (CVS 6107) check-in: 27ae4065 user: drh tags: trunk
12:55
Fix a typo in a comment. (CVS 6106) check-in: 50f57cd1 user: drh tags: trunk
10:41
Add test file savepoint6.test. Contains pseudo random tests of savepoint related commands. (CVS 6105) check-in: 2946fbb7 user: danielk1977 tags: trunk
2009-01-02
21:39
Memory allocation failure in Bitvec are probably all benign. Still, add code to check this, just to be sure. (CVS 6104) check-in: 4688e1c8 user: drh tags: trunk
21:08
Reinitialize page 1 of the database file following a ROLLBACK TO of a transactional SAVEPOINT on an initially empty database. (CVS 6103) check-in: 3e9efb76 user: drh tags: trunk
18:10
Fix compiler warnings in pager.c (CVS 6102) check-in: 78dd7909 user: drh tags: trunk
17:33
Modify the (transaction) method of the tcl interface to use savepoints. This makes nested calls to (transaction) work more intuitively. (CVS 6101) check-in: f047758d user: danielk1977 tags: trunk
15:47
Add fts_expr.* files to Makefile.in. (CVS 6100) check-in: 524c8634 user: shane tags: trunk
15:45
Many of the boundary tests depend on a working 64-bit implementation of TCL, so skip them if this is not available. (CVS 6099) check-in: b1a4a17f user: shane tags: trunk
12:35
Increment the version number to 3.6.8. (CVS 6098) check-in: 7509641a user: drh tags: trunk
01:10
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) check-in: d44c84c0 user: drh tags: trunk
2009-01-01
15:20
Fix a (benign) valgrind error that can occur following malloc failure while executing a 'ROLLBACK TO savepoint' command. (CVS 6096) check-in: 9ff8598f user: danielk1977 tags: trunk
14:06
Fix some problems in the fts3 expression parser with mismatched parenthesis. (CVS 6095) check-in: ccfe4580 user: danielk1977 tags: trunk
12:34
Additional test cases and cleanup of FTS3 parenthesis processing. (CVS 6094) check-in: afac4293 user: drh tags: trunk
07:42
Add a couple of extra tests for the fts3 expression parser to improve mcdc coverage. (CVS 6093) check-in: 13146b34 user: danielk1977 tags: trunk
07:08
Add pseudo-random tests of the fts3 expression parser. Revise the fix in (6091). (CVS 6092) check-in: 11c2d468 user: danielk1977 tags: trunk
04:19
Fix a bug parsing "<expr> AND (abc NEAR def)" in fts3_expr.c. (CVS 6091) check-in: d1a6a2ed user: danielk1977 tags: trunk
2008-12-31
21:52
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) check-in: 73958060 user: drh tags: trunk
19:27
Fix the name in the documentation of the compile-time macro for enabling FTS3 parenthesis processing. (CVS 6089) check-in: ac8258da user: drh tags: trunk
16:27
Fix the FTS3 expression parser so that it works in the amalgamation when FTS3 is disabled. (CVS 6088) check-in: 7e238e86 user: drh tags: trunk
16:01
Fix the FTS3 module with parenthesis syntax so that it will work in the amalgamation. (CVS 6087) check-in: c2b9891f user: drh tags: trunk
2008-12-30
17:55
Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) check-in: b090d573 user: drh tags: trunk
16:35
Add LEFT JOIN test cases for multi-index OR in where9.test. (CVS 6085) check-in: 96f3b629 user: drh tags: trunk
16:18
Get EXPLAIN QUERY PLAN working with the multi-index OR optimization. Added new test script "where9.test". (CVS 6084) check-in: 4b646022 user: drh tags: trunk
16:13
Add further pseudo-randomly generated test cases to where8.test. (CVS 6083) check-in: e01f6ef9 user: danielk1977 tags: trunk
15:51
Fix a bug in where8.test causing a tcl exception. (CVS 6082) check-in: 495b569a user: danielk1977 tags: trunk
15:26
Add a few more tests to where8.test. (CVS 6081) check-in: ac28aa8b user: danielk1977 tags: trunk
14:40
Still more test cases in where7.test. (CVS 6080) check-in: eb9ba5fe user: drh tags: trunk
14:14
Add many new test cases to where7.test. (CVS 6079) check-in: 17498583 user: drh tags: trunk
13:21
Do not run savepoint4.test (crash simulation tests) in permutations.test. It slows things down too much. (CVS 6078) check-in: 2df02b54 user: danielk1977 tags: trunk
12:00
Add a couple of extra tests for the "WHERE ... OR" optimization. (CVS 6077) check-in: 35c87585 user: danielk1977 tags: trunk
09:45
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) check-in: f8ff0212 user: danielk1977 tags: trunk
06:36
Fix a bug in README.tokenizers. Ticket #3559. (CVS 6075) check-in: b8898d13 user: danielk1977 tags: trunk
06:24
Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074) check-in: e49807b1 user: danielk1977 tags: trunk
2008-12-29
23:45
Always make sure WhereClause objects are initialized to zero when they are first allocated. (CVS 6073) check-in: 7d0ae55d user: drh tags: trunk
18:33
Add test file where8.test. (CVS 6072) check-in: bff460ec user: danielk1977 tags: trunk
14:51
Remove an old variable declaration that was commented out using a C++ comment. (CVS 6071) check-in: 0b972f14 user: danielk1977 tags: trunk
10:39
Set the OPFLG_IN1 flag on a couple of extra opcodes. (CVS 6070) check-in: 03d03504 user: danielk1977 tags: trunk
2008-12-28
20:47
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) check-in: 3464d369 user: drh tags: trunk
18:35
Optimize WHERE clauses that constain AND, BETWEEN, and LIKE terms as operands of an OR. (CVS 6068) check-in: 67cf24b3 user: drh tags: trunk
16:55
Simplify the VM code that implements WHERE claues. (CVS 6067) check-in: fa95f843 user: drh tags: trunk
2008-12-27
15:23
Fix a problem with savepoint and incremental-vacuum. (CVS 6066) check-in: 08352f9e user: danielk1977 tags: trunk
2008-12-26
07:56
Reset the column cache before coding each step of a trigger program. Candidate fix for #3554. (CVS 6065) check-in: a1b1f6cd user: danielk1977 tags: trunk
2008-12-24
11:25
Fix a virtual table related assert() that can fail following a malloc failure. (CVS 6064) check-in: c6fd3b8f user: danielk1977 tags: trunk
09:30
Fix a couple of problems in test file test_journal.c that were causing segfaults when running all.test. (CVS 6063) check-in: 416c9efb user: danielk1977 tags: trunk
2008-12-23
23:56
Continuing improvements to the multi-index OR-clause optimizer. Added a few simple test cases. (CVS 6062) check-in: 55d4f493 user: drh tags: trunk
19:15
Fix a problem with the savepoint code and in-memory journals. (CVS 6061) check-in: 26ceebf3 user: danielk1977 tags: trunk
16:23
Fix an OOM problem in where.c. (CVS 6060) check-in: d2105f61 user: drh tags: trunk
15:58
Make sure nOverflow is always cleared when a page is released. (CVS 6059) check-in: 8d0f7244 user: drh tags: trunk
13:35
Multi-index OR-clause optimization now works for simple tests. There are no test scripts for it yet, though. And it is disabled by default, pending further testing and optimization. We need a lot of both. (CVS 6058) check-in: d77a7023 user: drh tags: trunk
11:46
Add a test to savepoint.test that tests that nothing goes wrong if an incremental vacuum occurs inside a savepoint. (CVS 6057) check-in: fc4f0621 user: danielk1977 tags: trunk
11:11
In sqlite3AddColumn(), use local variable 'db' instead of 'pParse->db'. (CVS 6056) check-in: 0c53a4c2 user: danielk1977 tags: trunk
10:37
Fix a couple of assert() failures that can occur in btree.c and pager.c. (CVS 6055) check-in: ae44e748 user: danielk1977 tags: trunk
2008-12-22
15:04
Fix a reference counting bug in rtree. Ticket #3549. (CVS 6054) check-in: bbdc0e9f user: danielk1977 tags: trunk
11:43
Changes to test scripts so that veryquick.test runs with SQLITE_TEMP_STORE=3 defined. Also a fix to stop the same switch causing a crash in the savepoint code. (CVS 6053) check-in: ee0e6eae user: danielk1977 tags: trunk
10:58
Add a case to permutations.test to run tests with the test_journal.c backend installed. Also many fixes to test_journal.c and one quite obscure fix to pager.c. (CVS 6052) check-in: bb177e30 user: danielk1977 tags: trunk
03:37
Fix a variable type to prevent a warning in the proxy-locking code. (CVS 6051) check-in: d9595b96 user: danielk1977 tags: trunk
2008-12-21
03:51
Continue refactoring where.c in preparation for installing OR-clause optimizations. (CVS 6050) check-in: 778e91dd user: drh tags: trunk
2008-12-20
18:33
Add a vfs backend that detects problems like the one addressed by (6043) and (6047). (CVS 6049) check-in: 49172e48 user: danielk1977 tags: trunk
13:18
Do not use long long constants in code. Ticket #3547. (CVS 6048) check-in: 51b3bfc3 user: drh tags: trunk
08:39
Fix the crash-followed-by-corruption bug revealed by savepoint4.test. This is actually the same bug as was fixed by (6043). The fix was not entirely correct. (CVS 6047) check-in: 68833626 user: danielk1977 tags: trunk
02:14
Specify type "void" in the parameter list of functions that take no parameters. Tickets #3545 and #3546. (CVS 6046) check-in: c2228bd1 user: drh tags: trunk
02:06
Enhanced analysis of OR terms in a WHERE clause. Another step toward being able to use indices with OR-connected WHERE clause terms. (CVS 6045) check-in: c3f7aa01 user: drh tags: trunk
2008-12-19
18:45
Add extra crash test cases that stress the savepoint mechanism to savepoint4.test. Currently, these tests are causing database corruption which (obviously) needs to be fixed. (CVS 6044) check-in: e06a968a user: danielk1977 tags: trunk
16:31
Add some crash-tests for savepoint. Fix a bug revealed by these tests. (CVS 6043) check-in: 6f36c166 user: danielk1977 tags: trunk
11:37
Add the file ext/fts3/README.syntax, containing documentation describing the two query syntaxes now supported by fts3. (CVS 6042) check-in: ed81ad5a user: danielk1977 tags: trunk
2008-12-18
22:25
Fix the Oracle and MS-Sql command-line terminator logic in the CLI. Ticket #3544. (CVS 6041) check-in: dcc8935f user: drh tags: trunk
18:31
Increase test coverage of new savepoint code. (CVS 6040) check-in: d915718d user: danielk1977 tags: trunk
15:45
Add savepoint2.test, a file containing savepoint tests similar to tests in trans.test and avtrans.test. And a few savepoint bug fixes. (CVS 6039) check-in: 98a53d91 user: danielk1977 tags: trunk
05:30
Fix a bug in icuOpen() in fts2. (CVS 6038) check-in: b9c722bd user: danielk1977 tags: trunk
2008-12-17
19:22
Update the WHERE clause processing infrastructure in preparation for adding multi-index OR evaluation. (CVS 6037) check-in: 78401b33 user: drh tags: trunk
17:30
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) check-in: 34b56600 user: danielk1977 tags: trunk
15:49
Fix some strict-aliasing problems in fts3_expr.c. (CVS 6035) check-in: 20a4ca5d user: danielk1977 tags: trunk
15:18
Modify fts3 to support a more complex expression syntax that allows parenthesis. The new syntax is not entirely backwards compatible, so is disabled by default. Use -DSQLITE_ENABLE_FTS3_PARENTHESIS to enable it. (CVS 6034) check-in: 7389b9ec user: danielk1977 tags: trunk
2008-12-16
18:15
Version 3.6.7 (CVS 6033) check-in: f4f40370 user: drh tags: trunk, release
17:20
Fix a compile error in an assert() and a warning with MSVC builds. (CVS 6032) check-in: 8b8f6a6a user: shane tags: trunk
13:46
Make sure the memory returned from sqlite3ScratchMalloc() is 8-byte aligned. Ticket #3542. (CVS 6031) check-in: 13b56b7f user: drh tags: trunk