Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
54 events for the month beginning 2019-12-01 by user dan
Following month ↑|
2019-12-30
| ||
| 14:32 | • Closed ticket [7c0e06b1]: NATURAL JOIN on virtual table results in "parse error in rank function" plus 5 other changes (artifact: 156c8eb0 user: dan) | |
| 14:32 | Do not use HIDDEN columns for NATURAL joins. Fix for [7c0e06b16]. (check-in: ab09ef42 user: dan tags: trunk) | |
| 06:55 | In ALTER TABLE, rename columns and tables in expressions that are optimized out by the "AND 0" optimization. Doing this also fixes an otherwise harmless assert() failure. (check-in: a9e0354c user: dan tags: trunk) | |
|
2019-12-28
| ||
| 18:25 | Do not attempt to flatten compound sub-queries in a FROM clause into the parent if any component of the sub-query uses a window function. (check-in: eeb76f62 user: dan tags: trunk) | |
| 18:08 | Change an assert() in where.c to a testcase() macro, since the condition may be false. This was a problem with the assert() only, there is no bug in release builds that omit assert(). (check-in: 82be135d user: dan tags: trunk) | |
| 15:24 | Fix an instance where the planner might choose to use the OR-optimization when it adds no benefit. The same quirk causes an assert() to fail. This is not a bug in released versions - without the assert() the library still gets the right answer, it just does so less efficiently than it should. (check-in: f4bed1d7 user: dan tags: trunk) | |
| 09:08 | Second attempt to fix a problem with unwinding the WITH stack of the Parse object following an error. (check-in: 315d1f1a user: dan tags: trunk) | |
| 08:33 | Merge latest trunk changes with this branch. (Closed-Leaf check-in: d693be37 user: dan tags: better-error-handling-1) | |
| 08:26 | Fix an assert() failure in altertable3-22.4. (check-in: c566a91d user: dan tags: better-error-handling-1) | |
|
2019-12-27
| ||
| 20:54 | Do not attempt to unwind the WITH stack in the Parse object following an error. This fixes a separate case to [de6e6d68], but also causes an assertion fault at select.c:4666 for test case altertab3-22.4. (check-in: d29edef9 user: dan tags: better-error-handling-1) | |
| 20:06 | • Closed ticket [36ffedcb]: Debug assertion exprSrcCount: Assertion `0' failed plus 5 other changes (artifact: e5b585ae user: dan) | |
| 20:06 | Remove a NEVER() that is no longer true. Fix for [36ffedcb9]. (check-in: 597896ed user: dan tags: trunk) | |
| 19:46 | Fix a problem involving window function aliases being referenced from sub-selects. (check-in: e3b5fc05 user: dan tags: trunk) | |
| 16:25 | Fix a problem with window functions in aggregate queries that do not have GROUP BY clauses. (check-in: 99609786 user: dan tags: trunk) | |
| 15:31 | Do not mistake constant integers in a PARTITION BY expression for references to ORDER BY style references to values returned by the SELECT statement. (check-in: 45c64d39 user: dan tags: trunk) | |
| 14:16 | • Ticket [1dc432db] FTS4 integrity-check results in "database disk image is malformed" for UTF-16 encoding status still Open with 3 other changes (artifact: b88cf338 user: dan) ... 1 similar event omitted. | |
| 08:57 | When determining if an aggregate within a sub-query should be processed as part of the sub-query or an outer query, consider any FILTER clause in the same way as the arguments to the aggregate. (check-in: 1ffc045d user: dan tags: trunk) | |
|
2019-12-26
| ||
| 14:37 | • Closed ticket [167b2aac]: Debug assertion fts5CheckTransactionState: Assertion `iSavepoint<=p->ts.iSavepoint' failed plus 5 other changes (artifact: ab09a7cc user: dan) | |
| 14:37 | • Edit [a5d7f5d24a239f72|a5d7f5d2]: Edit check-in comment. (artifact: 20744134 user: dan) | |
| 14:36 | Fix an assert() in fts5 that could fail if an xSavepoint() call on another vtab fails. Fix for [167b2aac] . (check-in: a5d7f5d2 user: dan tags: trunk) | |
|
2019-12-24
| ||
| 20:51 | • Closed ticket [752fdbf6]: FTS database disk image is malformed for UTF-16 encoding and integrity check plus 5 other changes (artifact: f7cfb4b9 user: dan) | |
| 20:51 | Fix a problem causing fts5 integrity-check failures if numeric values are inserted into a table within a utf-16 database. Fix for [752fdbf6]. (check-in: bae060f3 user: dan tags: trunk) | |
| 16:20 | • Closed ticket [df46a6f3]: Debug assertion sqlite3Fts5HashScanNext: Assertion `!sqlite3Fts5HashScanEof(p)' failed plus 5 other changes (artifact: 4be93981 user: dan) | |
| 16:20 | Fix another case where malformed utf-8 was being mishandled in fts5. Fix for [df46a6f3]. (check-in: 1c0a05b0 user: dan tags: trunk) | |
| 15:35 | Fix an assert() added as part of commit [a11b393dc] that can fail if fts5 database records are corrupt. (check-in: 4630c1ec user: dan tags: trunk) | |
| 14:27 | Fix a spurious report of corruption that could be made by the fts5 integrity-check in SQLITE_DEBUG builds if the fts5 index contains malformed utf text. Ticket [d62981b76de521e3] (check-in: a11b393d user: dan tags: trunk) | |
|
2019-12-23
| ||
| 15:24 | • Closed ticket [bf1aab89]: FTS merge does not terminate plus 5 other changes (artifact: 962c97b5 user: dan) | |
| 15:17 | • Closed ticket [dfd66334]: Debug assertion impliesNotNullRow: Assertion `pWalker->eCode==0' failed plus 5 other changes (artifact: a85ae698 user: dan) | |
| 15:17 | Fix a case in which SQLite could fail to identify "x BETWEEN ? AND ?" being true as implying that x is not null. Ticket [dfd66334]. (check-in: 2f179749 user: dan tags: trunk) | |
| 14:36 | • Closed ticket [3ab4a9f0]: Debug assertion sqlite3VdbeExec: Assertion `pC!=0' failed plus 6 other changes (artifact: 515462bc user: dan) | |
| 14:21 | • Closed ticket [d9ed4ebe]: SELECT on window function causes a segfault plus 5 other changes (artifact: ec51a80e user: dan) | |
| 14:20 | For expressions like (x, y) IN (SELECT ...) where the SELECT uses window-functions, require that all columns on the LHS be indexed before an index can be used. Fix for [d9ed4ebe]. (check-in: 0b1dbd60 user: dan tags: trunk) | |
|
2019-12-22
| ||
| 17:32 | • Closed ticket [f00d096c]: Debug assertion sqlite3VdbeExec: Assertion `memIsValid(pRec)' failed plus 5 other changes (artifact: 04aede2e user: dan) | |
| 17:32 | Ensure sqlite3WindowRewrite() is called on a SELECT statement before any terms aremoved from it as part of IN() clause processing. Fix for [f00d096ca]. (check-in: 8c856404 user: dan tags: trunk) | |
| 14:30 | • Closed ticket [9cb7d0ef]: Debug assertion fts5StructureRead: Assertion `p->iStructVersion!=0' failed plus 5 other changes (artifact: 242ff056 user: dan) | |
| 14:29 | Fix "PRAGMA data_version" so that it works the same way with locking_mode=PERSIST and journal_mode=PERSIST configured. Fix for 7a458c2a5f. (check-in: 45748e2d user: dan tags: trunk) | |
|
2019-12-21
| ||
| 20:43 | • Closed ticket [cd3311e3]: FTS database disk image is malformed for update on languageid plus 5 other changes (artifact: e96fe9d9 user: dan) | |
| 20:43 | Fix a spurious report of corruption from the fts3/4 integrity-check triggered by using the languageid option. (check-in: 70815e27 user: dan tags: trunk) | |
|
2019-12-20
| ||
| 20:03 | Fix a bad interaction between RBU and [df51ae19]. (check-in: 0b9d8a12 user: dan tags: trunk) | |
| 19:41 | • Closed ticket [e431c355]: FTS database disk image is malformed for UTF-16 encoding plus 5 other changes (artifact: 8a229fe7 user: dan) | |
| 19:41 | Fix two more cases in fts5 where sqlite3_value_bytes() was being called before sqlite3_value_text(). Fix for e431c355. (check-in: a1ba9a37 user: dan tags: trunk) | |
| 14:18 | Fix a potential problem with ALTER TABLE commands on schemas that contains a triggers or view featuring a sub-query that uses an ON clause with a join that is not a LEFT JOIN. (check-in: 365dd8b6 user: dan tags: trunk) | |
| 13:24 | • Closed ticket [cf36cb4e]: FTS database disk image is malformed for UTF-16 encoding after update plus 5 other changes (artifact: fc18f675 user: dan) | |
| 13:24 | Ensure fts5 consistently calls sqlite3_value_text() before sqlite3_value_bytes(). This matters when storing blobs in fts5 tables within utf-16 databases. Fix for [cf36cb4e02]. (check-in: c16305eb user: dan tags: trunk) | |
|
2019-12-14
| ||
| 14:15 | Fix problems in fts3 with processing corrupt records and undefined integer overflows. (check-in: 3b873029 user: dan tags: trunk) | |
|
2019-12-10
| ||
| 03:40 | Avoid a buffer overread in fts5 that could occur when parsing corrupt configuration records. (check-in: 355afd77 user: dan tags: trunk) | |
|
2019-12-09
| ||
| 08:13 | Avoid infinite recursion in the ALTER TABLE code when a view contains an unused CTE that references, directly or indirectly, the view itself. (check-in: 1d2e53a3 user: dan tags: trunk) | |
| 02:20 | Fix possible null pointer dereferences in the fts5_expr() scalar function. (check-in: c5d44143 user: dan tags: trunk) | |
|
2019-12-05
| ||
| 14:31 | Fix a problem in ALTER TABLE that could occur if an index, view or trigger in the schema features an expression of the form ((SELECT ...) IN ()) where the SELECT statement uses a CTE. (check-in: 7e5ad8e0 user: dan tags: trunk) | |
|
2019-12-04
| ||
| 14:26 | Fix an assert() failure that could occur in ALTER TABLE code when the schema contains a view that uses a CTE. (check-in: 75b04a4b user: dan tags: trunk) | |
| 03:46 | Fix a buffer overread that could occur in fts3 with corrupt %_stat records. (check-in: e01fdbf9 user: dan tags: trunk) | |
| 01:42 | Fix a double-free that could occur when a component of a compound SELECT with an ORDER BY clause uses named window definitions. (check-in: 92893b79 user: dan tags: trunk) | |
|
2019-12-03
| ||
| 03:34 | Avoid a crash that could occur when a database containing a table with a temp trigger that has the same name as a temp table is detached. (check-in: c4cb9708 user: dan tags: trunk) | |