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 | |