Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants of ba59a7e2ba972444
2015-05-22
| ||
18:40 | Update with fixes and enhancements from trunk. (check-in: 9605d008 user: drh tags: value-dup) | |
17:29 | The SRT_Table type for the SelectDest object is now just an SRT_EphemTab for which the ephemeral table has already been allocated. (check-in: b9727e6b user: drh tags: trunk) | |
16:08 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". (check-in: b9fb9519 user: dan tags: trunk) | |
13:09 | Fix two faulty assert statements discovered by fuzzing. (check-in: 799817bf user: drh tags: trunk) | |
12:37 | Fix an assert in btree.c that can be false when using a corrupted database file. (check-in: a6eb2a39 user: drh tags: trunk) | |
11:38 | Add the --database option to the fuzzershell test program. (check-in: c6d5512f user: drh tags: trunk) | |
2015-05-21
| ||
20:26 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (Closed-Leaf check-in: b9e45596 user: dan tags: sessions-value-dup) | |
2015-05-20
| ||
22:01 | Add the sqlite3_value_dup() and sqlite3_value_free() interfaces and use those to add the sqlite3_rtree_query_info.apSqlParam field to the query callback in R-Tree. (check-in: 2007391c user: drh tags: sessions-value-dup) | |
21:28 | Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. (check-in: a7ee40c4 user: drh tags: value-dup) | |
17:36 | Fix the initialization logic in CREATE TABLE AS so that the correct affinities are applied to all values being inserted into the new table, even if the RHS is a compound SELECT. Fix for ticket [f2ad7de056ab1dc9200]. (check-in: 6a0cf3ce user: drh tags: trunk) | |
17:25 | Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. (Closed-Leaf check-in: 0e45e8f1 user: drh tags: create-table-as-type-fix) | |
17:18 | Simplification of the initialization code for CREATE TABLE AS. (check-in: 937f659e user: drh tags: create-table-as-type-fix) | |
15:51 | A proposed fix for the problem of CREATE TABLE AS generating a table that has INTEGER values in a TEXT column. Ticket [f2ad7de056ab1dc92]. (check-in: d5e2c1fc user: drh tags: create-table-as-type-fix) | |
00:15 | Fix handling of queries with VALUES on the left and UNION ALL SELECT on the right and a LIMIT clause. (check-in: c403502c user: drh tags: trunk) | |
2015-05-19
| ||
23:56 | Enhance the selecttrace display by showing Select.selFlags. (check-in: 45d3893c user: drh tags: trunk) | |
23:04 | Merge the Makefile.msc fix and the compiler warning fix from trunk. Also fix another compiler warning in sqlite3session_diff(). (check-in: 7530e1bf user: drh tags: sessions) | |
22:56 | Fix the MSVC makefile so that it works with OTA. Fix a harmless compiler warning in FTS3. (check-in: c7b16645 user: drh tags: trunk) | |
22:42 | Merge recent trunk changes, include the R-Tree enhancement that allows 8-byte BLOB arguments to geometry functions, and the fix for the TEXT affinity problem that could cause corrupt indexes. (check-in: 0a0de8b7 user: drh tags: sessions) | |
22:20 | Allow R-Tree geometry functions to take 8-byte BLOB arguments which are passed directly through to the underlying callback, and which can be used to pass pointers into the callback. (check-in: b271ed56 user: drh tags: trunk) | |
19:44 | Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. (check-in: f5d0ce80 user: dan tags: trunk) | |
17:48 | Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. (check-in: c74e0bc4 user: dan tags: trunk) | |
16:50 | Merge the ota-update branch with trunk. (check-in: 08e2864e user: dan tags: trunk) | |
16:26 | Add a comment for SQLITE_FCNTL_OTA to sqlite.h.in. (Closed-Leaf check-in: efa20f8e user: dan tags: ota-update) | |
16:22 | Allow OTA update state data to be stored in a database separate from the OTA update database. (check-in: 5af8db56 user: dan tags: ota-update) | |
14:14 | Merge latest trunk changes with this branch. (check-in: 6055a672 user: dan tags: ota-update) | |
2015-05-14
| ||
09:53 | Merge changes from the index-is-operator branch into this one. Drop the partial support added for IS on this branch by [52e73eec]. (check-in: 16ab9caf user: dan tags: ota-update) | |
08:58 | Merge latest trunk changes with this branch. (check-in: 299ed55c user: dan tags: ota-update) | |
2015-04-23
| ||
19:38 | Fix a problem in the "ota" utility program causing it to crash if SQLite failed to open the target database. (check-in: a1a2b4a2 user: dan tags: ota-update) | |
19:32 | Merge latest trunk changes into this branch. (check-in: 1506e99e user: dan tags: ota-update) | |
19:18 | Fix a performance problem in calls to sqlite3ota_close() made after the OTA update has been completely applied and checkpointed. (check-in: fa62093b user: dan tags: ota-update) | |
18:14 | Have OTA maintain a small LRU cache of UPDATE statements. This reduces the amount of time it spends compiling UPDATE if a single data_xxx table contains many different ota_control strings. (check-in: baee3556 user: dan tags: ota-update) | |
2015-04-22
| ||
11:34 | Add comments related to database locking to sqlite3ota.h. (check-in: 77242965 user: dan tags: ota-update) | |
2015-04-21
| ||
15:35 | Add a comment to sqlite3ota.h. No code changes. (check-in: 352fa09e user: dan tags: ota-update) | |
2015-04-17
| ||
17:00 | Ensure that filenames passed to the VFS xOpen() function are terminated by 2 '\0' bytes. (check-in: 66eff473 user: dan tags: ota-update) | |
16:29 | Fix a memory leak in sqlite3ota.c that can follow an OOM error. (check-in: c3dc15e7 user: dan tags: ota-update) | |
08:36 | Have OTA always specify SQLITE_CONFIG_URI when opening databases. Fix a test issue causing otacrash.test to fail. (check-in: 0d0e5ec0 user: dan tags: ota-update) | |
2015-04-16
| ||
18:49 | Be sure to release any xShmLock locks held when closing an OTA handle. (check-in: d0fba72a user: dan tags: ota-update) | |
14:33 | Fix a mismatched printf() argument and format specifier. Add ota files to Makefile.in. (check-in: 5db810a8 user: dan tags: ota-update) | |
10:55 | Avoid attempting to rename the *-oal file while it is still open. (check-in: 658c3b0c user: dan tags: ota-update) | |
2015-04-15
| ||
14:26 | Merge all recent trunk enhancements and fixes into the ota-update branch. (check-in: 9bd3e445 user: drh tags: ota-update) | |
2015-04-08
| ||
14:01 | Merge all changes for version 3.8.9 into the ota-update branch. (check-in: ec9d907a user: drh tags: ota-update) | |
2015-03-25
| ||
15:23 | Extend [52e73eec] so that the IS optimization may be used on primary keys with more than 3 columns. (check-in: 4e8796af user: dan tags: ota-update) | |
2015-03-24
| ||
18:21 | Merge the latest trunk changes into this branch. (check-in: 9d9b6c88 user: dan tags: ota-update) | |
18:03 | When the OTA module updates or deletes a row, save only those fields that are part of an index or primary key to the ota update database. (check-in: 6326fd32 user: dan tags: ota-update) | |
2015-03-23
| ||
17:10 | Fix a broken assert() in the ota module. (check-in: 858de8a5 user: dan tags: ota-update) | |
2015-03-18
| ||
20:03 | Allow whereShortCut() to use the PRIMARY KEY index of a WITHOUT ROWID table to optimize a vector of "IS" operators in a WHERE clause. (check-in: 52e73eec user: dan tags: ota-update) | |
19:04 | Clarify that OTA is unable to update or delete rows with NULL values in primary key fields. (check-in: 2e7c1e0a user: dan tags: ota-update) | |
2015-03-09
| ||
13:24 | Merge recent trunk enhancements into the ota-update branch. (check-in: 5489cb68 user: drh tags: ota-update) | |
2015-03-05
| ||
16:21 | Fix some problems with OTA and empty target databases, or target databases with the wrong set of tables. Also add SQLITE_FCNTL_VFSNAME support to the OTA VFS. (check-in: 46119e8d user: dan tags: ota-update) | |
14:07 | Add comments to sqlite3ota.h to make it clear that passing NULL in place of a parent VFS name to sqlite3ota_create_vfs() causes the new VFS to use the system default as its parent. (check-in: 158c1a48 user: dan tags: ota-update) | |
13:43 | Fix a typo in sqlite3ota.h. (check-in: 04087dec user: dan tags: ota-update) | |
2015-02-23
| ||
20:09 | Fix building with ENABLE_OTA and OMIT_LOAD_EXTENSION. (check-in: d6d21ff5 user: dan tags: ota-update) | |
16:17 | Merge latest trunk changes with this branch. (check-in: e5ca79d2 user: dan tags: ota-update) | |
15:41 | Change SQLITE_FCNTL_ZIPVFS_PAGER to SQLITE_FCNTL_ZIPVFS. (check-in: f7865b94 user: dan tags: ota-update) | |
15:02 | Update the sqlite3ota_db() API to account for the fact that each OTA handle now uses two SQLite database handles. (check-in: ef08ecce user: dan tags: ota-update) | |
12:22 | Improve tests for resuming ota updates following power failures. Fix a problem revealed by the same. (check-in: 1cb675e5 user: dan tags: ota-update) | |
2015-02-21
| ||
20:08 | Fix some problems with resuming ota updates if saving the state is interrupted by a power failure or system crash. (check-in: 6d5ed70d user: dan tags: ota-update) | |
2015-02-20
| ||
14:36 | Add some missing comments and fix other minor code issues in sqlite3ota.c. (check-in: 718fd8b6 user: dan tags: ota-update) | |
2015-02-19
| ||
19:59 | Ensure the mutex used to protect the linked list of all main database files opened by a single ota vfs is allocated. (check-in: 9c8682d6 user: dan tags: ota-update) | |
18:06 | Update various documentation comments in sqlite3ota.c and sqlite3ota.h. (check-in: 60e0a46b user: dan tags: ota-update) | |
14:41 | Merge latest trunk changes with this branch. (check-in: 6f5888a5 user: dan tags: ota-update) | |
13:36 | Add tests for a couple of previously untested branches in the ota code. (check-in: a3c1bc5d user: dan tags: ota-update) | |
2015-02-18
| ||
20:17 | Add new file ota12.test, containing tests for applying ota updates to live databases with other active reader/writer clients. (check-in: 0864d127 user: dan tags: ota-update) | |
20:16 | Add ota tests to increase code coverage. Fix some minor issues in error handling within the ota code. (check-in: 2b10c5d2 user: dan tags: ota-update) | |
17:40 | Fix a problem with OTA updates in the presence of database readers. (check-in: 144bb29f user: dan tags: ota-update) | |
2015-02-17
| ||
20:49 | Improve test coverage of ota code a bit. (check-in: a438fa6c user: dan tags: ota-update) | |
2015-02-16
| ||
21:13 | Add extra tests and fixes for ota. (check-in: e0b71519 user: dan tags: ota-update) | |
11:48 | Add further tests and fixes for ota. (check-in: 62dc1fff user: dan tags: ota-update) | |
06:27 | Move tcl test code from sqlite3ota.c to new file ext/ota/test_ota.c. (check-in: f20779a6 user: dan tags: ota-update) | |
2015-02-14
| ||
18:58 | Change the way the "incremental checkpoint" function of OTA works in order to reduce the effect on the SQLite core code. (check-in: b64a11a7 user: dan tags: ota-update) | |
2015-02-11
| ||
17:05 | Merge the ota-update-no-pager_ota_mode branch into this one. (check-in: 71887cd9 user: dan tags: ota-update) | |
16:54 | Merge latest trunk changes with this branch. (Closed-Leaf check-in: 0b63e8dc user: dan tags: ota-update-no-pager_ota_mode) | |
16:25 | Ensure that an error is reported if an attempt is made to update a wal mode database via ota. (check-in: 6fc5d4d2 user: dan tags: ota-update-no-pager_ota_mode) | |
2015-02-10
| ||
20:00 | Further tweaks to work with zipvfs. (check-in: 0f152416 user: dan tags: ota-update-no-pager_ota_mode) | |
17:08 | Add documentation and test cases for sqlite3ota_create_vfs(). Also code to detect errors in zipvfs/ota setup. (check-in: e7296681 user: dan tags: ota-update-no-pager_ota_mode) | |
2015-02-09
| ||
20:07 | Add the sqlite3ota_create_vfs() and sqlite3ota_destroy_vfs() functions. (check-in: 96443ecb user: dan tags: ota-update-no-pager_ota_mode) | |
2015-02-07
| ||
20:20 | Add comments to explain the role of the ota vfs. (check-in: 7bb63363 user: dan tags: ota-update-no-pager_ota_mode) | |
19:17 | Remove "PRAGMA pager_ota_mode". (check-in: 8ac58e46 user: dan tags: ota-update-no-pager_ota_mode) | |
2015-02-06
| ||
15:03 | Merge the command-line shell enhancements from trunk. (check-in: c3931db5 user: drh tags: ota-update) | |
00:31 | Revise the way that the index structure for a WITHOUT ROWID table is discovered. (check-in: 7f10a0ea user: drh tags: ota-update) | |
2015-02-05
| ||
17:46 | Change a comment in sqlite3ota.h to make it clear that it is not possible to insert a NULL value into an INTEGER PRIMARY KEY column using ota. (check-in: a5e86bea user: dan tags: ota-update) | |
17:36 | Prevent ota updates from violating NOT NULL constraints. Add a comment to the "limitations" section of sqlite3ota.h saying that CHECK constraints are not enforced. (check-in: 74e073dd user: dan tags: ota-update) | |
01:49 | Figure out the primary-key type of a table using queries of sqlite_master and the table_info and index_list pragmas, obviating the need for SQLITE_TESTCTRL_TBLTYPE. (check-in: 50ecdfc4 user: drh tags: ota-update) | |
2015-02-04
| ||
23:51 | Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. (check-in: 21e95d28 user: drh tags: ota-update) | |
19:20 | Fix the error messages returned by ota if an update violates a unique constraint. (check-in: c4845a3b user: dan tags: ota-update) | |
16:32 | Avoid a linear scan of the entire table when ota updates or deletes a row from a table with an external primary key index. (check-in: 1db198cc user: dan tags: ota-update) | |
11:08 | Fix a memory leak that could follow an OOM error in ota. (check-in: 0d5415f2 user: dan tags: ota-update) | |
2015-02-03
| ||
18:43 | Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . (check-in: a21fefb7 user: dan tags: ota-update) | |
15:56 | Remove "PRAGMA ota_mode". (check-in: 1c111447 user: dan tags: ota-update) | |
2015-01-31
| ||
20:42 | Have ota use imposter tables to write to indexes instead of the sqlite3_index_writer() interface. The error handling in this version is broken in a few small ways. (check-in: cdaeab46 user: dan tags: ota-update) | |
02:34 | Merge in support for the index_xinfo pragma. (check-in: f9b6dc77 user: drh tags: ota-update) | |
2015-01-30
| ||
21:00 | Merge the SQLITE_TESTCTRL_IMPOSTER changes from trunk. (check-in: 3ed6eb2f user: drh tags: ota-update) | |
16:36 | Merge all recent trunk changes, and especially the SQLITE_TESTCTRL_INITMODE enhancement. (check-in: 36436dde user: drh tags: ota-update) | |
2015-01-28
| ||
20:37 | Add missing VdbeCoverage() macros to the sqlite3_index_writer() implementation. (check-in: 6f8cda26 user: drh tags: ota-update) | |
15:30 | When a "full", "restart" or "truncate" checkpoint is attempted, return SQLITE_BUSY if a reader prevents the checkpointer from copying any frames at all into the database file. (check-in: f2700040 user: dan tags: ota-update) | |
12:27 | Correctly detect errors returned by walCheckpointStart() due to OOM. (check-in: 8e878c20 user: drh tags: ota-update) | |
12:00 | Merge in all changes from trunk. (check-in: 17c69be8 user: drh tags: ota-update) | |
2014-12-08
| ||
07:50 | Update this branch with latest trunk changes. (check-in: 69a312ad user: dan tags: ota-update) | |
07:28 | Update comments in sqlite3ota.h to remove the "must have PRIMARY KEY" restriction. (check-in: 088a41eb user: dan tags: ota-update) | |
07:22 | Extra tests for the ota_rowid column. (check-in: 46069393 user: dan tags: ota-update) | |
2014-12-06
| ||
19:30 | Allow the ota extension to write to tables with no PRIMARY KEY declaration. (check-in: ba59a7e2 user: dan tags: ota-update) | |