bgcolor # Type Status Created By Subsys Changed Assigned Svr Pri Title #cfe8bd 55 new active 2002 Jun anonymous 2007 Oct drh 5 3 instead of triggers for inserts (updates) on regular tablesxx #c8c8c8 68 new active 2002 Jun anonymous 2003 Jan 5 5 PRAGMA table_info(table-name) for queries #cacae5 82 new active 2002 Jun anonymous 2002 Jun 1 4 Add IsCacheable, IsNullable to sqlite_create_function #cfe8bd 93 new active 2002 Jul anonymous 2004 Jan 3 3 Can't open database when TEMP environment variable is not defined well #cfe8bd 139 new active 2002 Aug anonymous Pager 2002 Aug 3 3 Named transactions are misleading as documented #c8c8c8 151 new active 2002 Sep anonymous 2007 Mar 5 5 Add 'configure' options for locating readline headers and library #c8c8c8 169 new active 2002 Oct anonymous Unknown 2004 Apr anonymous 5 5 CE version #cfe8bd 175 new active 2002 Oct anonymous Pager 2002 Oct 5 3 journal file should be kept open #cfe8bd 184 new active 2002 Oct mike 2003 Jul drh 5 3 auto update mechanism for CVS #cacae5 186 new active 2002 Nov anonymous Shell 2002 Nov 5 4 ./configure --enable-threads-safe ? #f2dcdc 203 new active 2002 Dec anonymous Unknown 2002 Dec anonymous 2 1 Missing Win32 open flag if shared database #f2dcdc 209 new active 2002 Dec anonymous BTree 2003 Nov 1 1 update libtool #f2dcdc 216 new active 2003 Jan anonymous 2003 Jan 1 1 Add "DISTINCT ON()" clause to specify the fields to apply the unicity #c8c8c8 219 new active 2003 Jan anonymous 2003 Jan 5 5 MySQL style enums #cacae5 229 new active 2003 Jan anonymous Parser 2005 Sep 5 4 DECLARE ... CURSOR FOR ... would be really nice #f2dcdc 235 new active 2003 Jan anonymous Unknown 2003 Nov chw 5 1 Local language do not support! #cfe8bd 236 new active 2003 Jan anonymous 2003 Feb 3 3 Add RENAME TABLE - will be easier to work around missing ALTER TABLE #e8e8bd 239 new active 2003 Feb anonymous Unknown 2004 Jul 4 2 ANSI/Unicode(Wide) version file-handling functions for Win32 #c8c8c8 241 new active 2003 Feb anonymous 2005 Jun anonymous 5 5 lack of alter table statement #cacae5 243 new active 2003 Feb anonymous Unknown 2003 Oct anonymous 3 4 Performance problem with MSVC precompiled DLL #cacae5 244 new active 2003 Feb anonymous Unknown 2003 Feb drh 5 4 Combining CREATE TABLE with its populating from some flat file #f2dcdc 252 new active 2003 Feb anonymous 2003 Feb 4 1 Add optional regex matching similar to what Postgres & Oracle have #e8e8bd 259 new active 2003 Mar anonymous CodeGen 2003 Nov 1 2 ORDER BY queries including an integer primary key don't use index #cacae5 263 new active 2003 Mar anonymous CodeGen 2003 Mar 1 4 sqlite locking strategy can lead to deadlock #cfe8bd 268 new active 2003 Mar anonymous Parser 2003 Nov 1 3 columns of subselects containing joins are not recognized #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 279 new active 2003 Apr anonymous 2003 May 3 3 WinCE port of CVS version as of 02 Apr 2003 #cacae5 294 new active 2003 Apr anonymous Shell 2003 Apr a.rottmann 1 4 Diff for OpenBSD #cfe8bd 321 new active 2003 May anonymous 2003 May 4 3 Make SQLITE_ISO8859 and SQLITE_UTF8 overridable by compiler define #cacae5 326 new active 2003 May anonymous 2003 May 4 4 Request for additional callback for various functions #c8c8c8 331 new active 2003 May anonymous Unknown 2003 Jun mike 5 5 Went to compile Win32 project and found a missing header reference #f2dcdc 338 new active 2003 Jun anonymous Unknown 2003 Nov 5 1 lowerFunc and upperFunc Fail on foreign characters #e8e8bd 356 new active 2003 Jun anonymous VDBE 2003 Jun 5 2 Returns real error codes #c8c8c8 363 new active 2003 Jun anonymous VDBE 2003 Jun jadams 5 5 sqlite support domain as user defined type #cfe8bd 366 new active 2003 Jun anonymous Unknown 2003 Jun drh 4 3 Functions sqlite_(en/de)code_binary() not in sqlite.h #cfe8bd 381 new active 2003 Jul anonymous 2003 Jul 1 3 Support for DJGPP and DOS #f2dcdc 386 new active 2003 Jul anonymous 2003 Jul 5 1 compile on WinCE ? #cfe8bd 404 new active 2003 Jul anonymous 2003 Dec 3 3 new C API: sqlite_get_table_with_types with type information #cacae5 407 new active 2003 Jul anonymous 2003 Jul 4 4 sqlite_compile etc. and pragma empty_result_callbacks. #f2dcdc 412 new active 2003 Jul anonymous Unknown 2003 Jul drh 1 1 sign function: quick hack for func.c (hope this helps) #f2dcdc 413 new active 2003 Jul anonymous 2003 Jul 5 1 SQL_CALC_FOUND_ROWS & FOUND_ROWS() not supported #cfe8bd 420 new active 2003 Jul anonymous VDBE 2003 Jul 3 3 Not abort transaction when callback is cancelled #cfe8bd 424 new active 2003 Aug anonymous Shell 2003 Aug 4 3 Provide access to internal function _all_whitespace() #cfe8bd 425 new active 2003 Aug anonymous VDBE 2003 Aug 5 3 Datetime enhancements: fractional seconds, addmonth #c8c8c8 428 new active 2003 Aug anonymous TclLib 2003 Aug drh 5 5 missing prepare/fetch functions to be compatible with other DBs #e8e8bd 442 new active 2003 Sep anonymous 2003 Sep 5 2 [PATCH] sqlite: allow configure --enable-threadsafe #cfe8bd 448 new active 2003 Sep anonymous 2003 Sep drh 3 3 a general bug-fix and dos support without lfn #cacae5 450 new active 2003 Sep anonymous Shell 2003 Sep 5 4 Make HTML Output XHTML compliant #cacae5 454 new active 2003 Sep anonymous 2003 Sep 4 4 schema column types with parenthesis to automatically invoke functions #f2dcdc 457 new active 2003 Sep anonymous 2003 Sep 1 1 Ported to NetWare #cfe8bd 465 new active 2003 Sep anonymous 2003 Sep 4 3 data types should be implemented as formated strings #c8c8c8 472 new active 2003 Oct anonymous VDBE 2003 Nov 5 5 [Patch] Using localtime instead UTC time to 'now' #cacae5 477 new active 2003 Oct anonymous 2003 Dec anonymous 4 4 Are there any plans to enchance SQLite to support Unicode #cfe8bd 478 new active 2003 Oct anonymous Parser 2003 Nov drh 1 3 select into is lacking #cfe8bd 479 new active 2003 Oct anonymous Parser 2003 Oct drh 4 3 Sequences #cacae5 485 new active 2003 Oct anonymous BTree 2003 Oct 5 4 Comparing strings: user defined callback, strcoll? #cacae5 486 new active 2003 Oct anonymous VDBE 2003 Oct 5 4 index on expressions (general solution to case-insensitive problem) #cacae5 489 new active 2003 Nov anonymous 2008 Jan 4 4 DLL exports suggestion #cfe8bd 490 new active 2003 Nov anonymous VDBE 2003 Nov xdong 4 3 a few api improvements for recordset operations #cacae5 491 new active 2003 Nov anonymous 2003 Nov 4 4 Want to use SET col = 'val' with INSERT statement #cacae5 498 new active 2003 Nov anonymous Unknown 2003 Nov 4 4 Suggestion: Allow named parameters. #e8e8bd 510 new active 2003 Nov anonymous Unknown 2003 Nov 5 2 trigger: addition of create ability #f2dcdc 517 new active 2003 Dec anonymous Parser 2003 Dec drh 1 1 \' sequence unrecognized token error enhancement request #f2dcdc 524 new active 2003 Dec anonymous Unknown 2003 Dec 2 1 port of sqlite to dos with short file names #cacae5 525 new active 2003 Dec anonymous 2003 Dec 4 4 DB testing #cfe8bd 538 new active 2003 Dec anonymous 2003 Dec 4 3 Different warnings in windows #cacae5 539 new active 2003 Dec anonymous VDBE 2003 Dec 5 4 Addition of engine 'Suspension' interface #cacae5 544 new active 2004 Jan anonymous 2004 Jan 5 4 Feature Request: Indicate UNIQUE columns in table_info. #f2dcdc 550 new active 2004 Jan anonymous Unknown 2004 Jan anonymous 1 1 change of MASTER_NAME and TEMP_MASTER_NAME definition error #cfe8bd 563 new active 2004 Jan anonymous Parser 2004 Jan 4 3 Support for autoincrement type "SERIAL" (from PostgreSQL) #cacae5 566 new active 2004 Jan anonymous Unknown 2004 Jan 4 4 [PATCH] Port of sqlite and lemon to an EBCDIC mainframe #cfe8bd 572 new active 2004 Jan anonymous Unknown 2004 Jan drh 3 3 sqlite 2.8.11 port to djgpp #cacae5 588 new active 2004 Jan anonymous 2004 Jan 5 4 Please provide support for NULLS LAST in ORDER BY clauses. #cacae5 590 new active 2004 Jan anonymous Parser 2004 Jan 5 4 Treat ` like spaces outside of quoted strings. #cfe8bd 611 new active 2004 Feb anonymous VDBE 2004 Feb 1 3 Remove giant SWITCH statement in VM for better portability #c8c8c8 638 new active 2004 Mar anonymous 2004 Mar 5 5 Lemon.c could not be compiled - source dated 27.02.2004 #c8c8c8 645 new active 2004 Mar anonymous 2004 Mar 5 5 OpenWatcom makefile #cacae5 651 new active 2004 Mar anonymous 2004 Mar 5 4 Update optimisation #c8c8c8 660 new active 2004 Mar anonymous 2004 Mar 5 5 compression/encoding feature? #c8c8c8 662 new active 2004 Mar anonymous 2004 Mar drh 5 5 Stored Procedures? #cfe8bd 673 new active 2004 Mar anonymous Shell 2004 Apr 4 3 Format .dump nicer (patch) #f2dcdc 682 new active 2004 Apr anonymous 2004 Apr 5 1 sqlite_aggregate_context() valid in xFunc callback routine #cacae5 699 new active 2004 Apr anonymous 2004 Apr 5 4 Data types and implicit conversions #cfe8bd 707 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 how to use internal functions? #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 711 new active 2004 Apr anonymous 2004 Apr drh 3 3 Provide a callback function to verify values before insert or update #cfe8bd 712 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 Allow temporary databases to be created in specified folder #cfe8bd 714 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 Change sqlite_decode_binary to return buffer size #e8e8bd 717 new active 2004 May anonymous Unknown 2004 May drh 2 2 minor fixes and port to dos #e8e8bd 718 new active 2004 May anonymous 2004 May anonymous 2 2 Case insensitive index ? #cacae5 723 new active 2004 May anonymous Unknown 2004 May 5 4 BatchScript: Example windows batch script for creating databases. #c8c8c8 724 new active 2004 May anonymous 2004 May 4 5 VACUUM resets settings for the current session #c8c8c8 725 new active 2004 May anonymous 2006 Aug anonymous 5 5 Implement ATTACH LIB comand #c8c8c8 726 new active 2004 May anonymous Parser 2004 May anonymous 5 5 As to single quote #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 737 new active 2004 May anonymous Shell 2004 May anonymous 3 3 xml export #f2dcdc 738 new active 2004 May anonymous 2004 May danielk1977 4 1 Sort order array in memory #f2dcdc 739 new active 2004 May anonymous Unknown 2004 May danielk1977 3 1 Suggestion speed query #c8c8c8 741 new active 2004 May anonymous CodeGen 2004 May anonymous 5 5 command tool does not support history #c8c8c8 742 new active 2004 May anonymous VDBE 2004 May anonymous 5 5 database is locked #cfe8bd 748 new active 2004 May anonymous 2004 May 3 3 option to allow ignoring trailing whitespace in selects #e8e8bd 755 new active 2004 Jun anonymous TclLib 2004 Jun drh 5 2 Adding aggregate function to the tcl binding #cfe8bd 797 new active 2004 Jul anonymous Parser 2004 Jul 4 3 require basic named subquery / WITH sql support #cacae5 823 new active 2004 Jul anonymous Unknown 2004 Jul 5 4 absent VERSIONINFO into any Win32 DLL #cacae5 824 new active 2004 Jul anonymous Unknown 2004 Jul 5 4 StrSum - new build-in aggreate function suggestion #cfe8bd 843 new active 2004 Aug anonymous Unknown 2004 Aug 3 3 Introducing I64 printf size prefix #cacae5 845 new active 2004 Aug anonymous 2004 Aug 5 4 Support shared-memory databases #e8e8bd 867 new active 2004 Aug anonymous Parser 2006 Jan 3 2 update on multiple tables #cacae5 883 new active 2004 Sep anonymous Shell 2004 Sep 1 4 Choose appropriate column widths for column output #f2dcdc 916 new active 2004 Sep anonymous Unknown 2007 Dec 1 1 No delete notification for INSERT OR REPLACE #e8e8bd 930 new active 2004 Sep anonymous Unknown 2007 Mar drh 2 2 djgpp port for sqlite3 #cacae5 931 new active 2004 Sep anonymous 2006 Dec 5 4 Makefile for mingw on Win32, makes DLL, EXE and docs #cfe8bd 944 new active 2004 Oct anonymous Shell 2004 Oct 4 3 Command to abort current expression. #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 #cacae5 974 new active 2004 Oct anonymous 2005 Dec 5 4 Version-Resource in pre-compiled windows dll #cacae5 1011 new active 2004 Nov anonymous 2004 Nov 5 4 No .lib file for in windows precompiled binaries #cacae5 1031 new active 2004 Dec anonymous 2005 Jan 3 4 sqlite command line does not allow intermixing of dot commands and sql #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) #cacae5 1061 new active 2005 Jan anonymous Shell 2005 Jan 4 4 shell.c .import from stdin #cfe8bd 1126 new active 2005 Feb anonymous Unknown 2007 Jan drh 2 3 sqlite 2.8.16 port to djgpp #e8e8bd 1162 new active 2005 Mar anonymous 2005 Mar drh 1 2 Column names in sqlite views differ from oracle/informix column names #cfe8bd 1176 new active 2005 Mar anonymous Unknown 2005 Mar 4 3 Blocking Writes #cacae5 1186 new active 2005 Mar anonymous Shell 2005 Mar 4 4 Pragma page_size doesn't set the pagesize immediately #f2dcdc 1189 new active 2005 Mar anonymous Parser 2005 Mar 1 1 Make where-clause item count limit dynamic #cacae5 1190 new active 2005 Mar anonymous Unknown 2005 Mar drh 4 4 strftime() does not Support Years with 3 or 5 digits #e8e8bd 1204 new active 2005 Apr anonymous TclLib 2005 Apr drh 4 2 (visible) version provided by tclsqlite package #cacae5 1208 new active 2005 Apr anonymous Unknown 2005 Apr 4 4 no version info provided in precompiled sqlite3.dll #cfe8bd 1220 new active 2005 Apr anonymous 2005 Apr 4 3 Selectable calling convention #cacae5 1221 new active 2005 Apr anonymous 2005 Apr 5 4 Implementation of PRAGMA trigger_info(table) #e8e8bd 1227 new active 2005 Apr anonymous Shell 2005 Apr 5 2 Small patch for timing commands in shell.c #cfe8bd 1240 new active 2005 May anonymous Pager 2005 May drh 1 3 Need integration of Apple's file locking callbacks improvement #cacae5 1249 new active 2005 May anonymous Unknown 2005 May 5 4 transaction #cfe8bd 1250 new active 2005 May anonymous Pager 2005 May 1 3 FlushFileBuffers makes Windows sqlite dead slow compared to Linux #cfe8bd 1254 new active 2005 May anonymous Pager 2005 May 3 3 better pager_cksum #cfe8bd 1262 new active 2005 May anonymous VDBE 2005 May 5 3 5-15% performance increase for slow joins #cfe8bd 1294 new active 2005 Jun anonymous 2005 Jun 3 3 API to get ordinal table name #cacae5 1313 new active 2005 Jun anonymous 2005 Jun 4 4 Allow headers in imported text files #cacae5 1319 new active 2005 Jul anonymous 2005 Jul 5 4 Extend sqlite3_expired to detect schema changes #c8c8c8 1332 new active 2005 Jul anonymous Unknown 2005 Jul 5 5 update 20x slower when using a temp table #cacae5 1381 new active 2005 Aug anonymous Parser 2005 Aug 5 4 missing important builtin function stdev #c8c8c8 1400 new active 2005 Aug anonymous 2005 Sep 5 5 Use of indexes in queries to VIEWS built from UNION SELECTS #cfe8bd 1417 new active 2005 Sep anonymous 2005 Sep drh 3 3 Fix successive access to a DB handler (unix broken thread file lock) #cacae5 1423 new active 2005 Sep anonymous 2005 Sep drh 3 4 Binding NULL does not work as expected #cfe8bd 1424 new active 2005 Sep anonymous Unknown 2005 Sep drh 5 3 Pivot table creation #cfe8bd 1464 new active 2005 Oct anonymous 2005 Oct 4 3 Improving PRAGMA table_info() #c8c8c8 1468 new active 2005 Oct anonymous Parser 2005 Oct 5 5 Added Mysql function CONCAT #c8c8c8 1475 new active 2005 Oct anonymous Parser 2005 Oct anonymous 5 5 sytax error near autoincrement #cacae5 1476 new active 2005 Oct anonymous 2005 Oct 5 4 Patch for SQLite sequence manipulation functions #cacae5 1491 new active 2005 Oct anonymous Shell 2005 Oct 4 4 syntax error with " .mode column: #cacae5 1506 new active 2005 Nov anonymous Shell 2005 Nov 1 4 Add some flags to .import command #cacae5 1528 new active 2005 Nov anonymous Unknown 2005 Nov 5 4 Add Build Date To Command Line Greeting #cacae5 1532 new active 2005 Nov anonymous TclLib 2005 Nov 4 4 Variables don't get replaced in ATTACH statements. #cfe8bd 1550 new active 2005 Dec anonymous Unknown 2005 Dec 3 3 Triggers across attached databases #cacae5 1552 new active 2005 Dec anonymous Unknown 2005 Dec 5 4 Adding .read FILE support to the C API #cacae5 1558 new active 2005 Dec anonymous VDBE 2005 Dec 3 4 Request more debugging info when SQL statements in progress #cacae5 1566 new active 2005 Dec ghaering VDBE 2005 Dec 5 4 Implement sqlite3_clone() #cacae5 1588 new active 2006 Jan anonymous 2006 Jan 4 4 common subexpression elimination not performed in SELECT #cfe8bd 1597 new active 2006 Jan anonymous Unknown 2007 May 1 3 wish: support DROP COLUMN #cacae5 1626 new active 2006 Jan anonymous Unknown 2006 Jan 4 4 ALTER TABLE BUG/MISHEAVIOR #cfe8bd 1648 new active 2006 Jan anonymous Shell 2007 Dec 4 3 meaningful error message: constraint failed #c8c8c8 1653 new active 2006 Feb anonymous CodeGen 2006 Feb 4 5 SQLITE_OMIT_COST_REORDERING ? #cacae5 1655 new active 2006 Feb anonymous VDBE 2006 Mar 4 4 Every function can have their private data like agreagates #cacae5 1663 new active 2006 Feb anonymous Unknown 2006 Feb 4 4 Suggestion: DATETYPE field type using David Tribble's work? #cacae5 1675 new active 2006 Feb anonymous 2006 Feb 5 4 sqlite3_db_dup() ? #cacae5 1679 new active 2006 Feb anonymous 2006 Feb 4 4 SQLite requires code modification to replace memory allocation funcs #cfe8bd 1683 new active 2006 Feb anonymous Unknown 2006 Feb anonymous 4 3 .mode html produces uppercase tags #cacae5 1689 new active 2006 Feb anonymous 2006 Mar 2 4 triggers and temporary tables #cacae5 1693 new active 2006 Feb anonymous Parser 2006 Mar 4 4 Parser sensitive to position of word AUTOINCREMENT #cacae5 1702 new active 2006 Mar anonymous 2006 Mar 5 4 feature request: API to write in-memory DB to file. #cfe8bd 1703 new active 2006 Mar anonymous Pager 2006 Mar 2 3 Second parameter to gettimeofday() in os_unix.c should be NULL #cfe8bd 1704 new active 2006 Mar anonymous 2006 Mar 4 3 extern "C" block in sqliteInt.h #f2dcdc 1718 new active 2006 Mar anonymous 2006 Mar 1 1 allow *.sqlite as parameter to sqlite3_analyzer #cacae5 1720 new active 2006 Mar anonymous 2006 Mar 3 4 Actions made by a trigger are not triggered #e8e8bd 1722 new active 2006 Mar anonymous Unknown 2007 Jan 4 2 agregate sum() of strings #cacae5 1747 new active 2006 Apr anonymous Unknown 2006 Apr 4 4 Non descriptive error message #c8c8c8 1769 new active 2006 Apr anonymous Unknown 2006 Apr drh 5 5 Is there any djgpp port for 3-3-5 #cacae5 1770 new active 2006 Apr anonymous 2006 Apr 5 4 Request for expanded DELETE USING keyword like PostgreSQL #c8c8c8 1772 new active 2006 Apr anonymous TclLib 2006 Apr 5 5 db eval {QUERY} { do something } ELSE { there was no match } #cfe8bd 1778 new active 2006 Apr anonymous Parser 2007 Mar 1 3 stdev does not work, workaround not possible due to missing sqrt #c8c8c8 1781 new active 2006 Apr anonymous 2006 Apr 3 5 Interleaved sqlite_step behaves inconsistently #cfe8bd 1785 new active 2006 Apr anonymous Shell 2006 Apr 4 3 rl_readline_name not set #c8c8c8 1788 new active 2006 Apr anonymous 2006 Apr 5 5 memory allocator able to return with several allocated bloks at once #cacae5 1801 new active 2006 May anonymous Pager 2006 May owensmk 5 4 Include Support for User-defined Lock Synchronization #cfe8bd 1810 new active 2006 May anonymous 2006 May 3 3 localtime() not threadsafe on UNIX #f2dcdc 1812 new active 2006 May anonymous 2006 May 4 1 alter table add column default current_timestamp #cacae5 1814 new active 2006 May anonymous 2006 May 3 4 Autoconf support for MacOSX univeral binaries #e8e8bd 1817 new active 2006 May anonymous 2006 Jun 1 2 Patch to enable SQLite again on OS/2 #cacae5 1837 new active 2006 Jun anonymous Pager 2006 Jun 4 4 Deadlock detection would be best reported using explicit error code. #cfe8bd 1864 new active 2006 Jun anonymous 2006 Jun drh 3 3 List availabe SQL functions #cfe8bd 1874 new active 2006 Jun anonymous CodeGen 2006 Jun 2 3 IN is much slower than making separate queries #f2dcdc 1896 new active 2006 Jul drh 2006 Jul 1 1 All extensions to be statically linked #cfe8bd 1902 new active 2006 Jul anonymous Parser 2006 Jul 5 3 allow alternate INSERT syntax using SET foo=bar #cacae5 1905 new active 2006 Aug anonymous VDBE 2006 Aug 5 4 Get bound param as sqlite3_value? #e8e8bd 1906 new active 2006 Aug anonymous Unknown 2006 Aug 1 2 date.c line 417 uses non-thread safe localtime() call #cacae5 1907 new active 2006 Aug anonymous 2006 Aug 4 4 date and time types #cfe8bd 1924 new active 2006 Aug anonymous Parser 2007 May 2 3 optimize queries on unions, constant folding #e8e8bd 1928 new active 2006 Aug anonymous Parser 2006 Aug 2 2 NULL rowid in views and subqueries #cacae5 1933 new active 2006 Aug anonymous 2006 Aug 5 4 Add different date's separators #cacae5 1942 new active 2006 Aug anonymous 2006 Aug 4 4 select without left join with the *= operator #cfe8bd 1959 new active 2006 Sep anonymous 2006 Sep 4 3 Unblockable TEMP TABLES #cacae5 1975 new active 2006 Sep anonymous 2006 Sep 5 4 Request for sqlite3_table_column_metadata16 #cfe8bd 1996 new active 2006 Sep anonymous Unknown 2006 Sep drh 2 3 Data type CHAR #cfe8bd 2087 new active 2006 Nov anonymous 2006 Nov 3 3 Ability to add a check constraint via the alter table command #c8c8c8 2105 new active 2006 Dec anonymous 2006 Dec 5 5 sqlite3_exec does not return modified rows #cacae5 2120 new active 2006 Dec anonymous 2006 Dec 5 4 Date Column support #cfe8bd 2136 new active 2007 Jan anonymous 2007 Mar 1 3 sqlite locking does not handle afs; patch included #cfe8bd 2167 new active 2007 Jan anonymous 2007 Jan 1 3 add sqlite3_copy_bindings (parallel to sqlite3_transfer_bindings) #cacae5 2180 new active 2007 Jan anonymous 2007 Jan 5 4 feature request: DROP TABLE IF [EXISTS AND] EMPTY #cacae5 2181 new active 2007 Jan anonymous 2007 Jan 5 4 Generalize ON CONFLICT to failure trapping for all SQL statements #cfe8bd 2185 new active 2007 Jan anonymous 2007 Jan 5 3 API access to opened database pathname - helpful for virtual tables #cacae5 2198 new active 2007 Jan anonymous 2007 Jan 5 4 API: opening only existing databases #cacae5 2200 new active 2007 Jan anonymous 2007 Jan 5 4 threadsafe status not reported in .pc file #cacae5 2202 new active 2007 Jan anonymous 2007 Jan 5 4 function request: sqlite3_attach() #cfe8bd 2204 new active 2007 Jan anonymous 2007 Feb 5 3 Stable, documented metadata interface #cacae5 2206 new active 2007 Jan anonymous 2007 Jan 5 4 Support for foreign key constraints in virtual tables #cacae5 2207 new active 2007 Jan anonymous 2007 May 3 4 "CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints #cacae5 2220 new active 2007 Feb anonymous 2007 Feb drh 2 4 fsck for database files #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 2224 new active 2007 Feb scouten 2007 Feb 4 4 Option to have one-bit "journal should exist" flag #cacae5 2228 new active 2007 Feb anonymous 2008 Feb 3 4 horizontal partitioning #cacae5 2231 new active 2007 Feb anonymous 2007 Mar 4 4 shell should ignore leading whitespace for meta commands #cfe8bd 2233 new active 2007 Feb anonymous 2007 Mar 4 3 extend xBestIndex in vtables to carry the values for each contraint #cfe8bd 2235 new active 2007 Feb anonymous 2007 Feb 4 3 Missing xml support in FTS2 for the snippet function #cfe8bd 2238 new active 2007 Feb anonymous 2007 Feb 2 3 Streams as datbase #cacae5 2254 new active 2007 Feb anonymous 2007 Feb 5 4 ATTACH support IF NOT ATTACHED statement #f2dcdc 2256 new active 2007 Feb anonymous 2007 Apr drh 5 1 Add POSITION() function (SQL-92 standard) #cfe8bd 2258 new active 2007 Feb anonymous 2007 Mar 4 3 Include field name in check constraint failure message #cfe8bd 2266 new active 2007 Mar anonymous 2007 Mar anonymous 3 3 Add support for Row_Number() Over #cfe8bd 2280 new active 2007 Mar anonymous 2007 Mar 4 3 Check constraint failure message should include field name #f2dcdc 2304 new active 2007 Apr anonymous 2007 Apr 1 1 resolve "databas is locked" problem under DEFERRED transaction #f2dcdc 2327 new active 2007 Apr anonymous 2007 Apr anonymous 2 1 "DELETE" operation makes memory rise #cacae5 2329 new active 2007 Apr anonymous 2007 Apr 5 4 add a feature to .dump : partial dumps #cacae5 2333 new active 2007 May anonymous 2007 May 5 4 support memory mapped files #cacae5 2373 new active 2007 May anonymous 2007 May 4 4 "create table as explain " doesn't work #cfe8bd 2411 new active 2007 Jun anonymous 2007 Jun 5 3 fts2 RFE - Separate index and storage #cfe8bd 2417 new active 2007 Jun anonymous 2007 Nov drh 3 3 Idea for read write concurrency. #cfe8bd 2438 new active 2007 Jun rse 2007 Jun 3 3 More easily allow the building of SQLite with FTS1 and FTS2 #cfe8bd 2443 new active 2007 Jun anonymous 2007 Jun 3 3 sqlite should return different exit codes for different errors #cfe8bd 2448 new active 2007 Jun anonymous 2007 Jun 4 3 SQLITE needs to identify public exported symbols #c8c8c8 2456 new active 2007 Jun anonymous 2007 Jun 5 5 REQ: use index where applicable instead of full table scan #cacae5 2474 new active 2007 Jun anonymous 2007 Jun 5 4 Multiple-record comma-delineated INSERT command #cacae5 2484 new active 2007 Jul anonymous 2007 Jul 5 4 Support for RETURNING #cacae5 2488 new active 2007 Jul anonymous 2007 Jul 5 4 autosize on column output mode in sqlite3 program #e8e8bd 2506 new active 2007 Jul anonymous 2008 Jan 3 2 New API to retrieve ROWID from SQLite3_stmt structire #f2dcdc 2520 new active 2007 Jul anonymous 2007 Jul 4 1 User defined aggregate functions are not reentrant #f2dcdc 2555 new active 2007 Aug anonymous 2007 Aug 1 1 FTS index without original text #cfe8bd 2568 new active 2007 Aug anonymous 2007 Aug 3 3 TEMP_STORE is ignored in some cases #cacae5 2604 new active 2007 Aug anonymous 2007 Aug 4 4 CREATE VIRTUAL TABLE does not allow IF NOT EXISTS #cacae5 2649 new active 2007 Sep anonymous 2007 Sep 4 4 Add an "--enable-extensions" (default=no) to the configure script #cacae5 2651 new active 2007 Sep anonymous 2007 Sep 5 4 Add support for overriding home directory location #cfe8bd 2677 new active 2007 Sep anonymous 2007 Sep danielk1977 5 3 CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events #c8c8c8 2701 new active 2007 Oct anonymous 2007 Oct 5 5 Make INSERT-ing multiple rows MySQL-compatible #f2dcdc 2716 new active 2007 Oct anonymous 2007 Oct 5 1 Create Clear Command #f2dcdc 2756 new active 2007 Nov anonymous 2007 Nov 1 1 allow vacuum to change pragma setting instead of using existing ones #cacae5 2760 new active 2007 Nov anonymous 2007 Nov 5 4 request: sqlite3_unlink() to delete db files. #cacae5 2821 new active 2007 Dec anonymous 2007 Dec 3 4 hashtable indicies #cacae5 2831 new active 2007 Dec anonymous 2007 Dec 3 4 alter view #cacae5 2847 new active 2007 Dec anonymous 2008 Jan 5 4 Include major, minor, and patch version numbers in sqlite.h #cfe8bd 2853 new active 2007 Dec anonymous 2008 Jan 2 3 optimizer fails to use an index on MAX subquery #c8c8c8 2869 new active 2008 Jan anonymous 2008 Jan 5 5 add "sqlite3_open16_v2" to the C API #cacae5 2884 new active 2008 Jan anonymous 2008 Jan 4 4 Way to find out limits #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. #cacae5 2912 new active 2008 Jan anonymous 2008 Jan 5 4 merge join