# |
Status |
Created |
By |
Subsys |
Due Date |
SCR |
Assigned |
Svr |
Pri |
Title |
|
2340 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
"./configure && make testfixture" link problem
|
edit |
1947 |
active
|
2006 Aug
|
anonymous
|
Shell
|
Pending
|
|
|
3
|
3
|
".mode insert" works bad with BLOBs
|
edit |
2076 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
a.rottmann
|
1
|
1
|
% exists as value in varchar
|
edit |
2376 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
-batch doesn't work soon enough
|
edit |
2396 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
|
|
1
|
3
|
-column output truncates characters from varchar field.
|
edit |
2022 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
.import command is not working
|
edit |
2842 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
.import does not recongnise NULL values
|
edit |
1455 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
|
|
3
|
2
|
.import error: comma inside a string is read as field separator
|
edit |
1397 |
new
|
2005 Aug
|
anonymous
|
Shell
|
Pending
|
|
|
1
|
1
|
.mode csv creates ASCII output instead of UTF-8
|
edit |
1451 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
|
|
4
|
3
|
.mode insert does not output BLOBs in an usable way
|
edit |
698 |
active
|
2004 Apr
|
anonymous
|
Unknown
|
|
|
|
1
|
3
|
.mode list - not going to next line
|
edit |
1946 |
new
|
2006 Aug
|
anonymous
|
Unknown
|
New
|
|
|
2
|
2
|
.read file fails on blob fields with end-of-file char
|
edit |
2634 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
.schema uses incorrect ORDER BY giving wrong dependency order
|
edit |
735 |
active
|
2004 May
|
anonymous
|
Shell
|
|
|
|
4
|
3
|
.sqliterc not processed if running on a driver other than C:
|
edit |
2413 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
|
drh
|
1
|
1
|
1 bug and 2 suggestions in lemon
|
edit |
1461 |
active
|
2005 Sep
|
anonymous
|
Unknown
|
Pending
|
|
drh
|
1
|
2
|
3.2.7 DLL can not deal File paths with international characters
|
edit |
1365 |
active
|
2005 Aug
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
64 bit types not completely overridable
|
edit |
1790 |
active
|
2006 May
|
anonymous
|
Pager
|
Pending
|
|
|
3
|
3
|
:memory: performance difference between v2 and v3
|
edit |
1743 |
active
|
2006 Mar
|
anonymous
|
Parser
|
Pending
|
|
|
3
|
3
|
A very very deep IN statement failure
|
edit |
2096 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
ATTACH DATABASE returns SQLITE_ERROR when database is locked
|
edit |
2914 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
|
edit |
2032 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
AV in btree.c running FTS2 compiled with SQLITE_OMIT_SHARED_CACHE
|
edit |
1447 |
active
|
2005 Sep
|
anonymous
|
BTree
|
Pending
|
|
|
1
|
1
|
Abnormal program termination in src/btree.c line 1339
|
edit |
1867 |
active
|
2006 Jun
|
anonymous
|
BTree
|
Pending
|
|
|
1
|
3
|
Access Violation after set a new page_size
|
edit |
2684 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Accessing sqlite from an NT service will lock the complete databse.
|
edit |
2084 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
4
|
3
|
Add API function mapping column decl string to SQLite type
|
edit |
2131 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
Add substring() function (Part of SQL 99)
|
edit |
2908 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Add support to examine whether statements modify the database
|
edit |
2902 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
drh
|
3
|
3
|
Add watch support to SQLite
|
edit |
2911 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
Adding parentheses to a FROM clause
|
edit |
2652 |
active
|
2007 Sep
|
drh
|
|
Pending
|
|
|
1
|
1
|
Aggregate function cannot be used from within a subquery
|
edit |
2791 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Allow building FTS[123] as part of sqlite library with configure
|
edit |
1382 |
active
|
2005 Aug
|
anonymous
|
|
Pending
|
|
drh
|
1
|
1
|
Assert nErr==0 on corrupt db
|
edit |
2013 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
drh
|
4
|
3
|
Autoincrement increments on failing INSERT OR IGNORE
|
edit |
2408 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
|
|
2
|
1
|
BLOBs not output correctly in .mode insert (shell.c - isnumber)
|
edit |
1573 |
active
|
2005 Dec
|
anonymous
|
Shell
|
Pending
|
|
|
3
|
3
|
Bad CSV output when data contains double quotes
|
edit |
1489 |
active
|
2005 Oct
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
Bad permissions on install-sh prevent 'make install' from completing
|
edit |
783 |
active
|
2004 Jun
|
anonymous
|
Unknown
|
|
|
|
3
|
3
|
Build on MAC with -DSQLITE_DEBUG=1 compile error
|
edit |
2761 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
CLI (shell.c) should be bundled with amalgamation
|
edit |
1797 |
active
|
2006 May
|
anonymous
|
TclLib
|
Pending
|
|
drh
|
1
|
1
|
COPY command doesn't work in tclsqlite 3.3.5
|
edit |
1312 |
active
|
2005 Jun
|
anonymous
|
Shell
|
Pending
|
|
|
1
|
1
|
CSV file import / export is all wrong!
|
edit |
1900 |
active
|
2006 Jul
|
anonymous
|
Unknown
|
Pending
|
|
a.rottmann
|
1
|
1
|
CURRENT_TIMESTAMP keyword not inserting UTC date in column
|
edit |
301 |
active
|
2003 Apr
|
anonymous
|
Unknown
|
|
|
|
2
|
3
|
Can't acquire lock for database on Mac OS X AppleShare volume
|
edit |
2580 |
active
|
2007 Aug
|
anonymous
|
|
Pending
|
|
anonymous
|
1
|
2
|
Can't open a query if text to search is Greek
|
edit |
2547 |
active
|
2007 Aug
|
danielk1977
|
|
Pending
|
|
|
5
|
3
|
Changing db encoding of an attached db can confuse shared cache mode.
|
edit |
2543 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Chinese charset not support??
|
edit |
1488 |
active
|
2005 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Collate Reverse does not exists?
|
edit |
1142 |
active
|
2005 Feb
|
anonymous
|
Parser
|
Pending
|
|
danielk1977
|
1
|
1
|
Column names
|
edit |
1994 |
active
|
2006 Sep
|
anonymous
|
Parser
|
Pending
|
|
|
1
|
3
|
Columns from nested joins aren't properly propagated
|
edit |
1622 |
active
|
2006 Jan
|
danielk1977
|
|
Pending
|
|
|
1
|
1
|
Compiling with OMIT_PRAGMA causes an error in the test suite
|
edit |
1487 |
active
|
2005 Oct
|
anonymous
|
BTree
|
Pending
|
|
|
1
|
3
|
Corrupt database causes indefinite loop in sqlite3_step()
|
edit |
2363 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Couldn't build 3.3.17 on Cygwin/Vista
|
edit |
2219 |
active
|
2007 Feb
|
shess
|
|
Fixed
|
|
shess
|
2
|
2
|
Creating an fts table in an attached database works wrong.
|
edit |
1546 |
active
|
2005 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Creating unique index on non-unique column leads to corr. on SQLite2
|
edit |
2017 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
|
edit |
1816 |
active
|
2006 May
|
anonymous
|
VDBE
|
Pending
|
|
|
1
|
2
|
Database corruption with pragma auto_vacuum
|
edit |
2409 |
active
|
2007 Jun
|
anonymous
|
|
New
|
|
drh
|
1
|
1
|
Database malformed with SQLite3.3.17 on WindowsXP
|
edit |
2089 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Decouple sqlite_int64 from other 64bit datatypes
|
edit |
1255 |
active
|
2005 May
|
anonymous
|
|
Pending
|
|
|
4
|
3
|
Decrease number of warnings with Microsoft Visual C++
|
edit |
1948 |
active
|
2006 Aug
|
anonymous
|
Shell
|
Pending
|
|
|
2
|
3
|
Double quotes are not escaped in csv mode
|
edit |
1954 |
active
|
2006 Sep
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
Dual Core Processor Lockup
|
edit |
1735 |
active
|
2006 Mar
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
3
|
Encoding problem
|
edit |
2303 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Encrypted databases: No page cache due to problem in pagerSharedLock
|
edit |
2014 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
anonymous
|
4
|
3
|
Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE
|
edit |
1458 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
|
|
2
|
2
|
Error at .importing in csv format (another)
|
edit |
1445 |
active
|
2005 Sep
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Errors testing sqlite 3.2.6 (& v3.3.7)
|
edit |
2011 |
active
|
2006 Oct
|
anonymous
|
|
New
|
|
|
3
|
2
|
Escaping Porblem with .mode insert (double apostrophe)
|
edit |
2288 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
|
4
|
2
|
FTS does not support REPLACE
|
edit |
2512 |
active
|
2007 Jul
|
shess
|
|
Pending
|
|
|
1
|
1
|
FTS virtual table name quoting problem
|
edit |
2046 |
active
|
2006 Oct
|
anonymous
|
|
Fixed
|
|
shess
|
1
|
1
|
FTS1 - Error closing database due to unfinished statements
|
edit |
2019 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
FTS1: Create table in transaction raises Out of Sequence error (21)
|
edit |
1992 |
active
|
2006 Sep
|
anonymous
|
|
Fixed
|
|
shess
|
1
|
1
|
FTS1: Problems after dropping utility tables
|
edit |
2028 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
4
|
2
|
FTS1: UNIQUE() expression and UPDATE command not working
|
edit |
2865 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
|
1
|
2
|
FTS3 does not build with amalgamation in CVS
|
edit |
2027 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
FTS: Phrase searches return Offsets for individual phrase words
|
edit |
2171 |
review
|
2007 Jan
|
anonymous
|
|
Fixed
|
|
drh
|
3
|
3
|
Fix a major leakage of token minors in lemon generated parsers
|
edit |
1953 |
active
|
2006 Sep
|
anonymous
|
TclLib
|
Pending
|
|
|
4
|
3
|
Fix for false 64-bit comparisons "make test" failures on Cygwin
|
edit |
2100 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Fixes for SQL lower() and upper()
|
edit |
2825 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
FormatMessage (win32) should use extra flag and convert from Unicode
|
edit |
2857 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
GROUP BY cost estimate wrong with WHERE clause
|
edit |
2873 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make
|
edit |
1700 |
active
|
2006 Mar
|
anonymous
|
Parser
|
Pending
|
|
|
2
|
2
|
Handling column names for aliased queries is broken
|
edit |
1809 |
active
|
2006 May
|
anonymous
|
CodeGen
|
Pending
|
|
|
1
|
3
|
Huge slowdown/increased memory use when using GROUP BY on big dataset
|
edit |
1983 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
I/O Error at a size of 4GB and auto_vacuum=1
|
edit |
2627 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
Improper parsing of nested JOIN
|
edit |
2075 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Improve VACUUM speed and INDEX page locality
|
edit |
2511 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
drh
|
3
|
2
|
Inconsistent Pragma output
|
edit |
2859 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
drh
|
3
|
2
|
Inconsistent column names with DISTINCT
|
edit |
2383 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
Inconsistent conversion of BLOB revisited
|
edit |
1804 |
active
|
2006 May
|
anonymous
|
Unknown
|
Pending
|
|
|
4
|
3
|
Inconsistent value type returned by SUM when using a GROUP BY
|
edit |
1598 |
review
|
2006 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
Incorrect case-insensitive comparison of non-latin UTF-8 characters
|
edit |
2066 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
Incorrect error message in the case of ENOLCK
|
edit |
684 |
active
|
2004 Apr
|
anonymous
|
Unknown
|
|
|
|
3
|
2
|
Incorrect function result type when using SQLITE_ARGS
|
edit |
1980 |
active
|
2006 Sep
|
drh
|
|
Pending
|
|
|
1
|
1
|
Initializing FTS1 twice causes it to fail.
|
edit |
2907 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Issues of sqlite3 with Windows Mobile 5/6
|
edit |
1960 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
|
|
4
|
2
|
Issues with .import in sqlite.exe
|
edit |
2875 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
LIKE does not work with lowercase swedish characters
|
edit |
2898 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Latest CVS for 3.5.4 fails to build test1.c
|
edit |
1063 |
active
|
2005 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
3
|
Lemon bug: Strings in rule code should not be interpreted
|
edit |
1078 |
active
|
2005 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
Lemon destructor bugs that don't affect sqlite
|
edit |
1522 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
3
|
Make test fails in manydb 1.82-3.299 mac os x 10.4.3 ppc
|
edit |
2328 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Makefile sqlite3.c target breakage for C++
|
edit |
2753 |
active
|
2007 Nov
|
anonymous
|
|
New
|
|
drh
|
3
|
3
|
Master journal files sometimes not deleted
|
edit |
2878 |
active
|
2008 Jan
|
anonymous
|
|
Fixed
|
|
|
1
|
1
|
Memory leaks with latest CVS [4693]
|
edit |
2491 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Mingw Warnings w/ 3.4.0 Amalgamation
|
edit |
923 |
active
|
2004 Sep
|
anonymous
|
|
Pending
|
|
anonymous
|
3
|
2
|
Missing quotes in 2.8.15 .dump cause data loss when loading in sqlite3
|
edit |
2558 |
active
|
2007 Aug
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
Multiple JOIN USING() gives incorrect results
|
edit |
1504 |
active
|
2005 Nov
|
anonymous
|
Pager
|
Pending
|
|
|
1
|
3
|
Multithreaded DB lock not released using Begin/Commit between threads
|
edit |
1850 |
active
|
2006 Jun
|
anonymous
|
Unknown
|
Pending
|
|
|
2
|
1
|
NUMERIC data type ERROE when read on uClinux
|
edit |
1791 |
active
|
2006 May
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
Native threads support for BeOS
|
edit |
1878 |
active
|
2006 Jun
|
anonymous
|
CodeGen
|
Pending
|
|
|
2
|
3
|
No index used when specifying alias name in ORDER BY clause
|
edit |
2183 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
|
drh
|
1
|
1
|
OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
|
edit |
2388 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
1
|
3
|
ORDER BY fails on compound select
|
edit |
1742 |
active
|
2006 Mar
|
anonymous
|
Unknown
|
Pending
|
|
drh
|
2
|
3
|
ORDER BY on more than one column causes a big slowdown
|
edit |
1521 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
2
|
ORDER BY sorts incorrectly with aliased fields
|
edit |
691 |
active
|
2004 Apr
|
anonymous
|
Unknown
|
|
|
drh
|
1
|
1
|
OS X File Sharing
|
edit |
2809 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
PRAGMA collation_list shows unregistered collations
|
edit |
969 |
new
|
2004 Oct
|
anonymous
|
TclLib
|
Pending
|
|
|
3
|
3
|
PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so part 2
|
edit |
2122 |
review
|
2006 Dec
|
anonymous
|
|
Fixed
|
|
|
1
|
3
|
Potential wrong string could stay in with convertUtf8Filename
|
edit |
1861 |
active
|
2006 Jun
|
anonymous
|
Pager
|
Pending
|
|
|
1
|
1
|
Problem in using Triggers and multithreading
|
edit |
608 |
active
|
2004 Feb
|
anonymous
|
|
|
|
|
3
|
3
|
Problem with "pragma show_datatypes = on" and busy timeout
|
edit |
2770 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Problem with BLOB in 3.5.x ?
|
edit |
1213 |
active
|
2005 Apr
|
anonymous
|
Parser
|
Pending
|
|
|
3
|
2
|
Problem with alias columns in subqueries
|
edit |
2077 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
2
|
1
|
Problems with using ASCII symbols 0x80 - 0xFF in database path
|
edit |
154 |
active
|
2002 Sep
|
drh
|
Pager
|
|
|
drh
|
3
|
3
|
Prohibit links on database files.
|
edit |
1415 |
active
|
2005 Sep
|
anonymous
|
Unknown
|
Pending
|
|
drh
|
1
|
1
|
Querying for BLOB type fields
|
edit |
2378 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
Quoted fields come back corrupted, using GROUP BY
|
edit |
1515 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
|
|
4
|
3
|
Quotes incorrect included in colum names.
|
edit |
2901 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
ROLLBACK and COMMIT statements should not expire
|
edit |
685 |
active
|
2004 Apr
|
anonymous
|
CodeGen
|
|
|
|
1
|
3
|
SELECT from a VIEW with GROUP BY
|
edit |
2708 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
|
|
4
|
2
|
SQL error:disk I/O error
|
edit |
2509 |
active
|
2007 Jul
|
anonymous
|
|
New
|
|
|
1
|
1
|
SQLITE_DATE
|
edit |
1053 |
active
|
2004 Dec
|
anonymous
|
Pager
|
Pending
|
|
|
3
|
3
|
SQLITE_IOERR and strange rollback when db is busy
|
edit |
1856 |
active
|
2006 Jun
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
SQLITE_OMIT_UTF16 breaks 'make test'
|
edit |
1862 |
active
|
2006 Jun
|
anonymous
|
TclLib
|
Pending
|
|
tclguy
|
1
|
1
|
SQLite cannot load/import data from file
|
edit |
2487 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
SQLite database locked error on NFS mounted home dir
|
edit |
700 |
active
|
2004 Apr
|
anonymous
|
VDBE
|
|
|
|
2
|
3
|
Solaris-sparc segfaults on sum()
|
edit |
2043 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Spaces in view statement
|
edit |
2037 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
|
edit |
2059 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Still missing .DEF file from Windows 3.3.8 source code distribution
|
edit |
2897 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
String or BLOB exceed size limit
|
edit |
1815 |
active
|
2006 May
|
anonymous
|
Parser
|
Pending
|
|
|
3
|
3
|
Support of W3C-DTF(ISO8601 subset) is incomplete
|
edit |
2766 |
active
|
2007 Nov
|
drh
|
|
Pending
|
|
|
1
|
1
|
TCL transaction started from within a query does not commit
|
edit |
2874 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c
|
edit |
1822 |
active
|
2006 May
|
anonymous
|
|
Duplicate
|
|
|
3
|
3
|
Table Alias together with Subquery seems not to work proper
|
edit |
2060 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Table references enclosed in parenthesis become "invisible"
|
edit |
1305 |
active
|
2005 Jun
|
anonymous
|
TclLib
|
Pending
|
|
|
1
|
1
|
Tcl installs pkgIndex with wrong path
|
edit |
2350 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Temp files not deleted on WinCE
|
edit |
369 |
active
|
2003 Jun
|
anonymous
|
|
|
|
|
3
|
2
|
Testsuite fails on btree-1.1.1 (Mac OS X, SQLite 2.8.4)
|
edit |
1541 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
Ticket #924 not fixed in the 2.8 branch
|
edit |
2010 |
active
|
2006 Oct
|
anonymous
|
|
Fixed_in_3.0
|
|
|
3
|
3
|
Timeout ignored in Shared-Cache locking model
|
edit |
1327 |
active
|
2005 Jul
|
ghaering
|
VDBE
|
Pending
|
|
|
2
|
3
|
UNION causes sqlite3_column_decltype to always return NULL
|
edit |
1851 |
active
|
2006 Jun
|
anonymous
|
Unknown
|
Pending
|
|
|
2
|
1
|
USE "ORDER BY" error on uClinux
|
edit |
2414 |
active
|
2007 Jun
|
anonymous
|
|
Unable_to_fix
|
|
|
1
|
1
|
Unable t
|
edit |
1351 |
active
|
2005 Aug
|
anonymous
|
Shell
|
Pending
|
|
|
1
|
1
|
Unable to parse UTF8 input
|
edit |
798 |
active
|
2004 Jul
|
anonymous
|
Unknown
|
|
|
|
1
|
1
|
Unable to run tests on Tru64 bit Linux platform
|
edit |
709 |
active
|
2004 Apr
|
anonymous
|
Unknown
|
|
|
drh
|
1
|
1
|
Unable to unregister or replace functions
|
edit |
2530 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
Unable to write to windows share, even with exclusive lock
|
edit |
1733 |
active
|
2006 Mar
|
anonymous
|
VDBE
|
Pending
|
|
drh
|
4
|
3
|
Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
|
edit |
2810 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Unregistered collation problems with simple subselects
|
edit |
1941 |
active
|
2006 Aug
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER
|
edit |
2126 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
3
|
1
|
Update hook not invoked when deleteing all rows from table
|
edit |
2879 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
anonymous
|
4
|
3
|
VACUUM enters temporary sequence numbers in sqlite_sequence
|
edit |
1149 |
active
|
2005 Feb
|
anonymous
|
|
Pending
|
|
|
2
|
1
|
VACUUM, DUMP/RESTORE fail in certain cases
|
edit |
2510 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Vacuum modified FTS2 rowids
|
edit |
1754 |
active
|
2006 Apr
|
anonymous
|
Pager
|
Pending
|
|
anonymous
|
2
|
2
|
Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
|
edit |
2127 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
Virtual tables do not always free zErrmsg
|
edit |
1502 |
active
|
2005 Oct
|
anonymous
|
Unknown
|
Pending
|
|
anonymous
|
2
|
3
|
When selected in a union, view column names are incorrect.
|
edit |
2479 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
WinCE regression on some systems. Any db open fails.
|
edit |
2539 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
WinCE: Temporary etilqs_ files are not removed from temporary folder
|
edit |
2322 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Windows error: datetime('2000-10-29 06:00:00','localtime')
|
edit |
1882 |
active
|
2006 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
Wrong algorithm of SQLITE_VERSION_NUMBER calculation
|
edit |
2814 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
_XOPEN_SOURCE again
|
edit |
1205 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
1
|
accent ecu etc. in connectionstring
|
edit |
1264 |
active
|
2005 May
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
3
|
access() undefined on MSVC
|
edit |
2664 |
active
|
2007 Sep
|
danielk1977
|
|
Pending
|
|
|
1
|
1
|
attaching the same db twice in shared-cache mode fails
|
edit |
1058 |
active
|
2005 Jan
|
anonymous
|
BTree
|
Pending
|
|
|
3
|
3
|
btree.c pageSize -> usableSize
|
edit |
1974 |
active
|
2006 Sep
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
column type not consistent in views
|
edit |
1158 |
active
|
2005 Mar
|
anonymous
|
VDBE
|
Pending
|
|
|
1
|
1
|
core dump on solaris,
|
edit |
1485 |
active
|
2005 Oct
|
anonymous
|
Unknown
|
Pending
|
|
jshen
|
3
|
1
|
cyrilic problem(suppose Unicode as a whole, for PPC)
|
edit |
2867 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
doesn't build on Cygwin - wrong sqlite3 exe suffix
|
edit |
721 |
active
|
2004 May
|
anonymous
|
Shell
|
|
|
drh
|
3
|
2
|
empty .databases information
|
edit |
1201 |
active
|
2005 Apr
|
anonymous
|
CodeGen
|
Pending
|
|
danielk1977
|
1
|
1
|
erro defined type UINT8_TYPE
|
edit |
2215 |
active
|
2007 Feb
|
anonymous
|
|
Pending
|
|
|
1
|
2
|
error messages in virtual table are not propagated
|
edit |
2517 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
dflam
|
1
|
1
|
exception on reading text in vista but not xp
|
edit |
1465 |
active
|
2005 Oct
|
anonymous
|
CodeGen
|
Pending
|
|
|
1
|
1
|
fdatasync not available and not yet fixed
|
edit |
2793 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
fts3 lacks scoping
|
edit |
2057 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
1
|
full_column_names when 2 or more tables are joined is not working
|
edit |
2882 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
fulltest failure: ./testfixture: wrong # args: should be "cksum db"
|
edit |
2721 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
|
|
2
|
1
|
if db file is in a folder with non-ansi character some functions fail
|
edit |
1030 |
active
|
2004 Dec
|
anonymous
|
Shell
|
Pending
|
|
|
2
|
3
|
impossible to import a file and do other things in the same invocation (strongly affects scripting)
|
edit |
1235 |
active
|
2005 May
|
anonymous
|
Unknown
|
Pending
|
|
drh
|
4
|
3
|
inconsistent pragma handling
|
edit |
2893 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
incorrect integer range tests
|
edit |
841 |
active
|
2004 Aug
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
2
|
inner group by query isn't honored by outer count(*) aggregate
|
edit |
1783 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
2
|
insert times increase with growing table size (when indexed)
|
edit |
1494 |
active
|
2005 Oct
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
2
|
intermittent null reference exception in sqlite3_open
|
edit |
1782 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
journal file exclusion
|
edit |
1191 |
active
|
2005 Mar
|
anonymous
|
Unknown
|
Pending
|
|
|
2
|
3
|
last_insert_id() Does Not Work after Insert on View
|
edit |
1493 |
active
|
2005 Oct
|
anonymous
|
Parser
|
Pending
|
|
|
3
|
3
|
lemon: pathsearch uses wrong directory separator under Win32
|
edit |
744 |
active
|
2004 May
|
anonymous
|
BTree
|
|
|
anonymous
|
2
|
2
|
make test seg faults on x86_64 Linux
|
edit |
1100 |
active
|
2005 Feb
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
make test segfaults at capi2-7.12 on amd64 system
|
edit |
2725 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
memory leak in sqlite3_open_v2() when it fails
|
edit |
1323 |
active
|
2005 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped)
|
edit |
2905 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
pweilbacher
|
2
|
2
|
mutex_os2.c - incorrect mutex implementation
|
edit |
1200 |
active
|
2005 Apr
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
new versions of SQLite return different (incorrect) results.
|
edit |
2715 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
no authorization needed to remove authorizer
|
edit |
1111 |
active
|
2005 Feb
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
1
|
no such column error with a subselect as a table
|
edit |
1457 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
|
|
3
|
1
|
non-latin chars not recognized by CLI
|
edit |
2165 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
|
drh
|
4
|
3
|
pager performance and checksum
|
edit |
2440 |
active
|
2007 Jun
|
rse
|
|
Pending
|
|
|
2
|
2
|
pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS
|
edit |
575 |
active
|
2004 Jan
|
anonymous
|
VDBE
|
|
|
drh
|
3
|
3
|
pragma (default_)temp_store implementations seems incomplete
|
edit |
2223 |
active
|
2007 Feb
|
scouten
|
|
Pending
|
|
|
3
|
3
|
pragma auto_vacuum doesn't survive .dump & reconstitute
|
edit |
1085 |
active
|
2005 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
pragma full_column_names and short_column_names still broken
|
edit |
2241 |
active
|
2007 Feb
|
scouten
|
|
Pending
|
|
|
3
|
3
|
pragma integrity_check no longer affects command-line tool's exit code
|
edit |
1884 |
active
|
2006 Jul
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
pragma table_info caches results from previous query
|
edit |
1901 |
active
|
2006 Jul
|
anonymous
|
Unknown
|
Pending
|
|
adamd
|
2
|
2
|
problem in select request with a alias table
|
edit |
754 |
active
|
2004 Jun
|
anonymous
|
Shell
|
|
|
drh
|
2
|
3
|
problem opening a dbfile in the upper directory (../dbname)
|
edit |
1228 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
4
|
3
|
problem with select+union on a view with aliased columns
|
edit |
2613 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
|
drh
|
3
|
3
|
replace doesn't work with blobs containing \x0, otherwise it does
|
edit |
2294 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
|
2
|
1
|
segfault when destroying lock on WinCE with threads
|
edit |
1134 |
active
|
2005 Feb
|
anonymous
|
|
Pending
|
|
drh
|
3
|
3
|
select command with a view and a condition gets no result
|
edit |
1508 |
active
|
2005 Nov
|
anonymous
|
BTree
|
Pending
|
|
|
1
|
3
|
sqlite 2.8.16 crashes on 64-bit / strict memory alignment archs
|
edit |
1342 |
active
|
2005 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
sqlite 3.2.2 will not load on Suse Linux 9.3
|
edit |
1026 |
active
|
2004 Dec
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
3
|
sqlite automake sqlite3.pc file does not have version information
|
edit |
2140 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
1
|
sqlite doesn't link to readline
|
edit |
1893 |
active
|
2006 Jul
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
sqlite doesn't use indexes containing primary key in prim. key selects
|
edit |
2498 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
3
|
2
|
sqlite memory org on linux
|
edit |
1885 |
active
|
2006 Jul
|
anonymous
|
Shell
|
Pending
|
|
|
2
|
3
|
sqlite3 .mode insert and .dump do not list column names for selects
|
edit |
2632 |
review
|
2007 Sep
|
anonymous
|
|
Works_As_Designed
|
|
danielk1977
|
5
|
2
|
sqlite3* not available within loadable extension <sqlite3ext.h>
|
edit |
1298 |
active
|
2005 Jun
|
anonymous
|
Shell
|
Pending
|
|
drh
|
4
|
3
|
sqlite3.exe not recognizing newline as comment terminator
|
edit |
1990 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
sqlite3_close doesn't release always the file handle
|
edit |
1214 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
2
|
3
|
sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects
|
edit |
2081 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
|
doughenry
|
1
|
1
|
sqlite3_column_decltype throws exception, if selection is grouped
|
edit |
2371 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
sqlite3_errcode() and sqlite3_errmsg() return unexpected results
|
edit |
1278 |
active
|
2005 Jun
|
anonymous
|
|
Pending
|
|
|
1
|
2
|
sqlite3_finalize doesn't clear previous error code or message
|
edit |
1248 |
active
|
2005 May
|
anonymous
|
Unknown
|
Pending
|
|
|
3
|
1
|
sqlite3_get_table returns garbage for BLOB data
|
edit |
1872 |
active
|
2006 Jun
|
anonymous
|
|
Pending
|
|
|
4
|
3
|
sqlite3_open doesn't support RFC1738 format for filename
|
edit |
2320 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
drh
|
1
|
1
|
sqlite3_open(sFN_with_umlaut)
|
edit |
1633 |
active
|
2006 Jan
|
anonymous
|
VDBE
|
Pending
|
|
|
3
|
3
|
sqlite3_step returns SQLITE_ERROR when interrupted
|
edit |
2093 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
sqlite3_vtab_cursor doesn't have errMsg
|
edit |
627 |
active
|
2004 Feb
|
anonymous
|
|
|
|
|
3
|
3
|
sqliteRunVacuum returning wrong code?
|
edit |
2916 |
active
|
2008 Feb
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
sqlitedll-3_5_5.zip is older 3.5.4 binary
|
edit |
1775 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
|
|
1
|
1
|
strftime() not working in Windows Mobile 2005
|
edit |
2398 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
systemcalls should be restarted when they return EINTR
|
edit |
2048 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
|
drh
|
1
|
1
|
table_info on columns with no default value are returned as string
|
edit |
2203 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
table_info pragma "default" column format changed?
|
edit |
2903 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
2
|
2
|
tclinstaller.tcl fails on path and permissions issue
|
edit |
1428 |
active
|
2005 Sep
|
anonymous
|
TclLib
|
Pending
|
|
|
3
|
3
|
tclinstaller.tcl script problems
|
edit |
1799 |
active
|
2006 May
|
anonymous
|
Pager
|
Pending
|
|
|
2
|
3
|
temp_store=MEMORY slower than FILE for large intermediate result sets
|
edit |
2863 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
|
|
2
|
3
|
test cast-3.14, cast-3.18 and cast-3.24 fail
|
edit |
1056 |
active
|
2004 Dec
|
anonymous
|
Shell
|
Pending
|
|
|
3
|
3
|
test pragma-9.4 fails during second pass in "make fulltest"
|
edit |
2886 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
testfixture: -fPIC needed when building extension(s)
|
edit |
2352 |
active
|
2007 May
|
anonymous
|
|
Pending
|
|
|
5
|
3
|
timeout just 500 msec to soon
|
edit |
2755 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
|
|
3
|
3
|
trace interfere with transaction Tcl interface
|
edit |
2012 |
active
|
2006 Oct
|
anonymous
|
|
New
|
|
|
4
|
3
|
trigger4.test aborts "make test" on Windows
|
edit |
2297 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
|
drh
|
3
|
3
|
uninitialized var (with patch)
|
edit |
2508 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
|
|
1
|
1
|
utf8ToUnicode() does not work on some WinCE devices
|
edit |
2128 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
|
|
4
|
3
|
virtual table code doesn't verify type of rowid (calling xUpdate)
|
edit |