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 | |