Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/analyze.test
|
2019-08-08
| ||
| 15:24 | 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. file: [547bb700] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 9616 | |
|
2018-11-07
| ||
| 02:17 | Add the SQLITE_DEFAULT_DEFENSIVE compile-time option. Fix up test cases so that they work with DEFENSIVE enabled. file: [7168c8bf] check-in: [3212733c] user: drh branch: read-only-shadow, size: 9680 | |
|
2018-03-23
| ||
| 12:59 | Fix the ANALYZE command so that it will process tables whose names begin with "sqlite" as long as they do not being with "sqlite_". file: [b3a9c67d] check-in: [0249d9ae] user: drh branch: trunk, size: 9645 | |
|
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: [0e043e65] check-in: [c81f260c] user: drh branch: analyze-empty-tables, size: 9183 | |
|
2016-03-01
| ||
| 12:45 | Fix test cases to align with the improved stats computation. file: [6e7bb2c9] check-in: [810967bf] user: drh branch: analyze-worst-case, size: 9122 | |
|
2015-05-21
| ||
| 02:07 | When parsing the schema, ignore any SQL that does not begin with "CREATE". Cherrypick of [d3c00d61581c] with additional changes. file: [6f5feb49] check-in: [09784f37] user: drh branch: branch-3.7.11, size: 9059 | |
|
2015-04-16
| ||
| 00:26 | When parsing the schema, ignore any SQL that does not begin with "CREATE". file: [3eb35a4a] check-in: [d3c00d61] user: drh branch: trunk, size: 9122 | |
|
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: [1772936d] check-in: [cca8bf43] user: dan branch: sqlite_stat4, size: 9154 | |
|
2013-08-03
| ||
| 20:24 | Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [4d08a739] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 9090 | |
|
2011-08-26
| ||
| 13:52 | Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. file: [2b2e06e0] check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 9088 | |
|
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: [f8ab7d15] check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 9091 | |
|
2011-08-07
| ||
| 01:31 | Remove relevant elements from the sqlite_stat2 table when doing a DROP INDEX or DROP TABLE. file: [68b43c1f] check-in: [3c8f97ae] user: drh branch: trunk, size: 9091 | |
|
2011-03-30
| ||
| 14:54 | Do not generate sqlite_stat1 entries for empty tables when running ANALYZE. Ticket [83ea97620bd31016451] file: [c8cb89e8] check-in: [3a27af5b] user: drh branch: trunk, size: 7411 | |
|
2011-02-12
| ||
| 14:23 | Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. file: [d21f2143] check-in: [f2a8b5cc] user: drh branch: branch-3.7.2, size: 7408 | |
|
2010-09-25
| ||
| 22:32 | Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. file: [c1eb8706] check-in: [a7645d29] user: drh branch: trunk, size: 7446 | |
|
2010-07-08
| ||
| 09:44 | Changes to test scripts so that the "inmemory_journal" permutation works with [ef126e775a]. file: [bf692e7d] check-in: [f553c8ed] user: dan branch: trunk, size: 7373 | |
|
2008-08-11
| ||
| 18:44 | Do not allow indexing of any table whose name begins with "sqlite_". Ticket #3284. Improve handling of databases with malformed schemas - just in case somebody has actually indexed a system table. (CVS 5553) file: [ad532909] check-in: [0e1d8d14] user: drh branch: trunk, size: 7363 | |
|
2008-08-01
| ||
| 18:47 | Fix problems in test scripts. Add new test cases to improve test coverage. (CVS 5521) file: [a881c145] check-in: [b65f493c] user: drh branch: trunk, size: 7062 | |
|
2008-04-11
| ||
| 17:11 | Remove entries from the sqlite_stat1 table whenever an index is dropped. Related to #3033. (CVS 4989) file: [0bc15f67] check-in: [349aab42] user: danielk1977 branch: trunk, size: 6883 | |
|
2008-03-19
| ||
| 13:03 | When a parse of the sqlite_master table fails, include the name of the object being parsed as part of the error message. (CVS 4881) file: [309ae29d] check-in: [57805b58] user: drh branch: trunk, size: 5940 | |
|
2005-09-10
| ||
| 22:40 | The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) file: [2f55535a] check-in: [26565b89] user: drh branch: trunk, size: 5925 | |
|
2005-09-06
| ||
| 10:26 | Fix ANALYZE so that it works even if the empty_result_callbacks pragma is enabled. Ticket #1409. (CVS 2659) file: [8c54b1fb] check-in: [bfdaef12] user: drh branch: trunk, size: 5914 | |
|
2005-08-19
| ||
| 00:14 | Bring testing coverage of the analyze.c file up to 100%. Bugs found and fixed in the process. (CVS 2599) file: [a1206c74] check-in: [2fe0ac4f] user: drh branch: trunk, size: 5813 | |
|
2005-07-23
| ||
| 14:52 | Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) file: [ac50d2a2] check-in: [868279c7] user: drh branch: trunk, size: 4323 | |
| 02:17 | Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) file: [a34554a0] check-in: [bd7583a5] user: drh branch: trunk, size: 4217 Added | |