SQLite4
Timeline
Not logged in

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

157 check-ins using file test/src4.test version bd01d8cd89

2012-06-15
14:08
One more OOM related fix for lsm_log.c. check-in: 2069291793 user: dan tags: trunk
14:07
Changes to lsm_log.c to avoid crashing following an OOM condition. check-in: acfbe5d203 user: dan tags: trunk
2012-06-14
20:43
Add LSM_SEEK_LEFAST. But do not enable it in OP_NewRowid yet, as it causes too many test cases to fail. check-in: 91a802eedd user: dan tags: trunk
19:02
Make sure the constructors for KVStore objects have access to the sqlite3_env object. check-in: 22e89b1dc1 user: drh tags: trunk
18:01
Avoid storing a pointer to an lsm_env object in any structure that may be shared by more than one connection. check-in: d8018604ee user: dan tags: trunk
15:04
Fix an out-of-bounds read problem. check-in: 8785d13b06 user: dan tags: trunk
14:05
Remove some unused variables. check-in: 9b06d41f7b user: dan tags: trunk
11:38
Fix another memory leak. check-in: ba35f9d68a user: dan tags: trunk
09:54
Fix a test problem in lsmtest6.c. And some dropped return codes in lsm. check-in: 084e4c1ad8 user: dan tags: trunk
2012-06-13
20:24
Continue adding OOM tests. check-in: 7f7d7bc687 user: dan tags: trunk
17:41
Fix another memory leak. check-in: 9834ea1d9d user: dan tags: trunk
17:36
Fix long standing memory leak. check-in: 3380b739e1 user: dan tags: trunk
16:38
Fix further problems revealed by OOM injection tests. check-in: d6ce76ed01 user: dan tags: trunk
2012-06-12
20:20
Extra tests. check-in: a65d1ea34d user: dan tags: trunk
17:43
Start adding OOM injection tests to lsmtest. Fix issues along the way. check-in: d089a0f97e user: dan tags: trunk
2012-06-11
19:51
Improve documentation in lsm_file.c. Fix other problems. check-in: 9afb7862e4 user: dan tags: trunk
16:35
Changes so that phantom runs work in mmap mode. check-in: 57e0f3288d user: dan tags: trunk
16:00
Fix the way meta-pages are handled in lsm_file.c. check-in: d352b485a6 user: dan tags: trunk
2012-06-09
20:08
Simplify the code that selects runs to merge to use an algorithm more like an ordinary merge sort. Store the number of times each level has been merged in the checkpoint blob. Add a way to elect to use mmap() instead of read()/write() for IO at runtime. check-in: e1816661f1 user: dan tags: trunk
2012-06-05
19:38
Remove Database.pCkptMutex. Fix a problem with database files larger than 2GB. check-in: 84ea6f9a68 user: dan tags: trunk
15:32
Add new methods to struct lsm_env: xUnlink and xSectorSize. check-in: 549b270c77 user: dan tags: trunk
11:52
Improve the "lsmtest speed" command. check-in: 2d2ca7bb25 user: dan tags: trunk
2012-06-04
19:52
Switch to using the C interface when building leveldb into lsmtest. check-in: 0ad3b38e01 user: dan tags: trunk
18:14
Embed checksums in selected WRITE and DELETE records to limit the size of allocations and reads that may be made during recovery as a result of garbage in log files. check-in: 66d3f705c6 user: dan tags: trunk
14:23
Fix a problem with holding lsm cursors open when the in-memory tree is flushed to disk. check-in: dc75aaa181 user: dan tags: trunk
09:26
Add an option to lsmview.tcl to display database keys and values using hex notation. check-in: ac42c5dbca user: dan tags: trunk
2012-06-02
19:25
Change the 'lsmtest crash' command to accept a glob pattern as an argument. check-in: a64905f08e user: dan tags: trunk
18:55
Fix some of the lsmtest crash recovery tests. Update the code in lsm_log.c so that if synchronous=FULL, each transaction in the log file is stored on its own set of disk sectors. check-in: 960afb3114 user: dan tags: trunk
2012-06-01
19:47
Fix test infrastructure for lsmtest power failure tests. check-in: 5666f70625 user: dan tags: trunk
14:29
Fix a problem displaying pointers in lsmview.tcl. check-in: f0adbf3613 user: dan tags: trunk
13:17
Further improvements to lsmview.tcl. check-in: acd617edb0 user: dan tags: trunk
2012-05-31
20:07
Enhance lsmview.tcl so that it may be passed a database name on the command line. check-in: d34cc3832d user: dan tags: trunk
19:11
Add lsm_info() options to obtain the list of pages for an array, and to dump the contents of a page in human readable form. check-in: 0bdcfc3932 user: dan tags: trunk
2012-05-30
20:17
Fix a problem with log-wrapping triggered by an asynchronous checkpoint. check-in: 99b6b9ade5 user: dan tags: trunk
18:41
Log-file related fixes for savepoint rollback. check-in: 23794ed181 user: dan tags: trunk
17:10
Simplify the internals of lsm_log.c a bit. check-in: af5842b48f user: dan tags: trunk
12:02
Avoid overwriting runs that may still be in use when performing background work. check-in: 771940c9cc user: dan tags: trunk
2012-05-29
18:03
Fix a problem causing a block to be added to the freelist and reused as part of the same write. check-in: d515a162a2 user: dan tags: trunk
16:08
Fix a crash when attempting to close a database handle on which lsm_open() has failed. check-in: d1817c36d2 user: dan tags: trunk
16:02
Fix checkpointing of databases that contain large numbers of levels. check-in: e867c0cea0 user: dan tags: trunk
2012-05-28
19:20
Fix a bug causing the generation of very large database files. check-in: 4550832dec user: dan tags: trunk
18:25
Remove the "append-list" from the shared data and checkpoint formats. check-in: 75b9eec7fb user: dan tags: trunk
2012-05-23
11:49
Fix problems with log wrapping. check-in: d2c9dc4ffa user: dan tags: trunk
2012-05-22
19:46
Add missing test/test_lsm.c file. check-in: 385799592f user: dan tags: trunk
19:45
Further progress and test cases for logging. check-in: 20ec785d0a user: dan tags: trunk
2012-05-21
20:13
Further work on logging and thread-safety in lsm. check-in: 2f9b09b9b8 user: dan tags: trunk
09:02
Further work on LSM log files. Add the sqlite4_kvstore_control() interface. The only use of this so far is to allow applications to retrieve the lsm_db* handle associated with a database backup. This is useful for testing. check-in: ad1c1793fc user: dan tags: trunk
2012-05-19
10:03
Update log file format comments in lsm_log.c. Store the current log file offset as a part of each checkpoint record. check-in: 802871916a user: dan tags: trunk
2012-05-18
16:13
Truncate any log file to zero bytes in size as part of a clean database shutdown. check-in: 50a7df2a67 user: dan tags: trunk
15:04
Logging related fix for databases with multiple clients. check-in: e607910f65 user: dan tags: trunk
09:20
Fix a bug in log recovery checksums. check-in: 48bb7fd595 user: dan tags: trunk
2012-05-17
20:01
Re-enable logging. Still buggy. check-in: 279f148134 user: dan tags: trunk
2012-05-11
11:07
Fix typos in the design.wiki document. check-in: 4afc8d05d7 user: drh tags: trunk
2012-05-09
16:58
Fix problems with multi-threaded lsm tests. check-in: 41a5660c29 user: dan tags: trunk
14:35
Mark checkpointed b-tree pages as read-only when they are reloaded from disk. Fix other lsm problems related to [8e27d1f99c]. check-in: 4c8557b77c user: dan tags: trunk
11:46
Minor tweak to the decimal_floating_point.txt note. check-in: df636b697a user: drh tags: trunk
11:37
Tweaks to the design summary document. check-in: a36eae7be6 user: drh tags: trunk
09:23
Fix crash in debugging function lsmLogMessage(). check-in: 009cce0921 user: dan tags: trunk
2012-05-08
23:38
Begin adding documentation in the www/ directory. check-in: 6df890f9b0 user: drh tags: trunk
20:02
Re-enable writing separators and main runs to the same block. check-in: 8e27d1f99c user: dan tags: trunk
14:19
Fix a problem in lsmtest4.c. check-in: e52e8a370d user: dan tags: trunk
11:51
Fix lsmtest "rollback" tests. Fix a memory leak in lsm_shared.c. check-in: 788cb6b961 user: dan tags: trunk
2012-05-07
19:53
Enable the fenceposting code in lsmtest_mem.c. Fix a bug in lsm_mem.c. Remove traces of the old mutex API. check-in: adca302324 user: dan tags: trunk
18:57
Fix compilation problem in lsmtest. check-in: e5c56f655f user: dan tags: trunk
18:39
Use lsm_env instead of lsm_mutex_methods. check-in: ee29d7847d user: dan tags: trunk
17:33
Remove lsm_vfs. Use lsm_env instead. check-in: a9c6261d5d user: dan tags: trunk
16:47
Ensure that all allocations made by the LSM module use the supplied malloc functions supplied by the user. check-in: 1029e6cce7 user: dan tags: trunk
12:06
Import code for the "lsmtest" test utility. check-in: 49ff55e1a6 user: dan tags: trunk
08:57
Remove unused functions dflt_malloc() and friends from lsm_mem.c. check-in: 7a603fa454 user: dan tags: trunk
2012-05-05
16:33
Update the original rowset code so that it works with variable length keys. Remove the placeholder keyset code. check-in: 51d37b1626 user: dan tags: trunk
08:31
Remove the sqlite4.pVfs variable. check-in: ba6ca06478 user: dan tags: trunk
08:14
Expand the set of sqlite3 tests run by src4.test. check-in: 6610b8134e user: dan tags: trunk
2012-05-04
19:01
Fix a crash in "? IN (SELECT ... ORDER BY ... LIMIT)" expressions. Also a crash in lsm_csr_valid(). check-in: b688877924 user: dan tags: trunk
16:05
Fix a crash that can occur if the index specified by an INDEXED BY clause cannot be used. check-in: 7b6ffb0a0b user: dan tags: trunk
13:00
Fix a crash in scalar sub-selects that have ORDER BY clauses. check-in: 927b8c3427 user: dan tags: trunk
09:09
Update the explainIndexRange() function. check-in: 9dac245adf user: dan tags: trunk
2012-05-03
20:07
Remove a bad assert(). Fix rowid related crashes in triggers and foreign keys. check-in: 8bcdfe884e user: dan tags: trunk
17:18
Remove the update, commit, rollback and wal hooks. check-in: d38792589b user: dan tags: trunk
16:34
If both UNIQUE and PRIMARY KEY constraints are attached to the same set of columns, make sure the single index SQLite creates is the PRIMARY KEY (so that the table doesn't end up with an IPK). check-in: add223fab0 user: dan tags: trunk
16:04
Fix for "DISTINCT rowid" queries that have more than one datasource in the FROM clause. check-in: 47b30670d4 user: dan tags: trunk
15:04
Continuing work on cutting over the lsm_env logic in LSM. check-in: d8e75dd125 user: drh tags: trunk
09:57
Update boundary1.test. check-in: 2e9888ce58 user: dan tags: trunk
2012-05-02
20:09
Fix the commit and rollback hook callbacks. Remove more dead code. check-in: 9ca276ac06 user: dan tags: trunk
19:19
Fix warnings and other code issues. check-in: 6860a3b80c user: dan tags: trunk
15:49
Fix automatic indexes. check-in: d32ba91d2b user: dan tags: trunk
2012-05-01
20:01
Improve the EXPLAIN QUERY PLAN output a little. check-in: 6c6ce37269 user: dan tags: trunk
18:18
Remove an incorrect assert() from where.c. check-in: 51563f07cb user: dan tags: trunk
17:12
Remove the RowSet object. Implement enough of KeySet so that everything works (UPDATE, DELETE and the "or-optimization" for WHERE clauses). The "or-optimization" is still inefficient. check-in: f53a618a2a user: dan tags: trunk
11:34
Fix bugs in where.c and vdbe.c that occur when using a non-PK index to optimize an inequality on the PK fields. check-in: 6baa42724c user: dan tags: trunk
10:29
Fix a typo in [989bd130d7]. check-in: 93167e13de user: dan tags: trunk
2012-04-30
19:27
Fix a crash occuring in lsm following a failed call to open(). And another in "BEGIN EXCLUSIVE". check-in: 989bd130d7 user: dan tags: trunk
18:39
Fix a problem with aggregate queries that do not use any column values in the expression-list. e.g. "SELECT count(*) FROM ...". check-in: e44d955795 user: dan tags: trunk
16:49
Fix for WHERE terms of the form "a IN (SELECT x FROM tbl)" for cases where there is a UNIQUE index on tbl.x that is not used by the query. check-in: d8e2b6be11 user: dan tags: trunk
11:56
Fix some lsm problems with modifying the database while there are active cursors. check-in: cb9f166a72 user: dan tags: trunk
08:54
Fix some problems with sqlite4_changes() and DELETE statements. check-in: 5f5ca72866 user: dan tags: trunk
2012-04-28
17:59
Update scripts fkey3.test and fkey4.test. check-in: ebe7972eb3 user: dan tags: trunk
17:50
Fix problems with foreign key actions. check-in: b7f7cd27ac user: dan tags: trunk
16:03
Update some test cases in triggerC.test. check-in: 76ea2fc0e8 user: dan tags: trunk
15:03
Fix a problem with updating primary key fields. Change the error message generated when a PRIMARY KEY constraint is violated to match SQLite 3. check-in: f61bb092cb user: dan tags: trunk
02:39
Refactor the memory-printf components of LSM to be in a more manageable form. More work is needed here. check-in: 5ae95088ab user: drh tags: trunk
2012-04-27
23:16
Work towards converting LSM to use the lsm_env structure and avoid all use of global and static variables. The check-in works, but the changes are only beginning have for the most part have not been cut over yet. This is merely an incremental check-in. check-in: d28f9b6503 user: drh tags: trunk
19:45
Restore the initial value of the database deferred FK constraint counter if a statement transaction is rolled back. check-in: 145889c3c9 user: dan tags: trunk
19:20
Fix a bug in OP_IsUnique. check-in: 17b729a2fd user: dan tags: trunk
16:30
Update some savepoint related test cases so that they work with sqlite 4. check-in: cc3e890839 user: dan tags: trunk
15:01
Fix an lsm problem with rollback. check-in: eae7182230 user: dan tags: trunk
2012-04-26
19:59
Progress towards working savepoints. Fixes to LSM transaction handling. check-in: 365620b19d user: dan tags: trunk
11:30
Fix various compiler warnings. Begin fixing savepoint logic. check-in: 76cd35aad6 user: dan tags: trunk
2012-04-25
19:00
Do not attempt to reindex the primary key index. Add an xMakeKey callback for the RTRIM collation. check-in: 146284d2de user: dan tags: trunk
17:24
Remove support for "oid" and "_rowid_". Only support "rowid" on tables that have an implicit primary key. check-in: e40c75ec8d user: dan tags: trunk
16:18
If necessary, convert text to the correct encoding before invoking a collation sequence xMakeKey callback. check-in: e56fd972d1 user: dan tags: trunk
12:16
Add the "blessing" boilerplate, with correct dates, to the top of each LSM source file. check-in: d71f9ef975 user: drh tags: trunk
11:21
Add lsm source files. check-in: 46ae3fcec6 user: dan tags: trunk
09:59
Fixes for DESC indexes. check-in: 704936cfc8 user: dan tags: trunk
2012-04-24
19:44
Added clarification for the key-encoding of text. check-in: efe3d2e0e7 user: drh tags: trunk
18:47
Correct a buggy assert() in insert.c. check-in: 35e984dde5 user: dan tags: trunk
17:54
Updates to test scripts and main.mk. check-in: 99459e1ea9 user: dan tags: trunk
11:26
Move the test C code from the src/ to the test/ subdirectories. check-in: 26f16cc588 user: drh tags: trunk
11:16
Clean up the top-level directory by removing the configure script at its associated files. (We'll add back in autoconfig later.) And moving AWK scripts into the tool/ directory. check-in: 5c7177fa33 user: drh tags: trunk
00:34
Remove the bitvec.c module as it was no longer being used. check-in: 68df3f5ea7 user: drh tags: trunk
2012-04-23
23:02
Change the sqlite4_config() interface so that it applies to a particular sqlite4_env object. check-in: 6a87af6545 user: drh tags: trunk
21:08
Get rid of sqlite4_open_v2() and sqlite4_open16(). Change sqlite4_open() to take an sqlite4_env pointer and a zero-terminated varargs list of options. No options are currently recognized. check-in: b94314c297 user: drh tags: trunk
19:49
Towards an sqlite4_env object that defines the run-time environment. This is not a complete check-in, just an incremental change (hopefully) in the right direction. check-in: 88ac7f6772 user: drh tags: trunk
18:38
Fix a problem to do with copying from the sorter to a temporary table in select.c. check-in: 187316a0dc user: dan tags: trunk
16:50
Change the tcl interface so that tcl scripts may specify collation sequence xMkKey callbacks. check-in: 6ebe82280d user: dan tags: trunk
15:49
Remove the OS/2 interface logic. check-in: 9a64e0bc7e user: drh tags: trunk
14:54
Fix a bug in the nocase collation xMkKey function. check-in: fe9ccd646d user: dan tags: trunk
14:26
Remove the VDBE merge sorter. check-in: 1073bb477e user: drh tags: trunk
14:11
Add an xMkKey callback to the built-in collation sequence "nocase". Fix a bug in encoding text values with collation sequences into database keys. check-in: 6c9adc9acc user: dan tags: trunk
12:47
Remove the sqlite4_get_table() API. check-in: ff68adaca1 user: drh tags: trunk
12:07
Allow multiple NULL values in a UNIQUE index. check-in: 4dbb499c39 user: dan tags: trunk
11:45
Fix a bug in CREATE INDEX where the number of columns in the index is fewer than the number of columns in the primary key. check-in: b0ac144cf5 user: drh tags: trunk
09:40
Fix for compound EXCEPT queries. check-in: 2dc7b22339 user: dan tags: trunk
2012-04-21
19:59
Additional comments on the key encoder. Remove an unused variable. check-in: fdaed18ddf user: drh tags: trunk
19:19
Fix an off-by-one problem with encoding real values into index keys. Add a test for sorting numeric values. check-in: 7017d07fea user: dan tags: trunk
18:55
Fixes to the text of the key encoding definition in key_encoding.txt. check-in: ee5b8b8d11 user: drh tags: trunk
17:33
Get some more aggregate queries working. check-in: 7aace3e09f user: dan tags: trunk
13:56
Get rid of the page-cache and scratch memory allocators. check-in: 9346a42e0d user: drh tags: trunk
13:18
Remove the alternative pcache mechanism. check-in: bf89aa0f37 user: drh tags: trunk
13:00
All filenames are now URI capable. There is no provision for disabling URI filenames. check-in: 735870610b user: drh tags: trunk
12:49
Remove the last traces of shared cache mode. check-in: 27e0994174 user: drh tags: trunk
00:40
Remove cruft: (1) The sqlite4_prepare_v2() function becomes sqlite4_prepare and all other prepare functions are removed. (2) sqlite4_extended_result_codes() is removed. Extended result codes are now always enabled. (3) The sqlite4_busy_handler() and sqlite4_busy_timeout() functions are removed. check-in: e454574981 user: drh tags: trunk
2012-04-20
20:41
Move development back to trunk. check-in: 76ca8d1bee user: drh tags: trunk
20:38
Changes so that things work without SQLITE_ENABLE_LSM. Closed-Leaf check-in: 49e419f4e8 user: dan tags: primary-keys
20:15
Fix the sqlite4RefillIndex() function. This removes the broken (and disabled) merge-sort code. check-in: 9ac54fff5f user: dan tags: primary-keys
18:35
Changes to where.c to use the PK columns appended to each auxiliary index entry. check-in: 4c1dca78b3 user: dan tags: primary-keys
14:21
A fix to sqlite4VdbeDecodeIntKey(). check-in: b05e622090 user: drh tags: primary-keys
2012-04-19
18:51
Fix a problem with inequality constraints and indexes. check-in: 14d96763cc user: dan tags: primary-keys
18:33
Fixes for scans on indexes other than the primary key. check-in: ed6ac6860b user: dan tags: primary-keys
2012-04-18
18:27
Add file kvlsm.c, a KVStore wrapper around lsm. check-in: 174119bec7 user: dan tags: primary-keys
2012-04-17
18:49
Comment out some tests in select1.test that depend on "PRAGMA full_column_names" and "PRAGMA short_column_names". check-in: 946fe6504a user: dan tags: primary-keys
18:47
Fix a couple of issues with ORDER BY. check-in: 34138a088b user: dan tags: primary-keys
09:10
Enforce NOT NULL on all PRIMARY KEY columns. check-in: 035fdd3f5e user: dan tags: primary-keys
08:23
Fix more problems with triggers and triggers on views. check-in: 77b33bff0a user: dan tags: primary-keys
05:36
Fix an issue with sub-transaction rollback. check-in: 123a055a36 user: dan tags: primary-keys
2012-04-16
19:04
Get most of the trigger logic working again. Still some problems. check-in: b480943c48 user: dan tags: primary-keys
2012-04-14
19:38
Fixes to foreign key logic. And other things. check-in: 69cf7caf80 user: dan tags: primary-keys
2012-04-13
19:17
Fix sub-transaction commit in kvmem.c. Also various aspects of constraint handling. check-in: 365eb3c6de user: dan tags: primary-keys