SQLite
All Tickets
Not logged in
Key: Active Review Fixed Tested Deferred Closed
# mtime type status subsystem title
264b970c43 2014-04-14 19:48:16 Code_Defect Fixed Unknown Crash when calling sqlite_rename_parent() with NULL parameters.
2ea3e9fe63 2014-04-13 19:28:14 Code_Defect Fixed Unknown Partial index causes assertion fault on UPDATE OR REPLACE
10fb063b11 2014-04-10 02:24:43 Code_Defect Fixed Unknown Duplicate row output on an OR query
98825a79ce 2014-04-03 16:57:11 Code_Defect Fixed Unknown Incorrect result from a DISTINCT + GROUP BY + ORDER BY query
a8a0d2996a 2014-03-24 15:02:18 Code_Defect Fixed Unknown Incorrect column data type reported
07d6a0453d 2014-03-21 18:16:34 Code_Defect Fixed Unknown OFFSET ignored if there is no FROM clause
e39d032577 2014-03-20 13:31:59 Code_Defect Fixed Unknown Assertion fault on a query containing "x IN (?)"
0841d0f524 2014-03-11 13:20:51 Feature_Request Closed Unknown Exclusive transactions do not work if same database multiply attached
13137dccf3 2014-03-11 13:20:19 Feature_Request Closed Extensions FTS3 and last_insert_rowid()
084941461f 2014-03-11 13:20:03 Code_Defect Closed Extensions Some minor asyncvfs issues
25e09aa2ab 2014-03-11 13:19:13 Feature_Request Closed Parser Lint mode
5ac9b497de 2014-03-11 13:18:44 Feature_Request Fixed Parser Some issues with aliases, fully qualified identifiers, and *
030632f55b 2014-03-11 13:18:26 Feature_Request Closed Unknown make sqlite2 detect sqlite3
72b01a982a 2014-03-11 13:18:08 Feature_Request Closed Unknown Per page/region checksums
3671265894 2014-03-11 13:17:53 Feature_Request Closed Shell No error reporting on file open failure
af3450b763 2014-03-11 13:17:33 Feature_Request Closed Extensions Recursive virtual tables
c25aab7e7e 2014-03-11 13:17:03 Feature_Request Fixed Shell The ".import" command does not parse CSV correctly.
f817a45752 2014-03-11 13:16:48 Feature_Request Closed VFS CantOpen doesn't include name of file that can't be opened
775b39dd3c 2014-03-11 13:15:56 Code_Defect Fixed Shell Poor query planning with virtual tables, joins and ORDER BY.
2e047cbefa 2014-03-11 13:15:26 Performance_Issue Closed Virtual_Machine select DISTINCT performance could be better
23b2128201 2014-03-11 13:14:19 Feature_Request Fixed Virtual_Machine Uninformative error message on check constraint failure
61d35ac210 2014-03-11 13:14:00 Feature_Request Closed Unknown A way to tell if a journal should exist
33fdaab1a0 2014-03-11 13:13:26 Feature_Request Closed Virtual_Machine Need to cancel an integrity check in progress with sqlite3_interrupt
293860ac26 2014-03-11 13:12:43 Feature_Request Closed Unknown Allow triggers to reference other databases
65a1fd4bab 2014-03-11 13:12:02 Feature_Request Closed Shell Shell should call rl_readline_name
bcff482dd6 2014-03-11 13:11:26 Feature_Request Fixed Unknown Explicit extended error code for deadlock with sqlite_busy
5896edbe46 2014-03-11 13:11:05 Feature_Request Closed Unknown List available SQL functions
c276ee2e4e 2014-03-11 13:10:44 Feature_Request Closed Unknown null should not be allowed in primary key
f711d5a937 2014-03-11 13:09:05 Feature_Request Fixed Unknown Windows DLL should have versioninfo resource
4d5c039d12 2014-03-11 13:08:03 Feature_Request Closed Unknown Truncated database not detected well
de3ae967a0 2014-03-11 13:07:14 Feature_Request Fixed Parser Insert multiple rows at once
c060923a54 2014-03-11 13:06:54 Code_Defect Closed VFS VFS filename truncation issues
f6ee7c1986 2014-03-11 13:06:10 Feature_Request Fixed Shell Negative widths should right justify
ba7fdb568d 2014-03-11 13:05:46 Feature_Request Fixed VFS Page size should auto default to file system block size
08595ca456 2014-03-11 13:05:24 Code_Defect Closed Parser INTERSECT operator should have higher precedence
ed2ff2f4ef 2014-03-11 13:04:34 Feature_Request Closed Virtual_Machine Call progress callback while doing pragma integrity_check
ebde3f66fc 2014-03-11 13:04:06 Feature_Request Closed Virtual_Machine Shared cache has different busy behaviour than non-shared
d8fe6cef65 2014-03-11 13:03:38 Code_Defect Closed VFS Error return from VFS xUnlock ignored
1c67bd6ce9 2014-03-11 13:02:13 Feature_Request Closed Shell Shell Control-C (break) handling could be better
1a1790ca1a 2014-03-11 13:00:31 Feature_Request Closed Virtual_Machine No way to signal an error in collation callback
62359d6511 2014-03-11 13:00:09 Feature_Request Closed VFS xGetLastError should be dumped
efeeb90f2a 2014-03-11 12:59:44 Feature_Request Closed Unknown error messages should be per-thread not global
15e11a2c87 2014-03-11 12:59:14 Feature_Request Closed Unknown IfEmpty(a,b) : a function like IfNull(a,b) but for empty strings
eaa105fe74 2014-03-11 12:58:48 Feature_Request Closed Code_Generator (...) WHERE [col] IN (val1) not reflected in xBestIndex
b803a45d50 2014-03-11 12:58:12 Feature_Request Closed Unknown Feature Request: MATCHES(VAL1%, VAL2, %VALn%, ...)
e33452c90f 2014-03-11 12:56:59 Feature_Request Closed Unknown Query plan doesn't use existing index
89f7b55854 2014-03-11 12:56:34 Feature_Request Closed Unknown RFE - Documentation in PDF format?
2c5661c26a 2014-03-11 12:56:01 Feature_Request Closed Other Thread safety: does SQLite handle pthread_cancel cleanly?
1248e6cda8 2014-03-11 12:54:58 Code_Defect Closed Unknown Insufficient precision of sqlite3_column_text16() for floating point values
36769f697d 2014-03-11 12:50:03 Code_Defect Closed Extensions termDataCmp in FTS3 should be __cdecl on Windows
8f81455baf 2014-03-11 12:49:29 Code_Defect Closed Extensions fts3GetVarint32 sets random number on error
5e0423b058 2014-03-11 12:47:57 Documentation Open VFS xAccess behaviour is not documented, changed in Windows 3.7.0
edb497982c 2014-03-11 12:47:14 Code_Defect Fixed Unknown FTS n-character prefix query returns incorrect results when using an n+1 character prefix index.
f48b7da35c 2014-03-11 12:46:40 Documentation Closed Documentation Loadable extensions documentation bitrot
01b785eefa 2014-03-11 12:45:49 Support_Request Closed Shell sqlite3.exe - wrong parameter charset
6c266900a2 2014-03-11 12:44:44 Feature_Request Open Shell shell: The column mode (and width option) does not manage correctly UTF-8
beba9cae63 2014-03-11 12:44:00 Code_Defect Fixed Unknown Assertion fault on a valid query
4eb3a0bd32 2014-03-11 12:41:50 Code_Defect Fixed Unknown Performance regression in Skrooge
31a19d11b9 2014-03-05 15:07:06 Code_Defect Fixed Unknown Name resolution issue with compound SELECTs and Common Table Expressions
4ef7e3cfca 2014-03-04 13:03:50 Code_Defect Closed Unknown Name resolution problem in sub-selects within triggers
65bdeb9739 2014-02-26 02:26:29 Code_Defect Fixed Unknown "ORDER BY random()" gets optimized out
8c63ff0eca 2014-02-25 21:56:00 Code_Defect Fixed Unknown Incorrect query result on a UNION ALL
c34d0557f7 2014-02-12 14:43:48 Code_Defect Fixed Unknown Name resolution issue with WITHOUT ROWID
4c86b126f2 2014-02-11 02:48:03 Code_Defect Fixed Unknown Incorrect query result with SQLITE_ENABLE_STAT4
fccbde530a 2014-02-08 19:12:24 Code_Defect Fixed Unknown DISTINCT thinks a zeroblob() and blob of all zeros are different
1a1a194d1e 2014-01-20 19:56:28 Code_Defect Closed Unknown Assertion fault on query of virtual table with cross-column constraints
ee4b2b48f5 2013-12-31 18:29:27 Feature_Request Open Parser Prepared statement cache
520070ec7f 2013-12-22 20:44:24 Code_Defect Fixed Unknown Array overrun in the skip-scan optimization
4065ac8595 2013-11-12 12:31:31 Code_Defect Closed Unknown LEFT JOIN with virtual table on left hand side may not return all rows
c620261b5b 2013-10-28 20:39:11 Code_Defect Fixed Unknown Incorrect result on query involving LEFT JOIN and transitive constraints
a5c8ed66ca 2013-10-04 00:07:13 Code_Defect Fixed Unknown Incorrect count(*) when partial indices exist
9fb5cd7c76 2013-09-30 10:19:46 Code_Defect Fixed Unknown "DELETE FROM tbl" statements do not obtain a shared-cache write-lock on table "tbl"
be84e357c0 2013-09-03 14:03:54 Code_Defect Fixed Unknown Segfault during query involving LEFT JOIN column in the ORDER BY clause
9f2eb3abac 2013-08-29 13:12:10 Code_Defect Fixed Unknown A lookup on a primary key or unique index with more than 4 fields can cause a crash
2fd50fa665 2013-08-29 07:22:57 Feature_Request Closed VFS cygwin-1.7 issues: winFullPathname and tempname
bc878246ea 2013-08-28 16:27:07 Code_Defect Fixed Unknown Incorrect result from LEFT JOIN query
d666d600a6 2013-08-21 13:09:44 Code_Defect Fixed Unknown COLLATE operator on lhs of BETWEEN expression is ignored.
1c69be2daf 2013-08-15 22:42:36 Code_Defect Fixed Unknown Incorrect GROUP BY when input and output columns have the same name
f617ea3125 2013-08-15 22:42:19 Code_Defect Fixed Unknown Incorrect ORDER BY with colliding input and output column names
406d3b2ef9 2013-07-18 18:45:58 Code_Defect Fixed Unknown SQL function auxdata associated with parameters is not cleared
78588b938a 2013-07-17 11:54:50 Code_Defect Fixed Unknown Virtual Table Sync frees pVtab->zErrMsg without zeroing
83e9014ec2 2013-07-09 14:49:40 Code_Defect Fixed Unknown Incorrect result from sqlite3_stmt_status with SQLITE_STMTSTATUS_FULLSCAN_STEP
5ed1772895 2013-07-09 14:49:14 Code_Defect Fixed Unknown Incorrect ORDER BY on an indexed JOIN
bc1aea7b72 2013-07-09 14:48:25 Code_Defect Fixed Unknown Incorrect result on LEFT JOIN with OR constraints and an ORDER BY clause
490a4b7235 2013-07-09 03:04:50 Code_Defect Fixed Unknown "WHERE 0" on the first element of a UNION causes an assertion fault
d805526eae 2013-07-08 21:13:16 Code_Defect Fixed Unknown Incorrect join result or assertion fault due to transitive constraints
868145d012 2013-07-01 17:27:33 Code_Defect Fixed Unknown Assertion fault on double LEFT JOIN
a589ec069e 2013-06-27 17:40:44 Code_Defect Fixed Unknown sqlite3_stmt_readonly() returns an incorrect value for come PRAGMAs
e636a050b7 2013-05-15 18:21:44 Code_Defect Fixed Unknown Database corruption in shared cache mode
0fc59f908b 2013-05-15 17:58:20 Code_Defect Fixed Unknown Missing COLLATE function does not result in an error
f2369304e4 2013-05-09 14:20:19 Code_Defect Fixed Unknown Incorrect results when OR is used in the ON clause of a LEFT JOIN
6709574d2a 2013-05-08 16:58:10 Code_Defect Fixed Unknown COLLATE clause in ORDER BY causes incorrect EXCEPT
2f96536e7f 2013-05-06 20:29:01 Code_Defect Fixed Shell .tables output is not redirected into .output file
5eaa61ea18 2013-05-06 18:49:42 Portability Fixed Unknown sigbus on disk ful in WAL mode
0eb70d77cb 2013-05-06 13:45:39 Code_Defect Fixed Unknown Invalid pointer passed to the authorizer callback
19b44e3575 2013-04-30 14:26:35 Feature_Request Fixed Virtual_Machine sqlite3_bind_text inconsistent with NULL pointers, zero length etc
28c6e830f2 2013-04-30 14:07:07 Code_Defect Fixed Unknown Segfault while parsing/compiling an SQL statement
ba82a4a41e 2013-04-22 22:29:50 Code_Defect Fixed Unknown Query optimizer removes ORDER BY when it is needed
f69b96e307 2013-04-18 02:55:56 Code_Defect Fixed Unknown Over-aggressive optimization of ORDER BY using a virtual table with IN operator
2500cdb9be 2013-04-14 23:51:40 Code_Defect Fixed Unknown COLLATE in ORDER BY clause breaks name resolution
7ff3120e4f 2013-04-12 12:09:20 Code_Defect Fixed VFS Recovery race condition leads to database corruption on Windows
38b1ae018f 2013-03-27 21:12:25 Code_Defect Fixed Unknown Assertion fault on valid FTS4 query
6bfb98dfc0 2013-03-27 21:11:25 Code_Defect Fixed Unknown False report of database corruption on an INSERT
a179fe7465 2013-03-27 17:20:18 Code_Defect Fixed Unknown Incorrect output order on a join with an ORDER BY
689137afb6 2013-03-20 12:45:58 Code_Defect Fixed Unknown Casting UTF16 to numeric types fails
4dd95f6943 2013-03-13 00:13:54 Code_Defect Fixed Unknown Inverted result order with ORDER BY DESC and a DESC index.
fc7bd6358f 2013-03-06 01:55:45 Code_Defect Fixed Unknown Incorrect query result in a 3-way join due to affinity issues
7a31705a7e 2013-03-01 17:43:37 Code_Defect Fixed Unknown Name resolution fails when table name is a prefix of another table
db4d96798d 2013-01-29 23:55:55 Code_Defect Fixed Unknown LIMIT does not work with nested views containing UNION ALL
d58ccbb3f1 2013-01-28 19:00:28 Code_Defect Fixed Unknown Segmentation fault on a valid query with "union"
7c6a01c6c5 2013-01-15 15:28:03 Performance_Issue Closed Unknown Multi-column index is not used with IN operator
c997b11c4d 2013-01-09 14:43:29 Code_Defect Fixed Code_Generator ORDER BY clause ignored in 3-way join query
0cfd98ee20 2012-12-21 16:16:53 Code_Defect Closed Pager Potential corruption of backup db when backing up a db last written by sqlite<3.7.0
a7b7803e8d 2012-12-19 16:58:04 Code_Defect Fixed Code_Generator crash when filtering twice by same predicate using aliases
71e333e7d2 2012-12-19 15:17:05 Code_Defect Fixed Unknown COLLATE operator inside CHECK constraint fails in shared-cache mode
dec444cd68 2012-12-19 12:46:56 Code_Defect Closed Unknown rowid not usable in complex queries
df678d738a 2012-12-18 14:04:30 Code_Defect Closed Pager Cache corruption following IO error on systems supporting atomic-write
d6b36be38a 2012-12-07 19:41:22 Code_Defect Closed Code_Generator Sub-select in LIMIT clause may access db without locks.
ae3c5670b6 2012-12-06 19:42:31 Code_Defect Closed Code_Generator Bug caused by factoring of constants in trigger programs
f46ca03b55 2012-11-29 14:27:13 Code_Defect Closed Extensions The order of two operations in asyncLock()
bfbf38e5e9 2012-11-02 23:55:29 Code_Defect Fixed Unknown Segfault on a nested join
d02e1406a5 2012-10-04 19:41:35 Code_Defect Fixed Unknown LEFT JOIN with an OR in the ON clause causes segfault
c2ad16f997 2012-05-21 21:26:35 Code_Defect Fixed Unknown Segfault on query involving deeply nested aggregate views
cfe84e8683 2012-05-21 03:15:53 Code_Defect Fixed Unknown The ".schema" command outputs nested VIEWS in the wrong order
bdc6bbbb38 2012-05-10 17:59:02 Code_Defect Closed Unknown Problem with FTS aux. functions when used with OR queries with enhanced query syntax enabled
385a5b56b9 2012-04-20 17:44:18 Code_Defect Closed Code_Generator A DISTINCT SELECT optimized using a UNIQUE index may allow duplicate NULL values.
2a5629202f 2012-04-20 17:43:46 Code_Defect Closed Code_Generator Malfunctioning interaction between a multi-term ORDER BY clause and UNIQUE index containing NULL values
27ca74af3c 2012-03-31 18:02:56 Code_Defect Fixed Unknown Nested SAVEPOINT release causes pending query abort
b7c8682cc1 2012-03-13 14:10:35 Code_Defect Fixed Unknown Incorrect result from LEFT JOIN with OR in the WHERE clause
3557ad65a0 2012-03-03 01:44:33 Code_Defect Fixed Unknown Incorrect DISTINCT on an indexed query with IN
ae6794effd 2012-02-01 01:14:41 Code_Defect Fixed Unknown ALTER TABLE RENAME fails for triggers that use the table name with a different case
5f41597f7c 2012-01-30 18:41:08 Code_Defect Fixed Unknown sqlite3_uri_boolean defaults to true, documented as false, is a mess
232637c465 2012-01-28 21:09:25 Code_Defect Fixed Shell Dump code fails with 1002 columns
c04a8b8a4f 2012-01-28 21:09:09 Code_Defect Fixed Unknown Trailing comments not stripped from views, invalid dumps
ff5be73dee 2012-01-14 15:35:02 Code_Defect Fixed Unknown Database corruption following power-loss in WAL mode
a1fa75cbdd 2012-01-14 15:34:17 Code_Defect Fixed Pager Database corruption following unlucky application crash in WAL mode with "PRAGMA journal_size_limit"
ac0ff496b7 2011-12-22 02:11:23 Code_Defect Fixed Unknown Database corruption due to integer overflow with SQLITE_DIRECT_OVERFLOW_READ
7bbfb7d442 2011-12-10 13:53:09 Code_Defect Fixed Virtual_Machine Problem with using stale auto-indexes created on materialized sub-selects within trigger programs
3a77c9714e 2011-12-06 14:02:51 Code_Defect Fixed Parser Malfunction involving temporary registers and sub-queries implemented by vdbe sub-routines.
676bc02b87 2011-11-04 00:24:14 Code_Defect Fixed Unknown Incorrect xfer optimization with INTERGER PRIMARY KEY ON CONFLICT REPLACE
8290242b2a 2011-10-31 18:46:35 Code_Defect Closed Unknown ALTER TABLE RENAME fails if the database encoding is not UTF8
3338b3fa19 2011-10-31 18:46:16 Code_Defect Closed Unknown ambiguous column name when using multiple JOIN USING clauses and WHERE clause
f1c2a689c6 2011-10-31 18:45:34 Build_Problem Closed Other configure script ignores ``--with-tcl'' option when tclsh8.4 is installed.
92bd6eaf04 2011-10-31 18:44:47 Build_Problem Closed Makefile Suggestion to revise clean rule in main.mk.
57c971fc74 2011-10-31 18:44:32 Code_Defect Closed Unknown Some user defined string functions do not operate correctly on strings with embedded nuls
48f299634a 2011-10-29 11:54:59 Code_Defect Closed Virtual_Machine Crash in SAVEPOINT within a transaction that writes to then drops an FTS table
d214d7b114 2011-10-13 18:26:33 Code_Defect Closed Extensions FTS3 virtual table fails when names are quoted
9861b74ab9 2011-10-13 18:25:15 Code_Defect Closed Unknown Fts3 offsets() function may report SQLITE_CORRUPT with empty string.
9fd058691b 2011-10-13 17:34:50 Code_Defect Closed Extensions Problem with updating an FTS table that contains a single row
4c9223e34e 2011-10-13 16:32:26 Documentation Closed Documentation Vacuum fails within transaction but also rolls it back
ab7498f2f6 2011-10-13 16:07:15 Performance_Issue Closed Unknown 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause
92af7da36b 2011-10-13 16:02:27 Code_Defect Fixed Shell shell won't import large files
0c80ff9f5a 2011-10-13 15:56:12 Documentation Fixed Documentation Quickstart missing include of stdlib.h
fa7bf5ec94 2011-10-13 15:38:08 Code_Defect Fixed Unknown String literal case confusion in aggregate query
b2d64a52a0 2011-10-13 14:46:08 Build_Problem Closed Makefile pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make'
6e1086fb2c 2011-10-13 14:23:58 Code_Defect Closed Unknown "create table as select" and "pragma *_column_names"
991789d9f3 2011-10-13 14:12:28 Code_Defect Fixed Extensions ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8.
35c54c8749 2011-10-13 14:05:45 Code_Defect Fixed Unknown Some os win symbols should be declared static
aa92c76cd4 2011-10-13 13:53:26 Code_Defect Fixed Code_Generator Problem with GROUP BY and the distinction between real and integer values
43d2aa29b9 2011-10-13 13:52:50 Documentation Closed Documentation H13015 needs to be completed
4776dee07a 2011-10-13 13:52:23 Documentation Closed Documentation Documentation and code about registering functions
ac55d88a33 2011-10-13 13:35:04 Documentation Closed Unknown H10336 is no longer applicable
2466653295 2011-10-13 13:34:18 Code_Defect Fixed Shell Various dump issues
517e206abd 2011-10-13 13:25:17 Code_Defect Fixed Utilities Fix sqlite3_analyzer
5483170346 2011-10-13 13:24:46 Documentation Closed Documentation H35230 & H35240 refer incorrectly to H35230 - should be H35220
cbd054fa6b 2011-10-13 13:23:15 Code_Defect Closed Unknown "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2
9d68c88313 2011-10-13 13:22:24 Code_Defect Fixed Pager Database corruption following OOM fault
26ff0c82d1 2011-10-13 13:21:53 Code_Defect Fixed Unknown Incorrect result when using unnamed "?" bindings
fc62af4523 2011-10-13 13:19:41 Code_Defect Fixed Pager Executing "PRAGMA journal_mode" may delete journal file while it is in use.
54844eea3f 2011-10-13 13:16:48 Code_Defect Fixed Code_Generator Incorrect caching of sub-query results in the FROM clause of a scalar sub-query.
e59bdf6116 2011-10-13 13:15:34 Code_Defect Fixed Unknown Possible database corruption following EINTR on unix
af95b8c609 2011-10-13 13:13:57 Code_Defect Fixed Utilities Vacuuming a WAL database resets the file header read and write versions to 1.
ee19e690ec 2011-10-13 00:42:03 Code_Defect Fixed Shell If shell is interrupted while dumping it still produces commit (and invalid dump)
7d32c69b50 2011-10-13 00:11:47 Code_Defect Fixed Unknown sqlite3LoadExtension truncates file names
20f9d4fbbf 2011-10-12 23:50:07 Code_Defect Fixed Unknown sqlite3_overload_function ignores errors
0b803bff85 2011-10-12 23:14:14 Code_Defect Fixed VFS Return (error code) of xCurrentTime is always ignored
c48d99d690 2011-09-30 12:19:35 Code_Defect Closed Code_Generator Crash in "INSERT INTO ... SELECT" when "PRAGMA count_changes=1" is configured
d1d84037b9 2011-09-28 01:11:07 Feature_Request Fixed Shell import doesn't work on attached databases due to unnecessary quoting
bd484a090c 2011-09-19 20:43:56 Code_Defect Closed Extensions Date/time functions do not detect failure of localtime_r()
1a1308d253 2011-09-19 17:38:04 Code_Defect Closed Unknown Nested correlated subquery fails when indices used
002caede89 2011-09-19 17:37:54 Code_Defect Closed Unknown LEFT JOIN with OR terms in WHERE clause causes assertion fault
d635236375 2011-09-19 17:37:47 Code_Defect Closed Unknown Assertion fault on a join with a repeated column
6c14288a47 2011-09-19 17:37:38 Code_Defect Closed Unknown Virtual tables do not handle IS NOT NULL correctly
d6ddba6706 2011-09-19 17:37:30 Code_Defect Closed Unknown Parser accepts invalid CREATE TRIGGER syntax
25ee812710 2011-09-19 17:37:21 Code_Defect Closed Unknown PRAGMA case_sensitive_like=1 fails
91e2e8ba6f 2011-09-19 17:37:12 Code_Defect Closed Unknown Automatic indices cause undesirable type conversions
56be976859 2011-09-14 11:16:23 Code_Defect Closed Extensions Buffer overrun in FTS prefix queries
b1d3a2e531 2011-08-22 17:49:43 Code_Defect Closed Code_Generator Erroneous FK constraint failure when dropping table.
534aa198e1 2011-07-14 11:38:10 Build_Problem Closed Unknown Build error: missing manifest.uuid file in 3.7.4 downloadable source code
2d1a5c67df 2011-05-19 01:28:33 Code_Defect Fixed Pager Data loss on COMMIT in WAL mode
6284df89de 2011-04-24 23:02:35 Code_Defect Fixed Unknown INSERT INTO ... SELECT bypasses foreign key constraint checks
bb3a86e890 2011-04-13 13:48:30 Code_Defect Fixed Unknown SQLITE_FCNTL_SIZE_HINT overflows an array
83ea97620b 2011-03-30 14:54:18 Code_Defect Fixed Unknown ANALYZE on empty tables prevents the use of indices
f7b4edece2 2011-03-19 02:04:24 Code_Defect Fixed Unknown sqlite3_update_hook gives incorrect table name with shared cache
b72787b1a7 2011-02-22 05:24:39 Code_Defect Fixed Virtual_Machine Expiry mechanism causes incorrect collateral damage
eebb8a2803 2011-02-21 18:41:30 Build_Problem Closed Other Inconsistent amalgamation zip archive file names
752e1646fc 2011-02-11 20:54:35 Code_Defect Fixed Unknown Wrong result if DISTINCT used on subquery which uses ORDER BY.
89b8c9ac54 2011-02-10 19:24:13 Code_Defect Fixed B-Tree False reports of corruption after writing db with two different versions (3.7 and 3.6).
77aa3b1e65 2011-02-10 19:23:56 Code_Defect Fixed Unknown Segfault on automatic index using unknown collating function
9013e13dba 2011-02-04 00:53:22 Code_Defect Fixed Unknown ATTACH authorization fails when database name is not a literal
5d863f876e 2011-01-27 14:33:00 Code_Defect Fixed Unknown DB corruption following rollback-WAL-VACUUM-rollback
80ba201079 2010-12-07 15:10:31 Code_Defect Fixed Code_Generator Bug involving subqueries and the OR optimization
860399cc40 2010-10-12 02:13:48 Code_Defect Fixed Unknown Potential memory leak in sqlite3_bind_text()
a04e42a3fc 2010-10-11 18:53:54 Code_Defect Fixed Unknown Memory leak in sqlite3_create_collation_v2()
0322cd49c0 2010-10-11 04:23:46 Feature_Request Fixed Virtual_Machine create_function_v2 that takes destructor
38cb5df375 2010-10-06 19:14:07 Code_Defect Fixed Unknown LIMIT ignored on compound query with subqueries
3998683a16 2010-09-30 17:34:38 Code_Defect Fixed Utilities Some valid floating-point literals are not recognized.
8454a207b9 2010-09-30 14:48:22 Code_Defect Fixed Code_Generator ALTER TABLE ADD COLUMN with negative DEFAULT value
b351d95f9c 2010-09-28 07:21:50 Code_Defect Fixed Code_Generator Bug in "INSERT INTO ... SELECT" statements that use CASE
313723c356 2010-09-18 19:37:16 Code_Defect Fixed Pager Database corruption following an I/O error on xShmLock
5e10420e8d 2010-08-23 17:08:42 Code_Defect Fixed Unknown Free-list corruption in incremental-vacuum mode
e4b8a2ba6e 2010-08-13 16:50:01 Code_Defect Closed Code_Generator Problem with DISTINCT in sub-queries in a FROM clause.
13f033c865 2010-08-05 03:24:23 Code_Defect Fixed Code_Generator Performance regression
51ae9cad31 2010-08-04 11:40:07 Code_Defect Fixed B-Tree Database corruption by alternating writes from 3.7.0 and 3.6.23
c38baa3d96 2010-08-03 13:09:19 Code_Defect Fixed Code_Generator REPLACE on a CHECK constraint does not work as advertised
168d0f7176 2010-08-01 22:25:47 Code_Defect Fixed Unknown Segfault while reading database with a corrupt index
ce7c133ea6 2010-07-31 20:55:02 Code_Defect Fixed Code_Generator Foreign key constraint fails when it should succeed.
f3e5abed55 2010-07-30 11:37:32 Code_Defect Fixed Unknown Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction
c43940c49b 2010-07-29 10:08:14 Code_Defect Fixed Virtual_Machine sqlite3_profile gives milliseconds (was nanoseconds in earlier releases)
8011086c85 2010-07-28 02:53:54 Code_Defect Fixed Code_Generator Query planner creates unnecessary and expensive automatic index
4711020446 2010-07-22 17:50:14 Feature_Request Fixed Unknown should use collate nocase index even if column isn't declared nocase
e090183531 2010-07-22 12:34:28 Feature_Request Fixed Unknown like should use index when pattern has no wildcard
30349e0f68 2010-07-19 05:00:53 Code_Defect Closed Extensions Yet more FTS3 symbols need to be made private
80e031a00f 2010-07-14 18:24:26 Code_Defect Fixed Code_Generator Result of IN should never be NULL if the RHS is empty
d11f09d36e 2010-06-26 19:03:53 Code_Defect Closed Pager Cache corruption caused by ROLLBACK with synchronous=NORMAL
f973c7ac31 2010-06-09 16:16:29 Code_Defect Fixed Unknown Incorrect affinity for indexed range constraint
dd08e5a988 2010-05-14 19:24:22 Code_Defect Fixed Unknown Foreign key constraint fails to prevent consistency error.
51914f6acd 2010-05-13 23:00:39 Performance_Issue Fixed Unknown nRef and owner should be #ifdef SQLITE_DEBUG
3dbdcdb14e 2010-04-30 21:03:59 Code_Defect Fixed Code_Generator Assertion fault using indices with redundant columns
c39ff61c43 2010-04-30 06:00:18 Code_Defect Closed Virtual_Machine Erroneous FK constraint failure when reusing statement
bb1977f6e9 2010-04-22 12:08:03 Code_Defect Closed Unknown Concatenation can create very invalid strings
02a8e81d44 2010-04-15 23:26:14 Code_Defect Fixed Code_Generator LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly
883034dcb5 2010-03-31 15:11:24 Code_Defect Closed Code_Generator Column cache problem with aggregate queries
e063139eb3 2010-03-31 11:57:19 Build_Problem Fixed Makefile Download .zip excludes shell but .tar includes it
f3162063fd 2010-03-30 13:43:33 Code_Defect Closed Code_Generator Crash compiling "INSERT INTO tbl DEFAULT VALUES" if tbl has BEFORE or INSTEAD OF triggers.
7d96113ff0 2010-03-27 16:52:27 Build_Problem Fixed Makefile SQLite fails to build when TCL isn't installed
015d3820f2 2010-03-22 17:47:02 Code_Defect Closed Pager Missing call to xSync() following rollback.
dd3ba6063a 2010-03-19 19:11:13 Code_Defect Closed Extensions rtree module does not support last_insert_rowid()
b1552d0fa7 2010-03-18 16:35:14 Code_Defect Fixed Extensions Symbols not declared private that should be
170872f1c3 2010-03-15 20:53:18 Code_Defect Fixed Unknown Unmatched double-quote causes problems for FTS3
42d45a693e 2010-03-15 19:28:20 Code_Defect Fixed Unknown Spurious log message from FTS3
9abd6aa831 2010-03-04 18:00:15 Code_Defect Closed Utilities buffer overread in sqlite3_printf functions.
ebdbadade5 2010-02-27 12:30:49 Code_Defect Fixed Unknown LEFT JOIN incorrect when ON clause does not reference right table.
d2f02d37f5 2010-02-24 15:11:51 Code_Defect Fixed Unknown Assertion fault on UPDATE involving two virtual tables.
da1151f97d 2010-02-22 23:19:40 Code_Defect Fixed Unknown Assertion fault on VACUUM in an auto_vacuumed database.
e9a9fde1f4 2010-02-16 11:00:22 Code_Defect Fixed Extensions rtree module malfunctions if db page-size is changed
13336e9c3c 2010-02-15 18:05:25 Code_Defect Fixed Unknown ALTER TABLE RENAME fails to update foreign key references
985771e116 2010-02-15 16:55:27 Code_Defect Fixed Unknown CREATE TRIGGER confused by TEMP/MAIN table name overlap
8905af11a0 2010-02-02 20:53:40 Code_Defect Closed Unknown NOT NULL interferes with ON CONFLICT REPLACE
b80eeab588 2010-01-26 01:26:13 Feature_Request Fixed Unknown Respect custom page size for temp tables, indices, etc
1258875e07 2010-01-21 23:13:44 Code_Defect Fixed Unknown Undefined collating sequence on LIKE causes segfault
eb620916be 2010-01-18 18:16:31 Code_Defect Fixed Shell Shell doesn't print header if multiple statements on one line
eb942c64a1 2010-01-13 13:24:21 Code_Defect Fixed Unknown PRAGMA reverse_unordered_selects causes schema parse to fail
f51d950180 2010-01-13 08:26:00 Compiler_Warning Closed Unknown memset warning with gcc 4.3.3
360c6073e1 2010-01-07 15:17:33 Code_Defect Fixed Code_Generator Aggregate MAX() function with COLLATE clause
0d676cd6e6 2009-12-30 12:42:11 Code_Defect Closed Code_Generator Triggers: new/old.oid is interpreted as the IPK, even if there is another column "oid"
34d2ae1c6d 2009-12-29 23:39:46 Code_Defect Fixed Unknown Overloaded column named "ROWID" mishandled in triggers.
eb5548a849 2009-12-24 16:01:52 Code_Defect Fixed Unknown CAST in WHERE clause causes inconsistent query results
356c885b0b 2009-12-17 22:18:22 Code_Defect Fixed Other sqlite3_complete() should return 0 on empty string
31338dca7e 2009-12-16 22:11:58 Code_Defect Fixed Unknown OR operator in WHERE clause gives wrong answer when indexed
f74beaabde 2009-12-09 18:23:30 Code_Defect Fixed Code_Generator Problem with 3-way joins and the USING clause
ff44d82f3b 2009-12-09 05:31:06 Code_Defect Closed Extensions fts3ReallocOrFree and fts3InitVtab are not marked static
4abd1e4c00 2009-12-08 14:43:11 Documentation Fixed Documentation omitted.html still says recursive triggers are not supported
78e04e52ea 2009-12-08 14:34:50 Code_Defect Fixed Virtual_Machine Assertion failure dropping table with zero length name
abe728bbc3 2009-12-08 13:46:27 Code_Defect Fixed Virtual_Machine Crash committing multi-file transaction including temp file
97214a34d8 2009-12-01 14:32:00 Code_Defect Fixed VFS Use of os2MutexNotheld before their definition
16fbf14cb2 2009-11-23 21:24:42 Code_Defect Fixed Unknown Faulty VDBE code generated for certain third-party virtual tables
564d412f15 2009-11-20 18:51:24 Code_Defect Fixed Unknown OOM on autovacuum of in-memory database causes problems.
3211d778c0 2009-11-16 20:59:45 Feature_Request Closed Unknown replace function works on blobs
e123bd2242 2009-11-16 13:24:31 Feature_Request Closed VFS File handles aren't always immediately released on sqlite3_close
6b00e0a34c 2009-11-16 12:51:04 Code_Defect Fixed Code_Generator The great OP_If bug
702bbe755b 2009-11-16 12:47:18 Code_Defect Closed Code_Generator Invalid VDBE program built if ORDER BY used
29ab7be99f 2009-11-16 12:43:18 Code_Defect Fixed Code_Generator Hitting NOT NULL constraint does not roll back statement transaction
58a75d62e0 2009-11-16 12:42:07 Incident Closed Unknown encoding failure
98f156c79b 2009-11-16 12:41:06 Incident Closed Unknown  
60f26ed786 2009-11-16 12:27:46 Code_Defect Closed Unknown Empty Title
f5cb008a65 2009-11-11 04:17:15 Code_Defect Fixed Shell Shell silently ignores extra parameters
aeff892c57 2009-11-10 17:07:53 Code_Defect Fixed Shell -batch mode not creating DB in CLI
f12a9eeedc 2009-11-06 17:22:36 Code_Defect Fixed Shell Shell command argument parsing is lax
0bf974bdf9 2009-11-06 04:15:47 Code_Defect Fixed Extensions backup api asserts with zero length source file
aad47726e9 2009-10-28 18:23:20 Feature_Request Closed Unknown Generator of sqlite3UpperToLower&#91;&#93; and sqlite3CtypeMap&#91;&#93; for single lang
d82e3f3721 2009-10-26 08:30:31 Code_Defect Fixed Virtual_Machine VACUUM corrupts database when MAIN and TEMP table names overlap.
2cb66577f6 2009-10-24 02:06:16 Code_Defect Fixed Shell Diagnostic message is unintentionally printed in batch mode
6da68f691b 2009-10-24 02:00:11 Code_Defect Fixed Shell tables says you provide a like pattern but it adds % in code
3fe897352e 2009-10-24 01:48:05 Code_Defect Fixed Unknown Malformed UTF16 leads to a 2-byte buffer overread
f80d443a3b 2009-10-23 12:22:27 Documentation Closed B-Tree pragma cache size doesn report actual size (min is 10)
beb2dd69ad 2009-10-23 01:27:32 Code_Defect Fixed Shell do_meta_command inconsistent return values
bd770b2c52 2009-10-23 00:37:10 Code_Defect Fixed Shell shell doesn't return error exit code on import errors
7b61b6c6ce 2009-10-22 21:27:32 Code_Defect Fixed Shell insert mode is incorrectly converting text to numbers
72adc99de9 2009-10-22 21:27:19 Code_Defect Fixed Shell shell mode insert doesn't output blobs as blobs
dc3a6e5b31 2009-10-21 14:09:03 Code_Defect Fixed Shell Shell doesn't htmlify column headers
6f8b0c5855 2009-10-21 13:50:42 Code_Defect Fixed Shell Some minor genfkey fixups
39c85e8a4e 2009-10-21 03:56:00 Code_Defect Fixed VFS FormatMessage incorrectly used (Windows VFS)
89668ca167 2009-10-21 03:55:40 Feature_Request Fixed Shell shell can support .timer on Windows
43db771bb2 2009-10-21 03:55:12 Code_Defect Fixed Shell Sqlite shell prints some error messages to stdout
8440a8e22f 2009-10-20 18:13:01 Code_Defect Closed Unknown LENGTH & QUOTE stop at first zero
f9af981dd2 2009-10-20 15:28:27 Documentation Fixed Documentation sqlite3_shutdown documentation needs to mention danger
1751725cd6 2009-10-20 14:24:28 Documentation Fixed Documentation sqlite_close doc should qualify advice
8d510499cc 2009-10-20 13:27:15 Code_Defect Closed Parser Repreparation errors are always returned as SQLITE_SCHEMA
b73fb0bd64 2009-10-19 21:05:11 Code_Defect Fixed Unknown Natural self-join defect
897b96d49d 2009-10-19 11:43:27 Code_Defect Deferred Extensions SQLITE_CANTOPEN when using journal_mode=persist and async IO
94c04eaadb 2009-10-19 10:04:01 Code_Defect Closed Extensions Crash in asyncRead() with large (>2GB) database file
f777251dc7 2009-10-16 20:55:03 Code_Defect Fixed B-Tree Assertion fault following ROLLBACK with running queries
5ee23731f1 2009-10-13 15:44:37 Code_Defect Fixed Virtual_Machine assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements
8550ecca70 2009-10-07 23:43:40 Code_Defect Fixed VFS findLockInfo uses memcmp on non-zeroed, = assigned struct
668fe22637 2009-09-29 18:26:41 Feature_Request Closed Parser pragma table_info doesn't accept database names
cff1a52937 2009-09-26 14:20:52 Code_Defect Closed Unknown sqlite3_get_table() returns wrong result when using where clause
d77ffcd7a5 2009-09-26 13:57:05 Code_Defect Closed Shell Memory leak on failing INSERT statements on tables with UNIQUE INDEX
860d129c15 2009-09-25 10:35:42 Build_Problem Closed Unknown builds with sqlite 3.6.18 depends on tchsh
f7e3d17a34 2009-09-25 02:01:35 Support_Request Closed Unknown Memory accumulate without commit
4a03edc4c8 2009-09-24 18:42:02 Code_Defect Fixed Code_Generator Index corruption following aggressive use of ON CONFLICT clause.
c9394a56c7 2009-09-24 12:25:43 Support_Request Closed Parser Sqlite reading all column data on selects.
0bc616a2c8 2009-09-22 13:32:09 Build_Problem Closed Other In wince 6.0, I can not compile sqlite.
a8b1e82b8f 2009-09-22 13:00:57 Code_Defect Closed Unknown CAST failing for numeric
56928bd084 2009-09-21 16:34:44 Build_Problem Closed Utilities Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2
c472df6c1c 2009-09-21 16:14:51 Code_Defect Closed Unknown Segmentation fault by instead of insert triggers
1ff6d29030 2009-09-21 16:08:20 Build_Problem Closed Utilities Compile fails with SQLITE_OMIT_TRIGGER
f76cabebfd 2009-09-17 21:22:06 Feature_Request Closed Extensions xBestIndex/xFilter slight interface improvement
e25d9ea771 2009-09-17 00:47:07 Code_Defect Fixed Unknown Cascading delete trigger fails.
832b2f3e6e 2009-09-16 12:10:09 Code_Defect Closed Unknown integrity_check error after backup restore
127c1c42ff 2009-09-15 12:30:45 Build_Problem Closed Makefile Build error "C compiler cannot create executables" on debian lenny host
a696379c1f 2009-09-15 00:03:19 Code_Defect Fixed Unknown Access violation error trying to insert into triggered view
03b198a2fa 2009-09-14 16:50:08 Compiler_Warning Fixed VFS Getting several warnings when compiling in eVC++ 4
806f3be2d7 2009-09-14 15:35:28 Feature_Request Closed B-Tree Proposal to inline some functions
8c743979c2 2009-09-12 16:29:19 Code_Defect Closed Unknown SQLite version correction on LIKE operator + ORDER BY bug I reported earlier today
9a502b7a35 2009-09-12 04:06:08 Documentation Fixed Unknown datetime function has year 54079 bug
65bbb65a47 2009-09-11 18:04:37 Build_Problem Fixed Unknown 'configure' file without +x permission in sqlite-3.6.18.tar.gz tarball
4b81075908 2009-09-09 14:31:32 Code_Defect Closed Unknown In mult-thread that have a problem of updata lost
9fd0bc3663 2009-09-09 14:26:04 Feature_Request Fixed Unknown Add a new open flag to enable shared cache for a single db connection
3350da7d35 2009-09-09 12:50:52 Code_Defect Closed Unknown Error: malformed database schema - near "VIRTUAL": syntax error
df2c3ad12a 2009-09-07 14:43:17 Code_Defect Fixed Extensions free() on unallocated memory when fts3 match phrase contains terms after "-" modifier
cbb5a315df 2009-09-06 00:56:01 Feature_Request Closed Parser Concatenating strings should be possible with a plus '+' operator
2ea2425d34 2009-09-03 01:26:42 Code_Defect Fixed Code_Generator Assertion fault: Text encoding mismatch on value comparison
44a1b817c3 2009-09-01 15:23:50 Incident Closed Unknown Problem with Kaspersky Anti-Virus and SQLite
d2b46cfc75 2009-08-24 12:17:14 Code_Defect Closed Pager sqlite3BitvecClear will clear all bit in aHash when iSize>BITVEC_NBIT
efc02f9779 2009-08-24 01:37:18 Code_Defect Fixed Unknown Trigger creation order affects query correctness
fc6f41426b 2009-08-21 08:37:23 Incident Closed Unknown update primary key failure
92c5deed07 2009-08-19 15:22:53 Code_Defect Closed Extensions FTS3 bug with multiple terms for exclusion
93fb9f89d6 2009-08-19 15:21:05 Code_Defect Fixed Code_Generator Index causes incorrect WHERE clause evaluation
2d401a9428 2009-08-18 16:13:02 Code_Defect Fixed Unknown Segfault on unknown SQL function