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