| # |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
| 651 |
new
|
active
|
2004 Mar
|
anonymous
|
|
2009 Aug
|
|
5
|
4
|
Update optimization
|
| 4009 |
code
|
active
|
2009 Aug
|
anonymous
|
|
2009 Aug
|
|
2
|
1
|
group_concat too slow
|
| 3987 |
code
|
active
|
2009 Jul
|
anonymous
|
|
2009 Jul
|
|
4
|
3
|
limit + order by speed
|
| 3343 |
code
|
active
|
2008 Aug
|
rdc
|
|
2009 Jul
|
|
1
|
3
|
incorrect results for queries using alias names
|
| 2371 |
code
|
new
|
2007 May
|
anonymous
|
|
2009 Jul
|
|
2
|
2
|
sqlite3_errcode() and sqlite3_errmsg() return unexpected results
|
| 3857 |
code
|
active
|
2009 May
|
anonymous
|
|
2009 May
|
|
3
|
3
|
Lemon parser generator: No configurable location for lempar.c
|
| 3749 |
new
|
active
|
2009 Mar
|
anonymous
|
|
2009 Mar
|
|
5
|
4
|
Condition for indexes
|
| 3742 |
new
|
active
|
2009 Mar
|
aswift
|
|
2009 Mar
|
drh
|
3
|
4
|
Performance improvements for common ORDER BY clauses
|
| 3708 |
new
|
active
|
2009 Mar
|
anonymous
|
|
2009 Mar
|
|
3
|
4
|
UNION + ORDER BY
|
| 3128 |
code
|
active
|
2008 May
|
anonymous
|
|
2009 Mar
|
|
3
|
3
|
DISTINCT -> GROUP BY can lead to performance degradation
|
| 3666 |
code
|
active
|
2009 Feb
|
anonymous
|
|
2009 Feb
|
|
3
|
1
|
softHeapLimitEnforcer called too many times
|
| 3658 |
code
|
active
|
2009 Feb
|
anonymous
|
|
2009 Feb
|
|
1
|
2
|
Queries return inconsistent results
|
| 3650 |
doc
|
active
|
2009 Feb
|
anonymous
|
|
2009 Feb
|
|
4
|
3
|
documentation error in c3ref/changes.html
|
| 3600 |
code
|
active
|
2009 Jan
|
anonymous
|
|
2009 Jan
|
|
5
|
4
|
Unnecessary ephemeral table
|
| 3537 |
code
|
active
|
2008 Dec
|
anonymous
|
|
2008 Dec
|
|
5
|
4
|
sqlite3_bind_text + SQLITE_TRANSIENT + different encoding
|
| 3496 |
code
|
active
|
2008 Nov
|
anonymous
|
|
2008 Nov
|
|
4
|
4
|
FTS3: simple tokenizer ignores its first argument
|
| 3446 |
code
|
active
|
2008 Oct
|
anonymous
|
|
2008 Oct
|
|
2
|
3
|
select hex(randomblob(8)) as a, count(*) from Table where b = a;
|
| 3386 |
code
|
active
|
2008 Sep
|
anonymous
|
|
2008 Sep
|
|
4
|
4
|
insert default values does not work at the start of a trigger
|
| 3381 |
code
|
active
|
2008 Sep
|
anonymous
|
|
2008 Sep
|
|
2
|
1
|
SELECT DISTINCT returns incorrect results with alias in WHERE expr
|
| 3360 |
code
|
active
|
2008 Sep
|
anonymous
|
|
2008 Sep
|
|
4
|
4
|
undetected ambiguous column name
|
| 3330 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
3
|
4
|
faster large updates
|
| 3310 |
code
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
3
|
4
|
VFS xClose docs need update, code ignores returns mostly
|
| 3303 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
3
|
3
|
faster index creation for large tables
|
| 3285 |
new
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
drh
|
5
|
5
|
Add a module_list pragma to display all modules installed
|
| 3281 |
code
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
2
|
3
|
FTS3 and JOIN, cannot use MATCH operator
|
| 3282 |
doc
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
5
|
4
|
VFS xAccess says parameter is flags - should be flag (singular)
|
| 3274 |
code
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
|
1
|
1
|
"LIKE" does not work when searching for Arabic text
|
| 3266 |
doc
|
active
|
2008 Aug
|
anonymous
|
|
2008 Aug
|
shess
|
2
|
3
|
"TokenizeR" or "Tokenize"? Docs conflict code
|
| 1431 |
doc
|
active
|
2005 Sep
|
anonymous
|
|
2008 Jun
|
mihailim
|
1
|
1
|
Please can FAQ 7 reference http://www.sqlite.org/lockingv3.html
|
| 3115 |
code
|
active
|
2008 May
|
anonymous
|
|
2008 Jun
|
|
3
|
2
|
CREATE TABLE AS SELECT - file size
|
| 3140 |
new
|
active
|
2008 May
|
anonymous
|
|
2008 May
|
|
4
|
3
|
[PATCH] Make the default FTS3 tokenizer UTF8-aware
|
| 3117 |
code
|
active
|
2008 May
|
anonymous
|
|
2008 May
|
|
5
|
4
|
Lemon parser automaton listing improvement
|
| 3058 |
new
|
active
|
2008 Apr
|
anonymous
|
|
2008 Apr
|
|
3
|
5
|
optimizer chooses wrong indicies
|
| 3036 |
code
|
active
|
2008 Apr
|
anonymous
|
|
2008 Apr
|
|
4
|
4
|
ANALYZE considers all NULL values unique
|
| 2964 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Mar
|
drh
|
1
|
1
|
Access Violation from VACUUM with 3.5.6 on Corrupt Database
|
| 2413 |
code
|
active
|
2007 Jun
|
anonymous
|
|
2008 Feb
|
drh
|
1
|
1
|
1 bug and 2 suggestions in lemon
|
| 2917 |
code
|
active
|
2008 Feb
|
anonymous
|
|
2008 Feb
|
|
4
|
4
|
Tcl interface - busy callback confusion script/procedure
|
| 2853 |
new
|
active
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
2
|
3
|
optimizer fails to use an index on MAX subquery
|
| 2771 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
4
|
Lemon: Generated parser needs stdlib.h (not in default template)
|
| 2766 |
code
|
active
|
2007 Nov
|
drh
|
|
2007 Nov
|
|
1
|
1
|
TCL transaction started from within a query does not commit
|
| 2755 |
code
|
active
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
trace interfere with transaction Tcl interface
|
| 2729 |
doc
|
active
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Lemon: %fallback, %wildcard, and @X uncodumented
|
| 2664 |
code
|
active
|
2007 Sep
|
danielk1977
|
|
2007 Sep
|
|
1
|
1
|
attaching the same db twice in shared-cache mode fails
|
| 2652 |
code
|
active
|
2007 Sep
|
drh
|
|
2007 Sep
|
|
1
|
1
|
Aggregate function cannot be used from within a subquery
|
| 2558 |
code
|
active
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
2
|
3
|
Multiple JOIN USING() gives incorrect results
|
| 2547 |
code
|
active
|
2007 Aug
|
danielk1977
|
|
2007 Aug
|
|
5
|
3
|
Changing db encoding of an attached db can confuse shared cache mode.
|
| 2545 |
code
|
active
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
4
|
Group by returns table name with field name
|
| 2282 |
code
|
active
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
3
|
4
|
Update on view with no matching trigger does not raise error
|
| 2214 |
code
|
active
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
4
|
lemon generates bad error messages for %destructor
|
| 2128 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
3
|
virtual table code doesn't verify type of rowid (calling xUpdate)
|
| 2127 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
3
|
Virtual tables do not always free zErrmsg
|
| 2093 |
code
|
active
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
3
|
sqlite3_vtab_cursor doesn't have errMsg
|
| 2089 |
code
|
active
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
3
|
Decouple sqlite_int64 from other 64bit datatypes
|
| 1078 |
code
|
active
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
2
|
3
|
Lemon destructor bugs that don't affect sqlite
|
| 1063 |
code
|
active
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
1
|
3
|
Lemon bug: Strings in rule code should not be interpreted
|
| 1809 |
code
|
active
|
2006 May
|
anonymous
|
CodeGen
|
2009 Jan
|
|
1
|
3
|
Huge slowdown/increased memory use when using GROUP BY on big dataset
|
| 1493 |
code
|
active
|
2005 Oct
|
anonymous
|
Parser
|
2005 Oct
|
|
3
|
3
|
lemon: pathsearch uses wrong directory separator under Win32
|
| 1797 |
code
|
active
|
2006 May
|
anonymous
|
TclLib
|
2006 May
|
drh
|
1
|
1
|
COPY command doesn't work in tclsqlite 3.3.5
|
| 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
|
| 1111 |
code
|
active
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Jun
|
|
3
|
1
|
no such column error with a subselect as a table
|
| 1262 |
new
|
active
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
5-15% performance increase for slow joins
|
| 4010 |
code
|
active
|
2009 Aug
|
anonymous
|
back
|
2009 Aug
|
|
4
|
4
|
review design decision on JOURNAL_CHUNKSIZE in memjournal.c
|
| 3734 |
code
|
active
|
2009 Mar
|
danielk1977
|
back
|
2009 Mar
|
|
3
|
3
|
A read/write db connection may connect to a read-only shared cache.
|
| 3840 |
warn
|
active
|
2009 May
|
anonymous
|
build
|
2009 May
|
|
3
|
4
|
Missing header files in amalgamation
|
| 3659 |
build
|
active
|
2009 Feb
|
anonymous
|
build
|
2009 Feb
|
|
4
|
3
|
Building sqlite-tea: TEA version, install location, no tests
|
| 3670 |
new
|
active
|
2009 Feb
|
anonymous
|
cli
|
2009 Feb
|
|
5
|
3
|
Shell: The "backup_timeout" method for backup/restore operations
|
| 3678 |
new
|
active
|
2009 Feb
|
anonymous
|
front
|
2009 Mar
|
|
3
|
5
|
index not selected with re-ordered distinct columns
|
| 3647 |
new
|
active
|
2009 Feb
|
anonymous
|
front
|
2009 Feb
|
|
4
|
3
|
parsing natural join over more than 2 tables is too inefficient
|
| 3629 |
doc
|
active
|
2009 Feb
|
anonymous
|
front
|
2009 Feb
|
|
4
|
4
|
No error when selecting inappropriate columns when grouping.
|
| 4008 |
new
|
active
|
2009 Aug
|
anonymous
|
func
|
2009 Aug
|
|
1
|
1
|
2-digit year number in strftime() function by new 'y' switch
|
| 3998 |
new
|
active
|
2009 Jul
|
anonymous
|
func
|
2009 Aug
|
|
3
|
3
|
Optimization for UPDATE statement
|
| 3913 |
code
|
active
|
2009 Jun
|
anonymous
|
tcl
|
2009 Jun
|
|
4
|
4
|
Some variables in bubble-generator.tcl are being used before being set
|
| 3989 |
code
|
active
|
2009 Jul
|
anonymous
|
test
|
2009 Jul
|
|
4
|
4
|
lock3 has funky filepath causing problems on windows
|
| 3639 |
new
|
active
|
2009 Feb
|
anonymous
|
vfs
|
2009 Feb
|
|
3
|
1
|
Syntax error doesn't report a line number
|