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