SQLite

All files named ”test/analyze2.test”
Login

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

History for test/analyze2.test

2011-10-21
19:06
Deleted: Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: [aed2bf7a3c] user: drh branch: trunk, size: 0)
2011-08-06
01:22
[b2c53cf72a] 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: 18073)
2011-08-05
21:13
[6a5c1420bd] part of check-in [eb43422827] 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. (check-in: [eb43422827] user: drh branch: query-planner-tweaks, size: 18063)
2011-02-12
14:23
[ea3df82687] part of check-in [f2a8b5ccfb] 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. (check-in: [f2a8b5ccfb] user: drh branch: branch-3.7.2, size: 18220)
2011-01-28
01:57
[8f2b1534d4] part of check-in [4847c6cb71] 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. (check-in: [4847c6cb71] user: drh branch: stat2-enhancement, size: 18040)
2011-01-20
02:56
[f45ac8d54b] part of check-in [2cd374cd23] 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. (check-in: [2cd374cd23] user: drh branch: stat2-enhancement, size: 17979)
2010-11-15
16:12
[3bde8f0879] part of check-in [88a854e18f] Change some test cases to account for the new EXPLAIN QUERY PLAN output. (check-in: [88a854e18f] user: dan branch: trunk, size: 17978)
2010-06-22
13:46
[59dac6c399] part of check-in [85dd51a75c] Some changes to test scripts related to codec enabled versions of sqlite. (check-in: [85dd51a75c] user: dan branch: trunk, size: 15992)
2009-09-21
16:34
[a2ad7b0a4e] part of check-in [cd850d49a1] Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. (check-in: [cd850d49a1] user: dan branch: trunk, size: 15827)
2009-08-20
16:11
[297d3d63f2] part of check-in [cbfe6e9df3] 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. (check-in: [cbfe6e9df3] user: dan branch: trunk, size: 15725)
2009-08-19
15:34
[f3c0944b85] part of check-in [29cafcfdcc] Add some tests that use the sqlite_stat2 table in shared-cache mode. (check-in: [29cafcfdcc] user: dan branch: trunk, size: 15721)
14:34
[eb66cbd948] part of check-in [aa728e06ce] Clean up sqlite_stat2 related code. Add test cases. (check-in: [aa728e06ce] user: dan branch: trunk, size: 12567)
08:18
[f58acc55f5] part of check-in [362665e89c] Add the SQLITE_ENABLE_STAT2 macro. If this is not defined at build-time, the stat2 table is not created, populated, or used. (check-in: [362665e89c] user: dan branch: trunk, size: 7352)
2009-08-18
16:24
Added: [30987f595f] part of check-in [ded9dec645] Change the sqlite_stat2 schema to be more flexible. (check-in: [ded9dec645] user: dan branch: trunk, size: 7345)