Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
69 check-ins for the month beginning 2021-08-01
Following month ↑|
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: c7b34930e2 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: 46e28cbcf6 user: dan tags: trunk) | |
|
2021-08-27
| ||
| 11:26 | Patch lemon to fix "error" token handling, according ot forum post e680f42f53090061. (check-in: 106b5e5355 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: 0c6ab539cf user: dan tags: wal-shm-exceptions) | |
| 18:31 | Add the --safe to the CLI. Also the --nonce option and the .nonce command. (check-in: c76870cb1a 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: c7f0813cab user: drh tags: trunk) | |
|
2021-08-23
| ||
| 15:56 | Fix a typo in a comment. No changes to code. (check-in: d953646a63 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: d8fd1a2bfd 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: 1e2dcc2d4e 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: 600f1991e5 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: e480146f49 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: 18cc2f8574 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: 9e9d5b566d user: drh tags: wal-shm-exceptions) | |
| 17:23 | Add missing SEH_INJECT_FAULT macros. (check-in: 27e9bdb3a9 user: dan tags: wal-shm-exceptions) | |
| 16:19 | Add some assert() statements and fix small issues with code on this branch. (check-in: bd9b373b17 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: f9c1d3441b 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: 5a98820c3d user: dan tags: wal-shm-exceptions) | |
| 08:05 | Improved error messages for the SQLITE_CONSTRAINT_DATATYPE error. (Closed-Leaf check-in: 39abca0147 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: 1ed1b594d3 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: 840e0a14eb 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: 5c5fa47076 user: dan tags: wal-shm-exceptions) | |
| 16:29 | Improved comments. Fewer opcodes for integrity_check on strict tables. (check-in: 4ee57fb588 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: 97c9248b3b user: drh tags: strict-tables) | |
| 00:24 | STRICT tables require all fields of the PRIMARY KEY to be NOT NULL. (check-in: 5efdf9acad 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: 7ee01ee47d 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: 13abba0941 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: a19305e5cf 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: 78732b9f98 user: drh tags: strict-tables) | |
| 12:05 | Rename the Column.eType field to Column.eCType - with an extra "C". (check-in: b9b0dcd5af 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: 7cca80808c 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: 306694dfb4 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: 56869f54f3 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: 4b73e151cd 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: 19e56291a7 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: a7ce29a6ef 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: b1926cc0ab 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: 4bc93658aa user: drh tags: trunk) | |
| 19:41 | Merge recent trunk enhancements into the begin-concurrent-report branch. (check-in: 25a768cb8a user: drh tags: begin-concurrent-report) | |
| 19:33 | Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: 514b3cef6b user: drh tags: begin-concurrent-pnu) | |
| 19:15 | Sync to trunk (check-in: dd356ace4f user: larrybr tags: cli_extension) | |
| 18:35 | Merge recent trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 47a9b75981 user: drh tags: begin-concurrent-pnu-wal2) | |
| 18:26 | Merge recent trunk enhancements into the wal2 branch. (check-in: 84dac820a0 user: drh tags: wal2) | |
| 18:21 | Merge recent trunk enhancemenets into the begin-concurrent branch. (check-in: b88b632830 user: drh tags: begin-concurrent) | |
| 18:17 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: c8d1f17fde user: drh tags: reuse-schema) | |
| 18:13 | Further improvements to the eOpenState bit values. (check-in: d44f74f14a 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: bf9d70fc2f user: drh tags: trunk) | |
| 17:45 | Fix harmless compiler warnings and improve the presentation for the new --threadsafe option to the CLI. (check-in: 7929dc2f6f 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: 2d8f297c11 user: drh tags: trunk) | |
| 17:36 | Improved Hamming bit-distance between the SQLITE_STATE constants. (check-in: 5100b0456b user: drh tags: trunk) | |
| 13:06 | Fix comments associated with sqlite3.eOpenState. No logic changes. (check-in: fd8f498f5d user: drh tags: trunk) | |
| 11:03 | Merge latest trunk changes into this branch. (check-in: 67ed7422f8 user: dan tags: wal2) | |
|
2021-08-07
| ||
| 23:16 | Refactor sqlite3.magic into sqlite3.eOpenState. (check-in: e5d6512aa1 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: 087b8b41c6 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: 5c0f9ea98a 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: 0914270078 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: 832ac4c1ee user: drh tags: trunk) | |
|
2021-08-04
| ||
| 14:50 | Add NEVER() macros on recently introduced unreachable branches. (check-in: 806939eb59 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: 164662ef01 user: drh tags: trunk) | |
| 11:29 | Avoid using LIKE with the target db in RBU. It is possible the user may issue "PRAGMA case_sensitive_like = 1" or override the like() user function, causing RBU to malfunction. (check-in: 7cbd8cd5aa user: dan tags: trunk) | |
|
2021-08-03
| ||
| 23:23 | Fix the build for SQLITE_ENABLE_UPDATE_DELETE_LIMIT. (check-in: 5150d2da06 user: drh tags: trunk) | |
| 18:45 | Improved harmony with the reuse-schema branch. (check-in: cbc703f70d user: drh tags: trunk) | |
| 17:05 | Merge recent trunk enhancements into the begin-concurrent-report branch. (check-in: 385e3b4e9d user: drh tags: begin-concurrent-report) | |
| 16:49 | Merge recent trunk changes into the begin-concurrent-pnu branch. (check-in: 2c25f25b22 user: drh tags: begin-concurrent-pnu) | |
| 16:44 | Merge recent trunk changes into the begin-concurrent-pnu-wal2 branch. (check-in: 5b6f6514bd user: drh tags: begin-concurrent-pnu-wal2) | |
| 16:31 | Merge recent trunk enhancements into the begin-concurrent branch. (check-in: 8d806cf93c user: drh tags: begin-concurrent) | |
| 16:11 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: d71adc3fd8 user: drh tags: reuse-schema) | |
|
2021-08-02
| ||
| 20:29 | Merge recent trunk enhancements into the wal2 branch. (check-in: f615d7baa8 user: drh tags: wal2) | |
| 18:03 | Refactor field names in the Column object, zCnName and zCnColl, to make them unique and thus easier to find amid all the other code. (check-in: 8b781dcaf6 user: drh tags: trunk) | |
| 16:41 | Refactor the Table object to reduce its memory footprint. (check-in: bbb6759bcf user: drh tags: trunk) | |