Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/indexedby.test
2025-02-27
| ||
21:17 | [444fb04ce0] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 12045) | |
2021-03-20
| ||
15:11 | [f21eca4f7a] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 12044) | |
2021-03-12
| ||
13:49 | [a3ca11f081] part of check-in [98d6715284] Fix broken requirement marks. (check-in: [98d6715284] user: drh branch: trunk, size: 12230) | |
2020-06-03
| ||
03:00 | [f54aac21c0] part of check-in [d901837fea] 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: [d901837fea] user: drh branch: trunk, size: 12228) | |
2018-05-04
| ||
18:32 | [a52c8c6abf] part of check-in [7fdad122a2] Fix requirements marks. No code changes. (check-in: [7fdad122a2] user: drh branch: trunk, size: 12400) | |
2018-05-02
| ||
18:00 | [5a4a451412] part of check-in [5f0e803e33] 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: [5f0e803e33] user: drh branch: rework-EQP, size: 12398) | |
2017-11-07
| ||
18:20 | [faa585e315] part of check-in [292a04086a] Fix a problem causing an INDEXED BY specifying an unusable partial index to be mishandled. (check-in: [292a04086a] user: dan branch: trunk, size: 13138) | |
2015-09-12
| ||
19:26 | [9c4cd33122] part of check-in [eaeb2b80f6] 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: [eaeb2b80f6] user: dan branch: onepass-delete, size: 12516) | |
2015-09-11
| ||
20:54 | [69d2292dfd] part of check-in [86781093bd] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093bd] user: drh branch: trunk, size: 12534) | |
2015-03-04
| ||
23:14 | [5f527a78ba] part of check-in [c298ea0bd9] New requirements marks on INSERT and INDEXED BY and on some sqlite3_config() options. (check-in: [c298ea0bd9] user: drh branch: trunk, size: 12534) | |
2013-08-20
| ||
17:14 | [b2f22f3e69] part of check-in [ef192abb82] Fix an invalid assert() in where.c. Also a crash that can occur in the EXPLAIN QUERY PLAN code under obscure circumstances. (check-in: [ef192abb82] user: dan branch: trunk, size: 10794) | |
2013-06-12
| ||
17:08 | [0e95930870] part of check-in [addd7f466d] "make test" now passing. (check-in: [addd7f466d] user: drh branch: nextgen-query-plan-exp, size: 9129) | |
2013-06-10
| ||
23:30 | [e06e1bf5a9] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 9236) | |
2011-01-28
| ||
01:57 | [be501e381b] part of check-in [4847c6cb71] 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: [4847c6cb71] user: drh branch: stat2-enhancement, size: 9573) | |
2010-11-13
| ||
16:42 | [d7367c5a0e] part of check-in [6611b76b02] 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: [6611b76b02] user: dan branch: experimental, size: 9573) | |
2010-11-11
| ||
10:36 | [cd78133723] part of check-in [30904ef841] Modifications to test cases to account for new EXPLAIN QUERY PLAN output. (check-in: [30904ef841] user: dan branch: experimental, size: 9477) | |
2010-08-04
| ||
21:17 | [5a1180602f] part of check-in [e7a714b52c] 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: [e7a714b52c] user: drh branch: trunk, size: 8366) | |
2009-03-22
| ||
20:36 | [946ca2628a] part of check-in [53149c9f5d] Allow the keyword INDEXED to be used as the name of a table or index or column - for backwards compatibility. (CVS 6370) (check-in: [53149c9f5d] user: drh branch: trunk, size: 8100) | |
2008-12-30
| ||
09:45 | [bcf239ccdc] part of check-in [f8ff021212] 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: [f8ff021212] user: danielk1977 branch: trunk, size: 7497) | |
2008-10-06
| ||
16:18 | [03af52375e] part of check-in [83a7e446b2] Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) (check-in: [83a7e446b2] user: danielk1977 branch: trunk, size: 6862) | |
11:29 | [5e54a6b25a] part of check-in [bb51c34506] 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: [bb51c34506] user: danielk1977 branch: trunk, size: 5379) | |
05:32 | Added: [b3fde1aed0] part of check-in [98ca5580f5] Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) (check-in: [98ca5580f5] user: danielk1977 branch: trunk, size: 4734) | |