Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants of fc4f7c115207b786
|
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) | |
|
2014-11-27
| ||
| 18:09 | Update ota so that the hidden columns of virtual tables may be written. (check-in: ccee9996 user: dan tags: ota-update) | |
|
2014-11-22
| ||
| 09:09 | Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: 600cefdd user: dan tags: ota-update) | |
|
2014-11-21
| ||
| 14:37 | Merge latest trunk changes with this branch. (check-in: 7ef44c5b user: dan tags: ota-update) | |
| 11:22 | Changes to comments in sqlite3ota.h. (check-in: 14139542 user: dan tags: ota-update) | |
| 10:46 | Add support for updating virtual tables via ota. (check-in: 4dfcfe54 user: dan tags: ota-update) | |
|
2014-11-20
| ||
| 19:19 | Add the "ota_delta()" feature for delta-compressed updates. (check-in: c64dcd17 user: dan tags: ota-update) | |
| 17:37 | Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. (check-in: 55066a11 user: dan tags: ota-update) | |
| 15:11 | Updates to support zipvfs in pass-through mode. (check-in: 556c3de5 user: dan tags: ota-update) | |
|
2014-11-17
| ||
| 18:35 | Add tests for WITHOUT ROWID tables with composite primary keys. (check-in: 712d413d user: dan tags: ota-update) | |
| 17:57 | Changes so that sqlite3_ckpt_open() works with zipvfs databases. (check-in: acbed338 user: dan tags: ota-update) | |
| 15:07 | Fix a problem with the parameters to an OP_Affinity in one of the VM programs generated by sqlite3_index_writer() that was causing an OOB read. (check-in: 447b33b3 user: dan tags: ota-update) | |
|
2014-10-22
| ||
| 15:33 | Add tests to check error handling in OTA. (check-in: ec7321ae user: dan tags: ota-update) | |
| 11:30 | Sync the database file in sqlite3_ckpt_close(), even if the checkpoint has not finished. (check-in: e2729d62 user: dan tags: ota-update) | |
|
2014-10-21
| ||
| 19:35 | Test that sqlite3ota_open() works with URI paths. Fix some other issues. (check-in: 6fd09854 user: dan tags: ota-update) | |
| 18:09 | Add tests for another application writing the database while an ota update is ongoing. (check-in: 2402baa0 user: dan tags: ota-update) | |
|
2014-10-20
| ||
| 16:34 | Merge version-3.8.7 changes with this branch. (check-in: d380a648 user: dan tags: ota-update) | |
| 16:24 | Have the ota extension perform an incremental checkpoint after generating the wal file. (check-in: 0bf1301a user: dan tags: ota-update) | |
|
2014-09-19
| ||
| 18:08 | Add further tests to ota5.test. Add "ota.test", for running all ota tests. (check-in: 95ffdaa5 user: dan tags: ota-update) | |
| 15:06 | Add extra tests for the ota extension. (check-in: 1e468fe1 user: dan tags: ota-update) | |
|
2014-09-18
| ||
| 17:57 | Update the ota extension to support SQLITE_ENABLE_8_3_NAMES builds. (check-in: 718da6de user: dan tags: ota-update) | |
| 16:38 | Use quotes instead of angle-brackets to include sqlite3.h from sqlite3ota.h. (check-in: fce9c6cc user: dan tags: ota-update) | |
| 15:57 | Remove some c++isms from sqlite3ota.c. (check-in: 0da1862b user: dan tags: ota-update) | |
| 15:22 | Add new file ext/ota/README.txt, containing notes regarding the implementation of the ota extension. (check-in: 3c6e1cbb user: dan tags: ota-update) | |
| 14:48 | Add an API to query an ota handle for the total number of key/value operations performed so far. (check-in: e3943fa7 user: dan tags: ota-update) | |
| 11:31 | Merge latest trunk changes with this branch. (check-in: 67ea2979 user: dan tags: ota-update) | |
| 11:15 | Fix an ota bug causing attempts to write to tables with more than 8 columns to fail. (check-in: 7da98ca2 user: dan tags: ota-update) | |
|
2014-09-17
| ||
| 19:05 | Fix an unintialized variable problem in sqlite3ota.c. (check-in: 01268607 user: dan tags: ota-update) | |
| 15:20 | Add tests and fixes for "PRAGMA ota_mode". (check-in: 39df35c4 user: dan tags: ota-update) | |
|
2014-09-16
| ||
| 20:02 | Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. (check-in: decaccc3 user: dan tags: ota-update) | |
|
2014-09-15
| ||
| 19:34 | Remove the experimental sqlite3_transaction_save() and restore() APIs. (check-in: 48d201cd user: dan tags: ota-update) | |
| 16:57 | Merge latest trunk fixes into this branch. (check-in: 5efafef5 user: dan tags: ota-update) | |
| 15:34 | Merge latest trunk changes with this branch. (check-in: 55b8011d user: dan tags: ota-update) | |
| 15:22 | Have sqlite3ota.c use grave accents instead of double-quotes to enclose identifiers in generated SQL. To avoid having the SQL engine substitute a literal string if a column reference cannot be resolved. (check-in: 79f24184 user: dan tags: ota-update) | |
| 14:54 | Ensure the correct collation sequences are used when sorting data in sqlite3ota.c. (check-in: 473a72d7 user: dan tags: ota-update) | |
| 12:18 | Have the sqlite3_index_writer() VMs check that the final values of records inserted into indexes on rowid tables are integers. (check-in: cca376bf user: dan tags: ota-update) | |
| 10:44 | Add OP_Affinity opcodes to the VMs generated by sqlite3_index_writer(). (check-in: b9b38cb8 user: dan tags: ota-update) | |
|
2014-09-08
| ||
| 17:50 | Add support for update statements to sqlite3ota.c. (check-in: e109b27e user: dan tags: ota-update) | |
|
2014-09-06
| ||
| 20:19 | Add support for delete operations to the ota extension. (check-in: f988234b user: dan tags: ota-update) | |
|
2014-09-05
| ||
| 19:52 | Switch back to using a single database connection in sqlite3ota.c. (check-in: 3c2f4a07 user: dan tags: ota-update) | |
| 19:31 | Reorganize the code in sqlite3ota.c in preparation for adding support for update and delete operations. (check-in: 98387f05 user: dan tags: ota-update) | |
|
2014-09-04
| ||
| 19:05 | Avoid ever running a checkpoint in ota mode. (check-in: 9ae44447 user: dan tags: ota-update) | |
| 18:05 | Fix showwal.c so that it works with 64KiB pages. (check-in: fc4f7c11 user: dan tags: ota-update) | |