Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
91 check-ins going from release:202010141546 to trunk:202010141546
2020-10-14
| ||
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: 3e2643619d user: drh tags: trunk) | |
2020-10-12
| ||
18:09 | Fix some fts5 problems with signed integer overflow causing segfaults in -ftrapv builds. (check-in: 7e17c2f4b7 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: ce97b56d63 user: drh tags: trunk) | |
16:54 | Add options --data-only and --nosys to the ".dump" command in the CLI. (check-in: 57123b14a7 user: drh tags: trunk) | |
15:27 | Fix ALTER TABLE so that it can run even if the schema contains unknown collation sequences. (check-in: bc4bb9433f user: dan tags: trunk) | |
14:56 | Add the --nosys option to the .schema command in the CLI. (check-in: b72ee69453 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: bcb0bc6a7b 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: 2fa08c3963 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: 54b54f02c6 user: drh tags: trunk) | |
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: 64782463be user: dan tags: trunk) | |
2020-10-03
| ||
19:16 | Do not apply affinities when creating entries for automatic indexes on views. Fix for [95302bdb]. (check-in: df12f09722 user: dan tags: trunk) | |
17:06 | Fix a segfault caused by running "column LIKE NULL" against an fts5 table using the trigram tokenizer. Fix for [e33ee62575fc22]. (check-in: 6e72a08de7 user: dan tags: trunk) | |
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: b1d048748c user: dan tags: trunk) | |
2020-10-02
| ||
15:15 | Fix some test code so that testfixture can build with SQLITE_OMIT_WAL defined. (check-in: dd009cd7ae user: dan tags: trunk) | |
13:48 | Additional corner-case fixes for the in-scan-vs-index or OP_SeekScan optimization. (check-in: ad5ab24ebd user: drh tags: trunk) | |
12:49 | Remove an incorrect assert() from the OP_SeekScan opcode. (check-in: c0400f8c0b user: drh tags: trunk) | |
12:42 | Fix a faulty assert() statement. Add new test cases. (check-in: 80ecdb3da4 user: drh tags: trunk) | |
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: 091d719394 user: drh tags: trunk) | |
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: c75c3a3b75 user: drh tags: trunk) | |
2020-10-01
| ||
17:24 | Add experimental "trigram" tokenizer to fts5. (check-in: c4e8ec7907 user: dan tags: trunk) | |
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: 7a78274a07 user: drh tags: trunk) | |
14:38 | Remove a debugging printf() accidentally left in the previous check-in. (check-in: e9d1efa597 user: drh tags: trunk) | |
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: dbec6910d9 user: drh tags: trunk) | |
2020-09-30
| ||
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: 4a43430fd2 user: drh tags: trunk) | |
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: 7395e96b8c user: drh tags: trunk) | |
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: 69f9eb7343 user: drh tags: trunk) | |
09:17 | Better understanding of savepoint code (check-in: ce6d8d6215 user: shearer tags: trunk) | |
2020-09-28
| ||
15:49 | Small performance improvement and size reduction by reducing the size of the WhereTerm object. (check-in: 43f7ddad80 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: d3d13df31a user: drh tags: trunk) | |
2020-09-21
| ||
20:18 | Fix harmless compiler warning seen with MSVC. (check-in: 4591ee03d7 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: 782163693f 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: 8bbaee2385 user: drh tags: trunk) | |
12:10 | Attempt to silence harmless static analyzer warnings in Lemon and in the Lemon-generated parser. (check-in: de8ce22a46 user: drh tags: trunk) | |
2020-09-17
| ||
21:11 | Fix a typo in the documentation comment for sqlite3_preupdate_hook(). (check-in: 4542d194e2 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: c666c85a43 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: 9a55601d07 user: dan tags: trunk) | |
14:16 | Fix a "jump depends on unitialized value" valgrind/asan error in fts5. (check-in: 66f94d623c 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: e2074b2478 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: 751fe4edb2 user: drh tags: trunk) | |
00:46 | DISTINCT may not be ignored inside a UNION ALL common table expression. Fix for ticket [c51489c3b8f919c5] (check-in: 7d2b590d3a user: drh tags: trunk) | |
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: 9ea3039b53 user: drh tags: trunk) | |
16:55 | Fix harmless compiler warnings in Lemon. (check-in: 6c94ba4b1c user: drh tags: trunk) | |
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: 3d35fa0be8 user: dan tags: trunk) | |
12:29 | Do not invoke usleep() for more than 999999 microseconds. (check-in: 1f5ed852f2 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: b79f19edfd user: dan tags: trunk) | |
2020-09-10
| ||
15:09 | Try again to fix the typo in the sqlite3_txn_state() documentation. (check-in: 6d1ab0403c user: drh tags: trunk) | |
14:54 | Fix typo in the documentation for the new sqlite3_txn_state() interface. (check-in: 23f7d01758 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: 5b905d7d77 user: drh tags: trunk) | |
2020-09-07
| ||
11:14 | Fix another (harmless in practice) tsan error in shared-cache mode. (check-in: 5a74fa3f0a 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: 783fa887c9 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: 430c5d1da5 user: drh tags: trunk) | |
2020-09-04
| ||
19:10 | Fix a tsan error that could occur when using shared-cache mode. (check-in: de80bc8730 user: dan tags: trunk) | |
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: 5dd0594061 user: dan tags: trunk) | |
2020-09-01
| ||
19:02 | Fix harmless compiler warning. (check-in: a711e8cd2c 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: d34caf3bb6 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: 84d54eb357 user: drh tags: trunk) | |
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: 35505c68c1 user: drh tags: trunk) | |
00:26 | Fix a harmless compiler warning. (check-in: 3ca0b7d54d user: drh tags: trunk) | |
2020-08-31
| ||
18:49 | New test-control that returns the number of calls to sqlite3BtreeMovetoUnpacked() on the main database and then resets the counter. This only works for SQLITE_DEBUG builds. (check-in: dca5b91926 user: drh tags: trunk) | |
12:29 | Fix the documentation for the OP_IdxGT family of opcodes to show that the P5 operand is not used. (check-in: 62f7d2a612 user: drh tags: trunk) | |
2020-08-29
| ||
19:00 | Fix a sanitizer warning in zipfile.c. (check-in: ded1a75b3c user: dan tags: trunk) | |
15:15 | Improve performance of wal-mode locking on unix in cases where there are hundreds of connections to a single database within the same process. (check-in: a1c19eea8f user: dan tags: trunk) | |
2020-08-28
| ||
18:47 | Add the miscellaneous 'series' extension to the shell. (check-in: fc0856dccf user: mistachkin tags: trunk) | |
13:10 | Update Lemon documentation. Patches from sgbeal. (check-in: f5dc83442b user: drh tags: trunk) | |
12:58 | Fix a couple of unreachable branches. (check-in: f2d26f2b11 user: drh tags: trunk) | |
11:19 | Add fts5 test to confirm that for a table with columns a, b, c and d, "{a b}" and "-{c d}" are handled similarly. (check-in: 1a04920998 user: dan tags: trunk) | |
2020-08-27
| ||
20:55 | Remove a (harmless) redundant variable from the CLI implementation. (check-in: 3f7bbb840d user: drh tags: trunk) | |
18:36 | Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: 5ce34a955b user: drh tags: trunk) | |
16:28 | 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: aafb7a2104 user: drh tags: trunk) | |
14:53 | Do not attempt to run test script analyze3.test as part of the "prepare" permutation. (check-in: f7f13cb1bc user: dan tags: trunk) | |
2020-08-26
| ||
19:07 | Enhance the ".databases" command in the CLI so that it shows the result of sqlite3_db_readonly() and sqlite3_txn_state() for each database file. (check-in: 0ffd16d23d user: drh tags: trunk) | |
10:50 | If the argument to the ".read" command in the CLI begins with "|" then run the remainder of the argument as a command and read input from the output of that command. (check-in: 6c716f4b55 user: drh tags: trunk) | |
2020-08-25
| ||
19:09 | Add support for the sqlite3_txn_state() interface. (check-in: ad195e3dd8 user: drh tags: trunk) | |
2020-08-24
| ||
23:44 | Reduce the N in the logN term for the sorting cost associated with computing DISTINCT by B-Tree by half, under the assumption that the DISTINCT will eliminate about half the rows of output. This is really a wild guess. But we do not have any better way of estimating what the row-count reduction due to DISTINCT will actually be. (check-in: 8787417ec1 user: drh tags: trunk) | |
10:52 | Correctly handle expressions like "x IS (not) true/false" within the rhs of IN() expressions. Fix for [f3ff1472]. (check-in: 493a25949b user: dan tags: trunk) | |
2020-08-20
| ||
16:25 | Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: 5f58dd3a19 user: dan tags: trunk) | |
11:03 | Avoid a buffer overrun in test code that could occur if certain test functions were passed a hex-string containing an odd number of digits. (check-in: 3c5e63c22f user: dan tags: trunk) | |
2020-08-19
| ||
23:51 | Try to make SQLite easier to compiler for Mac Catalyst. See forum post 803387a1c5. (check-in: e1595a20d7 user: drh tags: trunk) | |
23:32 | 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: 871f2ddcfb user: drh tags: trunk) | |
15:24 | Update releasetest_data.tcl so that the "Fast-One" configuration runs bigmmap.test as part of release testing. (check-in: a0aa35aaa5 user: dan tags: trunk) | |
15:21 | Fix a problem in test file bigmmap.test. (check-in: d8e4738216 user: dan tags: trunk) | |
2020-08-17
| ||
09:11 | Fix the -quote option on the CLI to set the correct column separator. (check-in: c778f8295c user: drh tags: trunk) | |
2020-08-16
| ||
00:30 | Optimization to sqlite3BeginWriteOperation(). (check-in: 2173d4c6e3 user: drh tags: trunk) | |
2020-08-15
| ||
23:48 | Optimization of the sqlite3SrcListDelete() routine. (check-in: 1b4acd1ac4 user: drh tags: trunk) | |
22:23 | Remove more unnecessary sqlite3GetVdbe() calls, replacing them with assert()s. (check-in: b7dc932197 user: drh tags: trunk) | |
21:55 | Avoid unnecessary calls to the sqlite3GetVdbe() routine. Add assert() statements to prove each call is unnecessary. (check-in: 86d3790caf user: drh tags: trunk) | |
19:58 | Omit the unnecessary not-NULL check on the upper bound of a forward index range scan. The subsequent OP_IdxGT will always catch the NULL. Similarly, omit the not-NULL check on the lower bound of a reverse index range scan, as the SeekLE opcode will disallow the NULL. (check-in: e51ecadcbd user: drh tags: trunk) | |
2020-08-14
| ||
21:51 | When doing an UPDATE or DELETE using a multi-column index where only a few of the earlier columns of the index are useful for the index lookup, postpone doing the main table seek until after all WHERE clause constraints have been evaluated, in case those constraints can be covered by unused later terms of the index, thus avoiding unnecessary main table seeks. (check-in: 7fee0b1075 user: drh tags: trunk) | |
21:37 | Update the version number to 3.34.0 for the next development cycle. (check-in: 70f34f3df5 user: drh tags: trunk) | |
16:14 | Fix an inconsequential memory leak in sqldiff. Update the "Sanitize" case in wapptest.tcl to use -fsanitize=address,undefined, and to run more tests. (check-in: 613fb5c252 user: dan tags: trunk) | |
13:23 | Version 3.33.0 (check-in: fca8dc8b57 user: drh tags: trunk, release, version-3.33.0) | |