Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of ext/rbu/sqlite3rbu.c
|
2019-08-13
| ||
| 15:11 | Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. file: [f3a3e09f] check-in: [8c44b02f] user: dan branch: trunk, size: 171265 | |
|
2019-08-09
| ||
| 01:11 | Fix more compiler warnings. file: [4261ba8d] check-in: [1b85442b] user: drh branch: trunk, size: 171200 | |
|
2019-07-26
| ||
| 20:33 | Update RBU so that it supports indexes on expressions. file: [b254d13a] check-in: [6bfa44da] user: dan branch: trunk, size: 171196 | |
| 16:16 | Fix RBU handling of partial indexes with comments embedded in their CREATE INDEX statements. file: [38c57eca] check-in: [e1ccf211] user: dan branch: trunk, size: 169408 | |
|
2019-05-10
| ||
| 20:44 | Add tests for the RBU module. file: [8741c0ee] check-in: [a194e536] user: dan branch: trunk, size: 169088 | |
|
2019-05-08
| ||
| 21:14 | Add another test case to cover a previously uncovered branch in the RBU module. file: [311fe2c2] check-in: [30392985] user: dan branch: trunk, size: 169110 | |
| 18:49 | Add tests to improve code coverage of the RBU module. file: [65794a32] check-in: [ecb56b75] user: dan branch: trunk, size: 169096 | |
|
2019-05-07
| ||
| 16:28 | Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. file: [ec93d28c] check-in: [7b051698] user: dan branch: rbu-opt, size: 169262 | |
|
2019-05-06
| ||
| 20:40 | Optimize further cases of restarting an RBU vacuum. file: [e2669fb2] check-in: [6b3261bf] user: dan branch: rbu-opt, size: 167256 | |
|
2019-05-04
| ||
| 20:04 | Optimize some cases of restarting an RBU vacuum. file: [03d4acab] check-in: [cdc09867] user: dan branch: rbu-opt, size: 164356 | |
|
2019-04-13
| ||
| 14:07 | Fixes for harmless compiler warnings. file: [f222350c] check-in: [c28c973a] user: drh branch: trunk, size: 161263 | |
|
2019-04-11
| ||
| 16:54 | Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database). file: [3f21eda2] check-in: [31eb27f4] user: dan branch: trunk, size: 161208 | |
|
2019-02-19
| ||
| 17:45 | Fix a potential memory leak in RBU if the rbu_fossil_delta() SQL function is misused. Misuse never happens in a working RBU system, so this is not a particularly important fix. file: [d0627582] check-in: [12517d1b] user: drh branch: trunk, size: 159182 | |
|
2019-01-03
| ||
| 15:17 | Fix a problem with the second and subsequent sqlite3rbu_savestate() calls made on an RBU vacuum handle. file: [d643661c] check-in: [bef216df] user: dan branch: trunk, size: 159156 | |
|
2018-12-10
| ||
| 08:41 | Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. file: [f722ed41] check-in: [c878d741] user: dan branch: trunk, size: 159080 | |
|
2018-10-25
| ||
| 11:55 | Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. Cherrypick of [310b4b65]. file: [4eea9238] check-in: [fda8fdb0] user: dan branch: branch-3.22, size: 158434 | |
|
2018-10-01
| ||
| 17:33 | Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. file: [71f8c099] check-in: [310b4b65] user: dan branch: trunk, size: 158938 | |
|
2018-04-28
| ||
| 18:20 | Fix an RBU problem causing spurious SQLITE_CONSTRAINT errors when restarting an RBU update in which more than one source table writes to a single target database table. file: [f438fea8] check-in: [564ae829] user: dan branch: trunk, size: 157386 | |
|
2018-03-22
| ||
| 17:13 | Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). file: [f6e9ca38] check-in: [eb4f452e] user: dan branch: trunk, size: 156882 | |
|
2017-10-05
| ||
| 11:29 | Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. file: [64bd08c1] check-in: [d22c99b6] user: drh branch: trunk, size: 156882 | |
|
2017-09-05
| ||
| 16:24 | Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. file: [a1a303de] check-in: [7fdd6298] user: dan branch: trunk, size: 156677 | |
|
2017-08-03
| ||
| 15:43 | Fix some problems in RBU test cases. Also update RBU source code to better handle the trivial case where an RBU update is applied to a database zero pages in size. file: [920941a6] check-in: [7676b39b] user: dan branch: trunk, size: 154767 | |
|
2017-06-13
| ||
| 16:52 | Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. file: [d1438580] check-in: [c433672d] user: dan branch: trunk, size: 154686 | |
|
2017-03-03
| ||
| 16:51 | Before beginning an incremental checkpoint in RBU, sync the directory containing the target database file. This ensures that the new directory entry created by renaming the *-oal file to *-wal is synced to disk. file: [2a89efba] check-in: [915a9a28] user: dan branch: trunk, size: 154615 | |
|
2017-03-02
| ||
| 16:56 | Fix another RBU case similar to the previous. This one for systems where the sector-size is larger than the page-size. file: [cba23db3] check-in: [4012bb3a] user: dan branch: trunk, size: 154252 | |
| 14:51 | When saving the state of an RBU update in the incremental-checkpoint phase, sync the database file. Otherwise, if a power failure occurs and the RBU update resumed following system recovery, the database may become corrupt. file: [3c2dfd3f] check-in: [edee6a80] user: dan branch: trunk, size: 152890 | |
|
2017-01-17
| ||
| 10:41 | Fix a problem that could cause a spurious SQLITE_NOMEM error when attempting to resume an RBU operation if the previous client failed right after completing the incremental checkpoint. Also a "cannot vacuum wal db" error that could occur when resuming an RBU vacuum if an error (OOM or IO error) occurs during the incremental checkpoint. file: [bb0de6cd] check-in: [681d96eb] user: dan branch: trunk, size: 152463 | |
|
2017-01-13
| ||
| 18:24 | Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. file: [4ca89fbe] check-in: [97914266] user: dan branch: trunk, size: 151612 | |
|
2016-08-11
| ||
| 18:05 | Add the "modeof=<filename>" URI parameter to os_unix.c - used to specify a file to copy permissions from when a new database is created. Also allow passing NULL as the second parameter to sqlite3rbu_vacuum(). file: [e074c387] check-in: [ed406d31] user: dan branch: trunk, size: 151611 | |
|
2016-07-01
| ||
| 12:39 | Add the sqlite3rbu_state() API. Used to determine the current state (creating OAL, ready to move OAL, incremental-checkpoint, finished or error) of an RBU operation. file: [948677ee] check-in: [92e7df0f] user: dan branch: rbu-state-api, size: 151052 | |
|
2016-06-13
| ||
| 19:58 | Fix RBU so that it builds with -DSQLITE_ENABLE_8_3_NAMES. Fix "PRAGMA compile_options" for SQLITE_ENABLE_8_3_NAMES such that it reports the numeric setting: "1" or "2". file: [3d35b1dc] check-in: [0230ca17] user: drh branch: trunk, size: 150022 | |
|
2016-06-01
| ||
| 10:37 | Fix an issue preventing RBU vacuum from working with virtual tables. file: [a37a7dfb] check-in: [3bd85fa5] user: dan branch: trunk, size: 150025 | |
|
2016-04-25
| ||
| 19:25 | Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. file: [bf366259] check-in: [7dd48c10] user: dan branch: trunk, size: 149920 | |
|
2016-04-21
| ||
| 16:44 | If a call to sqlite3rbu_close() on an rbu handle opened by sqlite3rbu_vacuum() returns other than SQLITE_OK, delete the contents of the rbu_state table. This ensures that if an RBU vacuum operation either completes successfully or encounters an error, the next call to sqlite3rbu_vacuum() with the same parameters starts a new RBU vacuum operation. file: [20922328] check-in: [6e4ac704] user: dan branch: rbu-vacuum, size: 149921 | |
| 15:26 | Fix a problem in rbu vacuum on tables with a large sqlite_master table. file: [8310553b] check-in: [23eac52e] user: dan branch: rbu-vacuum, size: 149394 | |
|
2016-04-20
| ||
| 20:08 | Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. file: [80ab6865] check-in: [da5c753d] user: dan branch: rbu-vacuum, size: 149397 | |
| 17:47 | Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. file: [cc44505e] check-in: [f042fdd1] user: dan branch: rbu-vacuum, size: 148546 | |
|
2016-04-19
| ||
| 19:27 | Updates to ensure the values of PRAGMA settings like "page_size", "auto_vacuum", "user_version" and "application_id" are not lost when a database is RBU vacuumed. file: [a6c02a67] check-in: [74ffea76] user: dan branch: rbu-vacuum, size: 148280 | |
| 17:11 | When an RBU vacuum is started on a db identified using a URI filename, pass the same URI parameters when creating the new version of the db. This ensures that RBU vacuum works with password protected databases. file: [0447a8a3] check-in: [ca021ba8] user: dan branch: rbu-vacuum, size: 146847 | |
| 16:20 | Detect attempts to use rbu vacuum on a wal mode database (not allowed). And attempts to write to a database in the middle of an rbu vacuum (which prevents the vacuum from resuming). file: [d269d60b] check-in: [00b2f4b0] user: dan branch: rbu-vacuum, size: 146475 | |
|
2016-04-18
| ||
| 21:00 | Another fix to rbu vacuum for a zipvfs case. file: [ac4621fc] check-in: [29407d70] user: dan branch: rbu-vacuum, size: 146254 | |
| 18:18 | Fix some zipvfs related problems in RBU vacuum. file: [372ed3aa] check-in: [d76f4aaa] user: dan branch: rbu-vacuum, size: 146082 | |
|
2016-04-16
| ||
| 19:02 | Changes so that rbu vacuum works with zipvfs databases. file: [721c6c11] check-in: [bae7f875] user: dan branch: rbu-vacuum, size: 144333 | |
| 17:53 | Avoid creating any extra files ("<target>-vacuum") when running an RBU vacuum. Ensure that the OAL file created is "<target>-oal", not "<target>-vacuum-oal". file: [471b4055] check-in: [dc19aacc] user: dan branch: rbu-vacuum, size: 144341 | |
|
2016-04-15
| ||
| 20:46 | Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. file: [79b8be4a] check-in: [0216b48f] user: dan branch: rbu-vacuum, size: 144262 | |
|
2016-04-12
| ||
| 20:05 | More harmless compiler warning fixes. file: [9097f1d9] check-in: [ab69527c] user: mistachkin branch: warnings, size: 137526 | |
|
2016-03-19
| ||
| 17:09 | Fix a problem detecting invalid values in the rbu_control column of an rbu database table. file: [007fc4db] check-in: [a1132dd9] user: dan branch: rbu-percent-progress, size: 137517 | |
|
2016-03-18
| ||
| 20:12 | Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. file: [edeb8f90] check-in: [65e02368] user: dan branch: rbu-percent-progress, size: 137490 | |
| 18:56 | Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. file: [6b7dc899] check-in: [1a1b69e8] user: dan branch: rbu-percent-progress, size: 137215 | |
| 10:29 | Add tests for the changes on this branch. Fix a problem with calls to the new progress indicator API made after an rbu update has been resumed. file: [c89f1e59] check-in: [bf823217] user: dan branch: rbu-percent-progress, size: 135262 | |
|
2016-03-17
| ||
| 21:06 | Add an API to indicate the percentage progress of an rbu update. file: [9bcf35b2] check-in: [ffc58d2c] user: dan branch: rbu-percent-progress, size: 135210 | |
|
2016-03-08
| ||
| 16:02 | Remove an unused goto label in the RBU extension. file: [5956f8be] check-in: [2179a106] user: drh branch: trunk, size: 130640 | |
|
2016-03-07
| ||
| 17:39 | Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". file: [0d901d77] check-in: [169311c8] user: dan branch: rbu-delete-then-insert, size: 130652 | |
|
2016-02-19
| ||
| 15:17 | Fix a couple of harmless warnings generated by clang. file: [371e8bf0] check-in: [a1a3ff1f] user: drh branch: trunk, size: 130163 | |
|
2016-01-14
| ||
| 13:22 | Fix harmless compiler warnings in RBU and add RBU to the autoconf and windows makefiles. file: [bea95419] check-in: [fabe78c5] user: drh branch: trunk, size: 130162 | |
|
2015-10-08
| ||
| 17:35 | In the RBU extension, use MoveFile() instead of rename() on Windows CE. file: [ea47de61] check-in: [df9ef61f] user: mistachkin branch: trunk, size: 130086 | |
|
2015-08-28
| ||
| 16:41 | Fix compiler warnings in rbu code. file: [4ba82bd8] check-in: [0fdc36fe] user: dan branch: trunk, size: 128815 | |
|
2015-08-19
| ||
| 08:34 | When updating a zipvfs database with RBU, set journal_mode=off to prevent the upper-level pager from creating a large temporary file. file: [1650e682] check-in: [dec14a39] user: dan branch: trunk, size: 128732 | |
|
2015-08-13
| ||
| 18:26 | Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. file: [08fddeae] check-in: [851a875a] user: dan branch: trunk, size: 128250 | |
| 11:46 | Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. file: [e2ebcebf] check-in: [ee966af8] user: dan branch: trunk, size: 127542 | |
|
2015-08-08
| ||
| 22:47 | Fix compiler warnings and remove unreachable code. file: [07cef198] check-in: [be190fe7] user: drh branch: warnings, size: 127502 | |
| 15:13 | Update RBU to avoid repreparing a statement immediately after it is prepared. file: [df8658bc] check-in: [1d75a41b] user: dan branch: trunk, size: 127506 | |
|
2015-07-31
| ||
| 19:52 | Add support for "fossil deltas" to RBU and "sqldiff --rbu". file: [ffabbb80] check-in: [e26ef165] user: dan branch: trunk, size: 127506 | |
|
2015-07-30
| ||
| 11:38 | Allow RBU tables to be named "data[0-9]*_<target>" instead of strictly "data_<target>". Also update RBU so that it always processes data tables in order sorted by name. file: [75409b33] check-in: [287aa306] user: dan branch: trunk, size: 120004 | |
|
2015-07-24
| ||
| 21:19 | Enable the RBU extension to compile cleanly on Windows using MSVC. file: [dbd7e4b3] check-in: [cca79fdc] user: mistachkin branch: trunk, size: 118666 | |
| 18:58 | Allow the RBU module to read data from appropriately named SQL views created within the RBU database. file: [7a0ca8fc] check-in: [45c6a760] user: dan branch: trunk, size: 118611 | |
|
2015-07-23
| ||
| 20:44 | Change the name of the OTA extension to RBU: Resumable Bulk Update. file: [d37e1ca2] check-in: [017c5019] user: drh branch: trunk, size: 118598 Renamed from ext/ota/sqlite3ota.c | |