SQLite

All files named ”test/skipscan5.test”
Login

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

History for test/skipscan5.test

2021-03-20
15:11
[0672103fd2] 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: 5488)
2020-10-22
18:16
[980875ad45] part of check-in [27c681c9c6] Test case updates. (check-in: [27c681c9c6] user: drh branch: avoid-bad-indexes, size: 5560)
2014-09-23
01:40
[67817a4b68] part of check-in [ae9a42b268] Adjust skip-scan cost estimates slightly so that a full table scan is preferred over a skip-scan to a column with only two distinct values. (check-in: [ae9a42b268] user: drh branch: trunk, size: 5559)
2014-06-28
17:35
[d8b9692b70] part of check-in [4b8230e8fe] Add further tests to skipscan5.test. (check-in: [4b8230e8fe] user: dan branch: stat4-skipscan, size: 5563)
15:26
[4b83d803bb] part of check-in [dfb09db6d4] Fix a problem with using stat4 samples of type text when estimating the rows visited by a range-query/skip-scan loop. (check-in: [dfb09db6d4] user: dan branch: stat4-skipscan, size: 3611)
2014-06-27
20:14
Added: [7eb78ace4e] part of check-in [219736f54d] Fix a couple of problems in estimating the number of rows visited by a range query that uses a skip-scan. (check-in: [219736f54d] user: dan branch: stat4-skipscan, size: 2003)