Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for test/analyze9.test
2022-05-09
| ||
17:55 | [30e1cb9933] part of check-in [8ce2fecb58] Minor STAT4 test case change due to the ANALYZE enhancement of [eb59c46a5aed69bc|check-in eb59c46a5aed69bc]. (check-in: [8ce2fecb58] user: drh branch: trunk, size: 34223) | |
2021-03-20
| ||
15:11 | [162cd40d71] 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: 34223) | |
2019-04-17
| ||
23:56 | [ff43df879a] part of check-in [1f1866d11c] Fix a couple minor test issues. (check-in: [1f1866d11c] user: mistachkin branch: msvc, size: 34315) | |
2018-05-02
| ||
14:24 | [9fbf0e0101] 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: 34313) | |
2017-10-15
| ||
22:16 | [dac0bdc7ea] part of check-in [ee31c04353] In the query planner, do not consider index X to be a proper subset of index Y if X is a covering index but Y is not. (check-in: [ee31c04353] user: drh branch: trunk, size: 34405) | |
2016-03-01
| ||
22:41 | [b817b8e798] part of check-in [13a37fd487] Improved debugging output with wheretrace. Fix some typos in test script comments. (check-in: [13a37fd487] user: drh branch: trunk, size: 34238) | |
2016-02-05
| ||
16:46 | [88c1f2aa20] part of check-in [a6b3527323] From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (check-in: [a6b3527323] user: drh branch: trunk, size: 34240) | |
2015-03-16
| ||
09:21 | [3dd9e203fa] part of check-in [f2207a0691] Another test case for the planner change on this branch. (check-in: [f2207a0691] user: dan branch: stat4-change, size: 34243) | |
2015-03-14
| ||
18:59 | [2f6cfeae1f] part of check-in [e1caf93c9a] When estimating the number of rows visited by a range scan for which the keys consist of more than one field, consider prefixes of stat4 samples as well as the full samples. (check-in: [e1caf93c9a] user: dan branch: stat4-change, size: 32855) | |
2014-08-25
| ||
18:29 | [72795c8113] part of check-in [e06dc6f0c3] In cases where stat4 data is available but cannot be used because the rhs of a range constraint is too complex a expression, fall back to using the default estimates for number of rows scanned. (check-in: [e06dc6f0c3] user: dan branch: trunk, size: 31146) | |
2014-07-22
| ||
14:58 | [3ef1b47124] part of check-in [ca2a5a2c77] Enhance the sqlite_stat1.stat parsing to allow additional text parameters at the end. Unrecognized parameters are silently ignored. (check-in: [ca2a5a2c77] user: drh branch: trunk, size: 29617) | |
2014-07-01
| ||
15:22 | [bd5aaf2a8f] part of check-in [0df1fe72f8] Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables. (check-in: [0df1fe72f8] user: dan branch: trunk, size: 29619) | |
11:54 | [3129cc8a82] part of check-in [21981e3506] Ensure that all fields are loaded from the stat4 table for records that correspond to indexes on WITHOUT ROWID tables with composite primary keys. (check-in: [21981e3506] user: dan branch: trunk, size: 28885) | |
2014-06-30
| ||
18:02 | [93619368ff] part of check-in [053a210e31] Fix a problem in where.c with using the stat4 sample data of an index on a WITHOUT ROWID table. (check-in: [053a210e31] user: dan branch: stat4-without-rowid, size: 27890) | |
2014-04-28
| ||
12:08 | [623e02a99a] part of check-in [1b95544f84] Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. (check-in: [1b95544f84] user: dan branch: experimental-costs, size: 25972) | |
2014-04-24
| ||
20:04 | [e219daa58f] part of check-in [c5a6ec0a88] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (check-in: [c5a6ec0a88] user: dan branch: experimental-costs, size: 25969) | |
2014-02-28
| ||
18:39 | [e072a5172d] part of check-in [3a09f5605a] Update some test cases that deal with corrupt databases. (check-in: [3a09f5605a] user: dan branch: experimental, size: 25969) | |
2013-11-20
| ||
19:28 | [339e87723c] part of check-in [0e3f5df695] Further performance tweaks to OP_Column. (check-in: [0e3f5df695] user: drh branch: OP_Column-refactor, size: 25921) | |
2013-09-11
| ||
03:53 | [1b9b7e9a09] part of check-in [52d5268864] Tweaks to the index selection logic. (check-in: [52d5268864] user: drh branch: unlikely-func, size: 25870) | |
2013-09-10
| ||
01:53 | [a2c8330116] part of check-in [a51d751553] Merge trunk fixes into the unlikely-func branch. (check-in: [a51d751553] user: drh branch: unlikely-func, size: 25889) | |
01:41 | [ed70f0c105] part of check-in [48ed8b565b] Deterministically initialize the PRNG used as a tie-breaker in the ANALYZE command, so that the analysis is always the same given the same database. This simplifies testing. (check-in: [48ed8b565b] user: drh branch: trunk, size: 25867) | |
2013-09-06
| ||
15:23 | [e688c7289d] part of check-in [036fc37a03] Initial implementation of the unlikely() SQL function used as a hint to the query planner. (check-in: [036fc37a03] user: drh branch: unlikely-func, size: 25889) | |
2013-09-03
| ||
14:43 | [4a48461d71] part of check-in [d59f580904] Fix another problem in stat4 sample selection. (check-in: [d59f580904] user: dan branch: trunk, size: 25868) | |
2013-09-02
| ||
18:58 | [3b23fc97bc] part of check-in [0a702c4b4c] Further stat4 related tests. (check-in: [0a702c4b4c] user: dan branch: trunk, size: 24946) | |
11:52 | [bce50d7448] part of check-in [175842997a] Add tests to check if ANALYZE is choosing common non-periodic samples for the stat4 table. (check-in: [175842997a] user: dan branch: trunk, size: 19448) | |
07:16 | [c471744773] part of check-in [c21f58d848] Fix a problem with using stat4 data to estimate the number of rows scanned by a range constraint on the second or subsequent column of any index where an affinity transformation must be applied to the constraint argument. (check-in: [c21f58d848] user: dan branch: trunk, size: 16588) | |
2013-08-31
| ||
17:21 | [2bc3fb7b0b] part of check-in [1e86d81d46] Fix a problem causing SQLite not to use stat4 or stat3 data to analyze constraints of the form "column = expr COLLATE collation" (those with an explicit COLLATE on the non-column side of the comparison operator). (check-in: [1e86d81d46] user: dan branch: trunk, size: 14834) | |
2013-08-16
| ||
17:46 | [3095a9ebfe] part of check-in [5c59110481] Add a test for the problem fixed by [91733bc485]. (check-in: [5c59110481] user: dan branch: sqlite_stat4, size: 11191) | |
14:48 | [8a7880f295] part of check-in [fe99494d99] Fixes for test code that was not working with utf16 databases. Run the analyze*.test scripts as part of the 'utf16' permutation test. (check-in: [fe99494d99] user: dan branch: sqlite_stat4, size: 10029) | |
14:23 | [0e25a96008] part of check-in [949127d53e] Add extra tests. No code changes. (check-in: [949127d53e] user: dan branch: sqlite_stat4, size: 9609) | |
14:09 | [baeb1ac3f2] part of check-in [9f85b6a52a] Avoid buffer overreads and false OOM error reports that could be caused by corrupted sample records in the sqlite_stat4 table. (check-in: [9f85b6a52a] user: dan branch: sqlite_stat4, size: 9187) | |
2013-08-15
| ||
19:56 | [b73f9514af] part of check-in [d51df8a8fc] Fix a crash that can occur if the sqlite_stat3 or sqlite_stat4 table is corrupt. (check-in: [d51df8a8fc] user: dan branch: sqlite_stat4, size: 8459) | |
18:43 | [83e74db42a] part of check-in [9f80b26870] Fix a crash that can occur following an OOM fault. (check-in: [9f80b26870] user: dan branch: sqlite_stat4, size: 7743) | |
16:18 | [b018c83716] part of check-in [71070c9fce] Change some assert() statements in vdbe.c to ensure that a memory cell used to store a VdbeCursor object is not also used for some other purpose. (check-in: [71070c9fce] user: dan branch: sqlite_stat4, size: 7266) | |
14:39 | [f75d1f2edd] part of check-in [1fb4d9d6f2] Add tests for sqlite_stat4 sample selection. And a fix for the same. (check-in: [1fb4d9d6f2] user: dan branch: sqlite_stat4, size: 7042) | |
2013-08-12
| ||
16:34 | [1b419d0340] part of check-in [6d45078e62] Re-enable reading from the sqlite_stat3 table (as well as sqlite_stat4). (check-in: [6d45078e62] user: dan branch: sqlite_stat4, size: 4090) | |
2013-08-10
| ||
19:08 | [3e1bd02093] 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: 3986) | |
2013-08-06
| ||
20:15 | [1ed4e7d95d] part of check-in [84999e27cc] Fixes for builds without SQLITE_ENABLE_STAT4. (check-in: [84999e27cc] user: dan branch: sqlite_stat4, size: 2752) | |
2013-08-05
| ||
18:00 | [30479ec9ac] part of check-in [3a71afe674] Use N separate cursors when scanning an index with N columns to collect sqlite_stat4 data. This fixes a problem with collecting incorrect nEq values from multi-column indexes. (check-in: [3a71afe674] user: dan branch: sqlite_stat4, size: 2707) | |
05:34 | [2ffe8f627b] part of check-in [badd24d987] Fix a couple of problems in code related to sqlite_stat4. (check-in: [badd24d987] user: dan branch: sqlite_stat4, size: 1231) | |
2013-08-03
| ||
20:24 | Added: [238e3d1fa1] part of check-in [2beea303a1] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303a1] user: dan branch: sqlite_stat4, size: 1194) | |