Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 events occurring around 7bc8205dd9c1657c.
|
2019-11-18
| ||
| 10:37 | Improved detection of corruption in the %_stat table of FTS4. Chromium ticket 1025467. (check-in: 10f8a3b7 user: drh tags: trunk) | |
|
2019-11-17
| ||
| 11:47 | Fix an assert that can fail if the schema is corrupt. (check-in: ed57c48e user: drh tags: trunk) | |
| 02:41 | Better detection of corruption in the %_stat and %_docsize shadow tables of FTS3. (check-in: 1e449687 user: drh tags: trunk) | |
| 00:08 | Remove a reachable NEVER() in FTS3. (check-in: 8bd75bf6 user: drh tags: trunk) | |
|
2019-11-16
| ||
| 23:47 | More improvements to shadow table corruption detection in FTS3. (check-in: 51525f9c user: drh tags: trunk) | |
| 21:40 | Improved detection of corrupt shadow tables in FTS3. Enable the debugging special-inserts for FTS3 for both SQLITE_DEBUG and SQLITE_TEST. (check-in: 04b2873b user: drh tags: trunk) | |
| 18:36 | Do not allow shadow tables to be dropped in defensive mode. (check-in: 0a988ce3 user: drh tags: apple-osx) | |
| 18:30 | Modify three test cases so that they work even with unusual versions of the library printf(). (check-in: c2528907 user: drh tags: apple-osx) | |
| 16:54 | More restrictions on changes to shadow tables when in defensive mode. (check-in: bae76a5c user: drh tags: trunk) | |
| 14:15 | Do not allow CREATE TABLE or CREATE VIEW of an object with a name that looks like a shadow table name. (Closed-Leaf check-in: 6aef58b6 user: drh tags: defensive-improvements) | |
| 13:51 | Break out the test for writable shadow tables into a separate subroutine. (check-in: 8ad34d36 user: drh tags: defensive-improvements) | |
| 12:04 | Do not allow shadow tables to be dropped in defensive mode. (check-in: 70390bbc user: drh tags: trunk) | |
| 11:33 | Fix a potential NULL pointer dereference on a RENAME TABLE that references a VIEW with a logic error in a window function in the ORDER BY clause. (check-in: 0adb273f user: drh tags: trunk) | |
|
2019-11-15
| ||
| 21:16 | Modify three test cases so that they work even with unusual versions of the library printf(). (check-in: 8f4a3750 user: drh tags: trunk) | |
| 02:52 | Merge the version 3.30.1 changes into the apple-osx branch. (check-in: 2c8af352 user: drh tags: apple-osx) | |
| 00:52 | • Fixed ticket [2ae0c599]: Table-valued functions do not work as the right table of a LEFT JOIN plus 5 other changes (artifact: 95c1051d user: drh) | |
| 00:52 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 2c35d3f6 user: drh tags: trunk) | |
| 00:06 | • New ticket [2ae0c599] Table-valued functions do not work as the right table of a LEFT JOIN. (artifact: 73457732 user: drh) | |
|
2019-11-14
| ||
| 23:08 | Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. (check-in: ba27012d user: drh tags: branch-3.30) | |
| 18:07 | Add support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma. (check-in: 6399c47e user: drh tags: trunk) | |
| 17:46 | Fix a bug in the hard_heap_limit pragma so that it returns the new value of the hard_heap_limit, not the soft_heap_limit. Change SQLITE_MAX_MEMORY so that it works by setting the default hard_heap_limit value. (Closed-Leaf check-in: 33fd0c3a user: drh tags: hard-heap-limit) | |
| 15:21 | Merge recent enhancements from trunk. (check-in: b8a631fd user: drh tags: hard-heap-limit) | |
| 15:10 | Minor documentation enhancements. No changes to code. (check-in: 6153f3aa user: drh tags: hard-heap-limit) | |
| 13:57 | New test cases added to fuzzdata8.db. (check-in: 5baffcda user: drh tags: trunk) | |
| 13:24 | Ensure that the same subquery does not go through the window-function rewrite more than once, even when that subquery is part of a virtual table constraint that lacks the omit flag. (check-in: d0bc7db6 user: drh tags: trunk) | |
|
2019-11-13
| ||
| 18:50 | Add header guard to the expert extension. (check-in: 7e315185 user: mistachkin tags: trunk) | |
| 16:50 | Fix the sqlite3TreeView() output to consistently use a colon and not a comma after the table number in the AST dumps. (check-in: fa2416f6 user: drh tags: trunk) | |
|
2019-11-12
| ||
| 16:21 | For for the previous check-in: Always enable the nUri variable, even when debugging is turned off. (check-in: f84a1539 user: drh tags: trunk) | |
| 14:43 | Ensure that the main filename and the journal filenames in the pager object are all correctly double-zero terminated. (check-in: df51ae19 user: drh tags: trunk) | |
| 03:45 | Remove a harmless unused variable. (check-in: 28091a48 user: drh tags: trunk) | |
|
2019-11-11
| ||
| 15:13 | Remove an asm() block from build tool mksourceid.c, as it causes build failures on some systems and performance is not important at build-time. (check-in: 8e100e6c user: dan tags: trunk) | |
|
2019-11-10
| ||
| 11:09 | Proper surrogate pair decoding added to JSON functions. See the mailing list bug report and https://bugs.python.org/issue38749. More test cases needed here, but it seems to work so far. (check-in: 51027f08 user: drh tags: trunk) | |
| 10:08 | Remove an incorrect ALWAYS() macro. (check-in: f7a74f89 user: drh tags: trunk) | |
|
2019-11-09
| ||
| 15:31 | Change the COLFLAG_NOTAVAIL bitmask so that it fits in the single-byte Walker.eCode field. (check-in: 53847f5c user: drh tags: trunk) | |
| 14:44 | New dbsqlfuzz test cases added. (check-in: 18c3a17d user: drh tags: trunk) | |
| 14:38 | Make sure the WITH stack in the Parse object is disabled following an error. (check-in: de6e6d68 user: drh tags: trunk) | |
|
2019-11-08
| ||
| 20:28 | • Fixed ticket [7e59041f]: DISTINCT malfunctions for VIEW with virtual table plus 7 other changes (artifact: 2f5eddbd user: drh) | |
| 20:13 | When a virtual table reports orderByConsumed, that tells us nothing about whether or not the SQLITE_DISTINCTBY constraint is met. Fix for ticket [7e59041f9c4e5102]. Test cases in TH3. (check-in: b59f94e4 user: drh tags: trunk) | |
|
2019-11-07
| ||
| 21:58 | • New ticket [7e59041f] DISTINCT malfunctions for VIEW with virtual table. (artifact: 3f8b5e74 user: mrigger) | |
| 19:59 | Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. (Leaf check-in: 4ab9dbb9 user: drh tags: limit_heap_k) | |
| 14:51 | • Fixed ticket [302027ba]: VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column plus 3 other changes (artifact: 64dcc54e user: drh) | |
| 14:51 | Fix the xferCompatibleIndex() function so that it recognizes that a PRIMARY KEY index for a WITHOUT ROWID table is different from a UNIQUE constraint index on the primary key. Ticket [302027baf1374498] (check-in: 34f64f11 user: drh tags: trunk) | |
| 14:27 | • Ticket [302027ba] VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column status still Open with 4 other changes (artifact: e4dac141 user: drh) ... 2 similar events omitted. | |
| 02:33 | • Fixed ticket [299b50ba]: UPDATE on table with two generated columns and CHECK clause results in segfault plus 6 other changes (artifact: de304abd user: drh) | |
| 02:32 | Restore generated column loop detection logic that was incorrectly removed from the previous check-in [9e07b48934e9a972]. This fixes ticket [299b50ba812d8e54] (check-in: 104a2beb user: drh tags: trunk) | |
|
2019-11-06
| ||
| 23:10 | • New ticket [299b50ba] UPDATE on table with two generated columns and CHECK clause results in segfault. (artifact: 627b5554 user: mrigger) | |
| 22:20 | • Fixed ticket [4fc08501]: Segfault when inserting into table with generated columns plus 6 other changes (artifact: 635c203d user: drh) | |
| 22:19 | Change the way generated columns are computed so that no column is computed inside branch code that might not be taken. Ticket [4fc08501f4e56692] (check-in: 9e07b489 user: drh tags: trunk) | |
| 19:25 | Minor simplification to the changes from check-in [36c11ad51f]. (check-in: 7bc8205d user: mistachkin tags: trunk) | |
| 17:31 | • Fixed ticket [ce22a077]: NULL WHERE condition unexpectedly results in row being fetched plus 6 other changes (artifact: d70a33c4 user: drh) | |
| 17:31 | Fix the OP_DeferredSeek index-to-table column map in P4 so that it works with generated columns. Ticket [ce22a07731530118] (check-in: 36c11ad5 user: drh tags: trunk) | |
| 15:41 | • New ticket [4fc08501] Segfault when inserting into table with generated columns. (artifact: 73daa54f user: mrigger) | |
| 15:16 | • New ticket [ce22a077] NULL WHERE condition unexpectedly results in row being fetched. (artifact: b13b7dce user: mrigger) | |
| 14:50 | • Fixed ticket [2399f598]: REPLACE on table with generated NOT NULL column results in segfault plus 6 other changes (artifact: 990c736a user: drh) | |
| 14:49 | Fix the handling of NOT NULL constraint violations for generated columns in a REPLACE statement. Ticket [2399f5986134f79c] (check-in: 77b1c90a user: drh tags: trunk) | |
|
2019-11-05
| ||
| 22:31 | • New ticket [2399f598] REPLACE on table with generated NOT NULL column results in segfault. (artifact: c677a2c3 user: mrigger) | |
| 13:04 | • Closed ticket [1cda8f4b]: UNLIKELY in query causes row to not be fetched plus 6 other changes (artifact: 248d7d1e user: drh) ... 1 similar event omitted. | |
|
2019-11-04
| ||
| 12:49 | Changes an unreachable testcase() into an assert(). (check-in: 5710845b user: drh tags: trunk) | |
| 02:06 | • Fixed ticket [02aa2bd0]: Row value comparison malfunctions on view with left join plus 6 other changes (artifact: 9c9659a8 user: drh) | |
| 02:05 | Fix a false-postive in the sqlite3ExprImpliesNonNullRow() decision routine, that resulted in an incorrect LEFT JOIN strength reduction when the WHERE clause contained a row-value comparison. Ticket [02aa2bd02f97d0f2] (check-in: ea20068e user: drh tags: trunk) | |
|
2019-11-03
| ||
| 10:51 | • New ticket [02aa2bd0] Row value comparison malfunctions on view with left join. (artifact: 0d1dbe84 user: mrigger) | |
| 10:06 | • New ticket [3c9eadd2] PRAGMA integrity_check fails due to CHECK constraint even without records. (artifact: d58c01a9 user: mrigger) | |
| 00:07 | • Fixed ticket [623eff57]: LEFT JOIN in view malfunctions with partial index on table plus 6 other changes (artifact: 4895f3bf user: drh) | |
| 00:07 | The optimization of check-in [9b2879629c34fc0a] is incorrectly reasoned. The WHERE clause of the partial index might not be true if the table of the partial index is the right table of a left join. So disable the optimization in that case. Ticket [623eff57e76d45f6] (check-in: 3be19e11 user: drh tags: trunk) | |
|
2019-11-02
| ||
| 21:41 | • New ticket [623eff57] LEFT JOIN in view malfunctions with partial index on table. (artifact: 4a276959 user: mrigger) | |
| 17:59 | Fix a problem in VIEW creation that was introduced by the generated columns feature. (check-in: 9c795c4d user: drh tags: trunk) | |
| 13:45 | "STORED" is not actually a keyword. The parser looks for STORED as an ordinary identifier. (check-in: 167cd574 user: drh tags: trunk) | |
| 13:33 | • Edit [17e9f65814264de9|17e9f658]: Edit check-in comment. (artifact: 461928a4 user: drh) | |
| 13:33 | • Fixed ticket [a9efb428]: Incorrect result for GLOB operator plus 6 other changes (artifact: 5ddca416 user: drh) | |
| 13:32 | In sqlite3GenerateIndexKey(), do not attempt to reuse column values from the previous index if the current index is a partial index as the partial index test may have changed those values. Ticket [a9efb42811fa41ee] (check-in: 17e9f658 user: drh tags: trunk) | |
| 08:22 | • New ticket [a9efb428] Incorrect result for GLOB operator. (artifact: 003e557e user: mrigger) | |
| 00:00 | Restore the on-line ".help" for the ".explain" command in the CLI. (check-in: 28b8f103 user: drh tags: trunk) | |
|
2019-11-01
| ||
| 18:52 | Fix a harmless compiler warning. (check-in: f0ebea35 user: drh tags: trunk) | |
| 17:31 | The SET DEFAULT and SET NULL conflict resolution actions for foreign key constraints should cause an error when they appear on a generated column. (check-in: b47513d2 user: drh tags: trunk) | |
| 16:37 | Fix a potential use-after-free bug that follows an OOM error in code added two days ago by check-in [84e02d773d60cffe]. Problem discovered by OSSFuzz. (check-in: 0a2eb949 user: drh tags: trunk) | |
| 16:08 | Add another missing column number translation to the foreign key logic. (check-in: 32df5edc user: drh tags: trunk) | |
| 15:19 | • Fixed ticket [c28a01da]: REPLACE causes segfault in table with generated column and foreign key plus 6 other changes (artifact: 5ed2b8c2 user: drh) | |
| 15:19 | Omit the optimization that reduces the column-count on rowid-table cursors when the table has generated columns, because we do not know what columns the generator expressions might try to access. (check-in: e6c96ed9 user: drh tags: trunk) | |
| 13:37 | Fix an fts3 assert() that could fail when operating on a database containing corrupt records. (check-in: 7c52f547 user: dan tags: trunk) | |
| 12:14 | Add missing column translations to foreign key logic. Ticket [c28a01da72f8957c] (check-in: bc6a43e7 user: drh tags: trunk) | |
| 10:49 | Fix a potential array bounds overflow in the mkkeywordhash.c code generator. Also add marks to omit keywords specific to generated columns when building with -DSQLITE_OMIT_GENERATED_COLUMNS. (check-in: cc6a4081 user: drh tags: trunk) | |
| 08:00 | • New ticket [c28a01da] REPLACE causes segfault in table with generated column and foreign key. (artifact: baaa9dac user: mrigger) | |
| 02:30 | Slightly faster keyword hash table. (check-in: f12e743e user: drh tags: trunk) | |
|
2019-10-31
| ||
| 20:58 | • Ticket [b9befa4b] Segfault in table with generated column and foreign key status still Fixed with 3 other changes (artifact: 59afd142 user: drh) ... 1 similar event omitted. | |
| 20:54 | Correctly generate pre-UPDATE content for virtual columns that are used by foreign key constraints. Ticket [b9befa4b83a660cc] (check-in: 40d3282e user: drh tags: trunk) | |
| 20:02 | • New ticket [b9befa4b] Segfault in table with generated column and foreign key. (artifact: 99d2ef1d user: mrigger) | |
| 17:13 | Add a few simple TCL test cases for generated columns. (Full test coverage of the generated column logic is provided separately by TH3.) (check-in: acedb5c7 user: drh tags: trunk) | |
| 13:16 | • Fixed ticket [1d2a8efc]: VACUUM on table with generated column that uses TYPEOF results in an error plus 6 other changes (artifact: 6088e629 user: drh) | |
| 13:16 | Ignore differences in Expr.op2 in sqlite3ExprCompare() in cases where it does not matter. Ticket [1d2a8efc6c3a595a]. (check-in: 32982067 user: drh tags: trunk) | |
| 12:30 | Enhance the TreeView logic to show information about Expr.op2 for FUNCTION and COLUMN nodes. (check-in: aceeaf9e user: drh tags: trunk) | |
| 09:42 | • New ticket [1d2a8efc] VACUUM on table with generated column that uses TYPEOF results in an error. (artifact: c4ece77a user: mrigger) | |
|
2019-10-30
| ||
| 18:50 | • Fixed ticket [830277d9]: Non-deterministic date/time functions allowed in CHECK constraints plus 3 other changes (artifact: cfa6b870 user: drh) | |
| 18:50 | Always disallow the use of non-deterministic functions in CHECK constraints, even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] (check-in: 2978b65e user: drh tags: trunk) | |
| 16:29 | Simplify the bytecode generation for SQL function calls such that the OP_Function or OP_PureFunc opcodes are coded directly, rather than using the intermediate OP_Function0 or OP_PureFunc0 - opcodes that are now removed. (check-in: 84e02d77 user: drh tags: trunk) | |
| 13:00 | New tokens ALWAYS, GENERATED, and STORED used by generated columns should all be fallback tokens. (check-in: 13fe6978 user: drh tags: trunk) | |
| 10:33 | • Ticket [830277d9] Non-deterministic date/time functions allowed in CHECK constraints status still Open with 6 other changes (artifact: e6974b73 user: drh) | |