/ File History
Login

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

History of test/analyze3.test

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