SQLite

All files named ”test/analyze8.test”
Login

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

History for test/analyze8.test

2021-03-20
15:11
[29ef237d8a] 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: 3619)
2019-08-08
15:24
[36ce549477] 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: 3685)
2018-05-02
19:42
[e32a970564] part of check-in [dab5e52948] More test case updates. Tests are all running now. (check-in: [dab5e52948] user: drh branch: rework-EQP, size: 3693)
2014-11-05
19:26
[c05a461d0a] part of check-in [2d36be5d9a] Change the query planner to do a better job of estimating the number rows selected by a BETWEEN operator using STAT4 when both upper and lower bounds are contained within the same sample. (check-in: [2d36be5d9a] user: drh branch: trunk, size: 3737)
2013-08-14
19:54
[093d15c1c8] part of check-in [bdce612b35] Change the way ANALYZE works to use a single cursor when scanning indices. (check-in: [bdce612b35] user: dan branch: sqlite_stat4, size: 3737)
2013-08-12
20:14
[f3afd910c0] 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: 3738)
2013-08-08
11:48
[8d1f76ff1e] part of check-in [f783938ea9] Fix a bug in using stat4 data to estimate the number of rows selected by a range constraint. (check-in: [f783938ea9] user: dan branch: sqlite_stat4, size: 3730)
2013-08-03
20:24
[092425439c] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 3162)
2013-06-10
23:30
[ea4972c768] 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: 3162)
2011-08-16
01:15
Added: [4ca170de2b] part of check-in [2c83ac89dc] Add the analyze8.test test module for sqlite_stat3. (check-in: [2c83ac89dc] user: drh branch: stat3-enhancement, size: 3273)
2011-08-07
00:21
[fbb378563e] part of check-in [794fde6f91] The ANALYZE command adds the sqlite_stat2.cnt column if it does not already exist. (check-in: [794fde6f91] user: drh branch: query-planner-tweaks, size: 5416)
2011-08-06
19:48
[8a9c83bf73] part of check-in [6d1e2372fe] The sqlite_stat2.cnt field is parsed if it is present. But it is not yet used. A large comment added to analyze.c to explain the format of the ANALYZE system tables. (check-in: [6d1e2372fe] user: drh branch: query-planner-tweaks, size: 4568)
01:22
[ff7a3b4631] part of check-in [7e914aa999] Fix a compiler warning when STAT2 is off. More test cases. Fix legacy tests to deal with the new STAT2 logic. (check-in: [7e914aa999] user: drh branch: query-planner-tweaks, size: 4555)
2011-08-05
22:31
Added: [e78fb00274] part of check-in [e93c248c84] Bug fixes to the sample-count logic for STAT2. A few test cases added. (check-in: [e93c248c84] user: drh branch: query-planner-tweaks, size: 2333)