/ Recently changed tickets
Key: Active Review Fixed Tested Deferred Closed
# mtime type status subsystem title
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.


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:
The Windows VFS also definitely appears to contradict the limited description in the documentation. In particular calling xAccess with a filename of "." (ie currently directory) and a flag of SQLITE_ACCESS_EXISTS returns False. It used to return True prior to SQLite 3.7.0.

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