/ Recently changed tickets
Login
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:
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