/ Recently changed tickets
Login
Key: Active Review Fixed Tested Deferred Closed
# mtime type status subsystem title
comments
 
f096d191b6 2019-12-05 15:08:06 Code_Defect Open   Row value comparison malfunctions with rtree table
 
9fe487ba3c 2019-12-05 14:42:46 Code_Defect Fixed Unknown Join on two rtree tables malfunctions
 
30e2c183b6 2019-12-05 13:35:06 Code_Defect Fixed Unknown column = NULL predicate evaluates to TRUE for rtree table
 
a55ab6d97d 2019-12-05 00:45:14 Code_Defect Fixed Extensions Incorrect result for TEXT comparison on rtree table
 
3c9eadd2a6 2019-12-02 11:15:33 Code_Defect Open Unknown PRAGMA integrity_check fails due to CHECK constraint even without records
 
7f39060a24 2019-11-30 19:29:44 Code_Defect Fixed Unknown LEFT JOIN malfunctions with partial ISNULL index
 
8fe768e9c9 2019-11-18 12:28:47 Code_Defect Closed Unknown FTS integrity-check malfunctions
 
2ae0c599b7 2019-11-15 00:52:25 Code_Defect Fixed Unknown Table-valued functions do not work as the right table of a LEFT JOIN
 
7e59041f9c 2019-11-08 20:28:42 Code_Defect Fixed Unknown DISTINCT malfunctions for VIEW with virtual table
 
302027baf1 2019-11-07 14:51:45 Code_Defect Fixed Unknown VACUUM results in "database disk image is malformed" for PRIMARY KEY with duplicate column
 
299b50ba81 2019-11-07 02:33:14 Code_Defect Fixed Unknown UPDATE on table with two generated columns and CHECK clause results in segfault
 
4fc08501f4 2019-11-06 22:20:33 Code_Defect Fixed Unknown Segfault when inserting into table with generated columns
 
ce22a07731 2019-11-06 17:31:43 Code_Defect Fixed Unknown NULL WHERE condition unexpectedly results in row being fetched
 
2399f59861 2019-11-06 14:50:01 Code_Defect Fixed Unknown REPLACE on table with generated NOT NULL column results in segfault
 
1cda8f4b54 2019-11-05 13:04:18 Code_Defect Closed Unknown UNLIKELY in query causes row to not be fetched
 
02aa2bd02f 2019-11-04 02:06:14 Code_Defect Fixed Unknown Row value comparison malfunctions on view with left join
 
623eff57e7 2019-11-03 00:07:56 Code_Defect Fixed Unknown LEFT JOIN in view malfunctions with partial index on table
 
a9efb42811 2019-11-02 13:33:10 Code_Defect Fixed Unknown Incorrect result for GLOB operator
 
c28a01da72 2019-11-01 15:19:51 Code_Defect Fixed Unknown REPLACE causes segfault in table with generated column and foreign key
 
b9befa4b83 2019-10-31 20:58:06 Code_Defect Fixed Unknown Segfault in table with generated column and foreign key
 
1d2a8efc6c 2019-10-31 13:16:40 Code_Defect Fixed Unknown VACUUM on table with generated column that uses TYPEOF results in an error
 
830277d9db 2019-10-30 18:50:18 Code_Defect Fixed Unknown Non-deterministic date/time functions allowed in CHECK constraints
 
6484e6ce67 2019-10-29 16:19:00 Code_Defect Fixed Unknown VACUUM on table with generated column results in an error
 
166347c6fc 2019-10-29 03:39:31 Code_Defect Fixed Unknown VACUUM issue on table with generated column
 
9621dd78a0 2019-10-29 03:30:39 Code_Defect Fixed Unknown Segfault when updating table with generated columns
 
91e8695101 2019-10-27 22:22:42 Code_Defect Fixed Unknown Segfault in table with generated columns
 
3ea1755124 2019-10-26 23:52:24 Code_Defect Fixed Unknown REINDEX causes "UNIQUE constraint failed" error for generated column
 
c1e19e1204 2019-10-26 16:39:11 Code_Defect Fixed Unknown Trigger causes query to compute incorrect result
 
dd1f67bf25 2019-10-24 20:36:11 Code_Defect Closed Unknown FTS integrity-check malfunctions nondeterministically with tokenize="ascii"
 
50c09fc2cf 2019-10-24 19:37:01 Code_Defect Fixed Unknown Crash on REPLACE INTO of a table with an AFTER DELETE trigger.
 
