Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
113 check-ins for the month beginning 2020-07-01
Following month ↑|
2020-07-31
| ||
| 23:34 | Back out a NEVER() that turns out to be reachable. (check-in: 8cf342d4e5 user: drh tags: trunk) | |
| 20:56 | Improved non-locking PRNG. (check-in: eb7a9c04bd user: drh tags: begin-concurrent) | |
| 17:08 | Merge latest wal2 changes into this branch. (check-in: ebd39665e5 user: dan tags: begin-concurrent-pnu-wal2) | |
| 16:01 | Merge latest trunk changes into this branch. (check-in: 0c0d0a77bc user: dan tags: wal2) | |
| 02:07 | Remove an ALWAYS() that turns out to be reachable. (check-in: 12bb75d9ed user: drh tags: trunk) | |
|
2020-07-30
| ||
| 23:47 | Test for schema corruption is reachable after all. (check-in: 2032236cce user: drh tags: trunk) | |
| 22:33 | Provide an alternative "guaranteed-safe" method for overwriting the WAL index on recovery, in case some platform is found for which memcpy() cannot do this safely. (check-in: 168cccbabb user: drh tags: trunk) | |
| 19:56 | Merge begin-concurrent-pnu changes into this branch. (check-in: fd01e78827 user: dan tags: begin-concurrent-report) | |
| 19:37 | Merge latest trunk change into this branch. (check-in: 2b3241cf67 user: dan tags: begin-concurrent-pnu) | |
| 19:19 | Merge latest trunk changes into this branch. (check-in: e8a6651539 user: dan tags: begin-concurrent) | |
| 17:37 | Fix compiler warnings in MSVC. (check-in: 96e3dba2ed user: drh tags: trunk) | |
| 17:29 | Allow for page numbers as large as 4294967294 (0xfffffffe) which means database files as large as 281 TB. (check-in: 166e82dd20 user: drh tags: trunk) | |
| 17:14 | Fix unreachable branches. (Closed-Leaf check-in: 905752da98 user: drh tags: larger-databases) | |
|
2020-07-29
| ||
| 16:18 | Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (Leaf check-in: a80ae2c98b user: drh tags: typos) | |
| 12:23 | Fix signed/unsigned compiler warnings. (check-in: 1d69eee8b0 user: drh tags: larger-databases) | |
|
2020-07-28
| ||
| 20:32 | Earlier detection of out-of-range page numbers in the btree layer. (check-in: 805bb67a82 user: drh tags: larger-databases) | |
| 17:51 | Merge enhancements from trunk. (check-in: 969c25bb14 user: drh tags: larger-databases) | |
| 17:29 | If a writer crashes in WAL mode and leave the SHM file in an inconsistent state, subsequent transactions are now able to recover the SHM file even if there are active read transactions. (check-in: ee8a108058 user: drh tags: trunk) | |
| 17:17 | Add an sqlite3FaultSim() to make an OOM case more accessible and remove the ALWAYS() on the conditional that is false when the OOM actually occurs. (Closed-Leaf check-in: 2a251af84f user: drh tags: unlocked-recovery) | |
|
2020-07-27
| ||
| 20:16 | On recovery, always overwrite the old with the new, even if they are the same. Add ALWAYS() macros on branches currently thought to be unreachable, pending additional testing. (check-in: 7052cf1d53 user: drh tags: unlocked-recovery) | |
| 15:05 | Fix a couple of test scripts to match the new wal recovery behaviour on this branch. (check-in: 3af61e8353 user: dan tags: unlocked-recovery) | |
| 15:01 | Improved error reporting if walLockExclusive() fails. (check-in: cf962d213a user: drh tags: unlocked-recovery) | |
|
2020-07-25
| ||
| 20:16 | When trying to read the index header, accept either of the two headers that have a valid checksum after 15 attempts to get exactly matching headers fail. (Closed-Leaf check-in: 3549faefea user: drh tags: more-aggressive-wal-recovery) | |
| 20:16 | Allow a wal mode recovery to proceed even if there are readers. (check-in: 74374aebf9 user: dan tags: unlocked-recovery) | |
|
2020-07-24
| ||
| 13:49 | Merge recent changes from trunk. (check-in: 22e8e6901a user: drh tags: larger-databases) | |
| 11:01 | Remove a surplus space from a comment (check-in: 73fecc688a user: drh tags: trunk) | |
| 09:17 | Fix other potentiall pointer aliasing problems associated with subclassing of the sqlite3_file object for various VFS implementations. (check-in: 270ac1a0f2 user: drh tags: trunk) | |
| 09:14 | Fix pointer aliasing problem in the in-memory journal code. Ref: forum post d44eb2fc44 (check-in: 892e9191dc user: drh tags: trunk) | |
|
2020-07-23
| ||
| 20:37 | Turns out this is an aliasing bug in SQLite, not a GCC bug. Was: Work-around for what appears to be another GCC bug - this one for GCC 8.3.0 on ARM. See the SQLite forum post for discussion. (Closed-Leaf check-in: 40c44d3810 user: drh tags: mistake) | |
| 18:03 | Add the OMIT_ZLIB compile-time option to sessionfuzz.c. (Originally checked into the wrong branch.) (check-in: 6019bf8a2d user: drh tags: trunk) | |
| 18:01 | Add the OMIT_ZLIB compile-time option to sessionfuzz.c. (Closed-Leaf check-in: 0785e3146e user: drh tags: wrong-branch) | |
| 15:23 | Fix a typo in an error message. (check-in: 849b03d8de user: drh tags: larger-databases) | |
| 14:27 | Merge fixes from trunk. (check-in: dd39418ee4 user: drh tags: larger-databases) | |
| 14:12 | An ORDER BY clause can slip into an SRT_Upfrom query via the query flattener, even without the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option. So always enable the code to deal with that case. (check-in: 6a3111cd06 user: drh tags: trunk) | |
| 13:45 | Fix another case where a corrupt record could cause an assert() to fail in fts3. (check-in: 28515bbbae user: dan tags: trunk) | |
| 09:14 | Merge support for partial integrity checks. (check-in: b5443b47af user: drh tags: larger-databases) | |
| 00:45 | Add the ability to do a PRAGMA integrity_check (or quick_check) on a single table by specifying the table name as the argument. (check-in: 65dd321432 user: drh tags: trunk) | |
|
2020-07-22
| ||
| 21:11 | Detect out-of-bounds rootpage values in the schema. (check-in: e4a92688fc user: drh tags: larger-databases) | |
| 21:05 | Disable rootpage bounds checking when the SQLITE_TESTCTRL_EXTRA_SCHEMA_CHECKS setting is off, to facilitate reaching obscure error states during testing. (Closed-Leaf check-in: d7dd4fc464 user: drh tags: rootpage-bounds-check) | |
| 20:12 | Improvements to rootpage bounds checking during schema parse. (check-in: 75599a9731 user: drh tags: rootpage-bounds-check) | |
| 18:03 | When parsing the schema, detect out-of-bounds rootpage values and throw an error. (check-in: 6c3a2727dc user: drh tags: rootpage-bounds-check) | |
| 17:12 | All TCL tests now passing. (check-in: 4c5f3c6cac user: drh tags: larger-databases) | |
| 13:56 | Most test cases now passing. (check-in: 92e2ab3893 user: drh tags: larger-databases) | |
| 13:38 | Continuing work toward supporting unsigned 32-bit page numbers. (check-in: 9ce1710aad user: drh tags: larger-databases) | |
| 11:42 | Enhance showdb to be 32-bit clean. (check-in: a8200327d4 user: drh tags: larger-databases) | |
| 10:36 | Merge fixes from trunk. (check-in: d2aac00120 user: drh tags: larger-databases) | |
|
2020-07-21
| ||
| 18:36 | Work-around for GCC bug 96270. (check-in: 9679c0c611 user: drh tags: trunk) | |
| 18:25 | Add the sqlite3Int64ToText() routine and use it to convert integers to text, as it is much faster than the generic text formatter. (check-in: 14eed318aa user: drh tags: trunk) | |
|
2020-07-20
| ||
| 23:33 | Fix the ".read" command so that it gives an error when its argument is a directory. See forum message 4c53c434ca. (check-in: 6d258c3c7e user: drh tags: trunk) | |
| 18:07 | Fix a corner-case error in the new UPDATE FROM logic helpfully discovered by OSSFuzz. (check-in: 5cc200939d user: drh tags: trunk) | |
| 14:54 | Add the "enlargedb" utility program used to construct very large database files for testing. (check-in: 66858d8750 user: drh tags: larger-databases) | |
| 13:11 | Faster column name lookup in the columnIndex() routine using hashing. (check-in: de2a908124 user: drh tags: trunk) | |
| 12:47 | Initial changes to allow database up to 281TB in size. (check-in: 9cb7da9bdb user: drh tags: larger-databases) | |
|
2020-07-18
| ||
| 18:59 | Fix test case result on a DELETE with an INDEXED BY clause due to improvements in the query planner at [d901837fea1ed54d] (check-in: 020dbfa2ae user: drh tags: trunk) | |
| 18:44 | More harmless compiler warning fixes. (check-in: 4c0d208c45 user: drh tags: trunk) | |
| 18:03 | Fix a harmless compiler warning. (check-in: 5a0b0c6e11 user: drh tags: trunk) | |
| 15:52 | Add UPDATE FROM compatible with postgresql. (check-in: 88baf1eb07 user: drh tags: trunk) | |
|
2020-07-17
| ||
| 22:20 | Add ALWAYS() around a conditional that is always true. (Closed-Leaf check-in: 270e17bba1 user: drh tags: update-from) | |
| 18:07 | Use #ifdef to omit code that is only reachable when the SQLITE_ENABLE_UPDATE_DELETE_LIMIT compile-time option is used. (check-in: 587ded6035 user: drh tags: update-from) | |
| 16:31 | Make it an error to repeat the target object/alias of an UPDATE statement in its FROM clause. (check-in: d90a37e930 user: dan tags: update-from) | |
| 15:34 | Add a couple of "#ifdef SQLITE_ENABLE_UPDATE_DELETE_LIMIT" blocks missing from new code on this branch. (check-in: cc471df04a user: dan tags: update-from) | |
| 11:07 | Bring this branch up to date with begin-concurrent-pnu. (check-in: 12a909fb3d user: dan tags: begin-concurrent-report) | |
|
2020-07-16
| ||
| 20:57 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: 2160ede1d1 user: dan tags: begin-concurrent-pnu-wal2) | |
| 20:39 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: e9393a18cb user: dan tags: begin-concurrent-pnu) | |
| 20:24 | Allow BEGIN CONCURRENT transactions to contain schema modifications. However, this causes them to conflict with all other transactions. (check-in: 9a4a02304e user: dan tags: begin-concurrent) | |
| 18:55 | Relax pointless restrictions on allowing tables in the FROM clause from crossing over LEFT JOINs, as long as the table being moved is not the right table of the LEFT JOIN. (check-in: c1ea064948 user: drh tags: trunk) | |
| 14:52 | Modifications to test code so that the sqlite3MemdebugHastype() assert() statements are enabled for Tcl tests. (check-in: e3c423cb14 user: dan tags: update-from) | |
| 14:19 | Small performance improvement and size reduction in sqlite3DbStrNDup(). (check-in: 35cd87063d user: drh tags: trunk) | |
| 10:48 | Add OOM test for UPDATE...FROM statements inside triggers. (check-in: 917a479b0d user: dan tags: update-from) | |
| 02:36 | Fix a double-free of the FROM clause of an UPDATE inside of triggers. (check-in: 706c8da2f6 user: drh tags: update-from) | |
| 00:45 | Separate VdbeCoverage() macro for different jumps. (check-in: da593e57df user: drh tags: update-from) | |
|
2020-07-15
| ||
| 21:53 | Fix a problem in UPDATE FROM in which it tries to free using sqlite3_free() instead of sqlite3DbFree(). (check-in: 8ca8752652 user: drh tags: update-from) | |
| 20:01 | This was originally a merge to trunk. But after further testing, maybe it is better to run it a little longer on a branch. (check-in: 7d7d5ecbd7 user: dan tags: update-from) | |
| 19:38 | Add tests for UPDATE...FROM and foreign keys. (check-in: 6c3668f9ed user: dan tags: update-from) | |
| 18:30 | Fix problems that could occur if a table with the same name as the table being updated appeared in the FROM clause of an UPDATE statement. (check-in: 13224cbd75 user: dan tags: update-from) | |
| 15:32 | Fix a problem in SQLITE_ENABLE_HIDDEN_COLUMN builds occuring when an UPDATE...FROM fired an INSTEAD OF trigger. (check-in: 5176cb7a6a user: dan tags: update-from) | |
| 11:00 | Update this branch with changes from trunk. (check-in: 53b8b507a1 user: dan tags: update-from) | |
| 02:15 | New test cases for decimal and ieee754. (check-in: 73d62f82f9 user: drh tags: trunk) | |
|
2020-07-14
| ||
| 23:58 | Improvements to the min()/max() optimization so that it is able to use indexes where terms are constrained by IN operators. (check-in: b8ba2f17f9 user: drh tags: trunk) | |
| 22:20 | Now appears to work. All legacy tests pass. Need to add new tests, however. (Closed-Leaf check-in: 81e6450980 user: drh tags: minmax-opt-exp) | |
| 19:51 | Support UPDATE...FROM statements in trigger programs. (check-in: 4f6d8d0ebf user: dan tags: update-from) | |
| 15:30 | Fix an obsolete header comment on the sqlite3WhereIsOrdered() routine. (check-in: 5041f6a1c4 user: drh tags: trunk) | |
| 13:02 | Merge fixes from trunk. (check-in: 2af372f59e user: drh tags: minmax-opt-exp) | |
| 12:40 | Early detection of freelist size corruption in incremental vacuum. (check-in: f25a56c26e user: drh tags: trunk) | |
| 02:03 | Fix a crash. Not all tests pass, but tests do at least run to completion now. (check-in: b5d38e28c6 user: drh tags: minmax-opt-exp) | |
| 01:51 | Fix an obsolete assert(). (check-in: 221e021077 user: drh tags: minmax-opt-exp) | |
| 01:03 | Merge latest changes from trunk. This branch still does not work. (check-in: 6144387238 user: drh tags: minmax-opt-exp) | |
|
2020-07-13
| ||
| 20:43 | Add test for LEFT JOIN in UPDATE...FROM statement. (check-in: 4f3dff045a user: dan tags: update-from) | |
| 20:10 | Add test cases and fixes for UPDATE...FROM statements that modify primary key columns. (check-in: 47c87af3e5 user: dan tags: update-from) | |
| 18:04 | Merge latest trunk changes with this branch. (check-in: 5ee3c27e20 user: dan tags: update-from) | |
| 15:35 | Add back the ALWAYS() macro that was removed by [f7a74f89dbd58b47] as the condition is no longer reachable due to the previous check-in. (check-in: 9cb03beae4 user: drh tags: trunk) | |
| 15:20 | Fix a problem causing queries containing window functions to ignore collation sequences under some circumstances. (check-in: e6c2192ef8 user: dan tags: trunk) | |
| 11:06 | Fix an integer overflow bug in fts5 triggered by a corrupt record. (check-in: 49da8bdce1 user: dan tags: trunk) | |
|
2020-07-11
| ||
| 16:45 | Add second test case for the improvement in [30735432]. (check-in: 1bd18ca35b user: dan tags: trunk) | |
| 16:42 | Improved detection of a corrupt database schema. Fix for a problem discovered by dbsqlfuzz. (check-in: 30735432bc user: drh tags: trunk) | |
|
2020-07-10
| ||
| 21:43 | Remove unnecessary code from the window functions implementation. (check-in: 1e87da9c93 user: drh tags: trunk) | |
| 19:09 | An attempt to get the Min/Max optimization working with IN constraints. Not currently working. (check-in: 4a64c16fb7 user: drh tags: minmax-opt-exp) | |
| 11:12 | Fix a broken assert() in fts3 that could fail when handling corrupt records. (check-in: 5124732370 user: dan tags: trunk) | |
|
2020-07-09
| ||
| 21:29 | Fix handling of another corrupt database case in fts3. (check-in: ccff8cb826 user: dan tags: trunk) | |
| 14:05 | Fix a comment typo. No changes to code. (check-in: 610ee8d5dc user: drh tags: trunk) | |
|
2020-07-07
| ||
| 19:24 | Remove bashism from configure script. (check-in: 138beebb2a user: dan tags: trunk) | |
|
2020-07-06
| ||
| 12:13 | Increase the resolution of the vdbe opcode counters to 64 bits, as apparently some users run single prepared statements that go for longer than 4 billion instructions. See forum post "Possible freeze in the progress loop" (check-in: 612eb590ea user: drh tags: trunk) | |
|
2020-07-04
| ||
| 20:29 | Fix the table_info pragma so that it always checks the schema version and reprepares, even if it is a no-op. (check-in: 6da77973ab user: drh tags: trunk) | |
|
2020-07-03
| ||
| 21:24 | Fix the line-number of error messages coming out of the ".import" command when the --skip option is used. (check-in: e0a8b11dfd user: drh tags: trunk) | |
| 21:18 | Fix a compiler warning about an unused procedure in the parser. (check-in: b27bb4fe38 user: drh tags: trunk) | |
| 18:07 | Update the lemon documentation to match recent enhancements. (check-in: ca7630a577 user: drh tags: trunk) | |
| 17:24 | If the amalgamation is built using OPT_FEATURE_FLAGS = -DSQLITE_UDL_CAPABLE_PARSER then it can be compiled with or without the -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT option and it works either way. (check-in: 1f96a29dd8 user: drh tags: trunk) | |
| 15:41 | In lemon, add "%if" and "%else" and allow boolean expressions as the argument to "%if", "%ifdef", and "%ifndef". (check-in: 951d22b72f user: drh tags: trunk) | |
| 12:32 | Fix the pragma_foreign_key_check virtual table so that it accepts arguments. (check-in: 07f849dee3 user: drh tags: trunk) | |
| 12:15 | Fix a problem with "PRAGMA foreign_key_check" where if a table in one schema appears to have foreign key constraints against another table in a different schema, the pragma will try to check the constraints even though they do not apply because they are in different schemas. (check-in: 81bc4b65ae user: drh tags: trunk) | |
|
2020-07-02
| ||
| 17:05 | Minor simplification to the 32-bit varint decoder. (check-in: 6ffd17b668 user: drh tags: trunk) | |
|
2020-07-01
| ||
| 16:19 | Ensure that the "PRAGMA schema_version" command causes the schema to be reparsed and reloaded. (check-in: 27d4a9a7b5 user: drh tags: trunk) | |
| 14:07 | Fix a problem with VM code generated for some aggregate SELECT statements that feature min()/max() aggregates both with and without FILTER clauses. (check-in: 2094da753f user: dan tags: trunk) | |