SQLite

All files named ”test/autoindex3.test”
Login

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

History for test/autoindex3.test

2025-06-13
11:08
[0d78b07de5] part of check-in [40a83da503] Further improvements to the EQP text for flex-search. (check-in: [40a83da503] user: drh branch: flex-search, size: 4149)
00:50
[5ac57438d9] part of check-in [680e278c3e] Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: [680e278c3e] user: drh branch: flex-search, size: 4138)
2025-06-12
19:02
[4d0a7a4126] part of check-in [521948c64f] Preliminary code generation for flex-search. Add a no-op IfUseIndex opcode as a placeholder. (check-in: [521948c64f] user: drh branch: flex-search, size: 4129)
2024-05-27
21:55
[ca502c8050] part of check-in [70409763f7] Avoid creating an automatic index on a column that is known to be not very selective. (check-in: [70409763f7] user: drh branch: auto-index-improvements, size: 4114)
2023-02-28
13:46
[dcd6b2f8be] part of check-in [d7b2ac1c1a] When an automatic index creates a Bloom filter, show that in the EXPLAIN QUERY PLAN output. (check-in: [d7b2ac1c1a] user: drh branch: trunk, size: 3009)
2021-03-20
15:11
[2d13958a56] 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: 2980)
2018-05-02
18:00
[2dd997d659] 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: 3004)
2014-11-14
19:34
[a3be0d1a53] part of check-in [93642a65ef] Consider using an automatic-index for a scan even if there exists a possible skip-scan that uses one or more "=" operators. (check-in: [93642a65ef] user: dan branch: experimental-autoindex-fix, size: 3002)
2014-06-17
20:16
Added: [8254f689c3] part of check-in [4ece839d44] Prevent an automatic index from taking the place of a declared index. (check-in: [4ece839d44] user: drh branch: autoindex-improvements, size: 1986)