/ File History
Login

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