/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of test/pragma.test

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