| Key: | Active | Review | Fixed | Tested | Deferred | Closed |
| # | mtime | type | status | subsystem | title |
|---|---|---|---|---|---|
| comments | |||||
| 1be72aab92 | 2019-07-17 15:47:38 | Code_Defect | Fixed | Unknown | CHECK constraint using COLLATE with CASE or BETWEEN |
| fd3aec0c7e | 2019-07-17 13:10:33 | Code_Defect | Fixed | Unknown | Valgrind warning if PK has more columns than the table. |
| 9ece23d2ca | 2019-07-08 12:03:27 | Code_Defect | Closed | Unknown | Default collation sequences and affinities lost when window function added to query |
| 9cdc5c4662 | 2019-06-27 02:23:49 | Code_Defect | Fixed | Unknown | Incorrect result from second execution of correlated scalar sub-query that uses a partial sort |
| e1e07ef202 | 2019-06-16 14:57:07 | Code_Defect | Fixed | Unknown | COLLATE in BETWEEN expression is ignored |
| f1580ba1b5 | 2019-06-14 13:25:25 | Code_Defect | Fixed | Unknown | Built-in RTRIM collating sequence yields incorrect comparisons |
| ce8717f088 | 2019-06-14 12:29:07 | Code_Defect | Fixed | Unknown | LIKE malfunctions for UNIQUE COLLATE NOCASE column |
| 674385aeba | 2019-06-12 20:53:50 | Code_Defect | Fixed | Unknown | CAST('-0.0' AS NUMERIC) computes 0.0 rather than 0 |
| b148fa6105 | 2019-06-12 20:32:42 | Documentation | Fixed | Unknown | CAST takes implicit COLLATE of its operand |
| 4d01eda811 | 2019-06-12 13:50:44 | Code_Defect | Closed | Unknown | IS TRUE operator malfunctions with COLLATE and REAL value |
| 0c620df60b | 2019-06-11 21:02:25 | Code_Defect | Fixed | Unknown | LIKELY(), UNLIKELY() and LIKELIHOOD() have affinities |
| 57353f8243 | 2019-06-11 18:08:06 | Code_Defect | Fixed | Unknown | COLLATE expression in the right side of an IN operator results in an affinity conversion |
| afdc5a29dc | 2019-06-11 16:02:57 | Documentation | Closed | Unknown | Lossless conversion when casting a large TEXT number to NUMERIC is not performed |
| 1819598c09 | 2019-06-11 13:43:09 | Documentation | Fixed | Unknown | -'1.0' computes -1.0 rather than -1 |
| d60b3cd7cb | 2019-06-11 03:00:24 | Documentation | Fixed | Unknown | COLLATE expression has an affinity |
| 533010b8ca | 2019-06-11 02:43:44 | Code_Defect | Fixed | Unknown | Illegal argument to LIKELIHOOD() does not result in error when combined with "IN ()" |
| 412bba9b22 | 2019-06-10 23:45:20 | Code_Defect | Fixed | Unknown | CAST('.' AS NUMERIC) computes 0.0 rather than 0 |
| 5e0423b058 | 2019-06-10 19:07:23 | Documentation | Fixed | VFS | xAccess behaviour is not documented, changed in Windows 3.7.0 |
|
The documentation doesn't really define what xAccess should do, in particular when should it return False versus returning an error. http://sqlite.org/c3ref/vfs.html Under Unix you cannot have invalid filenames, except with some specialised non-default file systems. However Windows does have quite a few restrictions. For example it doesn't permit double quotes, angle brackets, asterisk, question mark etc in file names. (Note that colon is permitted to name an alternate data stream.) In my testing I use a filename of "<bad<filename:" and then call xAccess. Prior to SQLite 3.7.0 the Windows VFS would return False. With 3.7.0 it now returns SQLITE_IOERR with the helpful error text of "error". rogerb added on 2010-07-22 06:11:59: | |||||
| 31c6e64ff9 | 2019-06-10 18:51:37 | Code_Defect | Closed | Unknown | ALTER TABLE fails if a trigger references a non-existant table. |
| dd6bffbfb6 | 2019-06-10 18:33:24 | Code_Defect | Fixed | Unknown | CAST to NUMERIC no longer converts to INTEGER |
| fd76310a5e | 2019-06-10 15:35:32 | Code_Defect | Closed | Code_Generator | TEXT value interpreted as column name in an index with empty list in an IN expression |
| b1d8c79314 | 2019-06-10 13:52:52 | Code_Defect | Fixed | Code_Generator | LIKE malfunctions for INT PRIMARY KEY COLLATE NOCASE column |
| 4c2d7639f0 | 2019-06-07 22:26:55 | Code_Defect | Fixed | Unknown | CAST('-' AS NUMERIC) computes 0.0 |
| e8bedb2a18 | 2019-06-07 22:26:40 | Code_Defect | Fixed | Unknown | Incorrect result when subtracting a large integer number from a TEXT value |
| c41afac34f | 2019-05-29 17:22:56 | Code_Defect | Fixed | Unknown | LIMIT applied globally rather than locally |
| ce82323194 | 2019-05-22 22:49:50 | Code_Defect | Fixed | Unknown | Duplicate CTE name gives incorrect result |
| b5ca442af9 | 2019-05-21 14:46:52 | Code_Defect | Closed | Unknown | "Malformed database schema" when creating a failing index within a transaction |
| 9b78184be2 | 2019-05-20 17:15:29 | Code_Defect | Closed | Unknown | Index on non-existing column results in a fabricated value being fetched |
| d3e7f2ba5b | 2019-05-20 12:35:18 | Code_Defect | Fixed | Unknown | Nested boolean formula with IN operator computes an incorrect result |
| 787fa716be | 2019-05-19 17:01:13 | Code_Defect | Fixed | Unknown | Assertion fault when multi-use subquery implemented by co-routine |
| f4ec250930 | 2019-05-17 20:40:46 | Code_Defect | Closed | Code_Generator | Malformed image when using no journal mode, zero cache size, and failing when creating an index. |
| 3c27b97e31 | 2019-05-17 20:07:57 | Code_Defect | Fixed | Unknown | REAL rounding seems to depend on FROM clause |
| bba7b69f98 | 2019-05-14 00:43:27 | Code_Defect | Fixed | Unknown | REINDEX on WITHOUT ROWID table with DESC PRIMARY KEY corrupts automatic UNIQUE index |
| 8025674847 | 2019-05-11 13:05:10 | Code_Defect | Closed | Unknown | Incorrect use of "WHERE x NOT NULL" index for query with a "WHERE x IS NOT ?" term |
| 6c1d3febc0 | 2019-05-09 17:10:40 | Code_Defect | Fixed | Unknown | REAL PRIMARY KEY leads to a missing entry in the index. |
| a340eef47b | 2019-05-08 17:29:15 | Code_Defect | Closed | Unknown | PRAGMA case_sensitive_like can corrupt some databases. |
| 9cf6c9bb51 | 2019-05-08 14:03:50 | Code_Defect | Closed | Unknown | "<" or "<=" comparison of rowid and non-numeric text value sometimes gets the wrong answer. |
| e63cbcfd33 | 2019-05-07 20:06:59 | Code_Defect | Fixed | Unknown | Database table/index contents mismatch (corruption) caused by FK processing |
| 5c6955204c | 2019-05-04 17:34:15 | Code_Defect | Fixed | Code_Generator | Incorrect result on a table scan of a partial index |
| ae0f637bdd | 2019-05-01 19:01:39 | Code_Defect | Fixed | Unknown | REINDEX fails on a UNIQUE index on the GLOB operator of a REAL column |
| 3be1295b26 | 2019-05-01 15:32:51 | Code_Defect | Fixed | Unknown | Inconsistent behavior of a unique constraint on a boolean expression. |
| 3182d38790 | 2019-04-29 13:50:29 | Code_Defect | Fixed | Unknown | COLLATE nocase index on a WITHOUT ROWID table malfunctions |
| f00d7b651a | 2019-04-19 18:23:36 | Code_Defect | Fixed | Unknown | ALTER TABLE corrupts the schema for tables that start with "sqlite" |
| 596d059af7 | 2019-03-15 16:28:24 | Code_Defect | Closed | Code_Generator | Committing a transaction with a failed ALTER TABLE may subtly corrupt schema |
| df46dfb631 | 2019-02-23 00:21:35 | Code_Defect | Fixed | Unknown | Assertion fault in self-join with a IN constraint |
| 4feb3159c6 | 2019-02-22 21:35:59 | Code_Defect | Fixed | Unknown | Crash due to misuse of window functions. |
| 4e8e4857d3 | 2019-02-08 04:20:21 | Code_Defect | Fixed | Unknown | Crash on query using an OR term in the WHERE clause |
| 5948e09b8c | 2019-02-05 14:36:43 | Code_Defect | Fixed | Unknown | Incorrect result from LEFT JOIN |
| bb4bdb9f7f | 2019-01-25 20:09:23 | Code_Defect | Fixed | Virtual_Machine | Zeroblob truncated by an index on an expression |
| bc8d94f0fb | 2019-01-09 02:04:12 | Code_Defect | Fixed | Unknown | RENAME COLUMN fails on tables with redundant UNIQUE constraints |
| d0866b26f8 | 2019-01-01 18:03:21 | Code_Defect | Fixed | Unknown | Window function in correlated subquery causes assertion fault |
| 43ddc85a63 | 2018-12-26 15:17:23 | Code_Defect | Closed | Unknown | ALTER TABLE fails when there is an INSTEAD-OF trigger on a VIEW |
| e6f1f2e34d | 2018-12-22 01:13:33 | Code_Defect | Fixed | Unknown | REPLACE can insert a default NULL into a NOT NULL column |
| 50d2a6c292 | 2018-12-20 17:33:10 | Code_Defect | Closed | Unknown | Foreign key malfunction when parent and child are the same WITHOUT ROWID table and parent key is not also PRIMARY KEY |
| d96eba8769 | 2018-12-14 11:17:01 | Code_Defect | Fixed | Unknown | Incorrect results for OR query where both OR terms are different indexed expressions |
| 1d958d9059 | 2018-12-08 20:30:39 | Code_Defect | Fixed | Unknown | Incorrect result with NOT IN operator and partial index |
| f09fcd1781 | 2018-12-07 01:56:46 | Code_Defect | Fixed | Unknown | Assertion fault when window functions are used. |
| 1a84668dcf | 2018-11-05 13:42:03 | Code_Defect | Fixed | Unknown | Assertion fault due to malformed PRIMARY KEY |
| 65eb38f6e4 | 2018-11-05 08:09:34 | Code_Defect | Fixed | Unknown | Incorrect answer on LEFT JOIN when STAT4 is enabled |
| cf5ed20fc8 | 2018-10-25 15:17:51 | Code_Defect | Fixed | Unknown | Incorrect join result with duplicate WHERE clause constraint |
| e8b6742419 | 2018-10-03 15:34:40 | Performance_Issue | Open | Query planner chooses an inefficient algorithm. | |
| 69d642332d | 2018-09-27 20:20:10 | Code_Defect | Fixed | Unknown | The typeof() and length() functions fail in some virtual tables. |
| e8275b415a | 2018-09-27 13:02:41 | Code_Defect | Fixed | Unknown | Assertion fault from window function inside of recursive CTE |
| f25d5ceebe | 2018-09-24 14:11:02 | Code_Defect | Fixed | Unknown | INTEGER PRIMARY KEY WITHOUT ROWID virtual table crash |
| 510cde2777 | 2018-09-17 15:30:05 | Code_Defect | Fixed | Unknown | Endless loop on a query with window functions, ORDER BY, and LIMIT |
| b41031ea2b | 2018-09-17 15:29:43 | Code_Defect | Fixed | Unknown | ALTER TABLE returns an error on certain schemas |
| 9936b2fa44 | 2018-09-10 14:49:04 | Code_Defect | Fixed | Unknown | Infinite loop due to the ORDER BY LIMIT optimization |
| c94369cae9 | 2018-09-10 12:41:21 | Code_Defect | Fixed | Unknown | Wrong answer due to the LIKE optimization |
| 908f001483 | 2018-08-14 15:13:06 | Code_Defect | Fixed | Unknown | UPSERT does not work like PostgreSQL |
| c694113e50 | 2018-07-24 22:02:30 | Code_Defect | Fixed | Unknown | Unnecessary ABORT with unhelpful error message |