Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 check-ins occurring around 1e2dcc2d.
|
2021-09-15
| ||
| 16:20 | Fix the xBestIndex method on rtree so that it correctly recognizes that rowid=? works the same as id=?. (check-in: c74c07cc user: drh tags: trunk) | |
| 15:56 | Add ALWAYS() macros on some unreachable branches in rtree. (check-in: 9123f680 user: drh tags: trunk) | |
| 15:53 | Further updates to rtreedoc.test. (check-in: e6672783 user: dan tags: trunk) | |
| 14:48 | Fix non-build for a test configuration (check-in: c9a4ab05 user: larrybr tags: trunk) | |
| 13:09 | Simplify some of the corrupt shadow-table detection logic in rtree. (check-in: 0c4f37aa user: drh tags: trunk) | |
| 11:15 | Squelch needless narrowing warning. (check-in: 5540e6ab user: larrybr tags: trunk) | |
| 10:49 | Ensure rtreedoc.test is not run for builds without the rtree extension. (check-in: 42dff223 user: dan tags: trunk) | |
|
2021-09-14
| ||
| 20:07 | Add test cases to rtreedoc.test. (check-in: afe0ec4d user: dan tags: trunk) | |
| 18:57 | Update requirements marks to reflect recent documentation changes. (check-in: 08cab892 user: drh tags: trunk) | |
| 14:16 | Add test cases to rtreedoc.test. (check-in: b62de126 user: dan tags: trunk) | |
| 11:27 | Minor updates to rtreedoc.test. (check-in: b22c75e4 user: dan tags: trunk) | |
|
2021-09-13
| ||
| 23:11 | Shell to .read any named character source file/device (again.) (check-in: c6fe4f8d user: larrybr tags: trunk) | |
| 18:32 | Add test cases to rtreedoc.test. (check-in: 4ee99d31 user: dan tags: trunk) | |
| 18:16 | Add assert() statements to refute forum post 9f4e7f58fbb66ddd. (check-in: 83a83475 user: drh tags: trunk) | |
| 16:36 | Add new test file rtreedoc.test. (check-in: 8c4b1482 user: dan tags: trunk) | |
| 13:53 | Fix an incorrect comment and possible integer overflow in pager resulting from check-in [23ca23894af352ea]. Problem reported by forum post e2ea1a3f61. Also change the datatype of Pager.pageSize to i64 even though page size never exceeds 65536, in order to help prevent future problems of this kind. (check-in: f4a552ed user: drh tags: trunk) | |
|
2021-09-11
| ||
| 14:33 | Fix a case where the system error was not being set correctly. (check-in: 13a524b3 user: dan tags: wal-shm-exceptions) | |
| 02:42 | CLI prescanner made to match SQLite's rules for delimited identifiers. Tests begun. (check-in: 15b105c5 user: larrybr tags: speedy_cli) | |
|
2021-09-10
| ||
| 22:00 | Make replace.tcl useful with TCL 8.4 (check-in: 2dd61dd9 user: larrybr tags: trunk) | |
| 21:28 | If an EXCEPTION_IN_PAGE_ERROR exception is caught, make the underlying OS error code available via sqlite3_system_errno(). (check-in: fdb20e9e user: dan tags: wal-shm-exceptions) | |
| 19:45 | Make CLI prescan handle goofy identifier delimiters too. Streamline code. (check-in: 968aed69 user: larrybr tags: speedy_cli) | |
| 18:35 | Fix (luckily harmless) typo in memdb.c per https://sqlite.org/forum/forumpost/15af8872d5999df1 (check-in: d577030c user: larrybr tags: trunk) | |
| 01:45 | When showHeader set at CLI invocation, do not auto-set it later. (check-in: 733b7d4f user: larrybr tags: trunk) | |
| 01:02 | Back out changes [00286ca5d998d802] and [6844ede29e1dac93] (replacing the associated branches with NEVER()) and add a single new test to btreeOverwriteCell() that detects when an overflow pages is also mapped into a b-tree page and raises and immediate SQLITE_CORRUPT error before making any changes. dbsqlfuzz 81791bd980fe6935ff2c7334ec8bef11c1c12b82 and others. (check-in: 32210fa4 user: drh tags: trunk) | |
| 00:58 | Speed-up CLI's processing for huge block comments, for any content (check-in: c4568f9f user: larrybr tags: speedy_cli) | |
|
2021-09-09
| ||
| 19:19 | Remove a NEVER() in btree that is sometimes reachable. dbsqlfuzz b9140023005430654c8fe544cf0a082ef8d561c1. (check-in: 6844ede2 user: drh tags: trunk) | |
| 18:06 | Avoid masking off an OOM fault in rtreecheck(). (check-in: 3ebfe712 user: drh tags: trunk) | |
| 14:03 | Improved database corruption detection in the editPage() subroutine of the btree rebalancer. dbsqlfuzz f035b1b5a100a5f0cffb95c958b6c67d7c5eaf1f. (check-in: 00286ca5 user: drh tags: trunk) | |
|
2021-09-08
| ||
| 21:49 | Speedup CLI's gulping of many huge block SQL comments. (check-in: 729620c5 user: larrybr tags: trunk) | |
| 19:25 | Fix PRAGMA integrity_check so that it does not try to enforce types on ANY columns in a STRICT table. (check-in: 57384fda user: drh tags: trunk) | |
|
2021-09-07
| ||
| 20:58 | For sqldiff, sqlite_schema comparisons must use compound (synthesized) PK. (check-in: 5bdd8466 user: larrybr tags: trunk) | |
| 19:23 | New test cases added to fuzzdata8.db. No code changes. (check-in: 51e5aada user: drh tags: trunk) | |
| 19:04 | Make sqldiff able to compare sqlite_schema tables (for detailed schema differences.) (check-in: 7ff92da9 user: larrybr tags: trunk) | |
| 16:05 | Fix a memory leak in fts5 that could occur when writing to an fts5 table that is being scanned by an fts5vocab cursor. (check-in: 1183552d user: dan tags: trunk) | |
| 15:41 | Fix a potential NULL pointer deference in the LIKE optimization. The problem was introduced by the addition of generated columns in check-in [b855acf1831943b3] (SQLite version 3.31.0, 2020-01-22). Reported by Wang Ke in [forum/forumpost/699b44b3ee|forum post 699b44b3ee]. (check-in: b9417d40 user: drh tags: trunk) | |
|
2021-09-06
| ||
| 16:15 | Fix a use-after-free error that could occur if an fts5 table is written while scanning it using an fts5vocab cursor. (check-in: e751c2ec user: dan tags: trunk) | |
| 15:59 | Fix an issue in the "shrink.test" test script reported by forum post 90a74bd618. (check-in: 6c3734ed user: drh tags: trunk) | |
| 11:44 | Restore the use of system isnan() that was removed by check-in [ea748edecb261f2b]. See forum thread d7c530ac587f59e6. (check-in: b3cfe23b user: drh tags: trunk) | |
|
2021-09-05
| ||
| 18:45 | Complete shell.c maker's migration to TCL v.8.4 (check-in: e4b9b5b1 user: larrybr tags: cli_extension) | |
|
2021-09-03
| ||
| 18:11 | Fix an assertion fault in pcache introduced by [4bc93658aa563f2f] and detected by OSSFuzz. Test case in TH3. (check-in: 2262a494 user: drh tags: trunk) | |
|
2021-09-02
| ||
| 16:29 | Get shell.c maker acceptable to TCL v8.4 and minor tweaks (check-in: c60f4f90 user: larrybr tags: cli_extension) | |
| 01:21 | Meld -safe option into CLI (check-in: c7c84998 user: larrybr tags: cli_extension) | |
|
2021-08-31
| ||
| 15:53 | Have the planner ensure that if one scan uses a subset of the WHERE clause of another, that scan is estimated to cost less and return fewer rows. (check-in: c7b34930 user: dan tags: trunk) | |
|
2021-08-30
| ||
| 17:02 | Do not disable a rowid=? term used to drive an IPK index if it is a transitive constraint. Commit [f1f9b5de] made the same change for non-IPK indexes. (check-in: 46e28cbc user: dan tags: trunk) | |
|
2021-08-27
| ||
| 11:26 | Patch lemon to fix "error" token handling, according ot forum post e680f42f53090061. (check-in: 106b5e53 user: drh tags: trunk) | |
|
2021-08-26
| ||
| 21:12 | Change the structuree exception handler in wal.c to catch EXCEPTION_IN_PAGE_ERROR instead of EXCEPTION_ACCESS_VIOLATION. (check-in: 0c6ab539 user: dan tags: wal-shm-exceptions) | |
| 18:31 | Add the --safe to the CLI. Also the --nonce option and the .nonce command. (check-in: c76870cb user: drh tags: trunk) | |
|
2021-08-24
| ||
| 17:07 | Correctly preserve the collating sequence for a column when changing its datatype. Fix for the problem reported by forum post 36be3d3a08da9d92. Test cases in TH3. (check-in: c7f0813c user: drh tags: trunk) | |
|
2021-08-23
| ||
| 15:56 | Fix a typo in a comment. No changes to code. (check-in: d953646a user: drh tags: trunk) | |
| 10:28 | Back out the change that allows typeless columns in strict tables. Replace that capability with an ANY type for strict tables that will accept any datatype with BLOB affinity. (check-in: d8fd1a2b user: drh tags: trunk) | |
|
2021-08-21
| ||
| 20:54 | Allow typeless columns in STRICT tables that are able to accept any data type. (check-in: 1e2dcc2d user: drh tags: trunk) | |
| 16:42 | Defer deleting subqueries in the compound-SELECT code generator until the end of code generation, in order to avoid deleting expressions out from under the aggregation function sanity checking assert()s that occur near the end of SELECT code generation. This fixes the assertion fault described by forum post cfcb4b461d. The problem goes back to check-in [6e6b3729e0549de0]. (check-in: 600f1991 user: drh tags: trunk) | |
| 15:49 | Add test cases to ensure that there is at least one test that causes an exception to be thrown from each SEH_INJECT_FAULT macro. (check-in: e480146f user: dan tags: wal-shm-exceptions) | |
|
2021-08-20
| ||
| 19:51 | Improvement to error handling in Lemon. No impact on SQLite. Forum post 2f468f43cbc48d7f (check-in: 18cc2f85 user: drh tags: trunk) | |
| 18:18 | Use VVA_ONLY() instead of TESTONLY() in SEH macros so that the build works for coverage testing. (check-in: 9e9d5b56 user: drh tags: wal-shm-exceptions) | |
| 17:23 | Add missing SEH_INJECT_FAULT macros. (check-in: 27e9bdb3 user: dan tags: wal-shm-exceptions) | |
| 16:19 | Add some assert() statements and fix small issues with code on this branch. (check-in: bd9b373b user: dan tags: wal-shm-exceptions) | |
| 15:44 | Support for STRICT tables. A table with the STRICT option only allows a few core datatypes on columns and enforces those types rigidly. Also, PRIMARY KEY columns must be NOT NULL. (check-in: f9c1d344 user: drh tags: trunk) | |
| 11:50 | Fix a problem on this branch causing checkpoints that do not proceed because they can't get the CHECKPOINT lock to return incorrect output values. (check-in: 5a98820c user: dan tags: wal-shm-exceptions) | |
| 08:05 | Improved error messages for the SQLITE_CONSTRAINT_DATATYPE error. (Closed-Leaf check-in: 39abca01 user: drh tags: strict-tables) | |
| 01:12 | Do not allow the xfer-optimization to move the content of an ordinary table into a strict table. (check-in: 1ed1b594 user: drh tags: strict-tables) | |
|
2021-08-19
| ||
| 23:10 | Enable this branch to run both with and without the -DSQLITE_USE_SEH option. (check-in: 840e0a14 user: drh tags: wal-shm-exceptions) | |
| 21:01 | If SQLITE_USE_SEH is defined, handle structured-exceptions thrown by MSVC builds if the *-shm file mapping is accessed after it becomes invalid for some reason. (check-in: 5c5fa470 user: dan tags: wal-shm-exceptions) | |
| 16:29 | Improved comments. Fewer opcodes for integrity_check on strict tables. (check-in: 4ee57fb5 user: drh tags: strict-tables) | |
| 02:58 | Enhance PRAGMA integrity_check so that it verifies the datatype of all columns in STRICT tables. (check-in: 97c9248b user: drh tags: strict-tables) | |
| 00:24 | STRICT tables require all fields of the PRIMARY KEY to be NOT NULL. (check-in: 5efdf9ac user: drh tags: strict-tables) | |
|
2021-08-18
| ||
| 23:00 | Merge the WITHOUT ROWID, NOT NULL ON CONFLICT bug fix into the strict-tables branch. (check-in: 7ee01ee4 user: drh tags: strict-tables) | |
| 22:26 | Fix ON CONFLICT clause processing for NOT NULL constraints of PRIMARY KEY columns on WITHOUT ROWID tables. Ticket [f2be158c57aaa8c6] (check-in: 13abba09 user: drh tags: trunk) | |
| 19:22 | Trying to insert an incorrect datatype into a STRICT table raises an SQLITE_CONSTRAINT_DATATYPE error. Seems to work, though lots more testing is needed. (check-in: a19305e5 user: drh tags: strict-tables) | |
| 13:13 | What would it be like if you could add the keyword "STRICT" after a CREATE TABLE statement to cause the table to (1) allow only a few well-defined datatypes, (2) rigidly enforce those types, (3) require NOT NULL on PK columns, (4) always enforce foreign key constraint, and so forth? This branch seeks to explore that question. (check-in: 78732b9f user: drh tags: strict-tables) | |
| 12:05 | Rename the Column.eType field to Column.eCType - with an extra "C". (check-in: b9b0dcd5 user: drh tags: trunk) | |
|
2021-08-17
| ||
| 19:59 | Fix an off-by-one error in the error-handling logic of the Lemon parser-generator. This does not affect SQLite. Forum cff80737bf. (check-in: 7cca8080 user: drh tags: trunk) | |
|
2021-08-12
| ||
| 14:22 | By default, do not use memory mapping to access the temporary files used for external sorts. The old behaviour (to use memory mapping by default) may be restored by building with SQLITE_ENABLE_SORTER_MMAP defined. (check-in: 306694df user: dan tags: trunk) | |
|
2021-08-11
| ||
| 18:56 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (Leaf check-in: 56869f54 user: dan tags: rbu-replace-hack) | |
| 18:44 | If the special "sqlite_rbu_replace_hack" table is present in an RBU database, use REPLACE instead of INSERT when writing index entries to imposter tables. (check-in: 4b73e151 user: dan tags: rbu-replace-hack) | |
| 18:43 | During DELETE, if an index entry is missing, do not raise the SQLITE_CORRUPT_INDEX error (added by [f339f31f9e9a856b]) if in "PRAGMA writable_schema=ON" mode. (check-in: 19e56291 user: drh tags: trunk) | |
| 13:48 | Do not apply the push-down optimization to CTE subqueries that will be reused in other contexts in where the same optimization is unlikely to be valid. Fix for the bug reported by forum post d496c3d29bc93736. (check-in: a7ce29a6 user: drh tags: trunk) | |
| 13:19 | Improved comment on the OP_OpenDup used to get a new cursor for a reused materialized CTE. (check-in: b1926cc0 user: drh tags: trunk) | |
|
2021-08-09
| ||
| 19:54 | Fix a compiler warning in pcache1. Reduce the maximum size of a pcache1 cache to 2147418112 pages. (check-in: 4bc93658 user: drh tags: trunk) | |
| 19:41 | Merge recent trunk enhancements into the begin-concurrent-report branch. (check-in: 25a768cb user: drh tags: begin-concurrent-report) | |
| 19:33 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: 514b3cef user: drh tags: begin-concurrent-pnu) | |
| 19:15 | Sync to trunk (check-in: dd356ace user: larrybr tags: cli_extension) | |
| 18:35 | Merge recent trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 47a9b759 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:26 | Merge recent trunk enhancements into the wal2 branch. (check-in: 84dac820 user: drh tags: wal2) | |
| 18:21 | Merge recent trunk enhancemenets into the begin-concurrent branch. (check-in: b88b6328 user: drh tags: begin-concurrent) | |
| 18:17 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: c8d1f17f user: drh tags: reuse-schema) | |
| 18:13 | Further improvements to the eOpenState bit values. (check-in: d44f74f1 user: mistachkin tags: trunk) | |
| 18:07 | Ensure that the pcache1 cache size does not get so big that it overflows the integer that is keeping track of the cache size. (check-in: bf9d70fc user: drh tags: trunk) | |
| 17:45 | Fix harmless compiler warnings and improve the presentation for the new --threadsafe option to the CLI. (check-in: 7929dc2f user: drh tags: trunk) | |
| 17:37 | Undocumented "--threadsafe N" option added to the CLI for testing purposes. One of SQLITE_CONFIG_SINGLETHREAD, _MULTITHREAD, or _SERIALIZED is called depending on the value of the N integer. (check-in: 2d8f297c user: drh tags: trunk) | |
| 17:36 | Improved Hamming bit-distance between the SQLITE_STATE constants. (check-in: 5100b045 user: drh tags: trunk) | |
| 13:06 | Fix comments associated with sqlite3.eOpenState. No logic changes. (check-in: fd8f498f user: drh tags: trunk) | |
| 11:03 | Merge latest trunk changes into this branch. (check-in: 67ed7422 user: dan tags: wal2) | |
|
2021-08-07
| ||
| 23:16 | Refactor sqlite3.magic into sqlite3.eOpenState. (check-in: e5d6512a user: drh tags: trunk) | |
|
2021-08-06
| ||
| 20:17 | Fix an RBU problem with restarting an update after the *-oal file is already larger than 4GiB. (check-in: 087b8b41 user: dan tags: trunk) | |
| 19:38 | Attempt to fix the showwal.c utility program so that it works on WAL files larger than 4GiB. (check-in: 5c0f9ea9 user: drh tags: trunk) | |
| 15:26 | Fix harmless compiler warnings. Omit redundant copies of os_common.h and hwtime.h from the amalgamation. (check-in: 09142700 user: drh tags: trunk) | |
|
2021-08-05
| ||
| 15:27 | Store the collating sequence name for each column of a table as an extension to the column name, for an additional savings in the heap space needed to hold the schema. (check-in: 832ac4c1 user: drh tags: trunk) | |
|
2021-08-04
| ||
| 14:50 | Add NEVER() macros on recently introduced unreachable branches. (check-in: 806939eb user: drh tags: trunk) | |
| 13:42 | Always prefer built-in SQL functions over app-defined SQL functions within sqlite3NestedParse(). Formerly this was the case for a few calls to sqlite3NestedParse(), but not for all of them. (check-in: 164662ef user: drh tags: trunk) | |