Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
88 events for the month beginning 2021-11-01 by user drh
Following month ↑|
2021-11-30
| ||
| 14:07 | In the automatic index generator logic, be more precise about when a partial automatic index is allowed in order to capture more cases where it is legal to use a partial automatic index. (check-in: 664b461b user: drh tags: trunk) | |
|
2021-11-29
| ||
| 18:09 | Merge in the proposed date/time function enhancements: (1) Add the unixepoch() function, (2) the 'auto' modifier and (3) the 'julianday' modifier. (check-in: 19c51b46 user: drh tags: trunk) | |
| 17:55 | Bump the version number up to 3.38.0 in order to begin the next development cycle. (check-in: 8ad1fcaa user: drh tags: trunk) | |
| 17:23 | Add the unixepoch() function and the 'auto' and 'julianday' modifiers. (Closed-Leaf check-in: 559fdc0a user: drh tags: unixepoch) | |
|
2021-11-28
| ||
| 19:54 | Following a prior error, an ALWAYS() in sqlite3ExprCanBeNull() might be false. dbsqlfuzz 5dbec6678a20e7595a34dfdd869a3b9722b3ca43. (check-in: 4e207401 user: drh tags: trunk) | |
|
2021-11-27
| ||
| 15:12 | Merge version 3.37.0 into the reuse-schema branch. (check-in: f83d50d5 user: drh tags: reuse-schema) | |
| 15:11 | Merge version 3.37.0 into the begin-concurrent-pnu-wal2 branch. (check-in: 2171996a user: drh tags: begin-concurrent-pnu-wal2) | |
| 15:00 | Merge version 3.37.0 into the wal2 branch. (check-in: 3425af62 user: drh tags: wal2) | |
| 14:56 | Merge version 3.37.0 into the begin-concurrent-report branch. (check-in: 126d7a1d user: drh tags: begin-concurrent-report) | |
| 14:48 | Merge version 3.37.0 into the begin-concurrent-pnu branch. (Closed-Leaf check-in: 910001f2 user: drh tags: begin-concurrent-pnu) | |
| 14:45 | Merge version 3.37.0 into the begin-concurrent branch. (check-in: c5f2ad19 user: drh tags: begin-concurrent) | |
| 14:13 | Version 3.37.0 (check-in: bd41822c user: drh tags: trunk, release, major-release, version-3.37.0) | |
| 12:03 | Fix a harmless comment typo. (check-in: 7c567338 user: drh tags: trunk) | |
|
2021-11-26
| ||
| 20:26 | Add platform "Darwin-arm64" to test/releasetest_data.tcl. (check-in: 1d5c9aac user: drh tags: trunk) | |
| 17:10 | Improved defenses against integer overflow when computing the size of a memory allocations. No bugs were fixed here. But perhaps future bugs will be prevented. (check-in: eb878c01 user: drh tags: trunk) | |
| 15:08 | Fixes to internal comments. No changes to code or documentation. (check-in: 1489b196 user: drh tags: trunk) | |
|
2021-11-23
| ||
| 22:28 | Changes a test pattern for RBU so that it works regardless of whether newer TCL versions are used. (check-in: 5a9921c9 user: drh tags: trunk) | |
| 12:59 | Fix a compiler warning in the dbserialize method of the TCL interface. (check-in: ba71d030 user: drh tags: trunk) | |
|
2021-11-22
| ||
| 17:08 | Merge trunk enhancements into the begin-concurrent-report-wal2 branch. (check-in: 9b2ffa84 user: drh tags: begin-concurrent-report-wal2) | |
| 17:01 | Merge trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 8a9fad0f user: drh tags: begin-concurrent-pnu-wal2) | |
| 16:47 | Merge trunk enhancements into the wal2 branch. (check-in: 135133b7 user: drh tags: wal2) | |
| 16:39 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (check-in: ddc11f55 user: drh tags: begin-concurrent-report) | |
| 16:27 | Merge the latest trunk enhancements into the begin-concurrent-pnu branch. (check-in: aa045e7b user: drh tags: begin-concurrent-pnu) | |
| 16:14 | Merge the latest trunk changes into the begin-concurrent branch. (check-in: 8f3e6842 user: drh tags: begin-concurrent) | |
| 16:06 | There are two possible error messages from stat-9.1, depending on compile-time options. Adjust the test case to accept either one. (check-in: 0f567b61 user: drh tags: trunk) | |
| 16:05 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: d08832cb user: drh tags: reuse-schema) | |
| 13:59 | In fuzzcheck, improve the defense against long delays due to rogue busy_timeout macros in fuzzer-generated scripts. (check-in: 3024d7ca user: drh tags: trunk) | |
| 13:35 | Fix the build for SQLITE_OMIT_CTE. (check-in: d7ef96ba user: drh tags: trunk) | |
| 12:59 | In the previous check-in, do not overwrite the SQLITE_CORRUPT signal with an SQLITE_OK before exiting fts3auxNextMethod(). (check-in: 396688ae user: drh tags: trunk) | |
|
2021-11-20
| ||
| 13:30 | New test cases for STRICT and NOT NULL in PRIMARY KEY. (check-in: 0eafbc2f user: drh tags: trunk) | |
|
2021-11-19
| ||
| 19:11 | Small performance increase and size reduction for sqlite3ExprCompare(). This change also handles some corner cases without the need for ALWAYS(). (check-in: d814ba6e user: drh tags: trunk) | |
|
2021-11-18
| ||
| 20:56 | Minor tweaks to the way auxiliary tools are built, to make it easier to customize the builds without having to alter the code. (check-in: 90b06b6f user: drh tags: trunk) | |
| 15:40 | Improve CSV quoting in the CLI using the strstr() function. (check-in: b7927bf9 user: drh tags: trunk) | |
| 13:25 | Fix an obscure problem associated with quoting of CSV output in the CLI. (check-in: 38a9b660 user: drh tags: trunk) | |
|
2021-11-15
| ||
| 19:10 | Strengthen the sticky-CORRUPT idea of check-in [3feb0f1c3840904d] by automatically changing the first COMMIT after an SQLITE_CORRUPT error into a ROLLBACK. (check-in: bd66ab8a user: drh tags: trunk) | |
| 18:50 | Small performance optimization in sqlite3VdbeHalt(). (check-in: 9e1ecf43 user: drh tags: trunk) | |
| 13:22 | Improved context shown for the "ABORT-due-to-error" output line when using "PRAGMA vdbe_debug=on" in an SQLITE_DEBUG build. (check-in: c7776369 user: drh tags: trunk) | |
| 01:45 | Fix a faulty JSON assert() added 30 days ago by check-in [7b8ea2298927fd34]. dbsqlfuzz f30366e7b02562398a387ddcc681422fd4251190. (check-in: 0e0c23fc user: drh tags: trunk) | |
|
2021-11-12
| ||
| 14:39 | Improved handling of OOM while reallocating a column name to add type information. dbsqlfuzz 5a195b4233649e49e0aa34f1b743ca192d85b198 (check-in: 5995dd4d user: drh tags: trunk) | |
|
2021-11-11
| ||
| 23:52 | Make sure the rowid value returned by the VUpdate opcode is always initialized. (check-in: 150b5be5 user: drh tags: trunk) | |
| 16:26 | Remove a NEVER() that was add yesterday. The fuzzer found a new test case to make it happen. (check-in: 83e6ac71 user: drh tags: trunk) | |
| 11:23 | New assert() statements to help prove correct usage of VdbeCursor objects. (check-in: 7cee62f7 user: drh tags: trunk) | |
|
2021-11-10
| ||
| 15:23 | Load new test cases into test/fuzzdata8.db (check-in: 8b53ffe9 user: drh tags: trunk) | |
| 10:59 | Make SQLITE_CORRUPT sticky: If a CORRUPT error is returned, all subsequent write statements within the same transaction also fail early with SQLITE_CORRUPT. (check-in: 3feb0f1c user: drh tags: trunk) | |
|
2021-11-09
| ||
| 15:36 | Merge all recent trunk changes into the begin-concurrent-report branch. (check-in: 122f4a76 user: drh tags: begin-concurrent-report) | |
| 15:26 | Merge all recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: b9802d0b user: drh tags: begin-concurrent-pnu) | |
| 15:18 | Merge all recent trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 07bc1339 user: drh tags: begin-concurrent-pnu-wal2) | |
| 15:06 | Merge all recent trunk enhancements into the begin-concurrent branch. (check-in: 2d0c8f30 user: drh tags: begin-concurrent) | |
| 14:52 | Merge the walIndexPage() enhancement from trunk into the begin-concurrent branch. (check-in: ff223839 user: drh tags: begin-concurrent) | |
| 14:36 | Merge all trunk enhancements prior to the walIndexPage() fix into the begin-concurrent branch. (check-in: 6603f005 user: drh tags: begin-concurrent) | |
| 14:00 | Merge recent trunk enhancements into the reuse-schema branch. (check-in: 748bce4c user: drh tags: reuse-schema) | |
| 13:52 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 0894f595 user: drh tags: wal2) | |
| 13:31 | Change test case error message text to match the current implementation. (check-in: de10795a user: drh tags: trunk) | |
| 10:19 | • Edit [6f4369666efb8eed|6f436966]: Mark "Closed". (artifact: 5e217ef9 user: drh) | |
| 01:48 | Fix lempar.c so that Lemon can compile with NDEBUG defined. Forum post f331adca0b (check-in: ba4fb518 user: drh tags: trunk) | |
|
2021-11-08
| ||
| 23:24 | Refactor the code that figures out which SELECT in a cascade of nested queries a particular aggregate function belongs to. This fixes the problem reported by forum post c7cc2aa3546e39c1. New test cases in dbsqlfuzz and th3. (check-in: 74aec5dd user: drh tags: trunk) | |
| 16:38 | Add assert()s that verify that cursor numbers on subqueries are always greater than outer cursor numbers. Except, this is not always true in the presence of query flattening. We might need to relax that constraint. This branch will probably become a dead-end. For now it is saved for reference. (Closed-Leaf check-in: 6f436966 user: drh tags: well-ordered-cursors) | |
|
2021-11-07
| ||
| 23:33 | Ensure that the window function rewrite does not leave the parse tree in an invalid state that might cause problems downstream before the error is recognized and unwinds the stack. Also take steps such that an invalid parse tree does not cause problems even if it goes unrecognized. Forum post 398e9d5aa9. (check-in: 0f9fc6b6 user: drh tags: trunk) | |
|
2021-11-06
| ||
| 20:25 | Add ALWAYS() to a branch made unreachable by the previous check-in. (check-in: 0dc963f6 user: drh tags: trunk) | |
| 11:58 | Add the rbu_exclusive_checkpoint query parameter to RBU. (Leaf check-in: c15806a4 user: drh tags: reuse-schema-3.36) | |
| 10:59 | Avoid accessing the sqlite3_module.xShadowName field if (sqlite3_module.iVersion<3). (check-in: a024764c user: drh tags: trunk) | |
| 10:51 | • Edit [ca09148e13d33a74|ca09148e]: Move to branch reuse-schema. (artifact: 59a23ff6 user: drh) | |
|
2021-11-05
| ||
| 23:32 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: ca09148e user: drh tags: reuse-schema) | |
| 22:35 | Add the rbu_exclusive_checkpoint query parameter to RBU. (check-in: c2d33ea9 user: drh tags: trunk) | |
| 22:23 | New test cases for rbu_exclusive_checkpoint query parameter. (Closed-Leaf check-in: 00285ff1 user: drh tags: rbu_exclusive_checkpoint) | |
| 19:52 | Update an assert() statement to conform to the changes of the previous check-in. (check-in: b5c668ca user: drh tags: trunk) | |
| 19:36 | Add the SQLITE_OPEN_EXRESCODE flag for sqlite3_open_v2(). (check-in: ff9373f4 user: drh tags: trunk) | |
| 12:34 | Use the FTS_CORRUPT_VTAB macro rather than a direct call to sqlite3Fts3Corrupt() in [2fad2a89527757b3] so that the build works in all cases. (check-in: 029c59cd user: drh tags: trunk) | |
| 12:10 | • Edit [f474ac370accc5c7|f474ac37]: Edit check-in comment. (artifact: 274fba79 user: drh) | |
| 11:52 | Remove an incorrect NEVER() reported at forum post 5bbabfb7ce. Also use this opportunity to improve the isSimpleCount() function with better formatting, an expanded header comment, and some extra assert() and textcase() macros. (check-in: 2927185b user: drh tags: trunk) | |
|
2021-11-04
| ||
| 15:17 | Fix typo in the sqlite3ext.h file. forum post 63802db4ce (check-in: d4a48ee0 user: drh tags: trunk) | |
| 14:04 | Show the preferred schema table names in the output of "PRAGMA table_list". (check-in: 9147390d user: drh tags: trunk) | |
| 11:34 | Change a branch made unreachable by the previous check-in into an assert(). (check-in: 685a987c user: drh tags: trunk) | |
| 00:51 | First the shadow table mechanism so that it works even if the shadow table comes before the virtual table in the sqlite_schema table, as can happen after a VACUUM. (check-in: 005a8642 user: drh tags: trunk) | |
|
2021-11-03
| ||
| 16:35 | Remove two incorrect assert() statements added by a check-in from earlier today. (check-in: 3206edff user: drh tags: trunk) | |
| 15:59 | Improved the error message that results when a schema parse fails after ALTER TABLE ADD COLUMN. (check-in: b007a39d user: drh tags: trunk) | |
| 14:02 | Fix INSERT into STRICT table with STATIC generated columns. (check-in: 24285d91 user: drh tags: trunk) | |
| 12:50 | Add the --strict option to speedtest1.c (check-in: a247b5d8 user: drh tags: trunk) | |
| 11:43 | Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table. (check-in: 5dff1f66 user: drh tags: trunk) | |
|
2021-11-02
| ||
| 22:26 | • Fixed ticket [5981a8c0]: Incorrect answer on a SeekScan query plus 6 other changes (artifact: fba198c9 user: drh) | |
| 22:24 | Correctly handle SeekScan on an IN operator of the middle term of an index when the right-most term is a range constraint. Fix for ticket [5981a8c041a3c2f3]. (check-in: aa24660e user: drh tags: trunk) | |
| 20:52 | Proposed fix for a problem associated with OP_SeekScan that results in an incorrect answer. See ticket [5981a8c041a3c2f3]. (Closed-Leaf check-in: 266e9cba user: drh tags: seekscan-fix-20211102) | |
| 20:38 | • New ticket [5981a8c0] Incorrect answer on a SeekScan query. (artifact: 2d2d6923 user: drh) | |
| 17:55 | Ensure that ALTER TABLE RENAME recognizes OOM errors while parsing dependent triggers and handles them appropriately. dbsqlfuzz 53e245eee15d3f19639d773048aa955c30708785. (check-in: 1d9004cd user: drh tags: trunk) | |
| 11:24 | Add the --remove and --glob options to the .archive command in the CLI. (check-in: ea7b12cd user: drh tags: trunk) | |
| 10:54 | Fix a minor typo in a comment. (Closed-Leaf check-in: 06a5bf43 user: drh tags: archive_remove) | |
| 10:47 | Add recent dbsqlfuzz cases to test/fuzzdata8.db. (check-in: 8c3f2536 user: drh tags: trunk) | |
|
2021-11-01
| ||
| 12:53 | The VVA() macro in json1.c must be active during SQLITE_COVERAGE_TEST because it affects the outcome of testcase() macros. (check-in: 92c3d253 user: drh tags: trunk) | |