SQLite

All files named ”test/whereI.test”
Login

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

History for test/whereI.test

2021-03-20
15:11
[c4bb7e2ca5] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 2477)
2018-12-24
20:21
[a287406214] part of check-in [7153552bac] Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. (check-in: [7153552bac] user: drh branch: reuse-subqueries, size: 2501)
2018-05-04
00:39
[b7769ee8db] part of check-in [75ac7b4e4f] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e4f] user: drh branch: trunk, size: 2425)
2018-05-02
18:00
[0f30efab13] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 2373)
2016-02-05
16:46
[eab5b226bb] part of check-in [a6b3527323] From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (check-in: [a6b3527323] user: drh branch: trunk, size: 2369)
2014-05-27
11:42
[1d89199697] part of check-in [aa183e6092] Add a test to whereI.test that uses a multi-column PK. (check-in: [aa183e6092] user: dan branch: trunk, size: 2370)
2014-05-26
20:06
Added: [6cc613df88] part of check-in [2c7e277bbe] Enable the OR optimization for WITHOUT ROWID tables. Use a temp table instead of the RowSet object to track the rows that have already been included in the result set. (check-in: [2c7e277bbe] user: dan branch: without-rowid-or-opt, size: 1878)