SQLite

Timeline
Login

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

100 check-ins occurring around 042a1abb03.

2010-08-14
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
13:53
Merge trunk changes into experimental branch. check-in: aef6698c user: dan tags: experimental
13:50
Do not run some tests in notify3.test with the inmemory_journal permutation. They do not pass as the tests assume that the database schema is not loaded until the first invocation of [db eval]. This is not true with the inmemory_journal permutation. check-in: 698fba82 user: dan tags: trunk
12:00
Further updates to comments in pager.c. check-in: 5f4c17a3 user: dan tags: experimental
09:43
Modify test_journal.c to work with pre-allocated databases. check-in: 4894a5d2 user: dan tags: experimental
06:54
Fix a bug to do with deleting the journal file when exiting exclusive-locking mode. check-in: 6217b607 user: dan tags: experimental
02:10
Change two automatic array variables into static constant arrays. Update and reformat some comments for cleaner presentation. check-in: a7a15547 user: drh tags: trunk
2010-08-05
18:53
Add comments describing UNKNOWN_LOCK to pager.c. Improve some other comments in the same file. check-in: 54eff6de user: dan tags: experimental
16:22
Merge trunk changes with experimental branch. check-in: acd26b8b user: dan tags: experimental
16:08
Catch an error code that was not being propagated back to the caller. check-in: 800f4969 user: dan tags: experimental
15:30
Fixes for error handling with temp databases. And for errors that occur within OS locking primitives. check-in: f99a902f user: dan tags: experimental
11:56
Make the size of a Bitvec object 512 bytes on all platforms, instead of having the size depend on the size of a pointer. This makes testing easier. check-in: ca479f3d user: drh tags: trunk
03:21
Do not read the database file size on a SAVEPOINT rollback any more since after checkin [65b8636ac6e5] the in-header-size field is always valid. check-in: fbe70e11 user: drh tags: trunk
02:52
Fix the query planner so that when it has a choice of full-scan tables to move to the outer loop, it chooses the one that is likely to give the fewest output rows. Ticket [13f033c865f878]. check-in: 309bbedf user: drh tags: trunk
2010-08-04
21:17
If the outer loop of a join must be a full table scan, make sure that an incomplete ANALYZE does not trick the planner into use a table that might be indexable in an inner loop. Ticket [13f033c865f878] check-in: e7a714b5 user: drh tags: trunk
19:14
Fix some problems with error recovery introduced while reworking pager state. check-in: 77eaab6f user: dan tags: experimental
12:31
Version 3.7.0.1 Leaf check-in: 042a1abb user: drh tags: release, branch-3.7.0
12:19
Update the version number to 3.7.0.1. check-in: 5074b859 user: drh tags: branch-3.7.0
12:13
Backport fix [267492d3a7eff7b] for the performance regression caused by automatic indexing and reported by ticket [8011086c85c6c4040]. check-in: 3f367fe0 user: drh tags: branch-3.7.0
11:59
Backport the [65b8636ac6e5] fix for ticket [51ae9cad317a1] to version 3.7.0. check-in: dec70c63 user: drh tags: branch-3.7.0
11:34
When opening a write-transaction on a database file that has been appended to or truncated by a pre-3.7.0 client, update the database-size field in the database header. Fix for [51ae9cad31]. check-in: 65b8636a user: dan tags: trunk
2010-08-03
18:29
Merge trunk changes into experimental branch. check-in: 15368a9f user: dan tags: experimental
18:18
Set the Pager.eState variable to PAGER_ERROR whenever the pager enters the error state. check-in: 4d384761 user: dan tags: experimental
18:06
Fix disabled implementation-mark comments in func.c. check-in: 57c09600 user: drh tags: trunk
15:57
Add comments to clarify the purpose of the pager "error state". check-in: fde4c597 user: dan tags: experimental
13:08
Fix the REPLACE conflict resolution so that it falls back to ABORT when a CHECK constraint fails. Ticket [c38baa3d969eab794]. check-in: 4e157b77 user: drh tags: trunk
12:48
Add state diagram to comments in experimental version of pager.c. check-in: 16dcf5a6 user: dan tags: experimental
06:42
Incremental checkin on pager state refactoring. check-in: 0a636798 user: dan tags: experimental
2010-08-02
14:32
Experimental refactoring of the Pager object state. This version is surely buggy. check-in: 03a24051 user: dan tags: experimental
10:59
Modify wal2.test to disable tests requiring TCL 8.5 if the test harness is compiled using TCL 8.4. check-in: 016486c7 user: drh tags: trunk
10:47
In shared-cache mode, do not allow one connection to checkpoint a database while a second connection is reading or writing the same shared-cache. check-in: e75b52d1 user: dan tags: trunk
2010-08-01
22:41
Fix a typo in an error message of the TCL interface. check-in: 8eadd7b8 user: drh tags: trunk
2010-07-30
18:40
If a database becomes corrupted such that an index is out of sync with its table, make sure the corruption is detected and reported back. Do not assume that indices always contain rowids for valid table rows. check-in: 83395a3d user: drh tags: trunk
16:54
Fix typos in comments. No code or logic changes. check-in: 15c294ca user: drh tags: trunk
16:44
Remove a test from sqlite3PagerCommitPhaseOne which is now always true after the multi-file transaction fix. check-in: 6758f6a8 user: drh tags: trunk
15:43
Remove variable Pager.needSync, which was almost completely unused. check-in: 347f22a5 user: dan tags: experimental
14:39
Merge trunk changes into experimental again. check-in: 87e0f4e1 user: dan tags: experimental
11:31
Changes to the comments describing the Pager.setMaster variable in pager.c. Add an assert() statement to verify that two master journal pointers are not written to a single journal file. check-in: ad78ccac user: dan tags: trunk
11:20
Cherry-pick the multi-file transaction fix for ticket [f3e5abed55] out of the experimental branch. check-in: 40f7f0a5 user: drh tags: trunk
10:09
Add the test cases for bug [f3e5abed55]. check-in: cbbaf8e6 user: dan tags: experimental
10:02
Make sure a connection has an exclusive lock on all database files involved in a multi-file transaction before writing the master-journal pointer into any journal files. Fix for [f3e5abed55]. check-in: 50c0f220 user: dan tags: experimental
07:26
Merge further trunk changes into experimental branch. check-in: fb847d70 user: dan tags: experimental
05:06
Add tests to check that the ICU regexp() function can only be called with exactly two arguments. check-in: 451d9657 user: dan tags: trunk
00:31
Updates to the README.txt file for ICU. check-in: d37443d3 user: drh tags: trunk
2010-07-29
10:13
Unconditionally include the pTmpSpace size in the estimate of the pager memory used. check-in: 4b97f864 user: drh tags: trunk
10:07
Change the profile timer units back to nanoseconds and update the sqlite3_profile() documentation. Ticket [c43940c49b74c70a69] check-in: 7783b98a user: drh tags: trunk
01:50
Correct handling of compound foreign key constraints that include the integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] check-in: 53902f7d user: drh tags: trunk
2010-07-28
19:17
Get SQLITE_OMIT_VIRTUALTABLE working again after being broken by recent changes. check-in: 33b1e862 user: drh tags: trunk
18:51
Fix the dbstatus.test script so that it works correctly on 64-bit machines. check-in: a3401d9e user: drh tags: trunk
18:35
Merge trunk changes into experimental branch. check-in: aa819001 user: dan tags: experimental
17:36
Improve the accuracy of the Pager heap usage estimate. check-in: ae89777e user: drh tags: trunk
17:16
Adjust the shell test script "shell4.test" to account for changes in the ".stat on" display format from the previous checkin. check-in: 2f2fa7dd user: drh tags: trunk
17:01
Record the pcache allocation size statistics even for pcache overflow allocations. Adjust the wording on one of the stat output lines in the shell. check-in: f9adf66a user: drh tags: trunk
16:05
Modify CLI to optionally display "stats". check-in: 419ce0ed user: shaneh tags: trunk
15:52
Lookaside memory is not used to store schemas. Change the SQLITE_DBSATUS_SCHEMA_USED documentation to reflect this fact. check-in: 07abfd52 user: drh tags: trunk
15:49
Add documentation for the SQLITE_STATUS_MALLOC_COUNT parameter to sqlite3_status(). check-in: dbfbdb60 user: drh tags: trunk
15:10
Fix errors in wal3.test caused by recent modifications. check-in: 0714aecc user: dan tags: experimental
14:26
Support FCNTL_CHUNK_SIZE on windows too. check-in: a038688c user: dan tags: experimental
02:53
Do not allow automatic indices for the RHS of IN expressions which are not correlated subqueries. Ticket [8011086c85c6c404014c9] check-in: 267492d3 user: drh tags: trunk
2010-07-27
18:36
Merge trunk changes into experimental branch. check-in: 62182409 user: dan tags: experimental
18:34
Add experimental unix-only file-control to grow and truncate the database file by a configurable chunk size. check-in: 7cf0e851 user: dan tags: experimental
16:42
Update the makefiles to prefer TCL version 8.5 instead of 8.4. check-in: 8118de2a user: drh tags: trunk
2010-07-26
19:09
Fix a bug in the SQLITE_STATUS_MALLOC_COUNT counter. Add an ALWAYS() around a condition in the SQLITE_DBSTATUS_SCHEMA_USED logic that is always true. check-in: 6df081ad user: drh tags: trunk
18:43
Add the SQLITE_STATUS_MALLOC_COUNT option for sqlite3_status(). check-in: 8f8e442b user: drh tags: trunk
16:40
Increase the version number to 3.7.1 due to the API enhancement of the previous check-in. check-in: 1d7571e4 user: drh tags: trunk
16:24
Add support for SQLITE_DBSTATUS_SCHEMA_USED and SQLITE_DBSTATUS_STMT_USED to the trunk. check-in: 008368b2 user: drh tags: trunk
15:57
When calculating schema memory, use the actual allocated size of hash elements, not sizeof(HashElem). Also fix a bug in dbstatus.test. Closed-Leaf check-in: e327ef37 user: dan tags: experimental