Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/analyze3.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: [01f0b122] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 20459 | |
|
2018-05-02
| ||
| 14:24 | Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. file: [ff62d902] check-in: [82ca44b8] user: drh branch: rework-EQP, size: 20557 | |
|
2017-06-26
| ||
| 13:57 | Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. file: [8b3ef8ba] check-in: [7076e828] user: drh branch: enable-QPSG, size: 20677 | |
|
2017-06-07
| ||
| 10:55 | Cause the ANALYZE command to build sqlite_stat1 table entries for empty tables with the assumption that such tables really contain 10 elements. This gives better query plans for tables that are truely empty, but is likely to cause problems in legacy systems, so the change is kept off trunk. Some TCL tests fail on this check-in due to the new stat1 entries. file: [d35cffa9] check-in: [c81f260c] user: drh branch: analyze-empty-tables, size: 19772 | |
|
2015-12-01
| ||
| 21:23 | Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. file: [1dccda46] check-in: [9e1d6d4c] user: drh branch: trunk, size: 19757 | |
|
2015-04-20
| ||
| 15:13 | Fix a memory leak caused by duplicate entries in the sqlite_stat1 table. file: [0f0ee613] check-in: [2f58c8c9] user: dan branch: trunk, size: 19486 | |
| 13:59 | Fix an obscure memory leak in sqlite3Stat4ProbeFree() file: [c2c07285] check-in: [c72abbe2] user: drh branch: trunk, size: 18993 | |
|
2015-03-06
| ||
| 20:49 | Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. file: [75b9e42e] check-in: [6b993bd5] user: drh branch: like-opt-fix, size: 18581 | |
|
2014-04-28
| ||
| 10:00 | Update test script analyze3.test to account for the fact that SQLite now prefers a full-table scan over a non-covering index scan that visits a large percentage of the table rows. file: [bf41f0f6] check-in: [35f46a55] user: dan branch: experimental-costs, size: 18579 | |
|
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: [412f690d] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 18032 | |
|
2013-08-10
| ||
| 19:08 | Add the rowid field to the end of sample records stored in the sqlite_stat4 table. file: [ea4cba32] check-in: [3a5e8ab7] user: dan branch: sqlite_stat4, size: 17939 | |
|
2013-08-03
| ||
| 20:24 | Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [4532e547] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 17882 | |
|
2013-08-01
| ||
| 17:43 | Add test case for the problem fixed by [127a5b776d]. file: [53cfd076] check-in: [65816718] user: dan branch: trunk, size: 17882 | |
|
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: [69863b44] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 17125 | |
|
2011-10-21
| ||
| 19:06 | Purge lingering references to SQLITE_STAT2 from the code and test scripts. file: [c3c7f6c3] check-in: [aed2bf7a] user: drh branch: trunk, size: 17226 | |
|
2011-08-26
| ||
| 18:04 | Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. file: [9be0af5e] check-in: [a42db19d] user: drh branch: stat3-3.7.2, size: 17226 | |
|
2011-08-15
| ||
| 12:58 | Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. file: [7bcadc47] check-in: [2504bcfb] user: drh branch: stat3-enhancement, size: 17226 | |
|
2011-08-13
| ||
| 19:35 | Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. file: [d5e4da00] check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 17173 | |
|
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: [d61f55d8] check-in: [4847c6cb] user: drh branch: stat2-enhancement, size: 17142 | |
|
2010-11-15
| ||
| 16:12 | Change some test cases to account for the new EXPLAIN QUERY PLAN output. file: [820ddfb7] check-in: [88a854e1] user: dan branch: trunk, size: 17142 | |
|
2010-08-02
| ||
| 14:32 | Experimental refactoring of the Pager object state. This version is surely buggy. file: [6d4f4b09] check-in: [03a24051] user: dan branch: experimental, size: 16948 | |
|
2010-07-22
| ||
| 12:33 | Try to optimize LIKE and GLOB operators when RHS contains no wildcard. Ticket [e090183531fc274747] file: [535bf076] check-in: [613a87d6] user: drh branch: trunk, size: 16959 | |
|
2010-02-24
| ||
| 19:23 | Add a sqlite3_log() call on anonymous constraint failures. Fix the output of test cases having to do with improved reprepare reporting. Fix the VACUUM command to report more helpful error messages when things go wrong. file: [50620387] check-in: [69a49318] user: drh branch: trunk, size: 16516 | |
|
2009-11-12
| ||
| 19:59 | Enhance the OP_Found and OP_NotFound opcodes so that they can accept an array of registers as an unpacked record in addition to a record built using OP_MakeRecord. Use this to avoid OP_MakeRecord calls during IN expression processing. file: [ae06e0f8] check-in: [b9eab885] user: drh branch: trunk, size: 16526 | |
|
2009-10-20
| ||
| 07:01 | Fix cases where modifying bound variables using the clear_bindings() or transfer_bindings() APIs can invalidate a query plan. file: [851bcc07] check-in: [e6808c98] user: dan branch: trunk, size: 16527 | |
|
2009-10-19
| ||
| 18:11 | Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). file: [5c87ca74] check-in: [2c50b3d5] user: dan branch: trunk, size: 14421 | |
|
2009-10-16
| ||
| 15:59 | Fix a problem in the analyze3.test script. file: [2f00779b] check-in: [61174aea] user: dan branch: experimental, size: 16226 | |
|
2009-10-15
| ||
| 18:35 | Add the experimental sqlite3_reoptimize() API. file: [030efdbb] check-in: [9bd6f3d8] user: dan branch: experimental, size: 16246 Added | |