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