# |
Status |
Created |
By |
Subsys |
Due Date |
Ver |
Assigned |
Svr |
Pri |
Title |
|
798 |
active
|
2004 Jul
|
anonymous
|
Unknown
|
|
3.0.2
|
|
1
|
1
|
Unable to run tests on Tru64 bit Linux platform
|
edit |
1142 |
active
|
2005 Feb
|
anonymous
|
Parser
|
Pending
|
3.1.3
|
danielk1977
|
1
|
1
|
Column names
|
edit |
1201 |
active
|
2005 Apr
|
anonymous
|
CodeGen
|
Pending
|
3.2.1
|
danielk1977
|
1
|
1
|
erro defined type UINT8_TYPE
|
edit |
1278 |
active
|
2005 Jun
|
anonymous
|
|
Pending
|
3.2.1
|
|
1
|
2
|
sqlite3_finalize doesn't clear previous error code or message
|
edit |
1305 |
active
|
2005 Jun
|
anonymous
|
TclLib
|
Pending
|
3.2.2
|
|
1
|
1
|
Tcl installs pkgIndex with wrong path
|
edit |
1312 |
active
|
2005 Jun
|
anonymous
|
Shell
|
Pending
|
3.0.8
|
|
1
|
1
|
CSV file import / export is all wrong!
|
edit |
1323 |
active
|
2005 Jul
|
anonymous
|
|
Pending
|
3.2.2
|
|
1
|
1
|
misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped)
|
edit |
1342 |
active
|
2005 Jul
|
anonymous
|
|
Pending
|
3.2.2
|
|
1
|
1
|
sqlite 3.2.2 will not load on Suse Linux 9.3
|
edit |
1351 |
active
|
2005 Aug
|
anonymous
|
Shell
|
Pending
|
3.2.2
|
|
1
|
1
|
Unable to parse UTF8 input
|
edit |
1397 |
new
|
2005 Aug
|
anonymous
|
Shell
|
Pending
|
3.2.5
|
|
1
|
1
|
.mode csv creates ASCII output instead of UTF-8
|
edit |
1415 |
active
|
2005 Sep
|
anonymous
|
Unknown
|
Pending
|
3
|
drh
|
1
|
1
|
Querying for BLOB type fields
|
edit |
1461 |
active
|
2005 Sep
|
anonymous
|
Unknown
|
Pending
|
3.2.7
|
drh
|
1
|
2
|
3.2.7 DLL can not deal File paths with international characters
|
edit |
1465 |
active
|
2005 Oct
|
anonymous
|
CodeGen
|
Pending
|
3.2.7
|
|
1
|
1
|
fdatasync not available and not yet fixed
|
edit |
1487 |
active
|
2005 Oct
|
anonymous
|
BTree
|
Pending
|
3.2.2
|
|
1
|
3
|
Corrupt database causes indefinite loop in sqlite3_step()
|
edit |
1488 |
active
|
2005 Oct
|
anonymous
|
|
Pending
|
3.27
|
|
1
|
1
|
Collate Reverse does not exists?
|
edit |
1504 |
active
|
2005 Nov
|
anonymous
|
Pager
|
Pending
|
3.2.7
|
|
1
|
3
|
Multithreaded DB lock not released using Begin/Commit between threads
|
edit |
1522 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
3.2.7+
|
|
1
|
3
|
Make test fails in manydb 1.82-3.299 mac os x 10.4.3 ppc
|
edit |
1735 |
active
|
2006 Mar
|
anonymous
|
Unknown
|
Pending
|
3.2.2
|
|
1
|
3
|
Encoding problem
|
edit |
1775 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
3.3.4
|
|
1
|
1
|
strftime() not working in Windows Mobile 2005
|
edit |
1782 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
3.2.2
|
|
1
|
1
|
journal file exclusion
|
edit |
1797 |
active
|
2006 May
|
anonymous
|
TclLib
|
Pending
|
3.3.5
|
drh
|
1
|
1
|
COPY command doesn't work in tclsqlite 3.3.5
|
edit |
1809 |
active
|
2006 May
|
anonymous
|
CodeGen
|
Pending
|
3.3.5+
|
|
1
|
3
|
Huge slowdown/increased memory use when using GROUP BY on big dataset
|
edit |
1816 |
active
|
2006 May
|
anonymous
|
VDBE
|
Pending
|
3.3.5
|
|
1
|
2
|
Database corruption with pragma auto_vacuum
|
edit |
1861 |
active
|
2006 Jun
|
anonymous
|
Pager
|
Pending
|
3.3.5
|
|
1
|
1
|
Problem in using Triggers and multithreading
|
edit |
1862 |
active
|
2006 Jun
|
anonymous
|
TclLib
|
Pending
|
3.3.6
|
tclguy
|
1
|
1
|
SQLite cannot load/import data from file
|
edit |
1867 |
active
|
2006 Jun
|
anonymous
|
BTree
|
Pending
|
3.3.6
|
|
1
|
3
|
Access Violation after set a new page_size
|
edit |
1900 |
active
|
2006 Jul
|
anonymous
|
Unknown
|
Pending
|
3.3.6
|
a.rottmann
|
1
|
1
|
CURRENT_TIMESTAMP keyword not inserting UTC date in column
|
edit |
1941 |
active
|
2006 Aug
|
anonymous
|
|
Pending
|
3.3.7
|
|
1
|
1
|
Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER
|
edit |
1954 |
active
|
2006 Sep
|
anonymous
|
Unknown
|
Pending
|
3
|
|
1
|
1
|
Dual Core Processor Lockup
|
edit |
1974 |
active
|
2006 Sep
|
anonymous
|
Unknown
|
Pending
|
3.3.6
|
|
1
|
1
|
column type not consistent in views
|
edit |
1990 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
3.3.7
|
|
1
|
1
|
sqlite3_close doesn't release always the file handle
|
edit |
1994 |
active
|
2006 Sep
|
anonymous
|
Parser
|
Pending
|
3.3.7
|
|
1
|
3
|
Columns from nested joins aren't properly propagated
|
edit |
2017 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
|
edit |
2019 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
FTS1: Create table in transaction raises Out of Sequence error (21)
|
edit |
2022 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.33
|
|
1
|
1
|
.import command is not working
|
edit |
2027 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
FTS: Phrase searches return Offsets for individual phrase words
|
edit |
2037 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
|
edit |
2046 |
active
|
2006 Oct
|
anonymous
|
|
Fixed
|
3.3.8
|
shess
|
1
|
1
|
FTS1 - Error closing database due to unfinished statements
|
edit |
2048 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
drh
|
1
|
1
|
table_info on columns with no default value are returned as string
|
edit |
2059 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
Still missing .DEF file from Windows 3.3.8 source code distribution
|
edit |
2060 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
Table references enclosed in parenthesis become "invisible"
|
edit |
2076 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
a.rottmann
|
1
|
1
|
% exists as value in varchar
|
edit |
2100 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.8
|
|
1
|
1
|
Fixes for SQL lower() and upper()
|
edit |
2183 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
3.3.11
|
drh
|
1
|
1
|
OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
|
edit |
2215 |
active
|
2007 Feb
|
anonymous
|
|
Pending
|
3.3.12
|
|
1
|
2
|
error messages in virtual table are not propagated
|
edit |
2303 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.1.15
|
|
1
|
1
|
Encrypted databases: No page cache due to problem in pagerSharedLock
|
edit |
2320 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.3.17
|
drh
|
1
|
1
|
sqlite3_open(sFN_with_umlaut)
|
edit |
2322 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
1
|
Windows error: datetime('2000-10-29 06:00:00','localtime')
|
edit |
2328 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
1
|
Makefile sqlite3.c target breakage for C++
|
edit |
2350 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
1
|
Temp files not deleted on WinCE
|
edit |
2388 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
3
|
ORDER BY fails on compound select
|
edit |
2396 |
active
|
2007 Jun
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
3
|
-column output truncates characters from varchar field.
|
edit |
2409 |
active
|
2007 Jun
|
anonymous
|
|
New
|
3.3.17
|
drh
|
1
|
1
|
Database malformed with SQLite3.3.17 on WindowsXP
|
edit |
2414 |
active
|
2007 Jun
|
anonymous
|
|
Unable_to_fix
|
3.2.5
|
|
1
|
1
|
Unable t
|
edit |
2487 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.3.17
|
|
1
|
1
|
SQLite database locked error on NFS mounted home dir
|
edit |
2491 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4.0
|
|
1
|
1
|
Mingw Warnings w/ 3.4.0 Amalgamation
|
edit |
2508 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.40.0
|
|
1
|
1
|
utf8ToUnicode() does not work on some WinCE devices
|
edit |
2512 |
active
|
2007 Jul
|
shess
|
|
Pending
|
3.4.0
|
|
1
|
1
|
FTS virtual table name quoting problem
|
edit |
2517 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4
|
dflam
|
1
|
1
|
exception on reading text in vista but not xp
|
edit |
2543 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4.0
|
|
1
|
1
|
Chinese charset not support??
|
edit |
2580 |
active
|
2007 Aug
|
anonymous
|
|
Pending
|
3.4.2
|
anonymous
|
1
|
2
|
Can't open a query if text to search is Greek
|
edit |
2684 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
3.4.1
|
|
1
|
1
|
Accessing sqlite from an NT service will lock the complete databse.
|
edit |
2715 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
3.5.1
|
|
1
|
1
|
no authorization needed to remove authorizer
|
edit |
2725 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
3.5.1
|
|
1
|
1
|
memory leak in sqlite3_open_v2() when it fails
|
edit |
2770 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.2
|
|
1
|
1
|
Problem with BLOB in 3.5.x ?
|
edit |
2791 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.2+ CVS
|
|
1
|
1
|
Allow building FTS[123] as part of sqlite library with configure
|
edit |
2809 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.3 CVS
|
|
1
|
1
|
PRAGMA collation_list shows unregistered collations
|
edit |
2810 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.3 CVS
|
|
1
|
1
|
Unregistered collation problems with simple subselects
|
edit |
2842 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.3.6
|
|
1
|
1
|
.import does not recongnise NULL values
|
edit |
2865 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.5.4+ CVS
|
|
1
|
2
|
FTS3 does not build with amalgamation in CVS
|
edit |
2873 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.x
|
|
1
|
1
|
HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make
|
edit |
2897 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
1
|
1
|
String or BLOB exceed size limit
|
edit |
2898 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
1
|
1
|
Latest CVS for 3.5.4 fails to build test1.c
|
edit |
1030 |
active
|
2004 Dec
|
anonymous
|
Shell
|
Pending
|
3.0.8
|
|
2
|
3
|
impossible to import a file and do other things in the same invocation (strongly affects scripting)
|
edit |
1085 |
active
|
2005 Jan
|
anonymous
|
|
Pending
|
3.1.0.a
|
|
2
|
3
|
pragma full_column_names and short_column_names still broken
|
edit |
1191 |
active
|
2005 Mar
|
anonymous
|
Unknown
|
Pending
|
3.2.0
|
|
2
|
3
|
last_insert_id() Does Not Work after Insert on View
|
edit |
1200 |
active
|
2005 Apr
|
anonymous
|
|
Pending
|
3.2
|
|
2
|
3
|
new versions of SQLite return different (incorrect) results.
|
edit |
1214 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
3.2.1
|
|
2
|
3
|
sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects
|
edit |
1327 |
active
|
2005 Jul
|
ghaering
|
VDBE
|
Pending
|
3.2.2
|
|
2
|
3
|
UNION causes sqlite3_column_decltype to always return NULL
|
edit |
1458 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
3.2.6
|
|
2
|
2
|
Error at .importing in csv format (another)
|
edit |
1502 |
active
|
2005 Oct
|
anonymous
|
Unknown
|
Pending
|
3.2.7
|
anonymous
|
2
|
3
|
When selected in a union, view column names are incorrect.
|
edit |
1700 |
active
|
2006 Mar
|
anonymous
|
Parser
|
Pending
|
3.3.4
|
|
2
|
2
|
Handling column names for aliased queries is broken
|
edit |
1742 |
active
|
2006 Mar
|
anonymous
|
Unknown
|
Pending
|
3.3.4
|
drh
|
2
|
3
|
ORDER BY on more than one column causes a big slowdown
|
edit |
1754 |
active
|
2006 Apr
|
anonymous
|
Pager
|
Pending
|
3.3.5
|
anonymous
|
2
|
2
|
Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
|
edit |
1799 |
active
|
2006 May
|
anonymous
|
Pager
|
Pending
|
3.3.5
|
|
2
|
3
|
temp_store=MEMORY slower than FILE for large intermediate result sets
|
edit |
1850 |
active
|
2006 Jun
|
anonymous
|
Unknown
|
Pending
|
3.3.5
|
|
2
|
1
|
NUMERIC data type ERROE when read on uClinux
|
edit |
1851 |
active
|
2006 Jun
|
anonymous
|
Unknown
|
Pending
|
3.3.5
|
|
2
|
1
|
USE "ORDER BY" error on uClinux
|
edit |
1856 |
active
|
2006 Jun
|
anonymous
|
|
Pending
|
3.3.6
|
|
2
|
3
|
SQLITE_OMIT_UTF16 breaks 'make test'
|
edit |
1878 |
active
|
2006 Jun
|
anonymous
|
CodeGen
|
Pending
|
3.3.6
|
|
2
|
3
|
No index used when specifying alias name in ORDER BY clause
|
edit |
1885 |
active
|
2006 Jul
|
anonymous
|
Shell
|
Pending
|
3.3.6
|
|
2
|
3
|
sqlite3 .mode insert and .dump do not list column names for selects
|
edit |
1901 |
active
|
2006 Jul
|
anonymous
|
Unknown
|
Pending
|
3-3.3.6
|
adamd
|
2
|
2
|
problem in select request with a alias table
|
edit |
1946 |
new
|
2006 Aug
|
anonymous
|
Unknown
|
New
|
3.3.6
|
|
2
|
2
|
.read file fails on blob fields with end-of-file char
|
edit |
1948 |
active
|
2006 Aug
|
anonymous
|
Shell
|
Pending
|
3.3.5
|
|
2
|
3
|
Double quotes are not escaped in csv mode
|
edit |
1983 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
3.3.7
|
|
2
|
2
|
I/O Error at a size of 4GB and auto_vacuum=1
|
edit |
2077 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.7
|
|
2
|
1
|
Problems with using ASCII symbols 0x80 - 0xFF in database path
|
edit |
2093 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.8
|
|
2
|
3
|
sqlite3_vtab_cursor doesn't have errMsg
|
edit |
2127 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.8
|
|
2
|
3
|
Virtual tables do not always free zErrmsg
|
edit |
2131 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.8
|
|
2
|
3
|
Add substring() function (Part of SQL 99)
|
edit |
2203 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
3.3.8+
|
|
2
|
3
|
table_info pragma "default" column format changed?
|
edit |
2219 |
active
|
2007 Feb
|
shess
|
|
Fixed
|
3.3.12 and earlier
|
shess
|
2
|
2
|
Creating an fts table in an attached database works wrong.
|
edit |
2294 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.3.15
|
|
2
|
1
|
segfault when destroying lock on WinCE with threads
|
edit |
2371 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
2
|
2
|
sqlite3_errcode() and sqlite3_errmsg() return unexpected results
|
edit |
2440 |
active
|
2007 Jun
|
rse
|
|
Pending
|
3.4.0
|
|
2
|
2
|
pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS
|
edit |
2530 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.3.17
|
|
2
|
3
|
Unable to write to windows share, even with exclusive lock
|
edit |
2539 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4.1
|
|
2
|
2
|
WinCE: Temporary etilqs_ files are not removed from temporary folder
|
edit |
2558 |
active
|
2007 Aug
|
anonymous
|
|
Pending
|
3.4.1
|
|
2
|
3
|
Multiple JOIN USING() gives incorrect results
|
edit |
2721 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
3.5
|
|
2
|
1
|
if db file is in a folder with non-ansi character some functions fail
|
edit |
2857 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.5.4
|
|
2
|
2
|
GROUP BY cost estimate wrong with WHERE clause
|
edit |
2863 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.5.4
|
|
2
|
3
|
test cast-3.14, cast-3.18 and cast-3.24 fail
|
edit |
2867 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
2
|
2
|
doesn't build on Cygwin - wrong sqlite3 exe suffix
|
edit |
2903 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
2
|
2
|
tclinstaller.tcl fails on path and permissions issue
|
edit |
2905 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
pweilbacher
|
2
|
2
|
mutex_os2.c - incorrect mutex implementation
|
edit |
2911 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
2
|
2
|
Adding parentheses to a FROM clause
|
edit |
783 |
active
|
2004 Jun
|
anonymous
|
Unknown
|
|
3.0.1
|
|
3
|
3
|
Build on MAC with -DSQLITE_DEBUG=1 compile error
|
edit |
841 |
active
|
2004 Aug
|
anonymous
|
Unknown
|
Pending
|
3.0.3+
|
|
3
|
2
|
inner group by query isn't honored by outer count(*) aggregate
|
edit |
969 |
new
|
2004 Oct
|
anonymous
|
TclLib
|
Pending
|
3.0.8
|
|
3
|
3
|
PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so part 2
|
edit |
1026 |
active
|
2004 Dec
|
anonymous
|
Unknown
|
Pending
|
3.0.8
|
|
3
|
3
|
sqlite automake sqlite3.pc file does not have version information
|
edit |
1053 |
active
|
2004 Dec
|
anonymous
|
Pager
|
Pending
|
3.0.8
|
|
3
|
3
|
SQLITE_IOERR and strange rollback when db is busy
|
edit |
1056 |
active
|
2004 Dec
|
anonymous
|
Shell
|
Pending
|
3.08+
|
|
3
|
3
|
test pragma-9.4 fails during second pass in "make fulltest"
|
edit |
1058 |
active
|
2005 Jan
|
anonymous
|
BTree
|
Pending
|
3.08+
|
|
3
|
3
|
btree.c pageSize -> usableSize
|
edit |
1100 |
active
|
2005 Feb
|
anonymous
|
|
Pending
|
3.1.1beta
|
|
3
|
3
|
make test segfaults at capi2-7.12 on amd64 system
|
edit |
1111 |
active
|
2005 Feb
|
anonymous
|
Unknown
|
Pending
|
3.1.1 beta
|
|
3
|
1
|
no such column error with a subselect as a table
|
edit |
1205 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
3
|
|
3
|
1
|
accent ecu etc. in connectionstring
|
edit |
1213 |
active
|
2005 Apr
|
anonymous
|
Parser
|
Pending
|
3.2.1
|
|
3
|
2
|
Problem with alias columns in subqueries
|
edit |
1248 |
active
|
2005 May
|
anonymous
|
Unknown
|
Pending
|
3.2.1
|
|
3
|
1
|
sqlite3_get_table returns garbage for BLOB data
|
edit |
1365 |
active
|
2005 Aug
|
anonymous
|
|
Pending
|
3.2.2
|
|
3
|
3
|
64 bit types not completely overridable
|
edit |
1428 |
active
|
2005 Sep
|
anonymous
|
TclLib
|
Pending
|
3.2.5
|
|
3
|
3
|
tclinstaller.tcl script problems
|
edit |
1445 |
active
|
2005 Sep
|
anonymous
|
|
Pending
|
3.3.7
|
|
3
|
3
|
Errors testing sqlite 3.2.6 (& v3.3.7)
|
edit |
1457 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
3.2.7 and lower
|
|
3
|
1
|
non-latin chars not recognized by CLI
|
edit |
1485 |
active
|
2005 Oct
|
anonymous
|
Unknown
|
Pending
|
3.2.2
|
jshen
|
3
|
1
|
cyrilic problem(suppose Unicode as a whole, for PPC)
|
edit |
1493 |
active
|
2005 Oct
|
anonymous
|
Parser
|
Pending
|
3.2.7
|
|
3
|
3
|
lemon: pathsearch uses wrong directory separator under Win32
|
edit |
1521 |
active
|
2005 Nov
|
anonymous
|
Unknown
|
Pending
|
3.2.7
|
|
3
|
2
|
ORDER BY sorts incorrectly with aliased fields
|
edit |
1573 |
active
|
2005 Dec
|
anonymous
|
Shell
|
Pending
|
3.2.7
|
|
3
|
3
|
Bad CSV output when data contains double quotes
|
edit |
1633 |
active
|
2006 Jan
|
anonymous
|
VDBE
|
Pending
|
3.2.7
|
|
3
|
3
|
sqlite3_step returns SQLITE_ERROR when interrupted
|
edit |
1743 |
active
|
2006 Mar
|
anonymous
|
Parser
|
Pending
|
3.3.4
|
|
3
|
3
|
A very very deep IN statement failure
|
edit |
1783 |
active
|
2006 Apr
|
anonymous
|
Unknown
|
Pending
|
3.3.5
|
|
3
|
2
|
insert times increase with growing table size (when indexed)
|
edit |
1790 |
active
|
2006 May
|
anonymous
|
Pager
|
Pending
|
3.3.5
|
|
3
|
3
|
:memory: performance difference between v2 and v3
|
edit |
1815 |
active
|
2006 May
|
anonymous
|
Parser
|
Pending
|
3.3.5
|
|
3
|
3
|
Support of W3C-DTF(ISO8601 subset) is incomplete
|
edit |
1822 |
active
|
2006 May
|
anonymous
|
|
Duplicate
|
3.3.5
|
|
3
|
3
|
Table Alias together with Subquery seems not to work proper
|
edit |
1884 |
active
|
2006 Jul
|
anonymous
|
|
Pending
|
3.3.6
|
|
3
|
2
|
pragma table_info caches results from previous query
|
edit |
1893 |
active
|
2006 Jul
|
anonymous
|
|
Pending
|
3.3.6
|
|
3
|
3
|
sqlite doesn't use indexes containing primary key in prim. key selects
|
edit |
1947 |
active
|
2006 Aug
|
anonymous
|
Shell
|
Pending
|
3.3.7
|
|
3
|
3
|
".mode insert" works bad with BLOBs
|
edit |
2010 |
active
|
2006 Oct
|
anonymous
|
|
Fixed_in_3.0
|
3.3.7
|
|
3
|
3
|
Timeout ignored in Shared-Cache locking model
|
edit |
2011 |
active
|
2006 Oct
|
anonymous
|
|
New
|
3.3.7
|
|
3
|
2
|
Escaping Porblem with .mode insert (double apostrophe)
|
edit |
2057 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
|
3
|
1
|
full_column_names when 2 or more tables are joined is not working
|
edit |
2075 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
|
3
|
3
|
Improve VACUUM speed and INDEX page locality
|
edit |
2089 |
active
|
2006 Nov
|
anonymous
|
|
Pending
|
3.3.8
|
|
3
|
3
|
Decouple sqlite_int64 from other 64bit datatypes
|
edit |
2096 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.7
|
|
3
|
3
|
ATTACH DATABASE returns SQLITE_ERROR when database is locked
|
edit |
2126 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.7
|
|
3
|
1
|
Update hook not invoked when deleteing all rows from table
|
edit |
2140 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
3.3.8
|
|
3
|
1
|
sqlite doesn't link to readline
|
edit |
2223 |
active
|
2007 Feb
|
scouten
|
|
Pending
|
3.3.12
|
|
3
|
3
|
pragma auto_vacuum doesn't survive .dump & reconstitute
|
edit |
2241 |
active
|
2007 Feb
|
scouten
|
|
Pending
|
3.3.13
|
|
3
|
3
|
pragma integrity_check no longer affects command-line tool's exit code
|
edit |
2340 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17+ CVS
|
|
3
|
3
|
"./configure && make testfixture" link problem
|
edit |
2363 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
3
|
3
|
Couldn't build 3.3.17 on Cygwin/Vista
|
edit |
2376 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.16
|
|
3
|
3
|
-batch doesn't work soon enough
|
edit |
2383 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
3
|
3
|
Inconsistent conversion of BLOB revisited
|
edit |
2498 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4.0 and 3.3.17
|
|
3
|
2
|
sqlite memory org on linux
|
edit |
2511 |
active
|
2007 Jul
|
anonymous
|
|
Pending
|
3.4.0
|
drh
|
3
|
2
|
Inconsistent Pragma output
|
edit |
2613 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
3.4.2
|
drh
|
3
|
3
|
replace doesn't work with blobs containing \x0, otherwise it does
|
edit |
2627 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
3.42
|
|
3
|
2
|
Improper parsing of nested JOIN
|
edit |
2634 |
active
|
2007 Sep
|
anonymous
|
|
Pending
|
3.4.1
|
|
3
|
3
|
.schema uses incorrect ORDER BY giving wrong dependency order
|
edit |
2753 |
active
|
2007 Nov
|
anonymous
|
|
New
|
3.4.1
|
drh
|
3
|
3
|
Master journal files sometimes not deleted
|
edit |
2755 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.4.2
|
|
3
|
3
|
trace interfere with transaction Tcl interface
|
edit |
2761 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.1
|
|
3
|
3
|
CLI (shell.c) should be bundled with amalgamation
|
edit |
2793 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.2+
|
|
3
|
3
|
fts3 lacks scoping
|
edit |
2814 |
active
|
2007 Nov
|
anonymous
|
|
Pending
|
3.5.3
|
|
3
|
3
|
_XOPEN_SOURCE again
|
edit |
2825 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.5.3
|
|
3
|
3
|
FormatMessage (win32) should use extra flag and convert from Unicode
|
edit |
2859 |
active
|
2007 Dec
|
anonymous
|
|
Pending
|
3.5x
|
drh
|
3
|
2
|
Inconsistent column names with DISTINCT
|
edit |
2875 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
3
|
2
|
LIKE does not work with lowercase swedish characters
|
edit |
2901 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
3
|
3
|
ROLLBACK and COMMIT statements should not expire
|
edit |
2902 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
drh
|
3
|
3
|
Add watch support to SQLite
|
edit |
2908 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
3
|
3
|
Add support to examine whether statements modify the database
|
edit |
2914 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.5.4
|
|
3
|
3
|
ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
|
edit |
1228 |
active
|
2005 Apr
|
anonymous
|
Unknown
|
Pending
|
3.2.1
|
|
4
|
3
|
problem with select+union on a view with aliased columns
|
edit |
1235 |
active
|
2005 May
|
anonymous
|
Unknown
|
Pending
|
3.2.1
|
drh
|
4
|
3
|
inconsistent pragma handling
|
edit |
1298 |
active
|
2005 Jun
|
anonymous
|
Shell
|
Pending
|
3.2.1
|
drh
|
4
|
3
|
sqlite3.exe not recognizing newline as comment terminator
|
edit |
1451 |
active
|
2005 Sep
|
anonymous
|
Shell
|
Pending
|
3.2.5
|
|
4
|
3
|
.mode insert does not output BLOBs in an usable way
|
edit |
1733 |
active
|
2006 Mar
|
anonymous
|
VDBE
|
Pending
|
3.3.4
|
drh
|
4
|
3
|
Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
|
edit |
1804 |
active
|
2006 May
|
anonymous
|
Unknown
|
Pending
|
3.3.5
|
|
4
|
3
|
Inconsistent value type returned by SUM when using a GROUP BY
|
edit |
1953 |
active
|
2006 Sep
|
anonymous
|
TclLib
|
Pending
|
3.3.7
|
|
4
|
3
|
Fix for false 64-bit comparisons "make test" failures on Cygwin
|
edit |
1960 |
active
|
2006 Sep
|
anonymous
|
|
Pending
|
3.3.7
|
|
4
|
2
|
Issues with .import in sqlite.exe
|
edit |
2012 |
active
|
2006 Oct
|
anonymous
|
|
New
|
3.3.8
|
|
4
|
3
|
trigger4.test aborts "make test" on Windows
|
edit |
2013 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
drh
|
4
|
3
|
Autoincrement increments on failing INSERT OR IGNORE
|
edit |
2014 |
active
|
2006 Oct
|
anonymous
|
|
Pending
|
3.3.8
|
anonymous
|
4
|
3
|
Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE
|
edit |
2128 |
active
|
2006 Dec
|
anonymous
|
|
Pending
|
3.3.8
|
|
4
|
3
|
virtual table code doesn't verify type of rowid (calling xUpdate)
|
edit |
2165 |
active
|
2007 Jan
|
anonymous
|
|
Pending
|
3.3.10
|
drh
|
4
|
3
|
pager performance and checksum
|
edit |
2288 |
active
|
2007 Apr
|
anonymous
|
|
Pending
|
3.3.15
|
|
4
|
2
|
FTS does not support REPLACE
|
edit |
2708 |
active
|
2007 Oct
|
anonymous
|
|
Pending
|
3.5.1
|
|
4
|
2
|
SQL error:disk I/O error
|
edit |
2879 |
active
|
2008 Jan
|
anonymous
|
|
Pending
|
3.4.2
|
anonymous
|
4
|
3
|
VACUUM enters temporary sequence numbers in sqlite_sequence
|
edit |
2352 |
active
|
2007 May
|
anonymous
|
|
Pending
|
3.3.17
|
|
5
|
3
|
timeout just 500 msec to soon
|
edit |
2632 |
review
|
2007 Sep
|
anonymous
|
|
Works_As_Designed
|
3.5.0 alpha
|
danielk1977
|
5
|
2
|
sqlite3* not available within loadable extension <sqlite3ext.h>
|
edit |