Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
71 events for the month beginning 2020-10-01
Following month ↑|
2020-10-31
| ||
| 18:58 | Add the -tabs command-line option to the CLI. (check-in: 7d01e84d user: drh tags: trunk) | |
| 16:33 | Update the ALTER TABLE command to correctly handle UPDATE ... FROM statements within trigger programs. (check-in: 3e6af890 user: dan tags: trunk) | |
|
2020-10-27
| ||
| 11:58 | Prettify btree.h headings. Close branch. (Closed-Leaf check-in: ee9689ad user: shearer tags: btree-code-documentation) | |
| 11:23 | • Edit [eb6e5fc1891be52a|eb6e5fc1]: Add "open". (artifact: aa5f1a54 user: shearer) | |
| 11:22 | • Edit [eb6e5fc1891be52a|eb6e5fc1]: Mark "Closed". (artifact: b2c8ec1c user: shearer) | |
| 11:13 | Typo in btree.h (and unwanted merge; this branch for cherrypicking btree.h only) (check-in: eb6e5fc1 user: shearer tags: btree-code-documentation) | |
| 11:07 | Final commit in btree.h reorg. No more unknowns. (check-in: ea06f1d1 user: shearer tags: btree-code-documentation) | |
|
2020-10-26
| ||
| 18:14 | Always create a statement journal when using the OP_ParseSchema opcode, as you never know when it might fail. See the discussion on forum post daa2c728cc. (check-in: aa512f72 user: drh tags: trunk) | |
| 16:22 | Ensure that the table argument passed to Tcl_GetIndexFromObjStruct() in the sessions module test code is declared "static". (check-in: 80eba105 user: dan tags: trunk) | |
| 13:24 | Prevent fts5 tokenizer unicode61 from considering '\0' to be a token characters, even if other characters of class "Cc" are. See forum thread 09609d7e22 for details. (check-in: b7b7bde9 user: dan tags: trunk) | |
|
2020-10-22
| ||
| 18:59 | • Edit [263293f1e6db2603|263293f1]: Edit check-in comment. (artifact: 37c2e79b user: drh) | |
| 18:58 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 263293f1 user: drh tags: branch-3.28) | |
| 18:50 | Minor tweaks to query planning weights so that when STAT4 is enabled and functioning, a full table scan is more likely to be selected if that seems like the fastest solution. Only do this when STAT4 info is available because an error has a large potential downside. (check-in: 0e7e113d user: drh tags: trunk) | |
| 18:16 | Test case updates. (Closed-Leaf check-in: 27c681c9 user: drh tags: avoid-bad-indexes) | |
| 15:47 | Sometimes it makes sense to do a full table scan rather than try to use an index when most of the rows will be selected. This branch is trying to tune the query planner to make that happen more often. (check-in: 0f42099a user: drh tags: avoid-bad-indexes) | |
|
2020-10-20
| ||
| 14:40 | Fix the sqlite3_hard_heap_limit() so that it works with sqlite3_realloc64() in addition to sqlite3_malloc64(). Improvements to OOM processing and debugging aids in the fuzzcheck utility. (check-in: 602d7369 user: drh tags: trunk) | |
| 12:37 | Fix an assert() inside of debug-only code that can fail following an OOM. (check-in: 79da254f user: drh tags: trunk) | |
|
2020-10-19
| ||
| 20:49 | Fix an incorrect table ref-count in the new recursive CTE logic that might result in a reference to freed memory following a syntax error. (check-in: 75a02888 user: drh tags: trunk) | |
| 12:35 | Enhance recursive common table expressions to support two or more recursive terms. (check-in: 77e64647 user: drh tags: trunk) | |
| 01:44 | New test cases for recursive CTEs with multiple recursive terms. (Leaf check-in: cd5182bd user: drh tags: cte-enhancement) | |
| 01:23 | Allow multiple recursive terms in the compound SELECT of a recursive CTE. This facilitates writing a query to find find the connected components of an undirected graph. (check-in: 5481fa8c user: drh tags: cte-enhancement) | |
|
2020-10-18
| ||
| 18:35 | Fix harmless compiler warnings. (check-in: 7f8802bb user: mistachkin tags: trunk) | |
|
2020-10-17
| ||
| 22:13 | Fix the SQLITE_DESERIALIZE_FREEONCLOSE flag so that it works as it is documented to work. See forum post ba1dff667a (check-in: d6fac8a1 user: drh tags: trunk) | |
| 19:09 | Fix an incorrect printf() in debugging logic in where.c. Problem reported by forum post 80a9c47769772207. (check-in: 883da4da user: drh tags: trunk) | |
|
2020-10-15
| ||
| 17:59 | Minor fixes to the cksumvfs documentation in the header comment of the source file. Enhance speedtest1.c so that it can more easily do performance comparisons of cksumvfs. (check-in: ed3bb818 user: drh tags: trunk) | |
| 14:37 | The windows VFS accepts query parameter "exclusive=true" to cause it to take a mandatory file lock, preventing other applications from even reading the file. See forum thread 11b5560864189b5d. (check-in: 05b573fd user: drh tags: trunk) | |
|
2020-10-14
| ||
| 21:31 | Enhancements to TclKit batch tool for MSVC. (check-in: 2a8a4552 user: mistachkin tags: trunk) | |
| 21:30 | Fix typo in a documentation comment. (check-in: 462adc7d user: mistachkin tags: trunk) | |
| 15:46 | Enhanced documentation for sqlite3_vtab_nochange() to make it clear that it is an optimization and that virtual table implementations should be prepared for it to always return false. (check-in: 3e264361 user: drh tags: trunk) | |
|
2020-10-12
| ||
| 18:09 | Fix some fts5 problems with signed integer overflow causing segfaults in -ftrapv builds. (check-in: 7e17c2f4 user: dan tags: trunk) | |
| 17:57 | Improved quoting of the table name argument for the ".import" command of the CLI. See forum post 34591fefbe. (check-in: ce97b56d user: drh tags: trunk) | |
| 17:32 | • Edit [bcb0bc6a7b7006f0|bcb0bc6a]: Edit check-in comment. (artifact: 0486837f user: drh) | |
| 16:54 | Add options --data-only and --nosys to the ".dump" command in the CLI. (check-in: 57123b14 user: drh tags: trunk) | |
| 15:27 | Fix ALTER TABLE so that it can run even if the schema contains unknown collation sequences. (check-in: bc4bb943 user: dan tags: trunk) | |
| 14:56 | Add the --nosys option to the .schema command in the CLI. (check-in: b72ee694 user: drh tags: trunk) | |
| 14:29 | Fix UPDATE FROM statements on virtual tables that are declared WITHOUT ROWID. See forum post 0fee7951eb for more information. (check-in: bcb0bc6a user: dan tags: trunk) | |
| 13:24 | Fix BEGIN IMMEDIATE and BEGIN EXCLUSIVE so that they work even if one or more of the database files in the connection are read-only. Test cases for this are in TH3. (check-in: 2fa08c39 user: drh tags: trunk) | |
|
2020-10-07
| ||
| 11:24 | In the CSV extension, use SQLITE_TRANSIENT rather than SQLITE_STATIC on return values that can in fact change. (check-in: 54b54f02 user: drh tags: trunk) | |
|
2020-10-06
| ||
| 15:48 | More additions and improvements to btree.h documentation (check-in: a49a7cde user: shearer tags: btree-code-documentation) | |
|
2020-10-05
| ||
| 16:41 | Allow fts5 trigram tables created with detail=column or detail=none to optimize LIKE and GLOB queries. Allow case-insensitive tables to optimize GLOB as well as LIKE. (check-in: 64782463 user: dan tags: trunk) | |
| 03:24 | • Fixed ticket [95302bdb]: WHERE clause that uses a NUMERIC cast influences the result type plus 5 other changes (artifact: 50e0d5ea user: drh) | |
|
2020-10-03
| ||
| 19:16 | Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: df12f097 user: dan tags: trunk) | |
| 17:08 | • Closed ticket [e33ee625]: Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer plus 6 other changes (artifact: 47c0d456 user: dan) | |
| 17:06 | Fix a segfault caused by running "column LIKE NULL" against an fts5 table using the trigram tokenizer. Fix for [e33ee62575fc22]. (check-in: 6e72a08d user: dan tags: trunk) | |
| 15:44 | • New ticket [e33ee625] Segfault using a CROSS JOIN on a table using the experimental trigram tokenizer. (artifact: 3b682278 user: mrigger) | |
| 14:37 | • Closed ticket [2ba5930b]: Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer plus 4 other changes (artifact: dd78ada3 user: dan) ... 1 similar event omitted. | |
| 14:36 | FTS5 does not handle tokens that contain embedded nul characters. Prevent the trigram tokenizer from returning such tokens. Fix for [2ba5930b2]. (check-in: b1d04874 user: dan tags: trunk) | |
|
2020-10-02
| ||
| 21:16 | • New ticket [95302bdb] WHERE clause that uses a NUMERIC cast influences the result type. (artifact: bd7d181b user: mrigger) | |
| 20:44 | • New ticket [2ba5930b] Unexpected FTS5 integrity-check failure for the experimental trigram tokenizer. (artifact: 851e0fc3 user: mrigger) | |
| 20:19 | • Closed ticket [0f586dbe]: FTS4 integrity-check fails for UTF16 encoding plus 4 other changes (artifact: 845723a5 user: dan) ... 2 similar events omitted. | |
| 15:15 | Fix some test code so that testfixture can build with SQLITE_OMIT_WAL defined. (check-in: dd009cd7 user: dan tags: trunk) | |
| 13:57 | Import further corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization from trunk. (check-in: c144d640 user: drh tags: branch-3.28) | |
| 13:48 | Additional corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization. (check-in: ad5ab24e user: drh tags: trunk) | |
| 12:49 | Remove an incorrect assert() from the OP_SeekScan opcode. (check-in: c0400f8c user: drh tags: trunk) | |
| 12:42 | Fix a faulty assert() statement. Add new test cases. (check-in: 80ecdb3d user: drh tags: trunk) | |
| 12:11 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: ec37744c user: drh tags: branch-3.28) | |
| 11:55 | For the OP_SeekScan optimization, the OP_IdxGT does not necessarily come right after the OP_SeekGE. So use the P2 operand of OP_SeekScan to point to the first instruction after OP_IdxGT. Problem found by dbsqlfuzz. (check-in: 091d7193 user: drh tags: trunk) | |
| 02:07 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: 9a1cdf7e user: drh tags: branch-3.28) | |
| 02:02 | Disable the OP_SeekScan opcode of the in-scan-vs-index optimization when in PRAGMA reverse_unordered_selects mode, as the OP_SeekScan only works with forwards scans. Thanks to OSSFuzz for pointing out the problem to us. (check-in: c75c3a3b user: drh tags: trunk) | |
|
2020-10-01
| ||
| 17:24 | Add experimental "trigram" tokenizer to fts5. (check-in: c4e8ec79 user: dan tags: trunk) | |
| 17:15 | Add the -trigram option to the fts5txt2db.tcl script. (Closed-Leaf check-in: a394dd26 user: dan tags: fts5-trigram) | |
| 16:10 | Add tests for the trigram tokenizer. Fix minor issues. (check-in: 897ced99 user: dan tags: fts5-trigram) | |
| 15:46 | Fix the OP_SeekScan opcode so that its variable names do not cause problems for the test/vdbe-compress.tcl script. (check-in: 7a78274a user: drh tags: trunk) | |
| 14:38 | Remove a debugging printf() accidentally left in the previous check-in. (check-in: e9d1efa5 user: drh tags: trunk) | |
| 14:36 | • Fixed ticket [2d5a3163]: Segmentation fault in CROSS JOIN and the rtree extension plus 3 other changes (artifact: ea3a8285 user: drh) | |
| 14:36 | The IN-early-out optimization does not work for virtual tables. Do not try to use it there. Fix for ticket [2d5a3163563d559f]. Test cases in TH3. (check-in: dbec6910 user: drh tags: trunk) | |
| 13:33 | • Ticket [2d5a3163] Segmentation fault in CROSS JOIN and the rtree extension status still Open with 6 other changes (artifact: 5275fb84 user: drh) ... 1 similar event omitted. | |