/ File History
Login

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

History of test/index6.test

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