/ All files named "test/pragma.test"
Login

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

History for test/pragma.test

2020-07-23
00:45
[50b91bed] part of check-in [65dd3214] Add the ability to do a PRAGMA integrity_check (or quick_check) on a single table by specifying the table name as the argument. (check-in: [65dd3214] user: drh branch: trunk, size: 49429)
2019-09-30
16:13
[5e6cbd81] part of check-in [9ce4c791] Merge the 3.30.0 beta 1 changes from trunk. (check-in: [9ce4c791] user: drh branch: apple-osx, size: 52690)
2019-09-27
17:36
[59becdfd] part of check-in [326cdc16] Update requirement marks due to changes in documentation wording. (check-in: [326cdc16] user: drh branch: trunk, size: 49082)
2019-04-04
21:40
[56043531] part of check-in [521d5186] Merge all the latest changes and enhancements from trunk. (check-in: [521d5186] user: drh branch: apple-osx, size: 52435)
17:58
[cf066fe0] part of check-in [4cef609d] Add test cases to improve coverage of VDBE branches. Still some to go. (check-in: [4cef609d] user: dan branch: trunk, size: 48827)
2018-11-10
20:07
[5f399fa2] part of check-in [977fc44e] Merge the read-only shadow table and defensive mode enhancments from trunk. (check-in: [977fc44e] user: drh branch: apple-osx, size: 51938)
2018-11-07
02:17
[c267bf02] 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: 48330)
2017-10-24
19:12
[3ce8294c] part of check-in [13be3a44] Merge all enhancements and fixes from the 3.21.0 release. (check-in: [13be3a44] user: drh branch: apple-osx, size: 51905)
2017-10-23
16:34
[7c8cfc32] part of check-in [04813307] Updates to test procedures so that they all work with encryption. No changes to the core SQLite code. (check-in: [04813307] user: drh branch: branch-3.21, size: 48297)
2017-09-13
00:33
[c31b5e98] part of check-in [8525c30c] Improvements to PRAGMA integrity_check for better detection of malformed records. Integrity_check now avoids returning SQLITE_CORRUPT on a corrupt record. Also includes microoptimizations that I stumbled over while working on integrity_check. (check-in: [8525c30c] user: drh branch: trunk, size: 48231)
00:13
[21b5a5c2] part of check-in [81f62e99] PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (check-in: [81f62e99] user: drh branch: improved-integrity-check, size: 48221)
2017-09-12
00:24
[277488e8] part of check-in [d7b7f038] Make sure all connections are closed in the pragma.test script. Test change only - no changes to code. (check-in: [d7b7f038] user: drh branch: trunk, size: 48229)
2017-09-09
06:10
[20af8a8d] part of check-in [6a0b9d9d] Merge trunk enhancements (check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 51827)
2017-09-05
20:16
[faa8b64c] part of check-in [9e393a0e] Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. (check-in: [9e393a0e] user: dan branch: trunk, size: 48219)
2017-07-07
22:58
[1ffae882] part of check-in [7f48f6ab] Merge in all the latest trunk enhancements. (check-in: [7f48f6ab] user: drh branch: apple-osx, size: 51289)
19:43
[f274259d] part of check-in [732f90d6] Change the error message text for SQLITE_ERROR to omit the part about "missing database" as that meaning is now obsolete (since approx SQLite 2.0). (check-in: [732f90d6] user: drh branch: trunk, size: 47681)
2016-04-29
15:52
[d3b32e68] part of check-in [81b76901] Merge enhancements from trunk, and in particular the TEMP file deferred I/O enhancements. (check-in: [81b76901] user: drh branch: apple-osx, size: 51309)
2016-04-21
15:35
[2e34da1d] part of check-in [a15c49ae] Merge all recent enhancements from trunk. (check-in: [a15c49ae] user: drh branch: apple-osx, size: 50925)
15:03
[1e947551] part of check-in [cc28106e] Merge updates from trunk. (check-in: [cc28106e] user: drh branch: tempfiles-25, size: 47701)
2016-04-18
15:46
[dd5313ee] part of check-in [eba27d4d] Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] (check-in: [eba27d4d] user: drh branch: trunk, size: 47317)
2016-04-06
18:20
[36daccdb] part of check-in [84c55701] For a pager backed by a temp file, store the main journal in memory until it is at least sqlite3_config.nStmtSpill bytes in size. Prevent the backup API from being used to change the page-size of a temp file. (check-in: [84c55701] user: dan branch: tempfiles-lazy-open, size: 47662)
2016-03-15
12:45
[79a4a492] part of check-in [f41a7361] Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. (check-in: [f41a7361] user: drh branch: apple-osx, size: 50886)
2016-03-14
18:34
[afbf028b] part of check-in [99b9d7ee] Many more test cases fixed. Only a few remain. (check-in: [99b9d7ee] user: drh branch: see-testing, size: 47278)
2016-02-05
14:29
[70826dc1] part of check-in [201fcbee] Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. (check-in: [201fcbee] user: drh branch: apple-osx, size: 50727)
2016-02-03
19:20
[507ac7ef] part of check-in [af924018] Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. (check-in: [af924018] user: drh branch: trunk, size: 47119)
2015-09-15
17:20
[fc0c3c0c] part of check-in [f12b8a0f] Merge trunk enhancements into the apple-osx branch. (check-in: [f12b8a0f] user: drh branch: apple-osx, size: 50467)
2015-09-11
20:54
[a44253f9] part of check-in [86781093] Update evidence marks due to wording changes in requirements text. No changes to code. (check-in: [86781093] user: drh branch: trunk, size: 46859)
2015-07-01
17:13
[75fcb9bc] part of check-in [1c522123] Rework the PRAGMA integrity_check logic. Simplify the checkTreePage() routine and clean up the error messages generated. (check-in: [1c522123] user: drh branch: integrity-check-refactor, size: 46869)
2015-04-20
01:25
[69cc5c34] part of check-in [74b7bf17] Merge all recent trunk enhancements and fixes into the apple-osx branch. (check-in: [74b7bf17] user: drh branch: apple-osx, size: 50485)
2015-04-17
15:58
[be7195f0] part of check-in [7aeade9a] Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. (check-in: [7aeade9a] user: drh branch: trunk, size: 46877)
2015-04-16
16:04
[2e3d2078] part of check-in [e0a88176] Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. (check-in: [e0a88176] user: drh branch: trunk, size: 46781)
2015-04-15
13:51
[28748a49] part of check-in [bfc7142a] Merge recent trunk fixes and enhancements into the apple-osx branch. (check-in: [bfc7142a] user: drh branch: apple-osx, size: 50196)
07:19
[e6605ce8] part of check-in [0e087c01] Remove an incorrect ALWAYS() from the table_info pragma. (check-in: [0e087c01] user: drh branch: trunk, size: 46588)
2015-03-09
13:18
[28860077] part of check-in [5e04eec8] Merge recent trunk enhancements into the apple-osx branch. (check-in: [5e04eec8] user: drh branch: apple-osx, size: 50007)
2015-03-05
15:34
[ad99d05e] part of check-in [e5b13634] New test cases and requirements marks for PRAGMA index_info, index_xinfo, and index_list. (check-in: [e5b13634] user: drh branch: trunk, size: 46399)
14:29
[6929a762] part of check-in [fc543c2c] Revert "PRAGMA index_info" to output only three columns, for complete compatibility with prior versions. The new "PRAGMA index_xinfo" can be used to get the extra information in 4th, 5th, and 6th columns. (check-in: [fc543c2c] user: drh branch: trunk, size: 42631)
2015-02-28
01:04
[64f11ec7] part of check-in [fc51037c] More test cases and requirements marks for pragmas. (check-in: [fc51037c] user: drh branch: trunk, size: 42685)
2015-02-27
20:28
[a6187e24] part of check-in [8c2b29d9] New requirements marks and a few new test cases to go with them. No changes to code. (check-in: [8c2b29d9] user: drh branch: trunk, size: 42472)
2015-02-06
16:03
[ad028e69] part of check-in [44711921] Merge all recent trunk enhancements into the apple-osx branch. (check-in: [44711921] user: drh branch: apple-osx, size: 45699)
2015-02-04
23:13
[6cf0f0ce] part of check-in [3af19f84] Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (check-in: [3af19f84] user: drh branch: index_xinfo, size: 42091)
2015-01-31
02:00
[66776f48] part of check-in [30f51d7b] Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. (check-in: [30f51d7b] user: drh branch: index_xinfo, size: 42079)
2014-12-16
00:29
[7d7823c3] part of check-in [2c1d8dda] Merge latest fixes and enhancements from trunk into apple-osx. (check-in: [2c1d8dda] user: drh branch: apple-osx, size: 44379)
00:08
[aa16dedf] part of check-in [5b1b6970] Make sure the sqlite3BtreeCount() routine does not leave index cursors in an inconsistent state, as doing so might result in an assertion fault inside of sqlite3BtreeKey() called from saveAllCursors() if content is deleted out from under the statement that issued the sqlite3BtreeCount() call. (check-in: [5b1b6970] user: drh branch: trunk, size: 40771)
2014-12-02
16:38
[1666a0a9] part of check-in [43c4ba26] Merge all recent enhancements and bug fixes from trunk into the apple-osx branch. (check-in: [43c4ba26] user: drh branch: apple-osx, size: 43588)
2014-11-20
23:11
[49ac8a73] part of check-in [332cc959] Fix a benign test error on PRAGMA collation_list introduced by a recent checkin. (check-in: [332cc959] user: drh branch: trunk, size: 39980)
2014-08-15
22:37
[efe0b771] part of check-in [c8ade949] Aborted merge. (check-in: [c8ade949] user: numist branch: obsolete, size: 43772)
2014-08-06
01:51
[5e4805a9] part of check-in [b2e01080] Merge 3.8.6 beta changes in from trunk. (check-in: [b2e01080] user: drh branch: apple-osx, size: 43588)
2014-08-01
01:40
[19d0241a] part of check-in [9abcf269] Enhance the PRAGMA integrity_check command to detect UNIQUE and NOT NULL constraint violations. (check-in: [9abcf269] user: drh branch: trunk, size: 39980)
2014-05-08
23:01
[8ee8929d] part of check-in [9411d7dc] 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: [9411d7dc] user: drh branch: apple-osx, size: 42592)
2014-02-28
18:39
[adb21a90] part of check-in [3a09f560] Update some test cases that deal with corrupt databases. (check-in: [3a09f560] user: dan branch: experimental, size: 38984)
2014-02-25
21:01
[c1bc3a29] part of check-in [85206e0b] Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. (check-in: [85206e0b] user: dan branch: experimental, size: 38842)
2013-10-30
20:22
[e882183e] part of check-in [0d4fea74] Continue working to get UPDATE operational for WITHOUT ROWID tables. Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables. (check-in: [0d4fea74] user: drh branch: omit-rowid, size: 38794)
2013-10-12
09:32
[75990a4a] part of check-in [0c4dd9ff] Changes to the new initial row of PRAGMA index_list results. (check-in: [0c4dd9ff] user: mistachkin branch: indexList, size: 38980)
2013-10-08
22:25
[5c6e8ae9] part of check-in [dd03be10] Fix test cases for the new information in PRAGMA index_list. (check-in: [dd03be10] user: drh branch: row-size-est, size: 38923)
2013-10-04
15:30
[de128f02] part of check-in [07462bb6] Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. (check-in: [07462bb6] user: drh branch: index-scan-rate, size: 38890)
2013-05-01
19:49
[5e7de6c3] part of check-in [28c9e7fd] Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (check-in: [28c9e7fd] user: drh branch: application-id, size: 38860)
2013-03-27
19:53
[ffcad56b] part of check-in [0e3d5119] Modify various test cases so that they work if the file is extended in units of the system page-size. (check-in: [0e3d5119] user: dan branch: two-mappings, size: 38766)
2013-02-14
16:16
[60d29cd3] part of check-in [82952d08] Verify that the schema has not changed before running PRAGMA table_info, index_list, index_info, and foreign_key_list. (check-in: [82952d08] user: drh branch: trunk, size: 38671)
2013-01-01
13:55
[5ce333ca] part of check-in [3076a890] Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (check-in: [3076a890] user: drh branch: trunk, size: 37735)
2012-08-25
01:38
[eaf172eb] part of check-in [6723add4] Merge all the latest trunk changes into the apple-osx branch. (check-in: [6723add4] user: drh branch: apple-osx, size: 41130)
2012-07-16
10:06
[a62f7329] part of check-in [4353e40b] If a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA quick_check" command, search for problems in the nominated database only. i.e. "PRAGMA main.quick_check" now only scans the main database, not all attached databases as before. (check-in: [4353e40b] user: dan branch: trunk, size: 37522)
2012-06-08
01:13
[37d3475b] part of check-in [9d1b8515] Merge trunk changes into the apple-osx branch. (check-in: [9d1b8515] user: drh branch: apple-osx, size: 39604)
2012-06-06
23:23
[cb736bcc] part of check-in [61360ca6] Merge the changes need to compile on WinRT into trunk. (check-in: [61360ca6] user: drh branch: trunk, size: 35996)
2012-03-19
16:21
[e284a28b] part of check-in [f999197b] Merge latest trunk changes into apple-osx branch. (check-in: [f999197b] user: dan branch: apple-osx, size: 38367)
2012-03-14
00:44
[eba5bd33] part of check-in [7354ae8f] Add experimental support for resolving relative database file paths using a fixed user-defined directory. (check-in: [7354ae8f] user: mistachkin branch: winrt, size: 35934)
2012-03-08
20:00
[c51c148d] part of check-in [82bcd7ec] On Windows, make sure the current directory value used by the test suite is 'normalized' to what the parent command shell sees. Also, clean the test directories used by the quota2.test file. (check-in: [82bcd7ec] user: mistachkin branch: trunk, size: 34759)
2012-03-05
16:39
[ac4448f4] part of check-in [504bf490] Pull in all the latest trunk changes. (check-in: [504bf490] user: drh branch: apple-osx, size: 38359)
2012-03-02
22:41
[f11c59ec] part of check-in [9aaa1ab7] Fix test pragma-19.5 so that it works on file names that may contain spaces and/or backslashes. (check-in: [9aaa1ab7] user: mistachkin branch: trunk, size: 34751)
2012-02-22
20:08
[f6111ded] part of check-in [c81fc40b] Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. (check-in: [c81fc40b] user: drh branch: file-control-pragma, size: 34740)
19:56
[01abcc2e] part of check-in [56436181] If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. (check-in: [56436181] user: drh branch: file-control-pragma, size: 34666)
2011-12-08
21:08
[76d64428] part of check-in [59e0d4f3] Merge the latest trunk changes into the apple-osx branch. (check-in: [59e0d4f3] user: drh branch: apple-osx, size: 37779)
2011-11-09
14:23
[7fa35e53] part of check-in [b3faa680] A negative value N for the cache_size pragma adjusts the number of cache pages to use approximately N kibibytes of memory. (check-in: [b3faa680] user: drh branch: experimental-pcache, size: 34171)
2011-10-21
17:18
[86344e11] part of check-in [be62ef05] Merge the latest trunk changes into the apple-osx branch. (check-in: [be62ef05] user: drh branch: apple-osx, size: 37777)
2011-10-13
14:41
[1ea0c85b] part of check-in [150592b4] Make sure the page_count and quick_check pragmas work properly even when their names are capitalized. Fixes a problem reported on the mailing list. (check-in: [150592b4] user: drh branch: trunk, size: 34169)
2011-08-23
18:06
[68f2a9a4] part of check-in [c5f7977b] Merge latest trunk changes into the apple-osx branch. (check-in: [c5f7977b] user: dan branch: apple-osx, size: 37502)
2011-08-02
00:57
[c8108e01] part of check-in [9007586f] 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: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 33894)
2011-06-24
20:47
[6c4b98a9] part of check-in [34f0efa2] Merging local changes to apple-osx (check-in: [34f0efa2] user: adam branch: apple-osx, size: 37565)
2011-06-22
11:24
[9b08f84e] part of check-in [fb7ad09d] Update apple-osx branch with the latest trunk changes. (check-in: [fb7ad09d] user: dan branch: apple-osx, size: 37607)
2010-11-19
23:50
[88048136] part of check-in [c8bc057c] Merge all the latest changes from the trunk into the apple-osx branch. (check-in: [c8bc057c] user: drh branch: apple-osx, size: 37607)
2010-11-09
20:08
[421476c1] part of check-in [756589ad] Add "PRAGMA checkpoint_fullfsync". Similar to "PRAGMA fullfsync", but enables full fsyncs only during checkpoint operations. Update: This change was added to the trunk by check-in [a069867301de3ca2e17] (check-in: [756589ad] user: dan branch: apple-osx-exp, size: 37556)
00:43
[90f2386e] part of check-in [fd4d38fa] Integrated proxy locking file support for WAL journal mode and double free fix (check-in: [fd4d38fa] user: adam branch: apple-osx, size: 37556)
2010-10-06
16:42
[fdfc0906] part of check-in [759c954f] Fix minor test suite problems causing errors on OSX. (check-in: [759c954f] user: dan branch: trunk, size: 33957)
2010-09-10
20:19
[68abf503] part of check-in [782c3351] replaced relative lock proxy paths with absolute (check-in: [782c3351] user: adam branch: apple-osx, size: 37406)
2010-08-07
11:46
[66a412d3] part of check-in [f88c6367] Merge in all changes up to the 3.7.0.1 release. (check-in: [f88c6367] user: drh branch: apple-osx, size: 37415)
2010-07-08
09:44
[ed78d200] 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: 33908)
2010-06-22
13:46
[a869b428] part of check-in [85dd51a7] Some changes to test scripts related to codec enabled versions of sqlite. (check-in: [85dd51a7] user: dan branch: trunk, size: 33861)
2010-03-27
17:12
[6960f9ef] part of check-in [b844ac6f] Experimental changes that cause SQLite to use bytes 28..31 of the database header to determine the database size, rather than using the actual database size. This allows database space to be preallocated. (check-in: [b844ac6f] user: drh branch: experimental, size: 33696)
2009-11-03
22:34
[648a1760] part of check-in [941a01eb] Customizations for OSX contributed by Apple. (check-in: [941a01eb] user: adam branch: apple-osx, size: 37162)
2009-09-19
17:00
[5aeb48a4] part of check-in [d5d39981] Check in implementation of foreign key constraints. (check-in: [d5d39981] user: dan branch: trunk, size: 33655)
2009-01-12
14:01
[a35b0be3] part of check-in [5d88f8be] Only run tests that depend on SQLITE_PREFER_PROXY_LOCKING builds when said symbol is set. (CVS 6169) (check-in: [5d88f8be] user: danielk1977 branch: trunk, size: 33649)
2009-01-09
21:41
[3fd4d3cc] part of check-in [64c56226] Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) (check-in: [64c56226] user: drh branch: trunk, size: 33619)
2008-12-30
17:55
[325aa083] part of check-in [b090d573] Fix a bug in the multi-index OR cost estimator. Remove leftover "breakpoint" commands from test scripts. (CVS 6086) (check-in: [b090d573] user: drh branch: trunk, size: 32325)
2008-11-21
00:10
[0f299601] part of check-in [b9bc36d3] Added support for proxy file locking style Added pragma support for controlling proxy file locking Added file control access to last errno and proxy locking Added support for TMPDIR environment variable Extended unit tests to cover new proxy locking pragmas and file control features (CVS 5934) (check-in: [b9bc36d3] user: aswift branch: trunk, size: 32339)
2008-10-23
05:45
[165372b6] part of check-in [0e448bc6] Fix a bug in pragma table_info. Column default values specified as negative numbers (col DEFAULT -1) were being reported as NULL by the pragma. (CVS 5839) (check-in: [0e448bc6] user: danielk1977 branch: trunk, size: 29633)
2008-10-10
17:47
[58393790] part of check-in [3bb33cf5] Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) (check-in: [3bb33cf5] user: danielk1977 branch: trunk, size: 29179)
2008-09-16
15:50
[c86359a8] part of check-in [50feaa37] Use (file nativename (pwd)) instead of just (pwd) to find the name of the current directory to pass to "PRAGMA temp_store_directory" in pragma.test. This helps the test pass on non-unix systems. (CVS 5709) (check-in: [50feaa37] user: danielk1977 branch: trunk, size: 29156)
2008-09-02
00:52
[4461cb10] part of check-in [ef26ea5c] Continuing work on adding full support for the SQLITE_OMIT_WSD compile-time option. (CVS 5658) (check-in: [ef26ea5c] user: drh branch: trunk, size: 29112)
2008-08-20
16:34
[b55931bb] part of check-in [d0cfbbba] When a "pragma main.table_info(...)" is issued, consider only tables from the main database, not the temp db. Ticket #3320. (CVS 5568) (check-in: [d0cfbbba] user: danielk1977 branch: trunk, size: 29024)
2008-07-12
14:52
[2c675ed9] part of check-in [dcb16024] Remove leftover debugging commands (breakpoint and btree_breakpoint) from test scripts. (CVS 5400) (check-in: [dcb16024] user: drh branch: trunk, size: 28377)
2008-07-08
07:35
[e1984ed4] part of check-in [92e0cf9a] Prohibit the user from changing the temporary storage medium (pragma temp_store) while there is a read transaction open on the temporary database. Add tests to shared.test to cover a few more lines in btree.c. (CVS 5362) (check-in: [92e0cf9a] user: danielk1977 branch: trunk, size: 28396)
2008-06-23
16:53
[44bc52af] part of check-in [6dbe67da] Fix a bug causing the pager-cache size to be reset to its default value whenever the database schema was reloaded. (CVS 5283) (check-in: [6dbe67da] user: danielk1977 branch: trunk, size: 28011)
2008-06-06
11:11
[6b9bee4f] part of check-in [5173b3e8] Remove the xGetTempname() method from the vfs structure. Temp files are now opened by passing a NULL pointer as the filename to xOpen(). (CVS 5190) (check-in: [5173b3e8] user: danielk1977 branch: trunk, size: 27123)
2008-05-15
17:48
[c3229f5f] part of check-in [eb6985e6] Add the "page_count" pragma. Returns a single integer - the number of pages in the specified database file. (CVS 5135) (check-in: [eb6985e6] user: danielk1977 branch: trunk, size: 27096)
2008-03-19
00:21
[aec802c9] part of check-in [24e76997] Remove the dependency on the direct btree interface from as many test scripts as is practical. Fix a bug in the output limiter of the integrity_check pragma that came up while making this change. (CVS 4880) (check-in: [24e76997] user: drh branch: trunk, size: 26029)
2008-03-18
13:46
[a16e6c08] part of check-in [f87ddf83] Test script changes that go with the coverage enhancements of the previous check-in. (CVS 4878) (check-in: [f87ddf83] user: drh branch: trunk, size: 25519)
2008-01-20
23:19
[d9f3d805] part of check-in [0bf4e7fe] Add the RTRIM collating sequence. Only implemented for UTF8. Still considered experimental and may be removed if we find adverse impact elsewhere in the system. (CVS 4732) (check-in: [0bf4e7fe] user: drh branch: trunk, size: 24490)
2007-12-29
13:39
[bb77b00e] part of check-in [2ddc8d72] Add experimental pragma "quick_check", a reduced version of integrity_check that runs without most of the overhead of the full integrity_check. (CVS 4645) (check-in: [2ddc8d72] user: danielk1977 branch: trunk, size: 24473)
2007-10-09
08:29
[ab9ba0fb] part of check-in [07c00fff] Fixes to the test suite (no code changes) so that quick.test runs with OMIT_ATTACH builds. #2706. (CVS 4480) (check-in: [07c00fff] user: danielk1977 branch: trunk, size: 24400)
2007-05-17
16:38
[b0e73879] part of check-in [ae644bc7] Bring the autoconf based build system up to date with the recent changes. #2366, #2367 and #2368. (CVS 4022) (check-in: [ae644bc7] user: danielk1977 branch: trunk, size: 23833)
2007-04-06
21:42
[fecb7085] part of check-in [3471a226] Changes to test scripts to support alternative configurations. (CVS 3824) (check-in: [3471a226] user: drh branch: trunk, size: 23702)
2007-03-30
17:11
[4d2696d0] part of check-in [eec7ab63] Coverage tests for some pragmas. (CVS 3767) (check-in: [eec7ab63] user: danielk1977 branch: trunk, size: 23122)
2007-01-27
14:26
[91739ef0] part of check-in [4d0d2063] Adjustments to the pragma test for OS-X. (CVS 3615) (check-in: [4d0d2063] user: drh branch: trunk, size: 22380)
14:11
[5102c356] part of check-in [79a65436] More adjustments to the pragma test for windows. (CVS 3614) (check-in: [79a65436] user: drh branch: trunk, size: 22303)
14:04
[ec7fbfc1] part of check-in [a79914cc] Adjustment to tests for PRAGMA integrity_check so that they run under windows. (CVS 3613) (check-in: [a79914cc] user: drh branch: trunk, size: 22303)
02:24
[b523286a] part of check-in [d564a039] Limit the number of errors returned by PRAGMA integrity_check to 100 by default. Specify an alternative limit using an argument to the pragma. Ticket #2176. (CVS 3609) (check-in: [d564a039] user: drh branch: trunk, size: 22303)
2007-01-22
13:02
[d20fe81e] part of check-in [071c957a] Fix a pragma test so that it works in directories that have spaces in their names. (CVS 3597) (check-in: [071c957a] user: drh branch: trunk, size: 18388)
2007-01-04
22:13
[5b58a36e] part of check-in [f81c4227] Fix the user_version and schema_version pragmas so that they set a result column name. Ticket #2143. (CVS 3560) (check-in: [f81c4227] user: drh branch: trunk, size: 18381)
2006-11-30
13:06
[fc04e28f] part of check-in [5f21c3a5] Change the table_info pragma so that it returns NULL for the default value if there is no default value. Ticket #2078. (CVS 3527) (check-in: [5f21c3a5] user: drh branch: trunk, size: 18281)
2006-08-14
14:23
[b81f483c] part of check-in [b4d53974] Change the table_info pragma to show the text of the default value expression, not the result of evaluating the default value expression. Ticket #1919. (CVS 3353) (check-in: [b4d53974] user: drh branch: trunk, size: 18096)
2006-06-20
11:01
[e2d72d9e] part of check-in [c6ea353b] Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) (check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 17916)
2006-03-19
13:00
[2ca8f719] part of check-in [8ae6ccc7] Increase test coverage to above 98%. (CVS 3144) (check-in: [8ae6ccc7] user: drh branch: trunk, size: 17862)
2006-03-03
21:20
[745f5161] part of check-in [5cae8d63] The table_info pragma shows column affinity as "" if there is no column affinity. Ticket #1570. (CVS 3122) (check-in: [5cae8d63] user: drh branch: trunk, size: 17218)
2006-02-17
12:25
[3e3673e4] part of check-in [1e4644b2] Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104) (check-in: [1e4644b2] user: danielk1977 branch: trunk, size: 17241)
2006-02-09
16:52
[12e1b74e] part of check-in [731f1e32] Back out check-in (3058) - it breaks too much application code. (CVS 3063) (check-in: [731f1e32] user: drh branch: trunk, size: 16729)
2006-02-06
21:34
[71bdf78d] part of check-in [7940a590] Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) (check-in: [7940a590] user: drh branch: trunk, size: 16756)
2006-01-03
00:33
[8759b467] part of check-in [70b22857] The sqlite TCL command no longer returns the hex address of the sqlite3* structure. Instead there is a new command in testfixture to find that information. (CVS 2852) (check-in: [70b22857] user: drh branch: trunk, size: 16729)
2005-05-22
20:30
[95ea907a] part of check-in [2db2b32f] The cache_size pragma should not reset the synchronous pragma. Ticket #1260. (CVS 2474) (check-in: [2db2b32f] user: drh branch: trunk, size: 16572)
2005-03-29
03:10
[effcf2f0] part of check-in [c41d5544] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d5544] user: danielk1977 branch: trunk, size: 16552)
2005-02-13
23:34
[52e4ba75] part of check-in [f3c51de7] Update the version number in preparation for the release of 3.1.2. (CVS 2325) (check-in: [f3c51de7] user: drh branch: trunk, size: 16299)
2005-02-09
03:20
[6e675a12] part of check-in [f73a8aa3] Add experimental collation_list pragma. (CVS 2321) (check-in: [f73a8aa3] user: danielk1977 branch: trunk, size: 15781)
2005-01-17
07:53
[4a7a06bf] part of check-in [62442529] Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) (check-in: [62442529] user: danielk1977 branch: trunk, size: 15438)
2005-01-10
02:48
[c1b4cdb2] part of check-in [6c7bec1b] Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) (check-in: [6c7bec1b] user: danielk1977 branch: trunk, size: 15291)
2005-01-08
15:44
[3673c0eb] part of check-in [0a90eaf3] Fixes to the temp_store_directory pragma. (CVS 2185) (check-in: [0a90eaf3] user: drh branch: trunk, size: 13927)
2005-01-07
10:42
[6d6f7db6] part of check-in [7373a5d4] Reset the temp_store_directory each iteration of tests in all.test. (CVS 2181) (check-in: [7373a5d4] user: danielk1977 branch: trunk, size: 13969)
2004-12-20
19:01
[18b3f998] part of check-in [772e22cb] Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: [772e22cb] user: tpoindex branch: trunk, size: 13967)
2004-11-23
11:16
[726167cc] part of check-in [ff20c623] Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146) (check-in: [ff20c623] user: danielk1977 branch: trunk, size: 12561)
10:52
[e344e0fd] part of check-in [2d1f0b92] Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145) (check-in: [2d1f0b92] user: danielk1977 branch: trunk, size: 12501)
10:13
[5b0c3224] part of check-in [6ccb589b] Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: [6ccb589b] user: danielk1977 branch: trunk, size: 12281)
2004-11-14
21:56
[ab309fb9] part of check-in [98c7a554] The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) (check-in: [98c7a554] user: drh branch: trunk, size: 12160)
2004-11-12
16:12
[d14ed144] part of check-in [5e058318] Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) (check-in: [5e058318] user: danielk1977 branch: trunk, size: 12134)
2004-11-11
05:10
[1d2ca2b5] part of check-in [d28d1d68] Add the schema_cookie and user_cookie pragmas. (CVS 2089) (check-in: [d28d1d68] user: danielk1977 branch: trunk, size: 12093)
2004-11-04
14:47
[bde12713] part of check-in [158a2d16] All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) (check-in: [158a2d16] user: drh branch: trunk, size: 7842)
2004-11-03
16:27
[ed8156b5] part of check-in [b11fc9b3] Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: [b11fc9b3] user: drh branch: trunk, size: 7765)
13:59
[5f5c82cc] part of check-in [a82980fd] More work on optionally removing unused features at compile-time. (CVS 2049) (check-in: [a82980fd] user: drh branch: trunk, size: 7648)
2004-11-02
18:15
[128ed309] part of check-in [a2c9c45c] Fix a problem in the pragma.test script. (CVS 2041) (check-in: [a2c9c45c] user: drh branch: trunk, size: 7641)
2004-07-24
17:38
[66a66b7f] part of check-in [ebdb661e] Prepared statements now work with CREATE and DROP. All tests pass. No memory leaks. (CVS 1866) (check-in: [ebdb661e] user: drh branch: trunk, size: 7648)
2004-07-22
15:02
[f7414c1d] part of check-in [b0a3becd] Fix bugs associated with the codec. (CVS 1846) (check-in: [b0a3becd] user: drh branch: trunk, size: 7635)
2004-06-26
19:35
[212d810e] part of check-in [0f9c0f0a] Coverage testing of pragma.c. (CVS 1744) (check-in: [0f9c0f0a] user: drh branch: trunk, size: 7577)
06:37
[a0dac432] part of check-in [212de3ce] Remove default_synchronous and temp_store pragmas. Allow the safety-level and cache-size to be set for attached databases. (CVS 1735) (check-in: [212de3ce] user: danielk1977 branch: trunk, size: 5695)
2004-06-19
00:16
[e09ac12e] part of check-in [d705d051] Change the name of the TCL command from "sqlite" to "sqlite3" so that both SQLite version 2 and SQLite version 3 can be used by Tcl at the same time. (CVS 1626) (check-in: [d705d051] user: drh branch: trunk, size: 6940)
2004-05-26
06:58
[1b6792d4] part of check-in [93bb958d] Remove the show_datatypes pragma. (CVS 1461) (check-in: [93bb958d] user: danielk1977 branch: trunk, size: 6937)
2004-05-21
02:14
[e763be82] part of check-in [3b55095e] Most sorting problems are fixed. Dead code has been removed. 3 test failures remain but will be fixed by the new function API once it gets implemented. (CVS 1425) (check-in: [3b55095e] user: drh branch: trunk, size: 8713)
2004-05-13
11:34
[06c4e519] part of check-in [dbe8385e] Various minor fixes and updates to make more test cases pass. (CVS 1370) (check-in: [dbe8385e] user: danielk1977 branch: trunk, size: 8723)
2004-04-23
17:04
[24a3f7a6] part of check-in [7ace5762] Get the temp_store and default_temp_store pragmas working. Update the documentation. Also fix a malloc problem that popped up during the regression testing. (CVS 1302) (check-in: [7ace5762] user: drh branch: trunk, size: 8708)
2004-02-11
02:18
[33011f57] part of check-in [5200e9ed] Pass all (relevant) regression tests when using the codec. (CVS 1223) (check-in: [5200e9ed] user: drh branch: trunk, size: 6228)
2003-12-16
03:44
[17ff54f4] part of check-in [b92c31d6] Improvements to the way PRAGMA integrity_check works. More likely to output userful information when given a corrupt database. (CVS 1132) (check-in: [b92c31d6] user: drh branch: trunk, size: 6179)
2003-07-27
17:26
[e7cb7ffd] part of check-in [8c163fc0] Make sure the schema loader callback can handle EMPTY_RESULT_CALLBACKS being on. Ticket #406. (CVS 1065) (check-in: [8c163fc0] user: drh branch: trunk, size: 6178)
2003-06-15
23:42
[4c707a6f] part of check-in [c9734c27] Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: [c9734c27] user: drh branch: trunk, size: 5942)
2003-02-15
23:09
[d45d130f] part of check-in [3ef0ad8a] Fix the pager so that correct rollbacks occur when synchronous is turned off. This check-in also included unrelated documentation updates. (CVS 866) (check-in: [3ef0ad8a] user: drh branch: trunk, size: 5250)
2003-01-18
20:11
[0ca0773e] part of check-in [71cc292d] Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) (check-in: [71cc292d] user: drh branch: trunk, size: 4258)
2003-01-11
14:19
[94c82c75] part of check-in [e84d3afe] Document the SHOW_DATATYPES pragma and add tests for it to the test suite. Make sure datatypes are show even for aliased columns. Tickets #220 and #221. (CVS 822) (check-in: [e84d3afe] user: drh branch: trunk, size: 3550)
2002-03-06
22:01
Added: [0b9675ef] part of check-in [161c0c5f] Added the default_cache_size and default_synchronous pragmas. Added additional tests for pragmas. Added a new speedtest script. (CVS 421) (check-in: [161c0c5f] user: drh branch: trunk, size: 2673)