/ History for test/analyze.test
Login

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

History for test/analyze.test

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