/ File History
Login

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

History of test/pager1.test

2018-11-10
20:07
Merge the read-only shadow table and defensive mode enhancments from trunk. file: [a309660a] check-in: [977fc44e] user: drh branch: apple-osx, size: 86835
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: [1e9ee778] check-in: [3212733c] user: drh branch: read-only-shadow, size: 86258
2018-05-07
13:01
Merge enhancements from trunk, and especially the cell-overwrite optimization. file: [cfd1c1dd] check-in: [cb3aa778] user: drh branch: apple-osx, size: 86765
2018-05-03
16:56
Fix various error handling conditions on the cell overwrite optimization. Fix a test case so that it works with the new optimization. file: [a32ce299] check-in: [f89b54f4] user: drh branch: cell-overwrite-prototype, size: 86188
2018-01-15
21:59
Merge the enhancements associated with the first 3.22.0 beta. file: [9fe51801] check-in: [c9d2ec51] user: drh branch: apple-osx, size: 86765
2018-01-13
13:21
Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. Cherrypick of [56d93d07]. file: [9475f2a4] check-in: [6a296d4d] user: dan branch: branch-3.19, size: 86204
13:07
Fix various problems in test scripts preventing "make test" from passing on F2FS file-systems with the "atomic-write" feature. file: [f596d3bd] check-in: [56d93d07] user: dan branch: f2fs-test-fixes, size: 86188
2017-07-17
20:21
Merge all the latest fixes and enhancements from trunk. file: [4064c556] check-in: [e181225d] user: drh branch: apple-osx, size: 86703
2017-07-10
12:07
Update error message text for standard error codes to better describe the latest usage of those error codes. Modify sqlite3_open_v2() so that it does return a valid sqlite3 object in the event of SQLITE_MISUSE due to bad open flags, so that sqlite3_errmsg() does not report "out of memory" in that case. file: [8149b2a8] check-in: [f27b6370] user: drh branch: trunk, size: 86126
2016-03-15
12:45
Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts so that they work with SEE. file: [15d42376] check-in: [f41a7361] user: drh branch: apple-osx, size: 86719
2016-03-14
20:49
Changing page size using VACUUM or backup is not allowed with a codec attached. file: [84186801] check-in: [92be06c1] user: drh branch: see-testing, size: 86142
2016-02-22
16:32
Merge the master-journal optimization and other recent changes from trunk. file: [c92c8acd] check-in: [18c3ab47] user: drh branch: apple-osx, size: 85872
14:57
Avoid creating a master journal unless two or more databases in the transaction can actually benefit from that master journal. file: [f49df1a8] check-in: [3ed18906] user: drh branch: trunk, size: 85295
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: [1c39b52a] check-in: [9411d7dc] user: drh branch: apple-osx, size: 84339
2014-02-12
15:05
Various fixes and test case updates so that veryquick.test passes again. file: [c609ea28] check-in: [f352ef57] user: dan branch: deferred-open, size: 83762
2013-11-05
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [1acbdb14] check-in: [54b22192] user: drh branch: omit-rowid, size: 83762
2013-06-10
23:30
Fix test cases for the new EXPLAIN QUERY PLAN format. Add the wherecosttest tool. Other fixes to logarithm cost. file: [16b649c8] check-in: [aa580e36] user: drh branch: nextgen-query-plan-logcost, size: 83739
2013-04-15
17:03
Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. file: [30e63afd] check-in: [ea1404a1] user: drh branch: trunk, size: 83740
2013-04-06
11:03
Add tests to "permutations.test coverage-pager" to cover uncovered branches. file: [13414486] check-in: [07a0e4e9] user: dan branch: trunk, size: 83744
2013-04-05
20:40
Improve the code coverage of "permutations.test coverage-pager". file: [622bfaea] check-in: [b095e2cd] user: dan branch: trunk, size: 81216
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: [aa819efb] check-in: [0e3d5119] user: dan branch: two-mappings, size: 76711
2013-03-05
15:27
Do not attempt to set the permissions on an existing journal or wal file. Do this only immediately after creating a new file (or opening one zero bytes in size). file: [31c04bec] check-in: [1d808690] user: dan branch: experimental, size: 76559
2013-01-04
20:45
Do not use umask() since it change the umask for the entire process, not just the thread using SQLite. Make whatever permission changes are needed using fchmod() after the file is created, instead. file: [8e14e7cf] check-in: [6c4c2b7d] user: drh branch: trunk, size: 76537
2012-11-09
20:17
Change os_unix.c to propagate ENOENT errors back to sqlite as SQLITE_IOERR_DELETE_NOENT. Have SQLite ignore these where they are benign and propagate them back to the caller where they may indicate a file-system malfunction of some description. file: [f4c57e14] check-in: [bed9c172] user: dan branch: trunk, size: 76416
2012-10-13
19:58
Ensure that when the source of a backup is a database that is zero bytes in size, the final destination database consists of at least one page. Truncating it to zero bytes is equivalent to zeroing the schema cookie and change counter, which can cause problems for existing clients. file: [07116f72] check-in: [af5c9ee4] user: dan branch: zero-byte-backup-fix, size: 75650
2012-06-08
01:13
Merge trunk changes into the apple-osx branch. file: [f1f261a4] check-in: [9d1b8515] user: drh branch: apple-osx, size: 76224
2012-05-17
21:04
Merge updates from trunk. file: [2163c6ef] check-in: [224c65e4] user: mistachkin branch: winrt, size: 75647
2012-05-12
14:59
Merge trunk changes with apple-osx branch. file: [717d4fbe] check-in: [bf57f0fb] user: dan branch: apple-osx, size: 75228
2012-05-11
23:03
Adjust some of the pager tests to accommodate longer database pathnames. file: [31fef8ff] check-in: [22eef1d8] user: drh branch: trunk, size: 74651
2012-05-09
22:36
Added support for SQLITE_ENABLE_PERSIST_WAL compile time macro, retrieving lastErrno from WAL file and setting last errno when writes fail due to space constraints file: [99cf69a8] check-in: [65479294] user: adam branch: apple-osx, size: 75228
2012-04-02
23:35
Merge in latest changes, autologging options, read only file system wal support, test config conditionalization, WAL frame write prebuffering file: [4fbf634d] check-in: [d51c086e] user: adam branch: apple-osx, size: 75151
2012-03-31
02:46
Merge all the latest trunk changes into the apple-osx branch. file: [34fb695d] check-in: [18ec60ca] user: drh branch: apple-osx, size: 75035
2012-03-30
14:01
Merge the latest trunk changes into the winrt branch. file: [819a0ecc] check-in: [a1a85b84] user: drh branch: winrt, size: 75647
2012-03-28
01:34
Evaluate typeof(X) and length(Y) where X is any column and Y is a blob column without actually loading X and Y from disk. file: [eb6d64d2] check-in: [b899dbeb] user: drh branch: faster-typeof-and-length, size: 74651
2012-03-19
23:32
Merge updates from trunk. file: [41995062] check-in: [4ab1ffd4] user: mistachkin branch: winrt, size: 74748
16:21
Merge latest trunk changes into apple-osx branch. file: [20a99956] check-in: [f999197b] user: dan branch: apple-osx, size: 74136
2012-03-17
15:12
In pager1.test, use "file attr test.db -readonly 0" before "file attr test.db -perm rw-rw-rw-", not after. file: [cf8f40cf] check-in: [4f5283f1] user: dan branch: trunk, size: 73752
2012-03-15
21:28
Add the sqlite3_db_readonly() interface. This is still tentative, pending a closer look at other ideas to accomplish the same thing. file: [6e43e79d] check-in: [254f99ea] user: drh branch: db-readonly-api, size: 73748
2012-03-08
20:22
Merge and manually resolve testing updates from trunk. file: [4be3dacf] check-in: [5eecdb44] user: mistachkin branch: winrt, size: 74246
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: [101032cb] check-in: [82bcd7ec] user: mistachkin branch: trunk, size: 73250
2012-03-05
22:52
Add compile-time define to indicate if the VFS supports the concept of a current directory (as WinCE and WinRT do not). Avoid using the GetTempPath and GetFullPathName APIs on WinRT. Some tests still need adjustments. file: [a306c33e] check-in: [86c049a1] user: mistachkin branch: winrt, size: 74234
2012-02-10
18:18
Pull the latest trunk changes into the apple-osx branch. file: [5ee48e6e] check-in: [e2485986] user: drh branch: apple-osx, size: 73622
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. file: [efef0bb4] check-in: [96900c47] user: drh branch: trunk, size: 73238
2012-01-03
21:54
Pull all the latest trunk changes over into the apple-osx branch. file: [0b5d05d5] check-in: [8a048423] user: drh branch: apple-osx, size: 75613
2011-12-19
11:57
Merge [21b76af6ed] into statvfs branch. file: [9e9f5f1c] check-in: [e694f7b1] user: dan branch: statvfs, size: 75229
11:16
Fix a couple of test cases to account for the master-journal name related change in [cf3bccc2]. file: [b936e805] check-in: [21b76af6] user: dan branch: trunk, size: 75213
00:31
Some fixes to the test suite so that it works with ZERO_DAMAGE set to true. Still lots more problems remain. file: [6fad92de] check-in: [41891b23] user: drh branch: statvfs, size: 74527
2011-10-11
14:19
Merge the latest trunk changes into the apple-osx branch. file: [30058ab9] check-in: [7e2c4898] user: drh branch: apple-osx, size: 74895
2011-10-08
14:57
Add the SQLITE_DIRECT_OVERFLOW_READ compile time option. file: [1b630b32] check-in: [2ab14a84] user: dan branch: trunk, size: 74511
2011-09-24
05:55
Fix some test files so that they work with SQLITE_OMIT_WAL builds. file: [c8f202a4] check-in: [a38668dc] user: dan branch: trunk, size: 74336
2011-09-14
19:05
Merge in the latest changes from trunk. file: [1fb47476] check-in: [2456b4d0] user: drh branch: apple-osx, size: 74720
2011-08-29
11:56
Back out [05c9832e5f6eb] since it was causing a performance regression with no obvious benefit. file: [2d3a7c6f] check-in: [639cc85a] user: drh branch: trunk, size: 74268
2011-08-26
19:18
Merge the latest trunk changes into the apple-osx branch. file: [21ec8ef9] check-in: [55af8003] user: drh branch: apple-osx, size: 74677
2011-08-25
01:16
Make sure that SQLITE_FCNTL_SIZE_HINT on Windows does not shrink the file. file: [70c94c89] check-in: [d4f6437f] user: mistachkin branch: winNativeHeap, size: 74225
2011-08-23
18:06
Merge latest trunk changes into the apple-osx branch. file: [abddd000] check-in: [c5f7977b] user: dan branch: apple-osx, size: 73617
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: [7fc949cc] check-in: [9007586f] user: mistachkin branch: winopen-retry-logic, size: 73165
2011-06-25
16:35
Fix test cases so that they work with SQLITE_DEFAULT_WAL_SAFETYLEVEL defined. file: [52725f1e] check-in: [8f8b373e] user: dan branch: apple-osx, size: 73645
2011-06-24
20:47
Merging local changes to apple-osx file: [4b7c08ca] check-in: [34f0efa2] user: adam branch: apple-osx, size: 73310
2011-06-17
07:07
Add Microsoft nmake compatible makefile; update a few test cases for Windows. file: [228a8310] check-in: [a7590af6] user: shaneh branch: trunk, size: 73193
2011-05-05
19:44
Changes to various test scripts so that they pass on windows. file: [8baf4470] check-in: [1586244b] user: dan branch: win32-test-fixes, size: 73054
2011-04-23
10:12
Fix parsing of %00 in uri handling code. file: [2f2f9341] check-in: [44f0874a] user: dan branch: uri, size: 73014
2011-02-02
16:34
Merge in the blocking-checkpoint enhancement, including the new sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. file: [d8672fd0] check-in: [bac7342c] user: drh branch: trunk, size: 73009
2011-01-11
17:39
Add the SQLITE_FCNTL_SYNC file-control. file: [7006a8b5] check-in: [b3f2f465] user: dan branch: trunk, size: 73002
2010-11-23
18:59
Fix the max_page_count pragma so that it will not set to a value smaller than the current database size, as the documentation requires. Also, remove all occurances of atoi() from the core. file: [e066fb2e] check-in: [2031974b] user: drh branch: trunk, size: 73014
2010-11-18
16:14
Update test cases to account for the change in the previous commit. file: [1e073687] check-in: [ae089ec8] user: dan branch: blocking-checkpoint, size: 73021
2010-11-09
00:43
Integrated proxy locking file support for WAL journal mode and double free fix file: [4d3bf78c] check-in: [fd4d38fa] user: adam branch: apple-osx, size: 71257
2010-11-01
18:45
Add test cases to restore coverage of pager.c and wal.c. file: [07b06b89] check-in: [6cae5529] user: dan branch: trunk, size: 73014
17:38
If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory. file: [fa74657d] check-in: [8dd5c691] user: dan branch: trunk, size: 70858
2010-08-24
18:35
Changes to support building with SQLITE_OMIT_WAL. file: [12ad2028] check-in: [d1ed743b] user: shaneh branch: trunk, size: 70846
2010-08-18
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. file: [3c43e01a] check-in: [866e9286] user: drh branch: apple-osx, size: 71301
00:09
Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments file: [8343530e] check-in: [5e2ee7db] user: adam branch: apple-osx, size: 67927
2010-08-12
16:36
If an error occurs in PagerSetPagesize(), set the output variable to the unmodified page-size before returning. file: [6922029d] check-in: [02def8f9] user: dan branch: trunk, size: 70660
11:25
Add coverage tests for pager.c. file: [8b6e57d8] check-in: [228c5b16] user: dan branch: trunk, size: 70286
02:41
Increase the maximum page size from 32k to 64k. file: [9a7650f9] check-in: [45362437] user: drh branch: trunk, size: 68306
2010-08-11
18:56
Improve coverage of pager.c. file: [20457c96] check-in: [2fa05d01] user: dan branch: trunk, size: 68306
2010-07-07
13:54
Make sure the schema is loaded before preparing a "PRAGMA journal_mode" command. This helps it return meaningful results when it is the first command executed by a new database connection. file: [d8e4b2bc] check-in: [ef126e77] user: dan branch: trunk, size: 67287
11:05
Change the async-IO extension to return SQLITE_IOERR_SHORT_READ when appropriate. This prevents a valgrind warning in the test suite. file: [5352bec6] check-in: [d9e32879] user: dan branch: trunk, size: 67285
2010-07-06
20:34
Changes to pager1.test to support Windows. file: [c3a0c973] check-in: [fce689eb] user: shaneh branch: trunk, size: 67206
2010-07-03
13:45
Fix an assert in pager.c. And various test cases that fail with the in-memory journal permutation. file: [1fc67606] check-in: [78fc35ff] user: dan branch: mistake, size: 67019
10:00
Fix an assert() in pager.c added by the previous commit. And various problems with test scripts in autovacuum and in-memory journal mode. file: [b345014c] check-in: [62a10101] user: dan branch: mistake, size: 66725
2010-07-02
13:49
Run tkt-9d68c883.test along with the other pager.c coverage tests. Add a test case to pager1.test. file: [14c8e432] check-in: [c6714b0d] user: dan branch: trunk, size: 66299
11:27
Additional test cases to cover branches in pager.c. file: [4984a90b] check-in: [eddfb2b4] user: dan branch: trunk, size: 65947
2010-07-01
19:01
Add tests to pager1.test and pagerfault.test. file: [67de7de4] check-in: [c6e75950] user: dan branch: trunk, size: 64440
15:09
Add pager test cases. Change a condition in pager.c to NEVER(). file: [f00c701b] check-in: [a8f6341d] user: dan branch: trunk, size: 59926
2010-06-30
10:36
Add further test cases. Fix an assert() in pager.c. file: [a87a7dff] check-in: [8e65c0e3] user: dan branch: trunk, size: 55062
04:29
Add coverage test cases. Have sqlite3_backup_step() transform SQLITE_IOERR_NOMEM to SQLITE_NOMEM before returning. file: [4d83d4ac] check-in: [5e19bc36] user: dan branch: trunk, size: 52998
2010-06-29
10:30
Add tests to pager1.test and pagerfault.test. file: [28709653] check-in: [008513ee] user: dan branch: trunk, size: 50254
2010-06-28
19:04
Add extra pager tests. file: [634c62f8] check-in: [6b7e419d] user: dan branch: trunk, size: 42934
11:23
Fix some errors when compiling with SQLITE_OMIT_WAL. file: [d8dfe2f8] check-in: [3b68cb9c] user: dan branch: trunk, size: 36790
2010-06-26
15:42
When synchronous=NORMAL, use the same journal file format as with synchronous=FULL (i.e. multiple journal headers within the one journal). Fix for [d11f09d36e]. file: [18d35466] check-in: [2eaf5ee0] user: dan branch: trunk, size: 36692
2010-06-25
19:09
Further test cases for pager1.test and pagerfault.test. file: [dfb695c9] check-in: [bfd563c4] user: dan branch: trunk, size: 35723
2010-06-24
19:16
Add test cases to pager1.test and pagerfault.test. file: [b7099656] check-in: [4941e437] user: dan branch: trunk, size: 34981
10:50
Add coverage tests. Remove a NEVER macro from pager.c, as the condition can now be true in wal mode. file: [2fb769a4] check-in: [7aac9ad6] user: dan branch: trunk, size: 29699
2010-06-23
15:55
Add a version number to the wal-index header. If SQLite encounters a version number in either the wal or wal-index files that it does not understand, the operation is abandoned and SQLITE_CANTOPEN returned. file: [31478e94] check-in: [8d0f8a7f] user: dan branch: trunk, size: 26000
2010-06-22
13:46
Some changes to test scripts related to codec enabled versions of sqlite. file: [c3ec0855] check-in: [85dd51a7] user: dan branch: trunk, size: 25625
2010-06-21
18:29
Add test cases to pager1.test and pager2.test. file: [07e839e5] check-in: [cc9ddae6] user: dan branch: trunk, size: 25459
12:34
Change things so that journal2.test works with ENABLE_ATOMIC_WRITE. file: [86d034bf] check-in: [a64d96db] user: dan branch: experimental, size: 23219
07:45
Add further pager tests. file: [e086d98a] check-in: [4104b175] user: dan branch: experimental, size: 18314
2010-06-19
17:26
Add tests to pager1.test and pagerfault.test. file: [2842b356] check-in: [f5df83fd] user: dan branch: experimental, size: 18735
11:30
Add tests to pager1.test and pagerfault.test. file: [d71580a4] check-in: [58c0b5bf] user: dan branch: experimental, size: 14496
2010-06-18
18:59
Add tests to pager1.test. file: [f2806eeb] check-in: [582fca89] user: dan branch: experimental, size: 13888
2010-06-16
12:30
Add extra test cases to pager1.test. file: [60dec408] check-in: [ad320957] user: dan branch: trunk, size: 10717
10:55
Fix a memory leak that can occur in os_unix.c if an IO error occurs within the xUnlock method. file: [4e75fc0e] check-in: [6c5c04ee] user: dan branch: trunk, size: 7290
2010-06-15
19:07
Rationalize a common pattern in tcl test cases into proc do_multiclient_test. file: [fd1ca712] check-in: [efe44564] user: dan branch: trunk, size: 5928
17:44
Add test file pager1.test, containing tests of inter-process locking in non-wal mode. file: [dcc50ea9] check-in: [6e43eed9] user: dan branch: trunk, size: 7236 Added