Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/autoindex1.test
|
2018-12-24
| ||
| 20:21 | 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. file: [96185415] check-in: [7153552b] user: drh branch: reuse-subqueries, size: 19789 | |
| 12:09 | 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. file: [efdc2ff5] check-in: [06de44ec] user: drh branch: reuse-subqueries, size: 19782 | |
|
2018-05-02
| ||
| 19:42 | More test case updates. Tests are all running now. file: [a09958fa] check-in: [dab5e529] user: drh branch: rework-EQP, size: 19761 | |
|
2017-07-18
| ||
| 17:13 | Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS term. Fix for [ce68383b]. file: [788d0894] check-in: [d2f0b2e8] user: dan branch: trunk, size: 19795 | |
|
2015-04-15
| ||
| 07:34 | Remove an incorrect ALWAYS() from the automatic index generator. file: [14b63a9f] check-in: [eeb4bd06] user: drh branch: trunk, size: 19261 | |
|
2015-02-27
| ||
| 20:28 | New requirements marks and a few new test cases to go with them. No changes to code. file: [7008c9f6] check-in: [8c2b29d9] user: drh branch: trunk, size: 19005 | |
|
2014-09-22
| ||
| 14:30 | 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. file: [6ff78b94] check-in: [41de1643] user: drh branch: trunk, size: 18858 | |
|
2014-04-24
| ||
| 20:04 | Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. file: [762ff3f8] check-in: [c5a6ec0a] user: dan branch: experimental-costs, size: 13397 | |
|
2013-07-05
| ||
| 19:16 | Fix two test script problems revealed by permutations.test. file: [d4dfe140] check-in: [60cf7e44] user: dan branch: trunk, size: 13301 | |
|
2013-06-28
| ||
| 23:55 | Issue the new SQLITE_WARNING_AUTOINDEX warning on the SQLite log whenever an automatic index is created. file: [d0c86aad] check-in: [338826ef] user: drh branch: trunk, size: 13292 | |
| 21:12 | 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. file: [e19269b7] check-in: [459b3179] user: drh branch: trunk, size: 13003 | |
|
2013-06-17
| ||
| 14:18 | Use automatic indices on subqueries of the FROM clause when appropriate. file: [314f12f8] check-in: [e8f12428] user: drh branch: nextgen-query-plan-exp, size: 12786 | |
|
2013-06-13
| ||
| 15:16 | Make the MIN() and MAX() macros available in sqliteInt.h. Add TUNING comments to the NGQP and adjust costs slightly. file: [6a22a566] check-in: [3a72af2a] user: drh branch: nextgen-query-plan-exp, size: 12740 | |
|
2013-06-12
| ||
| 17:08 | "make test" now passing. file: [fac42073] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 12477 | |
|
2013-06-10
| ||
| 23:30 | Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [fadbdf68] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 12523 | |
|
2013-01-17
| ||
| 15:05 | Make more aggressive use of transitivity in optimizing queries. Add a test case. file: [f88146c4] check-in: [d9676284] user: drh branch: transitive-constraints, size: 12676 | |
|
2011-07-02
| ||
| 15:42 | Cherrypick change [27c65d4d9c] into the 3.7.2 branch. file: [5832aabf] check-in: [9bbcd8c0] user: dan branch: branch-3.7.2, size: 4907 | |
| 15:32 | Ensure that automatic indexes are only created in scenarios where they may be used more than once. file: [058d0b33] check-in: [27c65d4d] user: dan branch: trunk, size: 8167 | |
|
2011-02-12
| ||
| 14:23 | 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. file: [fb1fe6a0] check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 4736 | |
| 01:59 | 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. file: [53fdc135] check-in: [e72cf118] user: drh branch: branch-3.7.2, size: 4575 | |
|
2010-11-16
| ||
| 02:49 | Use the estimated number of rows computed for subqueries in the cost computations for outer queries. file: [860fc83f] check-in: [56bbc539] user: drh branch: trunk, size: 7957 | |
|
2010-11-13
| ||
| 16:42 | 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. file: [67e2de55] check-in: [6611b76b] user: dan branch: experimental, size: 7957 | |
|
2010-11-11
| ||
| 11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. file: [c00ee946] check-in: [7ae06895] user: dan branch: experimental, size: 7924 | |
| 10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [4400c3e1] check-in: [30904ef8] user: dan branch: experimental, size: 7897 | |
|
2010-10-21
| ||
| 22:58 | Make sure the estimated row count for ephemeral tables is initialized so that automatic indices can be used on those tables. file: [744ad86d] check-in: [d30f7b2d] user: drh branch: trunk, size: 7514 | |
|
2010-07-28
| ||
| 02:53 | Do not allow automatic indices for the RHS of IN expressions which are not correlated subqueries. Ticket [8011086c85c6c404014c9] file: [7df441bf] check-in: [267492d3] user: drh branch: trunk, size: 4565 | |
|
2010-04-08
| ||
| 16:30 | Additional automatic index tests. file: [ffb06a24] check-in: [99d8e325] user: drh branch: trunk, size: 3653 | |
| 15:01 | New test cases for automatic indices. New testcase() macros associated with column-used bitmasks. file: [637a6937] check-in: [e1aa48ac] user: drh branch: trunk, size: 2772 | |
|
2010-04-07
| ||
| 19:32 | Add an interface to the SQLITE_STMTSTATUS_AUTOINDEX status information to the TCL bindings. Add some simple automatic index test cases. file: [1ab878fa] check-in: [1f404412] user: drh branch: experimental, size: 2388 Added | |