/ File History
Login

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

History of test/analyze2.test

2011-08-06
01:22
Fix a compiler warning when STAT2 is off. More test cases. Fix legacy tests to deal with the new STAT2 logic. file: [b2c53cf7] check-in: [7e914aa9] user: drh branch: query-planner-tweaks, size: 18073
2011-08-05
21:13
Add a column to the sqlite_stat2 table that contains the number of entries with exactly the same key as the sample. We do not yet do anything with this extra value. Some tests in analyze2.test are failing. file: [6a5c1420] check-in: [eb434228] user: drh branch: query-planner-tweaks, size: 18063
2011-02-12
14:23
Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. file: [ea3df826] check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 18220
2011-01-28
01:57
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. file: [8f2b1534] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 18040
2011-01-20
02:56
The first of a planned series of enhancements to the query planner that enable it to make better use of sqlite_stat2 histograms when the table has many repeated values. file: [f45ac8d5] check-in: [2cd374cd] user: drh branch: stat2-enhancement, size: 17979
2010-11-15
16:12
Change some test cases to account for the new EXPLAIN QUERY PLAN output. file: [3bde8f08] check-in: [88a854e1] user: dan branch: trunk, size: 17978
2010-06-22
13:46
Some changes to test scripts related to codec enabled versions of sqlite. file: [59dac6c3] check-in: [85dd51a7] user: dan branch: trunk, size: 15992
2009-09-21
16:34
Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. file: [a2ad7b0a] check-in: [cd850d49] user: dan branch: trunk, size: 15827
2009-08-20
16:11
Change the code that collects samples for sqlite_stat2 so that the first sample taken is the (nRow/(2*SQLITE_INDEX_SAMPLES))th entry in the index, where nRow is the total number of index entries. file: [297d3d63] check-in: [cbfe6e9d] user: dan branch: trunk, size: 15725
2009-08-19
15:34
Add some tests that use the sqlite_stat2 table in shared-cache mode. file: [f3c0944b] check-in: [29cafcfd] user: dan branch: trunk, size: 15721
14:34
Clean up sqlite_stat2 related code. Add test cases. file: [eb66cbd9] check-in: [aa728e06] user: dan branch: trunk, size: 12567
08:18
Add the SQLITE_ENABLE_STAT2 macro. If this is not defined at build-time, the stat2 table is not created, populated, or used. file: [f58acc55] check-in: [362665e8] user: dan branch: trunk, size: 7352
2009-08-18
16:24
Change the sqlite_stat2 schema to be more flexible. file: [30987f59] check-in: [ded9dec6] user: dan branch: trunk, size: 7345 Added