/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/analyze8.test

2019-08-08
15:24
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. file: [36ce5494] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 3685
2018-05-02
19:42
More test case updates. Tests are all running now. file: [e32a9705] check-in: [dab5e529] user: drh branch: rework-EQP, size: 3693
2014-11-05
19:26
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. file: [c05a461d] check-in: [2d36be5d] user: drh branch: trunk, size: 3737
2013-08-14
19:54
Change the way ANALYZE works to use a single cursor when scanning indices. file: [093d15c1] check-in: [bdce612b] user: dan branch: sqlite_stat4, size: 3737
2013-08-12
20:14
If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. file: [f3afd910] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 3738
2013-08-08
11:48
Fix a bug in using stat4 data to estimate the number of rows selected by a range constraint. file: [8d1f76ff] check-in: [f783938e] user: dan branch: sqlite_stat4, size: 3730
2013-08-03
20:24
Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [09242543] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 3162
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [ea4972c7] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 3162
2011-08-16
01:15
Add the analyze8.test test module for sqlite_stat3. file: [4ca170de] check-in: [2c83ac89] user: drh branch: stat3-enhancement, size: 3273 Added
2011-08-07
00:21
The ANALYZE command adds the sqlite_stat2.cnt column if it does not already exist. file: [fbb37856] check-in: [794fde6f] user: drh branch: query-planner-tweaks, size: 5416
2011-08-06
19:48
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. file: [8a9c83bf] check-in: [6d1e2372] user: drh branch: query-planner-tweaks, size: 4568
01:22
Fix a compiler warning when STAT2 is off. More test cases. Fix legacy tests to deal with the new STAT2 logic. file: [ff7a3b46] check-in: [7e914aa9] user: drh branch: query-planner-tweaks, size: 4555
2011-08-05
22:31
Bug fixes to the sample-count logic for STAT2. A few test cases added. file: [e78fb002] check-in: [e93c248c] user: drh branch: query-planner-tweaks, size: 2333 Added