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