Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
|
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) | |