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

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

History for test/skipscan1.test

2020-01-06
17:33
[ed524bc8] part of check-in [d7126a9c] Do not attempt to use the skip-scan optimization if prior terms of the index are already used for non-equality constraints. Ticket [304017f5f04a0035] (check-in: [d7126a9c] user: drh branch: trunk, size: 13957)
2019-08-08
15:24
[2a64ca7b] 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: 13478)
2019-07-30
14:22
[acbde73b] part of check-in [89bf0399] Improved fix for ticket [ced41c7c7d6b4d36] that keeps skip-scan enabled, but avoids identifying a skip-scan as order-distinct (because it is not) and thus forces a separate b-tree to implement the DISTINCT clause of a query. This undoes check-in [a871d69c6de65038] and substitutes a new fix. (check-in: [89bf0399] user: drh branch: trunk, size: 13515)
01:17
[64ad7a05] part of check-in [a871d69c] Disable the skip-scan optimization for DISTINCT queries. Fix for ticket [ced41c7c7d6b4d36] (check-in: [a871d69c] user: drh branch: trunk, size: 13256)
2019-04-05
20:47
[b1fef304] part of check-in [cbc67de5] Add further tests so that veryquick.test covers all vdbe branches. (check-in: [cbc67de5] user: dan branch: trunk, size: 12655)
2018-07-12
19:14
[3ea1cccc] part of check-in [650a3fe0] Add a test-control to disable the skip-scan optimization. (check-in: [650a3fe0] user: dan branch: trunk, size: 11803)
2016-09-19
11:00
[8ab5d2c7] part of check-in [2401ea5a] 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...)". (check-in: [2401ea5a] user: drh branch: trunk, size: 11589)
2016-07-29
01:32
[f2d4482f] part of check-in [c7d51934] Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. (check-in: [c7d51934] user: drh branch: trunk, size: 11069)
2015-07-23
16:39
[d37a75b4] part of check-in [793e206f] 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]. (check-in: [793e206f] user: drh branch: trunk, size: 10979)
2014-11-15
19:08
[2ddfe5d1] part of check-in [00fe0950] Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (check-in: [00fe0950] user: drh branch: noskipscan-token, size: 10090)
2014-09-23
01:40
[7e15e1cc] part of check-in [ae9a42b2] 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: [ae9a42b2] user: drh branch: trunk, size: 9440)
2014-05-23
17:17
[28c7faa4] part of check-in [9268df30] 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. (check-in: [9268df30] user: dan branch: trunk, size: 8370)
2014-03-10
20:12
[bed8cbe9] part of check-in [0769eebd] 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. (check-in: [0769eebd] user: drh branch: trunk, size: 8386)
2013-12-22
20:44
[8c777ffd] part of check-in [46d04059] Make sure the WhereLoop.aLTerm[] array is large enough when processing the skip-scan optimization. Fix for ticket [520070ec7fbaac]. (check-in: [46d04059] user: drh branch: trunk, size: 7248)
2013-11-13
19:01
[6bb4891c] part of check-in [f668616a] 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. (check-in: [f668616a] user: drh branch: skip-scan, size: 6579)
16:58
[bc65ecb2] part of check-in [5e75ab93] Improve the way that skip-scan loops are constructued. Add test cases. Improved the scoring of skip-scan loops. (check-in: [5e75ab93] user: drh branch: skip-scan, size: 6050)
15:32
Added: [63af32c3] part of check-in [d3e6e9b2] 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. (check-in: [d3e6e9b2] user: drh branch: skip-scan, size: 5024)