135c9da751 2019-10-23 18:09:50 Code_Defect Fixed Unknown Comparison of row values with COLLATE NOCASE yields incorrect result
 
6ef984af89 2019-10-22 19:51:41 Code_Defect Fixed Unknown Row value comparison yields incorrect result
 
b47e3627ec 2019-10-22 10:43:16 Code_Defect Fixed Unknown Comparison of row values results in incorrect result
 
7fc8e5ff25 2019-10-21 13:35:17 Code_Defect Closed Unknown INSERT into table with two triggers does not terminate
 
bf1aab8978 2019-10-17 13:56:47 Code_Defect Open   FTS merge does not terminate
 
a8a4847a2d 2019-10-16 14:56:24 Code_Defect Fixed Unknown Trigger inserts duplicate value in UNIQUE column
 
278ac14262 2019-10-11 17:26:14 Code_Defect Fixed Unknown FTS integrity_check fails when inserting x'00'
 
745f1abcdc 2019-10-11 15:33:29 Code_Defect Closed Unknown FTS integrity-check malfunctions for transaction and the prefix option
 
8a6fa2bb22 2019-10-11 14:28:21 Code_Defect Closed Unknown FTS order=DESC results into integrity-check failing
 
c31034044b 2019-10-10 17:10:18 Code_Defect Closed Unknown LEFT JOIN in view malfunctions with NOTNULL
 
1079ad1999 2019-10-10 15:17:23 Code_Defect Closed Unknown Crash in query with FILTER clause on normal aggregate that refers to a column of a subquery
 
a976c487d1 2019-10-10 13:56:00 Code_Defect Closed Unknown LEFT JOIN in view malfunctions
 
d392017c8e 2019-10-09 18:36:50 Code_Defect Closed Unknown FTS rebuild in combination with crisismerge results in error "database or disk is full"
 
81a7f7b9e2 2019-10-09 15:27:54 Code_Defect Closed Unknown FTS integrity-check indicates that the database disk image is malformed
 
e258f008ce 2019-10-08 13:35:03 Code_Defect Closed Unknown FTS rebuild in transaction causes integrity-check to fail
 
265e935b26 2019-10-07 20:36:33 Code_Defect Closed Unknown FTS pgsz option results in "database disk image is malformed" error
 
b2d4edaffd 2019-10-07 01:07:56 Code_Defect Fixed Unknown Comparison on view malfunctions
 
99cd4807dc 2019-09-23 11:55:45 Code_Defect Fixed Unknown Scalar subquery with "LIMIT 0" should return NULL
 
587791f926 2019-09-17 13:30:42 Code_Defect Fixed Unknown Row is not fetched when using WHERE clause with INSTR()
 
0f0428096f 2019-09-16 18:20:06 Code_Defect Fixed Unknown GLOB unexpectedly does not match
 
18458b1ad6 2019-09-11 11:30:28 Code_Defect Closed Unknown COLLATE issue in view
 
c4130c33be 2019-09-10 19:46:38 Code_Defect Closed Unknown DISTINCT malfunctions for VIEW
 
a7debbe0ad 2019-09-09 20:18:05 Code_Defect Closed Unknown BETWEEN issue in view
 
767a8cbc6d 2019-09-03 14:27:40 Code_Defect Fixed Unknown COLLATE NOCASE string comparison yields incorrect result
 
29f635e0af 2019-09-03 13:35:00 Code_Defect Fixed Unknown IS NULL unexpectedly evaluates to TRUE
 
2841e99d10 2019-09-02 02:22:07 Code_Defect Fixed Unknown Different rounding when converting TEXT to REAL
 
57af00b664 2019-09-02 00:58:56 Code_Defect Fixed Unknown Expression computed on row yields incorrect result
 
d6a0fbc14e 2019-08-31 17:15:18 Code_Defect Closed Unknown REINDEX causes "UNIQUE constraint failed" error when using TRIGGER
 
40812aea1f 2019-08-30 23:56:45 Code_Defect Fixed Unknown Incorrect result for comparison of large number
 
5a3dba8104 2019-08-30 23:15:18 Code_Defect Fixed Unknown REINDEX causes "UNIQUE constraint failed" error
 
f8f472cbc7 2019-08-30 16:01:12 Code_Defect Fixed Unknown Partial index and BETWEEN issue
 
