Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
88 events for the month beginning 2020-09-01
Following month ↑|
2020-09-30
| ||
| 20:35 | Add experimental unicode-aware trigram tokenizer to fts5. And support for LIKE and GLOB optimizations for fts5 tables that use said tokenizer. (check-in: 0d7810c1 user: dan tags: fts5-trigram) | |
| 18:22 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: f07ac3fb user: drh tags: branch-3.28) | |
| 18:06 | Improved query optimization for multi-column indexes where the second or later columns are constrained by an IN operator and the earlier index columns limit the search to a small number of rows. Use the new OP_SeekScan opcode which does scanning of the relevant range of the index but gives up and falls back to doing a seek if the number of rows scanned grows to large, in order to guard against pathological cases where the estimated number of rows to be scanned is far too small. (check-in: 4a43430f user: drh tags: trunk) | |
| 18:03 | For the OP_SeekScan opcode, adjust the number of steps run before giving up based on the estimated number of comparisons needed to perform a seek. (Closed-Leaf check-in: dc4172e6 user: drh tags: in-scan-vs-index) | |
| 17:33 | • Fixed ticket [5c4e7aa7]: Incorrect result for comparison with NULL plus 6 other changes (artifact: 1091db2a user: drh) | |
| 17:32 | Back out the incorrect optimization of check-in [e51ecadcbdef5ce6] as ticket [5c4e7aa793943803] reports a case where the optimization does not work. (check-in: 7395e96b user: drh tags: trunk) | |
| 17:18 | • New ticket [5c4e7aa7] Incorrect result for comparison with NULL. (artifact: c71d1ae4 user: mrigger) | |
| 15:46 | • Fixed ticket [66e4b0e2]: Incorrect result for LEFT JOIN plus 7 other changes (artifact: 000faea0 user: drh) | |
| 15:36 | In the query flattener when substituting expression Y in place of expression X, if X is marked has having come from an ON or USING clause of a LEFT JOIN, then be sure that all subexpressions of Y, not just the root node of Y, are similarly marked. Otherwise, if Y is an AND operator, it will be split up during WHERE clause analysis and the subexpressions will not get the special treatment needed by LEFT JOIN ON/USING clauses. Fix for ticket [66e4b0e271c47145]. (check-in: 69f9eb73 user: drh tags: trunk) | |
| 12:47 | • New ticket [66e4b0e2] Incorrect result for LEFT JOIN. (artifact: 2d62d647 user: mrigger) | |
| 09:17 | Better understanding of savepoint code (check-in: ce6d8d62 user: shearer tags: trunk) | |
| 00:48 | Add an sqlite3FaultSim() call to btreeNext() to make it easier to simulate I/O errors in calls to sqlite3BtreeNext(), and in OP_SeekScan. (check-in: 29cca775 user: drh tags: in-scan-vs-index) | |
| 00:10 | In the OP_SeekScan opcode, changes to pOp must occur after the call to VdbeBranchTaken() so that the VdbeBranchTaken() attributes the branch to the correct opcode. (check-in: 61fbe7aa user: drh tags: in-scan-vs-index) | |
|
2020-09-29
| ||
| 23:52 | The OP_SeekScan opcode is a no-op if the cursor is not pointing to a valid row upon entry. (check-in: 4afc96b5 user: drh tags: in-scan-vs-index) | |
| 20:22 | Coverage testing of the OP_SeekScan opcode. Fix a problem that comes up when OP_SeekScan reaches the end of the table. (check-in: 9e57e758 user: drh tags: in-scan-vs-index) | |
| 17:29 | Improved comments on the new OP_SeekScan opcode. (check-in: 6110fdd5 user: drh tags: in-scan-vs-index) | |
| 16:05 | Improved performance by manually in-lining the sqlite3VdbeIdxKeyCompare() routine for the OP_IdxGT opcode and its kin. (check-in: 2206a2c8 user: drh tags: in-scan-vs-index) | |
| 15:32 | Typo fix to repair the early-out optimization. Also avoid unnecessary OP_SeekHit opcodes. (check-in: 8fd7d8df user: drh tags: in-scan-vs-index) | |
| 11:52 | • Ticket [c51489c3] Incorrect result from WITH RECURSIVE using DISTINCT status still Fixed with 3 other changes (artifact: 465c6275 user: drh) | |
| 01:48 | The OP_SeekScan opcode works, but using it requires disabling the IN-earlyout optimization because the OP_IfNoHope opcode might move the cursor. (check-in: f3c36b84 user: drh tags: in-scan-vs-index) | |
|
2020-09-28
| ||
| 19:51 | Revisiting the IN-scan optimization to try to fix it for the corner case where the statistics deceive the query planner into using a scan when an indexed lookup would be better. This check-in changes the code generation to do the IN-scan using a new OP_SeekScan opcode. That new opcode is designed to abandon the scan and fall back to a seek if it doesn't find a match quickly enough. For this work-in-progress check-in, OP_SeekScan is still a no-op and OP_SeekGE still ends up doing all the work. (check-in: d720b698 user: drh tags: in-scan-vs-index) | |
| 15:49 | Small performance improvement and size reduction by reducing the size of the WhereTerm object. (check-in: 43f7ddad user: drh tags: trunk) | |
| 13:34 | Avoid the possibility of integer overflow on the --pagecache option to the CLI. See forum post 10a2892377 (check-in: d3d13df3 user: drh tags: trunk) | |
|
2020-09-26
| ||
| 01:47 | • Added wiki page "checkin/2cbbabdf5ef624d809fbb40d2d312a29e0b5f02756fc0dbf6985fc8b0c8d1ade" (artifact: ac4b684e user: drh) | |
|
2020-09-25
| ||
| 17:17 | Clarify (check-in: 14dba0f3 user: shearer tags: btree-code-documentation) | |
| 16:54 | Distinguish between checkpoints (WAL-only, implementation specific) and savepoints (Btree internal implementation of COMMIT/ROLLBACK subtransactions) and SQL SAVEPOINT (identical name for SQL-level subtransactions) (check-in: ae686ab6 user: shearer tags: btree-code-documentation) | |
| 14:36 | • Edit [3a576608e6f26ae8|3a576608]: Edit check-in comment. (artifact: 40be378d user: drh) | |
| 14:26 | Reset to trunk's func. Still learning Fossil. (check-in: a4840cf5 user: shearer tags: btree-code-documentation) | |
| 13:56 | More classification of functions. Fix incorrect comment that sqlite3BtreeCursorHasHint() is only used within asserts. (check-in: 78d8db7c user: shearer tags: btree-code-documentation) | |
| 09:42 | Merge recent trunk changes into the btree-code-documentation branch (check-in: 3a576608 user: shearer tags: btree-code-documentation) | |
| 08:17 | Add reminder comment that, by definition, these functions won't be called from elsewhere in SQLite. Useful to remember for beginners who may suspect unusued code. (check-in: 6f5c1fde user: shearer tags: btree-code-documentation) | |
|
2020-09-24
| ||
| 11:41 | Added context to explain that the test coverage is about MC/DC in general, not just an SQLite-specifc test harness. (check-in: 770dbedd user: shearer tags: btree-code-documentation) | |
| 06:37 | Group metadata definitions together (check-in: 5c306f42 user: shearer tags: btree-code-documentation) | |
|
2020-09-23
| ||
| 17:31 | Figured out where/how sqlite3BtreeRowCountEst() is called (check-in: a4653715 user: shearer tags: btree-code-documentation) | |
|
2020-09-21
| ||
| 20:18 | Fix harmless compiler warning seen with MSVC. (check-in: 4591ee03 user: mistachkin tags: trunk) | |
| 14:53 | In fts5 integrity checks, do not compare the contents of the index against an external content table unless specifically requested. (check-in: 78216369 user: dan tags: trunk) | |
|
2020-09-20
| ||
| 13:33 | Remove a new assert() that the compiler finds is always true at compile-time, to avoid a compiler warning. (check-in: 8bbaee23 user: drh tags: trunk) | |
| 12:10 | Attempt to silence harmless static analyzer warnings in Lemon and in the Lemon-generated parser. (check-in: de8ce22a user: drh tags: trunk) | |
|
2020-09-17
| ||
| 21:11 | Fix a typo in the documentation comment for sqlite3_preupdate_hook(). (check-in: 4542d194 user: dan tags: trunk) | |
| 17:01 | Fix a problem in sqlite-expert causing it to ignore equality constraints on the second or subsequent columns of a multi-column PRIMARY KEY. (check-in: c666c85a user: dan tags: trunk) | |
| 15:16 | Fix a problem in fts5 causing the in-memory hash table to be flushed more often than necessary. (check-in: 9a55601d user: dan tags: trunk) | |
| 15:04 | Order btree.h by logical function, add comments (check-in: ab53b317 user: shearer tags: btree-code-documentation) | |
| 14:16 | Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: 66f94d62 user: dan tags: trunk) | |
| 11:56 | Earlier detection of corruption in the rtreecheck() SQL function to prevent a (harmless) read of an uninitialized value. (check-in: e2074b24 user: drh tags: trunk) | |
| 11:32 | Prevent use-after-free of the u.vtab.idxStr string following an OOM while generating the OP_VFilter opcode. (check-in: 751fe4ed user: drh tags: trunk) | |
| 00:47 | • Fixed ticket [c51489c3]: Incorrect result from WITH RECURSIVE using DEFAULT plus 5 other changes (artifact: bc9cfc49 user: drh) | |
| 00:46 | DISTINCT may not be ignored inside a UNION ALL common table expression. Fix for ticket [c51489c3b8f919c5] (check-in: 7d2b590d user: drh tags: trunk) | |
| 00:00 | • New ticket [c51489c3] Incorrect result from WITH RECURSIVE using DEFAULT. (artifact: bc476067 user: drh) | |
|
2020-09-16
| ||
| 19:48 | Fix a pair of assert()s in "PRAGMA foreign_key_check" that might have given a false-positive following an OOM. (check-in: 9ea3039b user: drh tags: trunk) | |
| 16:55 | Fix harmless compiler warnings in Lemon. (check-in: 6c94ba4b user: drh tags: trunk) | |
| 16:55 | Merge bugfixes made since version 3.33.0 into this branch. (Leaf check-in: 2e269dcd user: dan tags: reuse-schema-3.33) | |
| 16:49 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (Leaf check-in: 807643c5 user: dan tags: branch-3.33) | |
| 16:48 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f0055d0 user: dan tags: branch-3.33) | |
| 16:45 | Fix a tsan error that could occur when using shared-cache mode. (check-in: 61981b97 user: dan tags: branch-3.33) | |
| 16:44 | Fix another (harmless in practice) tsan error in shared-cache mode. (check-in: 553e20c3 user: dan tags: branch-3.33) | |
| 16:41 | Apply the same fix for ticket [9eda2697f5cc1aba] to text-to-integer conversions that was done for floating point conversions by check-in [1c76f1d8ec0937a2]. (check-in: 1b4801de user: dan tags: branch-3.33) | |
| 16:40 | Correctly handle expressions like "x IS (not) true/false" within the rhs of IN() expressions. Fix for [f3ff1472]. (check-in: 42361033 user: dan tags: branch-3.33) | |
| 16:39 | Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: 6438db45 user: dan tags: branch-3.33) | |
| 16:38 | Do not skip over TK_IF_NULL_ROW operators when bypassing TK_COLLATE operators. Fix to check-in [ac31edd3eeafcef4] which was itself a fix for ticket [45f4bf4eb4ffd788]. (check-in: 85041611 user: dan tags: branch-3.33) | |
|
2020-09-15
| ||
| 20:48 | Fix a buffer overread found by OSSFuzz that could occur if a WITHOUT ROWID table with many columns was NATURAL JOINed against itself. (check-in: 3d35fa0b user: dan tags: trunk) | |
| 12:29 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f5ed852 user: drh tags: trunk) | |
|
2020-09-11
| ||
| 15:01 | Catch fts5 index corruption caused by issuing 'delete' commands with incorrect data earlier in some cases. Also fix a couple of test script problems. (check-in: b79f19ed user: dan tags: trunk) | |
|
2020-09-10
| ||
| 15:09 | Try again to fix the typo in the sqlite3_txn_state() documentation. (check-in: 6d1ab040 user: drh tags: trunk) | |
| 14:56 | • Edit [430c5d1da57af452|430c5d1d]: Edit check-in comment. (artifact: 347265fd user: drh) | |
| 14:54 | Fix typo in the documentation for the new sqlite3_txn_state() interface. (check-in: 23f7d017 user: drh tags: trunk) | |
| 12:41 | If an amalgamation is created using SQLITE_ENABLE_UPDATE_DELETE_LIMIT, ensure that it can still be compiled without that option by setting the SQLITE_UDL_CAPABLE_PARSER flag in the preamble. (check-in: 5b905d7d user: drh tags: trunk) | |
|
2020-09-07
| ||
| 11:23 | Merge latest trunk changes into this branch. (check-in: ae1a778d user: dan tags: reuse-schema) | |
| 11:14 | Fix another (harmless in practice) tsan error in shared-cache mode. (check-in: 5a74fa3f user: dan tags: trunk) | |
|
2020-09-06
| ||
| 17:40 | Remove an artifical limitation on the length of columns in the "box" output mode of the command-line shell. (check-in: 783fa887 user: drh tags: trunk) | |
|
2020-09-05
| ||
| 06:21 | Fix a bug in Lemon that might cause it to crash if there is a multi-terminal token with a space following the "|" separator. This does not affect SQLite. (check-in: 430c5d1d user: drh tags: trunk) | |
|
2020-09-04
| ||
| 19:12 | Merge tsan error fix from trunk into this branch. (check-in: 93cc60b3 user: dan tags: reuse-schema) | |
| 19:10 | Fix a tsan error that could occur when using shared-cache mode. (check-in: de80bc87 user: dan tags: trunk) | |
| 17:40 | Update this branch with latest changes from trunk. (check-in: ca8deb44 user: dan tags: reuse-schema) | |
| 17:30 | Ensure that the busy-handler count is reset at the end of each sqlite3_file_control() and sqlite3_prepare() (and _v2() and _v3()). (check-in: 5dd05940 user: dan tags: trunk) | |
|
2020-09-02
| ||
| 16:14 | Add tests for virtual table shmlock. (Leaf check-in: 1c6a8442 user: dan tags: shmlock-vtab) | |
| 15:26 | Fix reporting on locks from external processes. Various other fixes. (check-in: 459de23e user: dan tags: shmlock-vtab) | |
|
2020-09-01
| ||
| 20:56 | Add file-controls and a vtab frontend for querying the unix VFS for the currently held shm-locks. Still some issues. (check-in: ef10e1b3 user: dan tags: shmlock-vtab) | |
| 19:02 | Fix harmless compiler warning. (check-in: a711e8cd user: mistachkin tags: trunk) | |
| 12:26 | In the Lemon output, add a prefix comment that explains that the output file is automatically generated and shows the name of the source file. (check-in: d34caf3b user: drh tags: trunk) | |
| 11:20 | Lemon updates: (1) include the #defines for all tokens in the generated C file, so that the C-file can be stand-alone. (2) If the grammar begins with a %include {...} directive on line one, make that directive the header for the generated C file. (3) Enhance the lemon.html documentation. (check-in: 84d54eb3 user: drh tags: trunk) | |
| 02:02 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 49b7631e user: drh tags: branch-3.28) | |
| 01:57 | • Edit [8301da31d08b7467|8301da31]: Mark "Closed". (artifact: 32bdac4a user: drh) | |
| 01:55 | • Edit [8301da31d08b7467|8301da31]: Move to branch branch-3.28-in-early-out-fail. Edit check-in comment. (artifact: a91e43c9 user: drh) | |
| 01:53 | • Edit [e9d983c6830efdfd|e9d983c6]: Move to branch in-early-out-fail. Edit check-in comment. (artifact: a39e1790 user: drh) | |
| 01:52 | • Edit [07222dce106d2225|07222dce]: Mark "Closed". (artifact: b7ee8ddb user: drh) | |
| 01:52 | Improvements to the IN-early-out optimization so that it works more efficiently when there are two or more indexed IN clauses on a single table. (check-in: 35505c68 user: drh tags: trunk) | |
| 00:26 | Fix a harmless compiler warning. (check-in: 3ca0b7d5 user: drh tags: trunk) | |
| 00:09 | Minor changes - fix a compiler warning and add an assert(). (Closed-Leaf check-in: 07222dce user: drh tags: in-early-out-fail) | |