/ All files named "test/analyze9.test"
Login

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

History for test/analyze9.test

2019-04-17
23:56
[ff43df87] part of check-in [1f1866d1] Fix a couple minor test issues. (check-in: [1f1866d1] user: mistachkin branch: msvc, size: 34315)
2018-05-02
14:24
[9fbf0e01] part of check-in [82ca44b8] 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: [82ca44b8] user: drh branch: rework-EQP, size: 34313)
2017-10-15
22:16
[dac0bdc7] part of check-in [ee31c043] 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: [ee31c043] user: drh branch: trunk, size: 34405)
2016-03-01
22:41
[b817b8e7] part of check-in [13a37fd4] Improved debugging output with wheretrace. Fix some typos in test script comments. (check-in: [13a37fd4] user: drh branch: trunk, size: 34238)
2016-02-05
16:46
[88c1f2aa] part of check-in [a6b35273] From test scripts, remove stray "breakpoint" commands and blank lines at the ends of files. (check-in: [a6b35273] user: drh branch: trunk, size: 34240)
2015-03-16
09:21
[3dd9e203] part of check-in [f2207a06] Another test case for the planner change on this branch. (check-in: [f2207a06] user: dan branch: stat4-change, size: 34243)
2015-03-14
18:59
[2f6cfeae] part of check-in [e1caf93c] 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: [e1caf93c] user: dan branch: stat4-change, size: 32855)
2014-08-25
18:29
[72795c81] part of check-in [e06dc6f0] 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: [e06dc6f0] user: dan branch: trunk, size: 31146)
2014-07-22
14:58
[3ef1b471] part of check-in [ca2a5a2c] Enhance the sqlite_stat1.stat parsing to allow additional text parameters at the end. Unrecognized parameters are silently ignored. (check-in: [ca2a5a2c] user: drh branch: trunk, size: 29617)
2014-07-01
15:22
[bd5aaf2a] part of check-in [0df1fe72] Add another test to verify that SQLite is using stat4 data for composite primary keys on WITHOUT ROWID tables. (check-in: [0df1fe72] user: dan branch: trunk, size: 29619)
11:54
[3129cc8a] part of check-in [21981e35] 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: [21981e35] user: dan branch: trunk, size: 28885)
2014-06-30
18:02
[93619368] part of check-in [053a210e] Fix a problem in where.c with using the stat4 sample data of an index on a WITHOUT ROWID table. (check-in: [053a210e] user: dan branch: stat4-without-rowid, size: 27890)
2014-04-28
12:08
[623e02a9] part of check-in [1b95544f] Add an extra column to a table in analyze9.test to give the planner a little more reason to select an index. (check-in: [1b95544f] user: dan branch: experimental-costs, size: 25972)
2014-04-24
20:04
[e219daa5] part of check-in [c5a6ec0a] Changes to the way the planner calculates the costs of various table and index scans. Some test cases still failing. (check-in: [c5a6ec0a] user: dan branch: experimental-costs, size: 25969)
2014-02-28
18:39
[e072a517] part of check-in [3a09f560] Update some test cases that deal with corrupt databases. (check-in: [3a09f560] user: dan branch: experimental, size: 25969)
2013-11-20
19:28
[339e8772] part of check-in [0e3f5df6] Further performance tweaks to OP_Column. (check-in: [0e3f5df6] user: drh branch: OP_Column-refactor, size: 25921)
2013-09-11
03:53
[1b9b7e9a] part of check-in [52d52688] Tweaks to the index selection logic. (check-in: [52d52688] user: drh branch: unlikely-func, size: 25870)
2013-09-10
01:53
[a2c83301] part of check-in [a51d7515] Merge trunk fixes into the unlikely-func branch. (check-in: [a51d7515] user: drh branch: unlikely-func, size: 25889)
01:41
[ed70f0c1] part of check-in [48ed8b56] 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: [48ed8b56] user: drh branch: trunk, size: 25867)
2013-09-06
15:23
[e688c728] part of check-in [036fc37a] Initial implementation of the unlikely() SQL function used as a hint to the query planner. (check-in: [036fc37a] user: drh branch: unlikely-func, size: 25889)
2013-09-03
14:43
[4a48461d] part of check-in [d59f5809] Fix another problem in stat4 sample selection. (check-in: [d59f5809] user: dan branch: trunk, size: 25868)
2013-09-02
18:58
[3b23fc97] part of check-in [0a702c4b] Further stat4 related tests. (check-in: [0a702c4b] user: dan branch: trunk, size: 24946)
11:52
[bce50d74] part of check-in [17584299] Add tests to check if ANALYZE is choosing common non-periodic samples for the stat4 table. (check-in: [17584299] user: dan branch: trunk, size: 19448)
07:16
[c4717447] part of check-in [c21f58d8] 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: [c21f58d8] user: dan branch: trunk, size: 16588)
2013-08-31
17:21
[2bc3fb7b] part of check-in [1e86d81d] 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: [1e86d81d] user: dan branch: trunk, size: 14834)
2013-08-16
17:46
[3095a9eb] part of check-in [5c591104] Add a test for the problem fixed by [91733bc485]. (check-in: [5c591104] user: dan branch: sqlite_stat4, size: 11191)
14:48
[8a7880f2] part of check-in [fe99494d] 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: [fe99494d] user: dan branch: sqlite_stat4, size: 10029)
14:23
[0e25a960] part of check-in [949127d5] Add extra tests. No code changes. (check-in: [949127d5] user: dan branch: sqlite_stat4, size: 9609)
14:09
[baeb1ac3] part of check-in [9f85b6a5] Avoid buffer overreads and false OOM error reports that could be caused by corrupted sample records in the sqlite_stat4 table. (check-in: [9f85b6a5] user: dan branch: sqlite_stat4, size: 9187)
2013-08-15
19:56
[b73f9514] part of check-in [d51df8a8] Fix a crash that can occur if the sqlite_stat3 or sqlite_stat4 table is corrupt. (check-in: [d51df8a8] user: dan branch: sqlite_stat4, size: 8459)
18:43
[83e74db4] part of check-in [9f80b268] Fix a crash that can occur following an OOM fault. (check-in: [9f80b268] user: dan branch: sqlite_stat4, size: 7743)
16:18
[b018c837] part of check-in [71070c9f] 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: [71070c9f] user: dan branch: sqlite_stat4, size: 7266)
14:39
[f75d1f2e] part of check-in [1fb4d9d6] Add tests for sqlite_stat4 sample selection. And a fix for the same. (check-in: [1fb4d9d6] user: dan branch: sqlite_stat4, size: 7042)
2013-08-12
16:34
[1b419d03] part of check-in [6d45078e] Re-enable reading from the sqlite_stat3 table (as well as sqlite_stat4). (check-in: [6d45078e] user: dan branch: sqlite_stat4, size: 4090)
2013-08-10
19:08
[3e1bd020] part of check-in [3a5e8ab7] Add the rowid field to the end of sample records stored in the sqlite_stat4 table. (check-in: [3a5e8ab7] user: dan branch: sqlite_stat4, size: 3986)
2013-08-06
20:15
[1ed4e7d9] part of check-in [84999e27] Fixes for builds without SQLITE_ENABLE_STAT4. (check-in: [84999e27] user: dan branch: sqlite_stat4, size: 2752)
2013-08-05
18:00
[30479ec9] part of check-in [3a71afe6] 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: [3a71afe6] user: dan branch: sqlite_stat4, size: 2707)
05:34
[2ffe8f62] part of check-in [badd24d9] Fix a couple of problems in code related to sqlite_stat4. (check-in: [badd24d9] user: dan branch: sqlite_stat4, size: 1231)
2013-08-03
20:24
Added: [238e3d1f] part of check-in [2beea303] Begin adding experimental sqlite_stat4 table. This commit is buggy. (check-in: [2beea303] user: dan branch: sqlite_stat4, size: 1194)