fba33c8b1d 2019-08-30 15:11:19 Code_Defect Fixed Unknown Partial index causes row to not be fetched in BETWEEN expression
 
a6408d42b9 2019-08-30 13:07:27 Code_Defect Fixed Unknown Partial index causes row to not be fetched
 
c03903637b 2019-08-29 15:07:20 Code_Defect Closed Unknown Indexes causes row to not be fetched
 
51f5b6e427 2019-08-29 12:54:37 Feature_Request Closed Unknown Short-circuit evaluation issue
 
f8a7060ece 2019-08-27 20:00:48 Code_Defect Closed Unknown Incorrect result for query that uses MIN() and a CAST on rowid
 
dbaf8a6820 2019-08-27 17:01:25 Code_Defect Fixed Unknown Unexpected affinity conversion is performed for the IN operator
 
ac8dd4a32b 2019-08-27 10:09:08 Code_Defect Fixed Unknown Segfault when dropping a temp trigger on a database that has already been detached
 
78acc9d40f 2019-08-26 14:19:30 Code_Defect Fixed Unknown Assertion fault in row-value UPDATE
 
7e07a3dbf5 2019-08-22 16:39:06 Code_Defect Fixed Unknown LIKELY() seems to cause unexpected affinity conversion for rowid
 
ac184eb571 2019-08-22 11:14:02 Code_Defect Fixed Unknown Row with comparison on TEXT UNIQUE column is not fetched
 
d9f584e936 2019-08-22 00:55:07 Code_Defect Fixed Unknown Row is not fetched in table with INTEGER PRIMARY KEY
 
b86894020e 2019-08-21 14:55:33 Code_Defect Closed Unknown DISTINCT malfunctions for IS NULL
 
f043b1130b 2019-08-20 11:45:21 Code_Defect Closed Unknown INDEXED BY results in row not being fetched
 
c7a1171907 2019-08-17 19:14:57 Code_Defect Closed Unknown WHERE clause erroneously influences value of fetched column from view
 
6710d2f7a1 2019-08-17 17:11:14 Code_Defect Fixed Unknown LEFT JOIN fails to fetch row
 
256741a16b 2019-08-15 14:36:11 Code_Defect Fixed Unknown null pointer dereference caused by window functions in result-set of EXISTS(SELECT ...)
 
e4598ecbdd 2019-08-15 14:35:55 Code_Defect Fixed Unknown Division by zero in the query planner.
 
17db54d744 2019-08-14 19:55:58 Code_Defect Closed Unknown Unexpected error in DELETE with existing trigger
 
3cf9bb227e 2019-08-12 18:26:57 Code_Defect Fixed Unknown Database corruption caused by REPLACE
 
9080b6227f 2019-08-10 15:06:29 Code_Defect Fixed Unknown Constant expression in partial index results in row not being fetched
 
0a5e2c1dcb 2019-08-06 23:28:25 Code_Defect Fixed Unknown Unexpected affinity conversion for view column in IN operator
 
9f66f887d4 2019-08-06 17:05:23 Documentation Fixed Unknown EXPLAIN PRAGMA executes PRAGMA
 
61c853857f 2019-08-06 15:33:12 Code_Defect Fixed Unknown Row is not fetched in SELECT from VIEW
 
d52a29a9e6 2019-08-05 20:41:11 Code_Defect Fixed Unknown Unexpected affinity conversion in view
 
71e183cab6 2019-08-03 16:51:24 Code_Defect Closed Unknown MIN() malfunctions for a query with ISNULL condition
 
41866dc373 2019-08-02 19:40:53 Code_Defect Closed Unknown MIN() malfunctions for UNIQUE column
 
ced41c7c7d 2019-07-30 01:17:23 Code_Defect Fixed Unknown Query with DISTINCT does not fetch all distinct rows
 
ccbe5759fb 2019-07-29 15:54:51 Code_Defect Closed Unknown ANALYZE causes DISTINCT to malfunction in CROSS JOIN
 
ba2f4585cf 2019-07-29 06:07:05 Code_Defect Fixed Unknown Query with ORDER BY results in "database disk image is malformed" error
 
18ab5da2c0 2019-07-29 06:05:34 Not_A_Bug Closed Unknown Issue with DISTINCT and COLLATE
 
c52b09c7f3 2019-07-24 23:15:31 Performance_Issue Fixed Unknown Assertion fault in the query planner on a deeply nested query
 
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.