Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
72 check-ins using file src/prepare.c version c2b31803
2012-08-25
| ||
00:49 | Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. (Leaf check-in: 865dfcba user: drh tags: branch-3.7.2) | |
2011-10-25
| ||
21:18 | Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil (check-in: 89d63a0e user: drh tags: branch-3.7.2) | |
20:36 | Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT (check-in: 14bc58ca user: drh tags: branch-3.7.2) | |
2011-08-26
| ||
18:28 | Veryquick and min.rc tests now passing. (Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2) | |
18:04 | Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: a42db19d user: drh tags: stat3-3.7.2) | |
17:17 | Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. (check-in: 41b5f869 user: drh tags: branch-3.7.2) | |
15:51 | Get stat3 working after import from trunk-based the stat3-enhancement branch. There is still a problem in the wal2 test. (check-in: 01cc4ff6 user: drh tags: stat3-3.7.2) | |
13:52 | Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: 0df04f92 user: drh tags: stat3-3.7.2) | |
2011-07-13
| ||
18:53 | Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the index is unique or nearly so. (check-in: d55b64ef user: drh tags: branch-3.7.2) | |
2011-07-12
| ||
14:48 | Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. (check-in: 7afb2354 user: dan tags: branch-3.7.2) | |
2011-07-02
| ||
15:42 | Cherrypick change [27c65d4d9c] into the 3.7.2 branch. (check-in: 9bbcd8c0 user: dan tags: branch-3.7.2) | |
13:34 | Cherrypick [45e581bff7] into the 3.7.2 branch. (check-in: c593792c user: dan tags: branch-3.7.2) | |
2011-05-01
| ||
22:57 | Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. (check-in: 7155e6f3 user: drh tags: branch-3.7.2) | |
2011-04-15
| ||
15:18 | Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. (check-in: 8d924e16 user: drh tags: branch-3.7.2) | |
2011-04-09
| ||
03:30 | Back port the unordered-index-hack to the 3.7.2 branch. (check-in: 80353020 user: drh tags: branch-3.7.2) | |
2011-04-08
| ||
23:36 | Backport test cases from trunk that seek to prove that the IS NOT NULL query optimization is working. (check-in: 9eff4702 user: drh tags: branch-3.7.2) | |
23:05 | Make sure the query planner is able to correctly analyze NULL value samples in the sqlite_stat2 table. This is a backport of changes from check-in [f73a167b434f] (check-in: 1d637889 user: drh tags: branch-3.7.2) | |
23:04 | Make sure the left-hand side of the IS NOT NULL operator is a simple column and not a general expression before applying the IS NOT NULL optimization. This is a backport of check-in [543f75a6abe3]. (check-in: e8177e01 user: drh tags: branch-3.7.2) | |
2011-03-31
| ||
18:36 | Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. (check-in: a5aae174 user: drh tags: branch-3.7.2) | |
2011-03-17
| ||
01:53 | Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. (check-in: 68daf20d user: drh tags: branch-3.7.2) | |
2011-03-12
| ||
05:55 | Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from check-in [b86999436e] on the trunk. (check-in: 668b91db user: shaneh tags: branch-3.7.2) | |
2011-03-09
| ||
22:09 | Backport the OP_Next and OP_Prev for UNIQUE indices patch from checkin [f000c9b2b7] on the trunk. (check-in: 2d55234e user: drh tags: branch-3.7.2) | |
2011-03-04
| ||
01:23 | Backport the query planner enhancement of [952f5e8c69904] to the 3.7.2 branch. (check-in: 440d9956 user: drh tags: branch-3.7.2) | |
2011-02-12
| ||
14:23 | Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. (check-in: f2a8b5cc user: drh tags: branch-3.7.2) | |
05:34 | Fix problems in the backport, reducing the number of errors in the TCL tests to just a few dozen. Most of the remaining errors seem to be real and desirable changes of behavior. (check-in: 9d2b0af2 user: drh tags: branch-3.7.2) | |
2010-11-25
| ||
17:49 | Add coverage tests (and associated fixes) for new matchinfo() code. (check-in: 70495cec user: dan tags: fts3-experimental) | |
10:33 | Fix bugs in fts3 function matchinfo() when used with deferred tokens. (check-in: ddc2b7ec user: dan tags: fts3-experimental) | |
2010-11-24
| ||
19:26 | Add code for the matchinfo 'longest common substring' feature. (check-in: 71011a4f user: dan tags: fts3-experimental) | |
15:02 | Fix crashes that can occur when queries are run on an FTS4 table containing zero rows. (check-in: ed61fd20 user: dan tags: fts3-experimental) | |
11:51 | Remove some unused code from fts3. Add tests to fts3matchinfo.test. (check-in: ae40b34c user: dan tags: fts3-experimental) | |
2010-11-23
| ||
19:16 | Experimental changes to fts3 function matchinfo(). (check-in: 9cf0f2b7 user: dan tags: fts3-experimental) | |
2010-11-22
| ||
17:26 | Fix a typo in unixCurrentTimeInt64() preventing compilation with NO_GETTOD defined. (check-in: 3df3e79b user: dan tags: trunk) | |
2010-11-20
| ||
12:01 | Extra tests for "PRAGMA checkpoint_fullfsync". (check-in: e38c81cc user: dan tags: trunk) | |
10:57 | Add extra tests for test_superlock.c. (check-in: 1c4e58e7 user: dan tags: trunk) | |
2010-11-19
| ||
18:51 | Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. (Closed-Leaf check-in: ebf74015 user: drh tags: blocking-checkpoint) | |
18:48 | Add tests for "PRAGMA checkpoint_fullfsync". (check-in: 765aa1b8 user: dan tags: trunk) | |
18:36 | Merge in the superlock demonstration changes. (check-in: 570e79a8 user: drh tags: trunk) | |
18:23 | Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. (check-in: a0698673 user: drh tags: trunk) | |
18:20 | Add file test_superlock.c with example code for obtaining an exclusive lock on either rollback or wal mode databases. (Closed-Leaf check-in: 1a3e7417 user: dan tags: superlock) | |
14:37 | Add the SQLITE_FCNTL_FILE_POINTER verb to sqlite3_file_control(). (check-in: 4425b064 user: drh tags: superlock) | |
09:58 | Add file test/tt3_checkpoint.c that adds a multi-threaded test for blocking checkpoints to threadtest3. (check-in: 648dd157 user: dan tags: blocking-checkpoint) | |
07:17 | Add extra test cases for blocking checkpoints. (check-in: ac348ae2 user: dan tags: blocking-checkpoint) | |
2010-11-18
| ||
19:28 | Fixes for SQLITE_BUSY handling in blocking checkpoint code. (check-in: 4c663a4d user: dan tags: blocking-checkpoint) | |
16:59 | Merge with latest trunk fix. (check-in: a8910e89 user: dan tags: blocking-checkpoint) | |
16:58 | Ensure tcl is using utf-8 as the system encoding when running capi3e.test. (check-in: 0a95589f user: dan tags: trunk) | |
16:32 | Merge with latest trunk changes. (check-in: e376480f user: dan tags: blocking-checkpoint) | |
16:14 | Update test cases to account for the change in the previous commit. (check-in: ae089ec8 user: dan tags: blocking-checkpoint) | |
15:44 | Added some tests to check that umlaut characters are supported in filenames. (check-in: c36f275d user: shaneh tags: trunk) | |
13:52 | Restrict the scope of the fts3ExprCost() subroutine inside of FTS3. (check-in: 76681870 user: drh tags: trunk) | |
13:47 | Fix compiler warnings. (check-in: 6c4f1d5c user: drh tags: trunk) | |
12:31 | Prevent a possible segfault when the sqlite3_value_numeric_type() interface is misused to try to determine the numeric type of the NULL value returned from sqlite3_column_value() with an invalid column number. (check-in: 501b743b user: drh tags: trunk) | |
12:11 | Modify the interface to the blocking wal-checkpoint functionality. (check-in: 72787c01 user: dan tags: blocking-checkpoint) | |
2010-11-17
| ||
02:02 | Restrict the scope of the sqlite3_stmt_readonly() interface to a specific subset of prepared statement types. (check-in: 919b06c3 user: drh tags: trunk) | |
2010-11-16
| ||
23:10 | Adding the sqlite3_stmt_readonly() interface. (check-in: fd5b2f23 user: drh tags: trunk) | |
18:56 | Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. (check-in: 7e3fc2c8 user: dan tags: blocking-checkpoint) | |
02:49 | Use the estimated number of rows computed for subqueries in the cost computations for outer queries. (check-in: 56bbc539 user: drh tags: trunk) | |
2010-11-15
| ||
21:50 | Change the EQP output for the min/max optimization from "SCAN" to "SEARCH". Other changes in where.c in support of full branch coverage testing. (check-in: d52b5939 user: drh tags: trunk) | |
16:29 | Fix the EQP logic so that it correctly reports OOM errors while formatting "detail" text. (check-in: 136c2ac2 user: drh tags: trunk) | |
16:12 | Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: 88a854e1 user: dan tags: trunk) | |
14:51 | Test some example code from documentation page eqp.html. (check-in: 547bc2c2 user: dan tags: trunk) | |
14:44 | Merge the EXPLAIN QUERY PLAN changes from experimental into trunk. (check-in: ce27bf38 user: drh tags: trunk) | |
2010-11-13
| ||
16:42 | Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (Closed-Leaf check-in: 6611b76b user: dan tags: experimental) | |
2010-11-12
| ||
17:41 | Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. (check-in: 85fdad85 user: dan tags: experimental) | |
15:36 | Reduce the number of branches that need to be tested in the explainIndexRange() function of where.c. (check-in: 6fdae9a6 user: drh tags: experimental) | |
2010-11-11
| ||
17:48 | Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. (check-in: 28643b85 user: dan tags: experimental) | |
16:46 | Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. (check-in: 00fb8468 user: dan tags: experimental) | |
11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: 7ae06895 user: dan tags: experimental) | |
10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: 30904ef8 user: dan tags: experimental) | |
2010-11-09
| ||
17:49 | Merge with latest trunk changes. (check-in: 4b5c93bc user: dan tags: experimental) | |
17:35 | Add missing comments and fix other issues with routines used by new EQP features. (check-in: 925f35c5 user: dan tags: experimental) | |
14:49 | Further enhancements and fixes for explain query plan. (check-in: 73c93f5a user: dan tags: experimental) | |
2010-11-08
| ||
19:01 | Experimental changes to EXPLAIN QUERY PLAN. (check-in: f4747eb8 user: dan tags: experimental) | |