/ File History
Login

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