/ All files named "test/index6.test"
Login

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

History for test/index6.test

2019-11-02
13:32
[f172653b] part of check-in [17e9f658] In sqlite3GenerateIndexKey(), do not attempt to reuse column values from the previous index if the current index is a partial index as the partial index test may have changed those values. Ticket [a9efb42811fa41ee] (check-in: [17e9f658] user: drh branch: trunk, size: 13707)
2019-09-03
14:27
[4d1dd3ca] part of check-in [5351e920] 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] (check-in: [5351e920] user: drh branch: trunk, size: 13197)
2019-08-30
16:00
[bae04b45] part of check-in [dd661348] The expression "(X IS FALSE) IN (FALSE)" does not imply that X is NOT NULL. Ticket [f8f472cbc77ba9c9] (check-in: [dd661348] user: drh branch: trunk, size: 12774)
15:11
[5b016266] part of check-in [057fb8b1] The expression "(X IS FALSE) BETWEEN FALSE AND TRUE" does not implie that X is not NULL. Ticket [fba33c8b1df6a915] (check-in: [057fb8b1] user: drh branch: trunk, size: 12635)
13:07
[4286a391] part of check-in [45ff2b1f] The expression "(x IS FALSE) IS FALSE" does not imply that X is not NULL. Ticket [a6408d42b9f44462] (check-in: [45ff2b1f] user: drh branch: trunk, size: 12271)
2019-08-08
15:24
[7883c357] part of check-in [1e17ea2f] 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. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 11987)
2019-05-11
16:14
[a6cf96bb] part of check-in [1b243032] When considering partial indexes, do not assume that a "CASE x ..." expression implies "x IS NOT NULL". (check-in: [1b243032] user: dan branch: trunk, size: 11995)
13:04
[f9359034] part of check-in [0ba6d709] Do not assume that "x IS NOT ?" implies "x NOT NULL" when considering partial indexes. Fix for ticket [8025674847]. (check-in: [0ba6d709] user: dan branch: trunk, size: 11894)
2019-05-04
17:32
[448fa05f] part of check-in [c2e439bc] Fix the NOT NULL logic in the theorem prover that determines when a partial index can be used. Ticket [5c6955204c392ae763a95]. (check-in: [c2e439bc] user: drh branch: trunk, size: 11584)
2018-12-09
18:55
[6b3e6cd4] part of check-in [b7bf3c98] New test case for ticket [1d958d90596593a77420e59]. (check-in: [b7bf3c98] user: drh branch: trunk, size: 11269)
2018-12-08
20:30
[7cb66c4e] part of check-in [15bc915d] Do not use a partial index as a table scan in an IN operator. Fix for ticket [1d958d90596593a77420e59]. (check-in: [15bc915d] user: drh branch: trunk, size: 11170)
2018-05-02
18:00
[d07ea75b] part of check-in [5f0e803e] 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. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 10635)
2016-10-03
18:13
[b4fc8122] part of check-in [c6e9b942] Allow deterministic functions in the WHERE clause of a partial index. (check-in: [c6e9b942] user: drh branch: trunk, size: 10633)
2016-06-08
18:07
[43b4e292] part of check-in [fe187432] Prefer to use partial indexes for full table scans when that is possible. (check-in: [fe187432] user: drh branch: trunk, size: 10606)
2015-08-07
20:57
[7102ec37] part of check-in [06576590] Enhance the query planner so that it is able to use partial indexes that use AND-connected terms in the WHERE clause. (check-in: [06576590] user: drh branch: trunk, size: 10243)
2015-06-11
13:58
[fbf45ceb] part of check-in [e63d01c6] When generating code for partial indexes, be sure not to modify the index condition expression in the schema. (check-in: [e63d01c6] user: drh branch: trunk, size: 9281)
2015-02-24
20:10
[3ae54e53] part of check-in [1d6fb43a] 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). (check-in: [1d6fb43a] user: dan branch: trunk, size: 8544)
18:39
[c5685245] part of check-in [c6399958] 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. (check-in: [c6399958] user: drh branch: tkt-2326c258, size: 7831)
2014-04-28
20:11
[fb370966] part of check-in [a8ae93f0] 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. (check-in: [a8ae93f0] user: dan branch: experimental-costs, size: 6863)
2014-04-13
19:15
[a0a2d286] part of check-in [3122b836] Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. (check-in: [3122b836] user: drh branch: trunk, size: 6845)
2013-11-05
13:33
[936979c3] part of check-in [54b22192] 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. (check-in: [54b22192] user: drh branch: omit-rowid, size: 6338)
2013-10-04
00:00
[9996f064] part of check-in [9f2f4c0a] Make sure the count(*) optimization works correctly even when partial indices are present. Ticket [a5c8ed66cae]. (check-in: [9f2f4c0a] user: drh branch: trunk, size: 6330)
2013-08-26
23:18
[e96324d8] part of check-in [a32af0ab] Merge the STAT4 capability into trunk. (check-in: [a32af0ab] user: drh branch: trunk, size: 6142)
2013-08-20
20:25
[6a754747] part of check-in [356c6c59] Fix a couple of test scripts to work with DEFAULT_AUTOVACUUM and OMIT_VIRTUALTABLE. (check-in: [356c6c59] user: dan branch: trunk, size: 6135)
2013-08-12
20:14
[d84c03a7] part of check-in [cca8bf43] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 6098)
2013-08-07
18:42
[5be279e4] part of check-in [08f74c45] Merge latest trunk changes with this branch. (check-in: [08f74c45] user: dan branch: sqlite_stat4, size: 6091)
2013-08-06
19:18
[f53a788b] part of check-in [153c6450] Fix a test case related to partial indices so that it works even if STAT3 is disabled. (check-in: [153c6450] user: drh branch: trunk, size: 6091)
2013-08-02
14:18
[0005b309] part of check-in [2e8c845e] Silently ignore database name qualifiers in CHECK constraints and in partial index WHERE clauses. (check-in: [2e8c845e] user: drh branch: partial-indices, size: 5880)
2013-08-01
16:02
[39671616] part of check-in [2e3df0bc] Fix bug in the logic that determines the end of a CREATE INDEX statement. Added a VACUUM test case that exposed the bug. (check-in: [2e3df0bc] user: drh branch: partial-indices, size: 5544)
15:09
[20363304] part of check-in [0c8cfdfa] More test cases and corresponding bug fixes. (check-in: [0c8cfdfa] user: drh branch: partial-indices, size: 5471)
04:39
[9db2067d] part of check-in [60353124] Fix the ANALYZE command to work with partial indices. (check-in: [60353124] user: drh branch: partial-indices, size: 3054)
03:36
[7030e7b7] part of check-in [6b73ae7c] Test cases and bug fixes for the partial index logic. (check-in: [6b73ae7c] user: drh branch: partial-indices, size: 2804)
2013-07-31
19:05
[11171203] part of check-in [f2aa7842] 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. (check-in: [f2aa7842] user: drh branch: partial-indices, size: 1613)
18:12
Added: [cbd74aa8] part of check-in [6794b2dc] 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. (check-in: [6794b2dc] user: drh branch: partial-indices, size: 878)