SQLite

All files named ”test/skipscan1.test”
Login

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

History for test/skipscan1.test

2024-08-15
23:38
[9cbbb65755] part of check-in [2fbb4dc232] If a subquery is materialized due to an ORDER BY and that ordering is useful in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort. (check-in: [2fbb4dc232] user: drh branch: order-by-subquery, size: 14201)
2023-03-24
21:24
[e03ba5b977] part of check-in [651a13fcd1] Fix an error in the OP_SeekScan opcode added by check-in [4a43430fd23f8835]. Problem reported by forum post 8cc1dc0fe9. (check-in: [651a13fcd1] user: drh branch: trunk, size: 14204)
2021-03-20
15:11
[1a9972e1dc] 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: 13945)
2020-01-06
17:33
[ed524bc86f] part of check-in [d7126a9ced] 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: [d7126a9ced] user: drh branch: trunk, size: 13957)
2019-08-08
15:24
[2a64ca7b3e] part of check-in [1e17ea2fd1] 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: [1e17ea2fd1] user: drh branch: omit-stat3, size: 13478)
2019-07-30
14:22
[acbde73b53] part of check-in [89bf0399e8] 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: [89bf0399e8] user: drh branch: trunk, size: 13515)
01:17
[64ad7a05a3] part of check-in [a871d69c6d] Disable the skip-scan optimization for DISTINCT queries. Fix for ticket [ced41c7c7d6b4d36] (check-in: [a871d69c6d] user: drh branch: trunk, size: 13256)
2019-04-05
20:47
[b1fef3046d] part of check-in [cbc67de5a3] Add further tests so that veryquick.test covers all vdbe branches. (check-in: [cbc67de5a3] user: dan branch: trunk, size: 12655)
2018-07-12
19:14
[3ea1cccca8] part of check-in [650a3fe03d] Add a test-control to disable the skip-scan optimization. (check-in: [650a3fe03d] user: dan branch: trunk, size: 11803)
2016-09-19
11:00
[8ab5d2c7c5] part of check-in [2401ea5acf] 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: [2401ea5acf] user: drh branch: trunk, size: 11589)
2016-07-29
01:32
[f2d4482f19] part of check-in [c7d51934a4] Undo some unhelpful changes to skip-scan scoring that were added by the check-in [9e2b2681] that improved scoring of index scan. (check-in: [c7d51934a4] user: drh branch: trunk, size: 11069)
2015-07-23
16:39
[d37a75b4be] part of check-in [793e206f90] 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: [793e206f90] user: drh branch: trunk, size: 10979)
2014-11-15
19:08
[2ddfe5d168] part of check-in [00fe095057] Adding the "noskipscan" token to an sqlite_stat1.stat field prevents an index for being used with the skip-scan algorithm. (check-in: [00fe095057] user: drh branch: noskipscan-token, size: 10090)
2014-09-23
01:40
[7e15e1cc52] 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: 9440)
2014-05-23
17:17
[28c7faa41a] part of check-in [9268df305b] 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: [9268df305b] user: dan branch: trunk, size: 8370)
2014-03-10
20:12
[bed8cbe9d5] part of check-in [0769eebd02] 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: [0769eebd02] user: drh branch: trunk, size: 8386)
2013-12-22
20:44
[8c777ffd9d] part of check-in [46d040591f] Make sure the WhereLoop.aLTerm[] array is large enough when processing the skip-scan optimization. Fix for ticket [520070ec7fbaac]. (check-in: [46d040591f] user: drh branch: trunk, size: 7248)
2013-11-13
19:01
[6bb4891c2c] part of check-in [f668616a29] 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: [f668616a29] user: drh branch: skip-scan, size: 6579)
16:58
[bc65ecb228] part of check-in [5e75ab9388] Improve the way that skip-scan loops are constructued. Add test cases. Improved the scoring of skip-scan loops. (check-in: [5e75ab9388] user: drh branch: skip-scan, size: 6050)
15:32
Added: [63af32c300] part of check-in [d3e6e9b2a7] 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: [d3e6e9b2a7] user: drh branch: skip-scan, size: 5024)