/ All files named "test/indexedby.test"
Login

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

History for test/indexedby.test

2020-06-03
03:00
[f54aac21] part of check-in [d901837f] Improve the query planner so that it is better able to find full index scan plan when there is an INDEXED BY clause. (check-in: [d901837f] user: drh branch: trunk, size: 12228)
2018-05-04
18:32
[a52c8c6a] part of check-in [7fdad122] Fix requirements marks. No code changes. (check-in: [7fdad122] user: drh branch: trunk, size: 12400)
2018-05-02
18:00
[5a4a4514] part of check-in [5f0e803e] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e] user: drh branch: rework-EQP, size: 12398)
2017-11-07
18:20
[faa585e3] part of check-in [292a0408] Fix a problem causing an INDEXED BY specifying an unusable partial index to be mishandled. (check-in: [292a0408] user: dan branch: trunk, size: 13138)
2015-09-12
19:26
[9c4cd331] part of check-in [eaeb2b80] Experimental change to use a single-pass approach for DELETE statements on non-virtual tables that do not fire triggers or require foriegn-key processing. (check-in: [eaeb2b80] user: dan branch: onepass-delete, size: 12516)
2015-09-11
20:54
[69d2292d] part of check-in [86781093] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093] user: drh branch: trunk, size: 12534)
2015-03-04
23:14
[5f527a78] part of check-in [c298ea0b] New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. (check-in: [c298ea0b] user: drh branch: trunk, size: 12534)
2013-08-20
17:14
[b2f22f3e] part of check-in [ef192abb] Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. (check-in: [ef192abb] user: dan branch: trunk, size: 10794)
2013-06-12
17:08
[0e959308] part of check-in [addd7f46] "make test" now passing. (check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 9129)
2013-06-10
23:30
[e06e1bf5] part of check-in [aa580e36] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 9236)
2011-01-28
01:57
[be501e38] part of check-in [4847c6cb] Change the weighting of binary searches on tables to 1/10th the cost of a search on an index. Change the assumed reduction in search space from a indexed range constraint from 1/3rd to 1/4th. Do not let the estimated number of rows drop below 1. (check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 9573)
2010-11-13
16:42
[d7367c5a] part of check-in [6611b76b] 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: [6611b76b] user: dan branch: experimental, size: 9573)
2010-11-11
10:36
[cd781337] part of check-in [30904ef8] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef8] user: dan branch: experimental, size: 9477)
2010-08-04
21:17
[5a118060] part of check-in [e7a714b5] If the outer loop of a join must be a full table scan, make sure that an incomplete ANALYZE does not trick the planner into use a table that might be indexable in an inner loop. Ticket [13f033c865f878] (check-in: [e7a714b5] user: drh branch: trunk, size: 8366)
2009-03-22
20:36
[946ca262] part of check-in [53149c9f] Allow the keyword INDEXED to be used as the name of a table or index or column - for backwards compatibility. (CVS 6370) (check-in: [53149c9f] user: drh branch: trunk, size: 8100)
2008-12-30
09:45
[bcf239cc] part of check-in [f8ff0212] Fix a bug in where.c causing a malfunction when an INDEXED BY clause specified an unusable index on other than the leftmost table in the FROM clause. Ticket #3560. (CVS 6076) (check-in: [f8ff0212] user: danielk1977 branch: trunk, size: 7497)
2008-10-06
16:18
[03af5237] part of check-in [83a7e446] Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) (check-in: [83a7e446] user: danielk1977 branch: trunk, size: 6862)
11:29
[5e54a6b2] part of check-in [bb51c345] Add a test to indexedby.test to check that automatic indexes (sqlite_autoindex_xxx) can be used with the INDEXED BY syntax. (CVS 5767) (check-in: [bb51c345] user: danielk1977 branch: trunk, size: 5379)
05:32
Added: [b3fde1ae] part of check-in [98ca5580] Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) (check-in: [98ca5580] user: danielk1977 branch: trunk, size: 4734)