/ Timeline
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.

200 most recent check-ins using file test/alter3.test version 25b95a13

2012-08-25
00:49
Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. Leaf check-in: 865dfcba user: drh tags: branch-3.7.2
2011-10-25
21:18
Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil check-in: 89d63a0e user: drh tags: branch-3.7.2
20:36
Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT check-in: 14bc58ca user: drh tags: branch-3.7.2
2011-08-26
18:28
Veryquick and min.rc tests now passing. Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2
18:04
Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. check-in: a42db19d user: drh tags: stat3-3.7.2
17:17
Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. check-in: 41b5f869 user: drh tags: branch-3.7.2
15:51
Get stat3 working after import from trunk-based the stat3-enhancement branch. There is still a problem in the wal2 test. check-in: 01cc4ff6 user: drh tags: stat3-3.7.2
13:52
Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. check-in: 0df04f92 user: drh tags: stat3-3.7.2
2011-07-13
18:53
Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the index is unique or nearly so. check-in: d55b64ef user: drh tags: branch-3.7.2
2011-07-12
14:48
Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. check-in: 7afb2354 user: dan tags: branch-3.7.2
2011-07-02
15:42
Cherrypick change [27c65d4d9c] into the 3.7.2 branch. check-in: 9bbcd8c0 user: dan tags: branch-3.7.2
13:34
Cherrypick [45e581bff7] into the 3.7.2 branch. check-in: c593792c user: dan tags: branch-3.7.2
2011-06-21
15:34
Backport the localtime() failure patch from trunk. Ticket [bd484a090c8077]. Leaf check-in: 2f5b3712 user: drh tags: branch-3.6.1
2011-05-01
22:57
Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. check-in: 7155e6f3 user: drh tags: branch-3.7.2
2011-04-15
15:18
Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. check-in: 8d924e16 user: drh tags: branch-3.7.2
2011-04-09
03:30
Back port the unordered-index-hack to the 3.7.2 branch. check-in: 80353020 user: drh tags: branch-3.7.2
2011-04-08
23:36
Backport test cases from trunk that seek to prove that the IS NOT NULL query optimization is working. check-in: 9eff4702 user: drh tags: branch-3.7.2
23:05
Make sure the query planner is able to correctly analyze NULL value samples in the sqlite_stat2 table. This is a backport of changes from check-in [f73a167b434f] check-in: 1d637889 user: drh tags: branch-3.7.2
23:04
Make sure the left-hand side of the IS NOT NULL operator is a simple column and not a general expression before applying the IS NOT NULL optimization. This is a backport of check-in [543f75a6abe3]. check-in: e8177e01 user: drh tags: branch-3.7.2
2011-03-31
18:36
Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. check-in: a5aae174 user: drh tags: branch-3.7.2
2011-03-17
01:53
Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. check-in: 68daf20d user: drh tags: branch-3.7.2
2011-03-12
05:55
Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from check-in [b86999436e] on the trunk. check-in: 668b91db user: shaneh tags: branch-3.7.2
2011-03-09
22:09
Backport the OP_Next and OP_Prev for UNIQUE indices patch from checkin [f000c9b2b7] on the trunk. check-in: 2d55234e user: drh tags: branch-3.7.2
2011-03-07
16:12
Backport a fix from [6b0cabd017ed25] (version 3.6.16 - 2009-03-05) to the 3.6.1 branch, a fix that prevents a null pointer deref if one of the column access routines such as sqlite3_column_int() is called with a NULL first parameter. check-in: df343640 user: drh tags: branch-3.6.1
2011-03-04
01:23
Backport the query planner enhancement of [952f5e8c69904] to the 3.7.2 branch. check-in: 440d9956 user: drh tags: branch-3.7.2
2011-02-12
14:23
Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. check-in: f2a8b5cc user: drh tags: branch-3.7.2
05:34
Fix problems in the backport, reducing the number of errors in the TCL tests to just a few dozen. Most of the remaining errors seem to be real and desirable changes of behavior. check-in: 9d2b0af2 user: drh tags: branch-3.7.2
01:59
This is the beginning of an attempt to backport recent query planner enhancements to version 3.7.2. The code in this version builds and runs and seems to give correct answers, but it generates suboptimal query plans and hence many of the test cases fail. The test script gives up after 1000 errors. check-in: e72cf118 user: drh tags: branch-3.7.2
2011-01-05
13:07
Cherrypick the WAL error logging from the pre-3.7.5 line into a branch for version 3.7.2. Include the sqlite3_vsnprintf() interface. This checkin is intended for debugging and not for release. Leaf check-in: 6549e767 user: drh tags: wal-trace-372
2010-11-19
04:22
Lemon: Fixed compiler warning on Visual C++. Closed-Leaf check-in: 892c5f37 user: icculus tags: lemon-update-2010
04:19
Lemon: correcting previous win32 access() fix.    The previous fix caused link errors when compiled as C++. check-in: bd03d333 user: icculus tags: lemon-update-2010
03:55
Lemon: Patched to compile with Visual Studio. check-in: 0b945101 user: icculus tags: lemon-update-2010
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] Closed-Leaf check-in: 756589ad user: dan tags: apple-osx-exp
01:53
Back out the prior attempt to enable full-fsync for WAL and attempt the same thing using a completely different approach. check-in: f59949fa user: drh tags: apple-osx-exp
00:47
Experimental changes to test defaulting to fullfsync for WAL mode check-in: 77b343cf user: adam tags: apple-osx-exp
00:43
Integrated proxy locking file support for WAL journal mode and double free fix check-in: fd4d38fa user: adam tags: apple-osx
2010-10-15
14:45
Cherry-pick the change at [2d4505510032bf9] into the 3.6.1 branch. check-in: ecb1419e user: drh tags: branch-3.6.1
2010-10-02
01:01
Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. Leaf check-in: 29a681dd user: drh tags: apple-osx-3623
01:00
Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. Leaf check-in: 265b0b29 user: drh tags: branch-3.6.23
2010-10-01
20:45
Backport the RTree implementation from the trunk into the 3.6.23 branch. The code for the application-defined query boxes is still present but is disabled. The reason for this backport is to take advantage of recent enhancements to robustness to database corruption. check-in: 854b23c1 user: drh tags: branch-3.6.23
2010-09-10
23:16
fixed memory leak in proxy lock file error handling check-in: e01c5f3e user: adam tags: apple-osx
20:19
replaced relative lock proxy paths with absolute check-in: 782c3351 user: adam tags: apple-osx
00:59
replaced relative lock proxy paths with absolute check-in: 6a88cd46 user: adam tags: apple-osx
00:18
Make sure SQLite is running with MEMSTATUS enabled at the beginning of every test script. check-in: b6e9a4d8 user: drh tags: apple-osx
2010-09-09
23:40
Make sure MEMSTATUS is enabled at the beginning of the memsubsys2.test script. check-in: cf23a354 user: drh tags: apple-osx
23:31
The merge for check-in [415c448dc4] did not do exactly write, resulting in a subtle bug in the SQLITE_FCNTL_SIZE_HINT logic. This check-in is the fix. check-in: badaaa18 user: drh tags: apple-osx
2010-09-06
18:50
Add test cases to e_select.test. check-in: 9db26d5e user: dan tags: trunk
18:44
Remove proprietary information from the releasetest.tcl script and add it to the public repository. check-in: e1d4a87e user: drh tags: trunk
2010-09-04
18:52
Add test file e_select.test. check-in: 8b9d8c22 user: dan tags: trunk
2010-09-03
18:50
Documentation enhancements for sqlite3_db_status(). Evidence marks on the SQL function call intrface. check-in: f06c7b19 user: drh tags: trunk
12:05
Improved documentation of the sqlite3_column_count() and sqlite3_data_count() interfaces. check-in: 0593373d user: drh tags: trunk
10:58
Add a few more subquery tests to e_expr.test. check-in: 189cba00 user: dan tags: trunk
04:29
Reduce the amount of memory taken up by WAL mmaped regions under Windows. check-in: f213e133 user: shaneh tags: trunk
03:32
Fix a discrepancy between the documented behavior of SQLITE_DBCONFIG_LOOKASIDE and what it actually does. Also add evidence marks on the DBCONFIG_LOOKASIDE implementation. check-in: f483be44 user: drh tags: trunk
2010-09-02
19:01
Move the test for an (illegal) scalar sub-query that returns more than one column to earlier in SELECT processing in order to avoid an assert() that can happen later on. check-in: a55842cf user: dan tags: trunk
18:13
Fix an off-by-one error in the scratch memory allocator. check-in: 5a959160 user: drh tags: trunk
17:15
Use sqlite3_mutex_notheld() instead of !sqlite3_mutex_held() inside of assert() statements since the former works when mutexing is disabled while the latter does not. check-in: 2211486b user: drh tags: trunk
14:35
Add test case to verify the previous change is correct. check-in: 2a5eed35 user: dan tags: trunk
14:00
Fix the computation of the offset on the mmap() for the Nth shared memory region. Because of the way shared memory is accessed, the old computation, though wrong, still happened to always get the right answer. Nevertheless, it is good to do the computation correctly. check-in: 36397f62 user: drh tags: trunk
11:53
Add tests for the EXISTS operator to e_expr.test. check-in: 9f9a95cc user: dan tags: trunk
10:08
If MEM_STATUS is disabled, avoid holding the STATIC_MEM mutex when calling the user-defined xMalloc method. Holding the mutex causes problems for memsys3 and memsys5. check-in: 4f20f8ba user: dan tags: trunk
04:30
Fix a few typos. Update evidence marks. check-in: c90a68b7 user: shaneh tags: trunk
2010-09-01
19:29
Identify additional requirements in the sqlite3_vfs object documentation. check-in: 47064453 user: drh tags: trunk
18:00
Add tests to quota.test. check-in: ec9af6eb user: dan tags: trunk
16:19
Call quota callback destructors from within sqlite3_quota_shutdown(). check-in: fb80c6f3 user: dan tags: trunk
15:26
Boundary value fix to the descriptive comment at the top of test_quota.c. check-in: 7f6072f0 user: drh tags: trunk
15:22
Merge the test_quota.c module into the trunk. check-in: 2e1a0202 user: drh tags: trunk
15:11
Fix the TCL interface to test_quota.c so that it works with empty callback scripts. Closed-Leaf check-in: 19e95f63 user: drh tags: experimental
14:58
Variable name and comment changes to test_quota.c for clearer presentation. check-in: 38ed1992 user: drh tags: experimental
14:45
Make all private routines in test_quota.c begin with "quota". Fix a test_quota.c segfault when setting a zero-quota. check-in: c0d0fc3a user: drh tags: experimental
14:35
Add the sqlite3_quota_dump test command. Add a destructor argument on the sqlite3_quota_set() interface. check-in: 7a624b5a user: drh tags: experimental
13:09
Clean up comments in the test_quota.c source file. check-in: c1eec7db user: drh tags: experimental
12:50
Update the quota shim so that when the same file is opened multiple times, its size only counts against the quota once. check-in: f5d26380 user: drh tags: experimental
11:50
Add an assert() with an evidence mark to show that automatically generated rowids are positive. check-in: 740adca3 user: drh tags: trunk
11:40
Add file test_quota.c, demonstrating how file-system quotas may be implemented as a VFS wrapper. check-in: 383eb87b user: dan tags: experimental
02:38
Fix some compiler warnings under MSVC. check-in: afdc82a9 user: shaneh tags: trunk
02:37
Ensure randomly generated rowids never go negative. check-in: 63142367 user: shaneh tags: trunk
2010-08-31
16:25
Do not clear the internal "schema has changed" flag when performing a savepoint rollback. The schema changes may not have taken place within the savepoint being rolled back. check-in: c2a84430 user: dan tags: trunk
15:54
Changes to comments and type names in rtree.c. check-in: 7c4f80ad user: dan tags: trunk
15:38
Fix a documentation typo reported on the mailing list. check-in: c9fe0a23 user: drh tags: trunk
15:27
Add evidence mark comments to source code. Add additional information to the documentation of sqlite3_release_memory(). Fix a minor inefficiency in mem1.c that was discovered while writing requirements tests. check-in: 53b0c03f user: drh tags: trunk
15:02
Add the "circle" test geometry callback to test_rtree.c. And tests for the same. check-in: 169b8ba4 user: dan tags: trunk
01:09
Remove unreachable branches to facilitate test coverage. check-in: 86bcb9aa user: drh tags: trunk
2010-08-30
22:15
Provide hints to the btree layer during the creation of transient tables for when it is possible for those tables to use a hash rather than a binary tree. No use is currently made of those hints, though assert() statement verify their accuracy. check-in: 4fead8e7 user: drh tags: trunk
18:39
When generating sqlite3.h, append the contents of sqlite3rtree.h. check-in: fc4d7537 user: dan tags: trunk
16:15
Fix a problem in pagerfault.test uncovered by the previous change. check-in: b6719ce3 user: dan tags: trunk
15:43
Add tests (and associated fixes) to restore coverage of rtree.c. check-in: b06f4695 user: dan tags: trunk
15:02
Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. check-in: 0900e353 user: drh tags: trunk
11:34
Add file sqlite3rtree.h. check-in: e1d9ffce user: dan tags: trunk
01:17
Updates to comments on the VDBE opcodes. check-in: 49c05b4e user: drh tags: trunk
2010-08-28
19:09
Fix problem with func3.test. check-in: aec52959 user: dan tags: trunk
18:58
Add code to allow user-defined searches of r-tree tables. Still largely untested. check-in: 782ca3b7 user: dan tags: trunk
2010-08-27
18:44
Make sqlite3_create_function() a special case of sqlite3_create_function_v2() in order reduce the number of code paths and simplify testing. check-in: 4758d86d user: drh tags: trunk
17:48
Add the sqlite3_create_function_v2() API, a version of create_function that allows a destructor to be specified. check-in: 9a724dfb user: dan tags: trunk
17:16
Refactor the implementation of the scratch memory allocator. Add the SQLITE_TESTCTRL_SCRATCHMALLOC interface to facilitate testing. check-in: a3475ddf user: drh tags: trunk
12:21
Remove unnecessary code from malloc.c. Enhance pcache1.c so that is tries to reuse existing pages, rather than create new pages, when SQLite is under memory pressure. "Memory pressure" means that SQLITE_CONFIG_PAGECACHE memory is nearly exhausted or sqlite3_soft_heap_limit() has been reached. check-in: 51049479 user: drh tags: trunk
11:19
Further tests for CAST in e_expr.test. check-in: 9616df8c user: dan tags: trunk
2010-08-26
19:05
Add tests for CAST expressions to e_expr.test. More to come. check-in: ba6119d1 user: dan tags: trunk
16:46
Add EXTERN macros before entry points in tclsqlite.c. These EXTERN macros were inexplicably removed by [1f680cb37584baa106cee05] a few days ago. check-in: 8b2cf9d4 user: drh tags: trunk
14:15
Fix a couple of memory leaks in r-tree that can occur following an OOM condition. check-in: 1975a27c user: dan tags: trunk
11:27
Remove unreachable condition from rtree.c. check-in: 90f40cd3 user: dan tags: trunk
07:59
Improve coverage of rtree.c some more. check-in: bee1959d user: dan tags: trunk
05:23
Simplification of changes for SQLITE_OMIT_WAL support in pager.c. check-in: afb2484c user: shaneh tags: trunk
2010-08-25
20:35
Reinstate the "sqlite" alias for backwards compatibility (but leave it undocumented) but remove the PackageProvide for "sqlite". check-in: 699cc6b4 user: drh tags: trunk
19:39
Disable the legacy "sqlite" command in the TCL interface. Provide only the "sqlite3" command. check-in: 909b3d88 user: drh tags: trunk
19:04
Further test coverage improvements for rtree.c. check-in: 05f6c1ae user: dan tags: trunk
17:53
Test cases to improve coverage of rtree module. Fixes associated with the same. check-in: 865cec04 user: dan tags: trunk
2010-08-24
20:46
Replicate asserts on unixOpen() to winOpen() in os_win.c. check-in: 40526d83 user: shaneh tags: trunk
18:35
Changes to support building with SQLITE_OMIT_WAL. check-in: d1ed743b user: shaneh tags: trunk
18:07
Change sqlite3_open_v2() to return SQLITE_MISUSE if the combination of bits in the flags parameter is invalid. The documentation says the behavior in this situation is undefined - the documentation is unaltered by this code change. check-in: 5e8101c5 user: drh tags: trunk
18:06
Comment enhancements and typo fixes in pcache1.c. check-in: c2dc39c0 user: drh tags: trunk
16:59
Fixes to allow fts3 tables to be renamed mid-transaction. check-in: d1c87532 user: dan tags: trunk
13:11
Add tests to e_expr.test. check-in: 5c1c694e user: dan tags: trunk
12:05
Pull the incremental_vacuum bug fix ([255f1eefa373153942c67b18b]) and the R-tree segfault bug fix ([7f2f71cc9e3c39093f09231f44]) into the 3.6.23 branch. Increase the version number to 3.6.23.3. check-in: bcbdecd8 user: drh tags: branch-3.6.23
02:10
Cherrypick the R-tree invalid shadow-table big fix of [7f2f71cc9e3c39093f09231f44] into the apple-osx 3.6.23 branch. check-in: 68103d91 user: drh tags: apple-osx-3623
01:59
Cherrypick the incremental_vacuum bug fix ([255f1eefa373153942c67b18b]) into the apple-osx 3.6.23 branch. check-in: 60f16838 user: drh tags: apple-osx-3623
01:51
Merge in the R-tree fix from the trunk. check-in: 02ee0bd5 user: drh tags: apple-osx
01:49
The R-tree module should not assume that its shadow tables are consistent. If a problem is found in a shadow table, return SQLITE_CORRUPT. check-in: 7f2f71cc user: drh tags: trunk
01:08
Merge changes through release 3.7.2 into the apple-osx branch. check-in: 415c448d user: drh tags: apple-osx
00:40
Version 3.7.2 check-in: 42537b60 user: drh tags: trunk, release, version-3.7.2
2010-08-23
18:19
Fixes for the SQLITE_CHECK_PAGES debugging feature. check-in: 21a1e596 user: dan tags: trunk
17:09
Update the version number in preparation for the 3.7.2 release. check-in: 77889510 user: drh tags: trunk
15:41
Fix for ticket [5e10420e8d]. check-in: 255f1eef user: dan tags: trunk
15:26
Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. check-in: 1070918e user: drh tags: trunk
01:25
Version 3.7.1 check-in: 3613b069 user: drh tags: trunk, release
2010-08-21
15:51
Add some tests to e_expr.test and pagerfault.test. No code changes. check-in: 44de3cab user: dan tags: trunk
15:09
Fix the ptrmapPageno() routine so that it works correctly for an input of 1. check-in: 699a9bf2 user: drh tags: trunk
2010-08-20
15:32
Do not allow a backup to change the page size if a codec is in use. check-in: 5523ecd3 user: drh tags: trunk
12:43
Fix typo in backcompat.test. check-in: 6a0cbb27 user: dan tags: trunk
12:34
Merge leaf created by accident. check-in: 1f680cb3 user: dan tags: trunk
12:31
Avoid assuming that the user has "." in their path when running multi-process tests. check-in: daa5d461 user: dan tags: trunk
10:28
Do not attempt run backwards compatibility tests if no historical "testfixture" binaries are available. check-in: 40e11aab user: drh tags: trunk
09:53
Disable the MEMSYS2 auxiliary routines if MEMSYS2 is changed to an alternative memory allocator using SQLITE_CONFIG_MALLOC. check-in: 541dd3b8 user: drh tags: trunk
09:14
Fix the sqlite3_release_memory() interface so that it does not attempt to free SQLITE_CONFIG_PAGECACHE memory. check-in: 0426cd62 user: drh tags: trunk
2010-08-19
18:05
Adjust filename globbing in backcompat.test for Windows. check-in: b0f47963 user: shaneh tags: trunk
17:16
Fix backcompat.test so that it works with windows mandatory locking. check-in: 8d05f66d user: dan tags: trunk
15:48
Add tests for WAL mode to test/backcompat.test. check-in: 7999910e user: dan tags: trunk
15:12
Merge two leaves. check-in: b03091fc user: dan tags: trunk
15:11
Modify the code for reading hot-journal files so that it can handle journals generated by versions 3.5.7 and earlier. check-in: b9170f29 user: dan tags: trunk
14:41
Fix typo in TCL stubs support for configure in Makefile.in check-in: 4c7ad73d user: shaneh tags: trunk
14:22
Remove a NEVER from balance_quick() that can occur in WAL mode on a corrupt database file. check-in: b273891a user: drh tags: trunk
11:05
Add new test script backcompat.test, for testing database/journal/wal file compatibility against previous versions. check-in: 8804f498 user: dan tags: trunk
2010-08-18
21:19
Fix two asserts in the btree logic so that they work correctly even for maximum-size index entries for 32K and 64K pages. check-in: e127192d user: drh tags: trunk
17:16
Updated tests for CLI. Added some basic tests for the .import command. check-in: d46567e5 user: shaneh tags: trunk
15:25
Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. check-in: 56cc883d user: dan tags: trunk
14:54
Fix issue with wal.test on Windows. check-in: 3497f54a user: shaneh tags: trunk
02:28
Fix some compiler warnings in the MSVC build. check-in: 1f5662b7 user: shaneh tags: trunk
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. check-in: 866e9286 user: drh tags: apple-osx
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 check-in: 5e2ee7db user: adam tags: apple-osx
2010-08-17
23:13
Cherrypick the changes for enhancement requests [e090183531fc27474] (use indices on LIKE with no wildcards) and [4711020446da7d93d993] (use nocase index for LIKE even if the column is binary) into the 3.6.23.1 release of the Apple-OSX branch. check-in: 220cca50 user: drh tags: apple-osx-3623
19:49
Remove a NEVER() that is actually reachable. check-in: acb171d4 user: drh tags: trunk
19:40
Suppress harmless compiler warning. check-in: 3f8c068a user: drh tags: trunk
19:34
Return an error when parsing "?NNN" if NNN is so large it cannot be stored as a 32-bit int. check-in: fc9014be user: dan tags: trunk
18:37
It is no longer possible to reach pagerStress() while in the error state, so put a NEVER() around the error state test of that routine. check-in: d7ed4634 user: drh tags: trunk
18:15
If an SQLITE_FULL error occurs during rollback or journal finalization, treat it in the same way as SQLITE_IOERR (i.e. require that the pager internals be completely reset before it is next read from or written to). check-in: 8ac18523 user: dan tags: trunk
17:25
Changes to pager for improved testability. check-in: 61c64b3a user: drh tags: trunk
16:06
Add tests for the BETWEEN operator to e_expr.test. check-in: ced6a348 user: dan tags: trunk
14:52
Invoke sqlite3_log() whenever one or more frames are recovered from a WAL file. check-in: e05089aa user: dan tags: trunk
05:55
Fix some non-ANSI C code in test_demovfs.c. Also change the same file so that attempting to delete a file that does not exist does not return an error. check-in: 07570ce3 user: dan tags: trunk
2010-08-16
20:02
Remove an superfluous branch from pager.c. check-in: 4271a95c user: drh tags: trunk
19:23
Add tests for different page sizes to wal.test. Including 64K pages. check-in: d95bcc05 user: dan tags: trunk
18:26
Add test cases designed to exercise all syntax diagram paths in lang_expr.html check-in: d4a26bb6 user: dan tags: trunk
16:31
Fix a typo in a comment in wal.c. No code changes. check-in: d854a3d4 user: drh tags: trunk
14:18
Add ALWAYS() macros in wal.c to cover branches that are no longer reachable following the pager refactoring. check-in: 24f24c92 user: drh tags: trunk
2010-08-14
21:21
Adjustments for better 64K page size handling. check-in: faf1974e user: drh tags: trunk
18:32
Add test case to e_expr.test. check-in: db9539f2 user: dan tags: trunk
17:12
Change sqlite3PagerPagecount() to return void, since the return value was always SQLITE_OK and was never used. check-in: 7dd78eb7 user: drh tags: trunk
16:02
Minor simplifications to btree.c in support of full-coverage testing. check-in: 364df6c7 user: drh tags: trunk
12:42
Tweaks to comments in pager.c. Fix two compiler warnings. check-in: 68a49f7f user: drh tags: trunk
12:25
Add test cases to e_expr.test. check-in: d8bbab78 user: dan tags: trunk
05:04
Test that it is possible to drop a trigger while there are active statements belonging to the same connection. check-in: d4ec61e2 user: dan tags: trunk
2010-08-13
18:41
Add tests to test file e_expr.test. check-in: 3fd1059e user: dan tags: trunk
16:38
Do not apply the flattening optimization if the sub-query is DISTINCT. Fix for [e4b8a2ba6e]. check-in: 497aafd8 user: dan tags: trunk
2010-08-12
16:36
If an error occurs in PagerSetPagesize(), set the output variable to the unmodified page-size before returning. check-in: 02def8f9 user: dan tags: trunk
11:25
Add coverage tests for pager.c. check-in: 228c5b16 user: dan tags: trunk
02:41
Increase the maximum page size from 32k to 64k. check-in: 45362437 user: drh tags: trunk
2010-08-11
18:56
Improve coverage of pager.c. check-in: 2fa05d01 user: dan tags: trunk
12:26
Update an r-tree extension test case to account for recent changes to the query planner. Also fix a comment in rtree.c. check-in: eaaca669 user: dan tags: trunk
11:59
Use sqlite3DbFree() instead of sqlite3_free() to free any error message reported by the parser layer while attempting to parse a CREATE TABLE statement passed to sqlite3_declare_vtab(). check-in: 7c674aab user: dan tags: trunk
11:35
Fixes to tcl test files so that they work in auto-vacuum mode. check-in: ea9eaf74 user: dan tags: trunk
06:14
Fix memory allocation in proxy locking so that it works with SQLITE_MEMDEBUG. check-in: f854cbe0 user: drh tags: trunk
06:04
Merge experimental changes into trunk. check-in: aa092ac9 user: dan tags: trunk
2010-08-10
15:46
Fix a bug in pager.c causing it to omit the xSync() call required following a hot-journal rollback. Closed-Leaf check-in: 42ba43ac user: dan tags: experimental
09:58
Add variable pager.dbHintSize, used to limit the number of calls made to the xFileControl(FCNTL_SIZE_HINT) method. check-in: eb3ac895 user: dan tags: experimental
07:12
Changes to debugging code in mutex_unix.c and mutex_w32.c to make an assert() statement threadsafe. check-in: e82e32bd user: dan tags: trunk
2010-08-09
19:17
Modify some comments in pager.c. check-in: 5662da6d user: dan tags: experimental
16:52
Merge latest trunk changes with experimental branch. check-in: aecbd890 user: dan tags: experimental
16:12
Fix a memory leak in test_journal.c causing tests to fail. check-in: f229487c user: dan tags: experimental
15:44
Fix typos in comments. No functional changes to the code. check-in: 9cebaf2d user: drh tags: trunk
14:47
Change to tcl test infrastructure so that --malloctrace=1 works when sizeof(int)!=sizeof(void*). check-in: c3e771b3 user: dan tags: experimental
14:26
Fix two comment typos that were reported on the mailing list. check-in: 88bf9016 user: drh tags: trunk
07:51
Fix a problem causing the return code of an xSync call to be ignored in wal.c. check-in: f1b2b5f9 user: dan tags: experimental
07:07
In WAL mode, ignore any error returned by an xFileControl(FCNTL_SIZE_HINT) call. This matches the behaviour in rollback mode. check-in: 158a3097 user: dan tags: experimental
2010-08-07
16:17
Fix minor problems and update comments in pager.c. check-in: 92e45637 user: dan tags: experimental
11:46
Merge in all changes up to the 3.7.0.1 release. check-in: f88c6367 user: drh tags: apple-osx
09:31
Fix a problem wherein changing the journal-mode immediately after leaving exclusive-locking mode could lead to the database being unlocked without clearing the changeCountDone flag. check-in: 531abc80 user: dan tags: experimental
05:15
Add test case 'cgt_pager_1', intended for use with callgrind to detect performance regression in the pager module, to threadtest3.c. check-in: b5d46f1e user: dan tags: experimental
2010-08-06
19:00
Remove all vestiges of ctype.h from FTS3. This addresses ticket [991789d9f3136a] among other bug reports. check-in: b8b465ed user: drh tags: trunk
17:18
Further enhancements to comments in pager.c. check-in: 876162c7 user: dan tags: experimental
14:37
Fix some problems with running test scripts with the inmemory_journal permutation. check-in: 7bd8ba08 user: dan tags: experimental