/ File History
Login

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

History of test/skipscan1.test

2019-04-05
20:47
Add further tests so that veryquick.test covers all vdbe branches. file: [b1fef304] check-in: [cbc67de5] user: dan branch: trunk, size: 12655
2018-07-12
19:14
Add a test-control to disable the skip-scan optimization. file: [3ea1cccc] check-in: [650a3fe0] user: dan branch: trunk, size: 11803
2016-09-19
11:00
Fix a segfault introduced by the row-value enhancement that comes up on a skip-scan where the first term of the index is unconstrained and the second term is of the form "columm IN (SELECT...)". file: [8ab5d2c7] check-in: [2401ea5a] user: drh branch: trunk, size: 11589
2016-07-29
01:32
Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. file: [f2d4482f] check-in: [c7d51934] user: drh branch: trunk, size: 11069
2015-07-23
16:39
The sqlite3ExprCodeGetColumn() is not guaranteed to put the result in the register requested. Fix the skip-scan code generator for WITHOUT ROWID tables so that it always checks the register and copies the result if it lands in the wrong register. Fix for ticket [8fd39115d8f46ece70e7d4b3]. file: [d37a75b4] check-in: [793e206f] user: drh branch: trunk, size: 10979
2014-11-15
19:08
Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. file: [2ddfe5d1] check-in: [00fe0950] user: drh branch: noskipscan-token, size: 10090
2014-09-23
01:40
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. file: [7e15e1cc] check-in: [ae9a42b2] user: drh branch: trunk, size: 9440
2014-05-23
17:17
Changes to the output of EXPLAIN QUERY PLAN to make it clearer when a query uses the PRIMARY KEY index of a WITHOUT ROWID table. file: [28c7faa4] check-in: [9268df30] user: dan branch: trunk, size: 8370
2014-03-10
20:12
Adjustments to the cost computation for the skip-scan query plan, to take into account the fact that a seek has to occur on each skip. file: [bed8cbe9] check-in: [0769eebd] user: drh branch: trunk, size: 8386
2013-12-22
20:44
Make sure the WhereLoop.aLTerm[] array is large enough when processing the skip-scan optimization. Fix for ticket [520070ec7fbaac]. file: [8c777ffd] check-in: [46d04059] user: drh branch: trunk, size: 7248
2013-11-13
19:01
Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting the shell from trunk. Fix a bug in skip-scan and add a test case to prevent a regression. file: [6bb4891c] check-in: [f668616a] user: drh branch: skip-scan, size: 6579
16:58
Improve the way that skip-scan loops are constructued. Add test cases. Improved the scoring of skip-scan loops. file: [bc65ecb2] check-in: [5e75ab93] user: drh branch: skip-scan, size: 6050
15:32
Add test cases for skip-scan. Enhance "do_test" so that if the expected result is of the form "/*..*/" or "~/*..*/" it treats the expected result as a glob pattern rather than as a regular expression. Fix a bug in ANALYZE result loading associated with WITHOUT ROWID tables. file: [63af32c3] check-in: [d3e6e9b2] user: drh branch: skip-scan, size: 5024 Added