SQLite

All files named ”test/analyze6.test”
Login

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

History for test/analyze6.test

2021-03-20
15:11
[028f5bdfc9] 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: 3925)
2019-08-08
15:24
[6c3f7df299] part of check-in [1e17ea2fd1] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 4003)
2018-05-02
19:42
[7b2667b879] part of check-in [dab5e52948] More test case updates. Tests are all running now. (check-in: [dab5e52948] user: drh branch: rework-EQP, size: 4011)
2014-07-22
14:42
[f1c552ce39] part of check-in [b083a961f8] Expire prepared statements after running ANALYZE. (check-in: [b083a961f8] user: drh branch: trunk, size: 4052)
2013-10-04
02:36
[d31defa011] part of check-in [6c352edbba] Progress toward using the iScanRatio information on indices. Many tests are still failing. (check-in: [6c352edbba] user: drh branch: index-scan-rate, size: 4036)
2013-08-12
20:14
[19151da2c4] part of check-in [cca8bf4372] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf4372] user: dan branch: sqlite_stat4, size: 4012)
2013-08-03
20:24
[3c01e08430] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 4004)
2013-06-10
23:30
[cdbf9887d4] 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: 4004)
2012-09-15
18:45
[aa8dae5066] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 4141)
2011-08-26
13:52
[c35da530ac] part of check-in [0df04f920b] Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. (check-in: [0df04f920b] user: drh branch: stat3-3.7.2, size: 2292)
2011-08-15
12:58
[bd3625806a] part of check-in [2504bcfb0c] Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. (check-in: [2504bcfb0c] user: drh branch: stat3-enhancement, size: 4089)
2011-03-30
14:54
[c125622a81] part of check-in [3a27af5b3c] Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] (check-in: [3a27af5b3c] user: drh branch: trunk, size: 4089)
2011-03-04
00:56
Added: [1ba1aea8fa] part of check-in [952f5e8c69] Do a better job of choosing the join table order when the tables having very different numbers of rows. (check-in: [952f5e8c69] user: drh branch: trunk, size: 2292)