SQLite

All files named ”test/analyze3.test”
Login

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

History for test/analyze3.test

2025-02-27
21:17
[c5156cef33] part of check-in [f50c21484d] Approximately 100 typo corrections spanning the whole tree, submitted via forum post 0db9827f0464bc33 and individually audited and verified. Affects only code comments, innocuous test strings, error message text in tool (not library) code, and configure-level help text. (check-in: [f50c21484d] user: stephan branch: trunk, size: 21667)
2023-05-03
05:00
[03f4b3d794] part of check-in [9350a25ac0] Do not overflow the Index.aSample[] array if the same index appears in the sqlite_stat4 table under multiple names because it is a WITHOUT ROWID primary key index. Forum post 537d8ab118df7edd (check-in: [9350a25ac0] user: drh branch: trunk, size: 21666)
2023-04-22
22:32
[d4e09dc556] part of check-in [f097ca70b5] The sqlite_stat4.idx field is case insensitive. It should work even if some entries use a different case than others. Fix for forum post 6c118daad0f1f5ef. (check-in: [f097ca70b5] user: drh branch: trunk, size: 21223)
2021-03-20
15:11
[4440c49322] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 20743)
2020-08-27
14:53
[fca2a9de00] part of check-in [f7f13cb1bc] Do not attempt to run test script analyze3.test as part of the "prepare" permutation. (check-in: [f7f13cb1bc] user: dan branch: trunk, size: 20833)
2020-07-29
16:18
[cb115a083b] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 20460)
2019-08-08
15:24
[01f0b122e3] part of check-in [1e17ea2fd1] 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. (check-in: [1e17ea2fd1] user: drh branch: omit-stat3, size: 20459)
2018-05-02
14:24
[ff62d9029e] part of check-in [82ca44b82f] Fix a dangling-else problem that was causing recursive CTEs to malfunction. Begin fixing test cases to work with the new EQP output. (check-in: [82ca44b82f] user: drh branch: rework-EQP, size: 20557)
2017-06-26
13:57
[8b3ef8ba6d] part of check-in [7076e8283e] 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. (check-in: [7076e8283e] user: drh branch: enable-QPSG, size: 20677)
2017-06-07
10:55
[d35cffa940] part of check-in [c81f260c2d] 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. (check-in: [c81f260c2d] user: drh branch: analyze-empty-tables, size: 19772)
2015-12-01
21:23
[1dccda46a6] part of check-in [9e1d6d4c39] Add the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option. (check-in: [9e1d6d4c39] user: drh branch: trunk, size: 19757)
2015-04-20
15:13
[0f0ee6135b] part of check-in [2f58c8c972] Fix a memory leak caused by duplicate entries in the sqlite_stat1 table. (check-in: [2f58c8c972] user: dan branch: trunk, size: 19486)
13:59
[c2c07285e1] part of check-in [c72abbe2c1] Fix an obscure memory leak in sqlite3Stat4ProbeFree() (check-in: [c72abbe2c1] user: drh branch: trunk, size: 18993)
2015-03-06
20:49
[75b9e42ea1] part of check-in [6b993bd540] Test cases added. Comments fixed. Proposed solution for ticket [05f43be8fdda9fbd9]. (check-in: [6b993bd540] user: drh branch: like-opt-fix, size: 18581)
2014-04-28
10:00
[bf41f0f680] part of check-in [35f46a55d8] 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. (check-in: [35f46a55d8] user: dan branch: experimental-costs, size: 18579)
2013-08-12
20:14
[412f690dfe] part of check-in [cca8bf4372] If ENABLE_STAT3 is defined but ENABLE_STAT4 is not, have ANALYZE create and populate the sqlite_stat3 table instead of sqlite_stat4. (check-in: [cca8bf4372] user: dan branch: sqlite_stat4, size: 18032)
2013-08-10
19:08
[ea4cba3277] part of check-in [3a5e8ab7dd] Add the rowid field to the end of sample records stored in the sqlite_stat4 table. (check-in: [3a5e8ab7dd] user: dan branch: sqlite_stat4, size: 17939)
2013-08-03
20:24
[4532e5475d] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 17882)
2013-08-01
17:43
[53cfd07625] part of check-in [65816718b5] Add test case for the problem fixed by [127a5b776d]. (check-in: [65816718b5] user: dan branch: trunk, size: 17882)
2013-06-10
23:30
[69863b4465] part of check-in [aa580e368e] Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. (check-in: [aa580e368e] user: drh branch: nextgen-query-plan-logcost, size: 17125)
2011-10-21
19:06
[c3c7f6c395] part of check-in [aed2bf7a3c] Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: [aed2bf7a3c] user: drh branch: trunk, size: 17226)
2011-08-26
18:04
[9be0af5e23] part of check-in [a42db19d52] Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. (check-in: [a42db19d52] user: drh branch: stat3-3.7.2, size: 17226)
2011-08-15
12:58
[7bcadc4758] part of check-in [2504bcfb0c] Update some test cases to work with sqlite_stat3 instead of sqlite_stat2. (check-in: [2504bcfb0c] user: drh branch: stat3-enhancement, size: 17226)
2011-08-13
19:35
[d5e4da00a3] part of check-in [89b2f70884] 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. (check-in: [89b2f70884] user: drh branch: stat3-enhancement, size: 17173)
2011-01-28
01:57
[d61f55d8b4] 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: 17142)
2010-11-15
16:12
[820ddfb759] 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: 17142)
2010-08-02
14:32
[6d4f4b0929] part of check-in [03a240514a] Experimental refactoring of the Pager object state. This version is surely buggy. (check-in: [03a240514a] user: dan branch: experimental, size: 16948)
2010-07-22
12:33
[535bf0762f] part of check-in [613a87d62f] Try to optimize LIKE and GLOB operators when RHS contains no wildcard. Ticket [e090183531fc274747] (check-in: [613a87d62f] user: drh branch: trunk, size: 16959)
2010-02-24
19:23
[5062038752] part of check-in [69a493182f] 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. (check-in: [69a493182f] user: drh branch: trunk, size: 16516)
2009-11-12
19:59
[ae06e0f8b3] part of check-in [b9eab885cd] 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. (check-in: [b9eab885cd] user: drh branch: trunk, size: 16526)
2009-10-20
07:01
[851bcc0738] part of check-in [e6808c988c] Fix cases where modifying bound variables using the clear_bindings() or transfer_bindings() APIs can invalidate a query plan. (check-in: [e6808c988c] user: dan branch: trunk, size: 16527)
2009-10-19
18:11
[5c87ca746d] part of check-in [2c50b3d5aa] Remove the sqlite3_reoptimize() API. The same functionality is now provided automatically to queries prepared using prepare_v2(). (check-in: [2c50b3d5aa] user: dan branch: trunk, size: 14421)
2009-10-16
15:59
[2f00779be9] part of check-in [61174aea74] Fix a problem in the analyze3.test script. (check-in: [61174aea74] user: dan branch: experimental, size: 16226)
2009-10-15
18:35
Added: [030efdbb01] part of check-in [9bd6f3d886] Add the experimental sqlite3_reoptimize() API. (check-in: [9bd6f3d886] user: dan branch: experimental, size: 16246)