/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/indexedby.test

2018-05-04
18:32
Fix requirements marks. No code changes. file: [a52c8c6a] check-in: [7fdad122] user: drh branch: trunk, size: 12400
2018-05-02
18:00
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. file: [5a4a4514] check-in: [5f0e803e] user: drh branch: rework-EQP, size: 12398
2017-11-07
18:20
Fix a problem causing an INDEXED BY specifying an unusable partial index to be mishandled. file: [faa585e3] check-in: [292a0408] user: dan branch: trunk, size: 13138
2015-09-12
19:26
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. file: [9c4cd331] check-in: [eaeb2b80] user: dan branch: onepass-delete, size: 12516
2015-09-11
20:54
Update evidence marks due to wording changes in requirements text. No changes to code. file: [69d2292d] check-in: [86781093] user: drh branch: trunk, size: 12534
2015-03-04
23:14
New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. file: [5f527a78] check-in: [c298ea0b] user: drh branch: trunk, size: 12534
2013-08-20
17:14
Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. file: [b2f22f3e] check-in: [ef192abb] user: dan branch: trunk, size: 10794
2013-06-12
17:08
"make test" now passing. file: [0e959308] check-in: [addd7f46] user: drh branch: nextgen-query-plan-exp, size: 9129
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: [e06e1bf5] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 9236
2011-01-28
01:57
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. file: [be501e38] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 9573
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: [d7367c5a] check-in: [6611b76b] user: dan branch: experimental, size: 9573
2010-11-11
10:36
Modifications to test cases to account for new EXPLAIN QUERY PLAN output. file: [cd781337] check-in: [30904ef8] user: dan branch: experimental, size: 9477
2010-08-04
21:17
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] file: [5a118060] check-in: [e7a714b5] user: drh branch: trunk, size: 8366
2009-03-22
20:36
Allow the keyword INDEXED to be used as the name of a table or index or column - for backwards compatibility. (CVS 6370) file: [946ca262] check-in: [53149c9f] user: drh branch: trunk, size: 8100
2008-12-30
09:45
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) file: [bcf239cc] check-in: [f8ff0212] user: danielk1977 branch: trunk, size: 7497
2008-10-06
16:18
Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) file: [03af5237] check-in: [83a7e446] user: danielk1977 branch: trunk, size: 6862
11:29
Add a test to indexedby.test to check that automatic indexes (sqlite_autoindex_xxx) can be used with the INDEXED BY syntax. (CVS 5767) file: [5e54a6b2] check-in: [bb51c345] user: danielk1977 branch: trunk, size: 5379
05:32
Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) file: [b3fde1ae] check-in: [98ca5580] user: danielk1977 branch: trunk, size: 4734 Added