Small. Fast. Reliable.
Choose any three.
Key: Active Review Fixed Tested Deferred Closed
# Type Status Created By Subsys Changed Assigned Svr Pri Title
17 new closed 2002 Apr anonymous   2002 Sep drh 5 5 Enhancement of %q in sqlite...printf API
38 code closed 2002 May danielk1977 CodeGen 2009 Sep   3 5 Count-changes broken for: DELETE FROM <table-name> (no WHERE clause)
64 code closed 2002 Jun danielk1977 Shell 2002 Sep   5 5 TEMP tables in a read-only db using the shell tool
67 new closed 2002 Jun anonymous   2008 Jun   5 5 BLOB (Binary Large OBject) support
68 new closed 2002 Jun anonymous   2009 Oct   5 5 PRAGMA table_info(table-name) for queries
70 doc closed 2002 Jun anonymous   2002 Sep   5 5 Error in online documentation for DROP VIEW
113 doc closed 2002 Jul anonymous   2002 Aug   5 5 Incorrect description of SQLite
115 new closed 2002 Jul anonymous Unknown 2003 Nov   1 5 table_info() missing datatypes
119 doc closed 2002 Jul anonymous   2003 Jul   5 5 How to Compile Sqlite.dll With VC++
126 event closed 2002 Jul anonymous VDBE 2009 Sep   4 5 malloc-1.195 test aborts from assert in vdbe.c
127 event closed 2002 Jul anonymous Unknown 2003 Jan   4 5 testfixture crashes with bus error following misuse-5.3 test
151 new closed 2002 Sep anonymous   2008 Mar   5 5 Add 'configure' options for locating readline headers and library
169 new closed 2002 Oct anonymous Unknown 2008 Jun anonymous 5 5 CE version
181 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 5 5 MAX Function on NULL Values
219 new closed 2003 Jan anonymous   2009 Oct   5 5 MySQL style enums
230 event closed 2003 Jan anonymous Shell 2009 Oct anonymous 4 5 Problems compiling on AIX 4.3.3
241 new closed 2003 Feb anonymous   2008 Jun anonymous 5 5 lack of alter table statement
331 doc closed 2003 May anonymous Unknown 2009 Oct mihailim 5 5 Went to compile Win32 project and found a missing header reference
363 new closed 2003 Jun anonymous VDBE 2009 Oct jadams 5 5 sqlite support domain as user defined type
428 new closed 2003 Aug anonymous TclLib 2009 Oct drh 5 5 missing prepare/fetch functions to be compatible with other DBs
472 new closed 2003 Oct anonymous VDBE 2008 Jun   5 5 [Patch] Using localtime instead UTC time to 'now'
540 event closed 2003 Dec drh   2009 Oct   1 5 Database corruption observed
570 event closed 2004 Jan anonymous   2004 Jan   5 5 database created on x86 can't work on arm
635 new closed 2004 Feb anonymous   2004 Mar   5 5 ROWID as ref. number
638 new closed 2004 Mar anonymous   2009 Oct   5 5 Lemon.c could not be compiled - source dated 27.02.2004
645 new closed 2004 Mar anonymous   2009 Oct   5 5 OpenWatcom makefile
652 doc closed 2004 Mar anonymous Unknown 2009 Oct anonymous 5 5 small addition needed in pragma table_info
656 code closed 2004 Mar anonymous Unknown 2009 Oct   5 5 The 'sum' and 'avg' functions don't work on Solaris (UNIX)
660 new closed 2004 Mar anonymous   2009 Oct   5 5 compression/encoding feature?
661 new closed 2004 Mar anonymous   2004 Mar   5 5 In-Memory feature?
662 new closed 2004 Mar anonymous   2009 Oct drh 5 5 Stored Procedures?
663 new closed 2004 Mar anonymous   2004 Mar drh 5 5 SELECT TOP n?
664 new closed 2004 Mar anonymous   2004 Mar   5 5 In-Memory convert to disk database file?
669 new closed 2004 Mar anonymous   2004 Mar   5 5 named-field?
704 event closed 2004 Apr anonymous   2004 Apr   5 5 .database && .databases
724 new closed 2004 May anonymous   2009 Oct   4 5 VACUUM resets settings for the current session
725 new closed 2004 May anonymous   2008 Jun anonymous 5 5 Implement ATTACH LIB comand
726 new closed 2004 May anonymous Parser 2008 Jun anonymous 5 5 As to single quote
732 doc closed 2004 May anonymous   2009 Oct   5 5 Odd columns lead to odder selections
741 new closed 2004 May anonymous CodeGen 2008 Jun anonymous 5 5 command tool does not support history
742 new closed 2004 May anonymous VDBE 2008 Jun anonymous 5 5 database is locked
746 warn closed 2004 May anonymous CodeGen 2009 Oct anonymous 5 5 How can I make sqlite support serial term?
761 todo closed 2004 Jun anonymous Unknown 2004 Jun   5 5 the current sqlite_source.zip is 2.8.13, not 2.8.14
878 build closed 2004 Aug anonymous Unknown 2008 Jun   5 5 Wrong shared library file-names
921 code closed 2004 Sep anonymous   2004 Sep   5 5 2nd time: SQL does not support non-ASCII IO?
961 new closed 2004 Oct anonymous   2004 Oct anonymous 5 5 a varchar value can be longer than its definition
968 code closed 2004 Oct anonymous Unknown 2004 Oct anonymous 5 5 Access overrun (sometimes) with use of SELECT DISTINCT
1014 doc closed 2004 Nov anonymous Parser 2009 Oct   5 5 Can't have column name "first" any more...
1029 doc closed 2004 Dec anonymous Unknown 2008 Jun   4 5 SQLITE_ not SQLITE3_ constants in the C/C++ interface . html
1045 event closed 2004 Dec anonymous   2004 Dec   1 5 MAJOR Problem with accessing databases
1148 new closed 2005 Feb anonymous Shell 2005 Mar   5 5 patch to print query execute time on shell.c
1203 todo closed 2005 Apr anonymous   2009 Oct   4 5 Web site problem, download links
1209 doc closed 2005 Apr anonymous Unknown 2008 Jun anonymous 3 5 SQLite3_Free_Table returns not #SQLITE_OK if suceeds
1241 code closed 2005 May anonymous   2009 Oct   4 5 sqlite3_create_collation16 - should have 'const void* zName' arg
1296 new closed 2005 Jun anonymous Unknown 2006 Feb   5 5 Nested Transactions needed
1330 code closed 2005 Jul anonymous Shell 2005 Aug   2 5 The internal function max doesn't work properly
1332 new closed 2005 Jul anonymous Unknown 2009 Oct   5 5 update 20x slower when using a temp table
1369 new closed 2005 Aug anonymous Shell 2005 Aug drh 5 5 Inefficient restoration of indexed dumps
1400 new closed 2005 Aug anonymous   2009 Dec   5 5 Use of indexes in queries to VIEWS built from UNION SELECTS
1466 warn closed 2005 Oct anonymous   2009 Oct   5 5 compile warnings
1468 new closed 2005 Oct anonymous Parser 2009 Oct   5 5 Added Mysql function CONCAT
1472 build closed 2005 Oct anonymous   2005 Oct   1 5 Borland command line compiler v 5.5 and SQLite
1475 new closed 2005 Oct anonymous Parser 2009 Oct anonymous 5 5 sytax error near autoincrement
1599 doc closed 2006 Jan anonymous   2006 Jan   5 5 Typo in FAQ not quite fixed
1602 code closed 2006 Jan anonymous   2006 Jan   4 5 likely typo in shell.c
1621 code closed 2006 Jan danielk1977   2009 Oct   5 5 Compiling with OMIT_FLOATING_POINT causes a segfault in the test suite
1653 new closed 2006 Feb anonymous CodeGen 2009 Oct   4 5 SQLITE_OMIT_COST_REORDERING ?
1730 new closed 2006 Mar anonymous   2006 Mar   2 5 referential integrity
1732 doc closed 2006 Mar anonymous   2008 Jun   5 5 Info on Home page
1734 code closed 2006 Mar anonymous Parser 2006 Mar drh 5 5 when not null is before integer primary key, syntax error occurs
1769 new closed 2006 Apr anonymous Unknown 2009 Oct drh 5 5 Is there any djgpp port for 3-3-5
1772 new closed 2006 Apr anonymous TclLib 2009 Oct   5 5 db eval {QUERY} { do something } ELSE { there was no match }
1781 new closed 2006 Apr anonymous   2009 Oct   3 5 Interleaved sqlite_step behaves inconsistently
1788 new closed 2006 Apr anonymous   2009 Oct   5 5 memory allocator able to return with several allocated bloks at once
1834 code closed 2006 Jun anonymous   2006 Jun   5 5 Can't create database with the é name (french E)
1838 code closed 2006 Jun anonymous   2009 Oct   5 5 test types3-1.3 fails on 64-bit Linux
1852 code closed 2006 Jun anonymous   2006 Jun   4 5 AUTOINC NOT NULL problem
1855 doc closed 2006 Jun anonymous   2006 Jun   5 5 how to configure SQLite with jboss
1858 doc closed 2006 Jun anonymous   2008 Jun   5 5 Typo: Pearl -> Perl
1934 doc closed 2006 Aug anonymous   2009 Oct   5 5 Documentation about default file format
1938 build closed 2006 Aug anonymous   2009 Oct   4 5 Cygwin compilation of v3 fails
2024 code closed 2006 Oct anonymous   2009 Oct drh 5 5 Add If not exist syntax to Create Virtual Table
2025 code closed 2006 Oct anonymous   2009 Oct drh 5 5 Add pragama command to return loaded extension list
2026 code closed 2006 Oct anonymous   2009 Oct   4 5 \n in .output is not allowed even with quote
2061 doc closed 2006 Nov anonymous   2009 Oct mihailim 5 5 cleanup for quickstart.html
2092 code closed 2006 Dec anonymous   2006 Dec   4 5 Bind null on an insert doesn't allow a WHERE bound with null
2105 new closed 2006 Dec anonymous   2009 Oct   5 5 sqlite3_exec does not return modified rows
2148 doc closed 2007 Jan anonymous   2009 Oct   5 5 3.3.9 changes.html addition
2197 code closed 2007 Jan anonymous   2007 Jan   4 5 invalid(?) join syntax results in runnable sql code
2209 doc closed 2007 Feb anonymous   2007 Feb   5 5 Wrong Comment in the change #3622
2374 code closed 2007 May anonymous   2009 Oct   5 5 "ALTER TABLE foo RENAME TO bar" will quote bar (ie. 'bar')
2384 doc closed 2007 May anonymous   2007 May   1 5 an error in comments
2420 code closed 2007 Jun anonymous   2007 Jun   5 5 sqlite3_prepare() don't work in php pdo implementation
2451 code closed 2007 Jun anonymous   2007 Jun   5 5 vdbe.c comment typo
2456 new closed 2007 Jun anonymous   2009 Oct   5 5 REQ: use index where applicable instead of full table scan
2462 todo closed 2007 Jun anonymous   2007 Jun   5 5 www.sqlite.org/cvstrac/tktnew suggestion
2577 code closed 2007 Aug anonymous   2007 Aug   5 5 Initilizing pointers to 0 instead of NULL.
2582 doc closed 2007 Aug anonymous   2009 Oct mihailim 5 5 documenation clarification
2620 doc closed 2007 Sep anonymous   2007 Sep   5 5 doc note needed for sqlite3_memory_alarm()
2642 code closed 2007 Sep anonymous   2007 Sep   5 5 CYGWIN compile error due to missing semicolon
2701 new closed 2007 Oct anonymous   2009 Oct   5 5 Make INSERT-ing multiple rows MySQL-compatible
2717 doc closed 2007 Oct anonymous   2007 Dec anonymous 5 5 Document clarification around SQLITE_OMIT_MEMORY_ALLOCATION
2752 code closed 2007 Nov anonymous   2007 Nov   5 5 redundant assignment?
2787 build closed 2007 Nov anonymous   2009 Jan   4 5 sqlite3.pc is not remade
2830 code closed 2007 Dec anonymous   2007 Dec   5 5 tkt2822.test refers to tkt2820 ?
2869 new closed 2008 Jan anonymous   2009 Oct   5 5 add "sqlite3_open16_v2" to the C API
2870 code closed 2008 Jan anonymous   2008 Jan danielk1977 5 5 Comment error
2887 code closed 2008 Jan anonymous   2008 Jan anonymous 5 5 || not outputing correctly with empty fields
2892 new closed 2008 Jan anonymous   2009 Oct   5 5 There should be a way in the api to read more precise error message.
2944 code closed 2008 Feb anonymous   2008 Feb   4 5 sqlite3.exe has problems with line comments (Win XP)
2948 code closed 2008 Feb anonymous   2008 Mar   5 5 Compiler warnings in SQLite 3.5.6
2956 new closed 2008 Feb anonymous   2009 Oct   1 5 alter table xxx add column yyy; on empty table (no records)
2965 event closed 2008 Feb anonymous   2008 Mar   3 5 crash of: SELECT DISTINCT .... FROM .... ORDER BY ROWID DESC;
3081 new closed 2008 Apr anonymous   2008 Apr   5 5 Primary key violated with UPDATE
3135 code closed 2008 May anonymous   2009 Oct   5 5 simple generic sqlite3_exec16 implemantation
3137 code closed 2008 May anonymous   2009 Oct   5 5 a small patch to support loading enable extension automatically
3167 new closed 2008 Jun anonymous   2009 Oct   5 5 Use threaded dispatch in the VDBE interpreter
3205 build closed 2008 Jul anonymous   2009 Oct   5 5 nan test failing - "inf" versus "Infinity"?
3239 code closed 2008 Jul anonymous   2009 Oct   5 5 ALTER TABLE sqlite_master - invalid error message
3243 code closed 2008 Jul anonymous   2008 Aug   5 5 constant in the code
3265 doc closed 2008 Aug anonymous   2009 Oct   5 5 Not implemented features - triggers
3271 code closed 2008 Aug anonymous   2008 Aug   5 5 Minor doc typo in sqlite3.h.in
3380 code closed 2008 Sep anonymous   2008 Sep   5 5 Timeline shows dates in weird format
3464 code closed 2008 Oct anonymous   2008 Oct   2 5 BOOLEAN type accepts all kinds of values, weird!!!
3483 code closed 2008 Nov anonymous   2009 Oct   5 5 Have a cache of prepared statements
3502 doc closed 2008 Nov anonymous   2008 Nov danielk1977 5 5 Compiling genfkey.c without sqlite3.c
3503 doc closed 2008 Nov anonymous   2008 Nov   5 5 SELECT documentation uses "as" instead of "has"
3529 new closed 2008 Dec anonymous   2009 Oct   3 5 Progress callback not invoked by PRAGMA integrity_check
3577 code closed 2009 Jan anonymous   2009 Jan drh 3 5 Result of "select string_value || NULL_value from some_table" is NULL
3580 new closed 2009 Jan anonymous   2009 Jan chw 3 5 conect vbscript
3596 code closed 2009 Jan anonymous   2009 Oct   4 5 "make test" return errors when SQLITE_DEFAULT_PAGE_SIZE=4096
3609 new closed 2009 Jan anonymous   2009 Oct   5 5 New boundary tests dont check for 32bit row id
3611 warn closed 2009 Jan anonymous   2009 Oct   5 5 mingw gcc warnings
3676 code closed 2009 Feb anonymous cli 2009 Feb   5 5 SQLite error no such table: syringes
3677 warn closed 2009 Feb anonymous vfs 2009 Feb danielk1977 5 5 os_common.h may have unneeded definition of sqlite3_pending_byte
3699 doc closed 2009 Mar anonymous back 2009 Mar   5 5 Clarify parameter documentation for pager_playback_one_page in pager.c
3704 doc closed 2009 Mar anonymous front 2009 Oct   4 5 Clarify parameter documentation for isLikeOrGlob in where.c
3725 doc closed 2009 Mar anonymous   2009 Mar   5 5 Incorrect diagram on http://www.sqlite.org/lang_createtable.html
3741 warn closed 2009 Mar anonymous   2009 Oct   4 5 1 = '1'
3827 doc closed 2009 Apr anonymous cli 2009 Apr   4 5 Type in online help
3877 code closed 2009 May anonymous func 2009 May   1 5 substr problem
3886 doc closed 2009 May anonymous func 2009 Oct   4 5 Unclear documentation regarding built-in function overriding
3892 website closed 2009 Jun anonymous   2009 Jun   5 5 typo on download page
3899 code closed 2009 Jun anonymous   2009 Jun   3 5 Random SQLITE_ERROR returned instead of SQLITE_BUSY
3953 new closed 2009 Jul anonymous front 2009 Oct a.rottmann 3 5 create view from SQL with noname expressions generates unusable names
4003 code closed 2009 Jul anonymous func 2009 Oct   3 5 wrong rounding
1 new closed 2002 Mar drh VDBE 2005 Feb   3 4 Make the LIKE operator a user-installable function
5 code closed 2002 Mar anonymous   2002 May   3 4 Bug submitter ignores severity/priority
14 new closed 2002 Apr anonymous   2002 Apr drh 5 4 decouple the BTREE implementaion from sqlite
15 code closed 2002 Apr anonymous CodeGen 2002 May   5 4 getting the number of affected lines is harder than necessary
19 new closed 2002 Apr danielk1977 BTree 2002 May   3 4 synchronous pragma does not effect TEMP tables
26 doc closed 2002 Apr anonymous   2002 Sep drh 5 4 Proc-1 Not Refresh Newer SQLITE_MASTER Info After Proc-2 CreateTable
31 code closed 2002 Apr danielk1977 CodeGen 2002 Sep   4 4 SELECT without FROM
45 code closed 2002 May anonymous   2002 Sep   4 4 Unique constraint problem on updating PRIMARY KEY column
47 code closed 2002 May anonymous   2002 Sep   5 4 Compiler Warning using MingW/gcc
52 new closed 2002 May anonymous   2002 Sep   5 4 Backslash check on temporary file names under Win32
53 new closed 2002 May anonymous   2002 Sep   5 4 Single checkpoint file enhancement
57 code closed 2002 Jun anonymous   2002 Jun   4 4 UPDATE Command Fails When Table Name is Part of SET Statement
58 new closed 2002 Jun anonymous   2002 Jun   4 4 Table JOIN Syntax Not Recognized
59 doc closed 2002 Jun anonymous   2002 Sep   3 4 Undocumented Concatenation Operator
60 new closed 2002 Jun anonymous   2002 Jun   3 4 UPDATE Statement with FROM Clause FAILS
62 code closed 2002 Jun danielk1977 VDBE 2002 Sep   3 4 TEMP tables with a read-only database
69 new closed 2002 Jun anonymous   2002 Jun   5 4 Sequences (some sort of auto-incremental fields...)
71 code closed 2002 Jun anonymous   2002 Sep drh 2 4 "COPY table FROM file" expects lines to end with LF.
82 new closed 2002 Jun anonymous   2009 Oct   1 4 Add IsCacheable, IsNullable to sqlite_create_function
87 new closed 2002 Jun anonymous   2005 Jan   1 4 ORDER BY & ISO 8859-2
88 doc closed 2002 Jun anonymous   2002 Sep   4 4 Typo on web page
89 new closed 2002 Jun chw Parser 2002 Sep   1 4 table aliases broken
109 new closed 2002 Jul anonymous   2002 Jul   5 4 Can the build process include a way to make a static library?
110 new closed 2002 Jul anonymous Unknown 2002 Sep anonymous 5 4 Refuse multiple begin transaction or commit
112 code closed 2002 Jul anonymous   2002 Sep   4 4 Segmentation fault in 2.5.5 when opening a 2.6.1 database
128 event closed 2002 Jul anonymous Unknown 2009 Oct   4 4 Workaround for problem reported in ticket 127-
129 event closed 2002 Jul anonymous Unknown 2009 Oct   4 4 tcl-2.2 test fails
149 new closed 2002 Sep anonymous Unknown 2002 Sep   5 4 SELECT UNIQUE
164 event closed 2002 Oct anonymous CodeGen 2008 Jun anonymous 3 4 Compiler warnings with MS Visual C++ 6.0
167 new closed 2002 Oct anonymous Shell 2002 Dec   5 4 Difficult to quickly quit sqlite
186 new closed 2002 Nov anonymous Shell 2008 Mar   5 4 ./configure --enable-threads-safe ?
192 doc closed 2002 Nov anonymous Unknown 2009 Oct anonymous 4 4 Finishing build on MacOS 10.x (and other *nix's, likely)
199 new closed 2002 Dec anonymous Unknown 2005 Jan drh 4 4 Encryption
205 code closed 2002 Dec anonymous VDBE 2002 Dec   4 4 select order by on a column with null values causes uninitialized-read
229 new closed 2003 Jan anonymous Parser 2009 Oct   5 4 DECLARE ... CURSOR FOR ... would be really nice
233 event closed 2003 Jan anonymous Unknown 2009 Oct   1 4 test bigfile-1.1 dumps core on Tru64 platform
243 new closed 2003 Feb anonymous Unknown 2008 Jun anonymous 3 4 Performance problem with MSVC precompiled DLL
244 new closed 2003 Feb anonymous Unknown 2009 Oct drh 5 4 Combining CREATE TABLE with its populating from some flat file
260 doc closed 2003 Mar anonymous   2003 Mar   5 4 may i add a contributed by <mailadress> to the wiki HowToCompile ?
263 new closed 2003 Mar anonymous CodeGen 2009 Oct   1 4 sqlite locking strategy can lead to deadlock
264 code closed 2003 Mar anonymous   2005 Jan   5 4 Result of lseek for UNIX version of sqliteOsSeek() is not checked
267 code closed 2003 Mar anonymous Unknown 2003 Mar anonymous 1 4 sqlite.dll / sqlite.def does not export an Init function
294 new closed 2003 Apr anonymous Shell 2009 Oct a.rottmann 1 4 Diff for OpenBSD
303 build closed 2003 May anonymous Unknown 2008 Jun a.rottmann 4 4 Makefile issues
314 event closed 2003 May anonymous Unknown 2003 May   4 4 Memory usage
324 todo closed 2003 May anonymous VDBE 2005 Jan   1 4 ESCAPE clause in LIKE predicate not implemented
326 new closed 2003 May anonymous   2009 Oct   4 4 Request for additional callback for various functions
330 code closed 2003 May anonymous VDBE 2009 Oct   3 4 Aggregator's error are ignored
368 code closed 2003 Jun anonymous   2009 Oct   3 4 UPDATE trigger doesn't fire on INSERT OR REPLACE
375 new closed 2003 Jul anonymous   2003 Jul anonymous 4 4 I'm missing DB metadata.
390 code closed 2003 Jul anonymous Shell 2003 Jul   3 4 database creation
395 code closed 2003 Jul anonymous Unknown 2009 Oct   4 4 Error opening db on Mac OS X not reported correctly
407 new closed 2003 Jul anonymous   2008 Jun   4 4 sqlite_compile etc. and pragma empty_result_callbacks.
414 code closed 2003 Jul anonymous VDBE 2009 Oct   3 4 sqlite_compile() and database schema changes
417 code closed 2003 Jul anonymous Unknown 2003 Aug   4 4 Resultset differs between ..LIMIT 20 OFFSET 100 and ..LIMIT 20, 100
418 code closed 2003 Jul anonymous Unknown 2005 Jan   4 4 sometimes web page returns error, hitting refresh makes it work
431 new closed 2003 Aug anonymous Shell 2003 Aug   5 4 possibility to use sql scripts in a file on the command line
438 code closed 2003 Aug anonymous Unknown 2005 Jan   1 4 Minute function off between 11:16 and 11:20
449 new closed 2003 Sep anonymous   2005 Jan   3 4 Date and time functions for SELECTs
454 new closed 2003 Sep anonymous   2009 Oct   4 4 schema column types with parenthesis to automatically invoke functions
466 todo closed 2003 Sep anonymous   2005 Jan   4 4 index internationalisation
477 new closed 2003 Oct anonymous   2008 Jun anonymous 4 4 Are there any plans to enchance SQLite to support Unicode
484 build closed 2003 Oct anonymous   2009 Oct   5 4 make clean cleans doc/ completely
485 new closed 2003 Oct anonymous BTree 2009 Oct   5 4 Comparing strings: user defined callback, strcoll?
486 new closed 2003 Oct anonymous VDBE 2009 Oct   5 4 index on expressions (general solution to case-insensitive problem)
491 new closed 2003 Nov anonymous   2009 Oct   4 4 Want to use SET col = 'val' with INSERT statement
492 code closed 2003 Nov anonymous Unknown 2003 Nov   2 4 database image is malformed
494 new closed 2003 Nov anonymous   2003 Nov   4 4 No way to get a list of table columns without parsing the schema
498 new closed 2003 Nov anonymous Unknown 2008 Jun   4 4 Suggestion: Allow named parameters.
500 doc closed 2003 Nov anonymous Unknown 2008 Jun   4 4 Discrepancies in comments in encode.c
501 doc closed 2003 Nov anonymous Unknown 2008 Jun anonymous 4 4 missing sqlite_encode_binary
507 code closed 2003 Nov anonymous Unknown 2003 Nov   2 4 string comparison in where-clause of select
508 doc closed 2003 Nov anonymous   2009 Oct   4 4 Build instructions on home page needs link to page with platform help
518 code closed 2003 Dec anonymous Unknown 2009 Oct   3 4 PRIMARY KEY does not imply UNIQUE and NOT NULL
525 new closed 2003 Dec anonymous   2009 Oct   4 4 DB testing
531 code closed 2003 Dec anonymous   2003 Dec   4 4 INT is not treated the same as INTEGER
539 new closed 2003 Dec anonymous VDBE 2009 Oct   5 4 Addition of engine 'Suspension' interface
543 new closed 2003 Dec anonymous   2003 Dec   5 4 Feature Request: Indicate NOT NULL columns in table_info.
544 new closed 2004 Jan anonymous   2009 Oct   5 4 Feature Request: Indicate UNIQUE columns in table_info.
547 code closed 2004 Jan anonymous TclLib 2005 Jan   3 4 tcl array not cleared between queries
556 warn closed 2004 Jan anonymous CodeGen 2004 Jan   3 4 double to int warnings in date.c
560 warn closed 2004 Jan anonymous   2008 Jun   4 4 Warnings on commpiling using Visual C++ 6.0
566 new closed 2004 Jan anonymous Unknown 2009 Oct   4 4 [PATCH] Port of sqlite and lemon to an EBCDIC mainframe
588 new closed 2004 Jan anonymous   2009 Oct   5 4 Please provide support for NULLS LAST in ORDER BY clauses.
589 new closed 2004 Jan anonymous Shell 2005 Sep   5 4 HTML tags in shell.c should be lower case
590 new closed 2004 Jan anonymous Parser 2009 Oct   5 4 Treat ` like spaces outside of quoted strings.
591 todo closed 2004 Feb anonymous Unknown 2009 Oct anonymous 5 4 "PRAGMA table_info" doesn't show you which column is unique
595 code closed 2004 Feb anonymous   2004 Feb   1 4 Big joins dont work as I expect
598 code closed 2004 Feb anonymous   2005 Jan   1 4 Joins not supported in DELETE
609 build closed 2004 Feb anonymous Unknown 2008 Jun   1 4 Makefile errors
613 doc closed 2004 Feb anonymous   2008 Jun   3 4 Doc is wrong with some prototypes and const is missing for errmsg
637 code closed 2004 Mar anonymous Parser 2009 Oct   5 4 union uses non-standard column names
646 warn closed 2004 Mar anonymous Pager 2008 Jun   5 4 Pager.c compilation warnings
647 warn closed 2004 Mar anonymous Shell 2008 Jun   5 4 Shell.c compilation warnings
650 new closed 2004 Mar anonymous Parser 2004 Mar   4 4 DISTINCT aggregates
666 code closed 2004 Mar anonymous Unknown 2009 Oct anonymous 5 4 Error message indicates wrong error
671 build closed 2004 Mar anonymous TclLib 2004 Mar   4 4 Missing tcl.h from /src
674 code closed 2004 Mar anonymous   2004 Mar   3 4 insert record fails mpatrol tests
689 doc closed 2004 Apr anonymous   2009 Oct anonymous 4 4 Old Comment for sqlite_decode_binary in sources ?
694 code closed 2004 Apr anonymous Unknown 2004 Apr   3 4 uninitialised or unaddressable byte(s) in os.c
697 event closed 2004 Apr anonymous Unknown 2009 Oct   3 4 Questionable locking
699 new closed 2004 Apr anonymous   2009 Oct   5 4 Data types and implicit conversions
710 new closed 2004 Apr anonymous Unknown 2008 Jun drh 3 4 Provide the ability to pass a user-data value during sqlite_compile
723 new closed 2004 May anonymous Unknown 2009 Oct   5 4 BatchScript: Example windows batch script for creating databases.
734 build closed 2004 May anonymous TclLib 2009 Jan   4 4 libtclsqlite.xxx not built by default make all target
736 new closed 2004 May anonymous   2009 Oct   4 4 Would like to be able to list the LAST 10 lines of a query
752 doc closed 2004 Jun anonymous   2008 Jun   4 4 FAQ-Entry: How to escape quotes
753 code closed 2004 Jun anonymous Unknown 2004 Nov drh 4 4 view always report numeric as data type
763 code closed 2004 Jun anonymous Unknown 2009 Oct   5 4 tclsqlite.dll not showing the correct version
773 code closed 2004 Jun anonymous Unknown 2004 Jun   3 4 user-defined sql function called unexpected number of times
781 code closed 2004 Jun anonymous Unknown 2004 Jun   4 4 unable to run malloc test even with -DMEMORY_DEBUG
787 code closed 2004 Jun anonymous Unknown 2005 Jan   4 4 Bad free() ignored (PERL_CORE)
799 build closed 2004 Jul anonymous Unknown 2004 Jul   5 4 Missing exports in 3.0.2 Win32 DLL
816 doc closed 2004 Jul anonymous Unknown 2009 Oct   1 4 sqlite3_changes - absent in sqlitedll-3_0_2.zip
820 code closed 2004 Jul anonymous Parser 2004 Oct   4 4 problem with sqlite3_prepare and variables
822 code closed 2004 Jul anonymous Unknown 2009 Oct drh 1 4 port of sqlite to dos with djgpp + small general bugfixes
823 new closed 2004 Jul anonymous Unknown 2009 Oct mihailim 5 4 absent VERSIONINFO into any Win32 DLL
824 new closed 2004 Jul anonymous Unknown 2009 Oct   5 4 StrSum - new build-in aggreate function suggestion
832 code closed 2004 Jul anonymous Unknown 2009 Oct anonymous 4 4 os_win.c :: sqlite3OsUnlock() method has an unused variable: rc
835 doc closed 2004 Jul anonymous Unknown 2004 Aug   4 4 Locks reference on the FAQ - Read while writing?
845 new closed 2004 Aug anonymous   2009 Oct   5 4 Support shared-memory databases
852 doc closed 2004 Aug anonymous   2008 Jun   5 4 Typos found in the Syntax documentation
883 new closed 2004 Sep anonymous Shell 2009 Oct   1 4 Choose appropriate column widths for column output
931 new closed 2004 Sep anonymous   2009 Oct   5 4 Makefile for mingw on Win32, makes DLL, EXE and docs
935 code closed 2004 Sep anonymous Unknown 2004 Nov   4 4 several crash.test tests fail (spuriously) when [sqlite3 -has-codec]
937 code closed 2004 Oct anonymous VDBE 2004 Oct drh 2 4 mixed wildcard "?" and ":abc" cause msvcrt.dll raise a exception.
950 new closed 2004 Oct anonymous Unknown 2004 Oct   2 4 No access to sqlite3ErrStr and sqlite3_temp_directory
954 build closed 2004 Oct anonymous   2009 Jan   2 4 Autogerated opcodes.h breaks bulid on MinGW/MSYS
974 new closed 2004 Oct anonymous   2008 Jun   5 4 Version-Resource in pre-compiled windows dll
986 code closed 2004 Nov anonymous Unknown 2004 Nov   3 4 indexed "between" is slower than manually typing out constraints
988 code closed 2004 Nov anonymous Unknown 2004 Nov   4 4 column type "int primary key" doesn't autoincrement
993 new closed 2004 Nov anonymous   2004 Nov   3 4 Plug-in codec support.
996 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 2 4 Error in primary key fields for temp tables
997 code closed 2004 Nov anonymous   2004 Nov   2 4 Returned column names include table name or alias.
999 build closed 2004 Nov anonymous   2005 Jan   5 4 CVS conflict files left in the source
1011 new closed 2004 Nov anonymous   2009 Oct   5 4 No .lib file for in windows precompiled binaries
1015 doc closed 2004 Nov a.rottmann   2005 Mar   5 4 Manpage fixes for SQLite3
1020 doc closed 2004 Nov anonymous   2008 Jun mihailim 5 4 in html (.tcl) <,> is not always &lt, &gt
1022 code closed 2004 Nov anonymous   2004 Dec   4 4 Table column naming differs between versions 2.8.15 and 3.0.8
1023 new closed 2004 Nov anonymous Unknown 2004 Dec   4 4 don't link against pthreads if not configured with --enable-threadsafe
1031 new closed 2004 Dec anonymous   2009 Oct   3 4 sqlite command line does not allow intermixing of dot commands and sql
1034 build closed 2004 Dec anonymous TclLib 2009 Oct   2 4 configure generated Makefile doesn't use TCL on MinGW on Windows
1040 new closed 2004 Dec anonymous Unknown 2009 Oct   4 4 pragma needed to enable flexibility of insert statements (esp. for awk-like filter use)
1050 doc closed 2004 Dec anonymous   2004 Dec   4 4 Correct front page information - SQLite is not ACID
1059 doc closed 2005 Jan anonymous Unknown 2009 Oct   5 4 Full support for IEEE 754 floating points
1061 new closed 2005 Jan anonymous Shell 2009 Oct   4 4 shell.c .import from stdin
1067 code closed 2005 Jan anonymous TclLib 2005 Jan anonymous 2 4 Tcl parsing failure in SQL statement DELETE?
1093 doc closed 2005 Feb anonymous Unknown 2005 Feb   5 4 possible mistake in a comment sqlite3_get_table sqlite3.h:~line312
1110 code closed 2005 Feb anonymous Parser 2005 Feb   4 4 Detection of invalid create table statement
1112 code closed 2005 Feb anonymous   2009 Oct   3 4 make test failures (108 out of 19721) on AIX 5.2, Power5 CPU
1123 build closed 2005 Feb anonymous TclLib 2009 Oct   3 4 cannot find tcl.h
1130 doc closed 2005 Feb anonymous   2005 Feb   4 4 documentation for PRAGMA short-column-names incorrect
1150 code closed 2005 Feb anonymous Parser 2005 Feb   4 4 'insert' is not a legal transaction name
1160 code closed 2005 Mar anonymous CodeGen 2005 Mar   4 4 GROUP BY is broken
1174 build closed 2005 Mar anonymous Parser 2005 Mar   4 4 Link problem using SQLITE_OMIT_xxx
1177 code closed 2005 Mar anonymous Shell 2009 Oct   1 4 (Win32) .import inserts extra carrier character in every row
1186 new closed 2005 Mar anonymous Shell 2009 Oct   4 4 Pragma page_size doesn't set the pagesize immediately
1190 new closed 2005 Mar anonymous Unknown 2009 Oct drh 4 4 strftime() does not Support Years with 3 or 5 digits
1208 new closed 2005 Apr anonymous Unknown 2008 Jun   4 4 no version info provided in precompiled sqlite3.dll
1221 new closed 2005 Apr anonymous   2009 Oct   5 4 Implementation of PRAGMA trigger_info(table)
1222 code closed 2005 Apr anonymous Unknown 2009 Oct   2 4 spec file errors
1223 code closed 2005 Apr anonymous   2009 Oct   3 4 .read FILENAME fails
1242 code closed 2005 May anonymous Shell 2009 Oct   3 4 EXPLAIN causes segmentation fault on OSX (and linux)
1249 new closed 2005 May anonymous Unknown 2009 Oct   5 4 transaction
1267 code closed 2005 May anonymous   2005 May   5 4 exists and case don't work together on an empty table
1280 new closed 2005 Jun anonymous   2005 Jun   5 4 Make tests can be run as root
1286 code closed 2005 Jun anonymous   2008 Jun   4 4 The downloadable DLL file does not work with Intel VTune
1302 event closed 2005 Jun anonymous Unknown 2009 Oct   1 4 malloc error after dumping table
1308 code closed 2005 Jun anonymous   2009 Oct   3 4 PRAGMA TABLE_INFO does not recognize attached database syntax.
1310 event closed 2005 Jun anonymous   2005 Aug   2 4 Problem after create a new table
1313 new closed 2005 Jun anonymous   2009 Oct   4 4 Allow headers in imported text files
1318 build closed 2005 Jul anonymous   2009 Oct   2 4 Build broken under Windows/MinGW
1319 new closed 2005 Jul anonymous   2009 Oct   5 4 Extend sqlite3_expired to detect schema changes
1322 code closed 2005 Jul anonymous   2005 Aug   4 4 after "select * from sqlite_master;" ".databases" command doesnt work
1325 code closed 2005 Jul anonymous Unknown 2009 Oct   1 4 sqlite3_bind_value not implemented
1349 code closed 2005 Aug anonymous Unknown 2005 Aug anonymous 4 4 NULL handling UNIQUE indexes is not consistent
1355 code closed 2005 Aug anonymous   2005 Sep   4 4 mixing GROUP and non-GROUP queries in a query should be an error
1360 code closed 2005 Aug anonymous   2005 Aug   4 4 Unsafe casting in table.c
1381 new closed 2005 Aug anonymous Parser 2009 Oct   5 4 missing important builtin function stdev
1401 code closed 2005 Aug anonymous Shell 2009 Oct   4 4 concatenating html in select list
1403 code closed 2005 Sep anonymous Pager 2009 Oct   4 4 Newly initialized pages aren't completely cleared
1423 new closed 2005 Sep anonymous   2009 Oct drh 3 4 Binding NULL does not work as expected
1438 code closed 2005 Sep anonymous   2005 Sep   4 4 UPDATE bug
1441 code closed 2005 Sep anonymous VDBE 2008 Jun   4 4 sqlite3_clear_bindings routine missing
1446 todo closed 2005 Sep     2005 Sep   4 4 Milestones are not tagged in CVS
1448 code closed 2005 Sep anonymous   2005 Sep   1 4 Parse Error In sqlite.c While Compiling PHP-5.0.5
1454 doc closed 2005 Sep anonymous   2008 Jun   4 4 Functions should all be documented in one place
1456 code closed 2005 Sep anonymous Unknown 2005 Sep   4 4 get_table16 ?
1470 new closed 2005 Oct anonymous Unknown 2005 Oct anonymous 2 4 International support
1476 new closed 2005 Oct anonymous   2009 Oct   5 4 Patch for SQLite sequence manipulation functions
1481 code closed 2005 Oct anonymous VDBE 2006 Sep   4 4 sqlite 3.2.7 does not report column names properly in joined queries
1484 code closed 2005 Oct anonymous Unknown 2009 Oct   4 4 Solaris8 awk problem
1491 new closed 2005 Oct anonymous Shell 2008 Jun   4 4 syntax error with " .mode column:
1492 code closed 2005 Oct anonymous   2005 Nov   1 4 CURRENT_TIMESTAMP bad for PM times.
1495 code closed 2005 Oct anonymous   2005 Oct   2 4 SELECT DISTINCT "col_name" from "TablName fails on first & last fields
1500 code closed 2005 Oct anonymous Unknown 2009 Oct   4 4 MIssing file listing permission causes DB opening/creation to fail
1503 doc closed 2005 Oct anonymous   2008 Jun   5 4 typo in datatype3.html
1506 new closed 2005 Nov anonymous Shell 2009 Oct   1 4 Add some flags to .import command
1518 code closed 2005 Nov anonymous Unknown 2005 Nov   4 4 can not vacuum an empty db-file
1519 code closed 2005 Nov anonymous Unknown 2009 Oct   3 4 Size double with blob data on UPDATE ?
1520 new closed 2005 Nov anonymous   2006 Jul   4 4 sqlite3_column_type do not work for empty table
1528 new closed 2005 Nov anonymous Unknown 2009 Oct   5 4 Add Build Date To Command Line Greeting
1532 new closed 2005 Nov anonymous TclLib 2009 Oct   4 4 Variables don't get replaced in ATTACH statements.
1539 code closed 2005 Nov anonymous   2006 Mar   4 4 sqlite3Realloc is a trap for the unwary
1542 code closed 2005 Nov anonymous Unknown 2009 Oct   2 4 wrong field names in views with quoted table name qualifiers
1545 build closed 2005 Nov anonymous Shell 2007 Feb   4 4 Solaris systems require -lrt to link sqlite3
1549 build closed 2005 Dec anonymous   2009 Oct   5 4 install fails for non-root user when TCL active
1552 new closed 2005 Dec anonymous Unknown 2009 Oct   5 4 Adding .read FILE support to the C API
1553 new closed 2005 Dec anonymous   2006 Mar   5 4 API suggestion: sqlite3_has_more_rows()
1555 doc closed 2005 Dec anonymous BTree 2008 Jun   2 4 sqlite+Crystal reports connection
1558 new closed 2005 Dec anonymous VDBE 2009 Oct   3 4 Request more debugging info when SQL statements in progress
1559 new closed 2005 Dec anonymous Unknown 2005 Dec   4 4 SQLite file is corrupt
1560 code closed 2005 Dec anonymous Unknown 2005 Dec   4 4 "make test" fails in conflict-6.2, conflict-6.3, and -6.7 upto -6.13
1564 build closed 2005 Dec anonymous   2009 Oct   4 4 Need GNU awk
1565 doc closed 2005 Dec anonymous   2009 Oct   4 4 wrong return-type specified for sqlite3_db_handle in c-api-reference
1566 new closed 2005 Dec ghaering VDBE 2009 Oct   5 4 Implement sqlite3_clone()
1576 build closed 2005 Dec anonymous   2009 Oct   4 4 PREFIX is not honored (cannot install as non-root)
1588 new closed 2006 Jan anonymous   2009 Oct   4 4 common subexpression elimination not performed in SELECT
1613 new closed 2006 Jan anonymous   2006 Jan   4 4 "between" doesn't take advantage of indexes
1626 new closed 2006 Jan anonymous Unknown 2009 Oct   4 4 ALTER TABLE BUG/MISHEAVIOR
1627 warn closed 2006 Jan anonymous   2009 Oct   4 4 warnings on BCB and how to resolve them + couple of minor fixes
1635 doc closed 2006 Jan anonymous   2009 Oct   4 4 SQLite Ticket "Version" field
1637 code closed 2006 Jan anonymous Parser 2009 Oct   4 4 Multiple JOIN USING() doesn't work.
1641 doc closed 2006 Jan anonymous   2006 Jan   5 4 Very minor documentation thing
1642 code closed 2006 Jan anonymous   2006 Jan   4 4 single time leaks in sqlite3_prepare()
1655 new closed 2006 Feb anonymous VDBE 2009 Oct   4 4 Every function can have their private data like agreagates
1656 doc closed 2006 Feb anonymous Parser 2009 Oct   5 4 lemon versions and changelog
1663 new closed 2006 Feb anonymous Unknown 2009 Oct   4 4 Suggestion: DATETYPE field type using David Tribble's work?
1675 new closed 2006 Feb anonymous   2009 Oct   5 4 sqlite3_db_dup() ?
1679 new closed 2006 Feb anonymous   2009 Oct   4 4 SQLite requires code modification to replace memory allocation funcs
1686 code closed 2006 Feb anonymous Pager 2006 Feb   2 4 File locking and concurrency problems under Windows
1689 new closed 2006 Feb anonymous   2009 Oct   2 4 triggers and temporary tables
1693 new closed 2006 Feb anonymous Parser 2009 Oct   4 4 Parser sensitive to position of word AUTOINCREMENT
1705 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Default column constant doesn't assign value on NULL insert
1707 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Internal data are not naturaly aligned, which could affect perfomance
1714 code closed 2006 Mar anonymous CodeGen 2009 Dec   4 4 Slow query when tables in 2 different files
1715 doc closed 2006 Mar anonymous   2006 Mar   5 4 int sqlite3_release_memory(int) documented but not implemented
1719 code closed 2006 Mar anonymous   2009 Oct   4 4 Solaris 8(SQL: bus error while creating temporary file
1720 new closed 2006 Mar anonymous   2009 Oct   3 4 Actions made by a trigger are not triggered
1736 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 #define SQLITE_OMIT_ALTERTABLE causes unresolved externals
1741 warn closed 2006 Mar anonymous VDBE 2009 Oct   5 4 unused variable with SQLITE_OMIT_UTF16 defined
1747 new closed 2006 Apr anonymous Unknown 2009 Oct   4 4 Non descriptive error message
1752 code closed 2006 Apr anonymous Unknown 2006 Apr   3 4 New compile warnings with default ./configure && make on MinGW
1759 code closed 2006 Apr anonymous   2006 Apr   3 4 "int primary key" not the same as "integer primary key"
1760 code closed 2006 Apr anonymous   2006 Apr   4 4 sqlite3_open(), then sqlite3_close()
1762 build closed 2006 Apr anonymous Unknown 2009 Oct   3 4 sqlite3_clear_bindings not exported in windows dll
1767 warn closed 2006 Apr anonymous Unknown 2006 Apr   5 4 Unused variable in function sqlite3VdbeChangeEncoding
1770 new closed 2006 Apr anonymous   2009 Oct   5 4 Request for expanded DELETE USING keyword like PostgreSQL
1777 code closed 2006 Apr anonymous   2009 Oct   2 4 Cygwin should be OS_UNIX target, not OS_WIN
1779 new closed 2006 Apr anonymous   2007 Nov   5 4 enhancement request (+ pointer) -- group_concat() aggregate function
1786 warn closed 2006 Apr anonymous   2009 Oct   4 4 Yet another list of compiler warnings.
1789 doc closed 2006 May anonymous Unknown 2008 Jun drh 4 4 sqlite3_result_error() not adequately documented
1801 new closed 2006 May anonymous Pager 2009 Oct owensmk 5 4 Include Support for User-defined Lock Synchronization
1802 build closed 2006 May anonymous Unknown 2009 Jan   4 4 sqlite.pc needs -lrt on Solaris for fdatasync()
1814 new closed 2006 May anonymous   2009 Oct   3 4 Autoconf support for MacOSX univeral binaries
1826 code closed 2006 May anonymous Parser 2006 May anonymous 4 4 Select unused table in from clause produces no results
1837 new closed 2006 Jun anonymous Pager 2009 Oct   4 4 Deadlock detection would be best reported using explicit error code.
1840 code closed 2006 Jun anonymous Unknown 2006 Jun   4 4 sqlite3_get_table returns null pointer for aggregate queries
1853 code closed 2006 Jun anonymous   2009 Oct   3 4 sqlite3_analyzer-3.3.4 integer overflows on large database
1868 code closed 2006 Jun anonymous Shell 2006 Jun   4 4 where a = b = c
1869 doc closed 2006 Jun anonymous Unknown 2008 Jun anonymous 4 4 Website typo
1876 event closed 2006 Jun anonymous Unknown 2006 Jun   4 4 Creating table disrupts previously prepared statement
1890 doc closed 2006 Jul anonymous Unknown 2009 Oct mihailim 3 4 double quotes ("") in a query are ambiguous
1891 code closed 2006 Jul anonymous Shell 2006 Jul pweilbacher 4 4 OS/2 may not have access to C:\ drive
1898 doc closed 2006 Jul anonymous   2009 Oct   5 4 sqlite3_progress_handler still marked experimental in documentation
1905 new closed 2006 Aug anonymous VDBE 2009 Oct   5 4 Get bound param as sqlite3_value?
1907 new closed 2006 Aug anonymous   2009 Oct   4 4 date and time types
1908 code closed 2006 Aug anonymous Unknown 2006 Aug anonymous 2 4 ORDER BY clause does not allow quoting
1910 event closed 2006 Aug anonymous   2006 Aug   3 4 Lost clusters generated by "create TEMP Table" (DJGPP/GCC2.953)
1921 code closed 2006 Aug anonymous   2006 Aug   4 4 misc1-10.1 failure on cygwin aborts make test
1932 new closed 2006 Aug anonymous   2006 Aug   3 4 I want a way to make db open fail if file does not exist
1933 new closed 2006 Aug anonymous   2009 Oct   5 4 Add different date's separators
1935 event closed 2006 Aug anonymous Parser 2009 Oct   4 4 GROUP BY and ORDER BY constant expressions valid?
1942 new closed 2006 Aug anonymous   2009 Oct   4 4 select without left join with the *= operator
1944 new closed 2006 Aug anonymous Unknown 2006 Aug   4 4 no UTF16 counterpart to sqlite3_exec()
1950 new closed 2006 Aug anonymous   2006 Sep   4 4 AUTOINCREMENT too picky about type
1958 code closed 2006 Sep anonymous   2009 Oct   4 4 some printf tests fail with Tcl 8.5a5, ok with Tcl 8.4
1966 build closed 2006 Sep anonymous Unknown 2007 Feb   3 4 Add a --disable-readline option to configure
1970 build closed 2006 Sep anonymous Unknown 2006 Sep   4 4 Cannot make Loadable Extensions to work for me.
1971 code closed 2006 Sep anonymous Unknown 2006 Oct   4 4 66 tests fail out of 26937
1972 code closed 2006 Sep anonymous   2009 Oct   2 4 segfault on empty query
1975 new closed 2006 Sep anonymous   2009 Oct   5 4 Request for sqlite3_table_column_metadata16
1985 doc closed 2006 Sep anonymous   2006 Sep   1 4 how get table names
2003 warn closed 2006 Sep anonymous VDBE 2006 Sep   4 4 vdbeaux.c:1585: warning: unused variable 'sqlite3_search_count'
2004 warn closed 2006 Sep anonymous   2009 Oct   1 4 vtab.c:142: warning: pointer targets in initialization differ in signe
2015 code closed 2006 Oct anonymous   2009 Oct anonymous 5 4 Enhancement Req: "EXPRn" PRAGMA for result set expression column names
2041 code closed 2006 Oct anonymous   2009 Jan   4 4 sqlite3.pc on Solaris needs -lrt in "Libs:" entry
2062 doc closed 2006 Nov anonymous   2009 Oct mihailim 4 4 document 'pk' column of PRAGMA table_info()
2063 code closed 2006 Nov anonymous   2009 Oct   4 4 vtab_err.test fails if sqlite is compiled without -DSQLITE_MEMDEBUG
2064 code closed 2006 Nov anonymous   2006 Nov   3 4 Table Name ignored if table Alias specified
2068 code closed 2006 Nov anonymous   2009 Jan   4 4 pkgIndex.tcl contains incomplete version number
2070 code closed 2006 Nov anonymous   2009 Dec   4 4 No error for ambiguous result alias in WHERE clause
2073 code closed 2006 Nov anonymous   2006 Nov   4 4 Ordering by a named expression which includes random doesn't work
2074 code closed 2006 Nov anonymous   2009 Oct   4 4 feature request: .dump with page_size
2080 code closed 2006 Nov anonymous   2009 Oct   4 4 Tranfering large BLOB data not efficient
2082 code closed 2006 Nov anonymous   2008 Mar   3 4 UNIX: configure script doesn't enable loading of extensions
2083 code closed 2006 Nov anonymous   2009 Oct   4 4 Give more detailed extension loading error information with dlerror
2085 code closed 2006 Nov anonymous   2006 Nov   5 4 Round statement with different behavior between 3.2.8 and 3.3.7
2086 code closed 2006 Nov anonymous   2009 Dec   5 4 Alias in update
2106 doc closed 2006 Dec anonymous   2009 Oct   4 4 FtsOne wiki page neglects to mention Porter stemming
2112 code closed 2006 Dec anonymous   2009 Oct   5 4 code compatibility with C++
2115 code closed 2006 Dec anonymous   2006 Dec   5 4 mix of allocator functions
2119 new closed 2006 Dec anonymous   2006 Dec   5 4 Unable to use place holders as part of the actual SQL query
2120 new closed 2006 Dec anonymous   2009 Oct   5 4 Date Column support
2121 code closed 2006 Dec anonymous   2006 Dec   3 4 Paths on Win9x following API specs (UTF-8) will fail
2125 code closed 2006 Dec anonymous   2009 Oct   4 4 SQLite strings/blobs limited to 1GB/2GB due to 'int' in api
2130 code closed 2006 Dec anonymous   2009 Oct   4 4 replace "long long int" type with "sqlite_int64" defined in sqlite3.h
2132 code closed 2006 Dec anonymous   2009 Oct   3 4 table_info, index_list, index_info & friends should be virtual tables
2133 build closed 2006 Dec anonymous   2009 Oct   4 4 meta ticket for outstanding autoconf issues
2137 code closed 2007 Jan anonymous   2007 Jan shess 4 4 I cannot find tcl.h header file. So, I am not able to compile the code
2155 code closed 2007 Jan anonymous   2007 Jan   4 4 Should %s in strftime() be rounded up?
2180 new closed 2007 Jan anonymous   2009 Oct   5 4 feature request: DROP TABLE IF [EXISTS AND] EMPTY
2181 new closed 2007 Jan anonymous   2009 Oct   5 4 Generalize ON CONFLICT to failure trapping for all SQL statements
2182 code closed 2007 Jan anonymous   2009 Oct   4 4 sqlite3BtreeGetMeta does not check the file format
2187 todo closed 2007 Jan anonymous   2009 Oct   3 4 RAISE in trigger not being caught by CONFLICT clause in calling SQL
2188 doc closed 2007 Jan anonymous   2009 Oct   5 4 Doc bug in src/vdbe.c, should s/P1/P2/ in NotFound
2190 code closed 2007 Jan anonymous   2007 Jan   3 4 bogus lines on "left join" with a "where right_table.column is NULL"
2198 new closed 2007 Jan anonymous   2009 Oct   5 4 API: opening only existing databases
2200 new closed 2007 Jan anonymous   2009 Oct   5 4 threadsafe status not reported in .pc file
2202 new closed 2007 Jan anonymous   2009 Oct   5 4 function request: sqlite3_attach()
2206 new closed 2007 Jan anonymous   2009 Oct   5 4 Support for foreign key constraints in virtual tables
2207 new closed 2007 Jan anonymous   2009 Oct   3 4 "CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints
2212 code closed 2007 Feb anonymous   2007 Feb   5 4 function request: sqlite3_bind_literal()
2218 code closed 2007 Feb anonymous   2009 Oct   3 4 select columns from views with table prefix
2220 new closed 2007 Feb anonymous   2009 Oct drh 2 4 fsck for database files
2221 new closed 2007 Feb anonymous   2009 Oct drh 3 4 Store blobs using inode-like lookup of pages rather than linked list
2222 build closed 2007 Feb anonymous   2009 Oct   4 4 Type mismatch in fts2.c [5091] when compile as fastcall or stdcall
2224 new closed 2007 Feb scouten   2009 Oct   4 4 Option to have one-bit "journal should exist" flag
2225 code closed 2007 Feb scouten   2009 Oct   5 4 Request count of number of inserts and deletes from the free page list
2226 code closed 2007 Feb scouten   2009 Oct   5 4 Report on unused indices (and tables?)
2228 new closed 2007 Feb anonymous   2009 Oct   3 4 horizontal partitioning
2231 new closed 2007 Feb anonymous   2009 Oct   4 4 shell should ignore leading whitespace for meta commands
2237 code closed 2007 Feb anonymous   2009 Oct   4 4 Test suite regressions using Tcl 8.5
2246 doc closed 2007 Feb anonymous   2009 Oct   5 4 SQL docs for CREATE TABLE should include FOREIGN KEY syntax
2254 new closed 2007 Feb anonymous   2009 Oct   5 4 ATTACH support IF NOT ATTACHED statement
2271 doc closed 2007 Mar anonymous   2007 Mar   3 4 Can't use "limit" as column name
2275 code closed 2007 Mar anonymous   2007 Mar   2 4 Can't get where clause to recognize equality with generated value
2279 code closed 2007 Mar anonymous   2007 Mar   3 4 sqlite3_exec NULL pointer crash
2302 build closed 2007 Apr anonymous   2009 Oct anonymous 4 4 sqlite3 does not honor configure --disable-threads anymore
2305 doc closed 2007 Apr anonymous   2007 Apr   4 4 Function replace(X,Y,Z) doesn't exist ?
2310 code closed 2007 Apr anonymous   2009 Oct anonymous 4 4 Problem installing on AIX 5.3, ML5 after successful compile with xlc
2316 code closed 2007 Apr anonymous   2007 Apr   4 4 2 prepared statements on same database cause RC = 21
2317 code closed 2007 Apr anonymous   2007 Apr   4 4 Floats rendered to strings differently in WHERE and GROUP BY clauses.
2329 new closed 2007 Apr anonymous   2009 Oct   5 4 add a feature to .dump : partial dumps
2333 new closed 2007 May anonymous   2009 Oct   5 4 support memory mapped files
2336 warn closed 2007 May anonymous   2009 Oct   4 4 Compiler warnings on strcpy(), sprintf(), et al.
2355 code closed 2007 May anonymous   2007 May   3 4 Segfault with looooong sql string
2358 code closed 2007 May anonymous   2007 May   3 4 Incorrect index chosen for query
2362 code closed 2007 May anonymous   2007 May   4 4 Can't add a column with ALTER TABLE
2366 code closed 2007 May anonymous   2007 May   4 4 "make test" failures: pragma-1.15, pragma-1.16
2372 code closed 2007 May anonymous   2009 Oct   4 4 sqlite3TestLockingStyle not used if SQLITE_FIXED_LOCKING_STYLE defined
2373 new closed 2007 May anonymous   2009 Oct   4 4 "create table as explain <expr>" doesn't work
2375 doc closed 2007 May anonymous   2007 May   4 4 sqlite3_exec docs mentions sqlite3_reset
2385 code closed 2007 May anonymous   2007 May   5 4 Comment for SQLITE_VERSION_NUMBER has a typo (missing zero).
2386 doc closed 2007 May anonymous   2007 May   5 4 Suggestion for wiki speed comparisson: order by, group by, subselect
2392 code closed 2007 May anonymous   2009 Oct   4 4 Reduce MemPage and PgHdr struct sizes. Better page memory utilization.
2393 code closed 2007 May anonymous   2009 Oct   4 4 pragma cache_size not accurate when set to less than 10
2397 build closed 2007 Jun anonymous   2009 Oct   2 4 make install failed on Cygwin
2400 code closed 2007 Jun anonymous   2007 Jun   4 4 SELECT COUNT (*); returns 1 rather than 0.
2442 doc closed 2007 Jun anonymous   2008 Jun   1 4 mailing list link doesn't always exist in website header
2447 code closed 2007 Jun anonymous   2007 Jun   1 4 select where TABLENAME="TABLENAME" returns whole table.
2459 code closed 2007 Jun anonymous   2009 Oct   4 4 changes() not reporting correctly after "failed" multiline INSERT
2467 code closed 2007 Jun anonymous   2009 Oct   4 4 changes() not reporting correctly after DELETE FROM table
2474 new closed 2007 Jun anonymous   2009 Oct   5 4 Multiple-record comma-delineated INSERT command
2480 code closed 2007 Jun anonymous   2007 Aug   4 4 typo in faq.tcl
2482 code closed 2007 Jul anonymous   2007 Jul   3 4 Possible optimizer bug
2484 new closed 2007 Jul anonymous   2009 Oct   5 4 Support for RETURNING
2488 new closed 2007 Jul anonymous   2009 Oct   5 4 autosize on column output mode in sqlite3 program
2492 code closed 2007 Jul anonymous   2007 Jul   4 4 Incorrect protoype for function sqlite3_result_zeroblob
2495 code closed 2007 Jul anonymous   2007 Jul   4 4 standard C library Naming conflict - limits.h
2496 code closed 2007 Jul anonymous   2009 Oct   5 4 "No such column" error should include table information
2500 code closed 2007 Jul anonymous   2007 Jul   2 4 Possible memory leak on avr32 arch
2503 code closed 2007 Jul anonymous   2009 Oct   3 4 sqlite3PagerReleaseMemory does not decrement page count
2532 code closed 2007 Jul anonymous   2007 Jul   3 4 Endless loop in Parser?
2537 code closed 2007 Jul anonymous   2007 Jul   4 4 sqlite3_column_type() function problem.
2540 code closed 2007 Jul anonymous   2009 Oct   5 4 Display dlopen() errors for errors when loading modules on Unix system
2541 doc closed 2007 Jul anonymous   2007 Jul danielk1977 4 4 ALTER TABLE <foo> RENAME TO <bar> doesn't update (all) trigger schema
2564 event closed 2007 Aug anonymous   2007 Aug anonymous 4 4 in C:\windows\temp are 50 files like sqlite_fMyj88gwaTTNgUF and 0 kb
2587 build closed 2007 Aug anonymous   2009 Oct   3 4 Build problem when using the SQLITE_OMIT_FLOATING_POINT define.
2589 doc closed 2007 Aug anonymous   2007 Aug danielk1977 4 4 s/effected/affected/ in PRAGMA locking_mode
2594 code closed 2007 Aug anonymous   2007 Aug   5 4 ability to replace allocator
2595 doc closed 2007 Aug anonymous   2009 Oct   4 4 sqlite3_commit_hook doc typo
2604 new closed 2007 Aug anonymous   2009 Oct   4 4 CREATE VIRTUAL TABLE does not allow IF NOT EXISTS
2645 build closed 2007 Sep anonymous   2009 Oct   5 4 Conflict between tclConfig.sh and tclinstaller.tcl
2651 new closed 2007 Sep anonymous   2009 Oct   5 4 Add support for overriding home directory location
2653 code closed 2007 Sep anonymous   2009 Oct   3 4 Exclusive Transactions do not work with a Database File attached twice
2660 code closed 2007 Sep anonymous   2007 Sep   4 4 Spelling error in comment for SQLITE_CONSTRAINT
2668 code closed 2007 Sep anonymous   2007 Oct   3 4 Build failure due to syntax error under Cygwin
2670 doc closed 2007 Sep anonymous   2007 Oct   5 4 Document for EXPLAIN doesn't mention using EXPLAIN QUERY PLAN
2671 code closed 2007 Sep shess   2009 Oct shess 2 4 Fts field-based queries are not correctly case-insensitive.
2674 code closed 2007 Sep anonymous   2009 Oct   3 4 NFS fails without lock manager
2689 build closed 2007 Oct anonymous   2007 Oct   3 4 make test fails in 3.5.1 - unresolved externals in testfixture
2690 code closed 2007 Oct anonymous   2007 Oct   3 4 "PRAGMA synchronous = OFF;" is more dangerous than documented
2703 code closed 2007 Oct anonymous   2009 Oct   3 4 make test does not work with SQLITE_OMIT_FLOATING_POINT
2704 code closed 2007 Oct anonymous   2009 Oct   4 4 "make test" aborts before completion with SQLITE_OMIT_BLOB_LITERAL
2705 code closed 2007 Oct anonymous   2009 Oct   4 4 testfixture unresolved externals with SQLITE_OMIT_GET_TABLE
2706 warn closed 2007 Oct anonymous   2007 Oct danielk1977 4 4 make test aborts when built with SQLITE_OMIT_ATTACH
2712 code closed 2007 Oct anonymous   2007 Oct   5 4 Expose a function to change the journal filename location
2714 code closed 2007 Oct anonymous   2009 Oct drh 3 4 Shell cannot import large files greater than 2 GB [patch]
2723 new closed 2007 Oct anonymous   2007 Oct anonymous 5 4 After execution of SQL, the Data Returned should display the col.name
2727 build closed 2007 Oct anonymous   2009 Oct   4 4 building with -malign-double causes strange behavior
2728 code closed 2007 Oct anonymous   2009 Oct   4 4 Some indexes could contain pointers not the data
2748 warn closed 2007 Oct anonymous   2009 Oct   4 4 amalgamation: SQLITE_OMIT_ALTERTABLE warnings
2749 warn closed 2007 Oct anonymous   2009 Oct   3 4 SQLITE_OMIT_FLOATING_POINT, int constants too large
2760 new closed 2007 Nov anonymous   2009 Oct   5 4 request: sqlite3_unlink() to delete db files.
2763 build closed 2007 Nov anonymous   2009 Oct   4 4 AIX build failure due to explicit _XOPEN_SOURCE definition
2775 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 4 Low-memory SEGV from sqlite3CodeRowTrigger()
2786 code closed 2007 Nov anonymous   2009 Jan   4 4 sqlite3.pc does not mention -lpthread when used with --static flag
2798 build closed 2007 Nov anonymous   2007 Nov   3 4 Wrong nm used when cross-compiling
2812 new closed 2007 Nov anonymous   2007 Dec   3 4 SQLITE_SECURE_DELETE overwrites with 0, but should use random data
2818 code closed 2007 Dec anonymous   2007 Dec   2 4 Comparison of 8 bytes integer numbers is truncated
2821 new closed 2007 Dec anonymous   2009 Oct   3 4 hashtable indicies
2831 new closed 2007 Dec anonymous   2009 Oct   3 4 alter view
2847 new closed 2007 Dec anonymous   2008 Jun   5 4 Include major, minor, and patch version numbers in sqlite.h
2848 code closed 2007 Dec anonymous   2007 Dec   4 4 windows CRLF is incorrectly handled by .dump
2872 code closed 2008 Jan anonymous   2009 Oct   4 4 Some table scan operations could use an index for better data density
2884 new closed 2008 Jan anonymous   2009 Oct   4 4 Way to find out limits
2885 code closed 2008 Jan anonymous   2009 Oct   4 4 (minor) fulltest failures
2888 code closed 2008 Jan anonymous   2008 Jan   3 4 statement not commited
2899 code closed 2008 Jan anonymous   2009 Oct   4 4 sqlite3_reset() after exec() takes > 100 ms to complete
2900 code closed 2008 Jan anonymous   2008 Jan   3 4 Can't ESCAPE in GLOB
2912 new closed 2008 Jan anonymous   2009 Oct   5 4 merge join
2919 code closed 2008 Feb anonymous   2009 Oct   3 4 Shell only shows headers for first statement
2926 code closed 2008 Feb anonymous   2009 Oct   5 4 set the minimum limit of pagesize even lower
2928 doc closed 2008 Feb anonymous   2008 Jun   5 4 Incorrect C example on "SQLite In 5 Minutes Or Less"
2932 code closed 2008 Feb anonymous   2009 Oct   4 4 sqlite3_get_table sets errno=2
2933 new closed 2008 Feb anonymous   2009 Oct   5 4 shell: negative .width could right-justify columns
2934 code closed 2008 Feb anonymous   2008 Feb   3 4 The optional OFFSET keyword isn't right implemented.
2941 code closed 2008 Feb anonymous   2009 Oct   5 4 expose sqlite3VdbeMemCopy, sqlite3MemCompare, sqlite3VdbeMemRelease
2946 new closed 2008 Feb anonymous   2009 Oct   4 4 16bit version of sqlite3_bind_parameter_index
2947 code closed 2008 Feb anonymous   2008 Feb   4 4 WIN32: .explain ON followed by .show crashes sqlite3
2967 code closed 2008 Feb anonymous   2008 Feb danielk1977 3 4 order of columns in index substantially affects the execution time
2968 doc closed 2008 Feb anonymous   2008 Mar   5 4 Documentation typo
2986 doc closed 2008 Mar anonymous   2008 Mar   4 4 Documentation Error
2988 new closed 2008 Mar aswift   2009 Dec drh 3 4 Add support for configuring limits at run-time and per-connection
2995 code closed 2008 Mar anonymous   2008 Mar   4 4 excessive calls to Sqlite3Error
2997 code closed 2008 Mar anonymous   2008 Mar   1 4 cann't execute "select count(*) ..." operator in a TRANSACTION
3002 new closed 2008 Mar anonymous   2008 Apr anonymous 4 4 Memory leak within sqlite3_open_v32()
3014 new closed 2008 Mar anonymous   2008 Apr chw 4 4 SQLite3 Don't support charIndex and IndexOf methods
3035 todo closed 2008 Apr anonymous   2008 Apr   1 4 Trigger with RAISE ROLLBACK
3042 new closed 2008 Apr anonymous   2009 Oct   4 4 use current work directory as home when environment HOME not defined
3043 code closed 2008 Apr anonymous   2008 Apr   1 4 assertion fails in 32 bit testfixture on little-endian platform
3045 doc closed 2008 Apr anonymous   2009 Oct drh 4 4 Various typo errors in lang.in
3046 warn closed 2008 Apr anonymous   2009 Oct   4 4 semmingly false errors reported by crash tests on solaris
3061 code closed 2008 Apr anonymous   2009 Oct   3 4 sqlite can't import from STDIN on windows if newlines exist
3064 code closed 2008 Apr anonymous   2008 Apr   3 4 String buffer used after memory freed
3065 code closed 2008 Apr anonymous   2008 Apr   4 4 redundant code can be removed
3066 code closed 2008 Apr anonymous   2008 Apr   5 4 vdbeaux needs version control comment
3067 code closed 2008 Apr anonymous   2008 Apr   5 4 Useless compiler directive #if SQLITE_MAX_COLUMN
3068 build closed 2008 Apr anonymous   2009 Oct   4 4 configure: BEXE incorrect for cygwin -> linux cross compile
3072 doc closed 2008 Apr anonymous   2008 Apr   5 4 F17868 incorrect
3077 build closed 2008 Apr anonymous   2008 Sep   4 4 sqlite pkgconfig doesn't provide full version string
3080 code closed 2008 Apr anonymous   2008 Apr   2 4 crash in sqlite3VtabSync if virtual table was dropped during transacti
3090 code closed 2008 Apr anonymous   2008 May drh 5 4 Proposition for sqlite3GetVarint() optimization
3097 code closed 2008 May anonymous   2008 May   2 4 intptr potentially wrong (amalgamation)
3098 new closed 2008 May anonymous   2009 Oct   5 4 Accept "INSERT IGNORE" for MySQL compatibility
3108 code closed 2008 May anonymous   2009 Oct   5 4 Code could be inefficient
3109 code closed 2008 May anonymous   2009 Oct   4 4 ROLLBACK doesn't halt properly
3112 new closed 2008 May anonymous   2009 Oct   5 4 Accept "AUTO_INCREMENT" attribute for MySQL compatibility
3113 new closed 2008 May anonymous   2009 Oct   5 4 Accept "LAST_INSERT_ID()" function for MySQL compatibility
3120 code closed 2008 May anonymous   2008 May   4 4 All the os_.c source files are missing version tags
3131 code closed 2008 May anonymous func 2009 Oct   4 4 PRAGMA encoding doesnt return encoding compiled with SQLITE_OMIT_UTF16
3138 doc closed 2008 May anonymous   2008 Jun   5 4 global cache size
3141 code closed 2008 May anonymous   2009 Oct   4 4 Feature Request: create_function_v2 that takes destructor
3144 code closed 2008 May anonymous   2009 Oct   5 4 F10336 is not true
3145 new closed 2008 May anonymous   2009 Oct   5 4 .CREATE command for sqlite3.exe
3151 code closed 2008 May shane   2008 Jun shane 4 4 winAccess return undefined on invalid flags with assertions disabled
3152 doc closed 2008 May anonymous   2009 Oct mihailim 5 4 Minor SQL documentation improvement suggestions
3153 code closed 2008 May anonymous   2009 Oct   4 4 Earlier detection of corrupt databases would be an advantage
3154 code closed 2008 May anonymous   2009 Oct   3 4 SELECT * FROM Table ON Column=1 runs, but produces all rows
3157 code closed 2008 Jun anonymous   2008 Jun   4 4 fulltest warning --- vacuum3.test did not close all files: 1
3158 code closed 2008 Jun anonymous   2008 Jun   4 4 Apparently bogus assertion in sqlite3ValueText
3159 code closed 2008 Jun anonymous   2009 Oct   1 4 Could not use sqlite3_open( ":memory:", &db); on FreeBSD 6.3
3160 new closed 2008 Jun anonymous   2009 Oct   4 4 publisch the progress handler for the virtual table hander
3161 build closed 2008 Jun anonymous   2009 Oct   2 4 Solaris 10 egrep is not GNU egrep, so make fails
3164 code closed 2008 Jun anonymous   2008 Jun danielk1977 4 4 Either a documentation error or a code probelm
3169 code closed 2008 Jun anonymous   2009 Oct   4 4 sqlite3_exec callback function can't identify table name
3170 doc closed 2008 Jun anonymous   2009 Oct   5 4 typo in locking documentation
3178 new closed 2008 Jun anonymous   2009 Oct   5 4 A bit more built-in functions
3183 doc closed 2008 Jun anonymous   2009 Oct   4 4 Documentation clarification request: ROLLBACK & step/reset/finalize
3188 code closed 2008 Jun anonymous   2008 Jun   1 4 Can't cast results from external functions
3206 new closed 2008 Jul anonymous   2009 Oct   5 4 Add additional columns to several schema pragmas
3222 new closed 2008 Jul anonymous   2009 Oct   3 4 UPDATE with joined tables
3231 code closed 2008 Jul anonymous   2008 Jul   4 4 numeric strings managed as integers in requests
3233 code closed 2008 Jul anonymous   2008 Jul   5 4 There's no way to format wide character strings using sqlite3_*printf
3234 doc closed 2008 Jul anonymous   2008 Jul   4 4 Error in doc lang_createtrigger.html#instead_of_trigger
3240 new closed 2008 Jul anonymous   2008 Jul   4 4 primary key column must not be null according to SQL 92 standard
3241 build closed 2008 Jul anonymous   2008 Jul   3 4 Fix Makefile.in TCC setting so includes from current sources are first
3242 build closed 2008 Jul anonymous   2008 Aug   5 4 make it easier for packagers to override where the .pc file goes
3246 code closed 2008 Jul anonymous   2008 Jul   3 4 Various memory routines should be using size_t
3247 code closed 2008 Jul anonymous   2009 Oct   3 4 failed malloc
3252 doc closed 2008 Jul anonymous   2008 Jul   4 4 SQLITE_CONFIG_MEMSTATUS documented with unknown 'boolean' type
3254 code closed 2008 Jul anonymous   2009 Dec   4 4 sqlite3_config() suggestions
3258 new closed 2008 Jul anonymous   2009 Oct   5 4 csv import
3268 code closed 2008 Aug anonymous   2009 Oct drh 5 4 Add additonal flag(s) to sqlite3_open_v2()
3272 new closed 2008 Aug anonymous   2008 Aug   4 4 Impossible to insert an empty row in an sqlite database
3280 doc closed 2008 Aug anonymous   2009 Oct   5 4 explain query plan not documented
3291 code closed 2008 Aug anonymous   2009 Oct   3 4 Speed Test 1-4 add "PRAGMA synchronous=OFF" to speedn-1.0 setup
3295 code closed 2008 Aug anonymous   2008 Aug   4 4 unspecified result after group by
3305 code closed 2008 Aug anonymous   2009 Sep   5 4 Suggested improvement for sqlite30OsDlOpen failure
3306 doc closed 2008 Aug anonymous   2009 Oct   4 4 Doc for VFS xRandomness needs update, unixRandomness returns wrong val
3313 build closed 2008 Aug anonymous   2008 Aug   3 4 Compiling for VxWorks
3321 new closed 2008 Aug anonymous   2009 Oct   5 4 Investigate Transactional NTFS on Vista
3342 new closed 2008 Aug aswift   2009 Oct drh 3 4 Allow manual configuration of locking style via sqlite3_file_control
3348 doc closed 2008 Sep anonymous   2008 Sep   4 4 null primary key
3352 build closed 2008 Sep anonymous   2009 Oct   4 4 Makefile does not install the manpage
3364 code closed 2008 Sep anonymous   2009 Oct   4 4 compiler warnings about potentially uninitialized variables
3366 secure closed 2008 Sep anonymous   2008 Sep   4 4 I want to register
3367 doc closed 2008 Sep anonymous   2008 Sep a.rottmann 5 4 Data Base Samples downloads?
3374 code closed 2008 Sep anonymous   2009 Oct   5 4 insert several times into the same column doesn't fail
3390 code closed 2008 Sep anonymous   2008 Sep   3 4 sqlite crash on select rowid in sub-select
3391 code closed 2008 Sep anonymous   2009 Oct   3 4 Clang static analyzer finds several warnings
3399 code closed 2008 Sep anonymous   2008 Sep   4 4 Bad C function declarations
3400 event closed 2008 Sep anonymous   2009 Oct   1 4 Core error line ***glibc detected free() *** invalid next size (fast)
3403 new closed 2008 Sep anonymous   2009 Oct   4 4 Don't create new database by default when file not found
3409 build closed 2008 Oct aswift   2008 Oct drh 4 4 bind-9.2 leaks fd with larger SQLITE_MAX_VARIABLE_NUMBER
3410 code closed 2008 Oct anonymous   2009 Oct   3 4 "ON CONFLICT IGNORE" not completely ignored -- sqlite_sequence updated
3413 code closed 2008 Oct anonymous   2008 Oct drh 2 4 strftime("%w", "whatever") returns wrong weekday number
3426 code closed 2008 Oct anonymous   2008 Oct   1 4 newline in query causes all field types to appear as DBI_TYPE_STRING
3437 code closed 2008 Oct anonymous   2008 Oct   3 4 subquery not working
3445 new closed 2008 Oct anonymous   2009 Oct   5 4 No read-only attached database support
3449 build closed 2008 Oct anonymous   2009 Jan   4 4 configure fails to detect TCL
3451 code closed 2008 Oct anonymous   2008 Oct   3 4 Syntax error creating a trigger using "UPDATE ON (column) OF table"
3458 code closed 2008 Oct anonymous   2008 Oct   4 4 PRAGMA show_table erronous info
3471 code closed 2008 Oct anonymous   2009 Oct   3 4 SQLite does not detect truncated database files well
3487 new closed 2008 Nov anonymous   2009 Oct   3 4 JOIN USING (rowid)?
3500 doc closed 2008 Nov anonymous   2008 Nov   5 4 documentation typo at SQLITE_OMIT_TRIGGER
3504 code closed 2008 Nov anonymous   2008 Nov   5 4 pragma table_info returns quoted text
3524 doc closed 2008 Dec anonymous   2009 Oct   5 4 Wish item: examples in documentation
3528 todo closed 2008 Dec anonymous   2008 Dec   1 4 Crashed ssh session on Xen causes disk I/O error on SQLite query
3531 code closed 2008 Dec anonymous   2009 Oct   3 4 Command line client hides value types
3534 new closed 2008 Dec anonymous   2009 Oct   4 4 sqlite3_stmt_status api include row change counters.
3552 build closed 2008 Dec anonymous   2009 Oct   3 4 shell.exe does not build correctly on windows/ce 5.0
3557 new closed 2008 Dec anonymous   2008 Dec   1 4 GUID primary keys
3558 code closed 2008 Dec anonymous   2008 Dec   4 4 syntax error : 'bad suffix on number'
3559 doc closed 2008 Dec anonymous   2008 Dec   4 4 Typo in tokenizer specification in ext/fts3/README.tokenizers
3563 new closed 2009 Jan anonymous   2009 Oct   5 4 AUTOINCREMENT FROM i BY j enhancement
3565 doc closed 2009 Jan anonymous   2009 Oct   5 4 Unsupported feature addiction
3567 doc closed 2009 Jan anonymous   2009 Jan   5 4 sqlite3_create_function invariant H16124 reports incorrect upper bound
3568 code closed 2009 Jan anonymous   2009 Jan   4 4 sqlite3shell.h needs "extern "C" protection for c++ code
3569 code closed 2009 Jan anonymous   2009 Oct   3 4 Should Shared-Cache Mode recognize busy timeouts?
3571 code closed 2009 Jan sdwilsh   2009 Jan   3 4 Crash when compiling SQLite with PGO
3573 new closed 2009 Jan anonymous   2009 Jan   3 4 journal_mode = truncate calls unlink(journal_file)
3576 doc closed 2009 Jan anonymous   2009 Jan   4 4 Not a bug
3582 new closed 2009 Jan anonymous   2009 Jan   5 4 ALTER TABLE and FOREIGN KEY support
3606 code closed 2009 Jan anonymous   2009 Jan anonymous 1 4 page cache unmetch times bigger than read() called times
3634 new closed 2009 Feb anonymous   2009 Oct   3 4 imputed column type of functions is not set
3635 build closed 2009 Feb anonymous build 2009 Oct   4 4 configure should define SQLITE_ENABLE_COLUMN_METADATA by default
3652 new closed 2009 Feb anonymous   2009 Oct   5 4 possible future compability problem
3654 doc closed 2009 Feb anonymous   2009 Oct   4 4 INSTALL doc should mention libreadline5-dev
3672 code closed 2009 Feb anonymous front 2009 Oct   4 4 Inconsistent column names returned
3683 code closed 2009 Feb anonymous ext 2009 Nov anonymous 3 4 Broken Query with FTS3
3686 build closed 2009 Feb anonymous build 2009 Feb   4 4 @RELEASE@ isn't set in sqlite3.pc in amalgamation tarball
3689 code closed 2009 Feb anonymous   2009 Mar   3 4 amalgamation not building with SQLITE_OMIT_VIRTUALTABLE gcc 4.1.2
3690 new closed 2009 Feb anonymous func 2009 Feb shane 5 4 UnEscape function should be there in SQLite
3693 new closed 2009 Feb anonymous   2009 Oct   4 4 index_info
3700 doc closed 2009 Mar anonymous   2009 Mar   5 4 mispelling in .../sqlite-3_6_11-docs/lang_indexedby.html
3709 new closed 2009 Mar anonymous back 2009 Sep   5 4 Page locking to improve concurrency for application server
3713 code closed 2009 Mar anonymous   2009 Mar   4 4 ATTACHED Dbase Speed Variation
3715 code closed 2009 Mar anonymous front 2009 Mar   5 4 How to query table from an encrypted sqlite file?
3719 code closed 2009 Mar anonymous   2009 Mar danielk1977 3 4 "Create Table As" fails on tables with a specific type of definition.
3721 new closed 2009 Mar anonymous   2009 Oct   5 4 CAST with custom data types is not very useful
3726 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_COMPOUND_SELECT compile error
3727 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_XFER_OPT compile error
3728 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_INCRBLOB compile error
3729 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_AUTOVACUUM compile error
3750 new closed 2009 Mar anonymous   2009 Jul   5 4 Use other separator than space for matches in offsets function of FTS3
3751 code closed 2009 Mar mlcreech   2009 Mar danielk1977 2 4 I/O error using journal_mode = TRUNCATE
3755 code closed 2009 Mar anonymous   2009 Mar   1 4 out-of-memory trying to fetch a column value in sqlite3
3764 code closed 2009 Mar anonymous ext 2009 Oct   3 4 contrib: extension-functions.c
3767 new closed 2009 Apr anonymous front 2009 Oct   3 4 Significant GROUP BY speed-up
3768 code closed 2009 Apr anonymous front 2009 Apr   5 4 No syntax error when FROM is mistyped
3779 code closed 2009 Apr anonymous cli 2009 Oct   4 4 sqlite3 .dump sqlite_sequence table details out of sequence for .read
3782 new closed 2009 Apr anonymous front 2009 Oct   5 4 parse ADD CONSTRAINT in ALTER TABLE statements
3787 doc closed 2009 Apr anonymous   2009 Apr   5 4 Funny "ah" in http://www.sqlite.org/limits.html
3790 code closed 2009 Apr anonymous build 2009 Apr   3 4 Define SQLITE_OMIT_TRIGGER
3792 secure closed 2009 Apr anonymous cli 2009 Sep   3 4 HTML mode does not quote special characters in headers
3799 doc closed 2009 Apr anonymous front 2009 Oct   5 4 Comment is incomplete in where.c
3802 code closed 2009 Apr anonymous test 2009 Apr   4 4 bindxfer.test fails compiled with SQLITE_OMIT_DEPRECATED
3812 code closed 2009 Apr anonymous cli 2009 Oct   1 4 Quotes appears around data when importing exported csv file
3817 new closed 2009 Apr anonymous front 2009 Oct   5 4 Function to duplicate prepared statements
3822 website closed 2009 Apr anonymous   2009 Apr drh 5 4 Sitemap says "browse bug beports"
3829 code closed 2009 Apr anonymous front 2009 Oct   4 4 invalid join types
3835 code closed 2009 May anonymous front 2009 May   2 4 "having max()" causes non-aligned pointers being freed
3846 code closed 2009 May anonymous front 2009 Jul   4 4 join operators without join
3847 warn closed 2009 May anonymous vfs 2009 May   4 4 Warning on Mac OSX
3849 doc closed 2009 May anonymous func 2009 Oct   5 4 Mispelling in util.c
3850 new closed 2009 May anonymous test 2009 Oct   5 4 additional test
3851 code closed 2009 May anonymous   2009 May   2 4 Table names no longer enclosed in brackets
3852 doc closed 2009 May anonymous   2009 Oct   5 4 H35230 requirement refers itself
3854 code closed 2009 May anonymous tcl 2009 May   4 4 Tcl Interface does not recognize dbcmd in "sqlite 3 dbcmd name"
3866 code closed 2009 May anonymous ext 2009 May anonymous 4 4 Make ext/async/sqlite3async.h includable to C++
3881 code closed 2009 May anonymous back 2009 Sep   3 4 zeroblob function causes memory problems
3898 todo closed 2009 Jun anonymous front 2009 Jun   3 4 Expressions are not being converted as expected.
3900 code closed 2009 Jun anonymous back 2009 Jun   3 4 Execution of sqlite3_mutex_leave without prior sqlite3_mutex_enter
3906 code closed 2009 Jun anonymous cli 2009 Oct   4 4 patch for mode insert in CLI to preserve number-like strings
3915 code closed 2009 Jun anonymous back 2009 Jun   4 4 assert statement repeated in btree.c
3916 code closed 2009 Jun anonymous back 2009 Jun   4 4 unneed assignment in build.c
3917 event closed 2009 Jun anonymous   2009 Oct   1 4 Illegal instruction (core dumped)
3921 xplatform closed 2009 Jun anonymous vfs 2009 Oct   1 4 Sqlite don't work for palm os
3926 code closed 2009 Jun anonymous back 2009 Oct   4 4 invalid error message
3927 code closed 2009 Jun anonymous   2009 Jun   4 4 incorrect syntax error message on "select * from Group" query
3943 build closed 2009 Jul anonymous build 2009 Oct   4 4 Problems when linking a not-threaded program to a shared sqlite
3946 code closed 2009 Jul anonymous back 2009 Oct   3 4 Error return from VFS xUnlock ignored
3952 new closed 2009 Jul anonymous   2009 Jul   5 4 Feature request: sqlite3_create_function_v2()
3957 code closed 2009 Jul anonymous front 2009 Jul   4 4 CONSTRAINT PRIMARY KEY don't respect the given name
3970 code closed 2009 Jul anonymous ext 2009 Jul   5 4 Rtree gives poor error message with column named index
3971 code closed 2009 Jul anonymous back 2009 Oct   4 4 TRACE error in btree.c when page is null
3976 code closed 2009 Jul anonymous test 2009 Jul danielk1977 4 4 savepoint does not handle SQLITE_OMIT_INCRBLOB properly
3985 code closed 2009 Jul anonymous test 2009 Jul   4 4 capi3c.test does not test for SQLITE_OMIT_UTF16
4002 new closed 2009 Jul anonymous back 2009 Oct   5 4 PRAGMA to force all tables to use AUTOINCREMENT behavior
4005 code closed 2009 Jul anonymous   2009 Oct   3 4 sqlite3AtoF() returns incorrect value for "7.4576373809917618"
4013 doc closed 2009 Aug anonymous tcl 2009 Aug   5 4 http://www.sqlite.org/tclsqlite.html#profile is not defined
4014 new closed 2009 Aug anonymous front 2009 Aug   4 4 Special Caracter '\' doesn't work!
4015 code closed 2009 Aug anonymous test 2009 Aug   4 4 test1.c needs to test for SQLITE_OMIT_DEPRECATED
4020 code closed 2009 Aug anonymous   2009 Oct   5 4 sqlite3FindFunction() - too long loop
4021 website closed 2009 Aug anonymous   2009 Sep   5 4 List of well know users
4031 doc closed 2009 Aug anonymous   2009 Aug   4 4 Document behavoir of SQLITE_OMIT_INCRBLOB compiler flag
4034 code closed 2009 Aug anonymous front 2009 Sep   4 4 EXPLAIN changes settings
4038 doc closed 2009 Aug anonymous   2009 Sep   4 4 Documentation error
4040 code closed 2009 Sep anonymous front 2009 Oct   3 4 sqlite3_bind_text( , , NULL, 0, ) binds null not the empty string
4046 code closed 2009 Dec anonymous cli 2009 Dec   4 4 Command-line id displayed incorrectly
2 new closed 2002 Mar drh CodeGen 2002 May   2 3 Add support for TABLE.* in a query
4 new closed 2002 Mar persicom Shell 2002 May   2 3 Change prompt of 'sqlite' query tool.
9 new closed 2002 Apr anonymous BTree 2002 Sep   1 3 platform-independent db files
24 code closed 2002 Apr anonymous   2002 Apr drh 4 3 Make "update ... where ..." fail if where clause is false.
36 code closed 2002 May anonymous   2002 May   4 3 drop table doesn't clean up database
37 code closed 2002 May anonymous   2004 Nov   3 3 can't open dbfile by apache process under mod_perl env.
40 code closed 2002 May drh   2002 Sep   3 3 Compiler warnings on RedHat 7.2
44 code closed 2002 May anonymous   2002 Sep   3 3 UNIQUE constraint (incorrectly) applies to NULL
51 doc closed 2002 May danielk1977 CodeGen 2002 May danielk1977 5 3 Triggers problem with INTEGER PRIMARY KEY
55 new closed 2002 Jun anonymous   2009 Oct drh 5 3 instead of triggers for inserts (updates) on regular tablesxx
63 new closed 2002 Jun drh CodeGen 2002 Sep   3 3 Add optimizations for "WHERE rowid IN (SELECT...)"
76 code closed 2002 Jun anonymous   2002 Sep   1 3 sqlite corruption possibly relating to drop of index
91 todo closed 2002 Jul anonymous   2002 Sep   4 3 A command-line program for windows
93 new closed 2002 Jul anonymous   2008 Jun   3 3 Can't open database when TEMP environment variable is not defined well
101 new closed 2002 Jul anonymous   2009 Mar   3 3 builtin functions do not work properly with LIMIT clause
111 doc closed 2002 Jul anonymous   2002 Sep   1 3 2.6.1 does not permit SELECT within TRANSACTION whereas 2.5.5 did
114 code closed 2002 Jul anonymous Unknown 2002 Sep   2 3 Concurrency problem in sqlite_open when automatic upgrading
122 new closed 2002 Jul anonymous   2002 Jul   3 3 BLOB support needs only an escape_string() function.
123 new closed 2002 Jul anonymous   2002 Jul   3 3 Would like Query type info
139 new closed 2002 Aug anonymous Pager 2008 Jun   3 3 Named transactions are misleading as documented
141 code closed 2002 Aug anonymous Unknown 2002 Aug   1 3 Using the incorrect format inhibits record update
143 code closed 2002 Aug anonymous Unknown 2002 Aug anonymous 1 3 order by and null columns
144 new closed 2002 Aug anonymous Unknown 2002 Aug   4 3 Read/Write Locks under Windows NT/2000/XP (simul. access)
148 code closed 2002 Sep anonymous Unknown 2002 Sep anonymous 3 3 sqlHashFind() segfaults in a created function
154 code closed 2002 Sep drh Pager 2009 Oct drh 3 3 Prohibit links on database files.
175 new closed 2002 Oct anonymous Pager 2009 Oct   5 3 journal file should be kept open
184 new closed 2002 Oct mike   2009 Oct drh 5 3 auto update mechanism for CVS
196 code closed 2002 Nov anonymous BTree 2003 Jul   4 3 there are the same record in a table,why?
236 new closed 2003 Jan anonymous   2009 Oct   3 3 Add RENAME TABLE - will be easier to work around missing ALTER TABLE
261 code closed 2003 Mar anonymous Unknown 2003 Jul   2 3 Non Callback Finalize Bug
265 new closed 2003 Mar anonymous Parser 2003 Mar drh 2 3 SQLITE does not like prefixed columns
268 new closed 2003 Mar anonymous Parser 2009 Oct   1 3 columns of subselects containing joins are not recognized
274 code closed 2003 Mar anonymous Unknown 2003 Apr   2 3 bug in sqlite_free_table
278 doc closed 2003 Apr anonymous Unknown 2009 Oct mihailim 3 3 Possible documentation bug in "expression" section.
279 new closed 2003 Apr anonymous   2008 Jun   3 3 WinCE port of CVS version as of 02 Apr 2003
286 doc closed 2003 Apr anonymous   2009 Oct   3 3 Tcl command documentation does not explain (minus) options.
301 code closed 2003 Apr anonymous Unknown 2009 Oct   2 3 Can't acquire lock for database on Mac OS X AppleShare volume
304 code closed 2003 May anonymous Shell 2003 May   3 3 DELETE on read-only db reporting error inconsistently
312 build closed 2003 May anonymous Shell 2008 Jun   1 3 libreadline.so.0.0 causes unidentified token error
320 doc closed 2003 May anonymous   2003 Jun jplyon 5 3 PRAGMA documentation should include numeric values of settings
321 new closed 2003 May anonymous   2008 Jun   4 3 Make SQLITE_ISO8859 and SQLITE_UTF8 overridable by compiler define
325 code closed 2003 May anonymous Parser 2003 May   3 3 Memory Leak with a cancelled sqlite_exec() using a callback routine
329 code closed 2003 May anonymous Unknown 2003 May   3 3 sqlite_get_table() returns 1 row when there should be none
339 build closed 2003 Jun anonymous Shell 2008 Jun   2 3 readline headers not found (because of readline/ prefix)
348 warn closed 2003 Jun anonymous Unknown 2009 Oct drh 4 3 SQLite and GCC using enhanced warning levels
366 new closed 2003 Jun anonymous Unknown 2008 Jun drh 4 3 Functions sqlite_(en/de)code_binary() not in sqlite.h
376 code closed 2003 Jul anonymous BTree 2003 Aug   2 3 btree-1.1.1...../src/btree.c:2687: failed assertion `pPage->isInit'
381 new closed 2003 Jul anonymous   2009 Oct   1 3 Support for DJGPP and DOS
391 warn closed 2003 Jul anonymous   2009 Oct   4 3 signed/unsiged compiler warnings from Borland C++6
398 build closed 2003 Jul anonymous Unknown 2009 Oct   3 3 configure.ac is wrong for Windows Mingw/Msys
399 event closed 2003 Jul anonymous   2003 Jul drh 3 3 SELECT COUNT(*) FROM TABLE
402 code closed 2003 Jul anonymous Shell 2005 Jan anonymous 2 3 linebreake
404 new closed 2003 Jul anonymous   2009 Oct   3 3 new C API: sqlite_get_table_with_types with type information
415 code closed 2003 Jul anonymous VDBE 2003 Dec   3 3 Stringify can loose digits in doubles
420 new closed 2003 Jul anonymous VDBE 2009 Oct   3 3 Not abort transaction when callback is cancelled
424 new closed 2003 Aug anonymous Shell 2009 Oct   4 3 Provide access to internal function _all_whitespace()
425 new closed 2003 Aug anonymous VDBE 2009 Oct   5 3 Datetime enhancements: fractional seconds, addmonth
426 code closed 2003 Aug anonymous VDBE 2003 Dec   2 3 TIME produces JDs off by 12 hours
437 code closed 2003 Aug anonymous Unknown 2003 Aug   3 3 Wrong order for results of SELECT
440 code closed 2003 Sep anonymous   2003 Dec drh 3 3 dayofmonth("now") returns one more than actual day
443 new closed 2003 Sep anonymous Parser 2005 Jan anonymous 3 3 LIKE ... should support ESCAPE as per SQL spec
446 doc closed 2003 Sep anonymous   2009 Oct drh 3 3 sqlite_compile can return no virtual machine with code SQLITE_OK
448 new closed 2003 Sep anonymous   2009 Oct drh 3 3 a general bug-fix and dos support without lfn
465 new closed 2003 Sep anonymous   2009 Oct   4 3 data types should be implemented as formated strings
470 code closed 2003 Oct anonymous Unknown 2005 Jan   2 3 Unnecessary 31-character name limit on Mac
473 build closed 2003 Oct anonymous   2009 Oct drh 3 3 makefile's target_source fails to create opcodes.c
476 doc closed 2003 Oct anonymous   2003 Nov   3 3 Define for omitting time and date functions
478 new closed 2003 Oct anonymous Parser 2009 Oct drh 1 3 select into is lacking
479 new closed 2003 Oct anonymous Parser 2009 Oct drh 4 3 Sequences
483 build closed 2003 Oct anonymous Shell 2009 Oct   2 3 history.h from readline library not checked for
490 new closed 2003 Nov anonymous VDBE 2009 Oct xdong 4 3 a few api improvements for recordset operations
493 event closed 2003 Nov anonymous Unknown 2008 Jun   3 3 Problem compiling sqlite
497 new closed 2003 Nov anonymous Unknown 2003 Nov   3 3 not able to escape quotes
499 code closed 2003 Nov anonymous Unknown 2004 Feb   1 3 dot in table name and in column name makes full_column_names unusable
509 event closed 2003 Nov anonymous   2009 Oct   5 3 SQLite on Pocket PC - question - how to do that step by step?
513 code closed 2003 Dec anonymous   2003 Dec   2 3 C++-style comments prevent compilation
527 code closed 2003 Dec anonymous Shell 2004 Feb   3 3 Sqlite shell: lack of checks
532 code closed 2003 Dec anonymous Parser 2003 Dec   2 3 crashes on gigantic query
538 new closed 2003 Dec anonymous   2008 Jun   4 3 Different warnings in windows
546 code closed 2004 Jan anonymous Pager 2004 Jan   3 3 (Program received signal SIGSEGV) when sqlite_open()
562 code closed 2004 Jan anonymous Unknown 2004 Jan   2 3 System needs to rename duplicate named columns.
563 new closed 2004 Jan anonymous Parser 2008 Jun   4 3 Support for autoincrement type "SERIAL" (from PostgreSQL)
572 new closed 2004 Jan anonymous Unknown 2009 Oct drh 3 3 sqlite 2.8.11 port to djgpp
575 code closed 2004 Jan anonymous VDBE 2009 Oct drh 3 3 pragma (default_)temp_store implementations seems incomplete
580 code closed 2004 Jan anonymous VDBE 2004 Jan   2 3 Incorrect Select when specifying same field value as column name
608 code closed 2004 Feb anonymous   2009 Oct   3 3 Problem with "pragma show_datatypes = on" and busy timeout
611 new closed 2004 Feb anonymous VDBE 2009 Oct   1 3 Remove giant SWITCH statement in VM for better portability
618 code closed 2004 Feb anonymous Unknown 2004 Feb   3 3 fails test btree-1.1.1
621 todo closed 2004 Feb anonymous Unknown 2009 Oct anonymous 3 3 Assorted errors running test's on MAC OSX
622 doc closed 2004 Feb anonymous   2009 Oct mihailim 1 3 Should mention PRAGMA table_info() in FAQ
627 code closed 2004 Feb anonymous   2009 Oct   3 3 sqliteRunVacuum returning wrong code?
628 code closed 2004 Feb anonymous Pager 2004 Feb   1 3 Assertion failure in syncJournal
629 code closed 2004 Feb anonymous Parser 2004 Feb   3 3 Variable used without having been initialized
631 code closed 2004 Feb anonymous Shell 2004 Feb   2 3 command line SQL paramater doesn't work on windows pre-compiled binary
644 todo closed 2004 Mar anonymous Unknown 2008 Jun   1 3 How do you fix "SQL error: database disk image is malformed"
673 new closed 2004 Mar anonymous Shell 2009 Oct   4 3 Format .dump nicer (patch)
677 code closed 2004 Mar anonymous   2004 Mar   2 3 Failure to convert to FP on division involving a constant
685 code closed 2004 Apr anonymous CodeGen 2009 Oct   1 3 SELECT from a VIEW with GROUP BY
695 code closed 2004 Apr anonymous   2005 Jan   3 3 CREATE INDEX and dbl-quoted index names
698 code closed 2004 Apr anonymous Unknown 2009 Oct   1 3 .mode list - not going to next line
700 code closed 2004 Apr anonymous VDBE 2009 Oct   2 3 Solaris-sparc segfaults on sum()
701 todo closed 2004 Apr anonymous   2004 Apr drh 3 3 INSERT FAILED?
702 code closed 2004 Apr anonymous   2004 Jul   3 3 Bug in sorting: some strings sort in the middle of numerical values
707 new closed 2004 Apr anonymous Unknown 2008 Jun drh 3 3 how to use internal functions?
711 new closed 2004 Apr anonymous   2009 Oct drh 3 3 Provide a callback function to verify values before insert or update
712 new closed 2004 Apr anonymous Unknown 2009 Oct drh 3 3 Allow temporary databases to be created in specified folder
714 new closed 2004 Apr anonymous Unknown 2009 Oct drh 3 3 Change sqlite_decode_binary to return buffer size
715 code closed 2004 Apr anonymous Unknown 2004 Apr   2 3 reference counted file locking attempts to unlock on different thread
719 code closed 2004 May anonymous   2004 May   2 3 index_list not reporting my indeces
727 event closed 2004 May anonymous   2009 Oct   4 3 "wrong" affected row value returned by REPLACE
728 code closed 2004 May anonymous Unknown 2004 Nov anonymous 4 3 .schema table fails if followed by a semicolon
729 new closed 2004 May anonymous Unknown 2004 Oct   5 3 Support wiki-style bulleted lists in tickets
730 new closed 2004 May anonymous   2004 May   4 3 Differentiate context-sensetive user actions and navigation in UI
731 code closed 2004 May anonymous   2004 May   2 3 UNIQUE constraint not working when one of the fields is null
733 code closed 2004 May anonymous   2004 Aug anonymous 3 3 About Ticket #731
735 code closed 2004 May anonymous Shell 2008 Jun   4 3 .sqliterc not processed if running on a driver other than C:
737 new closed 2004 May anonymous Shell 2009 Oct anonymous 3 3 xml export
745 code closed 2004 May anonymous VDBE 2005 Jan   5 3 no error message when two statements cause a conflict
747 code closed 2004 May anonymous   2005 Jan   3 3 database not closed if un-finalized VMs exist
748 new closed 2004 May anonymous   2009 Oct   3 3 option to allow ignoring trailing whitespace in selects
750 code closed 2004 May anonymous Unknown 2004 Jul   2 3 copy command does not work with existing table
754 code closed 2004 Jun anonymous Shell 2009 Oct drh 2 3 problem opening a dbfile in the upper directory (../dbname)
762 todo closed 2004 Jun anonymous Unknown 2009 Oct anonymous 4 3 Windows pre-compiled binaries are 2.8.13, not 2.8.14
783 code closed 2004 Jun anonymous Unknown 2009 Oct   3 3 Build on MAC with -DSQLITE_DEBUG=1 compile error
795 new closed 2004 Jul anonymous TclLib 2004 Oct   5 3 Separate TCL library from libsqlite3
797 new closed 2004 Jul anonymous Parser 2009 Oct   4 3 require basic named subquery / WITH sql support
801 code closed 2004 Jul anonymous   2004 Sep   1 3 Multiple problems with v3.0.2
821 code closed 2004 Jul anonymous BTree 2004 Jul   3 3 Allows string data on indexes INTEGER fields
825 code closed 2004 Jul anonymous   2004 Jul   3 3 lower(X) / upper(X) - not work correctly on non Latin characters
828 warn closed 2004 Jul anonymous Unknown 2009 Oct   3 3 integer constants to long
833 todo closed 2004 Jul anonymous Unknown 2009 Oct   1 3 port of sqlite 2.8.15 to djgpp
843 new closed 2004 Aug anonymous Unknown 2009 Oct   3 3 Introducing I64 printf size prefix
853 doc closed 2004 Aug anonymous Parser 2009 Oct   4 3 syntax of DEFAULT in a CREATE TABLE statement not as documented
858 code closed 2004 Aug anonymous Unknown 2004 Aug   2 3 core dump when peforming bind
866 code closed 2004 Aug anonymous   2004 Aug   2 3 Breakage when repeatedly creating tables in an attached database
874 code closed 2004 Aug anonymous Parser 2004 Aug   2 3 Inconsistent treatment of quoted strings: "x" vs 'x'
876 code closed 2004 Aug anonymous Unknown 2004 Aug   1 3 select from ... where ... or ... is dead slow on indexed column
879 new closed 2004 Aug anonymous   2004 Aug   5 3 Makefile should produce GCC compatible import library for DLL as well
893 new closed 2004 Sep anonymous   2004 Sep   1 3 No string searches INSTR, LOCATE
894 code closed 2004 Sep anonymous Shell 2004 Sep   3 3 COUNT does not work with DISTINCT SUBSTR
906 code closed 2004 Sep anonymous Unknown 2004 Oct anonymous 3 3 Wrong error code returned when there's not enough disk space available
920 code closed 2004 Sep anonymous Unknown 2004 Sep anonymous 3 3 group by without having not supported
928 code closed 2004 Sep anonymous VDBE 2004 Sep drh 3 3 delete record by rowid would core dump
933 code closed 2004 Sep anonymous Unknown 2004 Sep anonymous 3 3 os_xxx.c does not always check for error and returns SQLITE_OK
941 code closed 2004 Oct anonymous Unknown 2004 Oct   2 3 Updates are not atomic with respect to unique constraints
944 new closed 2004 Oct anonymous Shell 2009 Oct   4 3 Command to abort current expression.
947 warn closed 2004 Oct anonymous Unknown 2009 Oct   3 3 Cygwin: integer constant is too large for "long" type
949 new closed 2004 Oct anonymous Unknown 2004 Oct   3 3 add user-level test for file validity
963 code closed 2004 Oct anonymous Unknown 2004 Oct   3 3 PRIMARY KEY
965 new closed 2004 Oct anonymous VDBE 2009 Oct   3 3 Busy Handler not invoked for SELECT et.al. in SQLite <= 2.8.15
970 code closed 2004 Oct anonymous Parser 2005 Jan   2 3 Crush in authorization procedure
972 warn closed 2004 Oct anonymous   2009 Oct   3 3 building SQLite on Irix
977 code closed 2004 Oct anonymous Unknown 2004 Nov   3 3 View Bug
978 code closed 2004 Oct anonymous BTree 2004 Oct anonymous 3 3 bug in sql_step related to INTEGER PRIMARY INDEX values.
989 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 Followup to #984, same issue with hexToInt
992 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 sqliteStrRealloc: Return early under malloc failure.
994 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 Brackets in JOIN statements break <table>.<column> SELECT syntax
1006 new closed 2004 Nov anonymous Parser 2004 Nov   4 3 Creation of sqlite3_exec16 ?
1009 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 sqlite3RunVacuum: "forever" loop exists in error code path.
1016 code closed 2004 Nov anonymous   2004 Nov   3 3 UPDATE command with invalid SQL Syntax executes
1018 code closed 2004 Nov anonymous Unknown 2005 Jan   1 3 Some functions not defined for OS_MAC
1019 code closed 2004 Nov anonymous Unknown 2005 Jan   1 3 Improper handling of 8bit data
1021 code closed 2004 Nov anonymous   2004 Dec   1 3 LIKE operator % wildcarding broken
1026 code closed 2004 Dec anonymous Unknown 2009 Jan   3 3 sqlite automake sqlite3.pc file does not have version information
1027 code closed 2004 Dec anonymous   2004 Dec   1 3 Deletion of records that don't meet the condition set
1030 code closed 2004 Dec anonymous Shell 2009 Oct   2 3 impossible to import a file and do other things in the same invocation (strongly affects scripting)
1043 doc closed 2004 Dec anonymous   2008 Jun   3 3 SQLITE3_ANY does not exist
1044 code closed 2004 Dec anonymous   2004 Dec   3 3 Insert an integer as a string
1053 code closed 2004 Dec anonymous Pager 2009 Oct   3 3 SQLITE_IOERR and strange rollback when db is busy
1055 code closed 2004 Dec anonymous Unknown 2005 Jan   3 3 Please archive files in PACKAGE-VERSION/ directory
1056 code closed 2004 Dec anonymous Shell 2009 Oct   3 3 test pragma-9.4 fails during second pass in "make fulltest"
1058 code closed 2005 Jan anonymous BTree 2009 Oct   3 3 btree.c pageSize -> usableSize
1065 new closed 2005 Jan anonymous Unknown 2005 Jan   3 3 Uppercase and foreign chars problems in searches
1071 code closed 2005 Jan anonymous Shell 2005 Jan   4 3 Typo in .help
1073 code closed 2005 Jan anonymous Shell 2005 Jan   2 3 Windows Shell: .read commands need '/' in filenames to work
1074 code closed 2005 Jan anonymous Unknown 2005 Jan drh 3 3 CREATE INDEX and dbl-quoted index names
1076 todo closed 2005 Jan anonymous Unknown 2005 Jan   2 3 data loss possible with fsync on Mac OS X 10.3
1085 code closed 2005 Jan anonymous   2009 Oct   2 3 pragma full_column_names and short_column_names still broken
1086 code closed 2005 Jan anonymous   2005 Jan   2 3 sqlite crashes while executing query
1088 code closed 2005 Jan anonymous   2005 Jan   2 3 Allow Collations to work in Views
1096 new closed 2005 Feb   Unknown 2005 Feb   3 3 ? placeholder not allowed in LIMIT or OFFSET clause
1100 code closed 2005 Feb anonymous   2009 Oct   3 3 make test segfaults at capi2-7.12 on amd64 system
1101 code closed 2005 Feb anonymous Parser 2005 Feb   3 3 uninitialized memory copy in yy_shift (in win32 version of parse.c)
1102 code closed 2005 Feb anonymous VDBE 2005 Feb   3 3 uninitialized memory copy in sqlite3VdbeExec
1105 code closed 2005 Feb     2005 Feb   1 3 SQLite Crashes when do a Correlated subqueries
1107 new closed 2005 Feb anonymous Unknown 2005 Mar   5 3 please add function to query endianness match/mismatch for BLOB
1119 code closed 2005 Feb anonymous Parser 2005 Feb   4 3 Field name interpreted as SQL command. (GROUP)
1126 new closed 2005 Feb anonymous Unknown 2009 Oct drh 2 3 sqlite 2.8.16 port to djgpp
1128 event closed 2005 Feb anonymous Shell 2009 Oct   2 3 sqlite3-3.1.2.bin segfaults
1129 new closed 2005 Feb anonymous Unknown 2005 Feb drh 4 3 allow having the same object in several open databases
1131 new closed 2005 Feb anonymous Unknown 2005 Feb   2 3 triggers don't seem to work across databases
1134 code closed 2005 Feb anonymous   2009 Oct drh 3 3 select command with a view and a condition gets no result
1136 code closed 2005 Feb anonymous Unknown 2005 Feb   3 3 make test: syntax error in alter-1.8.2
1138 build closed 2005 Feb anonymous   2009 Jan   4 3 make install fails on MinGW/MSYS trying to install into tclsh
1144 code closed 2005 Feb anonymous Unknown 2005 May   1 3 Changing page_size causes a GPF on memory databases
1172 code closed 2005 Mar anonymous   2005 Mar   1 3 sqlite3_step() seems to not reset database lock check
1176 new closed 2005 Mar anonymous Unknown 2009 Oct   4 3 Blocking Writes
1180 code closed 2005 Mar anonymous   2005 Mar   2 3 Field types problem with .import
1181 code closed 2005 Mar anonymous   2005 Mar   2 3 Field types problem with INSERT
1182 code closed 2005 Mar anonymous   2005 Mar danielk1977 2 3 ALTER TABLE...ADD COLUMN fails if table has user-defined collation
1185 code closed 2005 Mar anonymous   2005 Mar   1 3 Race condition causing crash in busily-threaded application
1187 build closed 2005 Mar anonymous Parser 2009 Oct drh 3 3 OMIT_TRIGGER OMIT_VIEW do not compile properly
1191 code closed 2005 Mar anonymous Unknown 2009 Oct   2 3 last_insert_id() Does Not Work after Insert on View
1192 code closed 2005 Mar anonymous Unknown 2005 Mar   2 3 Defaults not Respected by View Triggers
1195 code closed 2005 Apr anonymous Unknown 2005 Apr   3 3 memory leak
1199 doc closed 2005 Apr anonymous   2008 Jun   4 3 Update the README file
1200 code closed 2005 Apr anonymous   2009 Oct   2 3 new versions of SQLite return different (incorrect) results.
1214 code closed 2005 Apr anonymous Unknown 2009 Oct   2 3 sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects
1220 new closed 2005 Apr anonymous   2009 Oct   4 3 Selectable calling convention
1225 code closed 2005 Apr anonymous Unknown 2005 Apr   3 3 Empty resultset when unreferenced empty "table AS name" is given.
1226 code closed 2005 Apr anonymous   2005 Apr   2 3 Problem when several processes attempt inserts within on the same base
1228 code closed 2005 Apr anonymous Unknown 2009 Oct   4 3 problem with select+union on a view with aliased columns
1235 code closed 2005 May anonymous Unknown 2009 Oct drh 4 3 inconsistent pragma handling
1238 code closed 2005 May anonymous Unknown 2005 Jun   1 3 Failure to compile with SQLITE_OMIT_... macros enabled
1240 new closed 2005 May anonymous Pager 2009 Oct drh 1 3 Need integration of Apple's file locking callbacks improvement
1246 warn closed 2005 May anonymous   2009 Oct   4 3 Many warnings from gcc4
1250 new closed 2005 May anonymous Pager 2009 Oct   1 3 FlushFileBuffers makes Windows sqlite dead slow compared to Linux
1254 new closed 2005 May anonymous Pager 2009 Oct   3 3 better pager_cksum
1255 code closed 2005 May anonymous   2009 Oct   4 3 Decrease number of warnings with Microsoft Visual C++
1261 new closed 2005 May anonymous VDBE 2005 May   5 3 Optimization
1264 code closed 2005 May anonymous Unknown 2009 Oct   3 3 access() undefined on MSVC
1265 new closed 2005 May anonymous Pager 2005 May   3 3 10% speed improvement for huge inserts
1273 code closed 2005 Jun anonymous Unknown 2005 Jun   3 3 Numeric affinity problem with views + coalesce (maybe all functions?)
1294 new closed 2005 Jun anonymous   2009 Oct   3 3 API to get ordinal table name
1298 code closed 2005 Jun anonymous Shell 2009 Oct drh 4 3 sqlite3.exe not recognizing newline as comment terminator
1299 new closed 2005 Jun anonymous   2005 Jun   3 3 need NOT EXISTS
1317 code closed 2005 Jul anonymous   2005 Aug   3 3 Aggregate aliases result in assert() failure
1324 code closed 2005 Jul anonymous   2005 Aug anonymous 3 3 main.c (line 301): 'Timeout' meant to be ptr->busyTimeout ?
1327 code closed 2005 Jul ghaering VDBE 2009 Oct   2 3 UNION causes sqlite3_column_decltype to always return NULL
1333 code closed 2005 Jul anonymous Shell 2005 Jul   2 3 sqlite3 command line interfaces segfaults when getpwd() fails
1335 new closed 2005 Jul anonymous   2005 Aug   5 3 AllowNull
1336 code closed 2005 Jul anonymous   2005 Jul   2 3 cannot find the symbol Timeout
1350 code closed 2005 Aug     2005 Aug   3 3 sqlite gives errors with valgrind
1352 code closed 2005 Aug anonymous Pager 2005 Aug   3 3 Databases created via ATTACH do not respect page_size pragma
1364 code closed 2005 Aug anonymous   2005 Aug   3 3 variable Timeout does not exist anymore in main.c
1365 code closed 2005 Aug anonymous   2009 Oct   3 3 64 bit types not completely overridable
1366 code closed 2005 Aug anonymous VDBE 2005 Aug   3 3 not getting SQLITE_CORRUPT when corruption detected in a SELECT
1393 event closed 2005 Aug anonymous Unknown 2009 Oct   4 3 failure in select2-2.0.3... test
1410 code closed 2005 Sep anonymous Unknown 2005 Sep   2 3 count(*) confused by newlines in data
1417 new closed 2005 Sep anonymous   2009 Oct drh 3 3 Fix successive access to a DB handler (unix broken thread file lock)
1424 new closed 2005 Sep anonymous Unknown 2009 Oct drh 5 3 Pivot table creation
1427 build closed 2005 Sep anonymous   2009 Oct   4 3 tclsqlite.lo target should define USE_TCL_STUBS
1428 code closed 2005 Sep anonymous TclLib 2009 Oct   3 3 tclinstaller.tcl script problems
1430 event closed 2005 Sep anonymous   2005 Sep   3 3 pragma index_list(table) doesn' twork correct with integer PKs
1439 code closed 2005 Sep anonymous Unknown 2005 Sep   3 3 Format String inserting a text
1443 code closed 2005 Sep anonymous   2005 Sep drh 3 3 pragma full_column_names and short_column_names seems not working.
1445 code closed 2005 Sep anonymous   2009 Oct   3 3 Errors testing sqlite 3.2.6 (& v3.3.7)
1451 code closed 2005 Sep anonymous Shell 2009 Oct   4 3 .mode insert does not output BLOBs in an usable way
1464 new closed 2005 Oct anonymous   2009 Oct   4 3 Improving PRAGMA table_info()
1480 event closed 2005 Oct anonymous Unknown 2009 Oct   1 3 Wrong SQL statement crashes PHP+Apache
1483 doc closed 2005 Oct anonymous Unknown 2008 Jun   1 3 expression document:describe ERROR.
1487 code closed 2005 Oct anonymous BTree 2009 Oct   1 3 Corrupt database causes indefinite loop in sqlite3_step()
1496 code closed 2005 Oct anonymous   2005 Oct   4 3 No index creation possible on :memory: DB
1498 build closed 2005 Oct anonymous   2009 Oct   4 3 SQLite Cygwin support
1502 code closed 2005 Oct anonymous Unknown 2009 Oct anonymous 2 3 When selected in a union, view column names are incorrect.
1504 code closed 2005 Nov anonymous Pager 2009 Oct   1 3 Multithreaded DB lock not released using Begin/Commit between threads
1505 code closed 2005 Nov anonymous TclLib 2005 Nov   2 3 Sqlite3 tcl bindings return "{}" instead of {} for the empty result
1508 code closed 2005 Nov anonymous BTree 2009 Oct   1 3 sqlite 2.8.16 crashes on 64-bit / strict memory alignment archs
1515 code closed 2005 Nov anonymous Unknown 2009 Oct   4 3 Quotes incorrect included in colum names.
1522 code closed 2005 Nov anonymous Unknown 2009 Oct   1 3 Make test fails in manydb 1.82-3.299 mac os x 10.4.3 ppc
1531 code closed 2005 Nov anonymous   2005 Nov   4 3 Crash when evaluating SELECT ... HAVING NOT EXISTS
1535 code closed 2005 Nov anonymous Unknown 2005 Nov   2 3 Segmentation fault on query
1540 code closed 2005 Nov anonymous Unknown 2005 Nov   2 3 Failure to create a primary key
1550 new closed 2005 Dec anonymous Unknown 2009 Oct   3 3 Triggers across attached databases
1573 code closed 2005 Dec anonymous Shell 2009 Oct   3 3 Bad CSV output when data contains double quotes
1574 event closed 2005 Dec anonymous Shell 2005 Dec   1 3 corrupt database due to .dump process
1577 build closed 2005 Dec anonymous Unknown 2009 Oct drh 3 3 32bit compile on 64bit system fails to build sqlite3
1581 code closed 2006 Jan anonymous   2006 Jan   4 3 incompatible pointer types lead to compilation errors
1597 new closed 2006 Jan anonymous Unknown 2009 Oct   1 3 wish: support DROP COLUMN
1609 code closed 2006 Jan anonymous Unknown 2006 Jan   2 3 ALTER TABLE ADD COLUMN failed if table name has multibyte character
1612 code closed 2006 Jan anonymous   2006 Jan   1 3 "malformed database schema" when opening 3.2.8 database with SQLITE_OM
1631 code closed 2006 Jan anonymous   2006 Jan   2 3 Sqlite3 reports fdatasync type referenced symbol not found on Solaris
1633 code closed 2006 Jan anonymous VDBE 2009 Oct   3 3 sqlite3_step returns SQLITE_ERROR when interrupted
1636 todo closed 2006 Jan anonymous Shell 2009 Oct drh 4 3 stdev does not work
1639 code closed 2006 Jan anonymous Unknown 2006 Mar   3 3 pkgconfig file in 3.3.1 says version is 3.3
1648 new closed 2006 Jan anonymous   2009 Oct   4 3 meaningless error message: constraint failed
1668 event closed 2006 Feb anonymous Shell 2006 Feb drh 2 3 datetime modifiers "enf of *" and "group * by" do not work
1673 code closed 2006 Feb anonymous Shell 2006 Feb   3 3 constraint using "in" -- bug 1645 revisited
1677 new closed 2006 Feb anonymous   2007 Aug   4 3 No way to know if library was compiled with threadsafety
1681 code closed 2006 Feb anonymous Unknown 2006 Mar   1 3 After upgrading from 3.2.7 to 3.3.4, problems with umlauts
1683 new closed 2006 Feb anonymous Unknown 2008 Jun   4 3 .mode html produces uppercase tags
1687 todo closed 2006 Feb dougcurrie   2006 Mar   3 3 tclsqlite.c crashes MinGW/MSYS gcc 3.4.5 on WIndows
1691 code closed 2006 Feb anonymous Unknown 2006 Mar   3 3 sqlite3_sleep not built
1694 code closed 2006 Feb anonymous Parser 2006 Feb   3 3 SELECT count(distinct vnum) FROM table generates syntax error.
1703 new closed 2006 Mar anonymous Pager 2009 Oct   2 3 Second parameter to gettimeofday() in os_unix.c should be NULL
1704 new closed 2006 Mar anonymous   2009 Oct   4 3 extern "C" block in sqliteInt.h
1708 code closed 2006 Mar anonymous Unknown 2006 Mar anonymous 4 3 Spurious warning: no such table: faculty(1) at dbdimp.c line 269
1733 code closed 2006 Mar anonymous VDBE 2009 Oct drh 4 3 Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
1735 code closed 2006 Mar anonymous Unknown 2009 Oct   1 3 Encoding problem
1742 code closed 2006 Mar anonymous Unknown 2009 Dec drh 2 3 ORDER BY on more than one column causes a big slowdown
1743 code closed 2006 Mar anonymous Parser 2009 Oct   3 3 A very very deep IN statement failure
1748 code closed 2006 Apr anonymous VDBE 2006 Apr   3 3 Memory leak in insert.c: sqlite3TableAffinityStr
1761 code closed 2006 Apr anonymous Unknown 2006 Apr   1 3 SQLite3_BindText fails with a floating point error
1778 new closed 2006 Apr anonymous Parser 2009 Oct   1 3 stdev does not work, workaround not possible due to missing sqrt
1785 new closed 2006 Apr anonymous Shell 2009 Oct   4 3 rl_readline_name not set
1790 code closed 2006 May anonymous Pager 2009 Oct   3 3 :memory: performance difference between v2 and v3
1793 code closed 2006 May anonymous   2006 May   2 3 sqlite3.dll crashes when doing an inner join with limit 0
1799 code closed 2006 May anonymous Pager 2009 Oct   2 3 temp_store=MEMORY slower than FILE for large intermediate result sets
1804 code closed 2006 May anonymous Unknown 2009 Oct   4 3 Inconsistent value type returned by SUM when using a GROUP BY
1810 new closed 2006 May anonymous   2009 Oct   3 3 localtime() not threadsafe on UNIX
1811 doc closed 2006 May anonymous   2009 Oct   5 3 how many open cursors are allowed for one application?
1813 new closed 2006 May anonymous   2007 Nov   2 3 select distinct doesn't take advantage of existing indexes
1815 code closed 2006 May anonymous Parser 2009 Oct   3 3 Support of W3C-DTF(ISO8601 subset) is incomplete
1818 code closed 2006 May anonymous Unknown 2006 May drh 3 3 sqlite3_mprintf() misbehaving on %*. formats
1819 code closed 2006 May anonymous Unknown 2006 May persicom 4 3 faulty html code for concatenated field with "<" character
1822 code closed 2006 May anonymous   2009 Dec   3 3 Table Alias together with Subquery seems not to work proper
1828 code closed 2006 Jun anonymous   2006 Jun   1 3 if not exists doesn't work with a qt program I'm designing.
1833 doc closed 2006 Jun anonymous Unknown 2009 Oct drh 4 3 PRAGMA legacy_file_format not documented
1844 warn closed 2006 Jun anonymous   2006 Jun   2 3 compiler warnings with gcc 3.3.4 on Tru64 V5.1B
1854 event closed 2006 Jun anonymous   2006 Jun   3 3 i am unable to view the tables by using .tables command
1856 code closed 2006 Jun anonymous   2009 Oct   2 3 SQLITE_OMIT_UTF16 breaks 'make test'
1859 code closed 2006 Jun anonymous Unknown 2006 Jun danielk1977 4 3 Wrong calculation og log2() in check-in [3274]
1864 new closed 2006 Jun anonymous   2009 Oct drh 3 3 List availabe SQL functions
1867 code closed 2006 Jun anonymous BTree 2009 Oct   1 3 Access Violation after set a new page_size
1871 event closed 2006 Jun anonymous   2009 Oct   2 3 VACUUM should not change 3.x file format
1872 code closed 2006 Jun anonymous   2009 Oct   4 3 sqlite3_open doesn't support RFC1738 format for filename
1874 new closed 2006 Jun anonymous CodeGen 2009 Oct   2 3 IN is much slower than making separate queries
1878 code closed 2006 Jun anonymous CodeGen 2009 Dec   2 3 No index used when specifying alias name in ORDER BY clause
1880 code closed 2006 Jul anonymous   2006 Jul   3 3 Errors testing sqlite 3.3.6
1885 code closed 2006 Jul anonymous Shell 2009 Oct   2 3 sqlite3 .mode insert and .dump do not list column names for selects
1893 code closed 2006 Jul anonymous   2009 Oct   3 3 sqlite doesn't use indexes containing primary key in prim. key selects
1894 event closed 2006 Jul anonymous Unknown 2006 Jul   4 3 "library routine called out of sequence" when using progress (TCL)
1895 doc closed 2006 Jul anonymous   2008 Jun anonymous 4 3 IS operator not documented
1902 new closed 2006 Jul anonymous Parser 2009 Oct   5 3 allow alternate INSERT syntax using SET foo=bar
1904 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 error using drop table "if exists" in exec
1909 code closed 2006 Aug anonymous VDBE 2006 Aug anonymous 3 3 cannot use sqlite3_prepare() when DB is in "BEGIN EXCLUSIVE" mode
1924 new closed 2006 Aug anonymous Parser 2009 Dec   2 3 optimize queries on unions, constant folding
1929 warn closed 2006 Aug anonymous   2007 Sep   4 3 3.3.7 sqlite3_index_info incompatible with C++
1931 new closed 2006 Aug anonymous   2006 Aug   3 3 timezone difference between PDO/Sqlite and PHP
1936 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 Altering schema seems to invalidate existing database connections
1940 code closed 2006 Aug anonymous   2006 Aug   3 3 insert default values
1947 code closed 2006 Aug anonymous Shell 2009 Oct   3 3 ".mode insert" works bad with BLOBs
1948 code closed 2006 Aug anonymous Shell 2009 Oct   2 3 Double quotes are not escaped in csv mode
1953 code closed 2006 Sep anonymous TclLib 2009 Oct   4 3 Fix for false 64-bit comparisons "make test" failures on Cygwin
1959 new closed 2006 Sep anonymous   2009 Oct   4 3 Unblockable TEMP TABLES
1961 build closed 2006 Sep anonymous   2009 Oct   3 3 3.3.7 : wrong readline.h path in Makefile
1965 code closed 2006 Sep anonymous   2006 Sep   3 3 sqlite returns wrong error code
1994 code closed 2006 Sep anonymous Parser 2009 Dec   1 3 Columns from nested joins aren't properly propagated
1996 new closed 2006 Sep anonymous Unknown 2009 Oct drh 2 3 Data type CHAR
1997 code closed 2006 Sep anonymous   2006 Sep   2 3 can't select rows if column name is contained in data
1998 build closed 2006 Sep anonymous   2009 Jun   2 3 prefix option to configure ignored in tclinstaller.tcl
1999 code closed 2006 Sep anonymous Unknown 2006 Sep   3 3 Memmory leak and wrong passed argument to calback function
2000 doc closed 2006 Sep anonymous Unknown 2006 Sep   1 3 Teorical questions.
2010 code closed 2006 Oct anonymous   2009 Oct   3 3 Timeout ignored in Shared-Cache locking model
2012 code closed 2006 Oct anonymous   2009 Oct   4 3 trigger4.test aborts "make test" on Windows
2013 code closed 2006 Oct anonymous   2009 Oct drh 4 3 Autoincrement increments on failing INSERT OR IGNORE
2014 code closed 2006 Oct anonymous   2009 Oct anonymous 4 3 Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE
2042 code closed 2006 Oct anonymous   2006 Oct   2 3 Subquery does not return the expected NULL
2075 code closed 2006 Nov anonymous   2009 Dec   3 3 Improve VACUUM speed and INDEX page locality
2084 code closed 2006 Nov anonymous   2009 Oct   4 3 Add API function mapping column decl string to SQLite type
2087 new closed 2006 Nov anonymous   2009 Dec   3 3 Ability to add a check constraint via the alter table command
2090 build closed 2006 Nov anonymous   2009 Oct   4 3 Test corrupt2.test fails: Solaris
2091 code closed 2006 Nov anonymous   2006 Nov   3 3 thread unsafety + solution
2094 code closed 2006 Dec anonymous   2006 Dec   1 3 Virtual table cursors are not freed (memory leak)
2095 doc closed 2006 Dec anonymous   2009 Sep   1 3 xFindFunction documentation incomplete
2096 code closed 2006 Dec anonymous   2009 Oct   3 3 ATTACH DATABASE returns SQLITE_ERROR when database is locked
2099 doc closed 2006 Dec anonymous   2009 Oct   3 3 virtual table xDestroy/xDisconnect and cleanups
2104 build closed 2006 Dec anonymous   2009 Oct   2 3 manual link on Mac OS X fails due to common symbol
2108 code closed 2006 Dec anonymous   2006 Dec   4 3 potential memory leak in prepare.c
2110 build closed 2006 Dec anonymous   2009 Oct   4 3 Non-optional linking with readline makes sqlite3 binary GPL
2131 code closed 2006 Dec anonymous   2009 Oct   2 3 Add substring() function (Part of SQL 99)
2136 new closed 2007 Jan anonymous   2009 Oct   1 3 sqlite locking does not handle afs; patch included
2150 code closed 2007 Jan anonymous   2007 Jan   3 3 use of %W in strftime produces unreliable results
2165 code closed 2007 Jan anonymous   2009 Oct drh 4 3 pager performance and checksum
2167 new closed 2007 Jan anonymous   2009 Oct   1 3 add sqlite3_copy_bindings (parallel to sqlite3_transfer_bindings)
2170 code closed 2007 Jan anonymous   2007 Mar anonymous 3 3 -init does not execute .exit/.quit
2174 code closed 2007 Jan anonymous   2007 Jan anonymous 2 3 DBD::SQLite does not return number of rows affected. Count(XXX) OK
2185 new closed 2007 Jan anonymous   2009 Oct   5 3 API access to opened database pathname - helpful for virtual tables
2196 code closed 2007 Jan anonymous   2007 Jan   5 3 Bug in PRAGMA full_column_names with SELECT *
2203 code closed 2007 Jan anonymous   2009 Oct   2 3 table_info pragma "default" column format changed?
2204 new closed 2007 Jan anonymous   2009 Oct   5 3 Stable, documented metadata interface
2223 code closed 2007 Feb scouten   2009 Oct   3 3 pragma auto_vacuum doesn't survive .dump & reconstitute
2232 build closed 2007 Feb anonymous   2007 Feb   3 3 corrupt2.test fails with newer versions of Tcl
2233 new closed 2007 Feb anonymous   2009 Oct   4 3 extend xBestIndex in vtables to carry the values for each contraint
2235 new closed 2007 Feb anonymous   2009 Oct   4 3 Missing xml support in FTS2 for the snippet function
2238 new closed 2007 Feb anonymous   2009 Oct   2 3 Streams as datbase
2241 code closed 2007 Feb scouten   2009 Oct   3 3 pragma integrity_check no longer affects command-line tool's exit code
2243 code closed 2007 Feb anonymous   2007 Jul   2 3 sqlite3 authorizer cannot be exposed in garbage collected languages
2247 doc closed 2007 Feb anonymous   2009 Oct   3 3 documentation of DEFUALT cluase in CREATE TABLE should be fixed
2255 code closed 2007 Feb scouten   2007 Mar   3 3 Temporary DB files are deleted twice in pager_unwritelock, once implic
2258 new closed 2007 Feb anonymous   2008 Apr   4 3 Include field name in check constraint failure message
2266 new closed 2007 Mar anonymous   2009 Oct anonymous 3 3 Add support for Row_Number() Over
2274 todo closed 2007 Mar anonymous   2009 Oct drh 5 3 Sqlite segfaults consistently in FTS2
2280 new closed 2007 Mar anonymous   2009 Oct   4 3 Check constraint failure message should include field name
2297 code closed 2007 Apr anonymous   2009 Oct drh 3 3 uninitialized var (with patch)
2308 build closed 2007 Apr anonymous   2009 Oct   4 3 make sqlite3.c recreates sqlite3.c even though nothing changed
2313 build closed 2007 Apr anonymous   2009 Oct   3 3 readline.h is not properly detected
2338 todo closed 2007 May anonymous   2007 May   4 3 3.3.17 windows dll download gives 3.2.7
2340 code closed 2007 May anonymous   2009 Oct   3 3 "./configure && make testfixture" link problem
2352 code closed 2007 May anonymous   2009 Oct   5 3 timeout just 500 msec to soon
2361 new closed 2007 May anonymous   2007 May   3 3 Why is no LIMIT suported in UPDATE-queries?
2363 code closed 2007 May anonymous   2009 Oct   3 3 Couldn't build 3.3.17 on Cygwin/Vista
2369 code closed 2007 May anonymous   2007 May   3 3 if you do a configure --prefix=/home/someotherdir tcl installs wrong
2376 code closed 2007 May anonymous   2009 Oct   3 3 -batch doesn't work soon enough
2377 build closed 2007 May pweilbacher   2008 Aug   4 3 Allow easy DLL build on OS/2
2381 doc closed 2007 May anonymous   2009 Oct   3 3 'VACUUM' aborts an active transaction.
2383 code closed 2007 May anonymous   2009 Oct   3 3 Inconsistent conversion of BLOB revisited
2388 code closed 2007 May anonymous   2009 Nov   1 3 ORDER BY fails on compound select
2396 code closed 2007 Jun anonymous   2009 Oct   1 3 -column output truncates characters from varchar field.
2398 code closed 2007 Jun anonymous   2009 Oct   2 3 systemcalls should be restarted when they return EINTR
2402 code closed 2007 Jun anonymous   2007 Jun   3 3 Left Outer Join and Where clause
2411 new closed 2007 Jun anonymous   2009 Oct   5 3 fts2 RFE - Separate index and storage
2417 new closed 2007 Jun anonymous   2009 Oct drh 3 3 Idea for read write concurrency.
2427 doc closed 2007 Jun anonymous   2009 Oct   4 3 HTML Tidy warnings on new capi3ref.html
2429 code closed 2007 Jun danielk1977   2007 Jun shess 1 3 problem with fts2 snippet() function
2438 new closed 2007 Jun rse   2009 Oct   3 3 More easily allow the building of SQLite with FTS1 and FTS2
2441 code closed 2007 Jun anonymous   2007 Jun   2 3 Windows only error when deleting tempory files
2443 new closed 2007 Jun anonymous   2009 Oct   3 3 sqlite should return different exit codes for different errors
2444 code closed 2007 Jun anonymous   2007 Jun   2 3 SIGFPE from division of (1<<63)==9223372036854775808
2461 code closed 2007 Jun anonymous   2007 Jun   2 3 BLOB retrieval produces garbled data in UTF-16
2476 todo closed 2007 Jun anonymous   2009 Oct   4 3 SQLite3 ignores ORDER BY clause when performing SELECT ... GROUP BY
2481 code closed 2007 Jul anonymous   2007 Jul   1 3 sqlite leaks memory (after 3.3.13)
2483 code closed 2007 Jul anonymous   2007 Jul   1 3 like clause not working
2486 code closed 2007 Jul anonymous   2007 Sep   2 3 pragma index_list does not detect index created on 2nd connection
2493 build closed 2007 Jul anonymous   2007 Jul   2 3 Fails to build under GCC-4.1.3 on FreeBSD-6.2
2501 build closed 2007 Jul anonymous   2007 Jul   2 3 limits.h confilct with visual studio limits.h
2516 code closed 2007 Jul anonymous   2007 Jul   3 3 REGRESSION:sqlite3_prepare ignores nBytes parameter
2530 code closed 2007 Jul anonymous   2009 Oct   2 3 Unable to write to windows share, even with exclusive lock
2534 code closed 2007 Jul anonymous   2007 Jul danielk1977 2 3 sqlite3_set_auxdata may cause memory to be leaked
2536 code closed 2007 Jul anonymous   2007 Aug   2 3 Possible non-ID index corruption when max_page_count exceeded
2549 build closed 2007 Aug anonymous   2007 Aug   1 3 3.4.1 fails to upgrade from 3.3.1.7 on freeBSD
2551 code closed 2007 Aug anonymous   2007 Aug   3 3 sqlite3 shell gets into bad state with unexpected input
2552 code closed 2007 Aug anonymous   2007 Aug   1 3 sqlite3_column_double causes invalid floating point operation
2553 code closed 2007 Aug anonymous   2007 Aug   3 3 AUTOINCREMENT not working when primary key has multiple columns
2557 build closed 2007 Aug anonymous   2007 Aug   3 3 make test errors on Rhel4 x86_64
2562 code closed 2007 Aug anonymous   2007 Aug   2 3 Multithreaded transactions deadlock (Windows)
2568 new closed 2007 Aug anonymous   2009 Oct   3 3 TEMP_STORE is ignored in some cases
2586 code closed 2007 Aug anonymous   2007 Aug   3 3 INSERT of large number fails on Windows
2603 new closed 2007 Aug anonymous   2007 Oct   1 3 B-tree and B+tree allow bidirectional cursor but VDBE does not.
2605 build closed 2007 Aug anonymous   2007 Aug   1 3 Amalgamated version 3.4.2 doesn't compile (VC++6)
2613 new closed 2007 Sep anonymous   2009 Oct drh 3 3 replace doesn't work with blobs containing \x0, otherwise it does
2617 code closed 2007 Sep anonymous   2007 Sep drh 2 3 Check in #4357 may lead to bugs in SMP aware systems in windows vfs
2634 code closed 2007 Sep anonymous   2009 Oct   3 3 .schema uses incorrect ORDER BY giving wrong dependency order
2638 code closed 2007 Sep anonymous   2007 Sep   2 3 selects on japanese text okay in 3.3.5 bad in later versions
2641 code closed 2007 Sep anonymous   2007 Sep   2 3 sqlite - Ticket #2638 continued as it was arbitrarily closed unsolved
2655 code closed 2007 Sep anonymous   2007 Sep   2 3 Reuse prepared statement after locked(5) gives called out of seq(21)
2661 code closed 2007 Sep anonymous   2007 Sep   2 3 Single line, multi inserts
2663 code closed 2007 Sep anonymous   2007 Oct   3 3 Adding a column with default value not reflected in view
2669 code closed 2007 Sep anonymous   2007 Sep anonymous 2 3 INSERT of Large REAL value fails with Floating Point Exception
2677 new closed 2007 Sep anonymous   2009 Oct danielk1977 5 3 CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events
2679 code closed 2007 Sep anonymous   2007 Oct   2 3 locking errors lead to disk i/o failure with bulk operations on winxp
2695 new closed 2007 Oct anonymous   2007 Oct drh 3 3 sqlite3 CLI unresolved externals with SQLITE_OMIT_GET_TABLE
2707 code closed 2007 Oct anonymous   2007 Oct appledev 1 3 SQLite on Mac OS X seems to have a 4GB database limit
2709 code closed 2007 Oct anonymous   2007 Oct   2 3 Some SQLITE_OMIT_* keys break the sqlite3.c amalgamation compilation
2726 code closed 2007 Oct anonymous   2007 Oct   4 3 solaris 10 compilation B_FALSE, B_TRUE clash from sys/types.h
2751 build closed 2007 Oct anonymous   2007 Nov   2 3 Regression - Solaris/sparc throws BUS ERROR on count()/sum()/etc.
2753 code closed 2007 Nov anonymous   2009 Oct drh 3 3 Master journal files sometimes not deleted
2761 code closed 2007 Nov anonymous   2009 Sep   3 3 CLI (shell.c) should be bundled with amalgamation
2765 code closed 2007 Nov anonymous   2007 Nov   1 3 bad rollback if temporary table created during transaction
2768 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 asserts in wrong order
2769 new closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 Enable access to the sql string used to prepare a statement
2772 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 Low memory assert in analyze
2793 code closed 2007 Nov anonymous   2009 Oct   3 3 fts3 lacks scoping
2814 code closed 2007 Nov anonymous   2009 Oct   3 3 _XOPEN_SOURCE again
2816 code closed 2007 Dec anonymous   2007 Dec drh 4 3 .timer missing from CLI
2825 code closed 2007 Dec anonymous   2009 Oct   3 3 FormatMessage (win32) should use extra flag and convert from Unicode
2845 code closed 2007 Dec rse   2009 Jan   3 3 SQLite 3.5.4 requires TCL during built-time
2855 code closed 2007 Dec anonymous   2007 Dec drh 2 3 Get an error "11:database disk image is malformed" during queries
2856 doc closed 2007 Dec anonymous   2009 Oct anonymous 4 3 SQLite Documentation - Tcl API - Link broken
2858 build closed 2007 Dec anonymous   2008 Jan danielk1977 3 3 amalgamated sqlite3.c requires sqlite3ext.h
2862 warn closed 2007 Dec anonymous   2008 Jan   4 3 Small warning fix
2863 code closed 2007 Dec anonymous   2009 Oct   2 3 test cast-3.14, cast-3.18 and cast-3.24 fail
2864 doc closed 2007 Dec anonymous   2009 Oct   5 3 ext/fts3/README.txt
2866 build closed 2008 Jan anonymous   2009 Oct   1 3 Problems building Windows native in cygwin/mingw environment
2871 build closed 2008 Jan anonymous   2008 Jan   3 3 SQLite 3.5.4 build process does not listen to --disable-tcl
2879 code closed 2008 Jan anonymous   2009 Oct anonymous 4 3 VACUUM enters temporary sequence numbers in sqlite_sequence
2882 code closed 2008 Jan anonymous   2009 Oct   3 3 fulltest failure: ./testfixture: wrong # args: should be "cksum db"
2886 code closed 2008 Jan anonymous   2009 Oct   3 3 testfixture: -fPIC needed when building extension(s)
2891 code closed 2008 Jan anonymous   2008 Feb   2 3 col with "NOT NULL", no default: works on table create, not col add
2901 code closed 2008 Jan anonymous   2009 Oct   3 3 ROLLBACK and COMMIT statements should not expire
2902 code closed 2008 Jan anonymous   2009 Oct drh 3 3 Add watch support to SQLite
2908 code closed 2008 Jan anonymous   2009 Oct   3 3 Add support to examine whether statements modify the database
2921 code closed 2008 Feb anonymous   2009 Nov   3 3 Use of readline interferes with pasting queries indented with tabs
2922 code closed 2008 Feb anonymous   2009 Oct   2 3 sqlite3_step() doesn't pass repreparation errors back to the caller
2930 new closed 2008 Feb anonymous   2009 Oct   3 3 Command line could works with multibyte chars on the current locale
2937 code closed 2008 Feb anonymous   2009 Oct drh 1 3 insert into an attached database does not work within (temp) trigger
2945 build closed 2008 Feb anonymous   2009 Oct   3 3 build on Windows CE 6
2950 code closed 2008 Feb anonymous   2009 Oct   3 3 Windows CE can occasionally leave temp files around
2961 code closed 2008 Feb mlcreech   2008 Feb danielk1977 3 3 Reproducible segfault when executing ioerr3-2
2977 build closed 2008 Mar anonymous   2008 Mar   4 3 The load extension mechanism does not have a configure option
2983 code closed 2008 Mar anonymous   2008 Mar   3 3 "SQL logic error or missing database" with INSERT
2984 new closed 2008 Mar anonymous   2009 Oct   3 3 Plans to add "end of ..." date/time functions?
2996 code closed 2008 Mar anonymous   2009 Oct   3 3 Can't open long filename/pathnames on windows
3005 code closed 2008 Mar anonymous   2008 Mar drh 3 3 Some Compilation Options not work
3006 code closed 2008 Mar anonymous   2008 Mar   3 3 Straneg behaviour during LEFT JOIN with column AS statement
3008 doc closed 2008 Mar anonymous   2009 Oct   3 3 HTML bad links on tclsqlite.html page
3013 code closed 2008 Mar anonymous   2008 Apr   4 3 sqlite3.nChange not (always) reset
3028 build closed 2008 Apr anonymous   2009 Oct   4 3 Build problem on 64 bit Windows.
3030 code closed 2008 Apr anonymous   2008 May   2 3 Failure of read during begin transaction leaves database locked.
3032 code closed 2008 Apr anonymous   2008 Apr   1 3 sqlite3_exec() can not get column count for blob data
3033 code closed 2008 Apr anonymous   2008 Apr   3 3 Index unused in join, unless dropped and recreated
3041 build closed 2008 Apr anonymous   2008 Apr   4 3 Build problem with SQLITE_OMIT_VIEW
3063 code closed 2008 Apr anonymous   2009 Sep   4 3 sqlite3_clear_bindings() clears error message as well
3075 warn closed 2008 Apr anonymous   2008 Apr   3 3 warnings when compiling with Visual Studio 2005
3078 code closed 2008 Apr anonymous   2008 Apr   2 3 blob i/o doesn't work with virtual tables
3091 code closed 2008 Apr anonymous   2008 Apr   2 3 AIX problems with 3.5.7 and 3.5.8 - possibly unixGetTempname related
3121 code closed 2008 May anonymous   2008 May   3 3 Bad encoding change in vdbe Op_Column.
3123 code closed 2008 May anonymous   2009 Oct   2 3 zErrMsg does not work for Virtual Tables
3155 code closed 2008 Jun anonymous   2008 Jun   3 3 SQLite breaks when interrupting while preparing a CREATE TABLE
3166 code closed 2008 Jun anonymous   2008 Jun   1 3 potential stack overflow from sqlite3VdbeMemRelease()
3173 new closed 2008 Jun anonymous   2008 Jun   3 3 No way to get fractional seconds since epoch
3180 code closed 2008 Jun anonymous   2008 Jun   3 3 Invalid column name in subselect does not generate an error
3187 doc closed 2008 Jun anonymous   2009 Oct   4 3 VirtualTable cursor recylcing undocumented (xFilter called twice)
3192 new closed 2008 Jun anonymous   2008 Jun   4 3 Feature Request: Add Date & Time Functions to 'DEFAULT' table syntax
3194 code closed 2008 Jun anonymous   2009 Oct   3 3 query parameter is treated as zero / ignored in SUM with GROUP BY
3195 doc closed 2008 Jun anonymous   2009 Oct   3 3 Are SQLITE_MAX_* variables official API or not?
3198 code closed 2008 Jul anonymous   2008 Jul   3 3 Strange memory leak on some kind of queries with virtual tables
3199 todo closed 2008 Jul anonymous   2008 Jul   3 3 AUTOINCREMENT and rollback reuses PKs
3212 code closed 2008 Jul anonymous   2008 Jul   2 3 autoincrement columns are not shown as primary key on sqlite_master
3213 code closed 2008 Jul anonymous   2009 Oct   3 3 pre-3.6.0 x86-64 fulltest failures
3249 code closed 2008 Jul anonymous   2008 Jul   2 3 ROLLBACK fails if statement was prepare before BEGIN
3251 doc closed 2008 Jul anonymous   2009 Oct   3 3 sqlite3_close() documentation may lead to crashing applications
3262 code closed 2008 Jul anonymous   2008 Jul   3 3 pre-3.6.1 fulltest regression (argument mismatch for perm-memsubsys1)
3267 code closed 2008 Aug anonymous   2008 Aug doughenry 1 3 Sqlite3_prepare16 problem
3276 code closed 2008 Aug anonymous   2009 Oct   2 3 double quotes and separators are not handled correctly (csv mode)
3279 code closed 2008 Aug anonymous   2008 Aug   2 3 bug in +marking of where column
3286 code closed 2008 Aug anonymous   2008 Aug   3 3 Reading long text generates error
3287 code closed 2008 Aug anonymous   2008 Aug   3 3 Case-insensitive search doesn't spread to Cyrillic characters
3294 code closed 2008 Aug anonymous   2008 Aug   3 3 sqlite3_open_v2
3297 code closed 2008 Aug anonymous   2009 Oct   4 3 mixing GROUP columns with no GROUP columns with no GROUP BY: no error
3312 code closed 2008 Aug anonymous   2008 Sep   3 3 rtreeBestIndex never sets estimatedCost
3314 code closed 2008 Aug anonymous   2008 Aug   3 3 "ORDER BY term number 1 does not match any result column" during UNION
3315 build closed 2008 Aug anonymous   2009 Oct   3 3 configure "--enable-load-extension" doesn't work "--without-tcl"
3332 todo closed 2008 Aug anonymous   2008 Aug drh 3 3 Switching auto_vacuum settings fails on certain files
3337 new closed 2008 Aug aswift   2009 Sep drh 3 3 Need API access to system error codes
3338 code closed 2008 Aug anonymous   2009 Oct   2 3 last_insert_rowid() result not correct when operating on FTS3 tables
3341 new closed 2008 Aug aswift   2009 Oct drh 3 3 Add support for compile-time mutex config SQLITE_CONFIG_MULTITHREAD
3351 secure closed 2008 Sep anonymous   2008 Sep   3 3 Insecure use of vsprintf() in lemon.c
3353 todo closed 2008 Sep anonymous   2009 Oct   2 3 sqlite3: "no space left on device" error lost when writing .output
3354 doc closed 2008 Sep anonymous   2009 Oct   1 3 concurrent write access fails on ReiserFS
3356 new closed 2008 Sep anonymous   2009 Oct drh 5 3 CURRENT_TIMESTAMP Default value
3358 code closed 2008 Sep anonymous   2008 Sep   1 3 segfault in sqlite3ExprAffinity
3363 code closed 2008 Sep anonymous   2008 Sep   1 3 RTree corruption
3373 code closed 2008 Sep anonymous   2009 Oct   1 3 unixFullPathname poor behaviour with long strings
3377 code closed 2008 Sep anonymous   2008 Sep   1 3 Compiler errors while trying to compile SQLite amalgamation
3382 code closed 2008 Sep anonymous   2008 Sep   1 3 Lib crashes then use UNION ALL and ORDER BY
3385 code closed 2008 Sep anonymous   2008 Sep   1 3 SELECT DISTINCT and ORDER BY misbehave
3393 code closed 2008 Sep anonymous   2009 Oct   3 3 VACUUM destroys certain databases.
3394 code closed 2008 Sep anonymous   2009 Sep   1 3 Return (error code) of xCurrentTime is always ignored
3401 code closed 2008 Sep anonymous   2008 Sep   2 3 failure to detect bogus virtual table column usage
3404 code closed 2008 Sep anonymous   2009 Oct   1 3 NaN handling not consistent between architectures on Mac OS X
3407 code closed 2008 Sep anonymous   2008 Sep   2 3 Tcl Interface - backslash substitution in strings retrieved from db
3408 code closed 2008 Sep anonymous   2008 Oct   1 3 wrong WHERE clause with RowID column
3416 code closed 2008 Oct anonymous   2008 Oct   2 3 Can't compile in Visual C++ 2003
3423 code closed 2008 Oct anonymous   2008 Oct   2 3 SQLite 3.6.3 fails to compile with Visual Studio .NET 2003
3425 code closed 2008 Oct anonymous   2009 Oct   3 3 virtual tables don't play well with .dump
3428 code closed 2008 Oct anonymous   2008 Oct   1 3 Possible memory leak in sqlite3_open_v2
3429 code closed 2008 Oct anonymous   2008 Oct   3 3 sqlite3_column_name returns name of wrong column
3431 build closed 2008 Oct anonymous   2008 Oct   4 3 Can't compile 3.6.3 (amalgameaed) withIntel compiler on Windows
3432 code closed 2008 Oct anonymous   2008 Oct   3 3 ORDER BY doesn't work with single quoted alias
3450 code closed 2008 Oct anonymous   2009 Oct   3 3 sqlite3 foo.db .dump emits COMMIT; after interrupt
3452 new closed 2008 Oct anonymous   2009 Oct   3 3 os_unix.c:unixSectorSize() should use statvfs() to get pref blk size
3454 code closed 2008 Oct anonymous   2008 Oct   3 3 hardcoded 32KB pagesize max may be too low
3455 code closed 2008 Oct anonymous   2008 Oct   3 3 low-memory assert in sqlite3CreateIndex() in build.c
3456 code closed 2008 Oct aswift   2009 Oct drh 3 3 Add extended error codes for SQLITE_ERROR
3462 code closed 2008 Oct anonymous   2009 Oct   4 3 H10336 is not true
3463 code closed 2008 Oct anonymous   2008 Oct   1 3 UNIQUE does not work according to SQL 92 standard
3468 code closed 2008 Oct anonymous   2008 Oct   3 3 low memory crash in sqlite3ValueFromExpr() in vdbemem.c
3470 code closed 2008 Oct anonymous   2008 Oct   3 3 low memory assert in sqlite3_exec() in legacy.c
3472 code closed 2008 Oct anonymous   2009 Oct   3 3 SQLITE_THREAD_OVERRIDE_LOCK depends on first DB accessed by process
3473 code closed 2008 Nov anonymous   2008 Nov   3 3 low memory assert in sqlite3VdbeExec()
3479 build closed 2008 Nov anonymous   2008 Nov   2 3 Compile error when SQLITE_MUTEX_NOOP is defined
3484 code closed 2008 Nov anonymous   2008 Nov   3 3 Column affinity not always correctly applied to integers
3498 code closed 2008 Nov anonymous   2009 Sep   2 3 sqlite3_errmsg and errcode should be per thread
3499 doc closed 2008 Nov anonymous   2008 Nov   4 3 are registrations by createFunction permanent
3501 code closed 2008 Nov anonymous   2008 Nov   3 3 like-search with german umlaut is case-sensitive, should not be
3506 build closed 2008 Nov anonymous   2009 Oct   2 3 configure needs to check libthread.so, not just libpthread.so
3507 code closed 2008 Nov anonymous   2009 Sep   3 3 sqlite3_overload_function ignores errors from sqlite3CreateFunc
3511 code closed 2008 Nov anonymous   2009 Oct   3 3 apparent incorrect return constant in do_meta_command
3514 code closed 2008 Nov anonymous   2009 Oct   2 3 sqlite3_analyzer reports weird numbers
3523 doc closed 2008 Dec anonymous   2009 Oct   4 3 sqlite_docs_<version>.zip changes directory back and forth
3532 doc closed 2008 Dec anonymous   2009 Oct   3 3 lang_select.html claims conformance to sql-92 join syntax
3539 code closed 2008 Dec anonymous   2008 Dec   3 3 Segmentation/bus error when creating complex view
3548 code closed 2008 Dec anonymous   2008 Dec   3 3 "count() .. group by" stmt return nothing instead of 0 when no record
3550 code closed 2008 Dec anonymous   2008 Dec   2 3 Problem in ATTACH or DETACH
3551 new closed 2008 Dec anonymous   2009 Oct   4 3 pragma table_info, declared collation of the column
3553 code closed 2008 Dec anonymous   2009 Oct   1 3 Bus error with 32bit build on Solaris SPARC
3554 code closed 2008 Dec anonymous   2008 Dec   3 3 before insert trigger odd behavior
3555 build closed 2008 Dec anonymous   2009 Oct   3 3 Need to check for and use -ldl
3556 code closed 2008 Dec anonymous   2008 Dec   1 3 Upgrade from 3.6.1 to 3.6.7 under WinCE resulted in Invalid Querys
3560 code closed 2008 Dec anonymous   2008 Dec   1 3 join with mis-specified index confuses query planner
3561 code closed 2008 Dec anonymous   2008 Dec   3 3 gcc 4.1.2 complains about illegal char in keywordCode() zText[]
3562 new closed 2008 Dec anonymous   2009 Jan   3 3 sqlite3_create_meta_function -- add const to first parameter
3575 code closed 2009 Jan anonymous   2009 Jan   3 3 Uninitialized memory read in sqlite3VdbeMemShallowCopy
3586 code closed 2009 Jan anonymous   2009 Jan   4 3 Unable to build shell in VS6. Plus encryption.
3590 code closed 2009 Jan anonymous   2009 Jan   2 3 unable to use 'release' as column name without quotes
3591 code closed 2009 Jan anonymous   2009 Oct   3 3 Print: "-- Loading resources from ..." in -batch mode
3592 code closed 2009 Jan anonymous   2009 Oct   4 3 sqlite3_changes return last value for drop table
3604 code closed 2009 Jan anonymous   2009 Jan   3 3 getNextToken contains off-by-1 error
3605 warn closed 2009 Jan anonymous   2009 Jan   3 3 Possibly incorrect assignment in function pager_playback_one_page
3607 code closed 2009 Jan anonymous   2009 Mar   1 3 Vista64 + SMB server - journal creation fails (concurrency issue)
3608 code closed 2009 Jan anonymous   2009 Jan drh 4 3 delete: alias for table not accepted => delete from tabelle t ...
3617 doc closed 2009 Jan anonymous   2009 Oct   3 3 Documentation does not discuss PRAGMA collation_list
3642 code closed 2009 Feb anonymous vfs 2009 Feb danielk1977 2 3 Journal recovery fails when fcntl stub macro is enabled
3643 code closed 2009 Feb anonymous front 2009 Feb   2 3 sqlite_bind_parameter_name() failure
3649 xplatform closed 2009 Feb anonymous cli 2009 Oct   2 3 sqlite3 hangs in Cygwin rxvt bash shell window
3655 new closed 2009 Feb anonymous   2009 Feb   5 3 Add month() and year() functions
3656 code closed 2009 Feb anonymous   2009 Feb   3 3 Strange behavior on jointure
3657 build closed 2009 Feb anonymous cli 2009 Feb drh 3 3 Broken again: Oracle and MS-sql command terminator logic
3667 build closed 2009 Feb anonymous build 2009 Feb   4 3 ./configure does not recognize --enable-dynamic-extensions
3673 build closed 2009 Feb anonymous build 2009 Oct   2 3 makefile doesn't clean pkgIndex.tcl and sqlite3_analyzer
3675 code closed 2009 Feb anonymous back 2009 Feb   3 3 load_extension does not work in trigger
3679 code closed 2009 Feb anonymous front 2009 Feb danielk1977 3 3 sqlite3_table_column_metadata fails in havy threading environment
3685 new closed 2009 Feb anonymous front 2009 Oct   3 3 Enhance INSERT syntax, allowing multiple VALUES
3687 new closed 2009 Feb anonymous ext 2009 Oct   1 3 Make genfkey code available in amalgamation
3691 new closed 2009 Feb anonymous tcl 2009 Oct   5 3 persist parameters in views
3692 new closed 2009 Feb anonymous front 2009 Oct   5 3 New define such as SQLITE_DISABLE_VIEW_ON_ATTACHED_DATABASE
3694 warn closed 2009 Feb anonymous   2009 Oct   3 3 Unpredictable uninitialized variables
3695 build closed 2009 Mar anonymous build 2009 Mar   3 3 sqlite-3.6.11.tar.gz: Outdated configure+Makefile.in
3706 build closed 2009 Mar anonymous build 2009 Mar anonymous 4 3 Make file in sqlite-3.6.11.tar.gz does not compile and link backup.c
3711 new closed 2009 Mar anonymous   2009 Oct   4 3 ATTACH + :memory: + atomic commit
3712 code closed 2009 Mar anonymous   2009 Mar   1 3 sqlite3.c:40187: sqlite3BtreeCommitStmt: Assertion `pBt->readOnly==0'
3714 xplatform closed 2009 Mar anonymous cli 2009 Oct   4 3 sqllite does not accept --help for help
3716 todo closed 2009 Mar anonymous   2009 Mar   1 3 Mac OS X archive not working
3722 code closed 2009 Mar anonymous cli 2009 Mar   3 3 buffer overflow in genfkey
3733 code closed 2009 Mar anonymous front 2009 Mar   2 3 Double quotation marks in WHERE-statement works incorrect
3735 code closed 2009 Mar anonymous back 2009 Oct   2 3 DB connections fail to share cache correctly
3736 code closed 2009 Mar anonymous func 2009 Mar   1 3 Bus error in HP-UX B.11.23 Itanium, problem in WhereInfo init ...
3737 build closed 2009 Mar anonymous build 2009 Oct   2 3 [Unix] libsqlite3.so should be linked with -ldl
3739 code closed 2009 Mar anonymous   2009 Mar   2 3 NULL in one of attributes messes up entire query that uses LIKE
3745 code closed 2009 Mar danielk1977 back 2009 Mar danielk1977 3 3 Incorrect SQLITE_BUSY return in persistent-journal mode
3747 build closed 2009 Mar anonymous build 2009 Mar   2 3 "make install" must install libsqlite3.la before libtclsqlite3.la
3748 build closed 2009 Mar anonymous build 2009 Mar   4 3 "make clean" errors out if doc/lemon.html doesn't exist
3752 new closed 2009 Mar anonymous   2009 May   3 3 Provide a method to override assert in SQLite
3754 xplatform closed 2009 Mar anonymous   2009 Oct   5 3 MySQL syntax compatibility: AUTO_INCREMENT as alias of AUTOINCREMENT
3765 build closed 2009 Mar anonymous build 2009 Jun anonymous 3 3 Warning during make of amalgamation version 3.6.12
3770 new closed 2009 Apr anonymous front 2009 Oct   3 3 Optimizations
3783 code closed 2009 Apr anonymous build 2009 Apr   4 3 notify.c: Missing (void) in procedure defs
3784 code closed 2009 Apr anonymous   2009 Apr   3 3 With check-in [6454], "PRAGMA default;" still reports syntax error
3785 code closed 2009 Apr anonymous front 2009 Oct   3 3 cannot join using column oid - column not present in both tables
3788 code closed 2009 Apr anonymous   2009 Apr   2 3 Extremely excessive memory usage and slowness when using 32k page_size
3794 code closed 2009 Apr anonymous func 2009 Apr   4 3 FAIL on SQL query causes sliqte3 to return SQLITE_CONSTRAINT twice
3795 code closed 2009 Apr anonymous func 2009 Apr   4 3 SQLITE returns SQLITE_CONSTRAINT twice on Trigger error.
3796 new closed 2009 Apr anonymous   2009 Sep   2 3 Async "attach" command
3797 new closed 2009 Apr anonymous front 2009 Oct   3 3 Not optimal join implementation in some case
3803 code closed 2009 Apr anonymous build 2009 Sep   3 3 size of sqlite3.c overflows stabs fields making some debugging fail
3810 code closed 2009 Apr anonymous back 2009 Oct danielk1977 2 3 SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()
3814 code closed 2009 Apr anonymous func 2009 May   1 3 sum function won't work if the "group by" fields heaving unicode data
3820 code closed 2009 Apr anonymous front 2009 Oct   4 3 multi-line comments don't work when followed by "." directive
3823 code closed 2009 Apr anonymous back 2009 Oct   3 3 busy timeout is ignored in shared-cache mode
3831 code closed 2009 Apr anonymous back 2009 Oct   3 3 Database corrupted during proper usage of sqlite
3833 code closed 2009 May anonymous back 2009 Jun   1 3 Concurrent sqlite3OsAccess() and sqlite3OsDelete()
3836 code closed 2009 May anonymous   2009 May   3 3 select * where rowid > 10 fails, but >=10 works
3839 code closed 2009 May anonymous vfs 2009 Sep   5 3 make internal functions and variables static
3868 code closed 2009 May anonymous   2009 May   1 3 sqlite3AtoF is wrong
3882 code closed 2009 May anonymous back 2009 May   1 3 On sparc/linux, sqlite-3.6.14.x series can generate a bus error.
3894 code closed 2009 Jun anonymous front 2009 Jun   3 3 No such column error when using quoted names in subqueries.
3895 code closed 2009 Jun anonymous back 2009 Jun   1 3 Bus Error on DELETE FROM on hpux-ia64 in 32bit mode (ELF-32)
3896 new closed 2009 Jun anonymous   2009 Oct   3 3 Optional Locking for Virtual Tables
3903 doc closed 2009 Jun anonymous   2009 Jun   3 3 Problem with affinities
3932 doc closed 2009 Jun anonymous front 2009 Jun   4 3 Accent grave (`) does not appear supported for table and column names
3935 code closed 2009 Jun anonymous front 2009 Jul   2 3 Error in table alias since 3.6.15
3936 warn closed 2009 Jun anonymous build 2009 Oct   4 3 Newer libtool needs LT_INIT
3937 code closed 2009 Jun anonymous vfs 2009 Oct   2 3 Cygwin 1.7 compatibility patch
3938 code closed 2009 Jun anonymous test 2009 Oct   3 3 v 3..6.16 do not pass unit tests: 'make test'
3939 code closed 2009 Jul anonymous   2009 Jul   3 3 Dropping a table with open statements fails
3944 code closed 2009 Jul anonymous front 2009 Jul danielk1977 1 3 Access violation in sqlite3AuthRead
3950 code closed 2009 Jul anonymous vfs 2009 Oct   2 3 sqlite3_last_insert_rowid returns the wrong rowid
3958 code closed 2009 Jul anonymous back 2009 Jul   4 3 Quering out the rowid works diferent
3966 code closed 2009 Jul anonymous cli 2009 Oct   1 3 sqlite shell does not return fail status from fail during .import
3969 doc closed 2009 Jul anonymous   2009 Jul   3 3 jump is a keyword?
3972 code closed 2009 Jul anonymous ext 2009 Jul danielk1977 3 3 zNew is used uninitialized in getNextString if !zTemp
3974 new closed 2009 Jul anonymous front 2009 Oct   4 3 support for SQL:2008 <result offset clause> and <fetch first clause>
3977 todo closed 2009 Jul danielk1977   2009 Jul danielk1977 3 3 Defining SQLITE_OMIT_INCRBLOB breaks sqlite3_result_zeroblob()
3979 code closed 2009 Jul anonymous   2009 Oct   2 3 DISTINCT performance
3980 code closed 2009 Jul anonymous   2009 Jul   1 3 Primary key with NULL not enforced
3984 doc closed 2009 Jul anonymous   2009 Oct   3 3 Requirement H13015 does not specify value for pzTail
3986 code closed 2009 Jul anonymous front 2009 Jul   3 3 EXPLAIN causes Segmentation Fault
3995 new closed 2009 Jul anonymous ext 2009 Jul   5 3 fts3 legacy syntax: whitespace before '-' prefix
3996 new closed 2009 Jul anonymous ext 2009 Jul   5 3 fts3 syntax: case insensitive column names
3999 code closed 2009 Jul anonymous   2009 Jul danielk1977 3 3 FTS3 : Use other separator than space for matches in offsets function
4006 new closed 2009 Aug anonymous back 2009 Aug   3 3 PRAGMA to define journal location
4023 code closed 2009 Aug anonymous   2009 Aug   3 3 Error when connect to SQLite on Linux platform
4024 new closed 2009 Aug anonymous back 2009 Oct   4 3 createVarMap race condition fix
4025 warn closed 2009 Aug anonymous back 2009 Oct   3 3 Add assertions to createVarMap
4026 build closed 2009 Aug anonymous build 2009 Aug   2 3 Error when compiling for Windows CE
4030 code closed 2009 Aug anonymous back 2009 Aug   3 3 Checkin 6906 has unintended side affect in how zero blobs are stored
4032 new closed 2009 Aug anonymous   2009 Oct   5 3 Create TableObject future
4035 warn closed 2009 Aug anonymous ext 2009 Oct   4 3 Fix for compiler warning in fts3.c
4036 new closed 2009 Aug anonymous back 2009 Oct   4 3 Especial Use of BackSlach characters
4037 code closed 2009 Aug anonymous front 2009 Nov   2 3 unsupported syntax: databasename.tablename.*
4042 code closed 2009 Oct anonymous   2009 Oct   3 3 Tests from icu.test fail in SQLite 3.6.19
4044 code closed 2009 Nov anonymous   2009 Nov   5 3 For Wince Patch Or Dll ?
7 code closed 2002 Apr danielk1977 VDBE 2002 May   5 2 VDBE trace prints out garbage for P3 of Function opcodes
16 code closed 2002 Apr anonymous CodeGen 2002 May   2 2 sqlite cores
27 code closed 2002 Apr anonymous   2002 Apr drh 2 2 incorrect result when doing select using quotes in where
41 code closed 2002 May drh   2002 Sep   1 2 sqlite_complete() failure
46 code closed 2002 May drh CodeGen 2002 Sep   3 2 CREATE TABLE accepts duplicate column names
50 code closed 2002 May drh   2002 Sep   3 2 Memory leak in triggers on TEMP tables
54 todo closed 2002 Jun anonymous   2002 Sep   2 2 win32 binaries are missing symbols
65 code closed 2002 Jun anonymous   2002 Sep   2 2 Error in .dump'ed INSERT statements
66 code closed 2002 Jun anonymous   2002 Sep drh 1 2 LIMIT clause ignored in subselects
77 code closed 2002 Jun anonymous   2002 Sep   2 2 more than one LIMIT on nested select shows 0 rows
80 code closed 2002 Jun anonymous   2002 Sep   2 2 Heap corruption on select with ORDER BY, LIMIT, and OFFSET
92 code closed 2002 Jul anonymous   2002 Sep   2 2 max() looks boggus in a view
100 code closed 2002 Jul anonymous   2002 Sep   1 2 view not properly restored after closing and reopening database
104 code closed 2002 Jul anonymous   2002 Sep   1 2 error in trigger on view after closing and reopening database
157 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 3 2 Doesn't check for data types
158 code closed 2002 Oct anonymous Unknown 2002 Oct   3 2 Union doesn't check for data types
162 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 3 2 mismatch in response column and Group by column is ignored
170 code closed 2002 Oct anonymous TclLib 2002 Oct anonymous 2 2 Insert / select text with cp1250 characters
239 new closed 2003 Feb anonymous Unknown 2009 Oct   4 2 ANSI/Unicode(Wide) version file-handling functions for Win32
248 code closed 2003 Feb anonymous Unknown 2003 Nov   1 2 SQLColumn function in ODBC returns incorrect datatype
259 new closed 2003 Mar anonymous CodeGen 2009 Oct   1 2 ORDER BY queries including an integer primary key don't use index
271 event closed 2003 Mar anonymous Unknown 2008 Jun drh 3 2 'make test' fails on MacOS X
285 build closed 2003 Apr anonymous Unknown 2008 Mar   2 2 Configure doesn't honour LDFLAGS during build
287 new closed 2003 Apr anonymous CodeGen 2005 Jan drh 3 2 query execution time depend from tables order in FROM clause
335 event closed 2003 Jun anonymous Unknown 2009 Oct drh 2 2 ChangeCount still failing
356 new closed 2003 Jun anonymous VDBE 2008 Jun   5 2 Returns real error codes
362 event closed 2003 Jun anonymous Shell 2009 Oct jadams 4 2 Problem with select count
369 code closed 2003 Jun anonymous   2009 Oct   3 2 Testsuite fails on btree-1.1.1 (Mac OS X, SQLite 2.8.4)
380 code closed 2003 Jul anonymous Unknown 2003 Jul   2 2 "uniqueness constraint failed" on insertion of distinct rows
382 code closed 2003 Jul   Unknown 2003 Jul   2 2 Triggers stop firing under certain situations
442 new closed 2003 Sep anonymous   2008 Mar   5 2 [PATCH] sqlite: allow configure --enable-threadsafe
455 doc closed 2003 Sep anonymous   2003 Sep   4 2 undocumented functions: sqlite_mprintf,and sqlite_vmprintf
464 code closed 2003 Sep anonymous   2003 Dec   2 2 VACUUM doesn't compile with sqlite_compile
503 warn closed 2003 Nov anonymous Unknown 2009 Oct anonymous 5 2 Include sqlite source in Visual C++ 6.0 SP5
510 new closed 2003 Nov anonymous Unknown 2009 Oct   5 2 trigger: addition of create ability
512 code closed 2003 Dec anonymous Parser 2003 Dec   2 2 order by clause is not ordering data properly in aggregate functions
528 code closed 2003 Dec anonymous Unknown 2003 Dec   4 2 compiled c code shows queries in executable
537 code closed 2003 Dec anonymous VDBE 2003 Dec   1 2 Problems using sqlite_bind() with INSERT INTO ... SELECT statements
553 code closed 2004 Jan anonymous Pager 2004 Jan   2 2 conversion error in compiling pager.c
578 code closed 2004 Jan anonymous   2004 Feb   4 2 calling isdigit in sqliteIsNumber cause asserts (VC.NET)
597 code closed 2004 Feb anonymous Unknown 2004 Feb   3 2 SELECT * FROM TB_LINFPSP_CONFIG WHERE LINFPSP_CUST_CODE='HBC'
632 doc closed 2004 Feb anonymous   2004 Feb   2 2 fix links on wrappers page
643 code closed 2004 Mar anonymous Unknown 2004 Mar   3 2 local variable 'db' used without having been initialized
684 code closed 2004 Apr anonymous Unknown 2009 Oct   3 2 Incorrect function result type when using SQLITE_ARGS
717 new closed 2004 May anonymous Unknown 2009 Oct drh 2 2 minor fixes and port to dos
718 new closed 2004 May anonymous   2009 Oct anonymous 2 2 Case insensitive index ?
721 code closed 2004 May anonymous Shell 2008 Jun drh 3 2 empty .databases information
744 code closed 2004 May anonymous BTree 2009 Oct anonymous 2 2 make test seg faults on x86_64 Linux
751 code closed 2004 Jun anonymous VDBE 2005 Jan   1 2 sqliteVdbeExec: Assertion `db->magic==***' failed.
755 new closed 2004 Jun anonymous TclLib 2009 Oct drh 5 2 Adding aggregate function to the tcl binding
769 code closed 2004 Jun anonymous   2004 Jun   2 2 macro SQLITE_OMIT_AUTHORIZATION is not honored
780 warn closed 2004 Jun anonymous Unknown 2009 Oct   3 2 Builkd gice src code errors on MacOS
796 code closed 2004 Jul anonymous   2004 Sep   1 2 sqlite3_open16 Unworkable
817 new closed 2004 Jul anonymous   2004 Jul   4 2 Return size of blob
841 code closed 2004 Aug anonymous Unknown 2009 Oct   3 2 inner group by query isn't honored by outer count(*) aggregate
851 doc closed 2004 Aug anonymous Parser 2009 Oct mihailim 5 2 SQLite allows Zero length table column names
863 code closed 2004 Aug anonymous BTree 2004 Sep   2 2 Stack overflow in the btree.c module
864 build closed 2004 Aug anonymous Unknown 2009 Oct   2 2 3.0.4 uses readling
867 new closed 2004 Aug anonymous Parser 2009 Oct   3 2 update on multiple tables
887 code closed 2004 Sep anonymous Pager 2004 Sep   3 2 Unable to recover from SQLITE_FULL error until DB file is reopened
889 event closed 2004 Sep anonymous BTree 2004 Sep anonymous 1 2 btree.c with new malloc
915 code closed 2004 Sep anonymous   2004 Sep   3 2 problem #901, but on read-only databases
923 code closed 2004 Sep anonymous   2008 Jun anonymous 3 2 Missing quotes in 2.8.15 .dump cause data loss when loading in sqlite3
930 new closed 2004 Sep anonymous Unknown 2009 Oct drh 2 2 djgpp port for sqlite3
942 code closed 2004 Oct anonymous CodeGen 2004 Oct   1 2 Horrible time complexity for certain triple joins.
945 code closed 2004 Oct anonymous Unknown 2004 Oct   2 2 sqlite3 opens sqlite2 databases without complaining
952 code closed 2004 Oct anonymous Unknown 2004 Oct   1 2 Serious memory leak for insert into table with primary key
958 code closed 2004 Oct anonymous Unknown 2004 Nov drh 3 2 sqlite3_create_function() dose not really delete an user function
960 doc closed 2004 Oct anonymous   2008 Jun   3 2 Make archive unpack into directory sqlite-VERSION/
967 event closed 2004 Oct anonymous TclLib 2004 Oct   3 2 PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so
982 code closed 2004 Nov anonymous   2004 Nov   2 2 COPY command does not work in 3.0.8 as it does in 2.8.13
1028 new closed 2004 Dec anonymous Unknown 2004 Dec   2 2 Without COPY: need alt. method to import data (not .import)
1038 code closed 2004 Dec anonymous   2004 Dec   2 2 multi-word type names confuse pragma table_info
1042 code closed 2004 Dec anonymous Unknown 2004 Dec   1 2 where does not work
1060 code closed 2005 Jan anonymous   2005 Jan anonymous 1 2 result of calcul
1092 code closed 2005 Feb anonymous Unknown 2005 Feb   1 2 wrong result of a query
1113 code closed 2005 Feb anonymous Unknown 2005 Feb   2 2 Problem with TYPEOF function in triggers
1125 code closed 2005 Feb anonymous Parser 2005 Mar   1 2 Syntax error: create index with table name qualified by database name
1143 code closed 2005 Feb anonymous   2005 Feb   2 2 prepare/step give incorrect results, compared to the sqlite3 tool
1162 new closed 2005 Mar anonymous   2009 Oct drh 1 2 Column names in sqlite views differ from oracle/informix column names
1183 code closed 2005 Mar anonymous Unknown 2005 Mar danielk1977 3 2 Memory coruption related to syntax errors
1193 new closed 2005 Mar anonymous   2009 Jun   1 2 umask not respected... please change 644 to 666 in src/os_unix.c
1204 new closed 2005 Apr anonymous TclLib 2009 Oct drh 4 2 (visible) version provided by tclsqlite package
1213 code closed 2005 Apr anonymous Parser 2009 Oct   3 2 Problem with alias columns in subqueries
1227 new closed 2005 Apr anonymous Shell 2009 Oct   5 2 Small patch for timing commands in shell.c
1266 code closed 2005 May anonymous VDBE 2005 May   2 2 crash when using instead of update triggers on views
1278 code closed 2005 Jun anonymous   2009 Oct   1 2 sqlite3_finalize doesn't clear previous error code or message
1300 event closed 2005 Jun anonymous Unknown 2009 Oct   2 2 Apache.exe has encountered a problem and needs to close.
1341 code closed 2005 Jul anonymous Parser 2005 Aug   3 2 sqlite_exec() returns always 1 on error
1402 code closed 2005 Sep anonymous Unknown 2005 Sep   1 2 (Windows 2K) file handle on file not released after use
1421 code closed 2005 Sep anonymous BTree 2005 Sep   2 2 Assertion when I try to create a index
1426 event closed 2005 Sep anonymous Unknown 2009 Oct drh 2 2 Problem with DETACH in 2.8.16
1452 code closed 2005 Sep anonymous   2005 Sep   3 2 segmentation fault on OS X tiger
1455 code closed 2005 Sep anonymous Shell 2009 Oct   3 2 .import error: comma inside a string is read as field separator
1458 code closed 2005 Sep anonymous Shell 2008 Jun   2 2 Error at .importing in csv format (another)
1460 code closed 2005 Sep anonymous VDBE 2008 Jan drh 2 2 sqlite3_clear_bindings not implemented in sources
1461 code closed 2005 Sep anonymous Unknown 2009 Oct drh 1 2 3.2.7 DLL can not deal File paths with international characters
1462 code closed 2005 Sep anonymous VDBE 2005 Sep drh 1 2 sqlite3_bind_parameter_name() always return nulls
1477 code closed 2005 Oct anonymous Unknown 2006 Sep   1 2 first "select count(*) from mytable" takes a very long time
1489 code closed 2005 Oct anonymous   2009 Oct   3 2 Bad permissions on install-sh prevent 'make install' from completing
1494 code closed 2005 Oct anonymous Unknown 2009 Oct   1 2 intermittent null reference exception in sqlite3_open
1507 code closed 2005 Nov anonymous VDBE 2005 Nov   2 2 Embarassing buffer overflow in sqlite3VdbeMemPrettyPrint( )
1509 code closed 2005 Nov anonymous   2005 Nov   3 2 Different performance - SELECT COUNT(*) AND SELECT *
1510 build closed 2005 Nov anonymous   2005 Nov   3 2 Can't seem to get autoincrement to work no matter what I try
1516 code closed 2005 Nov anonymous   2005 Nov   1 2 comparison error in WHERE clause
1521 code closed 2005 Nov anonymous Unknown 2009 Dec   3 2 ORDER BY sorts incorrectly with aliased fields
1525 event closed 2005 Nov anonymous Unknown 2009 Oct anonymous 1 2 error creating database
1580 code closed 2006 Jan anonymous   2006 Jan   4 2 3.2.8 does not compile under Solaris 10
1591 build closed 2006 Jan anonymous   2009 Oct   3 2 Missing TEXE suffix in linking and install rules for sqlite3
1592 code closed 2006 Jan anonymous Unknown 2006 Mar   1 2 [patch] fixes for mbcs in os_win.c
1594 code closed 2006 Jan anonymous BTree 2006 Jan danielk1977 2 2 Schema pointer is freed twice
1610 code closed 2006 Jan anonymous   2006 Jan   1 2 SQLITE_OMIT_SUBQUERY can cause access violation
1638 warn closed 2006 Jan anonymous   2009 Dec   3 2 rows place change and some row element missing
1640 code closed 2006 Jan anonymous VDBE 2006 Jan   3 2 Can't get error message from sqlite3_result_error
1643 doc closed 2006 Jan anonymous   2009 Oct   1 2 database-name.table-name not working for "PRAGMA table_info" + friends
1659 event closed 2006 Feb anonymous Shell 2006 Feb anonymous 1 2 Sqlite.exe .import stopped working in latest 3.3.3 release (Win32)
1676 code closed 2006 Feb anonymous   2006 Feb   2 2 When binding the wrong type sqlite3 bails out but retuns an SQLITE_OK
1692 code closed 2006 Feb anonymous   2006 Mar   1 2 Collation dont work in functions
1700 code closed 2006 Mar anonymous Parser 2009 Dec   2 2 Handling column names for aliased queries is broken
1706 code closed 2006 Mar anonymous   2006 Mar   1 2 Group operations like ORDER BY don't work after renaming a table
1722 new closed 2006 Mar anonymous Unknown 2009 Oct   4 2 agregate sum() of strings
1754 code closed 2006 Apr anonymous Pager 2009 Oct anonymous 2 2 Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
1764 code closed 2006 Apr anonymous Unknown 2006 Apr   1 2 database file format not inter-operable between 32-bit/ 64-bit systems
1765 code closed 2006 Apr anonymous   2006 Apr   1 2 SQLite3_BindText fails with a floating point error (explicited)
1766 new closed 2006 Apr anonymous Unknown 2006 Apr   3 2 Order by NO Case Sensitive
1776 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 1 2 Max(DateTime column) returns a String, not a DateTime
1783 code closed 2006 Apr anonymous Unknown 2009 Oct   3 2 insert times increase with growing table size (when indexed)
1800 new closed 2006 May anonymous   2006 May linus 1 2 possible to have the lastest version of sqlite with PHP 5?????
1816 code closed 2006 May anonymous VDBE 2009 Oct   1 2 Database corruption with pragma auto_vacuum
1835 code closed 2006 Jun anonymous Unknown 2006 Jun   1 2 Memory leak on sqlite3_step with Select with no result row
1841 warn closed 2006 Jun anonymous   2006 Jun mani 3 2 a scan in safe mode says my sqlite file is wrong size
1843 code closed 2006 Jun anonymous   2006 Jun   3 2 compile with gcc 3.3.4 on Tru64 V5.1B
1865 code closed 2006 Jun anonymous   2006 Jun   1 2 Encoding problem using order by
1870 code closed 2006 Jun anonymous   2006 Jun   2 2 dbWriteTable in RSQLite can't write strings that contain commas.
1883 code closed 2006 Jul anonymous   2006 Jul   1 2 "no such table error" using sqlite-odbc driver
1884 code closed 2006 Jul anonymous   2009 Oct   3 2 pragma table_info caches results from previous query
1901 code closed 2006 Jul anonymous Unknown 2009 Oct adamd 2 2 problem in select request with a alias table
1903 code closed 2006 Aug anonymous   2006 Aug   2 2 LIKE string search sometimes fails
1928 new closed 2006 Aug anonymous Parser 2009 Oct   2 2 NULL rowid in views and subqueries
1946 code closed 2006 Aug anonymous Unknown 2009 Oct   2 2 .read file fails on blob fields with end-of-file char
1952 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 Memory leak in select with duplicate colum names
1960 code closed 2006 Sep anonymous   2009 Oct   4 2 Issues with .import in sqlite.exe
1962 new closed 2006 Sep anonymous   2006 Sep   4 2 sqlite3_column_value() not exported
1963 new closed 2006 Sep anonymous   2006 Sep   2 2 sqlite3_aggregate_context() should be improved
1967 code closed 2006 Sep anonymous Unknown 2006 Sep   3 2 Degrade of INSERT performance between 3.3.4 and 3.3.6/3.3.7
1968 code closed 2006 Sep anonymous Unknown 2006 Sep   1 2 sqlite3_column_type() returns 1 instead of 0 since 3.3.7
1969 code closed 2006 Sep anonymous   2006 Sep   3 2 Degrade of INSERT performance between 3.3.4 and 3.3.6/3.3.7
1973 code closed 2006 Sep anonymous Parser 2006 Nov   1 2 sqlite3_prepare (DLL 3.3.7) exception in two programs
1983 code closed 2006 Sep anonymous   2009 Oct   2 2 I/O Error at a size of 4GB and auto_vacuum=1
1988 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 linker error wih SQLITE_OMIT_VIRTUALTABLE
1989 build closed 2006 Sep anonymous Unknown 2006 Sep a.rottmann 2 2 100's daily in XP temp folder-Cannot delete w/out reboot-Stop create?
2011 code closed 2006 Oct anonymous   2009 Oct   3 2 Escaping Porblem with .mode insert (double apostrophe)
2028 code closed 2006 Oct anonymous   2009 Oct   4 2 FTS1: UNIQUE() expression and UPDATE command not working
2066 code closed 2006 Nov anonymous   2009 Oct   2 2 Incorrect error message in the case of ENOLCK
2103 secure closed 2006 Dec anonymous   2006 Dec   2 2 No bound check for the insert string data!
2138 code closed 2007 Jan anonymous   2007 Jan   1 2 COLLATE and multiple order by problem
2142 build closed 2007 Jan anonymous   2007 Jan   2 2 make fails on cygwin
2146 code closed 2007 Jan anonymous   2007 Jan   1 2 Correlated subqueries as columns of select return a syntax error
2157 code closed 2007 Jan anonymous   2007 Jan   1 2 Profile called back too many times if a prepare_v2 statement is reused
2158 code closed 2007 Jan anonymous   2007 Jan   1 2 SCHEMA error still returned if SQL becomes invalid
2215 code closed 2007 Feb anonymous   2009 Oct   1 2 error messages in virtual table are not propagated
2219 code closed 2007 Feb shess   2009 Oct shess 2 2 Creating an fts table in an attached database works wrong.
2244 code closed 2007 Feb anonymous   2007 Feb danielk1977 1 2 xUpdate in virtual table being called when no record exists
2288 code closed 2007 Apr anonymous   2009 Oct   4 2 FTS does not support REPLACE
2293 code closed 2007 Apr anonymous   2007 Apr   2 2 Extra file operations with sub journal when DB in MEM
2330 code closed 2007 May anonymous   2007 May drh 2 2 Usage of fieldname Session is impossible for where clause
2351 secure closed 2007 May anonymous   2009 Oct   2 2 UTF-16 convertor accepts malformed UTF-8 sequence
2357 code closed 2007 May anonymous   2007 Jun anonymous 2 2 Crash in sqlite3PagerClose when SQLITE_ENABLE_MEMORY_MANAGEMENT is def
2367 code closed 2007 May anonymous   2007 May   2 2 SQLITE_OMIT_INCRBLOB breaks default "make test"
2370 code closed 2007 May anonymous   2007 May   3 2 Data is converted without me telling it to do so
2378 code closed 2007 May anonymous   2009 Oct   2 2 Quoted fields come back corrupted, using GROUP BY
2419 build closed 2007 Jun anonymous   2009 Oct   1 2 'CP_UTF8' : undeclared identifier when trying to build the dll
2440 code closed 2007 Jun rse   2009 Jan   2 2 pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS
2457 build closed 2007 Jun anonymous   2009 Oct drh 1 2 Build fails with internal compiler error (Windows, MS VC++ 6.0)
2473 warn closed 2007 Jun anonymous   2009 Oct anonymous 3 2 sqlite memory org. on linux
2478 code closed 2007 Jun anonymous   2007 Jun   2 2 LIMIT and OFFSET abbreviation to LIMIT x,y bug!
2485 code closed 2007 Jul anonymous   2007 Jul   1 2 SQLite + Python segfaults at various places in the code
2497 code closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_errcode does not return the proper error code
2498 code closed 2007 Jul anonymous   2009 Oct   3 2 sqlite memory org on linux
2506 new closed 2007 Jul anonymous   2009 Oct   3 2 New API to retrieve ROWID from SQLite3_stmt structire
2511 code closed 2007 Jul anonymous   2009 Oct drh 3 2 Inconsistent Pragma output
2513 code closed 2007 Jul anonymous   2007 Jul   1 2 Internal compiler error tclsqlite.c
2527 doc closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_create_module() API documentation missing
2539 code closed 2007 Jul anonymous   2009 Oct   2 2 WinCE: Temporary etilqs_ files are not removed from temporary folder
2567 build closed 2007 Aug anonymous   2009 Oct   3 2 Build fails to install
2569 code closed 2007 Aug anonymous   2007 Aug   3 2 Executing a statement causes an AccessViolation Exception
2580 code closed 2007 Aug anonymous   2009 Oct anonymous 1 2 Can't open a query if text to search is Greek
2584 new closed 2007 Aug anonymous   2007 Aug   1 2 On Windows function sqlite3WinSleep needs to dispatch messages
2590 todo closed 2007 Aug anonymous   2007 Aug danielk1977 2 2 return value of strftime('%s', 'now') being determined as 'text'
2596 code closed 2007 Aug anonymous   2007 Aug   2 2 wrong specifier for extern char arrays
2625 build closed 2007 Sep anonymous   2007 Sep   2 2 http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet has problem
2627 code closed 2007 Sep anonymous   2009 Oct   3 2 Improper parsing of nested JOIN
2630 code closed 2007 Sep anonymous   2007 Oct a.rottmann 2 2 sqlite3PagerOpen set a wrong temp file name in pPager->zFilename
2635 code closed 2007 Sep anonymous   2007 Sep   3 2 problem with calculation of juliand date
2639 code closed 2007 Sep anonymous   2007 Oct   1 2 Russian charset
2708 code closed 2007 Oct anonymous   2008 Jun   4 2 SQL error:disk I/O error
2724 code closed 2007 Oct anonymous   2007 Dec drh 2 2 Load Ext api missing error_toobig function.
2730 code closed 2007 Oct anonymous   2007 Oct anonymous 3 2 Can't compile for WindowsCE
2736 build closed 2007 Oct anonymous   2009 Oct   2 2 build problems on freebsd
2759 code closed 2007 Nov anonymous   2007 Nov danielk1977 1 2 crash due to 'select * from virtualTable where x is null'
2764 todo closed 2007 Nov anonymous   2007 Nov   2 2 Since I installed Leopard I keep getting sqlite3 data bases in trash
2779 code closed 2007 Nov anonymous   2007 Nov   2 2 Performance optimizations
2790 code closed 2007 Nov anonymous   2007 Nov danielk1977 2 2 sqlite3_compile returns NULL for empty statements
2808 doc closed 2007 Nov anonymous   2009 Oct   4 2 Documentation GIF images take up too much space
2828 code closed 2007 Dec anonymous   2007 Dec   1 2 SQLITE_OMIT_SUBQUERY compile error: sqlite3CodeSubselect() missing.
2837 code closed 2007 Dec anonymous   2007 Dec   2 2 can't build testfixture in latest CVS
2857 code closed 2007 Dec anonymous   2009 Dec   2 2 GROUP BY cost estimate wrong with WHERE clause
2859 code closed 2007 Dec anonymous   2009 Oct drh 3 2 Inconsistent column names with DISTINCT
2865 code closed 2007 Dec anonymous   2008 Jun   1 2 FTS3 does not build with amalgamation in CVS
2867 code closed 2008 Jan anonymous   2009 Oct   2 2 doesn't build on Cygwin - wrong sqlite3 exe suffix
2875 code closed 2008 Jan anonymous   2009 Oct   3 2 LIKE does not work with lowercase swedish characters
2889 build closed 2008 Jan anonymous   2008 Jan   3 2 Cannot disable TCL
2903 code closed 2008 Jan anonymous   2009 Oct   2 2 tclinstaller.tcl fails on path and permissions issue
2906 code closed 2008 Jan anonymous   2008 Jan anonymous 2 2 Error in MSVC v.6.0 (optimization: Maximize Speed mode)
2910 new closed 2008 Jan anonymous   2008 Jan   1 2 Number of rows in result set - new API
2911 code closed 2008 Jan anonymous   2009 Oct   2 2 Adding parentheses to a FROM clause
2962 code closed 2008 Feb anonymous   2008 Apr   2 2 64 bit integer support could be better.
2976 build closed 2008 Mar anonymous   2009 Oct   1 2 Can't link against SQLite when build for ARM9 with uClibc
3000 code closed 2008 Mar anonymous   2008 Mar   1 2 Rejects "Group" as column name
3007 new closed 2008 Mar anonymous   2009 Oct drh 3 2 Optional journal creation flag
3023 code closed 2008 Mar anonymous   2008 Mar   2 2 NUMERIC datatype error, with UNION ALL, TOTAL and SELECT
3044 warn closed 2008 Apr anonymous   2009 Oct   3 2 Using insecure function on Windows.
3057 code closed 2008 Apr anonymous   2009 Oct   1 2 VC6 optimization code results in: SQL logic error or missing database
3092 code closed 2008 May anonymous   2008 May   2 2 Query on nested union view returns garbage (regression)
3103 code closed 2008 May anonymous   2008 May   4 2 Core Dump on command .show on Solaris 9
3104 new closed 2008 May anonymous   2009 Oct   2 2 Patch that fixes some problems with mutex_w32.c implementation
3116 build closed 2008 May anonymous   2009 Oct   1 2 sqlite-3.5.9 Fedora FC8 has 40 test failures
3125 build closed 2008 May anonymous   2009 Oct   3 2 loadextension must link with libdl
3130 code closed 2008 May anonymous   2009 Oct danielk1977 1 2 MJ file still created with pragma journal_mode=off
3133 todo closed 2008 May anonymous   2009 Oct   1 2 Erratic behaviour of select command for FTS virtual table
3163 code closed 2008 Jun anonymous   2009 Oct   1 2 Column name resolution in nested SELECT in WHERE-clause
3168 code closed 2008 Jun anonymous   2008 Jun   1 2 64 bit integral types
3182 build closed 2008 Jun anonymous   2009 Oct   1 2 sqlite3-3_5_9-osx-x86 crashes on startup
3218 code closed 2008 Jul anonymous   2009 Oct   2 2 Patch to Initialize and Delete critical sections at init/shutdown
3237 code closed 2008 Jul anonymous   2009 Oct   1 2 sqlite3HashFindElem called with wrong parameter type -> EXC_BAD_ACCESS
3275 code closed 2008 Aug anonymous   2008 Aug peter 1 2 mem1.c : memory allocation: bad memory block type
3296 code closed 2008 Aug anonymous   2009 Oct   3 2 Compiling under CE (Unicode vs. ANSI)
3302 code closed 2008 Aug anonymous   2008 Aug   2 2 Bug in CREATE TABLE xyz AS SELECT * command.
3307 code closed 2008 Aug anonymous   2008 Aug   2 2 Try to enter a String with the first 2 letters 0e or 0E ( Zero E)
3319 code closed 2008 Aug anonymous   2008 Aug   3 2 Incorrect references to SQLITE_MAX_ATTACH in main.c
3350 code closed 2008 Sep anonymous   2008 Sep   1 2 can't compile 3.6.2 with VC6
3355 new closed 2008 Sep anonymous   2008 Sep   2 2 Multi-instance support of SQLite Engine
3365 build closed 2008 Sep anonymous   2008 Sep   3 2 new SQLITE_DEPRECATED and SQLITE_EXPERIMENTAL on MSVC6
3375 code closed 2008 Sep anonymous   2009 Jan   1 2 unknown errno code ENOTSUP used
3378 code closed 2008 Sep anonymous   2009 Oct   3 2 ORDER BY broken in substr query
3434 code closed 2008 Oct anonymous   2008 Oct shazow 1 2 crask sqlite with statment "create table " with
3448 code closed 2008 Oct anonymous   2008 Oct   3 2 References to ASCII windows routines are not WINCE-guarded
3513 code closed 2008 Nov anonymous   2008 Nov   2 2 SQLite crashes with simple invalid SELECT statement.
3520 code closed 2008 Dec anonymous   2009 Oct   3 2 sqlite3_update_hook isn't called
3525 build closed 2008 Dec anonymous   2009 Oct   2 2 sqlite3's tcl interface does not build with Tcl 8.6 (patch)
3535 code closed 2008 Dec anonymous   2008 Dec   2 2 PRIMARY KEY constraint not enforced in case of null values
3540 todo closed 2008 Dec anonymous   2008 Dec   1 2 Impossible to determine field type INTEGER PRIMARY KEY using PRAGMA
3543 code closed 2008 Dec anonymous   2008 Dec   2 2 Crash bug in icuOpen()
3572 code closed 2009 Jan anonymous   2009 Oct   2 2 BusyTimeout is not being used.
3632 event closed 2009 Feb anonymous back 2009 Feb   1 2 Temporary tables are bound on reconnection
3661 code closed 2009 Feb anonymous front 2009 Feb   1 2 ADD COLUMN produces fatal error on a particular table.
3684 code closed 2009 Feb anonymous   2009 Feb   2 2 db size quadruplicated
3707 code closed 2009 Mar anonymous func 2009 Mar   1 2 SUBSTR is returning 1 character less than it should
3717 code closed 2009 Mar anonymous ext 2009 Jun   2 2 Crash when querying fts3 for MATCH '""'
3746 code closed 2009 Mar anonymous front 2009 Mar   1 2 Bus Error on CREATE TABLE
3776 code closed 2009 Apr anonymous cli 2009 Apr anonymous 3 2 when use 'case' in a view, the where subclause is type awared
3826 code closed 2009 Apr anonymous vfs 2009 Oct   2 2 sqlite3VXPrintf optimization suggestions
3855 code closed 2009 May anonymous func 2009 May shane 2 2 Problem width compatibility version 3.6.14 width 3.6.13 (<)
3874 xplatform closed 2009 May anonymous   2009 Oct   3 2 Missing proper file locking on Hurd
3880 code closed 2009 May anonymous vfs 2009 Oct   1 2 incorrect return value when delete journaling file on WCE.
3948 new closed 2009 Jul anonymous func 2009 Jul   5 2 Add contextRealloc function similar to contextMalloc
3955 build closed 2009 Jul anonymous   2009 Oct   3 2 Compilation errors on GCC4.4.0 (My case: MinGW32)
3967 code closed 2009 Jul anonymous func 2009 Jul anonymous 3 2 sqlite3_mprintf
3983 code closed 2009 Jul sdwilsh build 2009 Jul   2 2 SQLITE_API not used in sqlite3.h
3993 warn closed 2009 Jul anonymous   2009 Sep   2 2 warnings in 3.6.16
3994 code closed 2009 Jul anonymous   2009 Oct   2 2 REPLACE statements fail on FTS3 tables when data already exists
4004 new closed 2009 Jul anonymous   2009 Nov   5 2 Implement a "counter" SQL function
4012 new closed 2009 Aug anonymous back 2009 Oct   3 2 Drop tables/indexes in the presence of active statements
4016 build closed 2009 Aug anonymous build 2009 Aug   3 2 `make install` rebuilds SQLite
4019 build closed 2009 Aug anonymous build 2009 Oct   3 2 Configure clean is not enough
4045 doc closed 2009 Dec anonymous   2009 Dec   3 2 Missing documentation for "PRAGMA ignore_check_constraints"
3 code closed 2002 Mar anonymous Parser 2002 May   1 1 Rejects "view" as column name
6 code closed 2002 Apr danielk1977 CodeGen 2002 May   1 1 Query optimizer does not consider function arguments
8 code closed 2002 Apr danielk1977 CodeGen 2002 May   2 1 More problems with where.c
10 code closed 2002 Apr drh VDBE 2002 May   1 1 Stack grows without bound on UPDATE OR IGNORE
11 code closed 2002 Apr drh CodeGen 2002 May   1 1 Wrong number of inserts reported after an IGNORE
18 event closed 2002 Apr anonymous   2002 Apr drh 1 1 The sqlite server does not run under windows xp
20 code closed 2002 Apr anonymous   2002 Apr drh 1 1 Order By clause not sorting correctly for string columns
21 code closed 2002 Apr anonymous Shell 2002 May   1 1 2.4.8 SQLITE.EXE: out of memory! (Windows98)
22 code closed 2002 Apr anonymous   2002 Sep drh 2 1 compound selects as expressions
23 code closed 2002 Apr anonymous   2003 Aug drh 1 1 FieldName Returned Not Correct When Use Fast-East Chararctor Set
25 code closed 2002 Apr anonymous   2002 Apr drh 1 1 continu ticket 23, I Direct Access Sqlite.dll
28 code closed 2002 Apr anonymous   2002 Sep drh 3 1 sqlite_changes not exported in sqlite.def in SQLite_source.zip
32 code closed 2002 May drh   2002 Sep   1 1 Columns in views are not always named correctly.
33 code closed 2002 May drh CodeGen 2002 Sep   1 1 Segfault when a VIEW contains a compound SELECT with an ORDER BY
34 code closed 2002 May drh CodeGen 2002 Sep   1 1 Segfault when a VIEW contains an ORDER BY clause
35 code closed 2002 May drh CodeGen 2002 Sep   1 1 An ORDER BY clause on a subquery causes a segfault
39 todo closed 2002 May drh   2002 Sep   5 1 Reformat the TRIGGER code for consistent style.
42 doc closed 2002 May drh   2002 Sep   1 1 Add comments to Trigger structures in sqliteInt.h
43 event closed 2002 May anonymous   2008 Mar drh 1 1 sqlite compile without readline on linux slackware 8.0
48 doc closed 2002 May anonymous   2008 Jun drh 1 1 use sqlite from a tclsh.exe
49 code closed 2002 May drh CodeGen 2002 Sep   2 1 DELETE Trigger causes extra rows to be deleted
61 new closed 2002 Jun anonymous   2002 Jun   1 1 Enhancement Request: Capability to Specify Table Join Type
72 code closed 2002 Jun anonymous   2002 Sep   1 1 malloc test in testbed fails Win32 build of 2.4.12
73 code closed 2002 Jun drh CodeGen 2002 Sep drh 1 1 ORDER BY clause is ignored on subqueries
75 code closed 2002 Jun drh CodeGen 2002 Sep   1 1 Auto-increment not working on an INSERT from a SELECT
78 code closed 2002 Jun drh CodeGen 2002 Sep   1 1 Assertion failure when closing database in the middle of a transaction
79 code closed 2002 Jun drh   2002 Sep   1 1 Tables are not being dropped correctly under certain circumstances.
83 todo closed 2002 Jun drh   2002 Sep drh 1 1 Add test cases
84 code closed 2002 Jun drh   2002 Sep   1 1 Complex left outer joins might give the wrong answer
85 todo closed 2002 Jun drh   2003 Apr   1 1 Document and test the sqlite_open_aux_file() API.
90 code closed 2002 Jul anonymous   2002 Sep   1 1 table aliases in select commands stopped working
94 code closed 2002 Jul drh Pager 2002 Sep   1 1 ROLLBACK fails to restore all pages
95 code closed 2002 Jul drh CodeGen 2002 Sep   1 1 DROP INDEX on an automatically created internal index is allowed
96 todo closed 2002 Jul drh   2009 Oct drh 1 1 Handle problems resulting from fork()
98 todo closed 2002 Jul drh   2009 Oct drh 1 1 Document and test TEMPORARY views
99 todo closed 2002 Jul drh   2002 Sep   1 1 Document and export the sqlite_mprintf() API.
102 code closed 2002 Jul drh   2002 Sep   1 1 ORDER BY ignored in subquery
103 code closed 2002 Jul anonymous   2002 Jul   2 1 Memory Leak in the Server
105 code closed 2002 Jul anonymous CodeGen 2002 Sep   2 1 Assertion fails on UPDATE of indexed table with subquery in WHERE
106 code closed 2002 Jul anonymous   2002 Jul   1 1 Bad handling of nulls
107 code closed 2002 Jul anonymous   2002 Sep   1 1 Incorrect query results
108 code closed 2002 Jul anonymous   2002 Sep   1 1 Sqlite's Windows Dll Version Still Is 2.56
116 code closed 2002 Jul anonymous   2002 Jul   1 1 run err with Hint Call msvcrt.dll.
117 code closed 2002 Jul anonymous   2002 Jul   1 1 run err with Hint Call msvcrt.dll.
118 code closed 2002 Jul anonymous   2002 Jul   1 1 Under WinNT4.04 Call Opendatabase or Else Function Generate Error
120 code closed 2002 Jul anonymous   2002 Jul   1 1 Strange comparison logic
121 code closed 2002 Jul anonymous   2002 Jul   1 1 Bug LEFT JOIN - GROUP BY
124 code closed 2002 Jul anonymous Unknown 2002 Sep anonymous 2 1 Segfault on a join using an INTEGER PRIMARY KEY.
125 code closed 2002 Jul anonymous   2002 Jul   2 1 Data and Category SELECT bug
145 code closed 2002 Aug anonymous Unknown 2002 Aug   1 1 Tests failing
156 code closed 2002 Oct anonymous Unknown 2002 Oct   1 1 Cannot log in to CVSTraq because no "create account page"
161 code closed 2002 Oct anonymous Unknown 2003 Dec   1 1 Left join with 3 tables bug ?
165 code closed 2002 Oct anonymous VDBE 2002 Oct anonymous 1 1 can create and change tickets, without logged in
180 event closed 2002 Oct anonymous   2009 Oct anonymous 1 1 on WIN32 - multithreaded process causes crash on assert(mutext)
182 event closed 2002 Oct anonymous Unknown 2002 Oct   1 1 Win32 DBI Interface crashes Perl.exe
183 code closed 2002 Oct anonymous   2002 Nov drh 1 1 Bug regarding grouping, left joining, aggregate functions
188 todo closed 2002 Nov drh   2002 Nov   1 1 Serialize disk I/O
201 doc closed 2002 Dec anonymous Unknown 2003 Nov   1 1 it is very well if there is a table lock! but ...
203 new closed 2002 Dec anonymous Unknown 2009 Oct anonymous 2 1 Missing Win32 open flag if shared database
204 event closed 2002 Dec anonymous Unknown 2008 Jun anonymous 1 1 Select statement takes hours (or more!)
207 event closed 2002 Dec anonymous Shell 2008 Jun   2 1 After installation cannot create any databases
209 new closed 2002 Dec anonymous BTree 2008 Jun   1 1 update libtool
214 code closed 2003 Jan anonymous Unknown 2003 Jan   1 1 segmentation fault on ETRAX board - started in version 2.7.4
216 new closed 2003 Jan anonymous   2009 Oct   1 1 Add "DISTINCT ON()" clause to specify the fields to apply the unicity
228 event closed 2003 Jan anonymous Unknown 2003 Jan drh 1 1 The size of database file is not decreased .
235 new closed 2003 Jan anonymous Unknown 2008 Jun chw 5 1 Local language do not support!
251 code closed 2003 Feb anonymous   2003 Mar   1 1 ORDER BY doesn't work on TIMESTAMP column type
252 new closed 2003 Feb anonymous   2009 Oct   4 1 Add optional regex matching similar to what Postgres & Oracle have
253 event closed 2003 Feb anonymous   2009 Oct   1 1 make install does not work with install-sh script
254 event closed 2003 Feb anonymous   2009 Oct   1 1 make test does not work on HP64 (B11.11)
255 event closed 2003 Feb anonymous   2009 Oct   1 1 Database locked on HP64 (B11.11)
273 new closed 2003 Mar drh CodeGen 2009 Oct drh 1 1 Make NULL_ALWAYS_DISTINCT a pragma rather than a compile-time option
283 code closed 2003 Apr anonymous Parser 2003 Apr   3 1 Defect in sqlite_exec_vprintf
307 event closed 2003 May anonymous Shell 2008 Jun anonymous 1 1 fail to rpm install on redhat 9
319 code closed 2003 May anonymous Unknown 2003 May   1 1 Large Encoded Strings Get Truncated
328 code closed 2003 May anonymous Unknown 2003 May   2 1 Trigger accessing temp table now does not work
338 new closed 2003 Jun anonymous Unknown 2009 Oct   5 1 lowerFunc and upperFunc Fail on foreign characters
343 new closed 2003 Jun anonymous Parser 2003 Jun   3 1 insert single quote value in SQL statement
344 event closed 2003 Jun anonymous   2003 Jun   1 1 select
358 code closed 2003 Jun anonymous Unknown 2003 Jun   1 1 Problems with inserting file (.bmp; .jpg) in BLOB field
359 code closed 2003 Jun anonymous   2003 Jun   1 1 sum() returns incorrect value
371 event closed 2003 Jul anonymous   2003 Nov   1 1 crash in conflict.test
372 event closed 2003 Jul anonymous Unknown 2003 Jul anonymous 1 1 tcl.h missing in windows source code
374 code closed 2003 Jul anonymous Pager 2003 Jul   1 1 btree crash in moveto - sqlitepager_get
379 new closed 2003 Jul anonymous   2003 Jul   5 1 use \' and \" instead of '' and "" only
386 new closed 2003 Jul anonymous   2008 Jun   5 1 compile on WinCE ?
388 code closed 2003 Jul anonymous Unknown 2003 Jul   2 1 sqlite-2.8.4.tar.gz doesn't have the Constants.java file
389 event closed 2003 Jul anonymous Shell 2003 Jul   1 1 Undefined symbol
392 event closed 2003 Jul anonymous Shell 2003 Jul anonymous 1 1 Unable to link libsqlite.so file on SunOS 5.8
409 event closed 2003 Jul anonymous Unknown 2008 Jun anonymous 3 1 sqlite_open will cause segfault when using Rational PurifyPlus/Linux
411 todo closed 2003 Jul anonymous   2009 Oct drh 1 1 support for sign function in select
412 new closed 2003 Jul anonymous Unknown 2009 Oct drh 1 1 sign function: quick hack for func.c (hope this helps)
413 new closed 2003 Jul anonymous   2009 Oct   5 1 SQL_CALC_FOUND_ROWS & FOUND_ROWS() not supported
422 code closed 2003 Aug anonymous Unknown 2003 Dec   4 1 Memory leak in src/build.c
423 code closed 2003 Aug anonymous Unknown 2003 Dec   1 1 'data schema has been changed error' how will overcome this
436 code closed 2003 Aug drh BTree 2003 Aug drh 1 1 In-memory database backend segfaults on recursive access
441 code closed 2003 Sep anonymous Parser 2003 Dec drh 1 1 Cannot find table under Managed C++
445 build closed 2003 Sep anonymous Unknown 2008 Jun anonymous 3 1 Compilation problem on MinGW
451 build closed 2003 Sep anonymous   2009 Oct   1 1 Makefile fails on FreeBSD
456 build closed 2003 Sep anonymous   2008 Jun anonymous 1 1 compilation problem under winnt 4 using Lcc-win32
457 new closed 2003 Sep anonymous   2008 Jun   1 1 Ported to NetWare
462 event closed 2003 Sep anonymous   2008 Jun   2 1 list index out of bounds(1)
463 event closed 2003 Sep anonymous   2008 Jun   2 1 list index out of bounds(1)
467 code closed 2003 Sep anonymous Unknown 2003 Oct   2 1 Problem with renaming fields
471 code closed 2003 Oct anonymous Parser 2003 Oct   5 1 Parser accepts faulty SQL
474 code closed 2003 Oct anonymous Unknown 2003 Oct   4 1 Problem with showing the datatypes of columns of a empty table
475 code closed 2003 Oct anonymous   2003 Oct   1 1 question:how to use the sqlite in my VC6 project?
495 build closed 2003 Nov anonymous   2008 Jun   1 1 Makefile syntax errors
496 build closed 2003 Nov anonymous   2008 Mar   1 1 SQLite Ignores Autoconf Options
506 code closed 2003 Nov anonymous   2003 Nov   2 1 Result tuple not formed correctly on select query
511 code closed 2003 Nov anonymous VDBE 2003 Nov   1 1 confused error of nested calling of "sqlite_compile"
516 code closed 2003 Dec anonymous Parser 2003 Dec   1 1 unrecognized token error when a string contains a \' escape sequence
517 new closed 2003 Dec anonymous Parser 2009 Oct drh 1 1 \' sequence unrecognized token error enhancement request
522 code closed 2003 Dec anonymous Unknown 2003 Dec   1 1 Error in comparision equal and less-equal
524 new closed 2003 Dec anonymous Unknown 2009 Oct   2 1 port of sqlite to dos with short file names
535 code closed 2003 Dec anonymous Unknown 2003 Dec   1 1 Use of uninitialised value of size 4
536 code closed 2003 Dec anonymous Pager 2003 Dec   1 1 Syscall param write(buf) contains unaddressable byte(s)
549 code closed 2004 Jan anonymous Shell 2004 Jan   1 1 number of week change in wendesday/thursday
550 new closed 2004 Jan anonymous Unknown 2009 Oct anonymous 1 1 change of MASTER_NAME and TEMP_MASTER_NAME definition error
554 code closed 2004 Jan anonymous Unknown 2004 Jan   3 1 sqlite_close SQLITE_MAGIC_ERROR
555 code closed 2004 Jan anonymous VDBE 2004 Jan   1 1 sqlite_step and sqlite_compile cause locking problem
557 code closed 2004 Jan anonymous Unknown 2004 Jan   3 1 sqlite_close SQLITE_MAGIC_ERROR reply.
559 code closed 2004 Jan anonymous Unknown 2008 Mar   1 1 Very slow insert into ... under Win2K
571 code closed 2004 Jan anonymous Unknown 2004 Jan   1 1 Execution of comment via sqlite_step raise Access violation
579 code closed 2004 Jan anonymous   2004 Jan   3 1 condition where sqlite_decode_binary will return -1
581 code closed 2004 Jan anonymous Parser 2004 Jan   3 1 Failure for lemon.c to compile on MacOSX (fixed as well ;-))
584 new closed 2004 Jan anonymous   2004 Jan anonymous 5 1 Cursor support in SQLite
585 code closed 2004 Jan anonymous   2004 Jan   1 1 sqlite is not thread safe
586 code closed 2004 Jan anonymous   2004 Jan   2 1 Memory allocation problem ?
592 event closed 2004 Feb anonymous Unknown 2009 Oct   1 1 VIEW produces strange result set
596 code closed 2004 Feb anonymous   2004 Feb   1 1 sqlite_exec OR sqlite_get_table can not handle empty results sets
600 code closed 2004 Feb anonymous   2004 Feb   1 1 unable to open database file, win32, Java jdbc
606 code closed 2004 Feb anonymous   2004 Feb   1 1 odbc doesn't like datetime type - returns a null
607 code closed 2004 Feb anonymous   2004 Feb   1 1 odbc doesn't like field name date
616 code closed 2004 Feb anonymous VDBE 2004 Feb   1 1 variable 'db' is not initialized before being used (expr.c line 418)
619 code closed 2004 Feb anonymous   2004 Feb   1 1 Multiple BEGIN and COMMIT transaction problem...
624 new closed 2004 Feb anonymous   2004 Feb   1 1 SQLite transaction...
625 code closed 2004 Feb anonymous   2004 Feb   1 1 CORE DUMPED when running sum() in DBD::SQLite
630 code closed 2004 Feb anonymous   2004 Feb   1 1 using uninitialized variable
633 build closed 2004 Feb anonymous   2008 Jun   1 1 new build system does not run correctly under MinGW/MSYS
636 new closed 2004 Mar anonymous Unknown 2004 Mar   1 1 Retaining autoincrement (Primary key) generated values
639 event closed 2004 Mar anonymous   2004 Mar   1 1 Why fixed tickets are not closed ?
642 code closed 2004 Mar anonymous Shell 2004 Mar   1 1 Problem when adding a SQL string on the command line - THIS IS REAL!!
649 code closed 2004 Mar anonymous Shell 2004 Mar   1 1 sqlite-2.8.12 segmentation fault in shell command-line usage
653 code closed 2004 Mar anonymous Unknown 2004 Mar   1 1 sqlite db 'create table t(f)' dumps core
657 code closed 2004 Mar anonymous Unknown 2004 Mar   1 1 Wrong reported columncount in CallBack routine
672 warn closed 2004 Mar anonymous Unknown 2004 Mar   1 1 THE DLL FILE FOR WINDOWS IS CURRUPTED
675 code closed 2004 Mar anonymous   2004 Mar   2 1 Malformed error at GET BLOB DATA from database file
676 build closed 2004 Mar anonymous   2009 Oct   1 1 Problem with Makefile
678 code closed 2004 Mar anonymous Unknown 2004 Jul anonymous 1 1 Group by only returning one row when source table is sub-query or view
679 code closed 2004 Mar anonymous Unknown 2006 Jan a.rottmann 2 1 database closed
681 build closed 2004 Apr anonymous CodeGen 2004 Apr   1 1 undefined reference to 'sqlite_open'
682 new closed 2004 Apr anonymous   2009 Oct   5 1 sqlite_aggregate_context() valid in xFunc callback routine
688 code closed 2004 Apr anonymous   2004 Apr   1 1 Scope problem in subselect
691 code closed 2004 Apr anonymous Unknown 2009 Oct drh 1 1 OS X File Sharing
693 build closed 2004 Apr anonymous   2004 Apr   1 1 Compiling for freeBSD
696 code closed 2004 Apr anonymous TclLib 2005 Jan   1 1 tclsqlite does not build on RH 7.3
706 build closed 2004 Apr anonymous Unknown 2004 Apr   1 1 undefined reference
709 code closed 2004 Apr anonymous Unknown 2009 Oct drh 1 1 Unable to unregister or replace functions
720 event closed 2004 May anonymous   2009 Oct   1 1 Write problem on MS Windows 98
722 code closed 2004 May anonymous VDBE 2004 Jul drh 2 1 long long format specifier in sqlite_exec_printf missing
738 new closed 2004 May anonymous   2009 Oct danielk1977 4 1 Sort order array in memory
739 new closed 2004 May anonymous Unknown 2009 Oct danielk1977 3 1 Suggestion speed query
740 code closed 2004 May anonymous BTree 2004 May   1 1 Unable to compile on Fedora core 1
759 event closed 2004 Jun anonymous Unknown 2004 Jun a.rottmann 2 1 record can't be inserted
764 code closed 2004 Jun drh   2004 Jun drh 1 1 ROLLBACK disables TEMP triggers.
767 new closed 2004 Jun anonymous   2004 Jun   1 1 Metadata of query
775 code closed 2004 Jun anonymous Unknown 2004 Aug   1 1 windows sqlite3.dll corrupt?
776 code closed 2004 Jun anonymous   2005 Jan   1 1 sqlite says Database is locked when database file is on Novel disk
779 code closed 2004 Jun anonymous   2004 Jun   4 1 duplicated declaration of sqlite3_changes() in sqlite.h.in
788 build closed 2004 Jun anonymous TclLib 2004 Jun   1 1 3.0.1 make test failure/death on Mac OS X 10.2.8
790 code closed 2004 Jul anonymous   2004 Jul   1 1 Missing include file for the SQLITE distribution 3.0.x
792 code closed 2004 Jul anonymous   2004 Sep   1 1 ODBC support is broken for 3.0.2
798 code closed 2004 Jul anonymous Unknown 2009 Oct   1 1 Unable to run tests on Tru64 bit Linux platform
802 warn closed 2004 Jul anonymous   2009 Oct anonymous 1 1 Unable to compile the sqlite
803 new closed 2004 Jul anonymous Unknown 2004 Jul drh 1 1 sqlite3_create_function needs a userdata parameter
808 code closed 2004 Jul anonymous Unknown 2004 Jul   1 1 Lower() function with UNICODE
809 code closed 2004 Jul anonymous   2004 Jul   2 1 Sqlite also fetches the hooks
814 todo closed 2004 Jul anonymous Unknown 2005 Jan anonymous 1 1 How can I get the recent bug-fixed branch version 2?
815 build closed 2004 Jul anonymous   2008 Jun   2 1 SQLite3.dll exports
830 code closed 2004 Jul anonymous   2004 Jul   1 1 sqlite3_get_table() error
836 code closed 2004 Aug anonymous   2004 Aug   1 1 sqlite3_prepare() fails when a temp table does not yet exists.
840 code closed 2004 Aug anonymous   2005 Jan   1 1 Query returns invalid results (Index problem?).
846 code closed 2004 Aug anonymous Parser 2004 Aug   1 1 error(1) at dbdimp.c line 250 [for Statement "PRAGMA table_info(?)"]
847 code closed 2004 Aug anonymous Unknown 2005 Jan   4 1 sqlite3_changes doesn't reset to zero after inserts
849 code closed 2004 Aug anonymous Parser 2004 Sep   1 1 error(1) for Statement "PRAGMA table_info(?)"
850 code closed 2004 Aug anonymous   2004 Aug   1 1 quoted table names not allowed in combination with *
854 code closed 2004 Aug anonymous Unknown 2004 Aug anonymous 3 1 Index don't work with NULL field
856 code closed 2004 Aug anonymous   2004 Aug   1 1 memory leak within sqlite3_open()/sqlite3_close() pair
861 code closed 2004 Aug anonymous Unknown 2004 Sep anonymous 1 1 SqLite is accent-sensitive?
865 build closed 2004 Aug anonymous Unknown 2009 Oct   1 1 Building problems with v3.0.3 and v3.0.4 on Fedora Core 2
868 doc closed 2004 Aug anonymous   2004 Aug   1 1 Conflict resolution fails when attempting to create duplicate key
880 code closed 2004 Sep anonymous   2004 Sep   1 1 dropping a temporary table locks the database
882 code closed 2004 Sep anonymous Parser 2004 Sep   1 1 crash on insert
884 new closed 2004 Sep anonymous Parser 2004 Sep   5 1 Allow read only transactions.
909 code closed 2004 Sep anonymous Unknown 2004 Oct   1 1 Inconsistent unordered and ordered selects (index corruption?)
916 new closed 2004 Sep anonymous Unknown 2009 Oct   1 1 No delete notification for INSERT OR REPLACE
917 code closed 2004 Sep anonymous VDBE 2004 Sep drh 1 1 bug with named parameters
919 event closed 2004 Sep anonymous Unknown 2009 Oct   1 1 'make test' RESETS macOSX at ioerr 2.73.1
929 code closed 2004 Sep anonymous Parser 2004 Sep   2 1 Inserting duplicate primary key value returns success
951 code closed 2004 Oct anonymous Unknown 2004 Oct   1 1 DBD telling me table doesnt exist
955 warn closed 2004 Oct anonymous Unknown 2009 Oct   1 1 When installing SQLite it says that a file is missing.
957 new closed 2004 Oct ghaering   2004 Oct   1 1 Old callback-based API should still return column types
964 code closed 2004 Oct anonymous Pager 2004 Oct   3 1 Possible segfault from bad call
971 todo closed 2004 Oct anonymous Unknown 2009 Oct peter 2 1 how to recompile sqlite with THREADSAFE preprocessor macro set to 1?
976 code closed 2004 Oct anonymous   2004 Oct   1 1 Locale & upper/lower
981 code closed 2004 Nov anonymous   2005 Jan   1 1 UTF8 characters in database directory or filename not supported
983 code closed 2004 Nov anonymous   2004 Nov   1 1 assert()'s broken on both (some) 32 bit and (most) 64 bit platforms
987 code closed 2004 Nov anonymous TclLib 2009 Jan   1 1 in Tcl, package require sqlite3 fails
990 code closed 2004 Nov anonymous   2005 Jan   1 1 PRAGMA empty_result_callbacks in tclsqlite-3.0.8.so eliminated?
998 event closed 2004 Nov anonymous Unknown 2004 Nov anonymous 2 1 Database table is locked accessing SQLite through QT library.
1000 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 1 1 use popen function and sqlite3_open is dummy..
1005 code closed 2004 Nov anonymous Unknown 2004 Nov   1 1 No error from sqlite3_exec
1013 build closed 2004 Nov anonymous Unknown 2004 Nov peter 1 1 undefined reference to sqlite_open
1017 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 1 1 error while loading shared libraries: /lib/libsqlite.so.0
1024 code closed 2004 Dec anonymous   2004 Dec   1 1 trunk blob data
1037 code closed 2004 Dec anonymous Unknown 2004 Dec   1 1 .Net Interop Problem
1041 code closed 2004 Dec anonymous Unknown 2004 Dec   1 1 select x<2 from table does not work anymore
1064 code closed 2005 Jan anonymous CodeGen 2005 Jan   2 1 problems with queries and aggregate functions
1070 build closed 2005 Jan anonymous CodeGen 2009 Oct   1 1 error by compiling windows vcc / vc# <sqlite.h> not found
1077 code closed 2005 Jan anonymous Shell 2005 Jan   1 1 auto_increment and insert into ~ select
1087 event closed 2005 Jan anonymous Parser 2005 Jan   5 1 CREATE TRIGGER with SQLite3 --> Error "near "WHEN" : syntaxe error
1089 code closed 2005 Jan anonymous Shell 2005 Jan   1 1 Segmentation fault
1090 new closed 2005 Jan anonymous   2009 Jan   1 1 tclinstaller.tcl does not support DESTDIR
1091 code closed 2005 Jan anonymous   2005 Jan   1 1 not the function of ".export TABLE FILE"
1097 new closed 2005 Feb     2005 Feb   4 1 Please provide a numeric version number in sqlite3.h
1098 code closed 2005 Feb anonymous   2005 Feb   1 1 DBs created with PHP and the command line are incompatible
1104 code closed 2005 Feb anonymous VDBE 2005 Feb   1 1 Integer overflow
1106 code closed 2005 Feb anonymous   2005 Feb   2 1 sqlite3FinishCoding is masking errors during parsing
1109 code closed 2005 Feb anonymous BTree 2005 Feb   1 1 assert in btree
1118 build closed 2005 Feb anonymous   2005 Feb   1 1 pa
1132 code closed 2005 Feb anonymous Shell 2005 Feb   1 1 database migration from sqlite 2.8.12 to sqlite 3.0.8
1139 code closed 2005 Feb anonymous Unknown 2005 Mar   1 1 error while loading shared libraries
1141 code closed 2005 Feb anonymous Parser 2005 Apr   4 1 Select rowid for integer primary key does not return rowid
1142 code closed 2005 Feb anonymous Parser 2009 Oct danielk1977 1 1 Column names
1147 code closed 2005 Feb anonymous Parser 2005 Apr   1 1 column names do not respect pragma settings
1149 code closed 2005 Feb anonymous   2009 Oct   2 1 VACUUM, DUMP/RESTORE fail in certain cases
1154 event closed 2005 Mar anonymous VDBE 2005 Mar   1 1 PRIMARY KEY AUTOINCREMENT and TRIGGER problem
1155 doc closed 2005 Mar anonymous   2005 Mar   1 1 how i can get a month from a date with a SELECT
1156 new closed 2005 Mar anonymous Unknown 2005 Mar   3 1 Cant fetch records in between one DATE to another DATE
1157 new closed 2005 Mar anonymous   2005 Mar drh 1 1 Is there a roadmap?
1158 code closed 2005 Mar anonymous VDBE 2009 Oct   1 1 core dump on solaris,
1173 code closed 2005 Mar anonymous   2005 Mar   1 1 C : if there is count(*) in a select then bug
1175 code closed 2005 Mar anonymous Unknown 2005 Mar   1 1 busy handler is not being called
1178 code closed 2005 Mar anonymous VDBE 2005 Mar   1 1 sqlite 3 returns SQLITE_ERROR instead of SQLITE_SCHEMA
1179 code closed 2005 Mar anonymous TclLib 2005 Mar   2 1 Unable to use NULL for an AUTOINCREMENT field in TclSQLite
1189 new closed 2005 Mar anonymous Parser 2009 Oct   1 1 Make where-clause item count limit dynamic
1196 build closed 2005 Apr anonymous   2005 Apr   1 1 out-of memory on powerpc on linux
1197 code closed 2005 Apr anonymous   2005 Apr   1 1 race condition in sqlite3_close
1201 code closed 2005 Apr anonymous CodeGen 2009 Oct danielk1977 1 1 erro defined type UINT8_TYPE
1205 code closed 2005 Apr anonymous Unknown 2009 Oct   3 1 accent ecu etc. in connectionstring
1207 code closed 2005 Apr anonymous   2005 Apr anonymous 2 1 How to Install SQLite
1215 code closed 2005 Apr anonymous   2005 Apr   1 1 PRAGMA table_info and INTEGER UNSIGNED - sqlite3 client
1218 code closed 2005 Apr anonymous Unknown 2005 Apr   2 1 'select rowid' does not return 'rowid' as column title
1230 event closed 2005 Apr anonymous TclLib 2005 May   1 1 coredump in tclsqlite on HPUX 11.11 64 bit
1231 code closed 2005 May anonymous BTree 2005 May   1 1 Solaris9: Bus error, alignment issues
1233 code closed 2005 May anonymous BTree 2005 May   1 1 Triggers assert
1237 code closed 2005 May anonymous   2005 May anonymous 1 1 I like to use SQLite in php
1245 code closed 2005 May anonymous   2005 Jun   3 1 Query causes 'unable to open database' after ~1000 operations
1248 code closed 2005 May anonymous Unknown 2009 Oct   3 1 sqlite3_get_table returns garbage for BLOB data
1268 build closed 2005 May anonymous   2005 May   1 1 /usr/include/sys/context.h:155: parse error before "sigset64_t"
1269 code closed 2005 May anonymous   2005 Jul   1 1 Bus Error during import
1276 code closed 2005 Jun anonymous Pager 2005 Jun   1 1 Failing assertion in pager.c
1281 code closed 2005 Jun anonymous Unknown 2005 Jun   1 1 Errors testing sqlite 3.2.1
1288 code closed 2005 Jun anonymous   2005 Jun   1 1 Win32 Resource leak - InitializeCriticalSection(...)
1290 new closed 2005 Jun anonymous VDBE 2005 Jun drh 1 1 optimize VBDE, reordening ID numbers of OP_????? codes
1293 build closed 2005 Jun anonymous   2009 Oct   1 1 No file .LIB in sqlitedll-3_2_2.zip for links in Windows.
1295 event closed 2005 Jun anonymous Unknown 2009 Oct   1 1 SQL query involving subqueries causes reproduceable segfault in 2.8.14
1305 code closed 2005 Jun anonymous TclLib 2009 Jan   1 1 Tcl installs pkgIndex with wrong path
1307 new closed 2005 Jun anonymous   2005 Aug   1 1 BLOBs and Tcl library (again)
1309 build closed 2005 Jun anonymous   2005 Sep   1 1 make problem
1312 code closed 2005 Jun anonymous Shell 2009 Sep   1 1 CSV file import / export is all wrong!
1323 code closed 2005 Jul anonymous   2009 Oct   1 1 misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped)
1326 code closed 2005 Jul anonymous Unknown 2005 Aug   4 1 using callbacks with two exact queries duplicate results
1329 code closed 2005 Jul anonymous BTree 2005 Jul   5 1 A bug About select from a table
1339 code closed 2005 Jul anonymous   2005 Jul   1 1 Table Create in exists db with exists table = MemoryLeak
1342 code closed 2005 Jul anonymous   2009 Oct   1 1 sqlite 3.2.2 will not load on Suse Linux 9.3
1343 code closed 2005 Jul anonymous   2005 Jul   1 1 segmentation fault on select on view
1344 code closed 2005 Jul anonymous BTree 2005 Aug anonymous 3 1 sqlite does 40 times allocations for a single sql statement
1351 code closed 2005 Aug anonymous Shell 2009 Oct   1 1 Unable to parse UTF8 input
1361 code closed 2005 Aug anonymous Unknown 2005 Sep   1 1 sqlite3_mprintf function(s) don't account for commas with %q flag
1367 new closed 2005 Aug anonymous Shell 2005 Aug peter 1 1 connection string for SQLite with some examples
1377 warn closed 2005 Aug anonymous   2005 Aug dwong 1 1 can't connect to database
1379 warn closed 2005 Aug anonymous Unknown 2009 Oct   1 1 cannot install . phpize failed
1382 code closed 2005 Aug anonymous   2009 Oct drh 1 1 Assert nErr==0 on corrupt db
1383 code closed 2005 Aug anonymous VDBE 2005 Aug   1 1 Whole doubles get a dot zero when promoted to string
1397 code closed 2005 Aug anonymous Shell 2009 Oct   1 1 .mode csv creates ASCII output instead of UTF-8
1404 event closed 2005 Sep anonymous Unknown 2005 Sep   1 1 pragma case_sensitive_like is broken?
1406 code closed 2005 Sep anonymous   2005 Sep   1 1 no result with order by
1408 code closed 2005 Sep anonymous Parser 2005 Sep   1 1 ATTACH DATABASE doesn't support *.db files
1411 code closed 2005 Sep anonymous Shell 2005 Sep anonymous 3 1 how to change database name
1415 code closed 2005 Sep anonymous Unknown 2009 Oct drh 1 1 Querying for BLOB type fields
1416 code closed 2005 Sep anonymous   2005 Sep xdong 1 1 database is same size as before when we do clearing operation.
1422 code closed 2005 Sep anonymous   2005 Sep   1 1 incorrect error codes from sqlite3_errCode
1434 code closed 2005 Sep anonymous   2005 Sep   1 1 .dump dumps sqlite_stat1, which makes it impossible to load dump
1436 code closed 2005 Sep anonymous   2005 Sep   1 1 cvs HEAD does not return rows for a query that works on older versions
1442 code closed 2005 Sep anonymous Parser 2005 Sep   1 1 sqlite3 3.2.6/3.2.2/3.2.1 reproductible crash
1447 code closed 2005 Sep anonymous BTree 2009 Oct   1 1 Abnormal program termination in src/btree.c line 1339
1450 code closed 2005 Sep anonymous Shell 2005 Sep   1 1 Unable to compile on SCO Openserver(gcc)
1457 code closed 2005 Sep anonymous Shell 2009 Oct   3 1 non-latin chars not recognized by CLI
1459 code closed 2005 Sep anonymous   2005 Sep   1 1 Division operation
1463 code closed 2005 Sep anonymous   2005 Sep   3 1 can't see views in browser 1.0
1465 code closed 2005 Oct anonymous CodeGen 2009 Oct   1 1 fdatasync not available and not yet fixed
1469 event closed 2005 Oct anonymous Parser 2009 Oct   1 1 Having problems with subselects that work on mySQL
1482 code closed 2005 Oct anonymous   2005 Oct   1 1 Cannot finish a transaction if a previous transaction was rolled back;
1485 code closed 2005 Oct anonymous Unknown 2009 Oct jshen 3 1 cyrilic problem(suppose Unicode as a whole, for PPC)
1488 code closed 2005 Oct anonymous   2009 Oct   1 1 Collate Reverse does not exists?
1490 code closed 2005 Oct anonymous   2005 Nov   1 1 Create Temp Index has problem
1499 code closed 2005 Oct anonymous   2006 Mar anonymous 3 1 Sqlite 3.2.7 does not support Chinese path.
1511 event closed 2005 Nov anonymous   2005 Nov   1 1 how to use the index with "order by"
1517 code closed 2005 Nov anonymous   2005 Nov   1 1 unable to drop a temporary table when database is locked
1523 code closed 2005 Nov anonymous Shell 2005 Nov danielk1977 5 1 size of database dose not change smaller after delete records
1526 new closed 2005 Nov anonymous   2005 Nov   1 1 Unused data structure fields when trace support is omitted.
1529 code closed 2005 Nov anonymous   2006 May   1 1 can not uses japanese as table name to create table
1530 code closed 2005 Nov anonymous Parser 2005 Nov xdong 2 1 error on where clause with serial-type.
1534 code closed 2005 Nov anonymous   2005 Nov   1 1 error:
1538 code closed 2005 Nov anonymous   2005 Nov   1 1 Access Violation error
1541 code closed 2005 Nov anonymous Unknown 2009 Oct   1 1 Ticket #924 not fixed in the 2.8 branch
1543 build closed 2005 Nov anonymous   2009 Oct   2 1 File encrypted or corrupted while using french characters
1546 code closed 2005 Nov anonymous   2009 Oct   1 1 Creating unique index on non-unique column leads to corr. on SQLite2
1547 event closed 2005 Nov anonymous Unknown 2009 Dec   1 1 slow insert into indexed table and slow index create on huge table
1548 warn closed 2005 Dec     2005 Dec   1 1 Command failed for target `sqlite3'
1551 code closed 2005 Dec anonymous   2005 Dec   1 1 sqlite3_reset seems not to be exported correctly
1556 event closed 2005 Dec anonymous Unknown 2005 Dec anonymous 1 1 database locked if used on mounted nfs shares (linux)
1557 event closed 2005 Dec anonymous Parser 2006 Mar   1 1 sqlite core dumps in exprNodeIsConstant
1561 build closed 2005 Dec anonymous   2005 Dec   3 1 compile sqlite 3.2.7 failed on Unix
1562 warn closed 2005 Dec anonymous Unknown 2009 Oct   3 1 i64 not defined in 32bit compiler
1563 code closed 2005 Dec anonymous   2006 Mar   1 1 The system crash when creating a database!
1568 code closed 2005 Dec anonymous Unknown 2006 Mar   1 1 sqlite3_column_decltype( ) returning BadPointer with "UNION"
1571 code closed 2005 Dec anonymous   2005 Dec   1 1 SQLiteCC crashes when you rollback create table
1579 code closed 2006 Jan anonymous Shell 2006 Jan anonymous 1 1 database locked
1582 code closed 2006 Jan anonymous Shell 2006 Jan anonymous 1 1 the sqlite328.exe generates Application error -memory cold not be read
1595 doc closed 2006 Jan anonymous   2006 Jan   4 1 tcl-devel is required to build. This requirement is not listed
1606 code closed 2006 Jan anonymous   2006 Jan   1 1 sqlite3_prepare16 broken
1617 code closed 2006 Jan anonymous   2006 Jan drh 1 1 Memory allocation routines always return non-zero value
1618 code closed 2006 Jan anonymous   2006 Jan drh 1 1 Problematic ENTER_MALLOC() macro definition
1620 todo closed 2006 Jan anonymous   2006 Jan   1 1 error database or disk is full
1622 code closed 2006 Jan danielk1977   2009 Oct   1 1 Compiling with OMIT_PRAGMA causes an error in the test suite
1623 code closed 2006 Jan anonymous   2006 Jan drh 1 1 ThreadData instance never gets freed
1624 code closed 2006 Jan anonymous   2006 Jan drh 1 1 OSMALLOC(int n) implementation does not allow OOM testing
1647 doc closed 2006 Jan anonymous Unknown 2008 Jun   3 1 i want to use this lib in my project
1667 code closed 2006 Feb anonymous BTree 2006 Feb danielk1977 1 1 Database corruption when db file hits 1 GB with auto_vacuum (3.3.3)
1678 code closed 2006 Feb anonymous Unknown 2006 Feb   1 1 error select like
1698 build closed 2006 Mar anonymous   2009 Oct   1 1 sqlite_4y6ngs9FlYvAMGO 0kb 3/1/2006 1:16 PM
1701 doc closed 2006 Mar anonymous   2009 Oct drh 3 1 3.3 build option not documented?
1710 new closed 2006 Mar anonymous   2006 Aug   1 1 when order by, performance is low
1712 code closed 2006 Mar anonymous   2006 Mar   1 1 aggregate function return empty row
1718 new closed 2006 Mar anonymous   2009 Oct   1 1 allow *.sqlite as parameter to sqlite3_analyzer
1723 code closed 2006 Mar anonymous   2006 Mar   1 1 Crash (floating point error) when dealing with BIGINT datatypes
1724 code closed 2006 Mar anonymous Shell 2006 Mar anonymous 1 1 sqlite doesn't work with "cifs-mounted-directories"
1725 code closed 2006 Mar anonymous   2006 Mar   2 1 sql "HAVING" fails to filter query grouping "UNION ALL" subqueries
1729 code closed 2006 Mar anonymous   2006 Mar   1 1 SQLite loses precision on 64-bit integers
1738 code closed 2006 Mar anonymous Unknown 2006 Mar a.rottmann 1 1 The function "sqlite3_get_table" doen't do well with blob data.
1739 code closed 2006 Mar anonymous Unknown 2006 Mar   4 1 sqlite3_bind_int on UPDATE * SET COLUMN1='Test' WHERE ID=?
1751 code closed 2006 Apr anonymous Unknown 2006 Sep mike 1 1 sqlite doesn't work on a cifs-mounted drive
1753 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 2 1 Order by not working on a column with random() function
1757 code closed 2006 Apr anonymous   2006 Apr   2 1 sqlite not using index
1758 code closed 2006 Apr anonymous Unknown 2006 Apr   3 1 problem with: select ... UNION ... select .. ORDER BY LOWER(column)
1774 code closed 2006 Apr ghaering   2006 Apr   1 1 sqlite3_column_decltype() stopped working in SQLite 3.3
1775 code closed 2006 Apr anonymous Unknown 2009 Oct   1 1 strftime() not working in Windows Mobile 2005
1780 code closed 2006 Apr anonymous BTree 2006 Apr   1 1 What's mean for "b0G1X" or "b0G0" in the head of payload in cell?
1782 code closed 2006 Apr anonymous Unknown 2009 Oct   1 1 journal file exclusion
1787 code closed 2006 Apr anonymous   2006 Apr   1 1 Certain integer values are written/read incorrectly to/from database
1791 code closed 2006 May anonymous Unknown 2009 Oct   1 1 Native threads support for BeOS
1795 code closed 2006 May anonymous Unknown 2006 Aug   1 1 Incorrect result if a nested view contains a union
1796 code closed 2006 May anonymous   2006 May   1 1 .import command not working in 3.3.5
1808 code closed 2006 May anonymous   2006 May   1 1 Wrong index is chosen
1812 new closed 2006 May anonymous   2009 Oct   4 1 alter table add column default current_timestamp
1820 warn closed 2006 May anonymous TclLib 2009 Jan anonymous 5 1 make: *** [tclsqlite.lo] Error 1
1823 code closed 2006 May anonymous   2006 May   1 1 pysqlite2.dbapi2.OperationalError: unable to open database file
1829 code closed 2006 Jun anonymous   2006 Jun   1 1 Odbc driver parameter bind offset pointer does not work
1832 code closed 2006 Jun anonymous   2006 Jun   1 1 Segmentation fault when placing a 0 limit on a joined subquery.
1842 code closed 2006 Jun anonymous Unknown 2006 Jun anonymous 1 1 The field data saved in the table is corrupt
1846 code closed 2006 Jun anonymous   2006 Jun   1 1 Memory leak after returning error message
1850 code closed 2006 Jun anonymous Unknown 2009 Oct   2 1 NUMERIC data type ERROE when read on uClinux
1851 code closed 2006 Jun anonymous Unknown 2009 Oct   2 1 USE "ORDER BY" error on uClinux
1860 code closed 2006 Jun anonymous Pager 2009 Oct danielk1977 1 1 Problem in using SQLite3 with trigger and multithreading
1861 code closed 2006 Jun anonymous Pager 2009 Oct   1 1 Problem in using Triggers and multithreading
1862 code closed 2006 Jun anonymous TclLib 2009 Oct tclguy 1 1 SQLite cannot load/import data from file
1866 event closed 2006 Jun anonymous   2006 Jun   1 1 SQLite.NET ExecuteNonQuery() limit of text size
1881 code closed 2006 Jul anonymous Parser 2006 Jul anonymous 2 1 error in inserting strings with single quotes
1882 code closed 2006 Jul anonymous   2009 Oct   1 1 Wrong algorithm of SQLITE_VERSION_NUMBER calculation
1888 code closed 2006 Jul anonymous Unknown 2006 Jul anonymous 1 1 connetion to db extremely slow
1896 new closed 2006 Jul drh   2009 Oct   1 1 All extensions to be statically linked
1900 code closed 2006 Jul anonymous Unknown 2009 Aug a.rottmann 1 1 CURRENT_TIMESTAMP keyword not inserting UTC date in column
1922 code closed 2006 Aug anonymous Parser 2006 Aug   1 1 field name with space can not be specified as primary key
1930 code closed 2006 Aug anonymous Unknown 2006 Aug adamd 1 1 the select command can't support NOT_FOUND.
1939 event closed 2006 Aug anonymous Unknown 2009 Oct   2 1 SQLite hangs with WHERE condition in an SELECT with joined table
1941 code closed 2006 Aug anonymous   2008 Jun   1 1 Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER
1945 code closed 2006 Aug anonymous   2006 Nov   1 1 symbol not found: sqlite_freemem
1949 new closed 2006 Aug anonymous   2006 Aug   4 1 Missing 64Bit type
1954 code closed 2006 Sep anonymous Unknown 2008 Jun   1 1 Dual Core Processor Lockup
1956 code closed 2006 Sep anonymous   2009 Jan   1 1 ALTER TABLE ADD COLUMN does not support asian language column names.
1974 code closed 2006 Sep anonymous Unknown 2009 Oct   1 1 column type not consistent in views
1980 code closed 2006 Sep drh   2009 Oct   1 1 Initializing FTS1 twice causes it to fail.
1984 code closed 2006 Sep anonymous   2006 Sep   1 1 sqlite3_exec problem
1990 code closed 2006 Sep anonymous   2009 Sep   1 1 sqlite3_close doesn't release always the file handle
1992 code closed 2006 Sep anonymous   2009 Oct shess 1 1 FTS1: Problems after dropping utility tables
1993 event closed 2006 Sep anonymous   2006 Sep   3 1 bit operators problemm
1995 code closed 2006 Sep anonymous   2006 Oct   2 1 SHARED lock does not kick in (DEFERRED does not work ?)
2005 event closed 2006 Sep anonymous   2009 Oct   1 1 Multiple rows with the same primary key, and null values in "not null"
2006 event closed 2006 Sep anonymous   2009 Oct   1 1 Strange data in a table.
2007 code closed 2006 Oct anonymous   2006 Oct   1 1 Server has unexpecedly died/u've found a bug/ i cant connect to hub
2017 code closed 2006 Oct anonymous   2009 Oct   1 1 DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
2019 code closed 2006 Oct anonymous   2009 Oct   1 1 FTS1: Create table in transaction raises Out of Sequence error (21)
2020 code closed 2006 Oct anonymous   2006 Oct   1 1 sqlite3_column_type always returns 1
2021 code closed 2006 Oct anonymous   2006 Oct a.rottmann 2 1 Expression Always Returning String
2022 code closed 2006 Oct anonymous   2009 Oct   1 1 .import command is not working
2027 code closed 2006 Oct anonymous   2009 Oct   1 1 FTS: Phrase searches return Offsets for individual phrase words
2031 code closed 2006 Oct anonymous   2006 Oct   1 1 .DEF file missing from 3.3.8 source code distribution
2033 code closed 2006 Oct anonymous   2006 Oct   1 1 SQLite 3.3.8 breaks Rails 1.1.6 (SQLite 3.3.6 OK)
2034 code closed 2006 Oct anonymous   2006 Oct jenglish 1 1 lazarus and sqlite3
2035 code closed 2006 Oct anonymous   2006 Oct jenglish 1 1 lazarus and sqlite3
2037 code closed 2006 Oct anonymous   2009 Oct   1 1 Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
2039 code closed 2006 Oct anonymous   2006 Oct   1 1 How to delete SQLITE Temp files
2040 code closed 2006 Oct anonymous   2006 Nov   1 1 Fatal reloc error: Using sqlite-3.3.6 with apache-2.2.0 on SPARC Solar
2043 code closed 2006 Oct anonymous   2009 Oct   1 1 Spaces in view statement
2046 code closed 2006 Oct anonymous   2009 Oct shess 1 1 FTS1 - Error closing database due to unfinished statements
2048 code closed 2006 Oct anonymous   2009 Oct drh 1 1 table_info on columns with no default value are returned as string
2049 code closed 2006 Oct anonymous   2006 Oct   1 1 sqlite_HrmKZy6ma4XBUGl is in my temp file and cannot be deleted.
2052 code closed 2006 Nov anonymous   2006 Nov   1 1 BLOBs still do not work on version 3.0
2053 code closed 2006 Nov anonymous   2006 Nov   1 1 problem on solaris 10
2054 code closed 2006 Nov anonymous   2006 Nov   1 1 material to learn SQLite
2057 code closed 2006 Nov anonymous   2009 Oct   3 1 full_column_names when 2 or more tables are joined is not working
2058 code closed 2006 Nov anonymous   2006 Nov   1 1 sum or total result in only 1 row returned
2059 code closed 2006 Nov anonymous   2009 Oct   1 1 Still missing .DEF file from Windows 3.3.8 source code distribution
2060 code closed 2006 Nov anonymous   2009 Oct   1 1 Table references enclosed in parenthesis become "invisible"
2076 code closed 2006 Nov anonymous   2009 Oct a.rottmann 1 1 % exists as value in varchar
2077 code closed 2006 Nov anonymous   2009 Dec   2 1 Problems with using ASCII symbols 0x80 - 0xFF in database path
2079 code closed 2006 Nov anonymous   2006 Nov   1 1 strftime doesn't work in where statement
2081 code closed 2006 Nov anonymous   2009 Dec doughenry 1 1 sqlite3_column_decltype throws exception, if selection is grouped
2097 code closed 2006 Dec anonymous   2006 Dec   1 1 MAX function broken
2098 warn closed 2006 Dec anonymous   2009 Oct   1 1 php sqlite problem after commit transaction
2100 code closed 2006 Dec anonymous   2009 Oct   1 1 Fixes for SQL lower() and upper()
2101 event closed 2006 Dec anonymous   2006 Dec   1 1 sqlite files filling up Temp folder 7,700 files so far can not delete
2102 code closed 2006 Dec anonymous   2006 Dec   1 1 locking failing on w2k on vmware
2124 code closed 2006 Dec anonymous   2006 Dec   1 1 default ./configure && make broken on Linux in latest CVS
2126 code closed 2006 Dec anonymous   2009 Dec   3 1 Update hook not invoked when deleteing all rows from table
2134 code closed 2006 Dec anonymous   2006 Dec   2 1 is this a bug of sqlite3_prepare?
2140 code closed 2007 Jan anonymous   2008 Jun   3 1 sqlite doesn't link to readline
2152 code closed 2007 Jan anonymous   2007 Jan   1 1 there is not tclsqlite.h in sqlite3.3.9
2162 code closed 2007 Jan anonymous   2007 Jan   1 1 c code compile fails with "Undefined reference to sqlite3_open()"
2169 code closed 2007 Jan anonymous   2007 Mar adamd 2 1 cast function
2178 code closed 2007 Jan anonymous   2007 Apr   1 1 On Windows Vista, a simple select returns different results.
2179 new closed 2007 Jan anonymous   2007 Jan   4 1 Odbc driver for sqlite takes more time in executing a query.
2183 code closed 2007 Jan anonymous   2009 Oct drh 1 1 OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
2186 code closed 2007 Jan anonymous   2007 Jan drh 1 1 database seems to be corrupted during a huge transaction
2199 build closed 2007 Jan anonymous   2008 Mar   1 1 configure doesn't find libreadline if its in uncommon place
2205 build closed 2007 Jan anonymous   2009 Oct anonymous 1 1 Problem while using with tcl on ARM
2213 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Bug handling strings that are not nul-terminated.
2230 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Problem with virtual tables and grouping by aggregate function.
2234 code closed 2007 Feb anonymous   2007 Feb   1 1 3.3.13 is identical to 3.3.12 except VERSION file
2236 code closed 2007 Feb anonymous   2007 Feb   1 1 inserts with selects do not work in 3.1.13
2239 doc closed 2007 Feb anonymous   2007 Feb   1 1 Size of database in Speed Comparison?
2240 code closed 2007 Feb anonymous   2007 Feb   1 1 Parser command termination problem fails to catch illegal statements
2245 new closed 2007 Feb anonymous   2007 Feb a.rottmann 5 1 Union Problem on Empty Table
2250 code closed 2007 Feb anonymous   2007 Mar danielk1977 1 1 segmentation violation when using "select max(rowid)" in fts1
2253 code closed 2007 Feb anonymous   2007 Mar danielk1977 1 1 src/vdbe.c:3639: sqlite3VdbeExec: Assertion `pC!=0' failed.
2256 new closed 2007 Feb anonymous   2009 Dec drh 5 1 Add POSITION() function (SQL-92 standard)
2260 code closed 2007 Feb anonymous   2007 Mar   1 1 virtual table/vdbe does not call xFilter() making xColumn segv
2261 build closed 2007 Mar anonymous   2007 Mar   1 1 Problem under Windows 95
2263 code closed 2007 Mar anonymous   2007 Mar   1 1 Apparent potential leak or concurrency problem when using codec
2265 doc closed 2007 Mar anonymous   2007 Mar   1 1 windows + xampp (php) + sqlite3 ... how?
2269 code closed 2007 Mar anonymous   2007 Mar anonymous 2 1 SQLite3_Column_decltype treat [char] (32) as 'char',but not 'char(32)'
2277 code closed 2007 Mar anonymous   2007 Oct   1 1 Incorrect usage of CRITICAL_SECTION and TLS on Windows
2283 warn closed 2007 Apr anonymous   2009 Oct   1 1 Compile warning by VCToolkit2003
2292 code closed 2007 Apr anonymous   2007 Apr   1 1 VACUUM => constraint failed
2294 code closed 2007 Apr anonymous   2009 Oct   2 1 segfault when destroying lock on WinCE with threads
2299 build closed 2007 Apr anonymous   2009 Oct   1 1 Cannot compile sqlite-3.3.15 on linux rhel
2300 code closed 2007 Apr anonymous   2007 Apr   1 1 compound query ORDER BY expression problem
2301 build closed 2007 Apr anonymous   2009 Oct   1 1 Latest cvs 3.3.15 fails lock4-1.3 test
2303 code closed 2007 Apr anonymous   2009 Oct   1 1 Encrypted databases: No page cache due to problem in pagerSharedLock
2304 new closed 2007 Apr anonymous   2009 Oct   1 1 resolve "databas is locked" problem under DEFERRED transaction
2312 code closed 2007 Apr anonymous   2007 Apr mike 1 1 Using ODBC. Only saves first 5 characters of text fields. Can you help
2315 code closed 2007 Apr anonymous   2007 Apr   1 1 Macro Redefinition Warning
2320 code closed 2007 Apr anonymous   2009 Oct drh 1 1 sqlite3_open(sFN_with_umlaut)
2322 code closed 2007 Apr anonymous   2009 Oct   1 1 Windows error: datetime('2000-10-29 06:00:00','localtime')
2325 code closed 2007 Apr anonymous   2007 Apr   1 1 Link Fails w/ SQLITE_OMIT_ALTERTABLE
2327 new closed 2007 Apr anonymous   2009 Oct anonymous 2 1 "DELETE" operation makes memory rise
2328 code closed 2007 Apr anonymous   2008 Jun   1 1 Makefile sqlite3.c target breakage for C++
2331 code closed 2007 May anonymous   2007 May   1 1 Performance problem with complex where clause
2332 code closed 2007 May anonymous   2007 May danielk1977 1 1 incrblob: Data error writing large blobs
2342 doc closed 2007 May anonymous   2009 Oct   1 1 Document that prepared incremental vacuum needs multiple sqlite3_step
2346 code closed 2007 May anonymous   2007 May   1 1 Inserting a certain integer
2350 code closed 2007 May anonymous   2009 Oct   1 1 Temp files not deleted on WinCE
2353 code closed 2007 May anonymous   2007 May   1 1 Issue with selecting values of indexed column
2365 code closed 2007 May anonymous   2007 May   1 1 incrvacuum2, zeroblob regressions from check-ins on 2007-May-16
2368 code closed 2007 May anonymous   2007 May   1 1 vdbeblob.c missing from Makefile.in
2380 code closed 2007 May anonymous   2007 May   1 1 Order By Collum1, Collum2, Collum3 for Pocket PC incorrect in device
2387 code closed 2007 May anonymous   2007 May   1 1 query: problem with update anagrafica SET nome='nome' where id = '4';
2389 code closed 2007 May anonymous   2007 Jun   1 1 database placed in the non ASCII named folder could not be opened
2390 code closed 2007 May anonymous   2007 May drh 1 1 defect in select with max(id)
2391 todo closed 2007 May danielk1977   2007 May danielk1977 1 1 Inconsistent behaviour from explicit collate clauses.
2394 todo closed 2007 Jun anonymous   2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
2395 todo closed 2007 Jun anonymous   2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
2401 warn closed 2007 Jun anonymous   2009 Oct   1 1 I can't send anything to the contrib page
2405 code closed 2007 Jun anonymous   2007 Jun   1 1 sqlite3_prepare() don't work in php pdo implementation
2408 code closed 2007 Jun anonymous   2009 Oct   2 1 BLOBs not output correctly in .mode insert (shell.c - isnumber)
2409 code closed 2007 Jun anonymous   2009 Oct drh 1 1 Database malformed with SQLite3.3.17 on WindowsXP
2412 build closed 2007 Jun anonymous   2007 Jun a.rottmann 1 1 Can't make Sqlite 3.3.17 on Solaris 10 X86
2414 code closed 2007 Jun anonymous   2008 Jun   1 1 Unable t
2421 code closed 2007 Jun anonymous   2007 Jun   1 1 unresolved external
2435 code closed 2007 Jun anonymous   2007 Jun   1 1 Data corruption in version 3.4.0
2439 code closed 2007 Jun rse   2007 Jul   1 1 FTS1 and FTS2 use the unportable <malloc.h>
2445 code closed 2007 Jun anonymous   2007 Jun   1 1 crash in sqlite3_prepare16
2449 doc closed 2007 Jun anonymous   2007 Jun   1 1 BLOB and binary data
2450 code closed 2007 Jun anonymous   2007 Jun   1 1 Crashes and random wrong results with certain column names
2452 code closed 2007 Jun anonymous   2007 Jun drh 1 1 In Memory Query Performance
2458 code closed 2007 Jun anonymous   2007 Jun   1 1 sqlite caching results between calls to select on an open database
2460 code closed 2007 Jun anonymous   2007 Jun   1 1 VC6 Compile Error
2463 todo closed 2007 Jun anonymous   2007 Jun anonymous 1 1 Crash after calling sqlite_close() if SQLITE_ENABLE_MEMORY_MANAGEMENT
2469 build closed 2007 Jun anonymous   2009 Oct   1 1 test fails on Solaris
2471 secure closed 2007 Jun anonymous   2007 Jun   1 1 a bug for 64 bit driver under operation system
2472 code closed 2007 Jun anonymous   2007 Jun   1 1 smart quotes turning question marks while storing in oracle 9i DB
2479 code closed 2007 Jun anonymous   2009 Oct   1 1 WinCE regression on some systems. Any db open fails.
2487 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLite database locked error on NFS mounted home dir
2489 build closed 2007 Jul anonymous   2007 Jul   1 1 Latest cvs 3.4.0 make test fails related to TCL
2490 code closed 2007 Jul anonymous   2007 Oct   1 1 Latest cvs 3.4.0 seg fault
2491 code closed 2007 Jul anonymous   2008 Jun   1 1 Mingw Warnings w/ 3.4.0 Amalgamation
2494 code closed 2007 Jul anonymous   2007 Jul   1 1 DRow["ID"] = reader.GetString(reader.GetOrdinal("ID")); fails
2504 build closed 2007 Jul anonymous   2007 Jul   1 1 sqlite 3.4.0 fails to build FreeBSD 6.2 64-bit system
2505 code closed 2007 Jul anonymous   2007 Jul   1 1 does not return error when use sqlite_open to open an non-sqlite db
2508 code closed 2007 Jul anonymous   2009 Oct   1 1 utf8ToUnicode() does not work on some WinCE devices
2509 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLITE_DATE
2510 code closed 2007 Jul anonymous   2009 Oct   1 1 Vacuum modified FTS2 rowids
2512 code closed 2007 Jul shess   2009 Oct   1 1 FTS virtual table name quoting problem
2515 code closed 2007 Jul anonymous   2007 Jul   1 1 Entered to ASCII zeros as a text string was return a single zero.
2517 code closed 2007 Jul anonymous   2009 Oct dflam 1 1 exception on reading text in vista but not xp
2519 new closed 2007 Jul anonymous   2007 Oct   1 1 Page cache and schema should be shared between all connections/threads
2520 new closed 2007 Jul anonymous   2009 Oct   4 1 User defined aggregate functions are not reentrant
2529 code closed 2007 Jul anonymous   2007 Jul anonymous 1 1 Bug in sqlite3_prepare_v2( ) function
2531 code closed 2007 Jul anonymous   2007 Jul a.rottmann 1 1 Can't find head files in icu.c
2538 code closed 2007 Jul anonymous   2007 Jul   1 1 calling sqlite3_interrupt() randomly leaves db->ul.isInterrupted = 1
2542 code closed 2007 Jul anonymous   2007 Jul   2 1 select 3/2 * avg(x) gives wrong result
2543 code closed 2007 Jul anonymous   2009 Oct   1 1 Chinese charset not support??
2555 new closed 2007 Aug anonymous   2009 Oct   1 1 FTS index without original text
2563 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3_column_database_name16() is broken
2566 build closed 2007 Aug anonymous   2009 Oct   2 1 fts2 broken after vacuum
2571 todo closed 2007 Aug anonymous   2007 Aug   1 1 SQLite opening in Access
2572 warn closed 2007 Aug anonymous   2007 Aug   1 1 Sqlitw error unrecognize token
2575 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3_mutex_enter missing return
2576 code closed 2007 Aug anonymous   2007 Aug   1 1 Check-in [4239] mutex race conditions
2578 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3BtreeEnter, sqlite3BtreeLeave threading issues
2581 code closed 2007 Aug anonymous   2007 Aug   1 1 ./configure && make broken: new source files: mem[12].c, mutex.c, etc
2585 code closed 2007 Aug anonymous   2007 Oct anonymous 1 1 Error Function GetAtomNameA
2592 warn closed 2007 Aug anonymous   2007 Aug   1 1 The Entry C:\Windows\Temp\sqlite_z6onAYdsVGqLG3Q is Invalid
2593 code closed 2007 Aug anonymous   2007 Aug   1 1 btshared unlock bug
2601 code closed 2007 Aug anonymous   2007 Oct   1 1 Problem with opening database with Unicode filename
2607 event closed 2007 Aug anonymous   2009 Oct   2 1 Data loss, continuation to Re: [sqlite] how to flush database to disk?
2609 code closed 2007 Sep anonymous   2007 Sep   1 1 Is non-thread safe binaries dangerous for multi-threaded app design ?
2614 code closed 2007 Sep anonymous   2007 Sep   1 1 Custom VFS still calls default xRandomness
2618 code closed 2007 Sep anonymous   2007 Sep linus 4 1 Dabase is Locked
2626 code closed 2007 Sep anonymous   2007 Sep   1 1 The Amalgamation compile error
2636 code closed 2007 Sep anonymous   2007 Sep   1 1 Bug in sqlite3_prepare_v2
2637 code closed 2007 Sep anonymous   2007 Sep   1 1 Segfault in pthread_getspecific ()
2644 code closed 2007 Sep anonymous   2007 Sep   1 1 sqlite
2646 code closed 2007 Sep anonymous   2007 Sep a.rottmann 4 1 sqlite3_get_table loses one table row
2647 code closed 2007 Sep anonymous   2007 Sep   1 1 sqlite-3.5.0 Cygwin: Compilation fails on src/os_win.c - ';' missing
2650 build closed 2007 Sep anonymous   2007 Sep   1 1 lack ; in os_win.c:1329
2654 code closed 2007 Sep anonymous   2007 Oct jadams 1 1 sqlite3_prepare return 1(fail)
2656 doc closed 2007 Sep anonymous   2007 Oct   2 1 missing documentation: END TRANSACTION
2657 build closed 2007 Sep anonymous   2007 Oct anonymous 1 1 fail to compile
2662 code closed 2007 Sep anonymous   2007 Sep   1 1 Serious Performance Degradation from 3.3.4 to 3.3.5 & latest versions
2665 code closed 2007 Sep anonymous   2007 Sep   3 1 Dissapearing exclusive lock when DB is copied...
2667 code closed 2007 Sep anonymous   2007 Oct   1 1 no such function: hex no such function: regexp
2675 new closed 2007 Sep anonymous   2007 Sep   1 1 TEMP_STORE does not appear to be set by the compile time switch
2676 code closed 2007 Sep anonymous   2007 Sep   1 1 TEMP_STORE does not appear to be set by the compile time switch
2682 code closed 2007 Oct anonymous   2007 Oct   1 1 SQLite Text Problem
2684 code closed 2007 Oct anonymous   2008 Jun   1 1 Accessing sqlite from an NT service will lock the complete databse.
2688 build closed 2007 Oct anonymous   2007 Oct   3 1 SQLITE_OMIT_AUTHORIZATION build failure
2691 code closed 2007 Oct anonymous   2007 Oct   1 1 SQLITE_OMIT_AUTHORIZATION compilation error
2692 build closed 2007 Oct anonymous   2007 Oct   1 1 COmpilation of Sqlite amalgamation v3.4.2. failed
2715 code closed 2007 Oct anonymous   2009 Oct   1 1 no authorization needed to remove authorizer
2716 new closed 2007 Oct anonymous   2009 Oct   5 1 Create Clear Command
2718 build closed 2007 Oct anonymous   2007 Oct   2 1 WinCE compile error
2719 code closed 2007 Oct anonymous   2007 Oct   3 1 WinCE winFullPathName doesn't return a value
2720 code closed 2007 Oct anonymous   2007 Oct   1 1 WinCE - Can't write
2721 code closed 2007 Oct anonymous   2009 Oct   2 1 if db file is in a folder with non-ansi character some functions fail
2725 code closed 2007 Oct anonymous   2008 Jun   1 1 memory leak in sqlite3_open_v2() when it fails
2731 code closed 2007 Oct anonymous   2007 Oct   1 1 sqlite3ExprCode TK_UMINUS inefficient with large negative floats
2734 code closed 2007 Oct anonymous   2007 Oct   3 1 2 bug under the wince
2735 code closed 2007 Oct anonymous   2007 Oct nmadhav 3 1 Error : Unrecognized Token
2742 code closed 2007 Oct anonymous   2007 Oct   1 1 codeInteger and codeReal
2743 doc closed 2007 Oct anonymous   2007 Oct   1 1 Comparison of SQLite against McObject Fusion
2744 code closed 2007 Oct drh   2007 Nov danielk1977 1 1 Cannot quote collating sequence name
2745 code closed 2007 Oct anonymous   2007 Oct shazow 1 1 Sharing File between two processes
2746 code closed 2007 Oct anonymous   2007 Oct   1 1 PRIMARY KEY does not treat NULL as unique
2747 code closed 2007 Oct anonymous   2007 Nov maria.khomenko 1 1 How to use Composite Key in Sqlite
2750 code closed 2007 Oct anonymous   2007 Oct   2 1 for the new.somefield value returns the old value of it
2756 new closed 2007 Nov anonymous   2009 Oct   1 1 allow vacuum to change pragma setting instead of using existing ones
2757 doc closed 2007 Nov anonymous   2007 Nov   1 1 Special characters handling in SQLite Like Query
2758 code closed 2007 Nov anonymous   2007 Dec   1 1 Why this?
2770 code closed 2007 Nov anonymous   2009 Oct   1 1 Problem with BLOB in 3.5.x ?
2773 code closed 2007 Nov danielk1977   2007 Nov   2 1 sqlite crashes in sqlite3_step when compiled with SQLITE_THREADS=1
2776 warn closed 2007 Nov anonymous   2008 Mar   5 1 mailing list
2777 code closed 2007 Nov anonymous   2007 Nov shess 1 1 FTS[23] compile bug
2778 code closed 2007 Nov anonymous   2007 Nov adixon 1 1 Error 0
2782 code closed 2007 Nov anonymous   2007 Nov   1 1 bind_text(...) into transaction
2791 code closed 2007 Nov anonymous   2009 Oct   1 1 Allow building FTS[123] as part of sqlite library with configure
2802 code closed 2007 Nov anonymous   2007 Dec   1 1 SELECT UNION and EXCEPT seem to have a memory allocation bug
2804 code closed 2007 Nov anonymous   2007 Dec   1 1 PRAGMA legacy_file_format=OFF setting lost with VACUUM
2809 code closed 2007 Nov anonymous   2009 Oct   1 1 PRAGMA collation_list shows unregistered collations
2810 code closed 2007 Nov anonymous   2009 Oct   1 1 Unregistered collation problems with simple subselects
2813 build closed 2007 Nov anonymous   2009 Oct   1 1 compile error on Windows CE
2817 code closed 2007 Dec danielk1977   2007 Dec danielk1977 1 1 Temp-tables with the same name as database tables can cause corruption
2819 code closed 2007 Dec anonymous   2007 Dec   2 1 Blocking and crashing
2823 code closed 2007 Dec anonymous   2007 Dec   1 1 query not return values
2824 code closed 2007 Dec anonymous   2007 Dec   1 1 enable shared cache problem
2834 event closed 2007 Dec anonymous   2007 Dec   2 1 Is Version 3.1.3 not compatible with 3.5.3 ?
2836 build closed 2007 Dec anonymous   2007 Dec   1 1 Undefined symbol 'OP_StackDepth'
2841 todo closed 2007 Dec anonymous   2009 Oct   1 1 The sqlite mailing list has become overrun by trolls
2842 code closed 2007 Dec anonymous   2008 Jun   1 1 .import does not recongnise NULL values
2844 build closed 2007 Dec anonymous   2009 Oct   4 1 lemon is being built without respecting LDFLAGS
2854 code closed 2007 Dec danielk1977   2007 Dec danielk1977 1 1 BEGIN EXCLUSIVE does not prevent other shared-cache users from reading
2860 todo closed 2007 Dec anonymous   2009 Oct   3 1 Database file fragmentation
2861 doc closed 2007 Dec anonymous   2008 Jan   1 1 How do I connect to Crystal Reports - I am using vs2003 & the Finisar
2868 code closed 2008 Jan anonymous   2008 Jan   1 1 Encryption user can't link latest SQLite
2874 code closed 2008 Jan anonymous   2009 Oct   1 1 THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c
2876 build closed 2008 Jan anonymous   2008 Jan   1 1 3.5.4 fails to build on OpenBSD...
2878 code closed 2008 Jan anonymous   2008 Jun   1 1 Memory leaks with latest CVS [4693]
2881 build closed 2008 Jan anonymous   2009 Oct   1 1 Latest sqlite-3.5.4 build fail on latest Fedora 2.6.23.12-52.fc7
2890 build closed 2008 Jan anonymous   2008 Jan   1 1 Assistance request fixing six 3.5.4 i/o test failures
2893 code closed 2008 Jan anonymous   2009 Oct   1 1 incorrect integer range tests
2895 build closed 2008 Jan anonymous   2008 Jan   3 1 Please describe how to run an indvidual test out of the test suite
2896 code closed 2008 Jan anonymous   2008 Jan   1 1 FTS3 misses document, but finds non-matching ones instead
2897 code closed 2008 Jan anonymous   2009 Oct   1 1 String or BLOB exceed size limit
2907 code closed 2008 Jan anonymous   2009 Oct   1 1 Issues of sqlite3 with Windows Mobile 5/6
2918 code closed 2008 Feb anonymous   2008 Feb danielk1977 1 1 sqlite3SelectMask() missing with SQLITE_OMIT_TRIGGER
2925 code closed 2008 Feb anonymous   2008 Feb danielk1977 3 1 I can't understand the code
2929 code closed 2008 Feb anonymous   2008 Feb   1 1 Issue with the MAX() aggregate function
2931 new closed 2008 Feb anonymous   2009 Oct   1 1 auto-detect page size
2939 code closed 2008 Feb anonymous   2009 Oct   1 1 instr, locate, position, charindex etc
2951 code closed 2008 Feb anonymous   2008 Feb   2 1 Bug of SQLite3_open
2952 new closed 2008 Feb anonymous   2009 Oct   4 1 "New" feature needed...
2954 code closed 2008 Feb anonymous   2009 Oct drh 2 1 "database disk image is malformed" Error
2957 code closed 2008 Feb anonymous   2008 Feb   1 1 SQL "like" select result error when string is chinese
2958 code closed 2008 Feb anonymous   2008 Feb anonymous 1 1 group by error
2960 code closed 2008 Feb anonymous   2009 Oct   2 1 select count(*) on large database locks the database for long time.
2966 code closed 2008 Feb anonymous   2008 Feb   1 1 SQL error: database disk image is malformed
2970 code closed 2008 Mar danielk1977   2009 Oct   1 1 Mozilla crash related to sqlite3_enable_shared_cache()
2971 doc closed 2008 Mar anonymous   2009 Oct   1 1 Web site link to math extensions downlaod is broken
2972 todo closed 2008 Mar anonymous   2009 Oct   1 1 Can't download contributions from contribution page on www.sqlite.org
2973 new closed 2008 Mar anonymous   2008 Jun   1 1 Any possibilties that yall could add math functions into the distro
2974 code closed 2008 Mar anonymous   2008 Apr   1 1 Select problem in transition from Version 3.2.2 to 3.5.4
2987 code closed 2008 Mar anonymous   2009 Oct   1 1 unable to open database file
2989 code closed 2008 Mar anonymous   2008 Mar   1 1 cannot DELETE from table named: 'catalogs'
2992 event closed 2008 Mar anonymous   2009 Oct mlcreech 1 1 sqlite compatibility with windows mobile 6.0
2999 doc closed 2008 Mar anonymous   2008 Mar   1 1 Visual Basic Commands
3003 event closed 2008 Mar anonymous   2008 Mar   2 1 I dot connection help me
3010 code closed 2008 Mar anonymous   2008 Mar   1 1 with UTF-16BE or UTF-16LE encoding, sqlite3_column_blob return invalid
3011 code closed 2008 Mar anonymous   2008 Mar drh 1 1 Invalid Blob result on UTF-16 encoding
3012 code closed 2008 Mar anonymous   2008 Mar   1 1 called in inappropriate state
3017 build closed 2008 Mar anonymous   2008 Mar   1 1 query order by not working for any other column except than rowid
3018 code closed 2008 Mar anonymous   2008 Mar   1 1 how can i implement moveprev() i.e. step prev.
3021 new closed 2008 Mar anonymous   2009 Oct   1 1 Delete trigger not fired when "insert or replace" does a replace
3022 code closed 2008 Mar anonymous   2008 Mar danielk1977 2 1 Select on view of indexed table broken
3025 code closed 2008 Mar anonymous   2008 Apr   1 1 sqlite application
3026 code closed 2008 Apr anonymous   2008 Jun   3 1 "drop table if exists" fails
3027 code closed 2008 Apr anonymous   2008 Apr   2 1 Segmentation fault on WinXP
3034 code closed 2008 Apr anonymous   2008 Apr danielk1977 1 1 sqlite3_mprintf does not format 64bit integer (sqlite3_int64)
3070 code closed 2008 Apr anonymous   2008 Apr   1 1 sqlite3_changes bug (?)
3071 doc closed 2008 Apr anonymous   2008 Apr   2 1 BNF for CREATE TABLE on sqlite.org is wrong
3073 code closed 2008 Apr anonymous   2009 Oct anonymous 1 1 Critical section doesn't be deleted while not using sqlite3.
3074 new closed 2008 Apr anonymous   2009 Oct   1 1 support for parentheses around UNION sub-queries
3076 code closed 2008 Apr anonymous   2008 Apr   1 1 group_concat() produces incorrect result with UTF16 database
3086 code closed 2008 Apr anonymous   2008 Apr   1 1 sqlite3BtreeCursorSize() missing (void)
3088 code closed 2008 Apr anonymous   2008 Apr   1 1 warning C4311: 'type cast' : pointer truncation from 'char *' to 'sqli
3095 new closed 2008 May anonymous   2009 Oct   1 1 DELETE FROM should support aliasing
3106 code closed 2008 May anonymous   2008 May   1 1 DB Files kept locked if a failure in loading a page happens
3107 code closed 2008 May anonymous   2009 Oct   3 1 SQLite doesn't correctly check for "file system full" on writes
3110 doc closed 2008 May anonymous   2008 Jun   1 1 Minor typo in sqlite3_step()
3111 code closed 2008 May anonymous   2009 Oct   5 1 sqlite3RunParser error in linux muti-threaded environment
3114 code closed 2008 May anonymous   2008 May   1 1 Memory corruption (?) and compilation warnings on x86_64
3122 code closed 2008 May anonymous   2009 Oct   1 1 sqlite3 crash with damaged db
3127 code closed 2008 May anonymous   2008 May drh 1 1 Segfault using pragma journal_mode=off
3147 code closed 2008 May anonymous   2009 Oct   1 1 string formatting cause loss of precision
3149 code closed 2008 May drh   2009 Oct   1 1 UPDATE does not adjust the sqlite_sequence table
3162 code closed 2008 Jun anonymous   2009 Oct dwong 1 1 sqlite3_prepare16_v2 return SQLITE_SCHEMA
3165 code closed 2008 Jun anonymous   2008 Jun   1 1 Buffer underruns and use of freed memory
3171 build closed 2008 Jun anonymous   2008 Jun   5 1 about SQLite3 on C++Builder 2007?
3174 build closed 2008 Jun anonymous   2009 Oct peter 1 1 compiled with Microsoft vs2005
3175 new closed 2008 Jun anonymous   2009 Oct   1 1 multiple row insert
3176 code closed 2008 Jun anonymous   2008 Jun a.rottmann 1 1 is encryption supported ?
3181 new closed 2008 Jun anonymous   2009 Oct   1 1 sqlite3_open16 doesn't work with unicode characters
3184 code closed 2008 Jun anonymous   2009 Oct   1 1 page lost from all page list
3185 code closed 2008 Jun anonymous   2008 Jun   1 1 bug in Alter table command
3186 todo closed 2008 Jun anonymous   2008 Jun   2 1 select 5/9.0; Does not yield a result
3189 build closed 2008 Jun anonymous build 2009 Mar   1 1 [PATCH] configure.ac doesn't handle --enable-dynamic-extensions=no
3190 code closed 2008 Jun anonymous   2008 Jun