/ History for ext/rbu/sqlite3rbu.c
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for ext/rbu/sqlite3rbu.c

2020-01-11
16:08
[77a47f32] part of check-in [bcb43d11] Redesign for better legacy compatibility. Add the sqlite3_uri_key() interface. (check-in: [bcb43d11] user: drh branch: enhanced-uri, size: 170556)
2019-12-20
20:03
[4e9a59aa] part of check-in [0b9d8a12] Fix a bad interaction between RBU and [df51ae19]. (check-in: [0b9d8a12] user: dan branch: trunk, size: 171265)
2019-08-13
15:11
[f3a3e09f] part of check-in [8c44b02f] Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. (check-in: [8c44b02f] user: dan branch: trunk, size: 171265)
2019-08-09
01:11
[4261ba8d] part of check-in [1b85442b] Fix more compiler warnings. (check-in: [1b85442b] user: drh branch: trunk, size: 171200)
2019-07-26
20:33
[b254d13a] part of check-in [6bfa44da] Update RBU so that it supports indexes on expressions. (check-in: [6bfa44da] user: dan branch: trunk, size: 171196)
16:16
[38c57eca] part of check-in [e1ccf211] Fix RBU handling of partial indexes with comments embedded in their CREATE INDEX statements. (check-in: [e1ccf211] user: dan branch: trunk, size: 169408)
2019-05-10
20:44
[8741c0ee] part of check-in [a194e536] Add tests for the RBU module. (check-in: [a194e536] user: dan branch: trunk, size: 169088)
2019-05-08
21:14
[311fe2c2] part of check-in [30392985] Add another test case to cover a previously uncovered branch in the RBU module. (check-in: [30392985] user: dan branch: trunk, size: 169110)
18:49
[65794a32] part of check-in [ecb56b75] Add tests to improve code coverage of the RBU module. (check-in: [ecb56b75] user: dan branch: trunk, size: 169096)
2019-05-07
16:28
[ec93d28c] part of check-in [7b051698] Remove some redundant code from sqlite3rbu.c. Add test cases for RBU vacuum. (check-in: [7b051698] user: dan branch: rbu-opt, size: 169262)
2019-05-06
20:40
[e2669fb2] part of check-in [6b3261bf] Optimize further cases of restarting an RBU vacuum. (check-in: [6b3261bf] user: dan branch: rbu-opt, size: 167256)
2019-05-04
20:04
[03d4acab] part of check-in [cdc09867] Optimize some cases of restarting an RBU vacuum. (check-in: [cdc09867] user: dan branch: rbu-opt, size: 164356)
2019-04-13
14:07
[f222350c] part of check-in [c28c973a] Fixes for harmless compiler warnings. (check-in: [c28c973a] user: drh branch: trunk, size: 161263)
2019-04-11
16:54
[3f21eda2] part of check-in [31eb27f4] Fix RBU so that it does not write rows that should be excluded into partial indexes (corrupting the database). (check-in: [31eb27f4] user: dan branch: trunk, size: 161208)
2019-02-19
17:45
[d0627582] part of check-in [12517d1b] 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. (check-in: [12517d1b] user: drh branch: trunk, size: 159182)
2019-01-03
15:17
[d643661c] part of check-in [bef216df] Fix a problem with the second and subsequent sqlite3rbu_savestate() calls made on an RBU vacuum handle. (check-in: [bef216df] user: dan branch: trunk, size: 159156)
2018-12-10
08:41
[f722ed41] part of check-in [c878d741] Fix a problem with using "<db>-vacuum" (the default) as the state database when resuming an RBU vacuum. (check-in: [c878d741] user: dan branch: trunk, size: 159080)
2018-10-25
11:55
[4eea9238] part of check-in [fda8fdb0] Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. Cherrypick of [310b4b65]. (check-in: [fda8fdb0] user: dan branch: branch-3.22, size: 158434)
2018-10-01
17:33
[71f8c099] part of check-in [310b4b65] Speed up xAccess() calls made on an RBU VFS when there are lots of open connections. (check-in: [310b4b65] user: dan branch: trunk, size: 158938)
2018-04-28
18:20
[f438fea8] part of check-in [564ae829] 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. (check-in: [564ae829] user: dan branch: trunk, size: 157386)
2018-03-22
17:13
[f6e9ca38] part of check-in [eb4f452e] Fix an RBU problem causing errors when updating tables with default collation sequences that require quoting (e.g. COLLATE "ICU_root-u-kn-on"). (check-in: [eb4f452e] user: dan branch: trunk, size: 156882)
2017-10-05
11:29
[64bd08c1] part of check-in [d22c99b6] Disable the delta checksum verification in RBU by default. Reenable it using -DRBU_ENABLE_DELTA_CKSUM, if desired. (check-in: [d22c99b6] user: drh branch: trunk, size: 156882)
2017-09-05
16:24
[a1a303de] part of check-in [7fdd6298] Add experimental API sqlite3rbu_temp_size_limit(). For limiting the amount of temporary disk space RBU uses. (check-in: [7fdd6298] user: dan branch: trunk, size: 156677)
2017-08-03
15:43
[920941a6] part of check-in [7676b39b] 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. (check-in: [7676b39b] user: dan branch: trunk, size: 154767)
2017-06-13
16:52
[d1438580] part of check-in [c433672d] Fix sqlite3rbu_close() so that the pzErrmsg parameter may be passed NULL. (check-in: [c433672d] user: dan branch: trunk, size: 154686)
2017-03-03
16:51
[2a89efba] part of check-in [915a9a28] 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. (check-in: [915a9a28] user: dan branch: trunk, size: 154615)
2017-03-02
16:56
[cba23db3] part of check-in [4012bb3a] Fix another RBU case similar to the previous. This one for systems where the sector-size is larger than the page-size. (check-in: [4012bb3a] user: dan branch: trunk, size: 154252)
14:51
[3c2dfd3f] part of check-in [edee6a80] 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. (check-in: [edee6a80] user: dan branch: trunk, size: 152890)
2017-01-17
10:41
[bb0de6cd] part of check-in [681d96eb] 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. (check-in: [681d96eb] user: dan branch: trunk, size: 152463)
2017-01-13
18:24
[4ca89fbe] part of check-in [97914266] Fix a problem preventing resumption of RBU operations after recovering from a process or system failure that occurs during the incremental-checkpoint phase. (check-in: [97914266] user: dan branch: trunk, size: 151612)
2016-08-11
18:05
[e074c387] part of check-in [ed406d31] 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(). (check-in: [ed406d31] user: dan branch: trunk, size: 151611)
2016-07-01
12:39
[948677ee] part of check-in [92e7df0f] 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. (check-in: [92e7df0f] user: dan branch: rbu-state-api, size: 151052)
2016-06-13
19:58
[3d35b1dc] part of check-in [0230ca17] 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". (check-in: [0230ca17] user: drh branch: trunk, size: 150022)
2016-06-01
10:37
[a37a7dfb] part of check-in [3bd85fa5] Fix an issue preventing RBU vacuum from working with virtual tables. (check-in: [3bd85fa5] user: dan branch: trunk, size: 150025)
2016-04-25
19:25
[bf366259] part of check-in [7dd48c10] Update the RBU vacuum code so that databases that use custom collation sequences can be vacuumed. (check-in: [7dd48c10] user: dan branch: trunk, size: 149920)
2016-04-21
16:44
[20922328] part of check-in [6e4ac704] 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. (check-in: [6e4ac704] user: dan branch: rbu-vacuum, size: 149921)
15:26
[8310553b] part of check-in [23eac52e] Fix a problem in rbu vacuum on tables with a large sqlite_master table. (check-in: [23eac52e] user: dan branch: rbu-vacuum, size: 149394)
2016-04-20
20:08
[80ab6865] part of check-in [da5c753d] Add a documentation comment for sqlite3rbu_vacuum() to sqlite3rbu.h. (check-in: [da5c753d] user: dan branch: rbu-vacuum, size: 149397)
17:47
[cc44505e] part of check-in [f042fdd1] Add fault injection tests for rbu vacuum. Fix some problems revealed by the same. (check-in: [f042fdd1] user: dan branch: rbu-vacuum, size: 148546)
2016-04-19
19:27
[a6c02a67] part of check-in [74ffea76] 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. (check-in: [74ffea76] user: dan branch: rbu-vacuum, size: 148280)
17:11
[0447a8a3] part of check-in [ca021ba8] 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. (check-in: [ca021ba8] user: dan branch: rbu-vacuum, size: 146847)
16:20
[d269d60b] part of check-in [00b2f4b0] 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). (check-in: [00b2f4b0] user: dan branch: rbu-vacuum, size: 146475)
2016-04-18
21:00
[ac4621fc] part of check-in [29407d70] Another fix to rbu vacuum for a zipvfs case. (check-in: [29407d70] user: dan branch: rbu-vacuum, size: 146254)
18:18
[372ed3aa] part of check-in [d76f4aaa] Fix some zipvfs related problems in RBU vacuum. (check-in: [d76f4aaa] user: dan branch: rbu-vacuum, size: 146082)
2016-04-16
19:02
[721c6c11] part of check-in [bae7f875] Changes so that rbu vacuum works with zipvfs databases. (check-in: [bae7f875] user: dan branch: rbu-vacuum, size: 144333)
17:53
[471b4055] part of check-in [dc19aacc] 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". (check-in: [dc19aacc] user: dan branch: rbu-vacuum, size: 144341)
2016-04-15
20:46
[79b8be4a] part of check-in [0216b48f] Add the experimental sqlite3rbu_vacuum() API function. For opening an RBU handle that rebuilds a database from scratch. (check-in: [0216b48f] user: dan branch: rbu-vacuum, size: 144262)
2016-04-12
20:05
[9097f1d9] part of check-in [ab69527c] More harmless compiler warning fixes. (check-in: [ab69527c] user: mistachkin branch: warnings, size: 137526)
2016-03-19
17:09
[007fc4db] part of check-in [a1132dd9] Fix a problem detecting invalid values in the rbu_control column of an rbu database table. (check-in: [a1132dd9] user: dan branch: rbu-percent-progress, size: 137517)
2016-03-18
20:12
[edeb8f90] part of check-in [65e02368] Add further tests for sqlite3rbu_bp_progress(). Fix a problem in handling WITHOUT ROWID tables in the same. (check-in: [65e02368] user: dan branch: rbu-percent-progress, size: 137490)
18:56
[6b7dc899] part of check-in [1a1b69e8] Change the name of the new API on this branch to "sqlite3_bp_progress". Add tests and documentation for the same. (check-in: [1a1b69e8] user: dan branch: rbu-percent-progress, size: 137215)
10:29
[c89f1e59] part of check-in [bf823217] 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. (check-in: [bf823217] user: dan branch: rbu-percent-progress, size: 135262)
2016-03-17
21:06
[9bcf35b2] part of check-in [ffc58d2c] Add an API to indicate the percentage progress of an rbu update. (check-in: [ffc58d2c] user: dan branch: rbu-percent-progress, size: 135210)
2016-03-08
16:02
[5956f8be] part of check-in [2179a106] Remove an unused goto label in the RBU extension. (check-in: [2179a106] user: drh branch: trunk, size: 130640)
2016-03-07
17:39
[0d901d77] part of check-in [169311c8] Add a new row type to RBU (a peer of insert, update and delete) - "delete then insert". (check-in: [169311c8] user: dan branch: rbu-delete-then-insert, size: 130652)
2016-02-19
15:17
[371e8bf0] part of check-in [a1a3ff1f] Fix a couple of harmless warnings generated by clang. (check-in: [a1a3ff1f] user: drh branch: trunk, size: 130163)
2016-01-14
13:22
[bea95419] part of check-in [fabe78c5] Fix harmless compiler warnings in RBU and add RBU to the autoconf and windows makefiles. (check-in: [fabe78c5] user: drh branch: trunk, size: 130162)
2015-10-08
17:35
[ea47de61] part of check-in [df9ef61f] In the RBU extension, use MoveFile() instead of rename() on Windows CE. (check-in: [df9ef61f] user: mistachkin branch: trunk, size: 130086)
2015-08-28
16:41
[4ba82bd8] part of check-in [0fdc36fe] Fix compiler warnings in rbu code. (check-in: [0fdc36fe] user: dan branch: trunk, size: 128815)
2015-08-19
08:34
[1650e682] part of check-in [dec14a39] When updating a zipvfs database with RBU, set journal_mode=off to prevent the upper-level pager from creating a large temporary file. (check-in: [dec14a39] user: dan branch: trunk, size: 128732)
2015-08-13
18:26
[08fddeae] part of check-in [851a875a] Add the sqlite3rbu_savestate() function to the rbu extension. To force rbu to save its state to disk without closing the sqlite3rbu* handle. (check-in: [851a875a] user: dan branch: trunk, size: 128250)
11:46
[e2ebcebf] part of check-in [ee966af8] Avoid invoking system call unlink() directly from RBU code. Use the xDelete method of the default VFS instead. (check-in: [ee966af8] user: dan branch: trunk, size: 127542)
2015-08-08
22:47
[07cef198] part of check-in [be190fe7] Fix compiler warnings and remove unreachable code. (check-in: [be190fe7] user: drh branch: warnings, size: 127502)
15:13
[df8658bc] part of check-in [1d75a41b] Update RBU to avoid repreparing a statement immediately after it is prepared. (check-in: [1d75a41b] user: dan branch: trunk, size: 127506)
2015-07-31
19:52
[ffabbb80] part of check-in [e26ef165] Add support for "fossil deltas" to RBU and "sqldiff --rbu". (check-in: [e26ef165] user: dan branch: trunk, size: 127506)
2015-07-30
11:38
[75409b33] part of check-in [287aa306] 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. (check-in: [287aa306] user: dan branch: trunk, size: 120004)
2015-07-24
21:19
[dbd7e4b3] part of check-in [cca79fdc] Enable the RBU extension to compile cleanly on Windows using MSVC. (check-in: [cca79fdc] user: mistachkin branch: trunk, size: 118666)
18:58
[7a0ca8fc] part of check-in [45c6a760] Allow the RBU module to read data from appropriately named SQL views created within the RBU database. (check-in: [45c6a760] user: dan branch: trunk, size: 118611)
2015-07-23
20:44
[d37e1ca2] part of check-in [017c5019] Change the name of the OTA extension to RBU: Resumable Bulk Update. (check-in: [017c5019] user: drh branch: trunk, size: 118598) Renamed from ext/ota/sqlite3ota.c