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