Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/skipscan1.test
|
2020-01-06
| ||
| 17:33 | Do not attempt to use the skip-scan optimization if prior terms of the index are already used for non-equality constraints. Ticket [304017f5f04a0035] file: [ed524bc8] check-in: [d7126a9c] user: drh branch: trunk, size: 13957 | |
|
2019-08-08
| ||
| 15:24 | 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. file: [2a64ca7b] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 13478 | |
|
2019-07-30
| ||
| 14:22 | 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. file: [acbde73b] check-in: [89bf0399] user: drh branch: trunk, size: 13515 | |
| 01:17 | Disable the skip-scan optimization for DISTINCT queries. Fix for ticket [ced41c7c7d6b4d36] file: [64ad7a05] check-in: [a871d69c] user: drh branch: trunk, size: 13256 | |
|
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 | |