Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/autoindex1.test
2025-01-18
| ||
21:19 | [6593151920] part of check-in [aa829a131a] Add a simple test case (many more are coming soon to TH3). Fix an obsolete assert(). (check-in: [aa829a131a] user: drh branch: without-rowid-autoidx, size: 21237) | |
2024-07-03
| ||
20:10 | [714cac6e60] part of check-in [c10a1b99d4] Show the creation of IN-operator Bloom filters in the EXPLAIN QUERY PLAN output. (check-in: [c10a1b99d4] user: drh branch: in-bloom, size: 20266) | |
2023-02-28
| ||
18:06 | [d34caffb03] part of check-in [5916705c73] Only use a Bloom filter on an automatic index if one or more of the key columns in the index can take on non-TEXT values. (check-in: [5916705c73] user: drh branch: trunk, size: 20238) | |
13:46 | [b8f093ff55] part of check-in [d7b2ac1c1a] When an automatic index creates a Bloom filter, show that in the EXPLAIN QUERY PLAN output. (check-in: [d7b2ac1c1a] user: drh branch: trunk, size: 20274) | |
2022-04-25
| ||
21:21 | [b2a87aca5c] part of check-in [4fbb9ffe72] Fix a problem with automatic indexes introduced by check-in [664b461bb5063d980] and reported by forum post 0d3200f4f3bcd3a3. (check-in: [4fbb9ffe72] user: drh branch: branch-3.38, size: 20193) | |
19:40 | [cdc336e80c] part of check-in [7ca3456c00] Failed first attempt to fix a problem with automatic indexes introduced by check-in [664b461bb5063d980] and reported by forum post 0d3200f4f3bcd3a3. I thought that I had tested this prior to check-in and that it worked. But after checking it in, I find that there are many test failures. (check-in: [7ca3456c00] user: drh branch: autoindex-fix, size: 20203) | |
2022-04-11
| ||
14:26 | [523b26034d] part of check-in [d91faeffea] Show LEFT and RIGHT JOIN processing in the EXPLAIN QUERY PLAN output. (check-in: [d91faeffea] user: drh branch: right-join, size: 19637) | |
2021-03-20
| ||
15:11 | [fe27af92ea] 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: 19627) | |
2020-07-29
| ||
16:18 | [0be3248078] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 19788) | |
2018-12-24
| ||
20:21 | [96185415f5] part of check-in [7153552bac] Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. (check-in: [7153552bac] user: drh branch: reuse-subqueries, size: 19789) | |
12:09 | [efdc2ff5d3] part of check-in [06de44ec9e] Do not generate subroutines for non-static SELECT and EXISTS expressions. Fix up some test cases to account for the minor changes in EXPLAIN QUERY PLAN output. (check-in: [06de44ec9e] user: drh branch: reuse-subqueries, size: 19782) | |
2018-05-02
| ||
19:42 | [a09958fa75] part of check-in [dab5e52948] More test case updates. Tests are all running now. (check-in: [dab5e52948] user: drh branch: rework-EQP, size: 19761) | |
2017-07-18
| ||
17:13 | [788d0894aa] part of check-in [d2f0b2e859] Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. (check-in: [d2f0b2e859] user: dan branch: trunk, size: 19795) | |
2015-04-15
| ||
07:34 | [14b63a9f1e] part of check-in [eeb4bd06bf] Remove an incorrect ALWAYS() from the automatic index generator. (check-in: [eeb4bd06bf] user: drh branch: trunk, size: 19261) | |
2015-02-27
| ||
20:28 | [7008c9f604] part of check-in [8c2b29d9ac] New requirements marks and a few new test cases to go with them. No changes to code. (check-in: [8c2b29d9ac] user: drh branch: trunk, size: 19005) | |
2014-09-22
| ||
14:30 | [6ff78b94f4] part of check-in [41de1643bf] Tune the query planner to be more aggressive about using automatic indexes on views and subqueries for which there is not opportunity to declare a persistent schema index. (check-in: [41de1643bf] user: drh branch: trunk, size: 18858) | |
2014-04-24
| ||
20:04 | [762ff3f8e2] part of check-in [c5a6ec0a88] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (check-in: [c5a6ec0a88] user: dan branch: experimental-costs, size: 13397) | |
2013-07-05
| ||
19:16 | [d4dfe14001] part of check-in [60cf7e4487] Fix two test script problems revealed by permutations.test. (check-in: [60cf7e4487] user: dan branch: trunk, size: 13301) | |
2013-06-28
| ||
23:55 | [d0c86aad05] part of check-in [338826ef3f] Issue the new SQLITE_WARNING_AUTOINDEX warning on the SQLite log whenever an automatic index is created. (check-in: [338826ef3f] user: drh branch: trunk, size: 13292) | |
21:12 | [e19269b74a] part of check-in [459b317902] Add the SQLITE_DEFAULT_AUTOMATIC_INDEX compile-time option, which if set to zero turns automatic indices off by default. Increase the estimated cost of an automatic index. Additional minor refactoring of the automatic index code. (check-in: [459b317902] user: drh branch: trunk, size: 13003) | |
2013-06-17
| ||
14:18 | [314f12f876] part of check-in [e8f124284e] Use automatic indices on subqueries of the FROM clause when appropriate. (check-in: [e8f124284e] user: drh branch: nextgen-query-plan-exp, size: 12786) | |
2013-06-13
| ||
15:16 | [6a22a566b2] part of check-in [3a72af2a95] Make the MIN() and MAX() macros available in sqliteInt.h. Add TUNING comments to the NGQP and adjust costs slightly. (check-in: [3a72af2a95] user: drh branch: nextgen-query-plan-exp, size: 12740) | |
2013-06-12
| ||
17:08 | [fac4207316] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 12477) | |
2013-06-10
| ||
23:30 | [fadbdf6829] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 12523) | |
2013-01-17
| ||
15:05 | [f88146c4c8] part of check-in [d96762841a] Make more aggressive use of transitivity in optimizing queries. Add a test case. (check-in: [d96762841a] user: drh branch: transitive-constraints, size: 12676) | |
2011-07-02
| ||
15:42 | [5832aabf50] part of check-in [9bbcd8c076] Cherrypick change [27c65d4d9c] into the 3.7.2 branch. (check-in: [9bbcd8c076] user: dan branch: branch-3.7.2, size: 4907) | |
15:32 | [058d0b331a] part of check-in [27c65d4d9c] Ensure that automatic indexes are only created in scenarios where they may be used more than once. (check-in: [27c65d4d9c] user: dan branch: trunk, size: 8167) | |
2011-02-12
| ||
14:23 | [fb1fe6a000] part of check-in [f2a8b5ccfb] Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. (check-in: [f2a8b5ccfb] user: drh branch: branch-3.7.2, size: 4736) | |
01:59 | [53fdc13501] part of check-in [e72cf118cb] This is the beginning of an attempt to backport recent query planner enhancements to version 3.7.2. The code in this version builds and runs and seems to give correct answers, but it generates suboptimal query plans and hence many of the test cases fail. The test script gives up after 1000 errors. (check-in: [e72cf118cb] user: drh branch: branch-3.7.2, size: 4575) | |
2010-11-16
| ||
02:49 | [860fc83f4f] part of check-in [56bbc53924] Use the estimated number of rows computed for subqueries in the cost computations for outer queries. (check-in: [56bbc53924] user: drh branch: trunk, size: 7957) | |
2010-11-13
| ||
16:42 | [67e2de552a] part of check-in [6611b76b02] Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. (check-in: [6611b76b02] user: dan branch: experimental, size: 7957) | |
2010-11-11
| ||
11:43 | [c00ee946c4] part of check-in [7ae068952f] Fix a bug in the EXPLAIN QUERY PLAN code. (check-in: [7ae068952f] user: dan branch: experimental, size: 7924) | |
10:36 | [4400c3e123] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 7897) | |
2010-10-21
| ||
22:58 | [744ad86deb] part of check-in [d30f7b2def] Make sure the estimated row count for ephemeral tables is initialized so that automatic indices can be used on those tables. (check-in: [d30f7b2def] user: drh branch: trunk, size: 7514) | |
2010-07-28
| ||
02:53 | [7df441bf0e] part of check-in [267492d3a7] Do not allow automatic indices for the RHS of IN expressions which are not correlated subqueries. Ticket [8011086c85c6c404014c9] (check-in: [267492d3a7] user: drh branch: trunk, size: 4565) | |
2010-04-08
| ||
16:30 | [ffb06a246e] part of check-in [99d8e325e9] Additional automatic index tests. (check-in: [99d8e325e9] user: drh branch: trunk, size: 3653) | |
15:01 | [637a6937c0] part of check-in [e1aa48ace7] New test cases for automatic indices. New testcase() macros associated with column-used bitmasks. (check-in: [e1aa48ace7] user: drh branch: trunk, size: 2772) | |
2010-04-07
| ||
19:32 | Added: [1ab878fa73] part of check-in [1f40441204] Add an interface to the SQLITE_STMTSTATUS_AUTOINDEX status information to the TCL bindings. Add some simple automatic index test cases. (check-in: [1f40441204] user: drh branch: experimental, size: 2388) | |