# |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
|
2916 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Feb
|
|
1
|
1
|
sqlitedll-3_5_5.zip is older 3.5.4 binary
|
edit |
2907 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Issues of sqlite3 with Windows Mobile 5/6
|
edit |
2898 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Latest CVS for 3.5.4 fails to build test1.c
|
edit |
2897 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
String or BLOB exceed size limit
|
edit |
2893 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
incorrect integer range tests
|
edit |
2878 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Memory leaks with latest CVS [4693]
|
edit |
2874 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c
|
edit |
2873 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make
|
edit |
2865 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
2
|
FTS3 does not build with amalgamation in CVS
|
edit |
2842 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
.import does not recongnise NULL values
|
edit |
2810 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Unregistered collation problems with simple subselects
|
edit |
2809 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
PRAGMA collation_list shows unregistered collations
|
edit |
2791 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Allow building FTS[123] as part of sqlite library with configure
|
edit |
2770 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Problem with BLOB in 3.5.x ?
|
edit |
2766 |
code
|
active
|
2007 Nov
|
drh
|
|
2007 Nov
|
|
1
|
1
|
TCL transaction started from within a query does not commit
|
edit |
2756 |
new
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
allow vacuum to change pragma setting instead of using existing ones
|
edit |
2725 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
memory leak in sqlite3_open_v2() when it fails
|
edit |
2715 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
no authorization needed to remove authorizer
|
edit |
2684 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Accessing sqlite from an NT service will lock the complete databse.
|
edit |
2664 |
code
|
active
|
2007 Sep
|
danielk1977
|
|
2007 Sep
|
|
1
|
1
|
attaching the same db twice in shared-cache mode fails
|
edit |
2652 |
code
|
active
|
2007 Sep
|
drh
|
|
2007 Sep
|
|
1
|
1
|
Aggregate function cannot be used from within a subquery
|
edit |
2580 |
code
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
anonymous
|
1
|
2
|
Can't open a query if text to search is Greek
|
edit |
2555 |
new
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
FTS index without original text
|
edit |
2545 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
4
|
Group by returns table name with field name
|
edit |
2543 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
Chinese charset not support??
|
edit |
2517 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
dflam
|
1
|
1
|
exception on reading text in vista but not xp
|
edit |
2512 |
code
|
active
|
2007 Jul
|
shess
|
|
2007 Jul
|
|
1
|
1
|
FTS virtual table name quoting problem
|
edit |
2510 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
Vacuum modified FTS2 rowids
|
edit |
2509 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
SQLITE_DATE
|
edit |
2508 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
utf8ToUnicode() does not work on some WinCE devices
|
edit |
2491 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
Mingw Warnings w/ 3.4.0 Amalgamation
|
edit |
2487 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
SQLite database locked error on NFS mounted home dir
|
edit |
2479 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
WinCE regression on some systems. Any db open fails.
|
edit |
2414 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
Unable t
|
edit |
2413 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
1
|
1
|
1 bug and 2 suggestions in lemon
|
edit |
2409 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
1
|
1
|
Database malformed with SQLite3.3.17 on WindowsXP
|
edit |
2396 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
3
|
-column output truncates characters from varchar field.
|
edit |
2388 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
3
|
ORDER BY fails on compound select
|
edit |
2350 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Temp files not deleted on WinCE
|
edit |
2328 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Makefile sqlite3.c target breakage for C++
|
edit |
2322 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Windows error: datetime('2000-10-29 06:00:00','localtime')
|
edit |
2320 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
drh
|
1
|
1
|
sqlite3_open(sFN_with_umlaut)
|
edit |
2304 |
new
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
resolve "databas is locked" problem under DEFERRED transaction
|
edit |
2303 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Encrypted databases: No page cache due to problem in pagerSharedLock
|
edit |
2215 |
code
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
2
|
error messages in virtual table are not propagated
|
edit |
2183 |
code
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
1
|
1
|
OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
|
edit |
2167 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
3
|
add sqlite3_copy_bindings (parallel to sqlite3_transfer_bindings)
|
edit |
2136 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
|
1
|
3
|
sqlite locking does not handle afs; patch included
|
edit |
2100 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
1
|
1
|
Fixes for SQL lower() and upper()
|
edit |
2081 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
doughenry
|
1
|
1
|
sqlite3_column_decltype throws exception, if selection is grouped
|
edit |
2076 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
a.rottmann
|
1
|
1
|
% exists as value in varchar
|
edit |
2060 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
Table references enclosed in parenthesis become "invisible"
|
edit |
2059 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
Still missing .DEF file from Windows 3.3.8 source code distribution
|
edit |
2048 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
drh
|
1
|
1
|
table_info on columns with no default value are returned as string
|
edit |
2046 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Nov
|
shess
|
1
|
1
|
FTS1 - Error closing database due to unfinished statements
|
edit |
2043 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
Spaces in view statement
|
edit |
2037 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
|
edit |
2032 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
AV in btree.c running FTS2 compiled with SQLITE_OMIT_SHARED_CACHE
|
edit |
2027 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
FTS: Phrase searches return Offsets for individual phrase words
|
edit |
2022 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
.import command is not working
|
edit |
2019 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
FTS1: Create table in transaction raises Out of Sequence error (21)
|
edit |
2017 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
|
edit |
1994 |
code
|
active
|
2006 Sep
|
anonymous
|
Parser
|
2006 Sep
|
|
1
|
3
|
Columns from nested joins aren't properly propagated
|
edit |
1992 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Nov
|
shess
|
1
|
1
|
FTS1: Problems after dropping utility tables
|
edit |
1990 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
sqlite3_close doesn't release always the file handle
|
edit |
1980 |
code
|
active
|
2006 Sep
|
drh
|
|
2006 Sep
|
|
1
|
1
|
Initializing FTS1 twice causes it to fail.
|
edit |
1974 |
code
|
active
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
|
1
|
1
|
column type not consistent in views
|
edit |
1954 |
code
|
active
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
|
1
|
1
|
Dual Core Processor Lockup
|
edit |
1941 |
code
|
active
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
1
|
1
|
Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER
|
edit |
1906 |
new
|
active
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
1
|
2
|
date.c line 417 uses non-thread safe localtime() call
|
edit |
1900 |
code
|
active
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Jul
|
a.rottmann
|
1
|
1
|
CURRENT_TIMESTAMP keyword not inserting UTC date in column
|
edit |
1896 |
new
|
active
|
2006 Jul
|
drh
|
|
2006 Jul
|
|
1
|
1
|
All extensions to be statically linked
|
edit |
1882 |
code
|
active
|
2006 Jul
|
anonymous
|
|
2006 Jul
|
|
1
|
1
|
Wrong algorithm of SQLITE_VERSION_NUMBER calculation
|
edit |
1867 |
code
|
active
|
2006 Jun
|
anonymous
|
BTree
|
2006 Jun
|
|
1
|
3
|
Access Violation after set a new page_size
|
edit |
1862 |
code
|
active
|
2006 Jun
|
anonymous
|
TclLib
|
2006 Jun
|
tclguy
|
1
|
1
|
SQLite cannot load/import data from file
|
edit |
1861 |
code
|
active
|
2006 Jun
|
anonymous
|
Pager
|
2006 Jun
|
|
1
|
1
|
Problem in using Triggers and multithreading
|
edit |
1817 |
new
|
active
|
2006 May
|
anonymous
|
|
2006 Jun
|
|
1
|
2
|
Patch to enable SQLite again on OS/2
|
edit |
1816 |
code
|
active
|
2006 May
|
anonymous
|
VDBE
|
2006 May
|
|
1
|
2
|
Database corruption with pragma auto_vacuum
|
edit |
1809 |
code
|
active
|
2006 May
|
anonymous
|
CodeGen
|
2006 May
|
|
1
|
3
|
Huge slowdown/increased memory use when using GROUP BY on big dataset
|
edit |
1797 |
code
|
active
|
2006 May
|
anonymous
|
TclLib
|
2006 May
|
drh
|
1
|
1
|
COPY command doesn't work in tclsqlite 3.3.5
|
edit |
1791 |
code
|
active
|
2006 May
|
anonymous
|
Unknown
|
2006 May
|
|
1
|
1
|
Native threads support for BeOS
|
edit |
1782 |
code
|
active
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
1
|
1
|
journal file exclusion
|
edit |
1778 |
new
|
active
|
2006 Apr
|
anonymous
|
Parser
|
2007 Mar
|
|
1
|
3
|
stdev does not work, workaround not possible due to missing sqrt
|
edit |
1775 |
code
|
active
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
1
|
1
|
strftime() not working in Windows Mobile 2005
|
edit |
1735 |
code
|
active
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
1
|
3
|
Encoding problem
|
edit |
1718 |
new
|
active
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
allow *.sqlite as parameter to sqlite3_analyzer
|
edit |
1622 |
code
|
active
|
2006 Jan
|
danielk1977
|
|
2006 Jan
|
|
1
|
1
|
Compiling with OMIT_PRAGMA causes an error in the test suite
|
edit |
1597 |
new
|
active
|
2006 Jan
|
anonymous
|
Unknown
|
2007 May
|
|
1
|
3
|
wish: support DROP COLUMN
|
edit |
1546 |
code
|
active
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
Creating unique index on non-unique column leads to corr. on SQLite2
|
edit |
1541 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
1
|
1
|
Ticket #924 not fixed in the 2.8 branch
|
edit |
1522 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
1
|
3
|
Make test fails in manydb 1.82-3.299 mac os x 10.4.3 ppc
|
edit |
1508 |
code
|
active
|
2005 Nov
|
anonymous
|
BTree
|
2005 Nov
|
|
1
|
3
|
sqlite 2.8.16 crashes on 64-bit / strict memory alignment archs
|
edit |
1506 |
new
|
active
|
2005 Nov
|
anonymous
|
Shell
|
2005 Nov
|
|
1
|
4
|
Add some flags to .import command
|
edit |
1504 |
code
|
active
|
2005 Nov
|
anonymous
|
Pager
|
2005 Nov
|
|
1
|
3
|
Multithreaded DB lock not released using Begin/Commit between threads
|
edit |
1494 |
code
|
active
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
|
1
|
2
|
intermittent null reference exception in sqlite3_open
|
edit |
1488 |
code
|
active
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
1
|
1
|
Collate Reverse does not exists?
|
edit |
1487 |
code
|
active
|
2005 Oct
|
anonymous
|
BTree
|
2005 Oct
|
|
1
|
3
|
Corrupt database causes indefinite loop in sqlite3_step()
|
edit |
1465 |
code
|
active
|
2005 Oct
|
anonymous
|
CodeGen
|
2005 Oct
|
|
1
|
1
|
fdatasync not available and not yet fixed
|
edit |
1461 |
code
|
active
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
1
|
2
|
3.2.7 DLL can not deal File paths with international characters
|
edit |
1447 |
code
|
active
|
2005 Sep
|
anonymous
|
BTree
|
2005 Sep
|
|
1
|
1
|
Abnormal program termination in src/btree.c line 1339
|
edit |
1415 |
code
|
active
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
1
|
1
|
Querying for BLOB type fields
|
edit |
1397 |
code
|
new
|
2005 Aug
|
anonymous
|
Shell
|
2005 Sep
|
|
1
|
1
|
.mode csv creates ASCII output instead of UTF-8
|
edit |
1382 |
code
|
active
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
drh
|
1
|
1
|
Assert nErr==0 on corrupt db
|
edit |
1351 |
code
|
active
|
2005 Aug
|
anonymous
|
Shell
|
2005 Sep
|
|
1
|
1
|
Unable to parse UTF8 input
|
edit |
1342 |
code
|
active
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
1
|
1
|
sqlite 3.2.2 will not load on Suse Linux 9.3
|
edit |
1325 |
code
|
active
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
|
1
|
4
|
sqlite3_bind_value not implemented
|
edit |
1323 |
code
|
active
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
1
|
1
|
misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped)
|
edit |
1312 |
code
|
active
|
2005 Jun
|
anonymous
|
Shell
|
2005 Sep
|
|
1
|
1
|
CSV file import / export is all wrong!
|
edit |
1305 |
code
|
active
|
2005 Jun
|
anonymous
|
TclLib
|
2005 Jun
|
|
1
|
1
|
Tcl installs pkgIndex with wrong path
|
edit |
1278 |
code
|
active
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
1
|
2
|
sqlite3_finalize doesn't clear previous error code or message
|
edit |
1250 |
new
|
active
|
2005 May
|
anonymous
|
Pager
|
2005 May
|
|
1
|
3
|
FlushFileBuffers makes Windows sqlite dead slow compared to Linux
|
edit |
1240 |
new
|
active
|
2005 May
|
anonymous
|
Pager
|
2005 May
|
drh
|
1
|
3
|
Need integration of Apple's file locking callbacks improvement
|
edit |
1201 |
code
|
active
|
2005 Apr
|
anonymous
|
CodeGen
|
2005 Apr
|
danielk1977
|
1
|
1
|
erro defined type UINT8_TYPE
|
edit |
1189 |
new
|
active
|
2005 Mar
|
anonymous
|
Parser
|
2005 Mar
|
|
1
|
1
|
Make where-clause item count limit dynamic
|
edit |
1177 |
code
|
active
|
2005 Mar
|
anonymous
|
Shell
|
2005 Mar
|
|
1
|
4
|
(Win32) .import inserts extra carrier character in every row
|
edit |
1162 |
new
|
active
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
drh
|
1
|
2
|
Column names in sqlite views differ from oracle/informix column names
|
edit |
1158 |
code
|
active
|
2005 Mar
|
anonymous
|
VDBE
|
2005 Mar
|
|
1
|
1
|
core dump on solaris,
|
edit |
1142 |
code
|
active
|
2005 Feb
|
anonymous
|
Parser
|
2005 Feb
|
danielk1977
|
1
|
1
|
Column names
|
edit |
1063 |
code
|
active
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
1
|
3
|
Lemon bug: Strings in rule code should not be interpreted
|
edit |
916 |
new
|
active
|
2004 Sep
|
anonymous
|
Unknown
|
2007 Dec
|
|
1
|
1
|
No delete notification for INSERT OR REPLACE
|
edit |
883 |
new
|
active
|
2004 Sep
|
anonymous
|
Shell
|
2004 Sep
|
|
1
|
4
|
Choose appropriate column widths for column output
|
edit |
822 |
code
|
active
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
drh
|
1
|
4
|
port of sqlite to dos with djgpp + small general bugfixes
|
edit |
798 |
code
|
active
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
1
|
1
|
Unable to run tests on Tru64 bit Linux platform
|
edit |
709 |
code
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2005 Jan
|
drh
|
1
|
1
|
Unable to unregister or replace functions
|
edit |
698 |
code
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
|
1
|
3
|
.mode list - not going to next line
|
edit |
691 |
code
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
drh
|
1
|
1
|
OS X File Sharing
|
edit |
685 |
code
|
active
|
2004 Apr
|
anonymous
|
CodeGen
|
2004 Apr
|
|
1
|
3
|
SELECT from a VIEW with GROUP BY
|
edit |
611 |
new
|
active
|
2004 Feb
|
anonymous
|
VDBE
|
2004 Feb
|
|
1
|
3
|
Remove giant SWITCH statement in VM for better portability
|
edit |
550 |
new
|
active
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
anonymous
|
1
|
1
|
change of MASTER_NAME and TEMP_MASTER_NAME definition error
|
edit |
517 |
new
|
active
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
drh
|
1
|
1
|
\' sequence unrecognized token error enhancement request
|
edit |
478 |
new
|
active
|
2003 Oct
|
anonymous
|
Parser
|
2003 Nov
|
drh
|
1
|
3
|
select into is lacking
|
edit |
457 |
new
|
active
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
1
|
1
|
Ported to NetWare
|
edit |
412 |
new
|
active
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
drh
|
1
|
1
|
sign function: quick hack for func.c (hope this helps)
|
edit |
381 |
new
|
active
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
1
|
3
|
Support for DJGPP and DOS
|
edit |
294 |
new
|
active
|
2003 Apr
|
anonymous
|
Shell
|
2003 Apr
|
a.rottmann
|
1
|
4
|
Diff for OpenBSD
|
edit |
273 |
new
|
active
|
2003 Mar
|
drh
|
CodeGen
|
2003 Mar
|
drh
|
1
|
1
|
Make NULL_ALWAYS_DISTINCT a pragma rather than a compile-time option
|
edit |
268 |
new
|
active
|
2003 Mar
|
anonymous
|
Parser
|
2003 Nov
|
|
1
|
3
|
columns of subselects containing joins are not recognized
|
edit |
263 |
new
|
active
|
2003 Mar
|
anonymous
|
CodeGen
|
2003 Mar
|
|
1
|
4
|
sqlite locking strategy can lead to deadlock
|
edit |
259 |
new
|
active
|
2003 Mar
|
anonymous
|
CodeGen
|
2003 Nov
|
|
1
|
2
|
ORDER BY queries including an integer primary key don't use index
|
edit |
216 |
new
|
active
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
1
|
1
|
Add "DISTINCT ON()" clause to specify the fields to apply the unicity
|
edit |
209 |
new
|
active
|
2002 Dec
|
anonymous
|
BTree
|
2003 Nov
|
|
1
|
1
|
update libtool
|
edit |
82 |
new
|
active
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
1
|
4
|
Add IsCacheable, IsNullable to sqlite_create_function
|
edit |
2911 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
Adding parentheses to a FROM clause
|
edit |
2905 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
pweilbacher
|
2
|
2
|
mutex_os2.c - incorrect mutex implementation
|
edit |
2903 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
tclinstaller.tcl fails on path and permissions issue
|
edit |
2867 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
doesn't build on Cygwin - wrong sqlite3 exe suffix
|
edit |
2863 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
3
|
test cast-3.14, cast-3.18 and cast-3.24 fail
|
edit |
2857 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
2
|
GROUP BY cost estimate wrong with WHERE clause
|
edit |
2853 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
2
|
3
|
optimizer fails to use an index on MAX subquery
|
edit |
2721 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Dec
|
|
2
|
1
|
if db file is in a folder with non-ansi character some functions fail
|
edit |
2671 |
code
|
active
|
2007 Sep
|
shess
|
|
2007 Sep
|
shess
|
2
|
4
|
Fts field-based queries are not correctly case-insensitive.
|
edit |
2558 |
code
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
2
|
3
|
Multiple JOIN USING() gives incorrect results
|
edit |
2539 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Sep
|
|
2
|
2
|
WinCE: Temporary etilqs_ files are not removed from temporary folder
|
edit |
2530 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
3
|
Unable to write to windows share, even with exclusive lock
|
edit |
2440 |
code
|
active
|
2007 Jun
|
rse
|
|
2007 Jun
|
|
2
|
2
|
pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS
|
edit |
2408 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
1
|
BLOBs not output correctly in .mode insert (shell.c - isnumber)
|
edit |
2398 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
systemcalls should be restarted when they return EINTR
|
edit |
2378 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
2
|
Quoted fields come back corrupted, using GROUP BY
|
edit |
2371 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
2
|
sqlite3_errcode() and sqlite3_errmsg() return unexpected results
|
edit |
2327 |
new
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
anonymous
|
2
|
1
|
"DELETE" operation makes memory rise
|
edit |
2294 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Sep
|
|
2
|
1
|
segfault when destroying lock on WinCE with threads
|
edit |
2238 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
2
|
3
|
Streams as datbase
|
edit |
2220 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
drh
|
2
|
4
|
fsck for database files
|
edit |
2219 |
code
|
active
|
2007 Feb
|
shess
|
|
2007 Feb
|
shess
|
2
|
2
|
Creating an fts table in an attached database works wrong.
|
edit |
2203 |
code
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
2
|
3
|
table_info pragma "default" column format changed?
|
edit |
2131 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
3
|
Add substring() function (Part of SQL 99)
|
edit |
2127 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
3
|
Virtual tables do not always free zErrmsg
|
edit |
2093 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
3
|
sqlite3_vtab_cursor doesn't have errMsg
|
edit |
2077 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
2
|
1
|
Problems with using ASCII symbols 0x80 - 0xFF in database path
|
edit |
2066 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
2
|
2
|
Incorrect error message in the case of ENOLCK
|
edit |
1996 |
new
|
active
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
drh
|
2
|
3
|
Data type CHAR
|
edit |
1983 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
2
|
2
|
I/O Error at a size of 4GB and auto_vacuum=1
|
edit |
1972 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
2
|
4
|
segfault on empty query
|
edit |
1948 |
code
|
active
|
2006 Aug
|
anonymous
|
Shell
|
2006 Aug
|
|
2
|
3
|
Double quotes are not escaped in csv mode
|
edit |
1946 |
code
|
new
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Dec
|
|
2
|
2
|
.read file fails on blob fields with end-of-file char
|
edit |
1928 |
new
|
active
|
2006 Aug
|
anonymous
|
Parser
|
2006 Aug
|
|
2
|
2
|
NULL rowid in views and subqueries
|
edit |
1924 |
new
|
active
|
2006 Aug
|
anonymous
|
Parser
|
2007 May
|
|
2
|
3
|
optimize queries on unions, constant folding
|
edit |
1901 |
code
|
active
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Jul
|
adamd
|
2
|
2
|
problem in select request with a alias table
|
edit |
1885 |
code
|
active
|
2006 Jul
|
anonymous
|
Shell
|
2006 Jul
|
|
2
|
3
|
sqlite3 .mode insert and .dump do not list column names for selects
|
edit |
1878 |
code
|
active
|
2006 Jun
|
anonymous
|
CodeGen
|
2006 Jun
|
|
2
|
3
|
No index used when specifying alias name in ORDER BY clause
|
edit |
1874 |
new
|
active
|
2006 Jun
|
anonymous
|
CodeGen
|
2006 Jun
|
|
2
|
3
|
IN is much slower than making separate queries
|
edit |
1856 |
code
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
2
|
3
|
SQLITE_OMIT_UTF16 breaks 'make test'
|
edit |
1851 |
code
|
active
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
2
|
1
|
USE "ORDER BY" error on uClinux
|
edit |
1850 |
code
|
active
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
2
|
1
|
NUMERIC data type ERROE when read on uClinux
|
edit |
1799 |
code
|
active
|
2006 May
|
anonymous
|
Pager
|
2006 May
|
|
2
|
3
|
temp_store=MEMORY slower than FILE for large intermediate result sets
|
edit |
1777 |
code
|
active
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
2
|
4
|
Cygwin should be OS_UNIX target, not OS_WIN
|
edit |
1754 |
code
|
active
|
2006 Apr
|
anonymous
|
Pager
|
2006 Apr
|
anonymous
|
2
|
2
|
Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
|
edit |
1742 |
code
|
active
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
drh
|
2
|
3
|
ORDER BY on more than one column causes a big slowdown
|
edit |
1703 |
new
|
active
|
2006 Mar
|
anonymous
|
Pager
|
2006 Mar
|
|
2
|
3
|
Second parameter to gettimeofday() in os_unix.c should be NULL
|
edit |
1700 |
code
|
active
|
2006 Mar
|
anonymous
|
Parser
|
2006 Mar
|
|
2
|
2
|
Handling column names for aliased queries is broken
|
edit |
1689 |
new
|
active
|
2006 Feb
|
anonymous
|
|
2006 Mar
|
|
2
|
4
|
triggers and temporary tables
|
edit |
1542 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
2
|
4
|
wrong field names in views with quoted table name qualifiers
|
edit |
1502 |
code
|
active
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
anonymous
|
2
|
3
|
When selected in a union, view column names are incorrect.
|
edit |
1458 |
code
|
active
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
|
2
|
2
|
Error at .importing in csv format (another)
|
edit |
1327 |
code
|
active
|
2005 Jul
|
ghaering
|
VDBE
|
2005 Jul
|
|
2
|
3
|
UNION causes sqlite3_column_decltype to always return NULL
|
edit |
1222 |
code
|
active
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
2
|
4
|
spec file errors
|
edit |
1214 |
code
|
active
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
2
|
3
|
sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects
|
edit |
1200 |
code
|
active
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
2
|
3
|
new versions of SQLite return different (incorrect) results.
|
edit |
1191 |
code
|
active
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
2
|
3
|
last_insert_id() Does Not Work after Insert on View
|
edit |
1149 |
code
|
active
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
2
|
1
|
VACUUM, DUMP/RESTORE fail in certain cases
|
edit |
1126 |
new
|
active
|
2005 Feb
|
anonymous
|
Unknown
|
2007 Jan
|
drh
|
2
|
3
|
sqlite 2.8.16 port to djgpp
|
edit |
1085 |
code
|
active
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
2
|
3
|
pragma full_column_names and short_column_names still broken
|
edit |
1078 |
code
|
active
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
2
|
3
|
Lemon destructor bugs that don't affect sqlite
|
edit |
1030 |
code
|
active
|
2004 Dec
|
anonymous
|
Shell
|
2005 Apr
|
|
2
|
3
|
impossible to import a file and do other things in the same invocation (strongly affects scripting)
|
edit |
930 |
new
|
active
|
2004 Sep
|
anonymous
|
Unknown
|
2007 Mar
|
drh
|
2
|
2
|
djgpp port for sqlite3
|
edit |
754 |
code
|
active
|
2004 Jun
|
anonymous
|
Shell
|
2004 Jun
|
drh
|
2
|
3
|
problem opening a dbfile in the upper directory (../dbname)
|
edit |
744 |
code
|
active
|
2004 May
|
anonymous
|
BTree
|
2004 May
|
anonymous
|
2
|
2
|
make test seg faults on x86_64 Linux
|
edit |
718 |
new
|
active
|
2004 May
|
anonymous
|
|
2004 May
|
anonymous
|
2
|
2
|
Case insensitive index ?
|
edit |
717 |
new
|
active
|
2004 May
|
anonymous
|
Unknown
|
2004 May
|
drh
|
2
|
2
|
minor fixes and port to dos
|
edit |
700 |
code
|
active
|
2004 Apr
|
anonymous
|
VDBE
|
2004 Apr
|
|
2
|
3
|
Solaris-sparc segfaults on sum()
|
edit |
524 |
new
|
active
|
2003 Dec
|
anonymous
|
Unknown
|
2003 Dec
|
|
2
|
1
|
port of sqlite to dos with short file names
|
edit |
301 |
code
|
active
|
2003 Apr
|
anonymous
|
Unknown
|
2003 Apr
|
|
2
|
3
|
Can't acquire lock for database on Mac OS X AppleShare volume
|
edit |
203 |
new
|
active
|
2002 Dec
|
anonymous
|
Unknown
|
2002 Dec
|
anonymous
|
2
|
1
|
Missing Win32 open flag if shared database
|
edit |
2914 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
|
edit |
2908 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
Add support to examine whether statements modify the database
|
edit |
2902 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
drh
|
3
|
3
|
Add watch support to SQLite
|
edit |
2901 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
ROLLBACK and COMMIT statements should not expire
|
edit |
2886 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
testfixture: -fPIC needed when building extension(s)
|
edit |
2882 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
fulltest failure: ./testfixture: wrong # args: should be "cksum db"
|
edit |
2875 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
2
|
LIKE does not work with lowercase swedish characters
|
edit |
2859 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
drh
|
3
|
2
|
Inconsistent column names with DISTINCT
|
edit |
2831 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
alter view
|
edit |
2825 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
FormatMessage (win32) should use extra flag and convert from Unicode
|
edit |
2821 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
hashtable indicies
|
edit |
2814 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
_XOPEN_SOURCE again
|
edit |
2793 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
fts3 lacks scoping
|
edit |
2761 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
CLI (shell.c) should be bundled with amalgamation
|
edit |
2755 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
trace interfere with transaction Tcl interface
|
edit |
2753 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
drh
|
3
|
3
|
Master journal files sometimes not deleted
|
edit |
2714 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
drh
|
3
|
4
|
Shell cannot import large files greater than 2 GB [patch]
|
edit |
2703 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
make test does not work with SQLITE_OMIT_FLOATING_POINT
|
edit |
2674 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
4
|
NFS fails without lock manager
|
edit |
2653 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
4
|
Exclusive Transactions do not work with a Database File attached twice
|
edit |
2634 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
3
|
.schema uses incorrect ORDER BY giving wrong dependency order
|
edit |
2627 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
2
|
Improper parsing of nested JOIN
|
edit |
2613 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2008 Jan
|
drh
|
3
|
3
|
replace doesn't work with blobs containing \x0, otherwise it does
|
edit |
2568 |
new
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
TEMP_STORE is ignored in some cases
|
edit |
2511 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
drh
|
3
|
2
|
Inconsistent Pragma output
|
edit |
2506 |
new
|
active
|
2007 Jul
|
anonymous
|
|
2008 Jan
|
|
3
|
2
|
New API to retrieve ROWID from SQLite3_stmt structire
|
edit |
2503 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
4
|
sqlite3PagerReleaseMemory does not decrement page count
|
edit |
2498 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
2
|
sqlite memory org on linux
|
edit |
2443 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
3
|
sqlite should return different exit codes for different errors
|
edit |
2438 |
new
|
active
|
2007 Jun
|
rse
|
|
2007 Jun
|
|
3
|
3
|
More easily allow the building of SQLite with FTS1 and FTS2
|
edit |
2417 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Nov
|
drh
|
3
|
3
|
Idea for read write concurrency.
|
edit |
2383 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
Inconsistent conversion of BLOB revisited
|
edit |
2376 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
-batch doesn't work soon enough
|
edit |
2363 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
Couldn't build 3.3.17 on Cygwin/Vista
|
edit |
2340 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
"./configure && make testfixture" link problem
|
edit |
2297 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
drh
|
3
|
3
|
uninitialized var (with patch)
|
edit |
2282 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
3
|
4
|
Update on view with no matching trigger does not raise error
|
edit |
2266 |
new
|
active
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
anonymous
|
3
|
3
|
Add support for Row_Number() Over
|
edit |
2241 |
code
|
active
|
2007 Feb
|
scouten
|
|
2007 Mar
|
|
3
|
3
|
pragma integrity_check no longer affects command-line tool's exit code
|
edit |
2228 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2008 Feb
|
|
3
|
4
|
horizontal partitioning
|
edit |
2223 |
code
|
active
|
2007 Feb
|
scouten
|
|
2007 Nov
|
|
3
|
3
|
pragma auto_vacuum doesn't survive .dump & reconstitute
|
edit |
2221 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
drh
|
3
|
4
|
Store blobs using inode-like lookup of pages rather than linked list
|
edit |
2218 |
code
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
3
|
4
|
select columns from views with table prefix
|
edit |
2207 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 May
|
|
3
|
4
|
"CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints
|
edit |
2140 |
code
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
3
|
1
|
sqlite doesn't link to readline
|
edit |
2132 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
4
|
table_info, index_list, index_info & friends should be virtual tables
|
edit |
2126 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
1
|
Update hook not invoked when deleteing all rows from table
|
edit |
2096 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
3
|
ATTACH DATABASE returns SQLITE_ERROR when database is locked
|
edit |
2089 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
3
|
Decouple sqlite_int64 from other 64bit datatypes
|
edit |
2087 |
new
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
3
|
Ability to add a check constraint via the alter table command
|
edit |
2082 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
4
|
UNIX: configure script doesn't enable loading of extensions
|
edit |
2075 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2007 Feb
|
|
3
|
3
|
Improve VACUUM speed and INDEX page locality
|
edit |
2057 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
1
|
full_column_names when 2 or more tables are joined is not working
|
edit |
2011 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
3
|
2
|
Escaping Porblem with .mode insert (double apostrophe)
|
edit |
2010 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
3
|
3
|
Timeout ignored in Shared-Cache locking model
|
edit |
1947 |
code
|
active
|
2006 Aug
|
anonymous
|
Shell
|
2006 Aug
|
|
3
|
3
|
".mode insert" works bad with BLOBs
|
edit |
1893 |
code
|
active
|
2006 Jul
|
anonymous
|
|
2006 Aug
|
|
3
|
3
|
sqlite doesn't use indexes containing primary key in prim. key selects
|
edit |
1890 |
code
|
active
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Jul
|
|
3
|
4
|
double quotes ("") in a query are ambiguous
|
edit |
1884 |
code
|
active
|
2006 Jul
|
anonymous
|
|
2006 Jul
|
|
3
|
2
|
pragma table_info caches results from previous query
|
edit |
1864 |
new
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
drh
|
3
|
3
|
List availabe SQL functions
|
edit |
1857 |
code
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
3
|
4
|
Can't use ISO 8601 dates with time zone designator 'Z'
|
edit |
1853 |
code
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
3
|
4
|
sqlite3_analyzer-3.3.4 integer overflows on large database
|
edit |
1822 |
code
|
active
|
2006 May
|
anonymous
|
|
2006 Sep
|
|
3
|
3
|
Table Alias together with Subquery seems not to work proper
|
edit |
1815 |
code
|
active
|
2006 May
|
anonymous
|
Parser
|
2006 May
|
|
3
|
3
|
Support of W3C-DTF(ISO8601 subset) is incomplete
|
edit |
1814 |
new
|
active
|
2006 May
|
anonymous
|
|
2006 May
|
|
3
|
4
|
Autoconf support for MacOSX univeral binaries
|
edit |
1810 |
new
|
active
|
2006 May
|
anonymous
|
|
2006 May
|
|
3
|
3
|
localtime() not threadsafe on UNIX
|
edit |
1790 |
code
|
active
|
2006 May
|
anonymous
|
Pager
|
2006 May
|
|
3
|
3
|
:memory: performance difference between v2 and v3
|
edit |
1783 |
code
|
active
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
3
|
2
|
insert times increase with growing table size (when indexed)
|
edit |
1781 |
new
|
active
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
3
|
5
|
Interleaved sqlite_step behaves inconsistently
|
edit |
1743 |
code
|
active
|
2006 Mar
|
anonymous
|
Parser
|
2006 Mar
|
|
3
|
3
|
A very very deep IN statement failure
|
edit |
1720 |
new
|
active
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
3
|
4
|
Actions made by a trigger are not triggered
|
edit |
1633 |
code
|
active
|
2006 Jan
|
anonymous
|
VDBE
|
2006 Apr
|
|
3
|
3
|
sqlite3_step returns SQLITE_ERROR when interrupted
|
edit |
1573 |
code
|
active
|
2005 Dec
|
anonymous
|
Shell
|
2005 Dec
|
|
3
|
3
|
Bad CSV output when data contains double quotes
|
edit |
1558 |
new
|
active
|
2005 Dec
|
anonymous
|
VDBE
|
2005 Dec
|
|
3
|
4
|
Request more debugging info when SQL statements in progress
|
edit |
1550 |
new
|
active
|
2005 Dec
|
anonymous
|
Unknown
|
2005 Dec
|
|
3
|
3
|
Triggers across attached databases
|
edit |
1521 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
3
|
2
|
ORDER BY sorts incorrectly with aliased fields
|
edit |
1519 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
3
|
4
|
Size double with blob data on UPDATE ?
|
edit |
1493 |
code
|
active
|
2005 Oct
|
anonymous
|
Parser
|
2005 Oct
|
|
3
|
3
|
lemon: pathsearch uses wrong directory separator under Win32
|
edit |
1489 |
code
|
active
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
3
|
2
|
Bad permissions on install-sh prevent 'make install' from completing
|
edit |
1485 |
code
|
active
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
jshen
|
3
|
1
|
cyrilic problem(suppose Unicode as a whole, for PPC)
|
edit |
1457 |
code
|
active
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
|
3
|
1
|
non-latin chars not recognized by CLI
|
edit |
1455 |
code
|
active
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
|
3
|
2
|
.import error: comma inside a string is read as field separator
|
edit |
1445 |
code
|
active
|
2005 Sep
|
anonymous
|
|
2006 Sep
|
|
3
|
3
|
Errors testing sqlite 3.2.6 (& v3.3.7)
|
edit |
1428 |
code
|
active
|
2005 Sep
|
anonymous
|
TclLib
|
2005 Sep
|
|
3
|
3
|
tclinstaller.tcl script problems
|
edit |
1423 |
new
|
active
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
drh
|
3
|
4
|
Binding NULL does not work as expected
|
edit |
1417 |
new
|
active
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
drh
|
3
|
3
|
Fix successive access to a DB handler (unix broken thread file lock)
|
edit |
1365 |
code
|
active
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
3
|
3
|
64 bit types not completely overridable
|
edit |
1308 |
code
|
active
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
3
|
4
|
PRAGMA TABLE_INFO does not recognize attached database syntax.
|
edit |
1294 |
new
|
active
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
3
|
3
|
API to get ordinal table name
|
edit |
1264 |
code
|
active
|
2005 May
|
anonymous
|
Unknown
|
2005 May
|
|
3
|
3
|
access() undefined on MSVC
|
edit |
1254 |
new
|
active
|
2005 May
|
anonymous
|
Pager
|
2005 May
|
|
3
|
3
|
better pager_cksum
|
edit |
1248 |
code
|
active
|
2005 May
|
anonymous
|
Unknown
|
2005 May
|
|
3
|
1
|
sqlite3_get_table returns garbage for BLOB data
|
edit |
1242 |
code
|
active
|
2005 May
|
anonymous
|
Shell
|
2007 Aug
|
|
3
|
4
|
EXPLAIN causes segmentation fault on OSX (and linux)
|
edit |
1223 |
code
|
active
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
3
|
4
|
.read FILENAME fails
|
edit |
1213 |
code
|
active
|
2005 Apr
|
anonymous
|
Parser
|
2005 Apr
|
|
3
|
2
|
Problem with alias columns in subqueries
|
edit |
1205 |
code
|
active
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
3
|
1
|
accent ecu etc. in connectionstring
|
edit |
1134 |
code
|
active
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
drh
|
3
|
3
|
select command with a view and a condition gets no result
|
edit |
1112 |
code
|
active
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
3
|
4
|
make test failures (108 out of 19721) on AIX 5.2, Power5 CPU
|
edit |
1111 |
code
|
active
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Jun
|
|
3
|
1
|
no such column error with a subselect as a table
|
edit |
1100 |
code
|
active
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
3
|
3
|
make test segfaults at capi2-7.12 on amd64 system
|
edit |
1058 |
code
|
active
|
2005 Jan
|
anonymous
|
BTree
|
2005 Jan
|
|
3
|
3
|
btree.c pageSize -> usableSize
|
edit |
1056 |
code
|
active
|
2004 Dec
|
anonymous
|
Shell
|
2004 Dec
|
|
3
|
3
|
test pragma-9.4 fails during second pass in "make fulltest"
|
edit |
1053 |
code
|
active
|
2004 Dec
|
anonymous
|
Pager
|
2004 Dec
|
|
3
|
3
|
SQLITE_IOERR and strange rollback when db is busy
|
edit |
1031 |
new
|
active
|
2004 Dec
|
anonymous
|
|
2005 Jan
|
|
3
|
4
|
sqlite command line does not allow intermixing of dot commands and sql
|
edit |
1026 |
code
|
active
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
3
|
3
|
sqlite automake sqlite3.pc file does not have version information
|
edit |
969 |
code
|
new
|
2004 Oct
|
anonymous
|
TclLib
|
2005 Jan
|
|
3
|
3
|
PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so part 2
|
edit |
965 |
new
|
active
|
2004 Oct
|
anonymous
|
VDBE
|
2004 Oct
|
|
3
|
3
|
Busy Handler not invoked for SELECT et.al. in SQLite <= 2.8.15
|
edit |
923 |
code
|
active
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
anonymous
|
3
|
2
|
Missing quotes in 2.8.15 .dump cause data loss when loading in sqlite3
|
edit |
867 |
new
|
active
|
2004 Aug
|
anonymous
|
Parser
|
2006 Jan
|
|
3
|
2
|
update on multiple tables
|
edit |
843 |
new
|
active
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Aug
|
|
3
|
3
|
Introducing I64 printf size prefix
|
edit |
841 |
code
|
active
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Aug
|
|
3
|
2
|
inner group by query isn't honored by outer count(*) aggregate
|
edit |
783 |
code
|
active
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
|
3
|
3
|
Build on MAC with -DSQLITE_DEBUG=1 compile error
|
edit |
748 |
new
|
active
|
2004 May
|
anonymous
|
|
2004 May
|
|
3
|
3
|
option to allow ignoring trailing whitespace in selects
|
edit |
739 |
new
|
active
|
2004 May
|
anonymous
|
Unknown
|
2004 May
|
danielk1977
|
3
|
1
|
Suggestion speed query
|
edit |
737 |
new
|
active
|
2004 May
|
anonymous
|
Shell
|
2004 May
|
anonymous
|
3
|
3
|
xml export
|
edit |
721 |
code
|
active
|
2004 May
|
anonymous
|
Shell
|
2004 May
|
drh
|
3
|
2
|
empty .databases information
|
edit |
714 |
new
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
drh
|
3
|
3
|
Change sqlite_decode_binary to return buffer size
|
edit |
712 |
new
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
drh
|
3
|
3
|
Allow temporary databases to be created in specified folder
|
edit |
711 |
new
|
active
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
drh
|
3
|
3
|
Provide a callback function to verify values before insert or update
|
edit |
710 |
new
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
drh
|
3
|
4
|
Provide the ability to pass a user-data value during sqlite_compile
|
edit |
707 |
new
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
drh
|
3
|
3
|
how to use internal functions?
|
edit |
684 |
code
|
active
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
|
3
|
2
|
Incorrect function result type when using SQLITE_ARGS
|
edit |
627 |
code
|
active
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
3
|
3
|
sqliteRunVacuum returning wrong code?
|
edit |
608 |
code
|
active
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
3
|
3
|
Problem with "pragma show_datatypes = on" and busy timeout
|
edit |
575 |
code
|
active
|
2004 Jan
|
anonymous
|
VDBE
|
2004 Mar
|
drh
|
3
|
3
|
pragma (default_)temp_store implementations seems incomplete
|
edit |
572 |
new
|
active
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
drh
|
3
|
3
|
sqlite 2.8.11 port to djgpp
|
edit |
518 |
code
|
active
|
2003 Dec
|
anonymous
|
Unknown
|
2006 Aug
|
|
3
|
4
|
PRIMARY KEY does not imply UNIQUE and NOT NULL
|
edit |
448 |
new
|
active
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
drh
|
3
|
3
|
a general bug-fix and dos support without lfn
|
edit |
420 |
new
|
active
|
2003 Jul
|
anonymous
|
VDBE
|
2003 Jul
|
|
3
|
3
|
Not abort transaction when callback is cancelled
|
edit |
414 |
code
|
active
|
2003 Jul
|
anonymous
|
VDBE
|
2003 Nov
|
|
3
|
4
|
sqlite_compile() and database schema changes
|
edit |
404 |
new
|
active
|
2003 Jul
|
anonymous
|
|
2003 Dec
|
|
3
|
3
|
new C API: sqlite_get_table_with_types with type information
|
edit |
369 |
code
|
active
|
2003 Jun
|
anonymous
|
|
2004 Jan
|
|
3
|
2
|
Testsuite fails on btree-1.1.1 (Mac OS X, SQLite 2.8.4)
|
edit |
368 |
code
|
active
|
2003 Jun
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
UPDATE trigger doesn't fire on INSERT OR REPLACE
|
edit |
330 |
code
|
active
|
2003 May
|
anonymous
|
VDBE
|
2003 May
|
|
3
|
4
|
Aggregator's error are ignored
|
edit |
279 |
new
|
active
|
2003 Apr
|
anonymous
|
|
2003 May
|
|
3
|
3
|
WinCE port of CVS version as of 02 Apr 2003
|
edit |
243 |
new
|
active
|
2003 Feb
|
anonymous
|
Unknown
|
2003 Oct
|
anonymous
|
3
|
4
|
Performance problem with MSVC precompiled DLL
|
edit |
236 |
new
|
active
|
2003 Jan
|
anonymous
|
|
2003 Feb
|
|
3
|
3
|
Add RENAME TABLE - will be easier to work around missing ALTER TABLE
|
edit |
154 |
code
|
active
|
2002 Sep
|
drh
|
Pager
|
2007 Jun
|
drh
|
3
|
3
|
Prohibit links on database files.
|
edit |
139 |
new
|
active
|
2002 Aug
|
anonymous
|
Pager
|
2002 Aug
|
|
3
|
3
|
Named transactions are misleading as documented
|
edit |
93 |
new
|
active
|
2002 Jul
|
anonymous
|
|
2004 Jan
|
|
3
|
3
|
Can't open database when TEMP environment variable is not defined well
|
edit |
2917 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Feb
|
|
4
|
4
|
Tcl interface - busy callback confusion script/procedure
|
edit |
2899 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
sqlite3_reset() after exec() takes > 100 ms to complete
|
edit |
2885 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
(minor) fulltest failures
|
edit |
2884 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
Way to find out limits
|
edit |
2879 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
anonymous
|
4
|
3
|
VACUUM enters temporary sequence numbers in sqlite_sequence
|
edit |
2872 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
Some table scan operations could use an index for better data density
|
edit |
2771 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
4
|
Lemon: Generated parser needs stdlib.h (not in default template)
|
edit |
2728 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
Some indexes could contain pointers not the data
|
edit |
2708 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
2
|
SQL error:disk I/O error
|
edit |
2705 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
testfixture unresolved externals with SQLITE_OMIT_GET_TABLE
|
edit |
2704 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
"make test" aborts before completion with SQLITE_OMIT_BLOB_LITERAL
|
edit |
2649 |
new
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
4
|
4
|
Add an "--enable-extensions" (default=no) to the configure script
|
edit |
2604 |
new
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
4
|
4
|
CREATE VIRTUAL TABLE does not allow IF NOT EXISTS
|
edit |
2559 |
code
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
4
|
4
|
"make clean" does not delete sqlite3.c and tsrc/
|
edit |
2520 |
new
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
1
|
User defined aggregate functions are not reentrant
|
edit |
2467 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
changes() not reporting correctly after DELETE FROM table
|
edit |
2459 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
changes() not reporting correctly after "failed" multiline INSERT
|
edit |
2448 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
3
|
SQLITE needs to identify public exported symbols
|
edit |
2393 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
pragma cache_size not accurate when set to less than 10
|
edit |
2392 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
Reduce MemPage and PgHdr struct sizes. Better page memory utilization.
|
edit |
2373 |
new
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
"create table as explain <expr>" doesn't work
|
edit |
2372 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
sqlite3TestLockingStyle not used if SQLITE_FIXED_LOCKING_STYLE defined
|
edit |
2310 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
anonymous
|
4
|
4
|
Problem installing on AIX 5.3, ML5 after successful compile with xlc
|
edit |
2288 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
2
|
FTS does not support REPLACE
|
edit |
2280 |
new
|
active
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
4
|
3
|
Check constraint failure message should include field name
|
edit |
2258 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
|
4
|
3
|
Include field name in check constraint failure message
|
edit |
2237 |
code
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
4
|
4
|
Test suite regressions using Tcl 8.5
|
edit |
2235 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
4
|
3
|
Missing xml support in FTS2 for the snippet function
|
edit |
2233 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
|
4
|
3
|
extend xBestIndex in vtables to carry the values for each contraint
|
edit |
2231 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
|
4
|
4
|
shell should ignore leading whitespace for meta commands
|
edit |
2224 |
new
|
active
|
2007 Feb
|
scouten
|
|
2007 Feb
|
|
4
|
4
|
Option to have one-bit "journal should exist" flag
|
edit |
2182 |
code
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
sqlite3BtreeGetMeta does not check the file format
|
edit |
2165 |
code
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
4
|
3
|
pager performance and checksum
|
edit |
2130 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
4
|
replace "long long int" type with "sqlite_int64" defined in sqlite3.h
|
edit |
2128 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
3
|
virtual table code doesn't verify type of rowid (calling xUpdate)
|
edit |
2125 |
code
|
new
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
4
|
SQLite strings/blobs limited to 1GB/2GB due to 'int' in api
|
edit |
2084 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
3
|
Add API function mapping column decl string to SQLite type
|
edit |
2083 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
Give more detailed extension loading error information with dlerror
|
edit |
2080 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
Tranfering large BLOB data not efficient
|
edit |
2074 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
feature request: .dump with page_size
|
edit |
2070 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
No error for ambiguous result alias in WHERE clause
|
edit |
2068 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
pkgIndex.tcl contains incomplete version number
|
edit |
2063 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
vtab_err.test fails if sqlite is compiled without -DSQLITE_MEMDEBUG
|
edit |
2062 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
document 'pk' column of PRAGMA table_info()
|
edit |
2041 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2007 Mar
|
|
4
|
4
|
sqlite3.pc on Solaris needs -lrt in "Libs:" entry
|
edit |
2028 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
4
|
2
|
FTS1: UNIQUE() expression and UPDATE command not working
|
edit |
2026 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
4
|
5
|
\n in .output is not allowed even with quote
|
edit |
2014 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
anonymous
|
4
|
3
|
Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE
|
edit |
2013 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
drh
|
4
|
3
|
Autoincrement increments on failing INSERT OR IGNORE
|
edit |
2012 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
4
|
3
|
trigger4.test aborts "make test" on Windows
|
edit |
1960 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
2
|
Issues with .import in sqlite.exe
|
edit |
1959 |
new
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
3
|
Unblockable TEMP TABLES
|
edit |
1958 |
code
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
4
|
some printf tests fail with Tcl 8.5a5, ok with Tcl 8.4
|
edit |
1953 |
code
|
active
|
2006 Sep
|
anonymous
|
TclLib
|
2006 Sep
|
|
4
|
3
|
Fix for false 64-bit comparisons "make test" failures on Cygwin
|
edit |
1942 |
new
|
active
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
select without left join with the *= operator
|
edit |
1907 |
new
|
active
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
date and time types
|
edit |
1872 |
code
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
4
|
3
|
sqlite3_open doesn't support RFC1738 format for filename
|
edit |
1837 |
new
|
active
|
2006 Jun
|
anonymous
|
Pager
|
2006 Jun
|
|
4
|
4
|
Deadlock detection would be best reported using explicit error code.
|
edit |
1812 |
new
|
active
|
2006 May
|
anonymous
|
|
2006 May
|
|
4
|
1
|
alter table add column default current_timestamp
|
edit |
1804 |
code
|
active
|
2006 May
|
anonymous
|
Unknown
|
2006 May
|
|
4
|
3
|
Inconsistent value type returned by SUM when using a GROUP BY
|
edit |
1785 |
new
|
active
|
2006 Apr
|
anonymous
|
Shell
|
2006 Apr
|
|
4
|
3
|
rl_readline_name not set
|
edit |
1747 |
new
|
active
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
4
|
4
|
Non descriptive error message
|
edit |
1733 |
code
|
active
|
2006 Mar
|
anonymous
|
VDBE
|
2006 Mar
|
drh
|
4
|
3
|
Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
|
edit |
1722 |
new
|
active
|
2006 Mar
|
anonymous
|
Unknown
|
2007 Jan
|
|
4
|
2
|
agregate sum() of strings
|
edit |
1719 |
code
|
active
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
4
|
4
|
Solaris 8(SQL: bus error while creating temporary file
|
edit |
1714 |
code
|
active
|
2006 Mar
|
anonymous
|
CodeGen
|
2006 Mar
|
|
4
|
4
|
Slow query when tables in 2 different files
|
edit |
1704 |
new
|
active
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
4
|
3
|
extern "C" block in sqliteInt.h
|
edit |
1693 |
new
|
active
|
2006 Feb
|
anonymous
|
Parser
|
2006 Mar
|
|
4
|
4
|
Parser sensitive to position of word AUTOINCREMENT
|
edit |
1683 |
new
|
active
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
anonymous
|
4
|
3
|
.mode html produces uppercase tags
|
edit |
1679 |
new
|
active
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
4
|
4
|
SQLite requires code modification to replace memory allocation funcs
|
edit |
1663 |
new
|
active
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
|
4
|
4
|
Suggestion: DATETYPE field type using David Tribble's work?
|
edit |
1655 |
new
|
active
|
2006 Feb
|
anonymous
|
VDBE
|
2006 Mar
|
|
4
|
4
|
Every function can have their private data like agreagates
|
edit |
1653 |
new
|
active
|
2006 Feb
|
anonymous
|
CodeGen
|
2006 Feb
|
|
4
|
5
|
SQLITE_OMIT_COST_REORDERING ?
|
edit |
1648 |
new
|
active
|
2006 Jan
|
anonymous
|
Shell
|
2007 Dec
|
|
4
|
3
|
meaningful error message: constraint failed
|
edit |
1637 |
code
|
active
|
2006 Jan
|
anonymous
|
Parser
|
2006 Jan
|
|
4
|
4
|
Multiple JOIN USING() doesn't work.
|
edit |
1626 |
new
|
active
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
4
|
4
|
ALTER TABLE BUG/MISHEAVIOR
|
edit |
1588 |
new
|
active
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
4
|
common subexpression elimination not performed in SELECT
|
edit |
1532 |
new
|
active
|
2005 Nov
|
anonymous
|
TclLib
|
2005 Nov
|
|
4
|
4
|
Variables don't get replaced in ATTACH statements.
|
edit |
1515 |
code
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
4
|
3
|
Quotes incorrect included in colum names.
|
edit |
1500 |
code
|
active
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
|
4
|
4
|
MIssing file listing permission causes DB opening/creation to fail
|
edit |
1491 |
new
|
active
|
2005 Oct
|
anonymous
|
Shell
|
2005 Oct
|
|
4
|
4
|
syntax error with " .mode column:
|
edit |
1484 |
code
|
active
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
|
4
|
4
|
Solaris8 awk problem
|
edit |
1464 |
new
|
active
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
4
|
3
|
Improving PRAGMA table_info()
|
edit |
1451 |
code
|
active
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
|
4
|
3
|
.mode insert does not output BLOBs in an usable way
|
edit |
1441 |
code
|
active
|
2005 Sep
|
anonymous
|
VDBE
|
2005 Sep
|
|
4
|
4
|
sqlite3_clear_bindings routine missing
|
edit |
1403 |
code
|
active
|
2005 Sep
|
anonymous
|
Pager
|
2005 Sep
|
|
4
|
4
|
Newly initialized pages aren't completely cleared
|
edit |
1401 |
code
|
active
|
2005 Aug
|
anonymous
|
Shell
|
2005 Aug
|
|
4
|
4
|
concatenating html in select list
|
edit |
1313 |
new
|
active
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
4
|
4
|
Allow headers in imported text files
|
edit |
1298 |
code
|
active
|
2005 Jun
|
anonymous
|
Shell
|
2005 Oct
|
drh
|
4
|
3
|
sqlite3.exe not recognizing newline as comment terminator
|
edit |
1286 |
code
|
active
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
4
|
4
|
The downloadable DLL file does not work with Intel VTune
|
edit |
1255 |
code
|
active
|
2005 May
|
anonymous
|
|
2005 May
|
|
4
|
3
|
Decrease number of warnings with Microsoft Visual C++
|
edit |
1241 |
code
|
active
|
2005 May
|
anonymous
|
|
2005 May
|
|
4
|
5
|
sqlite3_create_collation16 - should have 'const void* zName' arg
|
edit |
1235 |
code
|
active
|
2005 May
|
anonymous
|
Unknown
|
2005 May
|
drh
|
4
|
3
|
inconsistent pragma handling
|
edit |
1228 |
code
|
active
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
4
|
3
|
problem with select+union on a view with aliased columns
|
edit |
1220 |
new
|
active
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
4
|
3
|
Selectable calling convention
|
edit |
1208 |
new
|
active
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
4
|
4
|
no version info provided in precompiled sqlite3.dll
|
edit |
1204 |
new
|
active
|
2005 Apr
|
anonymous
|
TclLib
|
2005 Apr
|
drh
|
4
|
2
|
(visible) version provided by tclsqlite package
|
edit |
1190 |
new
|
active
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
drh
|
4
|
4
|
strftime() does not Support Years with 3 or 5 digits
|
edit |
1186 |
new
|
active
|
2005 Mar
|
anonymous
|
Shell
|
2005 Mar
|
|
4
|
4
|
Pragma page_size doesn't set the pagesize immediately
|
edit |
1176 |
new
|
active
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
4
|
3
|
Blocking Writes
|
edit |
1061 |
new
|
active
|
2005 Jan
|
anonymous
|
Shell
|
2005 Jan
|
|
4
|
4
|
shell.c .import from stdin
|
edit |
1040 |
new
|
active
|
2004 Dec
|
anonymous
|
Unknown
|
2005 Apr
|
|
4
|
4
|
pragma needed to enable flexibility of insert statements (esp. for awk-like filter use)
|
edit |
944 |
new
|
active
|
2004 Oct
|
anonymous
|
Shell
|
2004 Oct
|
|
4
|
3
|
Command to abort current expression.
|
edit |
832 |
code
|
active
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
anonymous
|
4
|
4
|
os_win.c :: sqlite3OsUnlock() method has an unused variable: rc
|
edit |
797 |
new
|
active
|
2004 Jul
|
anonymous
|
Parser
|
2004 Jul
|
|
4
|
3
|
require basic named subquery / WITH sql support
|
edit |
738 |
new
|
active
|
2004 May
|
anonymous
|
|
2004 May
|
danielk1977
|
4
|
1
|
Sort order array in memory
|
edit |
736 |
new
|
active
|
2004 May
|
anonymous
|
|
2004 May
|
|
4
|
4
|
Would like to be able to list the LAST 10 lines of a query
|
edit |
735 |
code
|
active
|
2004 May
|
anonymous
|
Shell
|
2004 May
|
|
4
|
3
|
.sqliterc not processed if running on a driver other than C:
|
edit |
724 |
new
|
active
|
2004 May
|
anonymous
|
|
2004 May
|
|
4
|
5
|
VACUUM resets settings for the current session
|
edit |
673 |
new
|
active
|
2004 Mar
|
anonymous
|
Shell
|
2004 Apr
|
|
4
|
3
|
Format .dump nicer (patch)
|
edit |
566 |
new
|
active
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
4
|
4
|
[PATCH] Port of sqlite and lemon to an EBCDIC mainframe
|
edit |
563 |
new
|
active
|
2004 Jan
|
anonymous
|
Parser
|
2004 Jan
|
|
4
|
3
|
Support for autoincrement type "SERIAL" (from PostgreSQL)
|
edit |
538 |
new
|
active
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
4
|
3
|
Different warnings in windows
|
edit |
525 |
new
|
active
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
4
|
4
|
DB testing
|
edit |
498 |
new
|
active
|
2003 Nov
|
anonymous
|
Unknown
|
2003 Nov
|
|
4
|
4
|
Suggestion: Allow named parameters.
|
edit |
491 |
new
|
active
|
2003 Nov
|
anonymous
|
|
2003 Nov
|
|
4
|
4
|
Want to use SET col = 'val' with INSERT statement
|
edit |
490 |
new
|
active
|
2003 Nov
|
anonymous
|
VDBE
|
2003 Nov
|
xdong
|
4
|
3
|
a few api improvements for recordset operations
|
edit |
489 |
new
|
active
|
2003 Nov
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
DLL exports suggestion
|
edit |
479 |
new
|
active
|
2003 Oct
|
anonymous
|
Parser
|
2003 Oct
|
drh
|
4
|
3
|
Sequences
|
edit |
477 |
new
|
active
|
2003 Oct
|
anonymous
|
|
2003 Dec
|
anonymous
|
4
|
4
|
Are there any plans to enchance SQLite to support Unicode
|
edit |
465 |
new
|
active
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
4
|
3
|
data types should be implemented as formated strings
|
edit |
454 |
new
|
active
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
4
|
4
|
schema column types with parenthesis to automatically invoke functions
|
edit |
424 |
new
|
active
|
2003 Aug
|
anonymous
|
Shell
|
2003 Aug
|
|
4
|
3
|
Provide access to internal function _all_whitespace()
|
edit |
407 |
new
|
active
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
4
|
4
|
sqlite_compile etc. and pragma empty_result_callbacks.
|
edit |
403 |
code
|
active
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
4
|
4
|
Two small fixes in .spec file for RPMS
|
edit |
395 |
code
|
active
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
4
|
4
|
Error opening db on Mac OS X not reported correctly
|
edit |
366 |
new
|
active
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
drh
|
4
|
3
|
Functions sqlite_(en/de)code_binary() not in sqlite.h
|
edit |
326 |
new
|
active
|
2003 May
|
anonymous
|
|
2003 May
|
|
4
|
4
|
Request for additional callback for various functions
|
edit |
321 |
new
|
active
|
2003 May
|
anonymous
|
|
2003 May
|
|
4
|
3
|
Make SQLITE_ISO8859 and SQLITE_UTF8 overridable by compiler define
|
edit |
252 |
new
|
active
|
2003 Feb
|
anonymous
|
|
2003 Feb
|
|
4
|
1
|
Add optional regex matching similar to what Postgres & Oracle have
|
edit |
239 |
new
|
active
|
2003 Feb
|
anonymous
|
Unknown
|
2004 Jul
|
|
4
|
2
|
ANSI/Unicode(Wide) version file-handling functions for Win32
|
edit |
2912 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
5
|
4
|
merge join
|
edit |
2892 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
5
|
5
|
There should be a way in the api to read more precise error message.
|
edit |
2869 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
5
|
5
|
add "sqlite3_open16_v2" to the C API
|
edit |
2847 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
5
|
4
|
Include major, minor, and patch version numbers in sqlite.h
|
edit |
2760 |
new
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
request: sqlite3_unlink() to delete db files.
|
edit |
2716 |
new
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
5
|
1
|
Create Clear Command
|
edit |
2701 |
new
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
5
|
5
|
Make INSERT-ing multiple rows MySQL-compatible
|
edit |
2677 |
new
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
danielk1977
|
5
|
3
|
CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events
|
edit |
2651 |
new
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
5
|
4
|
Add support for overriding home directory location
|
edit |
2547 |
code
|
active
|
2007 Aug
|
danielk1977
|
|
2007 Aug
|
|
5
|
3
|
Changing db encoding of an attached db can confuse shared cache mode.
|
edit |
2540 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
5
|
4
|
Display dlopen() errors for errors when loading modules on Unix system
|
edit |
2496 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
5
|
4
|
"No such column" error should include table information
|
edit |
2488 |
new
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
5
|
4
|
autosize on column output mode in sqlite3 program
|
edit |
2484 |
new
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
5
|
4
|
Support for RETURNING
|
edit |
2474 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
4
|
Multiple-record comma-delineated INSERT command
|
edit |
2456 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
REQ: use index where applicable instead of full table scan
|
edit |
2411 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
3
|
fts2 RFE - Separate index and storage
|
edit |
2374 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
5
|
"ALTER TABLE foo RENAME TO bar" will quote bar (ie. 'bar')
|
edit |
2352 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
3
|
timeout just 500 msec to soon
|
edit |
2333 |
new
|
active
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
4
|
support memory mapped files
|
edit |
2329 |
new
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
5
|
4
|
add a feature to .dump : partial dumps
|
edit |
2256 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Apr
|
drh
|
5
|
1
|
Add POSITION() function (SQL-92 standard)
|
edit |
2254 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
4
|
ATTACH support IF NOT ATTACHED statement
|
edit |
2226 |
code
|
active
|
2007 Feb
|
scouten
|
|
2007 Feb
|
|
5
|
4
|
Report on unused indices (and tables?)
|
edit |
2225 |
code
|
active
|
2007 Feb
|
scouten
|
|
2007 Feb
|
|
5
|
4
|
Request count of number of inserts and deletes from the free page list
|
edit |
2214 |
code
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
4
|
lemon generates bad error messages for %destructor
|
edit |
2206 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
Support for foreign key constraints in virtual tables
|
edit |
2204 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Feb
|
|
5
|
3
|
Stable, documented metadata interface
|
edit |
2202 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
function request: sqlite3_attach()
|
edit |
2200 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
threadsafe status not reported in .pc file
|
edit |
2198 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
API: opening only existing databases
|
edit |
2185 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
3
|
API access to opened database pathname - helpful for virtual tables
|
edit |
2181 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
Generalize ON CONFLICT to failure trapping for all SQL statements
|
edit |
2180 |
new
|
active
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
4
|
feature request: DROP TABLE IF [EXISTS AND] EMPTY
|
edit |
2120 |
new
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
Date Column support
|
edit |
2112 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
code compatibility with C++
|
edit |
2105 |
new
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
5
|
sqlite3_exec does not return modified rows
|
edit |
2086 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
5
|
4
|
Alias in update
|
edit |
2061 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
anonymous
|
5
|
5
|
cleanup for quickstart.html
|
edit |
2051 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
5
|
5
|
minor documentation bug
|
edit |
2025 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
drh
|
5
|
5
|
Add pragama command to return loaded extension list
|
edit |
2024 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
drh
|
5
|
5
|
Add If not exist syntax to Create Virtual Table
|
edit |
2015 |
code
|
active
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
anonymous
|
5
|
4
|
Enhancement Req: "EXPRn" PRAGMA for result set expression column names
|
edit |
1975 |
new
|
active
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
5
|
4
|
Request for sqlite3_table_column_metadata16
|
edit |
1933 |
new
|
active
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
5
|
4
|
Add different date's separators
|
edit |
1905 |
new
|
active
|
2006 Aug
|
anonymous
|
VDBE
|
2006 Aug
|
|
5
|
4
|
Get bound param as sqlite3_value?
|
edit |
1902 |
new
|
active
|
2006 Jul
|
anonymous
|
Parser
|
2006 Jul
|
|
5
|
3
|
allow alternate INSERT syntax using SET foo=bar
|
edit |
1838 |
code
|
active
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
5
|
5
|
test types3-1.3 fails on 64-bit Linux
|
edit |
1801 |
new
|
active
|
2006 May
|
anonymous
|
Pager
|
2006 May
|
owensmk
|
5
|
4
|
Include Support for User-defined Lock Synchronization
|
edit |
1788 |
new
|
active
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
5
|
5
|
memory allocator able to return with several allocated bloks at once
|
edit |
1772 |
new
|
active
|
2006 Apr
|
anonymous
|
TclLib
|
2006 Apr
|
|
5
|
5
|
db eval {QUERY} { do something } ELSE { there was no match }
|
edit |
1770 |
new
|
active
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
5
|
4
|
Request for expanded DELETE USING keyword like PostgreSQL
|
edit |
1769 |
new
|
active
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
drh
|
5
|
5
|
Is there any djgpp port for 3-3-5
|
edit |
1702 |
new
|
active
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
5
|
4
|
feature request: API to write in-memory DB to file.
|
edit |
1675 |
new
|
active
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
5
|
4
|
sqlite3_db_dup() ?
|
edit |
1621 |
code
|
active
|
2006 Jan
|
danielk1977
|
|
2006 Jan
|
|
5
|
5
|
Compiling with OMIT_FLOATING_POINT causes a segfault in the test suite
|
edit |
1566 |
new
|
active
|
2005 Dec
|
ghaering
|
VDBE
|
2005 Dec
|
|
5
|
4
|
Implement sqlite3_clone()
|
edit |
1552 |
new
|
active
|
2005 Dec
|
anonymous
|
Unknown
|
2005 Dec
|
|
5
|
4
|
Adding .read FILE support to the C API
|
edit |
1528 |
new
|
active
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
5
|
4
|
Add Build Date To Command Line Greeting
|
edit |
1476 |
new
|
active
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
5
|
4
|
Patch for SQLite sequence manipulation functions
|
edit |
1475 |
new
|
active
|
2005 Oct
|
anonymous
|
Parser
|
2005 Oct
|
anonymous
|
5
|
5
|
sytax error near autoincrement
|
edit |
1468 |
new
|
active
|
2005 Oct
|
anonymous
|
Parser
|
2005 Oct
|
|
5
|
5
|
Added Mysql function CONCAT
|
edit |
1424 |
new
|
active
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
5
|
3
|
Pivot table creation
|
edit |
1400 |
new
|
active
|
2005 Aug
|
anonymous
|
|
2005 Sep
|
|
5
|
5
|
Use of indexes in queries to VIEWS built from UNION SELECTS
|
edit |
1381 |
new
|
active
|
2005 Aug
|
anonymous
|
Parser
|
2005 Aug
|
|
5
|
4
|
missing important builtin function stdev
|
edit |
1332 |
new
|
active
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
|
5
|
5
|
update 20x slower when using a temp table
|
edit |
1319 |
new
|
active
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
5
|
4
|
Extend sqlite3_expired to detect schema changes
|
edit |
1262 |
new
|
active
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
5-15% performance increase for slow joins
|
edit |
1249 |
new
|
active
|
2005 May
|
anonymous
|
Unknown
|
2005 May
|
|
5
|
4
|
transaction
|
edit |
1227 |
new
|
active
|
2005 Apr
|
anonymous
|
Shell
|
2005 Apr
|
|
5
|
2
|
Small patch for timing commands in shell.c
|
edit |
1221 |
new
|
active
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
5
|
4
|
Implementation of PRAGMA trigger_info(table)
|
edit |
1011 |
new
|
active
|
2004 Nov
|
anonymous
|
|
2004 Nov
|
|
5
|
4
|
No .lib file for in windows precompiled binaries
|
edit |
974 |
new
|
active
|
2004 Oct
|
anonymous
|
|
2005 Dec
|
|
5
|
4
|
Version-Resource in pre-compiled windows dll
|
edit |
931 |
new
|
active
|
2004 Sep
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
Makefile for mingw on Win32, makes DLL, EXE and docs
|
edit |
845 |
new
|
active
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
5
|
4
|
Support shared-memory databases
|
edit |
824 |
new
|
active
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
5
|
4
|
StrSum - new build-in aggreate function suggestion
|
edit |
823 |
new
|
active
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
5
|
4
|
absent VERSIONINFO into any Win32 DLL
|
edit |
763 |
code
|
active
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
|
5
|
4
|
tclsqlite.dll not showing the correct version
|
edit |
755 |
new
|
active
|
2004 Jun
|
anonymous
|
TclLib
|
2004 Jun
|
drh
|
5
|
2
|
Adding aggregate function to the tcl binding
|
edit |
742 |
new
|
active
|
2004 May
|
anonymous
|
VDBE
|
2004 May
|
anonymous
|
5
|
5
|
database is locked
|
edit |
741 |
new
|
active
|
2004 May
|
anonymous
|
CodeGen
|
2004 May
|
anonymous
|
5
|
5
|
command tool does not support history
|
edit |
726 |
new
|
active
|
2004 May
|
anonymous
|
Parser
|
2004 May
|
anonymous
|
5
|
5
|
As to single quote
|
edit |
725 |
new
|
active
|
2004 May
|
anonymous
|
|
2006 Aug
|
anonymous
|
5
|
5
|
Implement ATTACH LIB comand
|
edit |
723 |
new
|
active
|
2004 May
|
anonymous
|
Unknown
|
2004 May
|
|
5
|
4
|
BatchScript: Example windows batch script for creating databases.
|
edit |
699 |
new
|
active
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
|
5
|
4
|
Data types and implicit conversions
|
edit |
682 |
new
|
active
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
|
5
|
1
|
sqlite_aggregate_context() valid in xFunc callback routine
|
edit |
666 |
code
|
active
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
anonymous
|
5
|
4
|
Error message indicates wrong error
|
edit |
662 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
drh
|
5
|
5
|
Stored Procedures?
|
edit |
660 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
compression/encoding feature?
|
edit |
656 |
code
|
active
|
2004 Mar
|
anonymous
|
Unknown
|
2004 May
|
|
5
|
5
|
The 'sum' and 'avg' functions don't work on Solaris (UNIX)
|
edit |
651 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
4
|
Update optimisation
|
edit |
645 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
OpenWatcom makefile
|
edit |
638 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
Lemon.c could not be compiled - source dated 27.02.2004
|
edit |
637 |
code
|
active
|
2004 Mar
|
anonymous
|
Parser
|
2004 Mar
|
|
5
|
4
|
union uses non-standard column names
|
edit |
590 |
new
|
active
|
2004 Jan
|
anonymous
|
Parser
|
2004 Jan
|
|
5
|
4
|
Treat ` like spaces outside of quoted strings.
|
edit |
588 |
new
|
active
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
5
|
4
|
Please provide support for NULLS LAST in ORDER BY clauses.
|
edit |
544 |
new
|
active
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
5
|
4
|
Feature Request: Indicate UNIQUE columns in table_info.
|
edit |
539 |
new
|
active
|
2003 Dec
|
anonymous
|
VDBE
|
2003 Dec
|
|
5
|
4
|
Addition of engine 'Suspension' interface
|
edit |
510 |
new
|
active
|
2003 Nov
|
anonymous
|
Unknown
|
2003 Nov
|
|
5
|
2
|
trigger: addition of create ability
|
edit |
486 |
new
|
active
|
2003 Oct
|
anonymous
|
VDBE
|
2003 Oct
|
|
5
|
4
|
index on expressions (general solution to case-insensitive problem)
|
edit |
485 |
new
|
active
|
2003 Oct
|
anonymous
|
BTree
|
2003 Oct
|
|
5
|
4
|
Comparing strings: user defined callback, strcoll?
|
edit |
472 |
new
|
active
|
2003 Oct
|
anonymous
|
VDBE
|
2003 Nov
|
|
5
|
5
|
[Patch] Using localtime instead UTC time to 'now'
|
edit |
450 |
new
|
active
|
2003 Sep
|
anonymous
|
Shell
|
2003 Sep
|
|
5
|
4
|
Make HTML Output XHTML compliant
|
edit |
442 |
new
|
active
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
5
|
2
|
[PATCH] sqlite: allow configure --enable-threadsafe
|
edit |
428 |
new
|
active
|
2003 Aug
|
anonymous
|
TclLib
|
2003 Aug
|
drh
|
5
|
5
|
missing prepare/fetch functions to be compatible with other DBs
|
edit |
425 |
new
|
active
|
2003 Aug
|
anonymous
|
VDBE
|
2003 Aug
|
|
5
|
3
|
Datetime enhancements: fractional seconds, addmonth
|
edit |
413 |
new
|
active
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
5
|
1
|
SQL_CALC_FOUND_ROWS & FOUND_ROWS() not supported
|
edit |
386 |
new
|
active
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
5
|
1
|
compile on WinCE ?
|
edit |
363 |
new
|
active
|
2003 Jun
|
anonymous
|
VDBE
|
2003 Jun
|
jadams
|
5
|
5
|
sqlite support domain as user defined type
|
edit |
356 |
new
|
active
|
2003 Jun
|
anonymous
|
VDBE
|
2003 Jun
|
|
5
|
2
|
Returns real error codes
|
edit |
338 |
new
|
active
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Nov
|
|
5
|
1
|
lowerFunc and upperFunc Fail on foreign characters
|
edit |
331 |
new
|
active
|
2003 May
|
anonymous
|
Unknown
|
2003 Jun
|
mike
|
5
|
5
|
Went to compile Win32 project and found a missing header reference
|
edit |
244 |
new
|
active
|
2003 Feb
|
anonymous
|
Unknown
|
2003 Feb
|
drh
|
5
|
4
|
Combining CREATE TABLE with its populating from some flat file
|
edit |
241 |
new
|
active
|
2003 Feb
|
anonymous
|
|
2005 Jun
|
anonymous
|
5
|
5
|
lack of alter table statement
|
edit |
235 |
new
|
active
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Nov
|
chw
|
5
|
1
|
Local language do not support!
|
edit |
229 |
new
|
active
|
2003 Jan
|
anonymous
|
Parser
|
2005 Sep
|
|
5
|
4
|
DECLARE ... CURSOR FOR ... would be really nice
|
edit |
219 |
new
|
active
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
5
|
5
|
MySQL style enums
|
edit |
186 |
new
|
active
|
2002 Nov
|
anonymous
|
Shell
|
2002 Nov
|
|
5
|
4
|
./configure --enable-threads-safe ?
|
edit |
184 |
new
|
active
|
2002 Oct
|
mike
|
|
2003 Jul
|
drh
|
5
|
3
|
auto update mechanism for CVS
|
edit |
175 |
new
|
active
|
2002 Oct
|
anonymous
|
Pager
|
2002 Oct
|
|
5
|
3
|
journal file should be kept open
|
edit |
169 |
new
|
active
|
2002 Oct
|
anonymous
|
Unknown
|
2004 Apr
|
anonymous
|
5
|
5
|
CE version
|
edit |
151 |
new
|
active
|
2002 Sep
|
anonymous
|
|
2007 Mar
|
|
5
|
5
|
Add 'configure' options for locating readline headers and library
|
edit |
68 |
new
|
active
|
2002 Jun
|
anonymous
|
|
2003 Jan
|
|
5
|
5
|
PRAGMA table_info(table-name) for queries
|
edit |
55 |
new
|
active
|
2002 Jun
|
anonymous
|
|
2007 Oct
|
drh
|
5
|
3
|
instead of triggers for inserts (updates) on regular tablesxx
|
edit |