Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/index6.test
|
2019-09-03
| ||
| 14:27 | When we play games with COLLATE in order to commute an operator in the WHERE clause processing, be sure not to use the commuted operator to qualify a partial index, as insufficient COLLATE information is preserved to verify that the expression will correctly qualify the index. Ticket [767a8cbc6d20bd68] file: [4d1dd3ca] check-in: [5351e920] user: drh branch: trunk, size: 13197 | |
|
2019-08-30
| ||
| 16:00 | The expression "(X IS FALSE) IN (FALSE)" does not imply that X is NOT NULL. Ticket [f8f472cbc77ba9c9] file: [bae04b45] check-in: [dd661348] user: drh branch: trunk, size: 12774 | |
| 15:11 | The expression "(X IS FALSE) BETWEEN FALSE AND TRUE" does not implie that X is not NULL. Ticket [fba33c8b1df6a915] file: [5b016266] check-in: [057fb8b1] user: drh branch: trunk, size: 12635 | |
| 13:07 | The expression "(x IS FALSE) IS FALSE" does not imply that X is not NULL. Ticket [a6408d42b9f44462] file: [4286a391] check-in: [45ff2b1f] user: drh branch: trunk, size: 12271 | |
|
2019-08-08
| ||
| 15:24 | Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [7883c357] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 11987 | |
|
2019-05-11
| ||
| 16:14 | When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". file: [a6cf96bb] check-in: [1b243032] user: dan branch: trunk, size: 11995 | |
| 13:04 | Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. file: [f9359034] check-in: [0ba6d709] user: dan branch: trunk, size: 11894 | |
|
2019-05-04
| ||
| 17:32 | Fix the NOT NULL logic in the theorem prover that determines when a partial index can be used. Ticket [5c6955204c392ae763a95]. file: [448fa05f] check-in: [c2e439bc] user: drh branch: trunk, size: 11584 | |
|
2018-12-09
| ||
| 18:55 | New test case for ticket [1d958d90596593a77420e59]. file: [6b3e6cd4] check-in: [b7bf3c98] user: drh branch: trunk, size: 11269 | |
|
2018-12-08
| ||
| 20:30 | Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. file: [7cb66c4e] check-in: [15bc915d] user: drh branch: trunk, size: 11170 | |
|
2018-05-02
| ||
| 18:00 | Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. file: [d07ea75b] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 10635 | |
|
2016-10-03
| ||
| 18:13 | Allow deterministic functions in the WHERE clause of a partial index. file: [b4fc8122] check-in: [c6e9b942] user: drh branch: trunk, size: 10633 | |
|
2016-06-08
| ||
| 18:07 | Prefer to use partial indexes for full table scans when that is possible. file: [43b4e292] check-in: [fe187432] user: drh branch: trunk, size: 10606 | |
|
2015-08-07
| ||
| 20:57 | Enhance the query planner so that it is able to use partial indexes that use AND-connected terms in the WHERE clause. file: [7102ec37] check-in: [06576590] user: drh branch: trunk, size: 10243 | |
|
2015-06-11
| ||
| 13:58 | When generating code for partial indexes, be sure not to modify the index condition expression in the schema. file: [fbf45ceb] check-in: [e63d01c6] user: drh branch: trunk, size: 9281 | |
|
2015-02-24
| ||
| 20:10 | Prevent partial indexes on the table on the left hand side of a LEFT JOIN from being incorrectly qualified by a constraint in the ON clause of the join. This relaxes the rule introduced by the previous commit (as the partial indexes on the table on the rhs of the LEFT JOIN may now be qualified by terms within the ON clause). file: [3ae54e53] check-in: [1d6fb43a] user: dan branch: trunk, size: 8544 | |
| 18:39 | More test cases to help ensure that partial indexes do not get used if their qualifing constraint is inside the ON clause of a LEFT JOIN. file: [c5685245] check-in: [c6399958] user: drh branch: tkt-2326c258, size: 7831 | |
|
2014-04-28
| ||
| 20:11 | Do not reduce the number of rows scanned at all for "IS NOT NULL" constraints. Fix a bug in calculating the number of rows visited by scans of partial indicies. file: [fb370966] check-in: [a8ae93f0] user: dan branch: experimental-costs, size: 6863 | |
|
2014-04-13
| ||
| 19:15 | Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. file: [a0a2d286] check-in: [3122b836] user: drh branch: trunk, size: 6845 | |
|
2013-11-05
| ||
| 13:33 | Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [936979c3] check-in: [54b22192] user: drh branch: omit-rowid, size: 6338 | |
|
2013-10-04
| ||
| 00:00 | Make sure the count(*) optimization works correctly even when partial indices are present. Ticket [a5c8ed66cae]. file: [9996f064] check-in: [9f2f4c0a] user: drh branch: trunk, size: 6330 | |
|
2013-08-26
| ||
| 23:18 | Merge the STAT4 capability into trunk. file: [e96324d8] check-in: [a32af0ab] user: drh branch: trunk, size: 6142 | |
|
2013-08-20
| ||
| 20:25 | Fix a couple of test scripts to work with DEFAULT_AUTOVACUUM and OMIT_VIRTUALTABLE. file: [6a754747] check-in: [356c6c59] user: dan branch: trunk, size: 6135 | |
|
2013-08-12
| ||
| 20:14 | If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. file: [d84c03a7] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 6098 | |
|
2013-08-07
| ||
| 18:42 | Merge latest trunk changes with this branch. file: [5be279e4] check-in: [08f74c45] user: dan branch: sqlite_stat4, size: 6091 | |
|
2013-08-06
| ||
| 19:18 | Fix a test case related to partial indices so that it works even if STAT3 is disabled. file: [f53a788b] check-in: [153c6450] user: drh branch: trunk, size: 6091 | |
|
2013-08-02
| ||
| 14:18 | Silently ignore database name qualifiers in CHECK constraints and in partial index WHERE clauses. file: [0005b309] check-in: [2e8c845e] user: drh branch: partial-indices, size: 5880 | |
|
2013-08-01
| ||
| 16:02 | Fix bug in the logic that determines the end of a CREATE INDEX statement. Added a VACUUM test case that exposed the bug. file: [39671616] check-in: [2e3df0bc] user: drh branch: partial-indices, size: 5544 | |
| 15:09 | More test cases and corresponding bug fixes. file: [20363304] check-in: [0c8cfdfa] user: drh branch: partial-indices, size: 5471 | |
| 04:39 | Fix the ANALYZE command to work with partial indices. file: [9db2067d] check-in: [60353124] user: drh branch: partial-indices, size: 3054 | |
| 03:36 | Test cases and bug fixes for the partial index logic. file: [7030e7b7] check-in: [6b73ae7c] user: drh branch: partial-indices, size: 2804 | |
|
2013-07-31
| ||
| 19:05 | Resolve names in CREATE INDEX WHERE clauses and detect errors. Disallow expressions that contain variables, subqueries, or functions. The expression is still not used for anything, however. still unused. file: [11171203] check-in: [f2aa7842] user: drh branch: partial-indices, size: 1613 | |
| 18:12 | Here begins an experimental branch for exploring the idea of a partial index. This check-in is able to parse a WHERE clause on a CREATE INDEX statement, but does not actually do anythingn with that WHERE clause yet. file: [cbd74aa8] check-in: [6794b2dc] user: drh branch: partial-indices, size: 878 Added | |