Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 most recent check-ins related to "ota-update"
2015-05-19
| ||
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-18
| ||
12:28 | Transitive constraints should only work if operands have compatible affinities and collating sequences. (check-in: 5df40564 user: drh tags: trunk) | |
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) | |
01:05 | A new implementation of indexing with the IS operator that works correctly when the IS operator is in the WHERE clause and the operands are from opposite sides of a LEFT JOIN. (check-in: 4541688b user: drh tags: index-is-operator) | |
2015-05-13
| ||
04:50 | Enhancements to the MSVC makefile. (check-in: 59e3e9e7 user: mistachkin tags: trunk) | |
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) | |
13:37 | Fix a faulty assert() in the "AS" alias resolution logic of the parser. (check-in: b5e43602 user: drh tags: trunk) | |
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) | |
09:16 | Remove an incorrect assert() statement from sqlite3Fts3Dequote(). (check-in: bd06eeb8 user: dan tags: trunk) | |
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) | |
12:16 | Version 3.8.9 (check-in: 8a8ffc86 user: drh tags: trunk, release, version-3.8.9) | |
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) | |
16:43 | Prevent a virtual table from being destroyed while it is in use. Also: replace Vdbe.inVtabMethod with sqlite3.nVDestroy. Simplify the EXPLAIN output for P4.pVtab to only show the sqlite3_vtab pointer. (check-in: cbeb9a1a user: drh tags: trunk) | |
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) | |
13:01 | Fix the LIKE optimization so that it works even if there are additional range contraints on the column that is subject to the LIKE or GLOB. (check-in: 984c3fd5 user: drh tags: trunk) | |
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) | |
15:42 | Update document on sqlite3_mprintf() and related functions. Discuss the %w format and point out that obscure ANSI-C formats are not supported. No changes to code. (check-in: f8917ba4 user: drh tags: trunk) | |
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) | |
02:43 | Move the os_unix.c file closer to apple-osx. (check-in: 81f242e3 user: drh tags: trunk) | |
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) | |
2015-02-07
| ||
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) | |
14:51 | Change the name of ".info" to ".dbinfo" and add an optional second argument which is the ATTACH-ed DB about which information is provided. Provide ".indexes" as an alternative name to the legacy ".indices" command. (check-in: 0f65a7e2 user: drh tags: trunk) | |
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) | |
23:13 | Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (Closed-Leaf check-in: 3af19f84 user: drh tags: index_xinfo) | |
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) | |
02:00 | Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. (check-in: 30f51d7b user: drh tags: index_xinfo) | |
2015-01-30
| ||
21:00 | Merge the SQLITE_TESTCTRL_IMPOSTER changes from trunk. (check-in: 3ed6eb2f user: drh tags: ota-update) | |
20:59 | Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. (check-in: 42d56017 user: drh tags: trunk) | |
16:36 | Merge all recent trunk changes, and especially the SQLITE_TESTCTRL_INITMODE enhancement. (check-in: 36436dde user: drh tags: ota-update) | |
15:52 | Added SQLITE_TESTCTRL_INITMODE for improved testability. (check-in: 98e02913 user: drh tags: trunk) | |
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) | |
2015-01-27
| ||
21:24 | Fix harmless compiler warnings. (check-in: e7d2ec04 user: mistachkin tags: trunk) | |
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) | |
14:56 | Avoid accessing a single uninitialized byte when moving a rare 3-byte cell from an internal page to a leaf. This was not actually causing a problem, just a valgrind warning. (check-in: 6aeece19 user: dan tags: trunk) | |
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
| ||
23:21 | Fix a typo in a requirements mark on the abs() SQL function. (check-in: b1e6c02f user: drh tags: trunk) | |
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) | |