SQLite

All files named ”test/skipscan6.test”
Login

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

History for test/skipscan6.test

2025-02-17
20:13
[e2b256cf5d] part of check-in [9c9c19414a] Add an ORDER BY to a test case for skip-scan to make the output consistent. (check-in: [9c9c19414a] user: drh branch: trunk, size: 15310)
2021-03-20
15:11
[bddbb35dd3] 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: 15296)
2018-05-02
18:00
[0b4cd1b4ac] 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: 15308)
2014-11-05
14:19
[5866039d03] part of check-in [948d6e5d07] Add a test case to check that the previous commit is effective. (check-in: [948d6e5d07] user: dan branch: trunk, size: 15348)
2014-10-21
01:05
Added: [3a891b45d6] part of check-in [f4b22a2620] If a skip-scan is a proper subset of some other scan, then adjust the cost of the skip-scan upward so that it is more costly than the other scan. Such a cost imbalance can arise under STAT4 because of difficulties in getting an accurate estimate for skip-scans. (check-in: [f4b22a2620] user: drh branch: trunk, size: 13965)