SQLite4
Timeline
Not logged in

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

139 check-ins using file test/manydb.test version ae2987e048

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
16:45
Fix a problem in kvmemRemoveNode() causing a pUp (parent node) pointer to be set incorrectly. check-in: 7faa762755 user: dan tags: primary-keys
10:35
Add placeholder code to make ROLLBACK (and OR ROLLBACK constraints) work a bit. check-in: 367fdc8463 user: dan tags: primary-keys
05:50
Ensure that kvmemSeek() does not come to rest on a deleted node. check-in: 21991a932a user: dan tags: primary-keys
2012-04-12
19:52
Further fixes to things. check-in: 81fab25002 user: dan tags: primary-keys
11:49
Fix a problem in kvmemRemoveNode. check-in: f3c424ddf3 user: dan tags: primary-keys
2012-04-11
18:48
Fix some problems with REPLACE and other conflict handling. check-in: ff493aaa41 user: dan tags: primary-keys
15:01
Fix various bugs. check-in: a70fb0629b user: dan tags: primary-keys
2012-04-10
19:52
Changes to support "real" user-defined primary keys. This is quite broken at present. check-in: 3841829752 user: dan tags: primary-keys
2012-03-01
14:47
Minor changes so that the code builds on Mac. check-in: a03018e6b8 user: drh tags: trunk
2012-02-23
17:56
Modify the key encoding so that integer values use one less byte of space. check-in: af96bd359f user: drh tags: trunk
2012-02-22
14:20
Add the "kvdump" pragma for debugging. check-in: 4746d99cc1 user: drh tags: trunk
13:15
CREATE INDEX runs, though index queries does not work yet so there is no way to test that the index was correctly created. check-in: 70f15a5352 user: drh tags: trunk
02:44
Remove the OP_Destroy opcode. Add an implementation for OP_Clear. check-in: 15cf832dfc user: drh tags: trunk
00:11
Remove the OP_CreateTable and OP_CreateIndex opcodes, which are not required with the key/value backend. check-in: 31b1faa995 user: drh tags: trunk
2012-02-21
20:03
Only the bare basics work. But we might as well go ahead and call this the trunk since we are unlikely to ever need to bisect back into this massive rewrite effort. check-in: a101b3e1c4 user: drh tags: trunk
20:01
Inserting multiple rows into a table and querying via full-table scan is now working. Leaf check-in: 6838c8a3a7 user: drh tags: remove-btree
19:57
Improved storage tracing output. check-in: d4c10f88ad user: drh tags: remove-btree
19:32
CREATE TABLE and a single row INSERT followed by SELECT now working. Still lots of stuff that doesn't work, though. check-in: 65f1e9a86f user: drh tags: remove-btree
19:20
Fix to kvmemSeek(). check-in: 05d897a0ae user: drh tags: remove-btree
17:11
Incremental check-in. Compiles but does not work. check-in: 829f7f1a65 user: drh tags: remove-btree
15:19
Incremental check-in. Trying to get it running. check-in: c055a35d1e user: drh tags: remove-btree
14:50
The testfixture now compiles. check-in: e85db5d81b user: drh tags: remove-btree
2012-02-20
19:49
Incremental check-in. Compiles but still does not run. check-in: cc977cdcc6 user: drh tags: remove-btree
18:46
Progress on transaction control. check-in: d5755d3561 user: drh tags: remove-btree
2012-02-17
20:33
Incremental check-in. The shell compiles and runs. Now trying to get it to work. check-in: 2843c28b82 user: drh tags: remove-btree
16:23
Add the kv_trace and trace pragmas. check-in: e37bee4f61 user: drh tags: remove-btree
12:45
Compiles and links. check-in: 5c44baf3fe user: drh tags: remove-btree
12:12
Incremental check-in - working toward getting it to compile. check-in: 18d380e9a6 user: drh tags: remove-btree
2012-02-16
22:17
Incremental check-in. Does not compile. check-in: 3165b1b5fb user: drh tags: remove-btree
2012-02-08
21:47
This is an incremental check-in for the massive change that removes the old b-tree layer and substitutes a uniform key-value namespace. Nothing works at this point. This check-in is just a checkpoint. check-in: 87d659d624 user: drh tags: remove-btree
2012-01-26
22:11
Always call OP_MakeKey before OP_MakeRecord prior to adding content to an index. check-in: 29c1ec8e6b user: drh tags: trunk
20:53
Fix the data codec so that it handles Inf and NaN. Make sure OP_MakeKey is only called with an index cursor. check-in: bfa05539ea user: drh tags: trunk
18:22
Adjust the initial values on the key encoding to provide auxiliary key space before and after the rows of each table. check-in: af6351afdd user: drh tags: trunk
16:34
First cut at a complete codec for both key and data. Data decoding is untested. check-in: 8e27a5ca62 user: drh tags: trunk
2012-01-25
17:40
Progress on the key encoder. Text value are still not encoded for keys. check-in: 4b07acf688 user: drh tags: trunk
03:33
Add the vdbecodec.c source file including stub functions for all encoders and decoders. Initial implementation for the data encoder. check-in: 6c42bd8b4f user: drh tags: trunk
2012-01-24
20:48
Remove lots more unused code. check-in: dcf2f7b862 user: drh tags: trunk
14:22
Fix the spelling of "lexicographical". check-in: a20f69592c user: drh tags: trunk
13:58
Add the database_design.txt document. check-in: b3390b2d58 user: drh tags: trunk
13:38
Many code simplifications. Removing support for shared-cache mode, VACUUM, multiplexor, test_stat, progress handler, etc. check-in: 3ebe674aed user: drh tags: trunk
2012-01-23
18:23
Change sqlite4_create_collate() to take comparison, key-generator, and destructor functions. Omit _create_collate16() and _create_collate_v2(). check-in: 9feaae9f84 user: drh tags: trunk
17:22
A few more tweaks for moving the version number from 3 to 4. check-in: 4dc43e1c6b user: drh tags: trunk
17:12
Add the varint.c module, but do not yet link it into the build. check-in: 3fc5c75369 user: drh tags: trunk
16:22
Rename all of the interfaces from "sqlite3" to "sqlite4" check-in: 9191010833 user: drh tags: trunk