SQLite

All files named ”test/stat.test”
Login

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

History for test/stat.test

2021-11-22
16:06
[123212a20c] part of check-in [0f567b6107] There are two possible error messages from stat-9.1, depending on compile-time options. Adjust the test case to accept either one. (check-in: [0f567b6107] user: drh branch: trunk, size: 10363)
2021-11-09
13:31
[c95e5f293d] part of check-in [de10795a1c] Change test case error message text to match the current implementation. (check-in: [de10795a1c] user: drh branch: trunk, size: 10327)
2021-11-06
18:22
[dbbb71a8fb] part of check-in [889dea52de] Return an error if an attempt is made to drop an eponymous virtual table. (check-in: [889dea52de] user: dan branch: trunk, size: 10328)
2020-06-19
13:33
[15a3106edd] part of check-in [9536fa0ae0] Further refactoring of the schema table name. (check-in: [9536fa0ae0] user: drh branch: trunk, size: 10040)
2020-01-04
19:14
[423257dc36] part of check-in [5b246b47ae] Fix DBSTAT so that it returns no rows, rather than an error when the WHERE clause is "schema=NULL". (check-in: [5b246b47ae] user: drh branch: trunk, size: 10040)
18:38
[7bdfc6ae0f] part of check-in [cfff5cb227] Omit the omit flat from eq constraints on column "name" of dbstat virtual tables. Fix for [74a4c386]. (check-in: [cfff5cb227] user: dan branch: trunk, size: 10057)
14:00
[f36f58c0ac] part of check-in [74ef6f2b6d] Omit the omit flag from eq constraints on column "aggregate" of dbstat virtual tables. Fix for [727074e2]. (check-in: [74ef6f2b6d] user: dan branch: trunk, size: 9904)
2019-11-19
18:48
[05669008ed] part of check-in [16fef3db06] Get the aggregate=TRUE feature working on the DBSTAT virtual table. (check-in: [16fef3db06] user: drh branch: dbstat-enhancements, size: 9693)
14:01
[a08fd3f87e] part of check-in [9b5722f0fe] Begin an enhancement effort for the built-in DBSTAT virtual table. (check-in: [9b5722f0fe] user: drh branch: dbstat-enhancements, size: 8686)
2016-08-05
15:34
[f8f1279fff] part of check-in [0f57effa36] Remove an incorrect ALWAYS() statement and add a test case to show when the condition is sometimes false. (check-in: [0f57effa36] user: drh branch: trunk, size: 8658)
2016-06-13
15:59
[ab95d28503] part of check-in [a1e1cdc51d] Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (check-in: [a1e1cdc51d] user: drh branch: trunk, size: 8369)
2016-06-10
22:49
[8544f21969] part of check-in [53a1e5d513] Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (check-in: [53a1e5d513] user: drh branch: trunk, size: 8374)
2016-04-27
18:54
[66e95f97b9] part of check-in [2662d8fef7] Modify the permutations.test script so as to set any permutation specific configuration values before running each individual test script. (check-in: [2662d8fef7] user: dan branch: permutations-fix, size: 8260)
2016-03-15
12:45
[688f0f9bca] part of check-in [f41a7361a1] Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. (check-in: [f41a7361a1] user: drh branch: apple-osx, size: 8281)
2016-03-14
18:34
[b65bad7120] part of check-in [99b9d7eef6] Many more test cases fixed. Only a few remain. (check-in: [99b9d7eef6] user: drh branch: see-testing, size: 8252)
2016-02-02
02:30
[b091791cca] part of check-in [e6a4a16312] Merge recent enhancements from trunk. (check-in: [e6a4a16312] user: drh branch: apple-osx, size: 8054)
2016-01-30
21:09
[acc91e8051] part of check-in [a2810cf65d] Fix new test cases in stat.test so that they work with -DSQLITE_DEFAULT_AUTOVACUUM=1 builds. (check-in: [a2810cf65d] user: dan branch: trunk, size: 8025)
2016-01-22
15:44
[fafe6e82df] part of check-in [e60461e984] Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. (check-in: [e60461e984] user: dan branch: trunk, size: 7991)
2015-08-28
02:12
[d7607786af] part of check-in [da8646582a] Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. (check-in: [da8646582a] user: drh branch: apple-osx, size: 6357)
2015-05-07
14:41
[8de91498c9] part of check-in [25ec09400b] Enhance the dbstat virtual table with the ability to analyze ATTACHed databases. (check-in: [25ec09400b] user: drh branch: trunk, size: 6328)
2015-03-20
20:30
[2120916b1e] part of check-in [0a7f2051b2] Where possible insert the set of new keys for each index in sorted order within "INSERT INTO ... SELECT" statements. (check-in: [0a7f2051b2] user: dan branch: insert-select-opt, size: 6193)
2014-05-08
23:01
[1e5faf3964] part of check-in [9411d7dc6f] Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. (check-in: [9411d7dc6f] user: drh branch: apple-osx, size: 6182)
2013-12-19
16:26
[76fd746b85] part of check-in [ca3fdfd419] Make sure errors encountered while initializing extensions such as FTS4 get reported out from sqlite3_open(). This fixes a bug introduced by check-in [9d347f547e7ba9]. Also remove lots of forgotten "breakpoint" commands left in test scripts over the years. (check-in: [ca3fdfd419] user: drh branch: trunk, size: 6153)
2013-11-02
11:34
[c8eccfe8fc] part of check-in [42a11e7464] A pair of sqlite3_analyzer bug fixes: (1) quote strings in the SQL at the end of the output. (2) Fix test_stat.c so that it no longer misses some overflow pages on internal index pages. (check-in: [42a11e7464] user: drh branch: trunk, size: 6164)
2012-09-28
10:57
[6d55845481] part of check-in [6a5c59dd7e] Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. (check-in: [6a5c59dd7e] user: drh branch: apple-osx, size: 5899)
2012-09-15
18:45
[be8d477306] part of check-in [cfaa7bc128] Attempt to use a covering index even on a full table scan, under the theory that the index will be smaller and require less disk I/O and thus be faster. (check-in: [cfaa7bc128] user: drh branch: fullscan-covering-index, size: 5870)
2012-04-02
23:35
[4ce96d67f6] part of check-in [d51c086e5c] Merge in latest changes, autologging options, read only file system wal support, test config conditionalization, WAL frame write prebuffering (check-in: [d51c086e5c] user: adam branch: apple-osx, size: 5809)
2012-02-13
10:00
[08e8185b3f] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 5780)
2011-09-28
00:50
[36bc951bdc] part of check-in [19b8eaaf70] Enhance the stat VFS to report out the total size of all pages used by a table, even if the ZIPVFS compression backend is in play. Update the sqlite3_analyzer logic to use these new outputs. (check-in: [19b8eaaf70] user: drh branch: trunk, size: 5769)
2011-08-02
00:57
[0997f6a57a] part of check-in [9007586fda] Add retry logic for AV defense to winOpen. Also, refactor test suite to allow the key Tcl file operations (e.g. copy and delete) to be retried. (check-in: [9007586fda] user: mistachkin branch: winopen-retry-logic, size: 5225)
2010-09-13
14:38
[c7b20ea430] part of check-in [8cb39306f4] Fix a couple of test files so that they work with DEFAULT_AUTOVACUUM. (check-in: [8cb39306f4] user: dan branch: trunk, size: 5232)
2010-08-24
18:35
[3c18f0698e] part of check-in [d1ed743b6e] Changes to support building with SQLITE_OMIT_WAL. (check-in: [d1ed743b6e] user: shaneh branch: trunk, size: 5176)
2010-08-18
00:09
[8b7342007b] part of check-in [5e2ee7db0f] Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments (check-in: [5e2ee7db0f] user: adam branch: apple-osx, size: 5177)
2010-07-19
12:05
[70fe540ffb] part of check-in [f87bb28361] Changes to stat.test so that it works with file-format 4. (check-in: [f87bb28361] user: dan branch: trunk, size: 5147)
2010-07-12
18:12
Added: [16b170b626] part of check-in [bf4fc08887] Fix test_stat.c so that it does not cause compilation errors if SQLITE_OMIT_VIRTUALTABLE is defined. (check-in: [bf4fc08887] user: dan branch: trunk, size: 5086)