# |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
|
2917 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Feb
|
|
4
|
4
|
Tcl interface - busy callback confusion script/procedure
|
edit |
2916 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Feb
|
|
1
|
1
|
sqlitedll-3_5_5.zip is older 3.5.4 binary
|
edit |
2228 |
new
|
active
|
2007 Feb
|
anonymous
|
|
2008 Feb
|
|
3
|
4
|
horizontal partitioning
|
edit |
2915 |
build
|
active
|
2008 Feb
|
pweilbacher
|
|
2008 Feb
|
|
4
|
3
|
fix Makefile for platforms that need .exe extension
|
edit |
2914 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
|
edit |
2905 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
pweilbacher
|
2
|
2
|
mutex_os2.c - incorrect mutex implementation
|
edit |
2902 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
drh
|
3
|
3
|
Add watch support to SQLite
|
edit |
2912 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
5
|
4
|
merge join
|
edit |
2903 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
tclinstaller.tcl fails on path and permissions issue
|
edit |
2911 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
Adding parentheses to a FROM clause
|
edit |
2909 |
build
|
active
|
2008 Jan
|
aswift
|
|
2008 Jan
|
aswift
|
4
|
4
|
Omit the _XOPEN_SOURCE 500 define on Mac OS-X (check for __APPLE__)
|
edit |
2613 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2008 Jan
|
drh
|
3
|
3
|
replace doesn't work with blobs containing \x0, otherwise it does
|
edit |
2907 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Issues of sqlite3 with Windows Mobile 5/6
|
edit |
2908 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
Add support to examine whether statements modify the database
|
edit |
2898 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Latest CVS for 3.5.4 fails to build test1.c
|
edit |
2901 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
ROLLBACK and COMMIT statements should not expire
|
edit |
2506 |
new
|
active
|
2007 Jul
|
anonymous
|
|
2008 Jan
|
|
3
|
2
|
New API to retrieve ROWID from SQLite3_stmt structire
|
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 |
2878 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Memory leaks with latest CVS [4693]
|
edit |
2897 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
String or BLOB exceed size limit
|
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 |
2893 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
incorrect integer range tests
|
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 |
2884 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
Way to find out limits
|
edit |
489 |
new
|
active
|
2003 Nov
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
DLL exports suggestion
|
edit |
2881 |
build
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Latest sqlite-3.5.4 build fail on latest Fedora 2.6.23.12-52.fc7
|
edit |
2847 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
5
|
4
|
Include major, minor, and patch version numbers in sqlite.h
|
edit |
2879 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
anonymous
|
4
|
3
|
VACUUM enters temporary sequence numbers in sqlite_sequence
|
edit |
2336 |
warn
|
active
|
2007 May
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
Compiler warnings on strcpy(), sprintf(), et al.
|
edit |
2875 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
2
|
LIKE does not work with lowercase swedish characters
|
edit |
2853 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
2
|
3
|
optimizer fails to use an index on MAX subquery
|
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 |
2872 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
4
|
4
|
Some table scan operations could use an index for better data density
|
edit |
2869 |
new
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
5
|
5
|
add "sqlite3_open16_v2" to the C API
|
edit |
2867 |
code
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
2
|
doesn't build on Cygwin - wrong sqlite3 exe suffix
|
edit |
2866 |
build
|
active
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
3
|
Problems building Windows native in cygwin/mingw environment
|
edit |
2864 |
doc
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
5
|
3
|
ext/fts3/README.txt
|
edit |
2865 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
2
|
FTS3 does not build with amalgamation in CVS
|
edit |
2863 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
3
|
test cast-3.14, cast-3.18 and cast-3.24 fail
|
edit |
2860 |
todo
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
1
|
Database file fragmentation
|
edit |
2859 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
drh
|
3
|
2
|
Inconsistent column names with DISTINCT
|
edit |
2761 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
CLI (shell.c) should be bundled with amalgamation
|
edit |
2857 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
2
|
GROUP BY cost estimate wrong with WHERE clause
|
edit |
2856 |
doc
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
anonymous
|
4
|
3
|
SQLite Documentation - Tcl API - Link broken
|
edit |
1648 |
new
|
active
|
2006 Jan
|
anonymous
|
Shell
|
2007 Dec
|
|
4
|
3
|
meaningful error message: constraint failed
|
edit |
2508 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
utf8ToUnicode() does not work on some WinCE devices
|
edit |
558 |
build
|
active
|
2004 Jan
|
anonymous
|
|
2007 Dec
|
|
4
|
4
|
Makefile.in should honor libdir and bindir
|
edit |
368 |
code
|
active
|
2003 Jun
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
UPDATE trigger doesn't fire on INSERT OR REPLACE
|
edit |
916 |
new
|
active
|
2004 Sep
|
anonymous
|
Unknown
|
2007 Dec
|
|
1
|
1
|
No delete notification for INSERT OR REPLACE
|
edit |
2844 |
build
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
4
|
1
|
lemon is being built without respecting LDFLAGS
|
edit |
2842 |
code
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
.import does not recongnise NULL values
|
edit |
2841 |
todo
|
active
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
The sqlite mailing list has become overrun by trolls
|
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 |
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 |
2813 |
build
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
compile error on Windows CE
|
edit |
2809 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
PRAGMA collation_list shows unregistered collations
|
edit |
2810 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Unregistered collation problems with simple subselects
|
edit |
2808 |
doc
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
2
|
Documentation GIF images take up too much space
|
edit |
2223 |
code
|
active
|
2007 Feb
|
scouten
|
|
2007 Nov
|
|
3
|
3
|
pragma auto_vacuum doesn't survive .dump & reconstitute
|
edit |
2793 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
fts3 lacks scoping
|
edit |
285 |
build
|
active
|
2003 Apr
|
anonymous
|
Unknown
|
2007 Nov
|
|
2
|
2
|
Configure doesn't honour LDFLAGS during build
|
edit |
2791 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Allow building FTS[123] as part of sqlite library with configure
|
edit |
2787 |
build
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
5
|
sqlite3.pc is not remade
|
edit |
2770 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Problem with BLOB in 3.5.x ?
|
edit |
2776 |
warn
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
1
|
mailing list
|
edit |
2771 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
4
|
Lemon: Generated parser needs stdlib.h (not in default template)
|
edit |
2766 |
code
|
active
|
2007 Nov
|
drh
|
|
2007 Nov
|
|
1
|
1
|
TCL transaction started from within a query does not commit
|
edit |
2417 |
new
|
active
|
2007 Jun
|
anonymous
|
|
2007 Nov
|
drh
|
3
|
3
|
Idea for read write concurrency.
|
edit |
2763 |
build
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
4
|
AIX build failure due to explicit _XOPEN_SOURCE definition
|
edit |
2760 |
new
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
request: sqlite3_unlink() to delete db files.
|
edit |
2756 |
new
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
allow vacuum to change pragma setting instead of using existing ones
|
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 |
2716 |
new
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
5
|
1
|
Create Clear Command
|
edit |
2749 |
warn
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
SQLITE_OMIT_FLOATING_POINT, int constants too large
|
edit |
2748 |
warn
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
amalgamation: SQLITE_OMIT_ALTERTABLE warnings
|
edit |
2392 |
code
|
active
|
2007 May
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
Reduce MemPage and PgHdr struct sizes. Better page memory utilization.
|
edit |
2728 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
Some indexes could contain pointers not the data
|
edit |
2736 |
build
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
2
|
build problems on freebsd
|
edit |
2715 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
no authorization needed to remove authorizer
|
edit |
2714 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
drh
|
3
|
4
|
Shell cannot import large files greater than 2 GB [patch]
|
edit |
2729 |
doc
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Lemon: %fallback, %wildcard, and @X uncodumented
|
edit |
2725 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
memory leak in sqlite3_open_v2() when it fails
|
edit |
2701 |
new
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
5
|
5
|
Make INSERT-ing multiple rows MySQL-compatible
|
edit |
2727 |
build
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
building with -malign-double causes strange behavior
|
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 |
2703 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
make test does not work with SQLITE_OMIT_FLOATING_POINT
|
edit |
2684 |
code
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Accessing sqlite from an NT service will lock the complete databse.
|
edit |
55 |
new
|
active
|
2002 Jun
|
anonymous
|
|
2007 Oct
|
drh
|
5
|
3
|
instead of triggers for inserts (updates) on regular tablesxx
|
edit |
2674 |
code
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
4
|
NFS fails without lock manager
|
edit |
2677 |
new
|
active
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
danielk1977
|
5
|
3
|
CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events
|
edit |
2671 |
code
|
active
|
2007 Sep
|
shess
|
|
2007 Sep
|
shess
|
2
|
4
|
Fts field-based queries are not correctly case-insensitive.
|
edit |