Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Key: Active Review Fixed Tested Deferred Closed
# Type Status Created By Subsys Changed Assigned Svr Pri Title
1 new closed 2002 Mar drh VDBE 2005 Feb   3 4 Make the LIKE operator a user-installable function
2 new closed 2002 Mar drh CodeGen 2002 May   2 3 Add support for TABLE.* in a query
5 code closed 2002 Mar anonymous   2002 May   3 4 Bug submitter ignores severity/priority
9 new closed 2002 Apr anonymous BTree 2002 Sep   1 3 platform-independent db files
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
32 code closed 2002 May drh   2002 Sep   1 1 Columns in views are not always named correctly.
40 code closed 2002 May drh   2002 Sep   3 3 Compiler warnings on RedHat 7.2
42 doc closed 2002 May drh   2002 Sep   1 1 Add comments to Trigger structures in sqliteInt.h
46 code closed 2002 May drh CodeGen 2002 Sep   3 2 CREATE TABLE accepts duplicate column names
49 code closed 2002 May drh CodeGen 2002 Sep   2 1 DELETE Trigger causes extra rows to be deleted
50 code closed 2002 May drh   2002 Sep   3 2 Memory leak in triggers on TEMP tables
56 event defer 2002 Jun anonymous   2002 Jun   1 1 'Permission Denied' while trying to use SQLITE in a Familiar iPAQ
63 new closed 2002 Jun drh CodeGen 2002 Sep   3 3 Add optimizations for "WHERE rowid IN (SELECT...)"
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
82 new closed 2002 Jun anonymous   2009 Oct   1 4 Add IsCacheable, IsNullable to sqlite_create_function
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()
97 todo fixed 2002 Jul drh   2003 Jan   1 1 Document and test the SHOW_DATATYPES pragma
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
108 code closed 2002 Jul anonymous   2002 Sep   1 1 Sqlite's Windows Dll Version Still Is 2.56
156 code closed 2002 Oct anonymous Unknown 2002 Oct   1 1 Cannot log in to CVSTraq because no "create account page"
165 code closed 2002 Oct anonymous VDBE 2002 Oct anonymous 1 1 can create and change tickets, without logged in
169 new closed 2002 Oct anonymous Unknown 2008 Jun anonymous 5 5 CE version
188 todo closed 2002 Nov drh   2002 Nov   1 1 Serialize disk I/O
198 todo fixed 2002 Dec anonymous   2003 Jan   1 1 Descending sort order in indices
201 doc closed 2002 Dec anonymous Unknown 2003 Nov   1 1 it is very well if there is a table lock! but ...
216 new closed 2003 Jan anonymous   2009 Oct   1 1 Add "DISTINCT ON()" clause to specify the fields to apply the unicity
219 new closed 2003 Jan anonymous   2009 Oct   5 5 MySQL style enums
229 new closed 2003 Jan anonymous Parser 2009 Oct   5 4 DECLARE ... CURSOR FOR ... would be really nice
252 new closed 2003 Feb anonymous   2009 Oct   4 1 Add optional regex matching similar to what Postgres & Oracle have
260 doc closed 2003 Mar anonymous   2003 Mar   5 4 may i add a contributed by <mailadress> to the wiki HowToCompile ?
266 new fixed 2003 Mar drh   2003 Apr   1 1 Make the VACUUM command work.
273 new closed 2003 Mar drh CodeGen 2009 Oct drh 1 1 Make NULL_ALWAYS_DISTINCT a pragma rather than a compile-time option
305 code fixed 2003 May chw   2003 Dec   1 1 Problems with locale specific "," as the radix point character
306 code fixed 2003 May drh CodeGen 2003 May   1 1 Left outer join fails when right table is a view of a join.
344 event closed 2003 Jun anonymous   2003 Jun   1 1 select
375 new closed 2003 Jul anonymous   2003 Jul anonymous 4 4 I'm missing DB metadata.
386 new closed 2003 Jul anonymous   2008 Jun   5 1 compile on WinCE ?
399 event closed 2003 Jul anonymous   2003 Jul drh 3 3 SELECT COUNT(*) FROM TABLE
418 code closed 2003 Jul anonymous Unknown 2005 Jan   4 4 sometimes web page returns error, hitting refresh makes it work
423 code closed 2003 Aug anonymous Unknown 2003 Dec   1 1 'data schema has been changed error' how will overcome this
432 code fixed 2003 Aug drh   2003 Aug   3 3 Returns "Disk I/O Error" when the filename is an empty string
436 code closed 2003 Aug drh BTree 2003 Aug drh 1 1 In-memory database backend segfaults on recursive access
454 new closed 2003 Sep anonymous   2009 Oct   4 4 schema column types with parenthesis to automatically invoke functions
465 new closed 2003 Sep anonymous   2009 Oct   4 3 data types should be implemented as formated strings
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
488 doc fixed 2003 Nov anonymous   2003 Nov   5 4 Lemon Parser Generator page is outdated
489 new fixed 2003 Nov anonymous   2008 Jun   4 4 DLL exports suggestion
496 build closed 2003 Nov anonymous   2008 Mar   1 1 SQLite Ignores Autoconf Options
498 new closed 2003 Nov anonymous Unknown 2008 Jun   4 4 Suggestion: Allow named parameters.
504 code fixed 2003 Nov anonymous   2004 Feb   3 3 'INDEX_INFO' PRAGMA returns invalid data if used with non-callback API
525 new closed 2003 Dec anonymous   2009 Oct   4 4 DB testing
543 new closed 2003 Dec anonymous   2003 Dec   5 4 Feature Request: Indicate NOT NULL columns in table_info.
570 event closed 2004 Jan anonymous   2004 Jan   5 5 database created on x86 can't work on arm
584 new closed 2004 Jan anonymous   2004 Jan anonymous 5 1 Cursor support in SQLite
586 code closed 2004 Jan anonymous   2004 Jan   2 1 Memory allocation problem ?
590 new closed 2004 Jan anonymous Parser 2009 Oct   5 4 Treat ` like spaces outside of quoted strings.
595 code closed 2004 Feb anonymous   2004 Feb   1 4 Big joins dont work as I expect
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
620 code fixed 2004 Feb anonymous Shell 2004 Feb   1 1 sqlite executable crashes
621 todo closed 2004 Feb anonymous Unknown 2009 Oct anonymous 3 3 Assorted errors running test's on MAC OSX
628 code closed 2004 Feb anonymous Pager 2004 Feb   1 3 Assertion failure in syncJournal
632 doc closed 2004 Feb anonymous   2004 Feb   2 2 fix links on wrappers page
638 new closed 2004 Mar anonymous   2009 Oct   5 5 Lemon.c could not be compiled - source dated 27.02.2004
639 event closed 2004 Mar anonymous   2004 Mar   1 1 Why fixed tickets are not closed ?
679 code closed 2004 Mar anonymous Unknown 2006 Jan a.rottmann 2 1 database closed
682 new closed 2004 Apr anonymous   2009 Oct   5 1 sqlite_aggregate_context() valid in xFunc callback routine
689 doc closed 2004 Apr anonymous   2009 Oct anonymous 4 4 Old Comment for sqlite_decode_binary in sources ?
693 build closed 2004 Apr anonymous   2004 Apr   1 1 Compiling for freeBSD
699 new closed 2004 Apr anonymous   2009 Oct   5 4 Data types and implicit conversions
704 event closed 2004 Apr anonymous   2004 Apr   5 5 .database && .databases
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
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
737 new closed 2004 May anonymous Shell 2009 Oct anonymous 3 3 xml export
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
751 code closed 2004 Jun anonymous VDBE 2005 Jan   1 2 sqliteVdbeExec: Assertion `db->magic==***' failed.
752 doc closed 2004 Jun anonymous   2008 Jun   4 4 FAQ-Entry: How to escape quotes
772 build fixed 2004 Jun anonymous   2004 Jun   2 2 configure with cygwin broken
776 code closed 2004 Jun anonymous   2005 Jan   1 1 sqlite says Database is locked when database file is on Novel disk
796 code closed 2004 Jul anonymous   2004 Sep   1 2 sqlite3_open16 Unworkable
815 build closed 2004 Jul anonymous   2008 Jun   2 1 SQLite3.dll exports
824 new closed 2004 Jul anonymous Unknown 2009 Oct   5 4 StrSum - new build-in aggreate function suggestion
829 code fixed 2004 Jul drh CodeGen 2004 Jul drh 1 1 VACUUM fails if there is a UNIQUE index
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
857 event fixed 2004 Aug anonymous   2004 Aug   1 1 Unable to download 3.0.4 precompiled binaries for Linux.
911 code fixed 2004 Sep anonymous Shell 2004 Oct   3 3 The sqlite command ".mode csv" doesn't work correctly
915 code closed 2004 Sep anonymous   2004 Sep   3 2 problem #901, but on read-only databases
992 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 sqliteStrRealloc: Return early under malloc failure.
993 new closed 2004 Nov anonymous   2004 Nov   3 4 Plug-in codec support.
1061 new closed 2005 Jan anonymous Shell 2009 Oct   4 4 shell.c .import from stdin
1068 code fixed 2005 Jan anonymous   2005 Jan drh 1 1 Lemon can emit 2 sets of destructor code in certain cases
1116 code fixed 2005 Feb drh VDBE 2005 Feb   1 1 VACUUM results in corrupt database
1130 doc closed 2005 Feb anonymous   2005 Feb   4 4 documentation for PRAGMA short-column-names incorrect
1145 doc fixed 2005 Feb anonymous   2005 Mar   4 4 duplicate text in FAQ
1155 doc closed 2005 Mar anonymous   2005 Mar   1 1 how i can get a month from a date with a SELECT
1157 new closed 2005 Mar anonymous   2005 Mar drh 1 1 Is there a roadmap?
1168 doc fixed 2005 Mar anonymous   2005 Mar   5 1 Update to the README file
1203 todo closed 2005 Apr anonymous   2009 Oct   4 5 Web site problem, download links
1220 new closed 2005 Apr anonymous   2009 Oct   4 3 Selectable calling convention
1227 new closed 2005 Apr anonymous Shell 2009 Oct   5 2 Small patch for timing commands in shell.c
1237 code closed 2005 May anonymous   2005 May anonymous 1 1 I like to use SQLite in php
1243 code fixed 2005 May anonymous TclLib 2005 Sep   1 1 Missing system encoding conversion when accessing files
1244 code fixed 2005 May anonymous   2005 May   1 1 Test misc2-.10.1 causes seg fault
1249 new closed 2005 May anonymous Unknown 2009 Oct   5 4 transaction
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++
1256 new fixed 2005 May anonymous   2005 May   3 3 Allow using non-default calling convention
1257 new fixed 2005 May anonymous VDBE 2005 May   5 3 3.5% speed improvement
1258 new fixed 2005 May anonymous VDBE 2005 May   5 3 20% sqlite speedup? Can it be true?
1259 code fixed 2005 May anonymous VDBE 2005 May   3 2 Small memory leak
1261 new closed 2005 May anonymous VDBE 2005 May   5 3 Optimization
1262 new active 2005 May anonymous VDBE 2005 May   5 3 5-15% performance increase for slow joins
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
1268 build closed 2005 May anonymous   2005 May   1 1 /usr/include/sys/context.h:155: parse error before "sigset64_t"
1279 doc fixed 2005 Jun anonymous   2005 Jun   4 4 Missing info about fourth arg to sqlite3_bind_* in API Reference
1288 code closed 2005 Jun anonymous   2005 Jun   1 1 Win32 Resource leak - InitializeCriticalSection(...)
1294 new closed 2005 Jun anonymous   2009 Oct   3 3 API to get ordinal table name
1309 build closed 2005 Jun anonymous   2005 Sep   1 1 make problem
1318 build closed 2005 Jul anonymous   2009 Oct   2 4 Build broken under Windows/MinGW
1368 new fixed 2005 Aug anonymous VDBE 2005 Sep   2 1 Aggregate queries against large tables use excessive amounts of memory
1371 new fixed 2005 Aug anonymous Parser 2005 Aug   1 1 This format not accepted for assigning a double: 12.e-3
1374 doc fixed 2005 Aug anonymous Unknown 2005 Aug drh 4 4 Documentation error for lang_createview.html
1391 code fixed 2005 Aug anonymous   2005 Aug   1 1 3.2.4 linux static binary shipped is not really static
1431 doc active 2005 Sep anonymous   2008 Jun mihailim 1 1 Please can FAQ 7 reference http://www.sqlite.org/lockingv3.html
1448 code closed 2005 Sep anonymous   2005 Sep   1 4 Parse Error In sqlite.c While Compiling PHP-5.0.5
1468 new closed 2005 Oct anonymous Parser 2009 Oct   5 5 Added Mysql function CONCAT
1469 event closed 2005 Oct anonymous Parser 2009 Oct   1 1 Having problems with subselects that work on mySQL
1471 todo fixed 2005 Oct anonymous   2005 Oct drh 5 4 Add link to home page to SQLite logo
1529 code closed 2005 Nov anonymous   2006 May   1 1 can not uses japanese as table name to create table
1543 build closed 2005 Nov anonymous   2009 Oct   2 1 File encrypted or corrupted while using french characters
1598 code review 2006 Jan anonymous   2006 Jan   3 2 Incorrect case-insensitive comparison of non-latin UTF-8 characters
1599 doc closed 2006 Jan anonymous   2006 Jan   5 5 Typo in FAQ not quite fixed
1622 code closed 2006 Jan danielk1977   2009 Oct   1 1 Compiling with OMIT_PRAGMA causes an error in the test suite
1630 code fixed 2006 Jan anonymous   2006 Jan drh 1 1 The TLS data is allocated/deallocated multiple times
1641 doc closed 2006 Jan anonymous   2006 Jan   5 4 Very minor documentation thing
1698 build closed 2006 Mar anonymous   2009 Oct   1 1 sqlite_4y6ngs9FlYvAMGO 0kb 3/1/2006 1:16 PM
1702 new fixed 2006 Mar anonymous   2009 Feb   5 4 feature request: API to write in-memory DB to file.
1717 code fixed 2006 Mar drh CodeGen 2006 Mar drh 1 1 CHECK constraints always use ABORT conflict resolution
1749 doc fixed 2006 Apr anonymous   2006 Apr   5 4 typo on FAQ web page
1750 doc fixed 2006 Apr anonymous   2006 Apr   5 4 typo on API reference web page
1772 new closed 2006 Apr anonymous TclLib 2009 Oct   5 5 db eval {QUERY} { do something } ELSE { there was no match }
1779 new closed 2006 Apr anonymous   2007 Nov   5 4 enhancement request (+ pointer) -- group_concat() aggregate function
1785 new closed 2006 Apr anonymous Shell 2009 Oct   4 3 rl_readline_name not set
1791 code closed 2006 May anonymous Unknown 2009 Oct   1 1 Native threads support for BeOS
1792 doc fixed 2006 May anonymous   2006 May   1 1 "commercial" is misspelled on the SQLite license page
1798 doc fixed 2006 May anonymous   2008 Jun mihailim 5 4 preprocessed is misspelled on download page
1805 code fixed 2006 May anonymous Shell 2006 May   3 4 missing out-of-memory check at src/shell.c:1485
1806 code fixed 2006 May anonymous TclLib 2006 May   3 4 Missing out-of-memory check at db/sqlite3/src/tclsqlite.c:1442
1811 doc closed 2006 May anonymous   2009 Oct   5 3 how many open cursors are allowed for one application?
1823 code closed 2006 May anonymous   2006 May   1 1 pysqlite2.dbapi2.OperationalError: unable to open database file
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
1859 code closed 2006 Jun anonymous Unknown 2006 Jun danielk1977 4 3 Wrong calculation og log2() in check-in [3274]
1866 event closed 2006 Jun anonymous   2006 Jun   1 1 SQLite.NET ExecuteNonQuery() limit of text size
1872 code closed 2006 Jun anonymous   2009 Oct   4 3 sqlite3_open doesn't support RFC1738 format for filename
1879 doc fixed 2006 Jul anonymous   2006 Jul   4 4 Perl is spelt Pearl on the http://www.sqlite.org page
1882 code closed 2006 Jul anonymous   2009 Oct   1 1 Wrong algorithm of SQLITE_VERSION_NUMBER calculation
1886 code fixed 2006 Jul drh   2006 Jul   1 1 Memory leak when malloc fails
1887 code fixed 2006 Jul anonymous TclLib 2006 Jul   1 1 Bad result on empty [db onecolumn]
1888 code closed 2006 Jul anonymous Unknown 2006 Jul anonymous 1 1 connetion to db extremely slow
1889 new fixed 2006 Jul drh   2006 Jul   1 1 Make sqlite3_interrupt() accessible from the TCL interface
1896 new closed 2006 Jul drh   2009 Oct   1 1 All extensions to be statically linked
1942 new closed 2006 Aug anonymous   2009 Oct   4 4 select without left join with the *= operator
1945 code closed 2006 Aug anonymous   2006 Nov   1 1 symbol not found: sqlite_freemem
1957 code fixed 2006 Sep anonymous   2006 Sep   4 4 Incorrect test messages: not compiled with -DSQLITE_DEBUG
1978 event fixed 2006 Sep anonymous   2006 Sep   1 1 Are e-mail addresses from check-in [3417] real ones ?
2039 code closed 2006 Oct anonymous   2006 Oct   1 1 How to delete SQLITE Temp files
2045 code fixed 2006 Oct anonymous   2006 Oct drh 5 4 Enhancement request: add "bail" command to sqlite3 shell
2049 code closed 2006 Oct anonymous   2006 Oct   1 1 sqlite_HrmKZy6ma4XBUGl is in my temp file and cannot be deleted.
2054 code closed 2006 Nov anonymous   2006 Nov   1 1 material to learn SQLite
2061 doc closed 2006 Nov anonymous   2009 Oct mihailim 5 5 cleanup for quickstart.html
2062 doc closed 2006 Nov anonymous   2009 Oct mihailim 4 4 document 'pk' column of PRAGMA table_info()
2084 code closed 2006 Nov anonymous   2009 Oct   4 3 Add API function mapping column decl string to SQLite type
2091 code closed 2006 Nov anonymous   2006 Nov   3 3 thread unsafety + solution
2110 build closed 2006 Dec anonymous   2009 Oct   4 3 Non-optional linking with readline makes sqlite3 binary GPL
2119 new closed 2006 Dec anonymous   2006 Dec   5 4 Unable to use place holders as part of the actual SQL query
2129 doc fixed 2006 Dec anonymous   2007 Jun   4 1 Typo in documentation for sqlite3_create_collation()
2153 code fixed 2007 Jan drh   2007 Jan   1 1 Error in the strftime() function
2162 code closed 2007 Jan anonymous   2007 Jan   1 1 c code compile fails with "Undefined reference to sqlite3_open()"
2168 doc fixed 2007 Jan anonymous   2007 Aug   4 1 Invalid documentation example - BLOB literal X'53514697465'
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
2185 new closed 2007 Jan anonymous   2009 Oct   5 3 API access to opened database pathname - helpful for virtual tables
2202 new closed 2007 Jan anonymous   2009 Oct   5 4 function request: sqlite3_attach()
2204 new closed 2007 Jan anonymous   2009 Oct   5 3 Stable, documented metadata interface
2212 code closed 2007 Feb anonymous   2007 Feb   5 4 function request: sqlite3_bind_literal()
2213 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Bug handling strings that are not nul-terminated.
2228 new closed 2007 Feb anonymous   2009 Oct   3 4 horizontal partitioning
2230 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Problem with virtual tables and grouping by aggregate function.
2238 new closed 2007 Feb anonymous   2009 Oct   2 3 Streams as datbase
2239 doc closed 2007 Feb anonymous   2007 Feb   1 1 Size of database in Speed Comparison?
2246 doc closed 2007 Feb anonymous   2009 Oct   5 4 SQL docs for CREATE TABLE should include FOREIGN KEY syntax
2262 code fixed 2007 Mar anonymous   2007 Mar drh 2 1 Dynamic allocation of tempory storage for pages
2265 doc closed 2007 Mar anonymous   2007 Mar   1 1 windows + xampp (php) + sqlite3 ... how?
2267 doc fixed 2007 Mar anonymous   2007 Mar drh 2 1 copyright.html grammer needs fix
2275 code closed 2007 Mar anonymous   2007 Mar   2 4 Can't get where clause to recognize equality with generated value
2277 code closed 2007 Mar anonymous   2007 Oct   1 1 Incorrect usage of CRITICAL_SECTION and TLS on Windows
2286 code fixed 2007 Apr drh   2007 Apr   1 1 Extra NULL value returned by a descending SELECT
2326 doc fixed 2007 Apr anonymous   2008 Jun mihailim 5 2 miss one word 'list'
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
2361 new closed 2007 May anonymous   2007 May   3 3 Why is no LIMIT suported in UPDATE-queries?
2380 code closed 2007 May anonymous   2007 May   1 1 Order By Collum1, Collum2, Collum3 for Pocket PC incorrect in device
2381 doc closed 2007 May anonymous   2009 Oct   3 3 'VACUUM' aborts an active transaction.
2382 doc fixed 2007 May anonymous   2007 Jul   3 3 VACUUM alters/repacks the ROWIDs if no explicit primary key is given
2386 doc closed 2007 May anonymous   2007 May   5 4 Suggestion for wiki speed comparisson: order by, group by, subselect
2398 code closed 2007 Jun anonymous   2009 Oct   2 3 systemcalls should be restarted when they return EINTR
2401 warn closed 2007 Jun anonymous   2009 Oct   1 1 I can't send anything to the contrib page
2408 code closed 2007 Jun anonymous   2009 Oct   2 1 BLOBs not output correctly in .mode insert (shell.c - isnumber)
2410 doc fixed 2007 Jun rdc   2007 Jun   5 3 typo in checkin 4053
2413 code active 2007 Jun anonymous   2008 Feb drh 1 1 1 bug and 2 suggestions in lemon
2421 code closed 2007 Jun anonymous   2007 Jun   1 1 unresolved external
2442 doc closed 2007 Jun anonymous   2008 Jun   1 4 mailing list link doesn't always exist in website header
2454 code fixed 2007 Jun drh   2007 Jun   1 1 Leading zeros cause large integers to be convert to floating point.
2456 new closed 2007 Jun anonymous   2009 Oct   5 5 REQ: use index where applicable instead of full table scan
2468 doc fixed 2007 Jun anonymous   2007 Jun   5 5 Spelling error in documentation
2472 code closed 2007 Jun anonymous   2007 Jun   1 1 smart quotes turning question marks while storing in oracle 9i DB
2475 code fixed 2007 Jun anonymous   2007 Jul   1 3 Handles being left open on unix
2479 code closed 2007 Jun anonymous   2009 Oct   1 1 WinCE regression on some systems. Any db open fails.
2480 code closed 2007 Jun anonymous   2007 Aug   4 4 typo in faq.tcl
2509 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLITE_DATE
2527 doc closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_create_module() API documentation missing
2547 code active 2007 Aug danielk1977   2007 Aug   5 3 Changing db encoding of an attached db can confuse shared cache mode.
2555 new closed 2007 Aug anonymous   2009 Oct   1 1 FTS index without original text
2560 doc fixed 2007 Aug anonymous   2007 Aug   5 4 Documentation typos
2564 event closed 2007 Aug anonymous   2007 Aug anonymous 4 4 in C:\windows\temp are 50 files like sqlite_fMyj88gwaTTNgUF and 0 kb
2572 warn closed 2007 Aug anonymous   2007 Aug   1 1 Sqlitw error unrecognize token
2583 build fixed 2007 Aug anonymous   2007 Aug   2 2 3.4.2 fails to build on Solaris due to conflict for B_FALSE and B_TRUE
2584 new closed 2007 Aug anonymous   2007 Aug   1 2 On Windows function sqlite3WinSleep needs to dispatch messages
2589 doc closed 2007 Aug anonymous   2007 Aug danielk1977 4 4 s/effected/affected/ in PRAGMA locking_mode
2591 doc fixed 2007 Aug anonymous   2007 Aug   4 4 sqlite3_open() documentation should mention :memory:
2604 new closed 2007 Aug anonymous   2009 Oct   4 4 CREATE VIRTUAL TABLE does not allow IF NOT EXISTS
2615 code fixed 2007 Sep anonymous   2007 Sep   1 1 winRandomness without effect due to < vs. > mixup
2651 new closed 2007 Sep anonymous   2009 Oct   5 4 Add support for overriding home directory location
2652 code active 2007 Sep drh   2007 Sep   1 1 Aggregate function cannot be used from within a subquery
2670 doc closed 2007 Sep anonymous   2007 Oct   5 4 Document for EXPLAIN doesn't mention using EXPLAIN QUERY PLAN
2677 new closed 2007 Sep anonymous   2009 Oct danielk1977 5 3 CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events
2706 warn closed 2007 Oct anonymous   2007 Oct danielk1977 4 4 make test aborts when built with SQLITE_OMIT_ATTACH
2710 code fixed 2007 Oct anonymous   2007 Oct   1 1 Typo in code specific to WinCE (checkin 4479)
2716 new closed 2007 Oct anonymous   2009 Oct   5 1 Create Clear Command
2728 code closed 2007 Oct anonymous   2009 Oct   4 4 Some indexes could contain pointers not the data
2743 doc closed 2007 Oct anonymous   2007 Oct   1 1 Comparison of SQLite against McObject Fusion
2747 code closed 2007 Oct anonymous   2007 Nov maria.khomenko 1 1 How to use Composite Key in Sqlite
2760 new closed 2007 Nov anonymous   2009 Oct   5 4 request: sqlite3_unlink() to delete db files.
2764 todo closed 2007 Nov anonymous   2007 Nov   2 2 Since I installed Leopard I keep getting sqlite3 data bases in trash
2769 new closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 Enable access to the sql string used to prepare a statement
2776 warn closed 2007 Nov anonymous   2008 Mar   5 1 mailing list
2778 code closed 2007 Nov anonymous   2007 Nov adixon 1 1 Error 0
2779 code closed 2007 Nov anonymous   2007 Nov   2 2 Performance optimizations
2803 code fixed 2007 Nov anonymous   2007 Nov   4 3 test: io-4.2.2 fails on 64-bit --- signed extension
2811 code fixed 2007 Nov anonymous   2007 Nov   5 4 "appropriate" misspelled "approriate" on SQLite Documentation page
2821 new closed 2007 Dec anonymous   2009 Oct   3 4 hashtable indicies
2833 doc fixed 2007 Dec anonymous   2007 Dec   5 1 typo on SQLite home page
2840 doc fixed 2007 Dec anonymous   2007 Dec   5 4 Punctuation errors in comment
2841 todo closed 2007 Dec anonymous   2009 Oct   1 1 The sqlite mailing list has become overrun by trolls
2843 code fixed 2007 Dec anonymous   2007 Dec   3 4 Low memory crash in sqlite3ExprCodeAndCache
2849 doc fixed 2007 Dec anonymous   2007 Dec   5 5 unary operator !
2856 doc closed 2007 Dec anonymous   2009 Oct anonymous 4 3 SQLite Documentation - Tcl API - Link broken
2861 doc closed 2007 Dec anonymous   2008 Jan   1 1 How do I connect to Crystal Reports - I am using vs2003 & the Finisar
2872 code closed 2008 Jan anonymous   2009 Oct   4 4 Some table scan operations could use an index for better data density
2874 code closed 2008 Jan anonymous   2009 Oct   1 1 THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c
2892 new closed 2008 Jan anonymous   2009 Oct   5 5 There should be a way in the api to read more precise error message.
2907 code closed 2008 Jan anonymous   2009 Oct   1 1 Issues of sqlite3 with Windows Mobile 5/6
2912 new closed 2008 Jan anonymous   2009 Oct   5 4 merge join
2916 code fixed 2008 Feb anonymous   2008 Feb   1 1 sqlitedll-3_5_5.zip is older 3.5.4 binary
2928 doc closed 2008 Feb anonymous   2008 Jun   5 4 Incorrect C example on "SQLite In 5 Minutes Or Less"
2930 new closed 2008 Feb anonymous   2009 Oct   3 3 Command line could works with multibyte chars on the current locale
2931 new closed 2008 Feb anonymous   2009 Oct   1 1 auto-detect page size
2946 new closed 2008 Feb anonymous   2009 Oct   4 4 16bit version of sqlite3_bind_parameter_index
2955 doc fixed 2008 Feb anonymous   2008 Feb   5 4 typo on website
2956 new closed 2008 Feb anonymous   2009 Oct   1 5 alter table xxx add column yyy; on empty table (no records)
2968 doc closed 2008 Feb anonymous   2008 Mar   5 4 Documentation typo
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
2989 code closed 2008 Mar anonymous   2008 Mar   1 1 cannot DELETE from table named: 'catalogs'
3001 code fixed 2008 Mar anonymous   2008 Apr   3 4 lemon: repeat %include
3012 code closed 2008 Mar anonymous   2008 Mar   1 1 called in inappropriate state
3031 doc fixed 2008 Apr anonymous   2008 Apr   5 4 Typo in "Atomic Commit In SQLite" document
3074 new closed 2008 Apr anonymous   2009 Oct   1 1 support for parentheses around UNION sub-queries
3088 code closed 2008 Apr anonymous   2008 Apr   1 1 warning C4311: 'type cast' : pointer truncation from 'char *' to 'sqli
3089 code fixed 2008 Apr drh   2008 Apr   1 1 Fix the implementation of sqlite3_isnan()
3095 new closed 2008 May anonymous   2009 Oct   1 1 DELETE FROM should support aliasing
3096 code fixed 2008 May drh   2008 May   1 1 Small-file CLI segfaults when given a large file
3120 code closed 2008 May anonymous   2008 May   4 4 All the os_.c source files are missing version tags
3138 doc closed 2008 May anonymous   2008 Jun   5 4 global cache size
3149 code closed 2008 May drh   2009 Oct   1 1 UPDATE does not adjust the sqlite_sequence table
3152 doc closed 2008 May anonymous   2009 Oct mihailim 5 4 Minor SQL documentation improvement suggestions
3177 doc fixed 2008 Jun anonymous   2008 Jun   1 1 Miswriting in article "SQLite's Use Of Temporary Disk Files"
3178 new closed 2008 Jun anonymous   2009 Oct   5 4 A bit more built-in functions
3185 code closed 2008 Jun anonymous   2008 Jun   1 1 bug in Alter table command
3192 new closed 2008 Jun anonymous   2008 Jun   4 3 Feature Request: Add Date & Time Functions to 'DEFAULT' table syntax
3193 code fixed 2008 Jun anonymous   2008 Jun   5 4 wrong description in comment describing sequnce
3208 new closed 2008 Jul anonymous   2008 Jul   1 1 new function :sqlite3_columns_values()
3214 code fixed 2008 Jul anonymous   2008 Jul   5 4 lemon: [5335] stops #line being generated for %include
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
3258 new closed 2008 Jul anonymous   2009 Oct   5 4 csv import
3265 doc closed 2008 Aug anonymous   2009 Oct   5 5 Not implemented features - triggers
3269 code closed 2008 Aug anonymous   2008 Aug drh 1 1 API functions not exported from sqlite
3285 new active 2008 Aug anonymous   2008 Aug drh 5 5 Add a module_list pragma to display all modules installed
3286 code closed 2008 Aug anonymous   2008 Aug   3 3 Reading long text generates error
3294 code closed 2008 Aug anonymous   2008 Aug   3 3 sqlite3_open_v2
3301 code fixed 2008 Aug anonymous   2008 Aug drh 1 4 Problem resolving columns in a nested subquery
3304 doc closed 2008 Aug anonymous   2009 Oct   1 1 Erroneous strftime documentation
3327 doc fixed 2008 Aug anonymous   2008 Aug   5 4 OP_MoveTo
3340 code closed 2008 Aug anonymous   2008 Aug   2 1 how to use Sqlite Source Code in Vb.net Program (without dll files)
3355 new closed 2008 Sep anonymous   2008 Sep   2 2 Multi-instance support of SQLite Engine
3371 code fixed 2008 Sep rdc   2008 Sep   2 3 wrong column names for queries with aggregate functions
3380 code closed 2008 Sep anonymous   2008 Sep   5 5 Timeline shows dates in weird format
3436 new closed 2008 Oct anonymous   2009 Oct   1 1 Provide API method to test for available extensions
3443 doc closed 2008 Oct anonymous   2008 Oct   3 1 Syntax in BNF?!
3454 code closed 2008 Oct anonymous   2008 Oct   3 3 hardcoded 32KB pagesize max may be too low
3482 code fixed 2008 Nov drh   2008 Nov   1 1 Buffer overrun on UTF-16BE to UTF-8 conversion
3503 doc closed 2008 Nov anonymous   2008 Nov   5 5 SELECT documentation uses "as" instead of "has"
3504 code closed 2008 Nov anonymous   2008 Nov   5 4 pragma table_info returns quoted text
3515 code closed 2008 Dec drh   2009 Oct   1 1 INTERSECT operator should have higher precedence
3534 new closed 2008 Dec anonymous   2009 Oct   4 4 sqlite3_stmt_status api include row change counters.
3536 code fixed 2008 Dec drh   2008 Dec   1 1 Incorrect evaluation of: WHERE rowid>922337236854775807
3541 code fixed 2008 Dec drh   2008 Dec   1 1 Use of ~ operator on repeated aggregate terms causes incorrect result.
3557 new closed 2008 Dec anonymous   2008 Dec   1 4 GUID primary keys
3563 new closed 2009 Jan anonymous   2009 Oct   5 4 AUTOINCREMENT FROM i BY j enhancement
3566 code closed 2009 Jan anonymous   2009 Oct   1 1 "unable to open database file" under cygwin build
3585 code fixed 2009 Jan anonymous   2009 Jan   5 5 .schema doesn't work with full_column_names=1
3637 code closed 2009 Feb anonymous   2009 Feb   1 1 segmentation fail ossurs then execute create table on arm
3643 code closed 2009 Feb anonymous front 2009 Feb   2 3 sqlite_bind_parameter_name() failure
3650 doc active 2009 Feb anonymous   2009 Feb   4 3 documentation error in c3ref/changes.html
3653 secure closed 2009 Feb anonymous   2009 Feb   1 1 how to register
3655 new closed 2009 Feb anonymous   2009 Feb   5 3 Add month() and year() functions
3666 code active 2009 Feb anonymous   2009 Feb   3 1 softHeapLimitEnforcer called too many times
3681 new closed 2009 Feb anonymous front 2009 Oct   1 1 have AUTOINCREMENT in column-indexed statment, not only in column-def
3714 xplatform closed 2009 Mar anonymous cli 2009 Oct   4 3 sqllite does not accept --help for help
3750 new closed 2009 Mar anonymous   2009 Jul   5 4 Use other separator than space for matches in offsets function of FTS3
3759 build fixed 2009 Mar anonymous   2009 Mar   1 1 Error Compiling with Borland BCC
3764 code closed 2009 Mar anonymous ext 2009 Oct   3 4 contrib: extension-functions.c
3794 code closed 2009 Apr anonymous func 2009 Apr   4 3 FAIL on SQL query causes sliqte3 to return SQLITE_CONSTRAINT twice
3822 website closed 2009 Apr anonymous   2009 Apr drh 5 4 Sitemap says "browse bug beports"
3826 code closed 2009 Apr anonymous vfs 2009 Oct   2 2 sqlite3VXPrintf optimization suggestions
3850 new closed 2009 May anonymous test 2009 Oct   5 4 additional test
3892 website closed 2009 Jun anonymous   2009 Jun   5 5 typo on download page
3913 code active 2009 Jun anonymous tcl 2009 Jun   4 4 Some variables in bubble-generator.tcl are being used before being set
3943 build closed 2009 Jul anonymous build 2009 Oct   4 4 Problems when linking a not-threaded program to a shared sqlite
3949 code closed 2009 Jul anonymous   2009 Jul   1 1 About COMMIT and ROLLBACK
3952 new closed 2009 Jul anonymous   2009 Jul   5 4 Feature request: sqlite3_create_function_v2()
3978 code closed 2009 Jul danielk1977 ext 2009 Jul   1 1 Asynchronous IO is incompatible with multi-file transactions
3993 warn closed 2009 Jul anonymous   2009 Sep   2 2 warnings in 3.6.16
4001 code closed 2009 Jul anonymous func 2009 Oct   1 1 "SQL error: database table is locked" for user function
4002 new closed 2009 Jul anonymous back 2009 Oct   5 4 PRAGMA to force all tables to use AUTOINCREMENT behavior
4004 new closed 2009 Jul anonymous   2009 Nov   5 2 Implement a "counter" SQL function
4007 new closed 2009 Aug anonymous func 2009 Aug   1 1 New group_split() function as inverse of group_concat()
4008 new active 2009 Aug anonymous func 2009 Aug   1 1 2-digit year number in strftime() function by new 'y' switch
4021 website closed 2009 Aug anonymous   2009 Sep   5 4 List of well know users
4023 code closed 2009 Aug anonymous   2009 Aug   3 3 Error when connect to SQLite on Linux platform
4038 doc closed 2009 Aug anonymous   2009 Sep   4 4 Documentation error
4041 code closed 2009 Oct anonymous   2009 Oct   1 1 sqlite3_create_function and INDEXED column values
453 code fixed 2003 Sep anonymous Parser 2003 Sep   3 3 "SELECT a, b FROM tt;-" Crashes SQLite
45 code closed 2002 May anonymous   2002 Sep   4 4 Unique constraint problem on updating PRIMARY KEY column
1379 warn closed 2005 Aug anonymous Unknown 2009 Oct   1 1 cannot install . phpize failed
2550 code fixed 2007 Aug anonymous   2007 Oct drh 3 3 Lemon parser may accept input before EOF is seen
1571 code closed 2005 Dec anonymous   2005 Dec   1 1 SQLiteCC crashes when you rollback create table
3175 new closed 2008 Jun anonymous   2009 Oct   1 1 multiple row insert
697 event closed 2004 Apr anonymous Unknown 2009 Oct   3 4 Questionable locking
1870 code closed 2006 Jun anonymous   2006 Jun   2 2 dbWriteTable in RSQLite can't write strings that contain commas.
2007 code closed 2006 Oct anonymous   2006 Oct   1 1 Server has unexpecedly died/u've found a bug/ i cant connect to hub
475 code closed 2003 Oct anonymous   2003 Oct   1 1 question:how to use the sqlite in my VC6 project?
503 warn closed 2003 Nov anonymous Unknown 2009 Oct anonymous 5 2 Include sqlite source in Visual C++ 6.0 SP5
1555 doc closed 2005 Dec anonymous BTree 2008 Jun   2 4 sqlite+Crystal reports connection
2300 code closed 2007 Apr anonymous   2007 Apr   1 1 compound query ORDER BY expression problem
2471 secure closed 2007 Jun anonymous   2007 Jun   1 1 a bug for 64 bit driver under operation system
487 code fixed 2003 Nov anonymous   2003 Nov   2 2 mac os x build via pear creates invalid bundle
723 new closed 2004 May anonymous Unknown 2009 Oct   5 4 BatchScript: Example windows batch script for creating databases.
1463 code closed 2005 Sep anonymous   2005 Sep   3 1 can't see views in browser 1.0
2771 code active 2007 Nov anonymous   2007 Nov   4 4 Lemon: Generated parser needs stdlib.h (not in default template)
659 code fixed 2004 Mar anonymous   2004 Mar   4 4 +1 month issue (dead or defective code) in date.c
2343 code fixed 2007 May anonymous   2007 May drh 2 3 mallo.c typo in v 1.168/check in 3925 of Makefile.in
195 code fixed 2002 Nov anonymous   2002 Nov   2 4 Borland Compiler error for long long definition in os.h
3579 doc fixed 2009 Jan anonymous   2009 Jan   4 3 rowset.c missing versioning tags
692 code fixed 2004 Apr anonymous Parser 2004 Apr   3 3 lemon.c:void emit_destructor_code() pointer unitialized
3975 code fixed 2009 Jul anonymous test 2009 Jul shane 4 4 tableapi.test section 3 runs when compiled with SQLITE_OMIT_GET_TABLE
3578 doc fixed 2009 Jan anonymous   2009 Jan   5 4 Incorrect comment in pragma.c regarding journal_size_limit
3131 code closed 2008 May anonymous func 2009 Oct   4 4 PRAGMA encoding doesnt return encoding compiled with SQLITE_OMIT_UTF16
3849 doc closed 2009 May anonymous func 2009 Oct   5 4 Mispelling in util.c
892 code fixed 2004 Sep anonymous   2004 Sep   3 1 LEMON can't generate well-formed Windows parsers with full paths
895 code fixed 2004 Sep anonymous   2004 Sep   4 4 LEMON doesn't like single-line parse_failure code.
897 code fixed 2004 Sep anonymous   2004 Sep   3 4 LEMON: Line numbers in generated parser.c are off. (Windows)
2723 new closed 2007 Oct anonymous   2007 Oct anonymous 5 4 After execution of SQL, the Data Returned should display the col.name
3704 doc closed 2009 Mar anonymous front 2009 Oct   4 5 Clarify parameter documentation for isLikeOrGlob in where.c
3677 warn closed 2009 Feb anonymous vfs 2009 Feb danielk1977 5 5 os_common.h may have unneeded definition of sqlite3_pending_byte
3219 doc fixed 2008 Jul anonymous   2008 Jul   4 3 SQLITE_CONFIG_GETMUTEX documention has incorrect header
3799 doc closed 2009 Apr anonymous front 2009 Oct   5 4 Comment is incomplete in where.c
2172 code fixed 2007 Jan anonymous   2007 Jan   5 1 crash when lemon (wireshark) is built with -DNDEBUG
3914 code fixed 2009 Jun anonymous back 2009 Jun shane 4 4 Linkage error in where.c when compiled with SQLITE_OMIT_VIRTUALTABLE
2164 code fixed 2007 Jan anonymous   2007 Jan   4 5 Possibly a typo in lemon.c
2171 code review 2007 Jan anonymous   2007 Jan drh 3 3 Fix a major leakage of token minors in lemon generated parsers
2175 code fixed 2007 Jan anonymous   2007 Mar   3 3 lemon calling destructors more than once
2862 warn closed 2007 Dec anonymous   2008 Jan   4 3 Small warning fix
3924 doc fixed 2009 Jun anonymous back 2009 Jun   4 4 Comment in expr.c doesn't make sense
3119 code fixed 2008 May anonymous   2008 May   4 4 loadexe.c missing version comment
3118 code fixed 2008 May anonymous   2008 May   4 4 fault.c does not contain a version comment
3916 code closed 2009 Jun anonymous back 2009 Jun   4 4 unneed assignment in build.c
3699 doc closed 2009 Mar anonymous back 2009 Mar   5 5 Clarify parameter documentation for pager_playback_one_page in pager.c
3293 build fixed 2008 Aug anonymous   2008 Aug   4 4 Fix a bunch of Win64 compilation errors by cowardly casting size_ts to
3915 code closed 2009 Jun anonymous back 2009 Jun   4 4 assert statement repeated in btree.c
3971 code closed 2009 Jul anonymous back 2009 Oct   4 4 TRACE error in btree.c when page is null
3830 doc fixed 2009 Apr anonymous test 2009 Apr   4 4 blob.test test numbers out of sequence
3435 code fixed 2008 Oct anonymous   2008 Nov   4 4 vacuum2 regression test does not check for SQLITE_OMIT_AUTOVACUUM
3071 doc closed 2008 Apr anonymous   2008 Apr   2 1 BNF for CREATE TABLE on sqlite.org is wrong
3619 doc fixed 2009 Jan anonymous back 2009 Feb   4 4 obsolete MakeIdxRec opcode references in vdbe.c
3413 code closed 2008 Oct anonymous   2008 Oct drh 2 4 strftime("%w", "whatever") returns wrong weekday number
3453 doc fixed 2008 Oct anonymous   2008 Nov   4 4 pragma.c documention error
657 code closed 2004 Mar anonymous Unknown 2004 Mar   1 1 Wrong reported columncount in CallBack routine
976 code closed 2004 Oct anonymous   2004 Oct   1 1 Locale & upper/lower
3490 code fixed 2008 Nov anonymous   2008 Nov   1 1 Reading dump causes string errors
1129 new closed 2005 Feb anonymous Unknown 2005 Feb drh 4 3 allow having the same object in several open databases
2961 code closed 2008 Feb mlcreech   2008 Feb danielk1977 3 3 Reproducible segfault when executing ioerr3-2
2098 warn closed 2006 Dec anonymous   2009 Oct   1 1 php sqlite problem after commit transaction
154 code closed 2002 Sep drh Pager 2009 Oct drh 3 3 Prohibit links on database files.
74 new defer 2002 Jun anonymous   2004 Nov   4 2 2.5 database file still says "SQLite 2.1 database"
107 code closed 2002 Jul anonymous   2002 Sep   1 1 Incorrect query results
103 code closed 2002 Jul anonymous   2002 Jul   2 1 Memory Leak in the Server
604 warn fixed 2004 Feb anonymous Parser 2004 Feb   4 4 'db' has been referenced but never assigned a value
12 new review 2002 Apr anonymous   2002 Jul   2 4 adding win32 multi process support using a Mutex
92 code closed 2002 Jul anonymous   2002 Sep   2 2 max() looks boggus in a view
15 code closed 2002 Apr anonymous CodeGen 2002 May   5 4 getting the number of affected lines is harder than necessary
94 code closed 2002 Jul drh Pager 2002 Sep   1 1 ROLLBACK fails to restore all pages
3 code closed 2002 Mar anonymous Parser 2002 May   1 1 Rejects "view" as column name
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
37 code closed 2002 May anonymous   2004 Nov   3 3 can't open dbfile by apache process under mod_perl env.
38 code closed 2002 May danielk1977 CodeGen 2009 Sep   3 5 Count-changes broken for: DELETE FROM <table-name> (no WHERE clause)
39 todo closed 2002 May drh   2002 Sep   5 1 Reformat the TRIGGER code for consistent style.
41 code closed 2002 May drh   2002 Sep   1 2 sqlite_complete() failure
44 code closed 2002 May anonymous   2002 Sep   3 3 UNIQUE constraint (incorrectly) applies to NULL
47 code closed 2002 May anonymous   2002 Sep   5 4 Compiler Warning using MingW/gcc
51 doc closed 2002 May danielk1977 CodeGen 2002 May danielk1977 5 3 Triggers problem with INTEGER PRIMARY KEY
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
54 todo closed 2002 Jun anonymous   2002 Sep   2 2 win32 binaries are missing symbols
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
61 new closed 2002 Jun anonymous   2002 Jun   1 1 Enhancement Request: Capability to Specify Table Join Type
62 code closed 2002 Jun danielk1977 VDBE 2002 Sep   3 4 TEMP tables with a read-only database
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
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.
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
76 code closed 2002 Jun anonymous   2002 Sep   1 3 sqlite corruption possibly relating to drop of index
4 new closed 2002 Mar persicom Shell 2002 May   2 3 Change prompt of 'sqlite' query tool.
6 code closed 2002 Apr danielk1977 CodeGen 2002 May   1 1 Query optimizer does not consider function arguments
7 code closed 2002 Apr danielk1977 VDBE 2002 May   5 2 VDBE trace prints out garbage for P3 of Function opcodes
30 new fixed 2002 Apr anonymous   2005 Feb drh 2 4 Correlated subqueries are not supported
8 code closed 2002 Apr danielk1977 CodeGen 2002 May   2 1 More problems with where.c
16 code closed 2002 Apr anonymous CodeGen 2002 May   2 2 sqlite cores
20 code closed 2002 Apr anonymous   2002 Apr drh 1 1 Order By clause not sorting correctly for string columns
19 new closed 2002 Apr danielk1977 BTree 2002 May   3 4 synchronous pragma does not effect TEMP tables
21 code closed 2002 Apr anonymous Shell 2002 May   1 1 2.4.8 SQLITE.EXE: out of memory! (Windows98)
181 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 5 5 MAX Function on NULL Values
22 code closed 2002 Apr anonymous   2002 Sep drh 2 1 compound selects as expressions
24 code closed 2002 Apr anonymous   2002 Apr drh 4 3 Make "update ... where ..." fail if where clause is false.
27 code closed 2002 Apr anonymous   2002 Apr drh 2 2 incorrect result when doing select using quotes in where
28 code closed 2002 Apr anonymous   2002 Sep drh 3 1 sqlite_changes not exported in sqlite.def in SQLite_source.zip
31 code closed 2002 Apr danielk1977 CodeGen 2002 Sep   4 4 SELECT without FROM
36 code closed 2002 May anonymous   2002 May   4 3 drop table doesn't clean up database
43 event closed 2002 May anonymous   2008 Mar drh 1 1 sqlite compile without readline on linux slackware 8.0
77 code closed 2002 Jun anonymous   2002 Sep   2 2 more than one LIMIT on nested select shows 0 rows
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.
80 code closed 2002 Jun anonymous   2002 Sep   2 2 Heap corruption on select with ORDER BY, LIMIT, and OFFSET
81 code defer 2002 Jun     2002 Jun   4 3 Single process on NFS
111 doc closed 2002 Jul anonymous   2002 Sep   1 3 2.6.1 does not permit SELECT within TRANSACTION whereas 2.5.5 did
84 code closed 2002 Jun drh   2002 Sep   1 1 Complex left outer joins might give the wrong answer
83 todo closed 2002 Jun drh   2002 Sep drh 1 1 Add test cases
85 todo closed 2002 Jun drh   2003 Apr   1 1 Document and test the sqlite_open_aux_file() API.
86 new defer 2002 Jun anonymous   2002 Jun   5 2 Add SAFEARRAY support for WIN32 clients of SQLite.DLL.
90 code closed 2002 Jul anonymous   2002 Sep   1 1 table aliases in select commands stopped working
109 new closed 2002 Jul anonymous   2002 Jul   5 4 Can the build process include a way to make a static library?
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
133 code fixed 2002 Aug anonymous Unknown 2002 Aug   5 5 sqlite.exe crashes
124 code closed 2002 Jul anonymous Unknown 2002 Sep anonymous 2 1 Segfault on a join using an INTEGER PRIMARY KEY.
112 code closed 2002 Jul anonymous   2002 Sep   4 4 Segmentation fault in 2.5.5 when opening a 2.6.1 database
101 new closed 2002 Jul anonymous   2009 Mar   3 3 builtin functions do not work properly with LIMIT clause
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
110 new closed 2002 Jul anonymous Unknown 2002 Sep anonymous 5 4 Refuse multiple begin transaction or commit
100 code closed 2002 Jul anonymous   2002 Sep   1 2 view not properly restored after closing and reopening database
87 new closed 2002 Jun anonymous   2005 Jan   1 4 ORDER BY & ISO 8859-2
118 code closed 2002 Jul anonymous   2002 Jul   1 1 Under WinNT4.04 Call Opendatabase or Else Function Generate Error
3367 doc closed 2008 Sep anonymous   2008 Sep a.rottmann 5 4 Data Base Samples downloads?
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
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++
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
125 code closed 2002 Jul anonymous   2002 Jul   2 1 Data and Category SELECT bug
1438 code closed 2005 Sep anonymous   2005 Sep   4 4 UPDATE bug
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
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
130 code fixed 2002 Aug anonymous   2002 Aug   3 3 No transactions across Linux threads seems restrictive.
131 code fixed 2002 Aug drh   2002 Aug drh 1 1 ORDER BY ignored when used with GROUP BY on an indexed column
132 new fixed 2002 Aug anonymous Unknown 2002 Aug   3 3 Temp file path
163 code fixed 2002 Oct anonymous Unknown 2002 Oct   2 2 Buggy initialization of random generator on win32
134 code fixed 2002 Aug anonymous Parser 2002 Aug anonymous 2 4 syntax error in lemon.c on IBM AIX systems (both gcc and xlc)
135 new fixed 2002 Aug anonymous   2002 Aug   5 4 Code optimizations (to reduce compilation warnings under BC5 Windows)
136 code fixed 2002 Aug drh CodeGen 2002 Aug drh 1 1 Segfault on VIEW of a subquery
137 code fixed 2002 Aug anonymous Shell 2002 Aug   4 3 shell's find_home_dir() is ineffecient
138 code fixed 2002 Aug jadams   2002 Aug   4 4 Makefile doesn't use exec_prefix, has some install problems
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
148 code closed 2002 Sep anonymous Unknown 2002 Sep anonymous 3 3 sqlHashFind() segfaults in a created function
452 code fixed 2003 Sep anonymous TclLib 2003 Dec   4 3 DbMain assumes sscanf likes 0x... syntax for pointers, breaking tests
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.
140 todo fixed 2002 Aug drh CodeGen 2002 Aug drh 4 4 Enhance INSERT ... SELECT to omit the intermediate temporary table
142 code fixed 2002 Aug anonymous   2002 Aug   1 1 Incorrect Order By when column is null
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)
145 code closed 2002 Aug anonymous Unknown 2002 Aug   1 1 Tests failing
153 code fixed 2002 Sep anonymous Parser 2003 Jan   1 1 PRAGMA SHOW_DATATYPES bug
146 code fixed 2002 Sep drh Pager 2002 Sep drh 1 1 Disk I/O error encountered on very large transactions
147 code fixed 2002 Sep anonymous   2002 Sep   1 1 "INSERT into xxx SELECT yyy ORDER BY zzz LIMIT 1" ignores the limit
149 new closed 2002 Sep anonymous Unknown 2002 Sep   5 4 SELECT UNIQUE
150 doc fixed 2002 Sep anonymous Unknown 2002 Sep anonymous 2 2 Missing documentation files
152 code fixed 2002 Sep anonymous Unknown 2002 Sep   1 1 "make test" has errors
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
159 code fixed 2002 Oct anonymous Unknown 2003 Apr drh 2 2 Triggers don't work _at all_ in the presence autoincrement fields
160 code fixed 2002 Oct anonymous   2005 Jan   1 4 trigger not called when user-defined function used
162 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 3 2 mismatch in response column and Group by column is ignored
205 code closed 2002 Dec anonymous VDBE 2002 Dec   4 4 select order by on a column with null values causes uninitialized-read
248 code closed 2003 Feb anonymous Unknown 2003 Nov   1 2 SQLColumn function in ODBC returns incorrect datatype
251 code closed 2003 Feb anonymous   2003 Mar   1 1 ORDER BY doesn't work on TIMESTAMP column type
155 code fixed 2002 Sep anonymous Unknown 2002 Dec   2 2 sqliteSortCompare var dir uninitialized
161 code closed 2002 Oct anonymous Unknown 2003 Dec   1 1 Left join with 3 tables bug ?
164 event closed 2002 Oct anonymous CodeGen 2008 Jun anonymous 3 4 Compiler warnings with MS Visual C++ 6.0
166 code fixed 2002 Oct anonymous Unknown 2002 Oct   1 1 Left outer join doesn't seem to be working
167 new closed 2002 Oct anonymous Shell 2002 Dec   5 4 Difficult to quickly quit sqlite
168 new fixed 2002 Oct anonymous Shell 2003 Apr   4 4 Startup file complicates dumping a database
170 code closed 2002 Oct anonymous TclLib 2002 Oct anonymous 2 2 Insert / select text with cp1250 characters
171 code fixed 2002 Oct anonymous   2002 Oct drh 1 3 incompatibility with Borland run-time library
172 code tested 2002 Oct anonymous   2002 Oct drh 3 3 incompatibility with Borland compiler
173 todo fixed 2002 Oct anonymous   2002 Oct drh 4 3 publish.sh does not build dll correctly
174 code fixed 2002 Oct anonymous Unknown 2002 Oct drh 1 3 inconsistent data types
175 new closed 2002 Oct anonymous Pager 2009 Oct   5 3 journal file should be kept open
176 code fixed 2002 Oct mike   2002 Oct drh 1 3 locking mechanism fails under Windows
177 code tested 2002 Oct danielk1977 VDBE 2003 Jan   1 4 Memory handling problem for very large aggregate results
178 code fixed 2002 Oct anonymous Unknown 2002 Oct   2 3 Undefinied pointer with sqlite_get_table (empty result set)
179 code fixed 2002 Oct drh   2002 Oct anonymous 1 1 Column names and string constants in parentheses cause errors.
180 event closed 2002 Oct anonymous   2009 Oct anonymous 1 1 on WIN32 - multithreaded process causes crash on assert(mutext)
183 code closed 2002 Oct anonymous   2002 Nov drh 1 1 Bug regarding grouping, left joining, aggregate functions
184 new closed 2002 Oct mike   2009 Oct drh 5 3 auto update mechanism for CVS
185 code fixed 2002 Oct anonymous Unknown 2002 Oct   1 1 Crash when running specific SQL
581 code closed 2004 Jan anonymous Parser 2004 Jan   3 1 Failure for lemon.c to compile on MacOSX (fixed as well ;-))
187 code fixed 2002 Nov anonymous Parser 2002 Dec   2 2 Having count(*) issue
189 code fixed 2002 Nov anonymous   2002 Nov   4 4 sqlite html output format produces extra </TD>
190 code fixed 2002 Nov anonymous   2002 Nov   1 3 the btree code crashes on LP64 systems
191 code fixed 2002 Nov anonymous Unknown 2003 Jan drh 1 1 Large file support does not work in Windows
192 doc closed 2002 Nov anonymous Unknown 2009 Oct anonymous 4 4 Finishing build on MacOS 10.x (and other *nix's, likely)
193 code fixed 2002 Nov anonymous Unknown 2002 Dec   3 3 Incorrect creation of a VIEW when using SELECT ... LIMIT
194 new fixed 2002 Nov anonymous BTree 2003 Apr   5 3 Remove warnings in btree.c
196 code closed 2002 Nov anonymous BTree 2003 Jul   4 3 there are the same record in a table,why?
199 new closed 2002 Dec anonymous Unknown 2005 Jan drh 4 4 Encryption
200 code fixed 2002 Dec anonymous Pager 2002 Dec   3 3 full pathname of database not recorded, so errors when chdir used
202 code fixed 2002 Dec anonymous   2002 Dec   1 1 make test core-dumps on solaris
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!)
208 code fixed 2002 Dec anonymous BTree 2002 Dec   2 2 pager.c uninitlized local variable
214 code closed 2003 Jan anonymous Unknown 2003 Jan   1 1 segmentation fault on ETRAX board - started in version 2.7.4
222 code fixed 2003 Jan anonymous VDBE 2003 Jan   3 3 cleanup tries to access memory out of array bounds
223 code fixed 2003 Jan anonymous VDBE 2003 Jan   3 3 using uninitialized memory's value
224 code fixed 2003 Jan anonymous Pager 2003 Jan   3 3 read overflows memory
210 code fixed 2002 Dec anonymous Unknown 2003 Jan drh 1 1 Segfault on OSX with Perl bindings
209 new closed 2002 Dec anonymous BTree 2008 Jun   1 1 update libtool
211 new fixed 2002 Dec anonymous Unknown 2003 Jan   4 4 How to add comments to an SQL-File
212 code fixed 2003 Jan drh Pager 2003 Jan   2 1 Corrupt database results if the very first transaction rolls back.
213 new fixed 2003 Jan anonymous Unknown 2003 Aug   4 4 Cygwin port needs __CYGWIN_USE_BIG_TYPES__ defined
215 new fixed 2003 Jan anonymous   2003 Feb   4 2 sqlite authorizer callback
217 code review 2003 Jan anonymous Unknown 2003 Jan anonymous 4 4 opcodes.c missing from the makefile SRC macro
218 new fixed 2003 Jan anonymous   2003 Jan   2 2 MacOS port for submission to CVS
220 code fixed 2003 Jan anonymous   2003 Jan   4 3 AS clause disables retrieving data types
221 doc fixed 2003 Jan anonymous   2003 Jan   2 4 pragma show_datatypes not documented
226 code fixed 2003 Jan anonymous Unknown 2003 Jan   2 2 Glob doesn't work for upercase letters
228 event closed 2003 Jan anonymous Unknown 2003 Jan drh 1 1 The size of database file is not decreased .
232 code fixed 2003 Jan anonymous Parser 2003 Feb   2 2 group by result is wrong
313 code fixed 2003 May anonymous Unknown 2003 May   2 3 Creating a table with a specific name crashes SQLite.
2966 code closed 2008 Feb anonymous   2008 Feb   1 1 SQL error: database disk image is malformed
225 code fixed 2003 Jan anonymous Unknown 2003 Jan   3 4 reading uninitialized memory
227 code fixed 2003 Jan anonymous Pager 2003 Jan   2 1 win32 db locked
909 code closed 2004 Sep anonymous Unknown 2004 Oct   1 1 Inconsistent unordered and ordered selects (index corruption?)
234 code fixed 2003 Jan anonymous   2003 Apr   4 4 Impossibility to have Comments and DOT-Commands in an SQL-File
235 new closed 2003 Jan anonymous Unknown 2008 Jun chw 5 1 Local language do not support!
237 code fixed 2003 Jan anonymous Parser 2003 Jan   2 2 suspected problem in IN operator
238 code fixed 2003 Feb drh CodeGen 2003 Feb   1 1 Assertion failure after some incorrect SQL
239 new closed 2003 Feb anonymous Unknown 2009 Oct   4 2 ANSI/Unicode(Wide) version file-handling functions for Win32
240 code fixed 2003 Feb anonymous   2003 Apr   5 4 fcntl return code checked instead of errno
241 new closed 2003 Feb anonymous   2008 Jun anonymous 5 5 lack of alter table statement
244 new closed 2003 Feb anonymous Unknown 2009 Oct drh 5 4 Combining CREATE TABLE with its populating from some flat file
245 code fixed 2003 Feb anonymous Parser 2003 Feb   3 3 LIMIT and OFFSET clause
311 code fixed 2003 May anonymous   2003 May   3 3 configure fails with non gcc compilers due to non escaped \n in test
247 code fixed 2003 Feb anonymous VDBE 2003 Feb drh 1 1 OUTER JOIN problem
246 event fixed 2003 Feb anonymous Unknown 2003 Feb   2 3 View not the same as direct query
233 event closed 2003 Jan anonymous Unknown 2009 Oct   1 4 test bigfile-1.1 dumps core on Tru64 platform
151 new closed 2002 Sep anonymous   2008 Mar   5 5 Add 'configure' options for locating readline headers and library
182 event closed 2002 Oct anonymous Unknown 2002 Oct   1 1 Win32 DBI Interface crashes Perl.exe
301 code closed 2003 Apr anonymous Unknown 2009 Oct   2 3 Can't acquire lock for database on Mac OS X AppleShare volume
319 code closed 2003 May anonymous Unknown 2003 May   1 1 Large Encoded Strings Get Truncated
449 new closed 2003 Sep anonymous   2005 Jan   3 4 Date and time functions for SELECTs
556 warn closed 2004 Jan anonymous CodeGen 2004 Jan   3 4 double to int warnings in date.c
763 code closed 2004 Jun anonymous Unknown 2009 Oct   5 4 tclsqlite.dll not showing the correct version
1459 code closed 2005 Sep anonymous   2005 Sep   1 1 Division operation
1515 code closed 2005 Nov anonymous Unknown 2009 Oct   4 3 Quotes incorrect included in colum names.
853 doc closed 2004 Aug anonymous Parser 2009 Oct   4 3 syntax of DEFAULT in a CREATE TABLE statement not as documented
1044 code closed 2004 Dec anonymous   2004 Dec   3 3 Insert an integer as a string
249 code fixed 2003 Feb anonymous Unknown 2004 Aug drh 1 1 install
250 code fixed 2003 Feb anonymous Unknown 2003 Mar   2 1 SQLite_Changes increments with new non-callback
255 event closed 2003 Feb anonymous   2009 Oct   1 1 Database locked on HP64 (B11.11)
257 code fixed 2003 Feb anonymous VDBE 2003 Mar   4 3 sqliteVdbeList should return SQLITE_DONE not SQLITE_OK
258 code fixed 2003 Feb anonymous Parser 2003 Mar   3 3 sqlite_compile doesn't work with (some?) PRAGMAs
259 new closed 2003 Mar anonymous CodeGen 2009 Oct   1 2 ORDER BY queries including an integer primary key don't use index
261 code closed 2003 Mar anonymous Unknown 2003 Jul   2 3 Non Callback Finalize Bug
262 new fixed 2003 Mar anonymous Unknown 2003 Jun   4 4 Non Callback is Slow on scripts
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
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
269 new fixed 2003 Mar anonymous   2005 Jan   3 3 table.column view columns can not be referenced in where clause
270 code fixed 2003 Mar anonymous Unknown 2003 Apr   3 4 incorrect check for fcntl error code
271 event closed 2003 Mar anonymous Unknown 2008 Jun drh 3 2 'make test' fails on MacOS X
272 code fixed 2003 Mar anonymous   2003 May   3 3 select on view with where clause does not use index
274 code closed 2003 Mar anonymous Unknown 2003 Apr   2 3 bug in sqlite_free_table
275 code fixed 2003 Mar anonymous CodeGen 2003 Apr   3 5 "INSERT INTO x SELECT * FROM x" doesn't work when x is a TEMP table
276 new fixed 2003 Apr anonymous Shell 2003 Apr   3 3 Proposal/Bug-Fix for TTY determination
277 code fixed 2003 Apr anonymous Parser 2003 Apr   1 2 Multi-line comments cause syntax errors in ".read" files
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
280 code fixed 2003 Apr anonymous   2003 Apr   2 2 Revise your code to use <stdarg.h>
281 code fixed 2003 Apr anonymous   2003 Apr   1 1 expression 0 = '' is true
282 code fixed 2003 Apr anonymous Unknown 2003 May   2 3 Echo "\n" on Solaris causes two linebreaks. Makefile problem.
283 code closed 2003 Apr anonymous Parser 2003 Apr   3 1 Defect in sqlite_exec_vprintf
285 build closed 2003 Apr anonymous Unknown 2008 Mar   2 2 Configure doesn't honour LDFLAGS during build
286 doc closed 2003 Apr anonymous   2009 Oct   3 3 Tcl command documentation does not explain (minus) options.
287 new closed 2003 Apr anonymous CodeGen 2005 Jan drh 3 2 query execution time depend from tables order in FROM clause
288 code fixed 2003 Apr anonymous   2003 Apr   1 1 sqlite don't compile on SuSE 8.2 (gcc 3.3)
289 code fixed 2003 Apr anonymous BTree 2003 Apr   1 1 File src/btree_rb.c is missing
290 event fixed 2003 Apr drh VDBE 2003 Apr   1 1 interaction of last_insert_rowid() and AFTER triggers
291 code fixed 2003 Apr drh   2003 Apr drh 1 1 autoincrement does not work with triggers
292 code fixed 2003 Apr drh   2005 Jan   4 4 Multiple indices created for a UNIQUE PRIMARY KEY
293 code fixed 2003 Apr anonymous   2003 Apr paul 1 2 configure-script broken by checkin #903
294 new closed 2003 Apr anonymous Shell 2009 Oct a.rottmann 1 4 Diff for OpenBSD
296 code fixed 2003 Apr anonymous VDBE 2003 Apr   1 4 crash sqlite or execute via libtclsqlite
298 code fixed 2003 Apr drh CodeGen 2003 Apr   1 1 SELECT sometimes ignores constant WHERE clause
299 new fixed 2003 Apr anonymous Parser 2006 Aug   2 3 Cannot insert only default values.
302 code fixed 2003 Apr anonymous Shell 2003 Apr   3 3 .sqliterc can do memory fault
304 code closed 2003 May anonymous Shell 2003 May   3 3 DELETE on read-only db reporting error inconsistently
307 event closed 2003 May anonymous Shell 2008 Jun anonymous 1 1 fail to rpm install on redhat 9
309 code fixed 2003 May anonymous Unknown 2003 May   5 5 Source code files are corrupted
310 code fixed 2003 May anonymous Pager 2003 May   3 3 win32 locking error
312 build closed 2003 May anonymous Shell 2008 Jun   1 3 libreadline.so.0.0 causes unidentified token error
314 event closed 2003 May anonymous Unknown 2003 May   4 4 Memory usage
315 code fixed 2003 May anonymous Unknown 2003 May   3 3 Usage of potentially changed address
316 code fixed 2003 May anonymous Unknown 2003 Aug   2 3 Cygwin with gcc V2.95.3 compilation -- os.h
318 code fixed 2003 May anonymous Unknown 2003 Jul drh 1 1 dl-minimal.c: 128: realloc: Asseration failure...
330 code closed 2003 May anonymous VDBE 2009 Oct   3 4 Aggregator's error are ignored
374 code closed 2003 Jul anonymous Pager 2003 Jul   1 1 btree crash in moveto - sqlitepager_get
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)
2618 code closed 2007 Sep anonymous   2007 Sep linus 4 1 Dabase is Locked
303 build closed 2003 May anonymous Unknown 2008 Jun a.rottmann 4 4 Makefile issues
317 code fixed 2003 May jplyon CodeGen 2003 May   2 3 ATTACH fails for external database containing an index
565 code fixed 2004 Jan anonymous VDBE 2004 Jan   2 3 sqlite: src/vdbe.c:512: sqliteVdbeExec: Assertion `p->tos<=pc' failed.
566 new closed 2004 Jan anonymous Unknown 2009 Oct   4 4 [PATCH] Port of sqlite and lemon to an EBCDIC mainframe
567 code fixed 2004 Jan anonymous Unknown 2004 Jan   3 3 Erroneous test for rowid >= (fp number) in where clause
568 code fixed 2004 Jan anonymous Shell 2004 Feb   2 2 Shell does not handle -init option correctly
569 code fixed 2004 Jan dougcurrie Pager 2004 Jan dougcurrie 3 3 Newer Cygwin (>1.50) doesn't want __CYGWIN_USE_BIG_TYPES__
571 code closed 2004 Jan anonymous Unknown 2004 Jan   1 1 Execution of comment via sqlite_step raise Access violation
572 new closed 2004 Jan anonymous Unknown 2009 Oct drh 3 3 sqlite 2.8.11 port to djgpp
574 code fixed 2004 Jan drh   2004 Jan   1 1 ATTACH fails when invoked from sqlite_compile()
575 code closed 2004 Jan anonymous VDBE 2009 Oct drh 3 3 pragma (default_)temp_store implementations seems incomplete
576 code fixed 2004 Jan anonymous CodeGen 2004 Feb   1 2 last_insert_rowid() returns wrong values in triggers on views
577 doc fixed 2004 Jan anonymous   2004 Jan   5 3 Typo on main SQLite home page
578 code closed 2004 Jan anonymous   2004 Feb   4 2 calling isdigit in sqliteIsNumber cause asserts (VC.NET)
580 code closed 2004 Jan anonymous VDBE 2004 Jan   2 3 Incorrect Select when specifying same field value as column name
582 build fixed 2004 Jan anonymous   2004 Jan   4 3 no permission to execute install-sh
583 warn fixed 2004 Jan anonymous Unknown 2004 Feb   4 4 _FILE_OFFSET_BITS redefined on 64bit sparc-sun-solaris
585 code closed 2004 Jan anonymous   2004 Jan   1 1 sqlite is not thread safe
587 code fixed 2004 Jan anonymous Unknown 2004 Jan   3 1 easy way to operate on a max () value
588 new closed 2004 Jan anonymous   2009 Oct   5 4 Please provide support for NULLS LAST in ORDER BY clauses.
592 event closed 2004 Feb anonymous Unknown 2009 Oct   1 1 VIEW produces strange result set
593 code fixed 2004 Feb anonymous VDBE 2004 Feb   3 3 Interrupted VACUUM returns SQLITE_ERROR not SQLITE_INTERRUPT
594 code fixed 2004 Feb anonymous   2004 Feb   1 1 TEMP tables not dropped by ROLLBACK if sqlite_interrupt was called
613 doc closed 2004 Feb anonymous   2008 Jun   3 4 Doc is wrong with some prototypes and const is missing for errmsg
614 code fixed 2004 Feb anonymous Shell 2004 Feb   2 1 history not saved after quitting the shell with .quit
636 new closed 2004 Mar anonymous Unknown 2004 Mar   1 1 Retaining autoincrement (Primary key) generated values
650 new closed 2004 Mar anonymous Parser 2004 Mar   4 4 DISTINCT aggregates
727 event closed 2004 May anonymous   2009 Oct   4 3 "wrong" affected row value returned by REPLACE
599 code fixed 2004 Feb anonymous Pager 2004 Feb   1 2 Corrupt problem encountered on Windows NT platform
601 code fixed 2004 Feb anonymous CodeGen 2004 Feb   1 1 Left-join subquery gives incorrect results
603 code fixed 2004 Feb anonymous   2004 Feb   4 4 compile error date.c if SQLITE_OMIT_DATETIME_FUNCS defined
608 code closed 2004 Feb anonymous   2009 Oct   3 3 Problem with "pragma show_datatypes = on" and busy timeout
609 build closed 2004 Feb anonymous Unknown 2008 Jun   1 4 Makefile errors
610 code fixed 2004 Feb anonymous Parser 2004 Feb   5 4 REPLACE INTO syntax not allowed in triggers
611 new closed 2004 Feb anonymous VDBE 2009 Oct   1 3 Remove giant SWITCH statement in VM for better portability
612 code fixed 2004 Feb anonymous   2004 Feb anonymous 3 1 Pointer 'db' not initialized in function lookupname() (expr.c)
615 code fixed 2004 Feb drh Pager 2004 Feb   2 3 Assertion fault in pager when synchronous changed within a transaction
616 code closed 2004 Feb anonymous VDBE 2004 Feb   1 1 variable 'db' is not initialized before being used (expr.c line 418)
617 new fixed 2004 Feb anonymous Unknown 2004 Feb   5 4 date() conversion seems to fail on -ve dates
618 code closed 2004 Feb anonymous Unknown 2004 Feb   3 3 fails test btree-1.1.1
622 doc closed 2004 Feb anonymous   2009 Oct mihailim 1 3 Should mention PRAGMA table_info() in FAQ
623 code fixed 2004 Feb anonymous Unknown 2004 Feb   2 3 Erroneous min/max on US zip codes
625 code closed 2004 Feb anonymous   2004 Feb   1 1 CORE DUMPED when running sum() in DBD::SQLite
626 code fixed 2004 Feb anonymous Parser 2004 Feb   2 2 EXPLAIN BEGIN TRANSACTION really starts a transaction
627 code closed 2004 Feb anonymous   2009 Oct   3 3 sqliteRunVacuum returning wrong code?
629 code closed 2004 Feb anonymous Parser 2004 Feb   3 3 Variable used without having been initialized
630 code closed 2004 Feb anonymous   2004 Feb   1 1 using uninitialized variable
631 code closed 2004 Feb anonymous Shell 2004 Feb   2 3 command line SQL paramater doesn't work on windows pre-compiled binary
633 build closed 2004 Feb anonymous   2008 Jun   1 1 new build system does not run correctly under MinGW/MSYS
634 warn fixed 2004 Feb anonymous Unknown 2004 Feb   3 3 Compiler warnings when compiling using LCC
635 new closed 2004 Feb anonymous   2004 Mar   5 5 ROWID as ref. number
637 code closed 2004 Mar anonymous Parser 2009 Oct   5 4 union uses non-standard column names
640 code fixed 2004 Mar drh CodeGen 2004 Mar   1 1 Trigger causes assertion failure
641 code fixed 2004 Mar anonymous Unknown 2004 Mar   1 1 select query doen't work with binary equations
642 code closed 2004 Mar anonymous Shell 2004 Mar   1 1 Problem when adding a SQL string on the command line - THIS IS REAL!!
644 todo closed 2004 Mar anonymous Unknown 2008 Jun   1 3 How do you fix "SQL error: database disk image is malformed"
645 new closed 2004 Mar anonymous   2009 Oct   5 5 OpenWatcom makefile
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
648 code fixed 2004 Mar rdc Unknown 2004 Mar   3 3 duplicate tracing with revised sqlite_exec implementation
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
684 code closed 2004 Apr anonymous Unknown 2009 Oct   3 2 Incorrect function result type when using SQLITE_ARGS
716 code fixed 2004 Apr anonymous Unknown 2005 Jan   4 4 create table as should preserve column types
722 code closed 2004 May anonymous VDBE 2004 Jul drh 2 1 long long format specifier in sqlite_exec_printf missing
850 code closed 2004 Aug anonymous   2004 Aug   1 1 quoted table names not allowed in combination with *
1132 code closed 2005 Feb anonymous Shell 2005 Feb   1 1 database migration from sqlite 2.8.12 to sqlite 3.0.8
654 code fixed 2004 Mar anonymous Unknown 2004 Mar   3 2 Can't compile with CodeWarrior Studio v9.1
655 code fixed 2004 Mar anonymous VDBE 2004 Jul   1 3 Numeric/string confusion with "in"
656 code closed 2004 Mar anonymous Unknown 2009 Oct   5 5 The 'sum' and 'avg' functions don't work on Solaris (UNIX)
658 code fixed 2004 Mar anonymous   2004 Mar   3 3 select max(rowid) from union crashes sqlite command-line
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?
665 code fixed 2004 Mar anonymous   2004 Apr   3 3 Lemon.c + OpenWatcom 1.3
666 code closed 2004 Mar anonymous Unknown 2009 Oct anonymous 5 4 Error message indicates wrong error
669 new closed 2004 Mar anonymous   2004 Mar   5 5 named-field?
671 build closed 2004 Mar anonymous TclLib 2004 Mar   4 4 Missing tcl.h from /src
672 warn closed 2004 Mar anonymous Unknown 2004 Mar   1 1 THE DLL FILE FOR WINDOWS IS CURRUPTED
673 new closed 2004 Mar anonymous Shell 2009 Oct   4 3 Format .dump nicer (patch)
674 code closed 2004 Mar anonymous   2004 Mar   3 4 insert record fails mpatrol tests
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
677 code closed 2004 Mar anonymous   2004 Mar   2 3 Failure to convert to FP on division involving a constant
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
680 code fixed 2004 Mar anonymous Parser 2004 Jul   3 3 Parser fails on quoted table/alias DOT STAR
683 code fixed 2004 Apr anonymous Unknown 2004 Jul   1 1 Impossible to drop index with single quotes in the name
685 code closed 2004 Apr anonymous CodeGen 2009 Oct   1 3 SELECT from a VIEW with GROUP BY
686 code fixed 2004 Apr anonymous   2004 Jul   2 3 select + indexes + left join + "in (set)" causes core dump
687 code fixed 2004 Apr anonymous   2004 Jul   4 2 Sqlite incorrectly handles invalid filenames.
688 code closed 2004 Apr anonymous   2004 Apr   1 1 Scope problem in subselect
690 code fixed 2004 Apr anonymous   2005 Jan   3 3 NATURAL JOIN does not work with table aliases
691 code closed 2004 Apr anonymous Unknown 2009 Oct drh 1 1 OS X File Sharing
695 code closed 2004 Apr anonymous   2005 Jan   3 3 CREATE INDEX and dbl-quoted index names
696 code closed 2004 Apr anonymous TclLib 2005 Jan   1 1 tclsqlite does not build on RH 7.3
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
703 code fixed 2004 Apr anonymous   2004 Jul   3 3 Aggregate functions (min/max) fail over sub-queries
705 code fixed 2004 Apr anonymous Parser 2004 Jul   3 3 can't handle special char in column name
707 new closed 2004 Apr anonymous Unknown 2008 Jun drh 3 3 how to use internal functions?
708 code fixed 2004 Apr anonymous Unknown 2004 Jul rdc 4 1 nonASCII Upper & Lower
709 code closed 2004 Apr anonymous Unknown 2009 Oct drh 1 1 Unable to unregister or replace functions
710 new closed 2004 Apr anonymous Unknown 2008 Jun drh 3 4 Provide the ability to pass a user-data value during sqlite_compile
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
713 code fixed 2004 Apr anonymous Unknown 2004 Jul drh 3 3 Compiling with SQLITE_OMIT_DATETIME_FUNCS causes error
717 new closed 2004 May anonymous Unknown 2009 Oct drh 2 2 minor fixes and port to dos
719 code closed 2004 May anonymous   2004 May   2 3 index_list not reporting my indeces
720 event closed 2004 May anonymous   2009 Oct   1 1 Write problem on MS Windows 98
721 code closed 2004 May anonymous Shell 2008 Jun drh 3 2 empty .databases information
724 new closed 2004 May anonymous   2009 Oct   4 5 VACUUM resets settings for the current session
728 code closed 2004 May anonymous Unknown 2004 Nov anonymous 4 3 .schema table fails if followed by a semicolon
731 code closed 2004 May anonymous   2004 May   2 3 UNIQUE constraint not working when one of the fields is null
732 doc closed 2004 May anonymous   2009 Oct   5 5 Odd columns lead to odder selections
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:
736 new closed 2004 May anonymous   2009 Oct   4 4 Would like to be able to list the LAST 10 lines of a query
739 new closed 2004 May anonymous Unknown 2009 Oct danielk1977 3 1 Suggestion speed query
743 code fixed 2004 May anonymous Parser 2005 Jun   2 2 WHERE clause with USING incorrectly requires table name
744 code closed 2004 May anonymous BTree 2009 Oct anonymous 2 2 make test seg faults on x86_64 Linux
745 code closed 2004 May anonymous VDBE 2005 Jan   5 3 no error message when two statements cause a conflict
746 warn closed 2004 May anonymous CodeGen 2009 Oct anonymous 5 5 How can I make sqlite support serial term?
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
749 code fixed 2004 May anonymous CodeGen 2004 Jul   2 1 SELECT DISTINCT with LIMIT
750 code closed 2004 May anonymous Unknown 2004 Jul   2 3 copy command does not work with existing table
753 code closed 2004 Jun anonymous Unknown 2004 Nov drh 4 4 view always report numeric as data type
754 code closed 2004 Jun anonymous Shell 2009 Oct drh 2 3 problem opening a dbfile in the upper directory (../dbname)
755 new closed 2004 Jun anonymous TclLib 2009 Oct drh 5 2 Adding aggregate function to the tcl binding
756 code fixed 2004 Jun anonymous   2004 Jul   2 3 Core Dump - Select From View
757 code fixed 2004 Jun anonymous VDBE 2004 Jun   3 3 Indexes on temporary tables leave cursors open
758 code fixed 2004 Jun anonymous Shell 2004 Jul   1 1 Incorrect return value form strftime %W
760 code fixed 2004 Jun anonymous Parser 2005 Jan   2 3 Selects leave tablename in tablename.columname
762 todo closed 2004 Jun anonymous Unknown 2009 Oct anonymous 4 3 Windows pre-compiled binaries are 2.8.13, not 2.8.14
767 new closed 2004 Jun anonymous   2004 Jun   1 1 Metadata of query
787 code closed 2004 Jun anonymous Unknown 2005 Jan   4 4 Bad free() ignored (PERL_CORE)
804 code fixed 2004 Jul anonymous   2004 Jul   1 1 sqliteStrNICmp() and sqliteStrICmp() return wrong value.
805 code fixed 2004 Jul anonymous   2004 Jul   3 2 coalesce in the where clause doesn't work
821 code closed 2004 Jul anonymous BTree 2004 Jul   3 3 Allows string data on indexes INTEGER fields
894 code closed 2004 Sep anonymous Shell 2004 Sep   3 3 COUNT does not work with DISTINCT SUBSTR
980 code fixed 2004 Nov anonymous VDBE 2004 Dec   2 4 Two triggers confusing each other
981 code closed 2004 Nov anonymous   2005 Jan   1 1 UTF8 characters in database directory or filename not supported
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
1344 code closed 2005 Jul anonymous BTree 2005 Aug anonymous 3 1 sqlite does 40 times allocations for a single sql statement
2043 code closed 2006 Oct anonymous   2009 Oct   1 1 Spaces in view statement
681 build closed 2004 Apr anonymous CodeGen 2004 Apr   1 1 undefined reference to 'sqlite_open'
761 todo closed 2004 Jun anonymous Unknown 2004 Jun   5 5 the current sqlite_source.zip is 2.8.13, not 2.8.14
764 code closed 2004 Jun drh   2004 Jun drh 1 1 ROLLBACK disables TEMP triggers.
766 code review 2004 Jun anonymous Pager 2005 Aug   3 5 cygwin, absolute path problem
773 code closed 2004 Jun anonymous Unknown 2004 Jun   3 4 user-defined sql function called unexpected number of times
777 code fixed 2004 Jun anonymous   2004 Jun   1 1 MIN() does not return NULL if there is a NULL in the list
782 new fixed 2004 Jun anonymous Unknown 2005 Feb   3 2 Correlated subqueries are not supported
800 todo fixed 2004 Jul anonymous VDBE 2004 Jul   3 3 Handling of NULLs by set function MIN has been changed to non-standard
806 code fixed 2004 Jul anonymous VDBE 2004 Jul   3 3 The maximum number of tables allowed in a join is 32.
809 code closed 2004 Jul anonymous   2004 Jul   2 1 Sqlite also fetches the hooks
812 code fixed 2004 Jul anonymous Unknown 2004 Jul   3 3 sqlite_mprintf ("%s", "") - "%s" alone with empty string arg fails
813 code fixed 2004 Jul anonymous   2004 Jul   2 4 LEFT OUTER JOIN give wrong result when an index is present
814 todo closed 2004 Jul anonymous Unknown 2005 Jan anonymous 1 1 How can I get the recent bug-fixed branch version 2?
822 code closed 2004 Jul anonymous Unknown 2009 Oct drh 1 4 port of sqlite to dos with djgpp + small general bugfixes
920 code closed 2004 Sep anonymous Unknown 2004 Sep anonymous 3 3 group by without having not supported
1065 new closed 2005 Jan anonymous Unknown 2005 Jan   3 3 Uppercase and foreign chars problems in searches
1295 event closed 2005 Jun anonymous Unknown 2009 Oct   1 1 SQL query involving subqueries causes reproduceable segfault in 2.8.14
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
1480 event closed 2005 Oct anonymous Unknown 2009 Oct   1 3 Wrong SQL statement crashes PHP+Apache
1500 code closed 2005 Oct anonymous Unknown 2009 Oct   4 4 MIssing file listing permission causes DB opening/creation to fail
523 code fixed 2003 Dec anonymous Unknown 2005 Jan   2 2 Select table 'AS' does not work in JOIN USING clause
831 code fixed 2004 Jul anonymous   2004 Jul   4 3 sqlite_mprintf("%q", "") returns random data
833 todo closed 2004 Jul anonymous Unknown 2009 Oct   1 3 port of sqlite 2.8.15 to djgpp
854 code closed 2004 Aug anonymous Unknown 2004 Aug anonymous 3 1 Index don't work with NULL field
859 doc fixed 2004 Aug anonymous   2004 Aug   5 4 typo in comment
862 code fixed 2004 Aug anonymous VDBE 2004 Aug   2 2 Memory is being freed twice when performing VACUUM on corrupted DB
874 code closed 2004 Aug anonymous Parser 2004 Aug   2 3 Inconsistent treatment of quoted strings: "x" vs 'x'
887 code closed 2004 Sep anonymous Pager 2004 Sep   3 2 Unable to recover from SQLITE_FULL error until DB file is reopened
896 code fixed 2004 Sep anonymous Parser 2004 Sep anonymous 1 3 Access violation when attempt to execute invalid query
905 code fixed 2004 Sep anonymous VDBE 2004 Oct   2 4 assertion failed in vdbe.c (it fails to not crash upon user error?)
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
955 warn closed 2004 Oct anonymous Unknown 2009 Oct   1 1 When installing SQLite it says that a file is missing.
970 code closed 2004 Oct anonymous Parser 2005 Jan   2 3 Crush in authorization procedure
971 todo closed 2004 Oct anonymous Unknown 2009 Oct peter 2 1 how to recompile sqlite with THREADSAFE preprocessor macro set to 1?
978 code closed 2004 Oct anonymous BTree 2004 Oct anonymous 3 3 bug in sql_step related to INTEGER PRIMARY INDEX values.
979 code fixed 2004 Nov anonymous Unknown 2004 Nov   1 3 large heap memory usage when creating VIEW TABLES from schema.sql file
997 code closed 2004 Nov anonymous   2004 Nov   2 4 Returned column names include table name or alias.
1007 code defer 2004 Nov anonymous   2004 Nov   3 2 SQLite ignores SQLITE_CORRUPT error and continues executing SQL query
1008 code fixed 2004 Nov anonymous Unknown 2004 Nov anonymous 4 1 default_temp_store=0 after VACUUM
1025 code fixed 2004 Dec anonymous   2005 Jan   3 3 Error starting transaction, SQLite still consider it started.
1054 code fixed 2004 Dec anonymous Parser 2005 Jan   1 1 Query with unknown column crashes when authorizer is set
1074 code closed 2005 Jan anonymous Unknown 2005 Jan drh 3 3 CREATE INDEX and dbl-quoted index names
1119 code closed 2005 Feb anonymous Parser 2005 Feb   4 3 Field name interpreted as SQL command. (GROUP)
1149 code closed 2005 Feb anonymous   2009 Oct   2 1 VACUUM, DUMP/RESTORE fail in certain cases
1158 code closed 2005 Mar anonymous VDBE 2009 Oct   1 1 core dump on solaris,
1202 code fixed 2005 Apr anonymous   2005 Aug   2 2 Library does not support "0x" prefix in cmd context string
1329 code closed 2005 Jul anonymous BTree 2005 Jul   5 1 A bug About select from a table
1382 code closed 2005 Aug anonymous   2009 Oct drh 1 1 Assert nErr==0 on corrupt db
1439 code closed 2005 Sep anonymous Unknown 2005 Sep   3 3 Format String inserting a text
1757 code closed 2006 Apr anonymous   2006 Apr   2 1 sqlite not using index
879 new closed 2004 Aug anonymous   2004 Aug   5 3 Makefile should produce GCC compatible import library for DLL as well
1117 build fixed 2005 Feb anonymous Unknown 2005 Feb anonymous 1 1 sqlite-2.8.16.tar.gz contains VERSION '3.1.2'
1118 build closed 2005 Feb anonymous   2005 Feb   1 1 pa
1120 code fixed 2005 Feb anonymous Parser 2005 Feb   2 2 lemon: off-by-two error
1124 event fixed 2005 Feb anonymous Shell 2005 Feb   4 4 sqlite.exe .dump & reload broken w/dependent VIEW lower in sort
1126 new closed 2005 Feb anonymous Unknown 2009 Oct drh 2 3 sqlite 2.8.16 port to djgpp
1127 code fixed 2005 Feb anonymous Unknown 2005 Mar   3 3 typeof() always returns "text" in unions
1245 code closed 2005 May anonymous   2005 Jun   3 1 Query causes 'unable to open database' after ~1000 operations
1274 code fixed 2005 Jun anonymous   2005 Jun   2 2 sqliteOsFullPathname() segfaults due to NULL from getcwd()
1322 code closed 2005 Jul anonymous   2005 Aug   4 4 after "select * from sqlite_master;" ".databases" command doesnt work
1330 code closed 2005 Jul anonymous Shell 2005 Aug   2 5 The internal function max doesn't work properly
1411 code closed 2005 Sep anonymous Shell 2005 Sep anonymous 3 1 how to change database name
1426 event closed 2005 Sep anonymous Unknown 2009 Oct drh 2 2 Problem with DETACH in 2.8.16
1508 code closed 2005 Nov anonymous BTree 2009 Oct   1 3 sqlite 2.8.16 crashes on 64-bit / strict memory alignment archs
1541 code closed 2005 Nov anonymous Unknown 2009 Oct   1 1 Ticket #924 not fixed in the 2.8 branch
1546 code closed 2005 Nov anonymous   2009 Oct   1 1 Creating unique index on non-unique column leads to corr. on SQLite2
1574 event closed 2005 Dec anonymous Shell 2005 Dec   1 3 corrupt database due to .dump process
1613 new closed 2006 Jan anonymous   2006 Jan   4 4 "between" doesn't take advantage of indexes
1661 code fixed 2006 Feb anonymous Unknown 2006 Feb   3 4 The following never returns in v2.8.16 : select 1 limit 1 offset 1;
2066 code closed 2006 Nov anonymous   2009 Oct   2 2 Incorrect error message in the case of ENOLCK
1569 code fixed 2005 Dec anonymous   2005 Dec drh 1 1 tarball of sqlite 2.8.17 is empty
1719 code closed 2006 Mar anonymous   2009 Oct   4 4 Solaris 8(SQL: bus error while creating temporary file
1972 code closed 2006 Sep anonymous   2009 Oct   2 4 segfault on empty query
2067 code fixed 2006 Nov anonymous   2007 Dec   4 4 Bad syntax caused core dump
2378 code closed 2007 May anonymous   2009 Oct   2 2 Quoted fields come back corrupted, using GROUP BY
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
3827 doc closed 2009 Apr anonymous cli 2009 Apr   4 5 Type in online help
295 code fixed 2003 Apr drh CodeGen 2003 Apr   1 1 ATTACH does not work on a database containing triggers
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
322 code fixed 2003 May anonymous   2003 Aug   3 3 Configure problem with ming32 on win32 (XP) and all sqlite version
323 code fixed 2003 May anonymous CodeGen 2003 Jun   1 1 Assertion failed by attaching a file
326 new closed 2003 May anonymous   2009 Oct   4 4 Request for additional callback for various functions
328 code closed 2003 May anonymous Unknown 2003 May   2 1 Trigger accessing temp table now does not work
329 code closed 2003 May anonymous Unknown 2003 May   3 3 sqlite_get_table() returns 1 row when there should be none
332 code tested 2003 May anonymous Unknown 2003 Jun   5 1 Dropping a temp trigger causes an access violation
333 code fixed 2003 Jun anonymous Unknown 2003 Jun   1 1 Temp Triggers cause update/delete statement failure with explicit transaction
334 code fixed 2003 Jun drh CodeGen 2003 Jun   1 1 REPLACE statement corrupts indices
335 event closed 2003 Jun anonymous Unknown 2009 Oct drh 2 2 ChangeCount still failing
340 code fixed 2003 Jun anonymous   2003 Jun   1 2 ATTACH database needs an authorization hook
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
562 code closed 2004 Jan anonymous Unknown 2004 Jan   2 3 System needs to rename duplicate named columns.
336 code fixed 2003 Jun anonymous   2003 Jun   4 2 Compiler warnings on SQLite 2.8.3
339 build closed 2003 Jun anonymous Shell 2008 Jun   2 3 readline headers not found (because of readline/ prefix)
341 code fixed 2003 Jun anonymous VDBE 2003 Jun   4 3 vdbe.c calls access() instead of sqliteOsFileExists()
342 code fixed 2003 Jun anonymous   2003 Jun   5 3 vxprintf() makes invalid assumptions about size of pointer and long
343 new closed 2003 Jun anonymous Parser 2003 Jun   3 1 insert single quote value in SQL statement
346 code fixed 2003 Jun anonymous BTree 2003 Jul   3 3 Problem with LIMIT 0
347 code fixed 2003 Jun anonymous BTree 2003 Jun   4 3 Workaround for warning that print_node() in btree_rb.c is unused
348 warn closed 2003 Jun anonymous Unknown 2009 Oct drh 4 3 SQLite and GCC using enhanced warning levels
350 code fixed 2003 Jun anonymous Unknown 2003 Jun   2 3 LEFT JOIN works improperly on static inner queries and views
351 code fixed 2003 Jun anonymous Pager 2003 Jun   2 3 Journal pager playback doesn't secure exclusive access
353 code fixed 2003 Jun anonymous   2003 Jun   4 3 Compile errors when SQLITE_OMIT_AUTHORIZATION is defined
355 code fixed 2003 Jun anonymous BTree 2003 Jun   4 3 Compile warning when NDEBUG is defined
356 new closed 2003 Jun anonymous VDBE 2008 Jun   5 2 Returns real error codes
357 code fixed 2003 Jun anonymous Pager 2003 Aug drh 4 3 Compilation errors and warnings when compiled on Open VMS
360 code fixed 2003 Jun anonymous Unknown 2003 Jun   2 3 "not N between n and m" in trigger dumps core
361 code fixed 2003 Jun anonymous Unknown 2003 Jun anonymous 3 3 main.c doesn't compile when SQLITE_OMIT_TRACE=1
363 new closed 2003 Jun anonymous VDBE 2009 Oct jadams 5 5 sqlite support domain as user defined type
364 code fixed 2003 Jun anonymous   2003 Jun   3 3 Assert when doing SELECT ROWID,* against a VIEW
365 code fixed 2003 Jun anonymous VDBE 2003 Jun   3 4 Can not define SQLITE_OMIT_AUTHORIZATION
366 new closed 2003 Jun anonymous Unknown 2008 Jun drh 4 3 Functions sqlite_(en/de)code_binary() not in sqlite.h
367 code fixed 2003 Jun anonymous Unknown 2003 Jun   4 1 soundex bug
368 code closed 2003 Jun anonymous   2009 Oct   3 4 UPDATE trigger doesn't fire on INSERT OR REPLACE
380 code closed 2003 Jul anonymous Unknown 2003 Jul   2 2 "uniqueness constraint failed" on insertion of distinct rows
396 code fixed 2003 Jul anonymous Unknown 2003 Jul   3 2 AGGREGATE FUNCTION WITH LIMIT
400 code fixed 2003 Jul anonymous   2003 Jul   3 4 shell.c, when readline() not avail, getline() conflicts with stdio's
447 event fixed 2003 Sep anonymous   2003 Sep   3 1 Problems compiling on FreeBSD 4.8-STABLE
491 new closed 2003 Nov anonymous   2009 Oct   4 4 Want to use SET col = 'val' with INSERT statement
548 code fixed 2004 Jan anonymous Parser 2004 Jan   3 3 SQLite will abort() when utf-8 character is invalid
600 code closed 2004 Feb anonymous   2004 Feb   1 1 unable to open database file, win32, Java jdbc
605 warn fixed 2004 Feb anonymous   2004 Feb   1 1 _FILE_OFFSET_BITS redefined
668 code fixed 2004 Mar anonymous VDBE 2004 Mar   2 2 sqlite crash on combinng case and not in
670 code fixed 2004 Mar anonymous   2004 Mar   3 3 The '.database' trunc file name
345 event fixed 2003 Jun anonymous BTree 2003 Jun   4 4 repeated returns
715 code closed 2004 Apr anonymous Unknown 2004 Apr   2 3 reference counted file locking attempts to unlock on different thread
362 event closed 2003 Jun anonymous Shell 2009 Oct jadams 4 2 Problem with select count
354 code fixed 2003 Jun anonymous Unknown 2003 Jul   3 2 ATTACH DATABASE call asserts in build.c in Debug Mode in MSVC7.1
370 code fixed 2003 Jun anonymous   2004 Feb dougcurrie 2 3 make fulltest status on Cygwin, failure on 2 tests
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
373 code fixed 2003 Jul anonymous   2003 Aug   1 2 2.8.4 Cygwin compile failure
377 code fixed 2003 Jul anonymous   2003 Jul   1 3 Comparisons of integer primary key to float are erroneous
378 doc fixed 2003 Jul anonymous Shell 2003 Jul   5 4 sqlite command line utility still needs file name
379 new closed 2003 Jul anonymous   2003 Jul   5 1 use \' and \" instead of '' and "" only
381 new closed 2003 Jul anonymous   2009 Oct   1 3 Support for DJGPP and DOS
383 code fixed 2003 Jul anonymous Unknown 2003 Jul   1 3 sqlite_changes returns wrong value with non-callback API
384 new fixed 2003 Jul anonymous   2003 Jul   4 4 NULL argument for pzTail to sqlite_compile causes access violation
385 new fixed 2003 Jul anonymous   2003 Jul   4 4 NULL args for output variables to sqlite_step cause access violation
389 event closed 2003 Jul anonymous Shell 2003 Jul   1 1 Undefined symbol
390 code closed 2003 Jul anonymous Shell 2003 Jul   3 4 database creation
391 warn closed 2003 Jul anonymous   2009 Oct   4 3 signed/unsiged compiler warnings from Borland C++6
392 event closed 2003 Jul anonymous Shell 2003 Jul anonymous 1 1 Unable to link libsqlite.so file on SunOS 5.8
393 code fixed 2003 Jul anonymous Unknown 2003 Jul   3 4 UNION and LIMIT incorrectly
395 code closed 2003 Jul anonymous Unknown 2009 Oct   4 4 Error opening db on Mac OS X not reported correctly
398 build closed 2003 Jul anonymous Unknown 2009 Oct   3 3 configure.ac is wrong for Windows Mingw/Msys
401 code fixed 2003 Jul anonymous   2003 Jul   2 3 Source downloads considered useless..
402 code closed 2003 Jul anonymous Shell 2005 Jan anonymous 2 3 linebreake
403 code fixed 2003 Jul anonymous   2008 Jun   4 4 Two small fixes in .spec file for RPMS
405 todo fixed 2003 Jul anonymous   2003 Jul   1 1 Missing complete unix source tarballs
451 build closed 2003 Sep anonymous   2009 Oct   1 1 Makefile fails on FreeBSD
455 doc closed 2003 Sep anonymous   2003 Sep   4 2 undocumented functions: sqlite_mprintf,and sqlite_vmprintf
369 code closed 2003 Jun anonymous   2009 Oct   3 2 Testsuite fails on btree-1.1.1 (Mac OS X, SQLite 2.8.4)
382 code closed 2003 Jul   Unknown 2003 Jul   2 2 Triggers stop firing under certain situations
394 code fixed 2003 Jul anonymous Parser 2003 Jul   4 1 SELECT 1; syntax throw run-time compiler warning
397 code fixed 2003 Jul anonymous Unknown 2003 Jul   4 3 tests attach-5.1 and attach2-1.1 fail on w2k mingw
406 code fixed 2003 Jul anonymous   2003 Jul   1 1 BEGIN ON CONFLICT ROLLBACK
407 new closed 2003 Jul anonymous   2008 Jun   4 4 sqlite_compile etc. and pragma empty_result_callbacks.
408 code fixed 2003 Jul anonymous VDBE 2003 Jul   1 1 toInt() reports success on overflow, causes comparisons to fail
409 event closed 2003 Jul anonymous Unknown 2008 Jun anonymous 3 1 sqlite_open will cause segfault when using Rational PurifyPlus/Linux
410 code fixed 2003 Jul anonymous Pager 2003 Jul   3 4 Creation and deltions of files should fsync() directory
414 code closed 2003 Jul anonymous VDBE 2009 Oct   3 4 sqlite_compile() and database schema changes
415 code closed 2003 Jul anonymous VDBE 2003 Dec   3 3 Stringify can loose digits in doubles
416 code fixed 2003 Jul anonymous   2003 Jul   1 1 An SQL DML which yields a segfault
417 code closed 2003 Jul anonymous Unknown 2003 Aug   4 4 Resultset differs between ..LIMIT 20 OFFSET 100 and ..LIMIT 20, 100
419 new fixed 2003 Jul anonymous   2003 Aug   4 3 Return index name with 'uniqueness constraint failed' error message
420 new closed 2003 Jul anonymous VDBE 2009 Oct   3 3 Not abort transaction when callback is cancelled
422 code closed 2003 Aug anonymous Unknown 2003 Dec   4 1 Memory leak in src/build.c
424 new closed 2003 Aug anonymous Shell 2009 Oct   4 3 Provide access to internal function _all_whitespace()
427 code fixed 2003 Aug anonymous Unknown 2003 Aug   2 2 access violation on vacuum with pragma empty_result_callbacks
428 new closed 2003 Aug anonymous TclLib 2009 Oct drh 5 5 missing prepare/fetch functions to be compatible with other DBs
429 code fixed 2003 Aug anonymous   2003 Aug   1 2 os.h cygwin compilation patch
430 code fixed 2003 Aug drh   2003 Aug   1 1 Dropping a trigger with the same name as a table corrupts the database
431 new closed 2003 Aug anonymous Shell 2003 Aug   5 4 possibility to use sql scripts in a file on the command line
513 code closed 2003 Dec anonymous   2003 Dec   2 3 C++-style comments prevent compilation
482 code fixed 2003 Oct anonymous BTree 2003 Dec   1 1 SIGSEGV inside memRbtreeNext
207 event closed 2002 Dec anonymous Shell 2008 Jun   2 1 After installation cannot create any databases
243 new closed 2003 Feb anonymous Unknown 2008 Jun anonymous 3 4 Performance problem with MSVC precompiled DLL
433 new fixed 2003 Aug anonymous Unknown 2003 Dec dougcurrie 3 2 configure needs updating for mingw/msys
434 code fixed 2003 Aug anonymous   2003 Aug   3 3 vacuum-3.1 test fails on Win2k needs db2 close
435 code fixed 2003 Aug anonymous Unknown 2003 Aug   3 3 backslash in Makefile hides clean target
437 code closed 2003 Aug anonymous Unknown 2003 Aug   3 3 Wrong order for results of SELECT
438 code closed 2003 Aug anonymous Unknown 2005 Jan   1 4 Minute function off between 11:16 and 11:20
439 code fixed 2003 Aug anonymous Unknown 2005 Jan   2 3 Query fails when run as a View
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
445 build closed 2003 Sep anonymous Unknown 2008 Jun anonymous 3 1 Compilation problem on MinGW
448 new closed 2003 Sep anonymous   2009 Oct drh 3 3 a general bug-fix and dos support without lfn
456 build closed 2003 Sep anonymous   2008 Jun anonymous 1 1 compilation problem under winnt 4 using Lcc-win32
458 new fixed 2003 Sep xdong Unknown 2003 Sep xdong 5 5 configure file and libtool doesnot work for cross compiling
459 new fixed 2003 Sep xdong Unknown 2003 Sep xdong 5 5 adding releasemode option to allow libtool link release
460 new fixed 2003 Sep anonymous VDBE 2003 Nov   5 5 [Patch] extending copy command for dump file of PostgerSQL pg_dump.
461 code fixed 2003 Sep anonymous CodeGen 2003 Sep   3 3 Nulls are incorrectly returned on an indexed column
464 code closed 2003 Sep anonymous   2003 Dec   2 2 VACUUM doesn't compile with sqlite_compile
467 code closed 2003 Sep anonymous Unknown 2003 Oct   2 1 Problem with renaming fields
468 code fixed 2003 Oct anonymous   2003 Oct   2 2 DROP TRIGGER w/ single quotes doesn't work.
469 code fixed 2003 Oct anonymous Unknown 2005 Jan   4 3 Qualified column name in subselect not recognized in outer select
470 code closed 2003 Oct anonymous Unknown 2005 Jan   2 3 Unnecessary 31-character name limit on Mac
471 code closed 2003 Oct anonymous Parser 2003 Oct   5 1 Parser accepts faulty SQL
472 new closed 2003 Oct anonymous VDBE 2008 Jun   5 5 [Patch] Using localtime instead UTC time to 'now'
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
484 build closed 2003 Oct anonymous   2009 Oct   5 4 make clean cleans doc/ completely
490 new closed 2003 Nov anonymous VDBE 2009 Oct xdong 4 3 a few api improvements for recordset operations
492 code closed 2003 Nov anonymous Unknown 2003 Nov   2 4 database image is malformed
493 event closed 2003 Nov anonymous Unknown 2008 Jun   3 3 Problem compiling sqlite
494 new closed 2003 Nov anonymous   2003 Nov   4 4 No way to get a list of table columns without parsing the schema
495 build closed 2003 Nov anonymous   2008 Jun   1 1 Makefile syntax errors
499 code closed 2003 Nov anonymous Unknown 2004 Feb   1 3 dot in table name and in column name makes full_column_names unusable
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
506 code closed 2003 Nov anonymous   2003 Nov   2 1 Result tuple not formed correctly on select query
507 code closed 2003 Nov anonymous Unknown 2003 Nov   2 4 string comparison in where-clause of select
509 event closed 2003 Nov anonymous   2009 Oct   5 3 SQLite on Pocket PC - question - how to do that step by step?
511 code closed 2003 Nov anonymous VDBE 2003 Nov   1 1 confused error of nested calling of "sqlite_compile"
512 code closed 2003 Dec anonymous Parser 2003 Dec   2 2 order by clause is not ordering data properly in aggregate functions
518 code closed 2003 Dec anonymous Unknown 2009 Oct   3 4 PRIMARY KEY does not imply UNIQUE and NOT NULL
521 code fixed 2003 Dec anonymous Unknown 2004 Jul   2 1 "create as select ..." does not preserve datatypes
524 new closed 2003 Dec anonymous Unknown 2009 Oct   2 1 port of sqlite to dos with short file names
526 code fixed 2003 Dec anonymous   2003 Dec   1 1 Primary key not unique (database corruption?)
528 code closed 2003 Dec anonymous Unknown 2003 Dec   4 2 compiled c code shows queries in executable
532 code closed 2003 Dec anonymous Parser 2003 Dec   2 3 crashes on gigantic query
539 new closed 2003 Dec anonymous VDBE 2009 Oct   5 4 Addition of engine 'Suspension' interface
596 code closed 2004 Feb anonymous   2004 Feb   1 1 sqlite_exec OR sqlite_get_table can not handle empty results sets
1196 build closed 2005 Apr anonymous   2005 Apr   1 1 out-of memory on powerpc on linux
446 doc closed 2003 Sep anonymous   2009 Oct drh 3 3 sqlite_compile can return no virtual machine with code SQLITE_OK
480 code fixed 2003 Oct anonymous CodeGen 2005 Sep   3 5 Joins with more than 32 tables are broken
442 new closed 2003 Sep anonymous   2008 Mar   5 2 [PATCH] sqlite: allow configure --enable-threadsafe
514 code fixed 2003 Dec anonymous Unknown 2004 Mar   2 3 attaching a locked database causes strange errors and a crash
515 code fixed 2003 Dec anonymous Unknown 2003 Dec   4 3 VACUUM fails after dependent table DROP,CREATE sequence
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
519 code fixed 2003 Dec drh VDBE 2003 Dec   1 1 3-way join causes segfault
520 code fixed 2003 Dec anonymous Parser 2003 Dec drh 2 2 tokenize bug in simultaneous threaded sqlite_open (with patch)
522 code closed 2003 Dec anonymous Unknown 2003 Dec   1 1 Error in comparision equal and less-equal
527 code closed 2003 Dec anonymous Shell 2004 Feb   3 3 Sqlite shell: lack of checks
529 code fixed 2003 Dec drh   2003 Dec   1 1 An aborted update can corrupt the database
598 code closed 2004 Feb anonymous   2005 Jan   1 4 Joins not supported in DELETE
530 code fixed 2003 Dec anonymous Pager 2003 Dec   2 2 sqlite returns SQLITE_BUSY forever (linux multithreaded)
531 code closed 2003 Dec anonymous   2003 Dec   4 4 INT is not treated the same as INTEGER
533 code fixed 2003 Dec anonymous   2003 Dec   2 1 Crash when using datetime() with a NULL value.
534 code fixed 2003 Dec anonymous   2004 Jan   2 2 possible bug in sqliteMalloc and sqliteMallocRaw
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)
537 code closed 2003 Dec anonymous VDBE 2003 Dec   1 2 Problems using sqlite_bind() with INSERT INTO ... SELECT statements
538 new closed 2003 Dec anonymous   2008 Jun   4 3 Different warnings in windows
540 event closed 2003 Dec drh   2009 Oct   1 5 Database corruption observed
542 code fixed 2003 Dec anonymous Parser 2003 Dec   1 1 crash on date parsing
544 new closed 2004 Jan anonymous   2009 Oct   5 4 Feature Request: Indicate UNIQUE columns in table_info.
545 code fixed 2004 Jan anonymous BTree 2004 Jan   5 4 Use of uninitialized memory
546 code closed 2004 Jan anonymous Pager 2004 Jan   3 3 (Program received signal SIGSEGV) when sqlite_open()
547 code closed 2004 Jan anonymous TclLib 2005 Jan   3 4 tcl array not cleared between queries
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
551 code fixed 2004 Jan anonymous Unknown 2004 Jan   3 3 Date/Time functions: some modifiers cause loss of h:m:s
552 code fixed 2004 Jan drh   2004 Jan   1 1 Integer overflow results in database corruption
553 code closed 2004 Jan anonymous Pager 2004 Jan   2 2 conversion error in compiling pager.c
554 code closed 2004 Jan anonymous Unknown 2004 Jan   3 1 sqlite_close SQLITE_MAGIC_ERROR
557 code closed 2004 Jan anonymous Unknown 2004 Jan   3 1 sqlite_close SQLITE_MAGIC_ERROR reply.
555 code closed 2004 Jan anonymous VDBE 2004 Jan   1 1 sqlite_step and sqlite_compile cause locking problem
558 build fixed 2004 Jan anonymous   2008 Mar   4 4 Makefile.in should honor libdir and bindir
559 code closed 2004 Jan anonymous Unknown 2008 Mar   1 1 Very slow insert into ... under Win2K
560 warn closed 2004 Jan anonymous   2008 Jun   4 4 Warnings on commpiling using Visual C++ 6.0
561 code fixed 2004 Jan drh Pager 2004 Jan   1 1 Database corruption when using Linux threads
563 new closed 2004 Jan anonymous Parser 2008 Jun   4 3 Support for autoincrement type "SERIAL" (from PostgreSQL)
564 code fixed 2004 Jan anonymous Parser 2005 Jan   4 4 Inability to determine column in subquery
602 code fixed 2004 Feb anonymous   2004 Feb   1 1 Update tablename set rowid = rowid -1 fails for more than 1000 records
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...
510 new closed 2003 Nov anonymous Unknown 2009 Oct   5 2 trigger: addition of create ability
325 code closed 2003 May anonymous Parser 2003 May   3 3 Memory Leak with a cancelled sqlite_exec() using a callback routine
579 code closed 2004 Jan anonymous   2004 Jan   3 1 condition where sqlite_decode_binary will return -1
714 new closed 2004 Apr anonymous Unknown 2009 Oct drh 3 3 Change sqlite_decode_binary to return buffer size
977 code closed 2004 Oct anonymous Unknown 2004 Nov   3 3 View Bug
784 code fixed 2004 Jun anonymous   2004 Jul   2 2 SQLITE_OMIT_DATETIME_FUNCS code error with Microsoft compilers
916 new closed 2004 Sep anonymous Unknown 2009 Oct   1 1 No delete notification for INSERT OR REPLACE
256 code fixed 2003 Feb anonymous   2003 May   3 2 Simple Makefile error on HP/UX, may affect other UNIX systems
300 new fixed 2003 Apr anonymous   2005 Feb   5 5 Correlated Subqueries are not supported
840 code closed 2004 Aug anonymous   2005 Jan   1 1 Query returns invalid results (Index problem?).
376 code closed 2003 Jul anonymous BTree 2003 Aug   2 3 btree-1.1.1...../src/btree.c:2687: failed assertion `pPage->isInit'
759 event closed 2004 Jun anonymous Unknown 2004 Jun a.rottmann 2 1 record can't be inserted
851 doc closed 2004 Aug anonymous Parser 2009 Oct mihailim 5 2 SQLite allows Zero length table column names
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?
338 new closed 2003 Jun anonymous Unknown 2009 Oct   5 1 lowerFunc and upperFunc Fail on foreign characters
825 code closed 2004 Jul anonymous   2004 Jul   3 3 lower(X) / upper(X) - not work correctly on non Latin characters
869 code fixed 2004 Aug anonymous   2004 Aug drh 3 3 SQLite 2.x: CREATE INDEX and dbl-quoted index names
1369 new closed 2005 Aug anonymous Shell 2005 Aug drh 5 5 Inefficient restoration of indexed dumps
70 doc closed 2002 Jun anonymous   2002 Sep   5 5 Error in online documentation for DROP VIEW
502 doc fixed 2003 Nov anonymous BTree 2003 Nov   5 3 Typos in Database File Format documentation
505 doc fixed 2003 Nov anonymous   2003 Nov   5 3 Typos in SQLite Database File Format document
508 doc closed 2003 Nov anonymous   2009 Oct   4 4 Build instructions on home page needs link to page with platform help
738 new closed 2004 May anonymous   2009 Oct danielk1977 4 1 Sort order array in memory
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
963 code closed 2004 Oct anonymous Unknown 2004 Oct   3 3 PRIMARY KEY
779 code closed 2004 Jun anonymous   2004 Jun   4 1 duplicated declaration of sqlite3_changes() in sqlite.h.in
974 new closed 2004 Oct anonymous   2008 Jun   5 4 Version-Resource in pre-compiled windows dll
1031 new closed 2004 Dec anonymous   2009 Oct   3 4 sqlite command line does not allow intermixing of dot commands and sql
1052 doc fixed 2004 Dec anonymous VDBE 2005 Jan   5 5 Typo error
1156 new closed 2005 Mar anonymous Unknown 2005 Mar   3 1 Cant fetch records in between one DATE to another DATE
1205 code closed 2005 Apr anonymous Unknown 2009 Oct   3 1 accent ecu etc. in connectionstring
1325 code closed 2005 Jul anonymous Unknown 2009 Oct   1 4 sqlite3_bind_value not implemented
1326 code closed 2005 Jul anonymous Unknown 2005 Aug   4 1 using callbacks with two exact queries duplicate results
1357 code fixed 2005 Aug anonymous   2005 Aug   1 1 MemLeak by CreateTable if exists
1399 new fixed 2005 Aug anonymous   2006 Jan   4 4 Please add "DROP IF EXISTS" support
1415 code closed 2005 Sep anonymous Unknown 2009 Oct drh 1 1 Querying for BLOB type fields
1510 build closed 2005 Nov anonymous   2005 Nov   3 2 Can't seem to get autoincrement to work no matter what I try
1730 new closed 2006 Mar anonymous   2006 Mar   2 5 referential integrity
1803 code fixed 2006 May anonymous Unknown 2006 Jun   3 3 sqlite3WinOpenReadWrite() passes wrong share parms to CreateFile()
1855 doc closed 2006 Jun anonymous   2006 Jun   5 5 how to configure SQLite with jboss
1954 code closed 2006 Sep anonymous Unknown 2008 Jun   1 1 Dual Core Processor Lockup
2000 doc closed 2006 Sep anonymous Unknown 2006 Sep   1 3 Teorical questions.
2105 new closed 2006 Dec anonymous   2009 Oct   5 5 sqlite3_exec does not return modified rows
2169 code closed 2007 Jan anonymous   2007 Mar adamd 2 1 cast function
2245 new closed 2007 Feb anonymous   2007 Feb a.rottmann 5 1 Union Problem on Empty Table
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
2312 code closed 2007 Apr anonymous   2007 Apr mike 1 1 Using ODBC. Only saves first 5 characters of text fields. Can you help
2553 code closed 2007 Aug anonymous   2007 Aug   3 3 AUTOINCREMENT not working when primary key has multiple columns
2571 todo closed 2007 Aug anonymous   2007 Aug   1 1 SQLite opening in Access
2585 code closed 2007 Aug anonymous   2007 Oct anonymous 1 1 Error Function GetAtomNameA
2667 code closed 2007 Sep anonymous   2007 Oct   1 1 no such function: hex no such function: regexp
2682 code closed 2007 Oct anonymous   2007 Oct   1 1 SQLite Text Problem
2707 code closed 2007 Oct anonymous   2007 Oct appledev 1 3 SQLite on Mac OS X seems to have a 4GB database limit
2735 code closed 2007 Oct anonymous   2007 Oct nmadhav 3 1 Error : Unrecognized Token
2757 doc closed 2007 Nov anonymous   2007 Nov   1 1 Special characters handling in SQLite Like Query
2782 code closed 2007 Nov anonymous   2007 Nov   1 1 bind_text(...) into transaction
3003 event closed 2008 Mar anonymous   2008 Mar   2 1 I dot connection help me
3014 new closed 2008 Mar anonymous   2008 Apr chw 4 4 SQLite3 Don't support charIndex and IndexOf methods
3032 code closed 2008 Apr anonymous   2008 Apr   1 3 sqlite3_exec() can not get column count for blob data
3220 code closed 2008 Jul anonymous   2008 Jul   1 1 install on hp unix error
3222 new closed 2008 Jul anonymous   2009 Oct   3 4 UPDATE with joined tables
3274 code active 2008 Aug anonymous   2008 Aug   1 1 "LIKE" does not work when searching for Arabic text
3565 doc closed 2009 Jan anonymous   2009 Oct   5 4 Unsupported feature addiction
3580 new closed 2009 Jan anonymous   2009 Jan chw 3 5 conect vbscript
3676 code closed 2009 Feb anonymous cli 2009 Feb   5 5 SQLite error no such table: syringes
3702 code fixed 2009 Mar anonymous   2009 Mar shane 5 4 Misspelling in sqlite3.c (succesfully instead of successfully)
3710 code closed 2009 Mar anonymous func 2009 Mar   5 1 Unable to open the database file
3754 xplatform closed 2009 Mar anonymous   2009 Oct   5 3 MySQL syntax compatibility: AUTO_INCREMENT as alias of AUTOINCREMENT
3837 code closed 2009 May anonymous vfs 2009 Jun adamd 1 1 MissingMethod exception cant find Can't find PInvoke DLL 'sqlite3.dll'
3842 code closed 2009 May anonymous back 2009 May a.rottmann 1 1 Sqlite3_exec is crashing when I am retrieving 1450 plus messages
3861 code closed 2009 May anonymous func 2009 May a.rottmann 3 1 I am not able to use variables with INSERT
4044 code closed 2009 Nov anonymous   2009 Nov   5 3 For Wince Patch Or Dll ?
1525 event closed 2005 Nov anonymous Unknown 2009 Oct anonymous 1 2 error creating database
1029 doc closed 2004 Dec anonymous Unknown 2008 Jun   4 5 SQLITE_ not SQLITE3_ constants in the C/C++ interface . html
1367 new closed 2005 Aug anonymous Shell 2005 Aug peter 1 1 connection string for SQLite with some examples
907 build fixed 2004 Sep anonymous   2004 Oct   1 2 If --enable-threadsafe then pthreads library is not linked in
1949 new closed 2006 Aug anonymous   2006 Aug   4 1 Missing 64Bit type
2587 build closed 2007 Aug anonymous   2009 Oct   3 4 Build problem when using the SQLITE_OMIT_FLOATING_POINT define.
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
1089 code closed 2005 Jan anonymous Shell 2005 Jan   1 1 Segmentation fault
1901 code closed 2006 Jul anonymous Unknown 2009 Oct adamd 2 2 problem in select request with a alias table
1854 event closed 2006 Jun anonymous   2006 Jun   3 3 i am unable to view the tables by using .tables command
1675 new closed 2006 Feb anonymous   2009 Oct   5 4 sqlite3_db_dup() ?
2207 new closed 2007 Jan anonymous   2009 Oct   3 4 "CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints
3938 code closed 2009 Jun anonymous test 2009 Oct   3 3 v 3..6.16 do not pass unit tests: 'make test'
802 warn closed 2004 Jul anonymous   2009 Oct anonymous 1 1 Unable to compile the sqlite
913 code fixed 2004 Sep anonymous   2004 Oct   3 2 Locking in os_unix.c
1006 new closed 2004 Nov anonymous Parser 2004 Nov   4 3 Creation of sqlite3_exec16 ?
1094 warn fixed 2005 Feb anonymous   2005 Feb   3 2 possible error in function OsWrite (in os_win.c)
1109 code closed 2005 Feb anonymous BTree 2005 Feb   1 1 assert in btree
1416 code closed 2005 Sep anonymous   2005 Sep xdong 1 1 database is same size as before when we do clearing operation.
2052 code closed 2006 Nov anonymous   2006 Nov   1 1 BLOBs still do not work on version 3.0
765 build fixed 2004 Jun anonymous   2004 Jun dougcurrie 3 2 MinGW/MSYS build fails with vrsion 3.0.0
768 code fixed 2004 Jun anonymous   2004 Jul anonymous 1 2 3.0.0 alpha WHERE-AND evaluation
769 code closed 2004 Jun anonymous   2004 Jun   2 2 macro SQLITE_OMIT_AUTHORIZATION is not honored
774 code fixed 2004 Jun anonymous Unknown 2004 Aug   1 1 sqlite3_exec not exported in windows sqlite.dll
1003 doc fixed 2004 Nov anonymous VDBE 2004 Nov   3 3 The documentation of VDBE Opcode SortPut is incorrect
775 code closed 2004 Jun anonymous Unknown 2004 Aug   1 1 windows sqlite3.dll corrupt?
778 code fixed 2004 Jun anonymous Unknown 2004 Jun   1 1 output of sqlite3_mprintf isn't correct
780 warn closed 2004 Jun anonymous Unknown 2009 Oct   3 2 Builkd gice src code errors on MacOS
781 code closed 2004 Jun anonymous Unknown 2004 Jun   4 4 unable to run malloc test even with -DMEMORY_DEBUG
783 code closed 2004 Jun anonymous Unknown 2009 Oct   3 3 Build on MAC with -DSQLITE_DEBUG=1 compile error
785 code fixed 2004 Jun anonymous   2004 Jun   1 1 local variable 'db' used without having been initialized
786 code fixed 2004 Jun anonymous BTree 2004 Aug drh 1 1 sqlite3 change SQLITE_PAGE_SIZE to 4096 causes assert
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
789 code fixed 2004 Jun anonymous   2004 Jun   1 1 the 'LL' qualifier is not supported by MSVC
837 code fixed 2004 Aug anonymous   2004 Sep   1 2 VACUUM returns "sql logic error or missing database"
1635 doc closed 2006 Jan anonymous   2009 Oct   4 4 SQLite Ticket "Version" field
790 code closed 2004 Jul anonymous   2004 Jul   1 1 Missing include file for the SQLITE distribution 3.0.x
791 code fixed 2004 Jul anonymous   2004 Jul   1 1 3.0.2 fails to build under Mingw
792 code closed 2004 Jul anonymous   2004 Sep   1 1 ODBC support is broken for 3.0.2
794 new fixed 2004 Jul anonymous Unknown 2004 Jul   4 3 add API to report number of wildcards in sqlite3_prepare*
797 new closed 2004 Jul anonymous Parser 2009 Oct   4 3 require basic named subquery / WITH sql support
798 code closed 2004 Jul anonymous Unknown 2009 Oct   1 1 Unable to run tests on Tru64 bit Linux platform
799 build closed 2004 Jul anonymous Unknown 2004 Jul   5 4 Missing exports in 3.0.2 Win32 DLL
801 code closed 2004 Jul anonymous   2004 Sep   1 3 Multiple problems with v3.0.2
803 new closed 2004 Jul anonymous Unknown 2004 Jul drh 1 1 sqlite3_create_function needs a userdata parameter
807 code fixed 2004 Jul anonymous VDBE 2004 Jul   1 3 Cannot run a prepared CREATE TABLE statement more than once
811 code fixed 2004 Jul drh   2004 Jul drh 1 1 When ATTACH fails, strange things happen.
816 doc closed 2004 Jul anonymous Unknown 2009 Oct   1 4 sqlite3_changes - absent in sqlitedll-3_0_2.zip
817 new closed 2004 Jul anonymous   2004 Jul   4 2 Return size of blob
818 doc fixed 2004 Jul anonymous   2004 Jul   4 3 The SQLite 3 API reference says "sqlite *" instead of "sqlite3 *"
846 code closed 2004 Aug anonymous Parser 2004 Aug   1 1 error(1) at dbdimp.c line 250 [for Statement "PRAGMA table_info(?)"]
849 code closed 2004 Aug anonymous Parser 2004 Sep   1 1 error(1) 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
820 code closed 2004 Jul anonymous Parser 2004 Oct   4 4 problem with sqlite3_prepare and variables
826 code fixed 2004 Jul drh CodeGen 2004 Aug drh 1 1 Nested views do not process * correctly.
827 code fixed 2004 Jul anonymous Unknown 2004 Jul   2 3 sub-select involving random() does not work
828 warn closed 2004 Jul anonymous Unknown 2009 Oct   3 3 integer constants to long
830 code closed 2004 Jul anonymous   2004 Jul   1 1 sqlite3_get_table() error
834 code fixed 2004 Jul anonymous Unknown 2004 Aug   4 3 No equivalent to sqlite_libversion() API call in SQLite3
836 code closed 2004 Aug anonymous   2004 Aug   1 1 sqlite3_prepare() fails when a temp table does not yet exists.
838 new fixed 2004 Aug anonymous   2004 Aug   4 2 Change os_common.h to allow SQLITE_DEBUG on Windows.
839 code fixed 2004 Aug anonymous   2004 Aug   2 2 'int isdigit(int)' causes a crash
842 code fixed 2004 Aug anonymous   2004 Aug   2 2 Ignoring an error return from sqlite3_exec causes invalid db.
873 code fixed 2004 Aug anonymous   2004 Sep   1 2 VACUUM of database with ' character in filename causes error
832 code closed 2004 Jul anonymous Unknown 2009 Oct anonymous 4 4 os_win.c :: sqlite3OsUnlock() method has an unused variable: rc
841 code closed 2004 Aug anonymous Unknown 2009 Oct   3 2 inner group by query isn't honored by outer count(*) aggregate
844 code fixed 2004 Aug anonymous VDBE 2004 Aug   1 1 AFTER DELETE trigger has erroneous values in old.X "variables"!
1421 code closed 2005 Sep anonymous BTree 2005 Sep   2 2 Assertion when I try to create a index
819 code fixed 2004 Jul anonymous Unknown 2004 Oct   1 2 building on linux/FC2 with --enable-threadsafe needs a -lpthread dep.
848 code fixed 2004 Aug anonymous Unknown 2004 Sep   3 3 make test seg fault in blob-1.5 on x86_64 Linux (Gentoo on Opteron)
855 build fixed 2004 Aug anonymous Unknown 2005 Feb   4 3 Unpack directory should include a version: sqlite-3.0.4/
856 code closed 2004 Aug anonymous   2004 Aug   1 1 memory leak within sqlite3_open()/sqlite3_close() pair
858 code closed 2004 Aug anonymous Unknown 2004 Aug   2 3 core dump when peforming bind
860 code fixed 2004 Aug anonymous Unknown 2004 Oct   3 1 SQLite 3.0.4 fails under Solaris 9
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
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
866 code closed 2004 Aug anonymous   2004 Aug   2 3 Breakage when repeatedly creating tables in an attached database
867 new closed 2004 Aug anonymous Parser 2009 Oct   3 2 update on multiple tables
868 doc closed 2004 Aug anonymous   2004 Aug   1 1 Conflict resolution fails when attempting to create duplicate key
870 code fixed 2004 Aug anonymous   2004 Aug   4 4 Segmentation Fault on sqlite3_step if sqlite3_prepare fails
875 code fixed 2004 Aug anonymous VDBE 2004 Aug   1 3 Error when INTERSECTing more than two subqueries.
876 code closed 2004 Aug anonymous Unknown 2004 Aug   1 3 select from ... where ... or ... is dead slow on indexed column
883 new closed 2004 Sep anonymous Shell 2009 Oct   1 4 Choose appropriate column widths for column output
877 todo fixed 2004 Aug anonymous Parser 2004 Aug   4 2 Binary garbage in preprocessed source file 'parse.c' (3.0.5)
878 build closed 2004 Aug anonymous Unknown 2008 Jun   5 5 Wrong shared library file-names
880 code closed 2004 Sep anonymous   2004 Sep   1 1 dropping a temporary table locks the database
881 code fixed 2004 Sep anonymous BTree 2004 Sep   1 3 Can not compile under Windows with Borland C++ Builder
885 code fixed 2004 Sep drh VDBE 2004 Sep   1 1 Sqlite3_step() does not return SQLITE_BUSY after a commit fails
886 code fixed 2004 Sep anonymous Unknown 2004 Sep anonymous 2 2 v3 assert with explain
899 doc fixed 2004 Sep anonymous   2004 Nov   4 3 sqlite3_create_function / negative nArg glitch
900 new fixed 2004 Sep anonymous   2004 Sep   4 4 sqlite3_trace and reusing prepared statements
882 code closed 2004 Sep anonymous Parser 2004 Sep   1 1 crash on insert
888 doc fixed 2004 Sep anonymous BTree 2004 Sep   5 4 incorrect (obsolete) comment above sqlite3BtreeOpen in btree.c
889 event closed 2004 Sep anonymous BTree 2004 Sep anonymous 1 2 btree.c with new malloc
890 code fixed 2004 Sep anonymous BTree 2004 Sep anonymous 1 1 Page sizes other than 1024 bytes result in segfaults
898 code fixed 2004 Sep anonymous   2004 Sep   1 1 nullif() crashes inside trigger
903 build fixed 2004 Sep anonymous   2004 Sep   3 3 make doc fails (please use mkdir -p)
904 build fixed 2004 Sep anonymous   2004 Sep   3 3 x86_64: please use $(libdir) instead of $(prefix)/lib
906 code closed 2004 Sep anonymous Unknown 2004 Oct anonymous 3 3 Wrong error code returned when there's not enough disk space available
891 build fixed 2004 Sep anonymous   2004 Sep   4 4 creating directories in makefile
908 event fixed 2004 Sep anonymous   2004 Sep   5 5 corrupt sqlite-3.0.7.so.gz file on download page
910 build fixed 2004 Sep dougcurrie Unknown 2004 Oct dougcurrie 2 2 Windows doesn't (usually) have or need pthread
912 code fixed 2004 Sep anonymous   2004 Sep   1 1 sqlite3 crashes in join statement
914 code fixed 2004 Sep anonymous Shell 2004 Sep   5 4 Small typo in shell help for .mode
919 event closed 2004 Sep anonymous Unknown 2009 Oct   1 1 'make test' RESETS macOSX at ioerr 2.73.1
924 code fixed 2004 Sep anonymous   2004 Oct drh 2 2 Compile problem using mingw "msys" environment and gcc 3.4.2
925 code fixed 2004 Sep anonymous BTree 2004 Sep   1 4 crash in btree.c:reparentPage when pageSize != usableSize
926 new fixed 2004 Sep anonymous   2004 Sep   1 1 create_function after a prepare returns MISUSE error
927 code fixed 2004 Sep anonymous   2004 Sep   3 2 errcode() returning OK even when previous function returned error
928 code closed 2004 Sep anonymous VDBE 2004 Sep drh 3 3 delete record by rowid would core dump
930 new closed 2004 Sep anonymous Unknown 2009 Oct drh 2 2 djgpp port for sqlite3
932 code fixed 2004 Sep anonymous VDBE 2004 Sep drh 3 4 With NDEBUG, SQLITE_DEBUG breaks
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
934 code fixed 2004 Sep anonymous   2004 Sep   3 1 pragma table_info
935 code closed 2004 Sep anonymous Unknown 2004 Nov   4 4 several crash.test tests fail (spuriously) when [sqlite3 -has-codec]
936 code fixed 2004 Sep anonymous CodeGen 2004 Sep   3 1 Prototype declaration is not correct
937 code closed 2004 Oct anonymous VDBE 2004 Oct drh 2 4 mixed wildcard "?" and ":abc" cause msvcrt.dll raise a exception.
940 new fixed 2004 Oct anonymous   2004 Oct   4 3 Simplify the makefile
942 code closed 2004 Oct anonymous CodeGen 2004 Oct   1 2 Horrible time complexity for certain triple joins.
943 new fixed 2004 Oct anonymous   2004 Oct   5 4 Missing const declarations.
944 new closed 2004 Oct anonymous Shell 2009 Oct   4 3 Command to abort current expression.
945 code closed 2004 Oct anonymous Unknown 2004 Oct   2 2 sqlite3 opens sqlite2 databases without complaining
946 code fixed 2004 Oct anonymous   2004 Oct   4 3 Including both sqlite.h and sqlite3.h results in error
947 warn closed 2004 Oct anonymous Unknown 2009 Oct   3 3 Cygwin: integer constant is too large for "long" type
948 code fixed 2004 Oct anonymous Unknown 2004 Oct   4 4 glob in attach2.test fails (Fedora Core)
949 new closed 2004 Oct anonymous Unknown 2004 Oct   3 3 add user-level test for file validity
950 new closed 2004 Oct anonymous Unknown 2004 Oct   2 4 No access to sqlite3ErrStr and sqlite3_temp_directory
953 code fixed 2004 Oct anonymous Shell 2004 Nov drh 2 3 sqlite3 core dump when delete record by specified rowid range
954 build closed 2004 Oct anonymous   2009 Jan   2 4 Autogerated opcodes.h breaks bulid on MinGW/MSYS
957 new closed 2004 Oct ghaering   2004 Oct   1 1 Old callback-based API should still return column types
960 doc closed 2004 Oct anonymous   2008 Jun   3 2 Make archive unpack into directory sqlite-VERSION/
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
986 code closed 2004 Nov anonymous Unknown 2004 Nov   3 4 indexed "between" is slower than manually typing out constraints
987 code closed 2004 Nov anonymous TclLib 2009 Jan   1 1 in Tcl, package require sqlite3 fails
994 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 Brackets in JOIN statements break <table>.<column> SELECT syntax
1016 code closed 2004 Nov anonymous   2004 Nov   3 3 UPDATE command with invalid SQL Syntax executes
1023 new closed 2004 Nov anonymous Unknown 2004 Dec   4 4 don't link against pthreads if not configured with --enable-threadsafe
938 code fixed 2004 Oct anonymous   2004 Oct   3 2 File locking in os_win.c (related to ticket #913)
1143 code closed 2005 Feb anonymous   2005 Feb   2 2 prepare/step give incorrect results, compared to the sqlite3 tool
939 code fixed 2004 Oct anonymous Unknown 2004 Oct   2 3 .import appends \n to last field (text fields, windows)
922 code fixed 2004 Sep anonymous   2004 Sep   5 2 SELECT statement crashes sqlite3
931 new closed 2004 Sep anonymous   2009 Oct   5 4 Makefile for mingw on Win32, makes DLL, EXE and docs
956 doc fixed 2004 Oct anonymous   2004 Oct   5 4 Typo on homepage
958 code closed 2004 Oct anonymous Unknown 2004 Nov drh 3 2 sqlite3_create_function() dose not really delete an user function
959 build fixed 2004 Oct anonymous   2005 Sep   4 4 mkopcodeh.awk requires gawk on Solaris
962 new fixed 2004 Oct anonymous   2004 Oct   4 4 Test btree_8.23.3 should use hypen instead of underscore
966 code fixed 2004 Oct anonymous   2004 Oct   1 1 GROUP BY of aggregate function fails with Out of Memory
967 event closed 2004 Oct anonymous TclLib 2004 Oct   3 2 PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so
969 code new 2004 Oct anonymous TclLib 2005 Jan   3 3 PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so part 2
972 warn closed 2004 Oct anonymous   2009 Oct   3 3 building SQLite on Irix
973 code fixed 2004 Oct anonymous Shell 2004 Oct   4 4 shell: "select" output interferes with future ".databases" output
975 code fixed 2004 Oct drh BTree 2004 Nov drh 1 1 Non-standard page sizes cause problems for large files
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
985 code fixed 2004 Nov anonymous BTree 2005 Jan   3 3 "Invalid read of size 1" errors created in btree.c line 2804
988 code closed 2004 Nov anonymous Unknown 2004 Nov   4 4 column type "int primary key" doesn't autoincrement
990 code closed 2004 Nov anonymous   2005 Jan   1 1 PRAGMA empty_result_callbacks in tclsqlite-3.0.8.so eliminated?
991 code fixed 2004 Nov anonymous VDBE 2004 Nov   4 4 misleading error message returned for bad column index
995 new fixed 2004 Nov anonymous   2004 Nov   4 3 Manual page for SQLite 3 should be named sqlite3.1
996 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 2 4 Error in primary key fields for temp tables
999 build closed 2004 Nov anonymous   2005 Jan   5 4 CVS conflict files left in the source
1000 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 1 1 use popen function and sqlite3_open is dummy..
1001 doc fixed 2004 Nov anonymous VDBE 2004 Nov   3 3 No documentation for VDBE Opcode MakeRecord
1002 doc fixed 2004 Nov anonymous Parser 2004 Nov   3 3 documentation of LIMIT clause is misleading
1004 doc fixed 2004 Nov anonymous Unknown 2004 Nov   3 3 eTextRep argument to sqlite3_create_function not documented
1005 code closed 2004 Nov anonymous Unknown 2004 Nov   1 1 No error from sqlite3_exec
1009 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 sqlite3RunVacuum: "forever" loop exists in error code path.
1014 doc closed 2004 Nov anonymous Parser 2009 Oct   5 5 Can't have column name "first" any more...
1015 doc closed 2004 Nov a.rottmann   2005 Mar   5 4 Manpage fixes for SQLite3
1018 code closed 2004 Nov anonymous Unknown 2005 Jan   1 3 Some functions not defined for OS_MAC
1020 doc closed 2004 Nov anonymous   2008 Jun mihailim 5 4 in html (.tcl) <,> is not always &lt, &gt
1021 code closed 2004 Nov anonymous   2004 Dec   1 3 LIKE operator % wildcarding broken
1022 code closed 2004 Nov anonymous   2004 Dec   4 4 Table column naming differs between versions 2.8.15 and 3.0.8
1024 code closed 2004 Dec anonymous   2004 Dec   1 1 trunk blob data
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
1028 new closed 2004 Dec anonymous Unknown 2004 Dec   2 2 Without COPY: need alt. method to import data (not .import)
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)
1032 new fixed 2004 Dec anonymous VDBE 2004 Dec   2 3 access violation in sqlite3_bind_parameter_index when name is NULL
1035 code fixed 2004 Dec anonymous Unknown 2004 Dec   1 1 union queries with sub-select tables with limits returns no results
1036 code fixed 2004 Dec anonymous Unknown 2007 Mar   3 1 Wrong handling of column names from VIEWs
1037 code closed 2004 Dec anonymous Unknown 2004 Dec   1 1 .Net Interop Problem
1038 code closed 2004 Dec anonymous   2004 Dec   2 2 multi-word type names confuse pragma table_info
1039 code fixed 2004 Dec anonymous   2005 Jan   1 1 GROUP BY causes a crash
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)
1041 code closed 2004 Dec anonymous Unknown 2004 Dec   1 1 select x<2 from table does not work anymore
1042 code closed 2004 Dec anonymous Unknown 2004 Dec   1 2 where does not work
1043 doc closed 2004 Dec anonymous   2008 Jun   3 3 SQLITE3_ANY does not exist
1045 event closed 2004 Dec anonymous   2004 Dec   1 5 MAJOR Problem with accessing databases
1049 doc fixed 2004 Dec anonymous   2005 Mar   4 4 Document that pragma default_synchronous is no longer available in v3.
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
1059 doc closed 2005 Jan anonymous Unknown 2009 Oct   5 4 Full support for IEEE 754 floating points
1060 code closed 2005 Jan anonymous   2005 Jan anonymous 1 2 result of calcul
1062 code fixed 2005 Jan anonymous CodeGen 2005 Jan   2 3 Home-built sqlite3 gives assertion failed on file where.c, line 383
1066 new fixed 2005 Jan anonymous Parser 2005 Jan   4 1 SQLite 3.0.8 does not allow the '$' on Column Names.
1067 code closed 2005 Jan anonymous TclLib 2005 Jan anonymous 2 4 Tcl parsing failure in SQL statement DELETE?
1069 code fixed 2005 Jan anonymous BTree 2005 Jan   3 3 Array bounds read error in Purify
1071 code closed 2005 Jan anonymous Shell 2005 Jan   4 3 Typo in .help
1072 code defer 2005 Jan anonymous   2005 Jan   3 3 Non-standard behaviour for date/time functions in SELECT
1073 code closed 2005 Jan anonymous Shell 2005 Jan   2 3 Windows Shell: .read commands need '/' in filenames to work
1075 build fixed 2005 Jan anonymous Unknown 2005 Sep anonymous 3 4 Solaris 9 build needs to use gawk instead of awk
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
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
1098 code closed 2005 Feb anonymous   2005 Feb   1 1 DBs created with PHP and the command line are incompatible
1099 code fixed 2005 Feb   VDBE 2005 Feb   1 1 make test fails on bind1.1.test
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
1104 code closed 2005 Feb anonymous VDBE 2005 Feb   1 1 Integer overflow
1107 new closed 2005 Feb anonymous Unknown 2005 Mar   5 3 please add function to query endianness match/mismatch for BLOB
1131 new closed 2005 Feb anonymous Unknown 2005 Feb   2 3 triggers don't seem to work across databases
1139 code closed 2005 Feb anonymous Unknown 2005 Mar   1 1 error while loading shared libraries
1251 code fixed 2005 May anonymous Parser 2005 May   3 2 Code fixes for memory leaks and invalid memory accesses
1312 code closed 2005 Jun anonymous Shell 2009 Sep   1 1 CSV file import / export is all wrong!
1313 new closed 2005 Jun anonymous   2009 Oct   4 4 Allow headers in imported text files
1343 code closed 2005 Jul anonymous   2005 Jul   1 1 segmentation fault on select on view
1748 code closed 2006 Apr anonymous VDBE 2006 Apr   3 3 Memory leak in insert.c: sqlite3TableAffinityStr
2992 event closed 2008 Mar anonymous   2009 Oct mlcreech 1 1 sqlite compatibility with windows mobile 6.0
989 code closed 2004 Nov anonymous Unknown 2004 Nov   3 3 Followup to #984, same issue with hexToInt
1064 code closed 2005 Jan anonymous CodeGen 2005 Jan   2 1 problems with queries and aggregate functions
1110 code closed 2005 Feb anonymous Parser 2005 Feb   4 4 Detection of invalid create table statement
1010 code fixed 2004 Nov anonymous BTree 2004 Dec   3 3 btree.c: "pagesSize" should be "usableSize" for AutoVacuum and MX_CELL
1012 build fixed 2004 Nov anonymous Unknown 2004 Nov   3 3 adding "cursor.c" to Makefile.in (diffs included)
1019 code closed 2004 Nov anonymous Unknown 2005 Jan   1 3 Improper handling of 8bit data
795 new closed 2004 Jul anonymous TclLib 2004 Oct   5 3 Separate TCL library from libsqlite3
872 code fixed 2004 Aug anonymous   2005 Sep   5 5 SQL does not support non-ASCII IO?
884 new closed 2004 Sep anonymous Parser 2004 Sep   5 1 Allow read only transactions.
921 code closed 2004 Sep anonymous   2004 Sep   5 5 2nd time: SQL does not support non-ASCII IO?
808 code closed 2004 Jul anonymous Unknown 2004 Jul   1 1 Lower() function with UNICODE
843 new closed 2004 Aug anonymous Unknown 2009 Oct   3 3 Introducing I64 printf size prefix
1829 code closed 2006 Jun anonymous   2006 Jun   1 1 Odbc driver parameter bind offset pointer does not work
871 code fixed 2004 Aug dougcurrie TclLib 2004 Aug   3 1 sqlite_temp_directory only defined in os_unix but used in tcl
917 code closed 2004 Sep anonymous VDBE 2004 Sep drh 1 1 bug with named parameters
918 code fixed 2004 Sep anonymous VDBE 2004 Sep   1 1 sqlite3_bind_parameter_index produces access violation
952 code closed 2004 Oct anonymous Unknown 2004 Oct   1 2 Serious memory leak for insert into table with primary key
1047 code fixed 2004 Dec   CodeGen 2005 Jan   1 1 text column comparison in joins may follow NUMERIC rules
1048 code fixed 2004 Dec anonymous   2005 Jan   3 2 Wrong column naming
1070 build closed 2005 Jan anonymous CodeGen 2009 Oct   1 1 error by compiling windows vcc / vc# <sqlite.h> not found
1113 code closed 2005 Feb anonymous Unknown 2005 Feb   2 2 Problem with TYPEOF function in triggers
1051 code fixed 2004 Dec anonymous Unknown 2004 Dec   2 2 pragma.c code breaks build when SQLITE_DEBUG #defined, fix included
1056 code closed 2004 Dec anonymous Shell 2009 Oct   3 3 test pragma-9.4 fails during second pass in "make fulltest"
1057 doc fixed 2004 Dec anonymous   2005 Jan   5 5 update "MEMORY_DEBUG" to "SQLITE_DEBUG" in several sqlite files
1058 code closed 2005 Jan anonymous BTree 2009 Oct   3 3 btree.c pageSize -> usableSize
1170 new fixed 2005 Mar anonymous Unknown 2005 Mar   3 3 strfdate Should Support Strict ISO-8601 Date Format
3054 doc fixed 2008 Apr anonymous   2008 Apr   5 4 column is used as a keyword but is not listed on website documentation
1084 code fixed 2005 Jan anonymous CodeGen 2005 Feb   1 1 Reference to outer query in result set can cause an assert() failure
1079 warn fixed 2005 Jan anonymous Unknown 2005 Jan   4 2 stddef.h should be included in sqliteint.h
1083 code fixed 2005 Jan anonymous VDBE 2005 Feb   1 1 crash in correlated sub-query
1212 code fixed 2005 Apr drh VDBE 2005 Apr   1 1 Large integers stored incorrectly.
1728 code fixed 2006 Mar drh VDBE 2006 Mar   1 1 Integrity_check fails after dropping tables in autovacuumed database
1085 code closed 2005 Jan anonymous   2009 Oct   2 3 pragma full_column_names and short_column_names still broken
1091 code closed 2005 Jan anonymous   2005 Jan   1 1 not the function of ".export TABLE FILE"
1090 new closed 2005 Jan anonymous   2009 Jan   1 1 tclinstaller.tcl does not support DESTDIR
1097 new closed 2005 Feb     2005 Feb   4 1 Please provide a numeric version number in sqlite3.h
1115 code fixed 2005 Feb drh   2005 Feb   1 1 Creating unique index on non-unique column leads to corruption
1787 code closed 2006 Apr anonymous   2006 Apr   1 1 Certain integer values are written/read incorrectly to/from database
1114 code fixed 2005 Feb anonymous   2005 Feb   1 1 Database corruption when using 'PRAGMA auto_vacuum=ON'
1092 code closed 2005 Feb anonymous Unknown 2005 Feb   1 2 wrong result of a query
1111 code active 2005 Feb anonymous Unknown 2005 Jun   3 1 no such column error with a subselect as a table
2303 code closed 2007 Apr anonymous   2009 Oct   1 1 Encrypted databases: No page cache due to problem in pagerSharedLock
1105 code closed 2005 Feb     2005 Feb   1 3 SQLite Crashes when do a Correlated subqueries
1108 build fixed 2005 Feb anonymous Shell 2005 Feb danielk1977 2 2 strcasecmp should be changed to sqlite3StrICmp
1093 doc closed 2005 Feb anonymous Unknown 2005 Feb   5 4 possible mistake in a comment sqlite3_get_table sqlite3.h:~line312
1095 code fixed 2005 Feb anonymous Unknown 2005 Feb   1 3 Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
1100 code closed 2005 Feb anonymous   2009 Oct   3 3 make test segfaults at capi2-7.12 on amd64 system
1106 code closed 2005 Feb anonymous   2005 Feb   2 1 sqlite3FinishCoding is masking errors during parsing
1112 code closed 2005 Feb anonymous   2009 Oct   3 4 make test failures (108 out of 19721) on AIX 5.2, Power5 CPU
1121 code fixed 2005 Feb anonymous Unknown 2005 Feb anonymous 1 2 Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
1122 code fixed 2005 Feb anonymous Shell 2005 Feb drh 3 2 strcasecmp in shell.c
1123 build closed 2005 Feb anonymous TclLib 2009 Oct   3 4 cannot find tcl.h
1125 code closed 2005 Feb anonymous Parser 2005 Mar   1 2 Syntax error: create index with table name qualified by database name
1128 event closed 2005 Feb anonymous Shell 2009 Oct   2 3 sqlite3-3.1.2.bin segfaults
1150 code closed 2005 Feb anonymous Parser 2005 Feb   4 4 'insert' is not a legal transaction name
1165 new fixed 2005 Mar anonymous Unknown 2005 Mar   3 4 On cygwin, sqlite filenames are windows, not cygwin
1230 event closed 2005 Apr anonymous TclLib 2005 May   1 1 coredump in tclsqlite on HPUX 11.11 64 bit
1530 code closed 2005 Nov anonymous Parser 2005 Nov xdong 2 1 error on where clause with serial-type.
1135 doc fixed 2005 Feb anonymous   2005 Mar   4 3 Typos in documentation for CREATE VIEW
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
1140 code fixed 2005 Feb anonymous CodeGen 2005 Mar   1 1 selectReadsTable infinite loop
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
1146 build fixed 2005 Feb anonymous   2005 Mar   4 4 make doc failure: no target 'arch.png'
1147 code closed 2005 Feb anonymous Parser 2005 Apr   1 1 column names do not respect pragma settings
1148 new closed 2005 Feb anonymous Shell 2005 Mar   5 5 patch to print query execute time on shell.c
1151 code fixed 2005 Mar anonymous CodeGen 2005 Mar   4 3 detach does not support database names inside square brakets
1152 code fixed 2005 Mar anonymous Pager 2005 Mar   3 4 create silently fails if corresponding journal file already exists
1153 code fixed 2005 Mar anonymous Unknown 2005 Mar   1 1 make test on 3.1.3 throws 11 errors
1154 event closed 2005 Mar anonymous VDBE 2005 Mar   1 1 PRIMARY KEY AUTOINCREMENT and TRIGGER problem
1159 code fixed 2005 Mar anonymous Unknown 2005 Mar   2 1 SQLite forgets to call the busy handler
1160 code closed 2005 Mar anonymous CodeGen 2005 Mar   4 4 GROUP BY is broken
1169 code fixed 2005 Mar anonymous VDBE 2005 Jun   1 1 Segmentation fault when deleting range of items using view/trigger
1172 code closed 2005 Mar anonymous   2005 Mar   1 3 sqlite3_step() seems to not reset database lock check
1285 code fixed 2005 Jun anonymous Pager 2005 Jun   1 3 deadlock in multithreaded application
1302 event closed 2005 Jun anonymous Unknown 2009 Oct   1 4 malloc error after dumping table
1699 code fixed 2006 Mar anonymous Unknown 2006 Mar   1 2 round(X) does not work correctly when nested in some functions
1997 code closed 2006 Sep anonymous   2006 Sep   2 3 can't select rows if column name is contained in data
2030 code fixed 2006 Oct anonymous   2006 Oct   1 1 CSV output should convert " to "" within values
2362 code closed 2007 May anonymous   2007 May   4 4 Can't add a column with ALTER TABLE
2834 event closed 2007 Dec anonymous   2007 Dec   2 1 Is Version 3.1.3 not compatible with 3.5.3 ?
1161 build fixed 2005 Mar anonymous   2005 Sep   2 4 Need to use "nawk" to build under Solaris 9
1162 new closed 2005 Mar anonymous   2009 Oct drh 1 2 Column names in sqlite views differ from oracle/informix column names
1163 code fixed 2005 Mar drh VDBE 2005 Mar   1 1 Database corruption possible on records with large numbers of columns.
1164 warn fixed 2005 Mar anonymous   2005 Mar   4 1 Compile warning about different "const" qualifiers
1166 code fixed 2005 Mar anonymous   2005 Mar   3 3 jounal1-1.2 test fails on Windows
1167 new fixed 2005 Mar anonymous   2005 Mar   4 3 test Bind-4.1 fails on Windows
1174 build closed 2005 Mar anonymous Parser 2005 Mar   4 4 Link problem using SQLITE_OMIT_xxx
1171 code fixed 2005 Mar anonymous Pager 2005 Jun   1 1 Statement transaction rollback can incorrectly update database file.
1566 new closed 2005 Dec ghaering VDBE 2009 Oct   5 4 Implement sqlite3_clone()
2196 code closed 2007 Jan anonymous   2007 Jan   5 3 Bug in PRAGMA full_column_names with SELECT *
1144 code closed 2005 Feb anonymous Unknown 2005 May   1 3 Changing page_size causes a GPF on memory databases
1080 doc fixed 2005 Jan anonymous   2005 Feb   3 3 Incorrect name in pragma documentation
1081 doc fixed 2005 Jan anonymous   2005 Feb   3 3 Errors in pragma documentation
1082 doc fixed 2005 Jan anonymous   2005 Feb   3 3 The new EXISTS predicate is not documented
1086 code closed 2005 Jan anonymous   2005 Jan   2 3 sqlite crashes while executing query
1175 code closed 2005 Mar anonymous Unknown 2005 Mar   1 1 busy handler is not being called
1182 code closed 2005 Mar anonymous   2005 Mar danielk1977 2 3 ALTER TABLE...ADD COLUMN fails if table has user-defined collation
1186 new closed 2005 Mar anonymous Shell 2009 Oct   4 4 Pragma page_size doesn't set the pagesize immediately
1200 code closed 2005 Apr anonymous   2009 Oct   2 3 new versions of SQLite return different (incorrect) results.
1204 new closed 2005 Apr anonymous TclLib 2009 Oct drh 4 2 (visible) version provided by tclsqlite package
1316 code fixed 2005 Jul anonymous Unknown 2005 Jul   4 4 Output from ROUND function is inconsistent cross-platform
1375 code fixed 2005 Aug anonymous   2005 Aug   4 3 Multi-database transactions perform undesirable fsyncs
1860 code closed 2006 Jun anonymous Pager 2009 Oct danielk1977 1 1 Problem in using SQLite3 with trigger and multithreading
1176 new closed 2005 Mar anonymous Unknown 2009 Oct   4 3 Blocking Writes
1178 code closed 2005 Mar anonymous VDBE 2005 Mar   1 1 sqlite 3 returns SQLITE_ERROR instead of SQLITE_SCHEMA
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
1183 code closed 2005 Mar anonymous Unknown 2005 Mar danielk1977 3 2 Memory coruption related to syntax errors
1184 todo fixed 2005 Mar danielk1977 CodeGen 2008 Jul   4 3 UTF-8 and UTF-16 substr() functions are subtly different
1190 new closed 2005 Mar anonymous Unknown 2009 Oct drh 4 4 strftime() does not Support Years with 3 or 5 digits
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
1197 code closed 2005 Apr anonymous   2005 Apr   1 1 race condition in sqlite3_close
1246 warn closed 2005 May anonymous   2009 Oct   4 3 Many warnings from gcc4
1229 code fixed 2005 Apr anonymous Unknown 2005 Apr   3 3 SQL code with trigger produces SegFault/BusError
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
1188 code fixed 2005 Mar anonymous   2005 Mar   1 3 Numbers greater than 0x7FFFFFFF are treated as signed in inequalities.
1193 new closed 2005 Mar anonymous   2009 Jun   1 2 umask not respected... please change 644 to 666 in src/os_unix.c
1194 code fixed 2005 Mar anonymous Pager 2005 Mar   4 4 64K page size does not work
1198 build fixed 2005 Apr anonymous Unknown 2005 Apr   1 1 3.2.1 build fails test and fulltest
1199 doc closed 2005 Apr anonymous   2008 Jun   4 3 Update the README file
1201 code closed 2005 Apr anonymous CodeGen 2009 Oct danielk1977 1 1 erro defined type UINT8_TYPE
1207 code closed 2005 Apr anonymous   2005 Apr anonymous 2 1 How to Install SQLite
1208 new closed 2005 Apr anonymous Unknown 2008 Jun   4 4 no version info provided in precompiled sqlite3.dll
1209 doc closed 2005 Apr anonymous Unknown 2008 Jun anonymous 3 5 SQLite3_Free_Table returns not #SQLITE_OK if suceeds
1210 code fixed 2005 Apr anonymous Unknown 2005 Jun   2 2 Generating SQLITE_INTERNAL error
1211 code fixed 2005 Apr anonymous   2005 Jun anonymous 2 2 too stupid boolean test
1213 code closed 2005 Apr anonymous Parser 2009 Oct   3 2 Problem with alias columns in subqueries
1214 code closed 2005 Apr anonymous Unknown 2009 Oct   2 3 sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects
1215 code closed 2005 Apr anonymous   2005 Apr   1 1 PRAGMA table_info and INTEGER UNSIGNED - sqlite3 client
1216 new fixed 2005 Apr anonymous   2005 Aug   4 3 strftime doesn't return milliseconds
1217 code fixed 2005 Apr anonymous Parser 2009 Jan   3 3 NATURAL JOIN results in incorrect "ambiguous column name" error
1218 code closed 2005 Apr anonymous Unknown 2005 Apr   2 1 'select rowid' does not return 'rowid' as column title
1219 code fixed 2005 Apr anonymous VDBE 2005 Jun anonymous 2 2 dereferencing null ptr in vdbeUnbind()
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
1224 new fixed 2005 Apr anonymous   2005 May   5 4 config.h is not required for build.
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
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
1234 code fixed 2005 May anonymous BTree 2005 May   1 1 solaris9 alignment problems
1235 code closed 2005 May anonymous Unknown 2009 Oct drh 4 3 inconsistent pragma handling
1236 todo fixed 2005 May anonymous Unknown 2005 Sep drh 3 3 Linux binary on download page not statically linked
1238 code closed 2005 May anonymous Unknown 2005 Jun   1 3 Failure to compile with SQLITE_OMIT_... macros enabled
1239 doc fixed 2005 May anonymous   2005 Sep   4 3 Documentation typos in different.tcl & docs.tcl
1241 code closed 2005 May anonymous   2009 Oct   4 5 sqlite3_create_collation16 - should have 'const void* zName' arg
1242 code closed 2005 May anonymous Shell 2009 Oct   3 4 EXPLAIN causes segmentation fault on OSX (and linux)
1247 new fixed 2005 May anonymous   2005 May   4 3 Default file permissions are too restrictive
1248 code closed 2005 May anonymous Unknown 2009 Oct   3 1 sqlite3_get_table returns garbage for BLOB data
1260 code fixed 2005 May anonymous   2005 May   4 4 value of synchronous changes back to full if you change the cache_size
1263 code fixed 2005 May anonymous   2005 Jun   1 3 full_column_names pragma not always honoured
1266 code closed 2005 May anonymous VDBE 2005 May   2 2 crash when using instead of update triggers on views
1267 code closed 2005 May anonymous   2005 May   5 4 exists and case don't work together on an empty table
1269 code closed 2005 May anonymous   2005 Jul   1 1 Bus Error during import
1270 code fixed 2005 Jun anonymous Unknown 2005 Jun   4 2 Creating views using prepared statements with parameters
1271 code fixed 2005 Jun anonymous Unknown 2005 Jun anonymous 1 3 Timeout not handled correctly, random behaviour on different platforms
1272 code fixed 2005 Jun anonymous Unknown 2005 Jun   1 3 File locks are broken in some multi-threaded environments
1273 code closed 2005 Jun anonymous Unknown 2005 Jun   3 3 Numeric affinity problem with views + coalesce (maybe all functions?)
1275 new fixed 2005 Jun anonymous   2005 Jun   4 3 Method to get sqlite3* from sqlite3_stmt
1276 code closed 2005 Jun anonymous Pager 2005 Jun   1 1 Failing assertion in pager.c
1277 doc fixed 2005 Jun anonymous Unknown 2005 Jun anonymous 3 3 "PRAGMA encoding" cannot be set after "PRAGMA synchronous"
1278 code closed 2005 Jun anonymous   2009 Oct   1 2 sqlite3_finalize doesn't clear previous error code or message
1280 new closed 2005 Jun anonymous   2005 Jun   5 4 Make tests can be run as root
1281 code closed 2005 Jun anonymous Unknown 2005 Jun   1 1 Errors testing sqlite 3.2.1
1283 code fixed 2005 Jun anonymous Unknown 2005 Jun   2 2 Database corrupts when creating table with autoincrement column
1298 code closed 2005 Jun anonymous Shell 2009 Oct drh 4 3 sqlite3.exe not recognizing newline as comment terminator
1334 doc fixed 2005 Jul anonymous Unknown 2005 Jul   1 1 problem MAX and sqlite3_column_text when no data is returned
1355 code closed 2005 Aug anonymous   2005 Sep   4 4 mixing GROUP and non-GROUP queries in a query should be an error
1359 code fixed 2005 Aug anonymous Unknown 2005 Aug   2 2 Segfault when using primary key plus another index.
1370 code fixed 2005 Aug anonymous   2005 Aug   3 4 Problem opening non-sqlite files smaller than spageSize.
1377 warn closed 2005 Aug anonymous   2005 Aug dwong 1 1 can't connect to database
1402 code closed 2005 Sep anonymous Unknown 2005 Sep   1 2 (Windows 2K) file handle on file not released after use
1505 code closed 2005 Nov anonymous TclLib 2005 Nov   2 3 Sqlite3 tcl bindings return "{}" instead of {} for the empty result
1523 code closed 2005 Nov anonymous Shell 2005 Nov danielk1977 5 1 size of database dose not change smaller after delete records
1597 new closed 2006 Jan anonymous Unknown 2009 Oct   1 3 wish: support DROP COLUMN
2346 code closed 2007 May anonymous   2007 May   1 1 Inserting a certain integer
2995 code closed 2008 Mar anonymous   2008 Mar   4 4 excessive calls to Sqlite3Error
1282 doc fixed 2005 Jun anonymous   2005 Jun   3 1 Typo in changes.tcl
1284 code fixed 2005 Jun anonymous Unknown 2005 Jun   2 3 Fail to compile at main.c:301 (old signature of function used)
1286 code closed 2005 Jun anonymous   2008 Jun   4 4 The downloadable DLL file does not work with Intel VTune
1287 code fixed 2005 Jun anonymous TclLib 2005 Jun   1 1 problem comparing with empty string inside tcl variable
1289 doc fixed 2005 Jun anonymous Unknown 2005 Jun   3 3 make doc misses a file named arch2.gif
1290 new closed 2005 Jun anonymous VDBE 2005 Jun drh 1 1 optimize VBDE, reordening ID numbers of OP_????? codes
1291 build fixed 2005 Jun anonymous   2005 Jun   2 3 makefile fix for Borland dll import lib under windows
1292 code fixed 2005 Jun anonymous Unknown 2005 Jul   4 4 'make test' fails on OS X, includes fix
1293 build closed 2005 Jun anonymous   2009 Oct   1 1 No file .LIB in sqlitedll-3_2_2.zip for links in Windows.
1296 new closed 2005 Jun anonymous Unknown 2006 Feb   5 5 Nested Transactions needed
1297 code fixed 2005 Jun anonymous Unknown 2005 Jun   1 3 sqlite 3.2.2 reproducible access violation
1299 new closed 2005 Jun anonymous   2005 Jun   3 3 need NOT EXISTS
1301 code fixed 2005 Jun anonymous CodeGen 2005 Jun   2 3 CREATE UNIQUE INDEX fails with existing rows with NULL as compound key
1304 new fixed 2005 Jun anonymous TclLib 2005 Jun   3 4 use Tcl_EvalObjv when calling user defined functions in Tcl library
1305 code closed 2005 Jun anonymous TclLib 2009 Jan   1 1 Tcl installs pkgIndex with wrong path
1306 doc fixed 2005 Jun anonymous   2005 Jun   4 4 DROP TABLE doc error
1307 new closed 2005 Jun anonymous   2005 Aug   1 1 BLOBs and Tcl library (again)
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
1311 code fixed 2005 Jun anonymous   2005 Aug   1 2 misuse-5.1 crashing on Mac OS X
1314 code fixed 2005 Jun anonymous Unknown 2005 Jul   1 2 Can't compile Sqlite 3.2.2 from .zip sources
1317 code closed 2005 Jul anonymous   2005 Aug   3 3 Aggregate aliases result in assert() failure
1319 new closed 2005 Jul anonymous   2009 Oct   5 4 Extend sqlite3_expired to detect schema changes
1320 doc fixed 2005 Jul anonymous Unknown 2005 Jul drh 5 5 comment says sqlite3_create_aggregate which does not exist any more
1321 doc fixed 2005 Jul anonymous Unknown 2005 Sep drh 5 5 strange comment
1323 code closed 2005 Jul anonymous   2009 Oct   1 1 misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped)
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
1331 event fixed 2005 Jul anonymous Pager 2005 Sep anonymous 1 1 unicode filename for database
1332 new closed 2005 Jul anonymous Unknown 2009 Oct   5 5 update 20x slower when using a temp table
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
1337 new fixed 2005 Jul anonymous   2005 Aug   3 4 compability problems with column names starting with digits
1338 code fixed 2005 Jul anonymous Parser 2005 Jul   2 2 assert triggers inside sqlite3AuthRead()
1340 code fixed 2005 Jul anonymous Unknown 2005 Aug anonymous 1 1 round(1e300) dumps core
1342 code closed 2005 Jul anonymous   2009 Oct   1 1 sqlite 3.2.2 will not load on Suse Linux 9.3
1346 code fixed 2005 Aug anonymous BTree 2005 Aug   2 2 assertion fires when query string goes beyond 865 characters
1347 code fixed 2005 Aug anonymous VDBE 2005 Aug anonymous 1 1 Concatinate operation with BLOB causes assertion fail
1348 code fixed 2005 Aug anonymous Shell 2005 Aug   3 1 Ticket #939 is not really fixed
1349 code closed 2005 Aug anonymous Unknown 2005 Aug anonymous 4 4 NULL handling UNIQUE indexes is not consistent
1350 code closed 2005 Aug     2005 Aug   3 3 sqlite gives errors with valgrind
1351 code closed 2005 Aug anonymous Shell 2009 Oct   1 1 Unable to parse UTF8 input
1352 code closed 2005 Aug anonymous Pager 2005 Aug   3 3 Databases created via ATTACH do not respect page_size pragma
1353 new fixed 2005 Aug anonymous   2005 Aug   5 4 Enhance error message when disk is full
1354 code fixed 2005 Aug anonymous VDBE 2005 Aug anonymous 3 2 Misusing sqlite3Error in vdbeapi.c
1356 code fixed 2005 Aug anonymous Parser 2005 Aug   4 4 Memory leak on query?
1358 code fixed 2005 Aug anonymous Unknown 2005 Aug   1 1 ORDER By Does not work
1360 code closed 2005 Aug anonymous   2005 Aug   4 4 Unsafe casting in table.c
1361 code closed 2005 Aug anonymous Unknown 2005 Sep   1 1 sqlite3_mprintf function(s) don't account for commas with %q flag
1362 code fixed 2005 Aug drh VDBE 2005 Aug   1 1 Dump and restore converts floating-point values to integers
1363 todo fixed 2005 Aug anonymous   2005 Aug   5 5 More symbols declared as static
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
1403 code closed 2005 Sep anonymous Pager 2009 Oct   4 4 Newly initialized pages aren't completely cleared
1485 code closed 2005 Oct anonymous Unknown 2009 Oct jshen 3 1 cyrilic problem(suppose Unicode as a whole, for PPC)
1487 code closed 2005 Oct anonymous BTree 2009 Oct   1 3 Corrupt database causes indefinite loop in sqlite3_step()
1520 new closed 2005 Nov anonymous   2006 Jul   4 4 sqlite3_column_type do not work for empty table
1557 event closed 2005 Dec anonymous Parser 2006 Mar   1 1 sqlite core dumps in exprNodeIsConstant
1565 doc closed 2005 Dec anonymous   2009 Oct   4 4 wrong return-type specified for sqlite3_db_handle in c-api-reference
1735 code closed 2006 Mar anonymous Unknown 2009 Oct   1 3 Encoding problem
1782 code closed 2006 Apr anonymous Unknown 2009 Oct   1 1 journal file exclusion
1819 code closed 2006 May anonymous Unknown 2006 May persicom 4 3 faulty html code for concatenated field with "<" character
1906 new fixed 2006 Aug anonymous Unknown 2008 Mar   1 2 date.c line 417 uses non-thread safe localtime() call
2001 code fixed 2006 Sep anonymous Unknown 2006 Sep   2 2 Views on altered tables are defect
1315 code fixed 2005 Jul anonymous Unknown 2005 Jul   1 1 busy callback called in 2 distinct places when starting a transaction
1345 code fixed 2005 Jul anonymous VDBE 2005 Aug   4 4 Small cosmetic defect in code
1372 build fixed 2005 Aug anonymous   2005 Sep   4 3 Use of incompatible function (gsub) in mkopcode[ch].awk on Solaris
1373 code fixed 2005 Aug anonymous   2005 Aug   1 1 Assertion fail with empty BLOB
1376 code fixed 2005 Aug anonymous VDBE 2005 Aug   1 3 Lengthy WHERE clause with many BETWEEN clauses seg fault
1770 new closed 2006 Apr anonymous   2009 Oct   5 4 Request for expanded DELETE USING keyword like PostgreSQL
1378 build fixed 2005 Aug anonymous   2005 Aug   3 3 Compiling with "./configure --enable-threadsafe; make" is broken
1380 code fixed 2005 Aug anonymous   2005 Aug   1 1 Crash with IN(correlated subquery)
1381 new closed 2005 Aug anonymous Parser 2009 Oct   5 4 missing important builtin function stdev
1384 code fixed 2005 Aug anonymous   2005 Aug   3 3 misuse-5.1 test fails because of memory corruption
1390 build fixed 2005 Aug anonymous   2005 Aug   4 3 Remove GNU-make-ism from Makefile.in
1410 code closed 2005 Sep anonymous Unknown 2005 Sep   2 3 count(*) confused by newlines in data
1637 code closed 2006 Jan anonymous Parser 2009 Oct   4 4 Multiple JOIN USING() doesn't work.
1393 event closed 2005 Aug anonymous Unknown 2009 Oct   4 3 failure in select2-2.0.3... test
1394 code fixed 2005 Aug anonymous VDBE 2005 Aug   3 3 Uninitialized variable in isSortingIndex()
1395 code fixed 2005 Aug anonymous Shell 2005 Aug drh 3 4 SQLite3 segfaults with -DSQLITE_OMIT_MEMORYDB and no filename
1396 code fixed 2005 Aug anonymous   2005 Sep   3 3 File paths with international characters are don't work on Windows
1397 code closed 2005 Aug anonymous Shell 2009 Oct   1 1 .mode csv creates ASCII output instead of UTF-8
1398 warn fixed 2005 Aug anonymous Parser 2005 Aug   5 5 Low priority warning to to resolve
1401 code closed 2005 Aug anonymous Shell 2009 Oct   4 4 concatenating html in select list
1405 build fixed 2005 Sep anonymous Unknown 2005 Sep   4 4 awk build problem on Solaris 10
1406 code closed 2005 Sep anonymous   2005 Sep   1 1 no result with order by
1407 code fixed 2005 Sep anonymous   2005 Sep   3 3 WinAPI, CreateFileA is not utf-8 compatible.
1408 code closed 2005 Sep anonymous Parser 2005 Sep   1 1 ATTACH DATABASE doesn't support *.db files
1409 code fixed 2005 Sep anonymous   2005 Sep   1 1 pragma empty_Result_callbacks and ANALYZE crashes
1412 code fixed 2005 Sep anonymous   2005 Sep   3 2 C++Builder 6 compilation
1413 code fixed 2005 Sep anonymous   2005 Sep   3 3 SUM returns unexpected results for columns with NULL values
1414 code fixed 2005 Sep anonymous   2005 Sep   2 3 Complex query that used to work with sqlite 3.2.2 doesn't with 3.2.5
1417 new closed 2005 Sep anonymous   2009 Oct drh 3 3 Fix successive access to a DB handler (unix broken thread file lock)
1418 code fixed 2005 Sep anonymous Parser 2005 Sep   3 3 assert() when creating a table with duplicate column names
1422 code closed 2005 Sep anonymous   2005 Sep   1 1 incorrect error codes from sqlite3_errCode
1423 new closed 2005 Sep anonymous   2009 Oct drh 3 4 Binding NULL does not work as expected
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
1433 code fixed 2005 Sep anonymous   2005 Sep   1 1 3.2.5 behaves differently than 3.2.2 when an index is created
1434 code closed 2005 Sep anonymous   2005 Sep   1 1 .dump dumps sqlite_stat1, which makes it impossible to load dump
1435 code fixed 2005 Sep anonymous   2005 Sep   1 1 query optimizer results in rows being returned in the wrong order
1451 code closed 2005 Sep anonymous Shell 2009 Oct   4 3 .mode insert does not output BLOBs in an usable way
1482 code closed 2005 Oct anonymous   2005 Oct   1 1 Cannot finish a transaction if a previous transaction was rolled back;
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.
2414 code closed 2007 Jun anonymous   2008 Jun   1 1 Unable t
1419 code fixed 2005 Sep anonymous Shell 2005 Sep drh 1 1 Shell no longer dumps sqlite_sequence
1425 doc fixed 2005 Sep anonymous Unknown 2005 Sep drh 5 5 NDEBUG
1437 code fixed 2005 Sep anonymous VDBE 2005 Sep drh 1 1 bulid failed on windows
1440 code fixed 2005 Sep anonymous   2005 Sep   1 1 2 compilation errors on VC6 (windows)
1441 code closed 2005 Sep anonymous VDBE 2008 Jun   4 4 sqlite3_clear_bindings routine missing
1442 code closed 2005 Sep anonymous Parser 2005 Sep   1 1 sqlite3 3.2.6/3.2.2/3.2.1 reproductible crash
1443 code closed 2005 Sep anonymous   2005 Sep drh 3 3 pragma full_column_names and short_column_names seems not working.
1444 code fixed 2005 Sep anonymous Unknown 2005 Sep drh 1 1 select union all and order by problems
1449 code fixed 2005 Sep anonymous   2005 Sep   1 1 Failed assert at select.c, line 1733: p->pRightmost==p
1450 code closed 2005 Sep anonymous Shell 2005 Sep   1 1 Unable to compile on SCO Openserver(gcc)
1458 code closed 2005 Sep anonymous Shell 2008 Jun   2 2 Error at .importing in csv format (another)
1507 code closed 2005 Nov anonymous VDBE 2005 Nov   2 2 Embarassing buffer overflow in sqlite3VdbeMemPrettyPrint( )
1570 code fixed 2005 Dec anonymous Unknown 2006 Mar drh 3 3 pragma table_info() incorrect result for columns with NONE affinity
1452 code closed 2005 Sep anonymous   2005 Sep   3 2 segmentation fault on OS X tiger
1453 code fixed 2005 Sep anonymous Unknown 2005 Sep   1 4 make test fails in conflict tests on mac os x
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 ?
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
1464 new closed 2005 Oct anonymous   2009 Oct   4 3 Improving PRAGMA table_info()
1465 code closed 2005 Oct anonymous CodeGen 2009 Oct   1 1 fdatasync not available and not yet fixed
1466 warn closed 2005 Oct anonymous   2009 Oct   5 5 compile warnings
1467 build fixed 2005 Oct anonymous   2006 Jan   1 1 3.2.7 on Solaris still chokes on fdatasync
1470 new closed 2005 Oct anonymous Unknown 2005 Oct anonymous 2 4 International support
1472 build closed 2005 Oct anonymous   2005 Oct   1 5 Borland command line compiler v 5.5 and SQLite
1473 code fixed 2005 Oct drh CodeGen 2005 Oct drh 1 1 Incorrect results when a subquery contains UNION ALL
1474 code fixed 2005 Oct anonymous   2006 Apr   2 3 SQLITE3.DLL fails to load if address 0x60900000 occupied
1476 new closed 2005 Oct anonymous   2009 Oct   5 4 Patch for SQLite sequence manipulation functions
1477 code closed 2005 Oct anonymous Unknown 2006 Sep   1 2 first "select count(*) from mytable" takes a very long time
1478 code fixed 2005 Oct anonymous Unknown 2005 Nov drh 3 2 Large file compile error with table.c
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.
1493 code active 2005 Oct anonymous Parser 2005 Oct   3 3 lemon: pathsearch uses wrong directory separator under Win32
1496 code closed 2005 Oct anonymous   2005 Oct   4 3 No index creation possible on :memory: DB
1497 code fixed 2005 Oct anonymous Parser 2005 Oct   4 1 SQL with unclosed string is accepted
1498 build closed 2005 Oct anonymous   2009 Oct   4 3 SQLite Cygwin support
1499 code closed 2005 Oct anonymous   2006 Mar anonymous 3 1 Sqlite 3.2.7 does not support Chinese path.
1501 code fixed 2005 Oct anonymous   2005 Nov   1 3 Access violation at address 00001002 error.
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
1506 new closed 2005 Nov anonymous Shell 2009 Oct   1 4 Add some flags to .import command
1509 code closed 2005 Nov anonymous   2005 Nov   3 2 Different performance - SELECT COUNT(*) AND SELECT *
1511 event closed 2005 Nov anonymous   2005 Nov   1 1 how to use the index with "order by"
1512 code fixed 2005 Nov anonymous Unknown 2005 Nov drh 3 3 VACUUM is a no-op on empty databases
1513 code fixed 2005 Nov anonymous Unknown 2005 Nov drh 1 1 last 3.2.7 cvs checkout doesn't compile under ms vc++
1514 code fixed 2005 Nov anonymous Unknown 2005 Nov   4 3 Strange single table query with aggregate and group by causes segfault
1516 code closed 2005 Nov anonymous   2005 Nov   1 2 comparison error in WHERE clause
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 ?
1521 code closed 2005 Nov anonymous Unknown 2009 Dec   3 2 ORDER BY sorts incorrectly with aliased fields
1524 code fixed 2005 Nov anonymous Pager 2006 Jan   2 3 Crash when using pragma auto_vacuum with :memory: database
1527 code defer 2005 Nov anonymous   2005 Nov   1 1 DROP TABLE returns "database disk image is malformed" error
1528 new closed 2005 Nov anonymous Unknown 2009 Oct   5 4 Add Build Date To Command Line Greeting
1531 code closed 2005 Nov anonymous   2005 Nov   4 3 Crash when evaluating SELECT ... HAVING NOT EXISTS
1532 new closed 2005 Nov anonymous TclLib 2009 Oct   4 4 Variables don't get replaced in ATTACH statements.
1533 code fixed 2005 Nov anonymous   2006 Mar   1 1 file os_win.c, function utf8ToUnicode and unicodeToUtf8 BUG
1534 code closed 2005 Nov anonymous   2005 Nov   1 1 error:
1535 code closed 2005 Nov anonymous Unknown 2005 Nov   2 3 Segmentation fault on query
1536 code fixed 2005 Nov anonymous Unknown 2005 Nov   2 1 insert ... select changes format of columns
1537 code fixed 2005 Nov anonymous BTree 2005 Nov   2 1 Left Join broken (wrong results)
1539 code closed 2005 Nov anonymous   2006 Mar   4 4 sqlite3Realloc is a trap for the unwary
1540 code closed 2005 Nov anonymous Unknown 2005 Nov   2 3 Failure to create a primary key
1542 code closed 2005 Nov anonymous Unknown 2009 Oct   2 4 wrong field names in views with quoted table name qualifiers
1544 code fixed 2005 Nov anonymous Unknown 2005 Nov drh 1 2 last CVS checkout doesn't compile under cygwin or msvc
1545 build closed 2005 Nov anonymous Shell 2007 Feb   4 4 Solaris systems require -lrt to link sqlite3
1547 event closed 2005 Nov anonymous Unknown 2009 Dec   1 1 slow insert into indexed table and slow index create on huge table
1549 build closed 2005 Dec anonymous   2009 Oct   5 4 install fails for non-root user when TCL active
1550 new closed 2005 Dec anonymous Unknown 2009 Oct   3 3 Triggers across attached databases
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()
1554 code fixed 2005 Dec anonymous Parser 2006 Jan   3 3 sqlite3_prepare ignores nBytes parameter
1556 event closed 2005 Dec anonymous Unknown 2005 Dec anonymous 1 1 database locked if used on mounted nfs shares (linux)
1558 new closed 2005 Dec anonymous VDBE 2009 Oct   3 4 Request more debugging info when SQL statements in progress
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
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!
1564 build closed 2005 Dec anonymous   2009 Oct   4 4 Need GNU awk
1567 code fixed 2005 Dec drh Pager 2005 Dec   1 1 Database corruption following statement rollback
1568 code closed 2005 Dec anonymous Unknown 2006 Mar   1 1 sqlite3_column_decltype( ) returning BadPointer with "UNION"
1573 code closed 2005 Dec anonymous Shell 2009 Oct   3 3 Bad CSV output when data contains double quotes
1576 build closed 2005 Dec anonymous   2009 Oct   4 4 PREFIX is not honored (cannot install as non-root)
1579 code closed 2006 Jan anonymous Shell 2006 Jan anonymous 1 1 database locked
1602 code closed 2006 Jan anonymous   2006 Jan   4 5 likely typo in shell.c
1603 code fixed 2006 Jan anonymous   2006 Jan   5 5 better customization of macro N_GUARD in utils.c
1628 code fixed 2006 Jan anonymous   2006 Jan   4 4 pragma integrity_check returns "OK" on a corrupt database
1633 code closed 2006 Jan anonymous VDBE 2009 Oct   3 3 sqlite3_step returns SQLITE_ERROR when interrupted
1646 doc fixed 2006 Jan anonymous   2006 Jan   3 4 API doc clarification for bind_text: utf8 bytes or chars?
1676 code closed 2006 Feb anonymous   2006 Feb   2 2 When binding the wrong type sqlite3 bails out but retuns an SQLITE_OK
1683 new closed 2006 Feb anonymous Unknown 2008 Jun   4 3 .mode html produces uppercase tags
1708 code closed 2006 Mar anonymous Unknown 2006 Mar anonymous 4 3 Spurious warning: no such table: faculty(1) at dbdimp.c line 269
1715 doc closed 2006 Mar anonymous   2006 Mar   5 4 int sqlite3_release_memory(int) documented but not implemented
1716 doc fixed 2006 Mar anonymous   2006 Mar   5 4 sqlite3_db_handle() has wrong documented signature
1551 code closed 2005 Dec anonymous   2005 Dec   1 1 sqlite3_reset seems not to be exported correctly
1593 code fixed 2006 Jan anonymous BTree 2006 Jan drh 1 2 error compiling with #define SQLITE_OMIT_AUTOVACUUM
1457 code closed 2005 Sep anonymous Shell 2009 Oct   3 1 non-latin chars not recognized by CLI
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
1548 warn closed 2005 Dec     2005 Dec   1 1 Command failed for target `sqlite3'
1572 code fixed 2005 Dec anonymous Parser 2006 Jan   2 1 Null Mallocation
1575 code fixed 2005 Dec anonymous Shell 2005 Dec   4 3 resolve_backslashes in shell.c is broken
1577 build closed 2005 Dec anonymous Unknown 2009 Oct drh 3 3 32bit compile on 64bit system fails to build sqlite3
1578 doc fixed 2005 Dec anonymous Unknown 2006 Mar   5 4 Typo on http://www.sqlite.org/version3.html page
1580 code closed 2006 Jan anonymous   2006 Jan   4 2 3.2.8 does not compile under Solaris 10
1581 code closed 2006 Jan anonymous   2006 Jan   4 3 incompatible pointer types lead to compilation errors
1583 code fixed 2006 Jan anonymous CodeGen 2006 Mar   2 4 explain query plan missing length
1584 code fixed 2006 Jan anonymous Unknown 2006 Jan   1 5 Solaris 8: bus error when /dev/urandom is not readable
1586 new fixed 2006 Jan anonymous   2006 Jan   2 3 ORDER BY with LIMIT clause is sub-optimal in speed and memory usage
1587 code fixed 2006 Jan anonymous Unknown 2006 Jan   3 3 Timezone is parsed reversely
1588 new closed 2006 Jan anonymous   2009 Oct   4 4 common subexpression elimination not performed in SELECT
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
1595 doc closed 2006 Jan anonymous   2006 Jan   4 1 tcl-devel is required to build. This requirement is not listed
1596 doc fixed 2006 Jan anonymous   2006 Jan   5 5 obsolete MakeIdxKey opcode references in vdbe.c and documentation
1604 build fixed 2006 Jan anonymous   2006 Jan   4 3 opcode generation fails on solaris 8 due to ancient awk
1609 code closed 2006 Jan anonymous Unknown 2006 Jan   2 3 ALTER TABLE ADD COLUMN failed if table name has multibyte character
1611 code fixed 2006 Jan anonymous   2006 Jan   4 3 sqlite3_close on wrong thread returns SQLITE_OK but leaks filehandle
1626 new closed 2006 Jan anonymous Unknown 2009 Oct   4 4 ALTER TABLE BUG/MISHEAVIOR
1631 code closed 2006 Jan anonymous   2006 Jan   2 3 Sqlite3 reports fdatasync type referenced symbol not found on Solaris
1632 code fixed 2006 Jan anonymous VDBE 2006 Jan   3 3 sqlite3_result_error doesn't work in user defined aggregate function
1634 code fixed 2006 Jan anonymous CodeGen 2006 Jan   3 3 LIMIT in nested select not working properly
1636 todo closed 2006 Jan anonymous Shell 2009 Oct drh 4 3 stdev does not work
1644 code fixed 2006 Jan ghaering VDBE 2006 Jan   3 3 CREATE TEMP/DROP TEMP do not modify schema cookie
1647 doc closed 2006 Jan anonymous Unknown 2008 Jun   3 1 i want to use this lib in my project
1658 code fixed 2006 Feb anonymous   2006 Feb   3 4 SQLITE3.EXE program crash
1689 new closed 2006 Feb anonymous   2009 Oct   2 4 triggers and temporary tables
1692 code closed 2006 Feb anonymous   2006 Mar   1 2 Collation dont work in functions
1720 new closed 2006 Mar anonymous   2009 Oct   3 4 Actions made by a trigger are not triggered
1844 warn closed 2006 Jun anonymous   2006 Jun   2 3 compiler warnings with gcc 3.3.4 on Tru64 V5.1B
1931 new closed 2006 Aug anonymous   2006 Aug   3 3 timezone difference between PDO/Sqlite and PHP
1932 new closed 2006 Aug anonymous   2006 Aug   3 4 I want a way to make db open fail if file does not exist
1937 new fixed 2006 Aug anonymous Unknown 2006 Aug drh 4 4 Tilda substitution not done on db file names.
1559 new closed 2005 Dec anonymous Unknown 2005 Dec   4 4 SQLite file is corrupt
1177 code closed 2005 Mar anonymous Shell 2009 Oct   1 4 (Win32) .import inserts extra carrier character in every row
1404 event closed 2005 Sep anonymous Unknown 2005 Sep   1 1 pragma case_sensitive_like is broken?
1486 code fixed 2005 Oct anonymous   2006 Jan   4 3 schema which is stored in sqlite_master was not complete
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
1679 new closed 2006 Feb anonymous   2009 Oct   4 4 SQLite requires code modification to replace memory allocation funcs
1996 new closed 2006 Sep anonymous Unknown 2009 Oct drh 2 3 Data type CHAR
2304 new closed 2007 Apr anonymous   2009 Oct   1 1 resolve "databas is locked" problem under DEFERRED transaction
1600 new fixed 2006 Jan anonymous   2006 Jan   5 4 WinCE locking implementation
1601 code fixed 2006 Jan anonymous Unknown 2006 Jan anonymous 1 2 3.3.0 multithreaded apps memory leak
1605 code fixed 2006 Jan drh VDBE 2006 Jan   1 1 Assertion fault when trying to LIKE a BLOB in UTF-16 mode.
1606 code closed 2006 Jan anonymous   2006 Jan   1 1 sqlite3_prepare16 broken
1607 code fixed 2006 Jan anonymous   2006 Jan   1 1 sqlite3_set_authorizer causes subsequent access violation
1608 doc fixed 2006 Jan anonymous   2006 Jan   4 3 Yet undocumented: create table IF NOT EXISTS
1610 code closed 2006 Jan anonymous   2006 Jan   1 2 SQLITE_OMIT_SUBQUERY can cause access violation
1612 code closed 2006 Jan anonymous   2006 Jan   1 3 "malformed database schema" when opening 3.2.8 database with SQLITE_OM
1655 new closed 2006 Feb anonymous VDBE 2009 Oct   4 4 Every function can have their private data like agreagates
1614 code fixed 2006 Jan anonymous   2006 Jan   2 2 sqlitedll-3_3_1.zip contain no DLL
1615 warn fixed 2006 Jan anonymous   2006 Jan drh 2 2 Metrowerks CodeWarrior compiler errors when build sqlite
1616 warn fixed 2006 Jan anonymous   2006 Jan drh 2 2 RVCT compiler warnings when making sqlite build
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
1619 code fixed 2006 Jan anonymous   2006 Jan drh 1 1 Can't compile sqlite with SQLITE_ENABLE_MEMORY_MANAGEMENT
1620 todo closed 2006 Jan anonymous   2006 Jan   1 1 error database or disk is full
1621 code closed 2006 Jan danielk1977   2009 Oct   5 5 Compiling with OMIT_FLOATING_POINT causes a segfault 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
1625 warn fixed 2006 Jan anonymous Unknown 2006 Jan   3 3 Compiler errors in building Sqlite3 from source
1627 warn closed 2006 Jan anonymous   2009 Oct   4 4 warnings on BCB and how to resolve them + couple of minor fixes
1629 code fixed 2006 Jan anonymous   2006 Jan drh 1 1 The fix for #1623 causes an assert in sqlite3MallocAllow()
1639 code closed 2006 Jan anonymous Unknown 2006 Mar   3 3 pkgconfig file in 3.3.1 says version is 3.3
1722 new closed 2006 Mar anonymous Unknown 2009 Oct   4 2 agregate sum() of strings
2165 code closed 2007 Jan anonymous   2009 Oct drh 4 3 pager performance and checksum
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
2178 code closed 2007 Jan anonymous   2007 Apr   1 1 On Windows Vista, a simple select returns different results.
2182 code closed 2007 Jan anonymous   2009 Oct   4 4 sqlite3BtreeGetMeta does not check the file format
2190 code closed 2007 Jan anonymous   2007 Jan   3 4 bogus lines on "left join" with a "where right_table.column is NULL"
2191 code fixed 2007 Jan anonymous   2007 Jan   4 3 Minor C++/C linkage compatibility issue in sqlite3.h
2198 new closed 2007 Jan anonymous   2009 Oct   5 4 API: opening only existing databases
2293 code closed 2007 Apr anonymous   2007 Apr   2 2 Extra file operations with sub journal when DB in MEM
2819 code closed 2007 Dec anonymous   2007 Dec   2 1 Blocking and crashing
2166 code fixed 2007 Jan shess   2007 Jan shess 2 3 fts modules corrupt data during UPDATE.
2183 code closed 2007 Jan anonymous   2009 Oct drh 1 1 OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
2184 code fixed 2007 Jan anonymous   2007 Jan drh 1 1 OMIT_SHARED_CACHE: missing #define in loadext.c
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
2189 code fixed 2007 Jan anonymous   2007 Jan   1 4 Incorrect results on LEFT JOINs with IS NULL condition in WHERE clause
2192 code fixed 2007 Jan drh   2007 Jan   1 1 Assertion fault on a deeply nested view
2193 code fixed 2007 Jan anonymous   2007 Jan   4 4 incorrect prototypes in tokenize.c
2194 code fixed 2007 Jan anonymous   2007 Jan   4 4 possible multiple inclusion with vdbeInt.h
2197 code closed 2007 Jan anonymous   2007 Jan   4 5 invalid(?) join syntax results in runnable sql code
2266 new closed 2007 Mar anonymous   2009 Oct anonymous 3 3 Add support for Row_Number() Over
2199 build closed 2007 Jan anonymous   2008 Mar   1 1 configure doesn't find libreadline if its in uncommon place
2201 code fixed 2007 Jan anonymous   2007 Feb   1 1 copy in tclsqlite doesn't work
2205 build closed 2007 Jan anonymous   2009 Oct anonymous 1 1 Problem while using with tcl on ARM
2206 new closed 2007 Jan anonymous   2009 Oct   5 4 Support for foreign key constraints in virtual tables
2208 todo fixed 2007 Jan anonymous   2007 Feb   1 1 SQLite CVSTrac attachment corruption?
2211 code fixed 2007 Feb anonymous   2007 Feb   1 3 select A.*, B.* from A join B where A.id=B.a_id order by A.id, B.value
2215 code closed 2007 Feb anonymous   2009 Oct   1 2 error messages in virtual table are not propagated
2216 code fixed 2007 Feb anonymous   2007 Feb   4 4 sqlite3ExprCompare() returns false for sqlite3ExprDup() result
2217 code fixed 2007 Feb anonymous   2007 Feb pamg 1 2 Incorrect result after first deleting operation (PRAGMA count_changes)
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
2223 code closed 2007 Feb scouten   2009 Oct   3 3 pragma auto_vacuum doesn't survive .dump & reconstitute
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?)
2227 new defer 2007 Feb scouten   2007 Apr   5 4 Feature request: CHECKPOINT command
2229 code fixed 2007 Feb anonymous   2007 Feb   1 2 Complex triggers can blow up sqlite
2235 new closed 2007 Feb anonymous   2009 Oct   4 3 Missing xml support in FTS2 for the snippet function
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
2280 new closed 2007 Mar anonymous   2009 Oct   4 3 Check constraint failure message should include field name
2295 code fixed 2007 Apr anonymous   2007 Apr   1 1 Subquery fails when "order by" is added
2405 code closed 2007 Jun anonymous   2007 Jun   1 1 sqlite3_prepare() don't work in php pdo implementation
2476 todo closed 2007 Jun anonymous   2009 Oct   4 3 SQLite3 ignores ORDER BY clause when performing SELECT ... GROUP BY
2486 code closed 2007 Jul anonymous   2007 Sep   2 3 pragma index_list does not detect index created on 2nd connection
3302 code closed 2008 Aug anonymous   2008 Aug   2 2 Bug in CREATE TABLE xyz AS SELECT * command.
2219 code closed 2007 Feb shess   2009 Oct shess 2 2 Creating an fts table in an attached database works wrong.
2231 new closed 2007 Feb anonymous   2009 Oct   4 4 shell should ignore leading whitespace for meta commands
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
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
2240 code closed 2007 Feb anonymous   2007 Feb   1 1 Parser command termination problem fails to catch illegal statements
2241 code closed 2007 Feb scouten   2009 Oct   3 3 pragma integrity_check no longer affects command-line tool's exit code
2242 code fixed 2007 Feb anonymous   2007 Feb   2 3 sqlite3 authorizer is not reentrant
2243 code closed 2007 Feb anonymous   2007 Jul   2 3 sqlite3 authorizer cannot be exposed in garbage collected languages
2244 code closed 2007 Feb anonymous   2007 Feb danielk1977 1 2 xUpdate in virtual table being called when no record exists
2247 doc closed 2007 Feb anonymous   2009 Oct   3 3 documentation of DEFUALT cluase in CREATE TABLE should be fixed
2249 code fixed 2007 Feb drh   2007 Feb drh 1 1 OR clause optimizer confused by column affinities
2250 code closed 2007 Feb anonymous   2007 Mar danielk1977 1 1 segmentation violation when using "select max(rowid)" in fts1
2251 code fixed 2007 Feb anonymous   2007 Feb   1 1 sqlite3_column_type gives bad type for sum() .. group by
2252 code fixed 2007 Feb drh   2007 Feb drh 1 1 New INSERT optimization bypasses CHECK constraint checks
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)
2257 doc fixed 2007 Feb adixon   2007 Mar   4 4 Auto-vacuum documentation misleading
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
2264 code fixed 2007 Mar anonymous   2007 Mar   3 1 User defined functions naming problem
2268 code fixed 2007 Mar shess   2007 Mar drh 1 4 SQLITE_OMIT_ATTACH doesn't disable sqlite_attach() function.
2269 code closed 2007 Mar anonymous   2007 Mar anonymous 2 1 SQLite3_Column_decltype treat [char] (32) as 'char',but not 'char(32)'
2270 build fixed 2007 Mar anonymous   2008 Mar   3 4 Build on Solaris 8 does not include other libs in .so build
2273 code fixed 2007 Mar anonymous   2007 Mar   1 2 Under latest release 3.3.13 query results in crash (used to run fine)
2276 code fixed 2007 Mar anonymous   2007 Mar   4 3 strftime %f zero padding problem
2279 code closed 2007 Mar anonymous   2007 Mar   3 4 sqlite3_exec NULL pointer crash
2281 build fixed 2007 Apr anonymous   2007 Apr   4 4 "CFLAGS=-DSQLITE_DEFAULT_FILE_FORMAT=4" causes alter2.test to fail
2525 code fixed 2007 Jul anonymous   2007 Jul   1 3 Constraint violations fail silently with "insert or replace"
2526 code fixed 2007 Jul anonymous   2007 Jul   2 4 Core dump when issuing a select statement with special having clause
2529 code closed 2007 Jul anonymous   2007 Jul anonymous 1 1 Bug in sqlite3_prepare_v2( ) function
2545 code active 2007 Jul anonymous   2007 Jul   1 4 Group by returns table name with field name
2891 code closed 2008 Jan anonymous   2008 Feb   2 3 col with "NOT NULL", no default: works on table create, not col add
2237 code closed 2007 Feb anonymous   2009 Oct   4 4 Test suite regressions using Tcl 8.5
2407 code fixed 2007 Jun anonymous   2007 Jun   1 4 Problem with ` (0x60) character in LIKE statement
2282 code active 2007 Apr anonymous   2007 Apr   3 4 Update on view with no matching trigger does not raise error
2283 warn closed 2007 Apr anonymous   2009 Oct   1 1 Compile warning by VCToolkit2003
2284 build fixed 2007 Apr anonymous   2007 Apr   1 1 make test fails with - undefined external sqlite3_xferopt_count
2285 code fixed 2007 Apr drh   2007 Apr   1 1 Rolling back a CREATE TEMP TABLE wedges the database
2287 code fixed 2007 Apr anonymous   2007 Apr   1 1 make test fails on latest 3.3.14 cvs code
2291 code fixed 2007 Apr drh   2007 Apr   1 1 VACUUM fails when NULLs appear in a UNIQUE constraint
2344 code fixed 2007 May anonymous   2007 Jun   2 3 Range of INTEGER not ANSI compliant
2288 code closed 2007 Apr anonymous   2009 Oct   4 2 FTS does not support REPLACE
2290 code fixed 2007 Apr anonymous   2007 Apr   1 1 Using function result text as a function parameter
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
2298 code fixed 2007 Apr anonymous   2007 Apr anonymous 3 2 Sqlite 3.3.15 backs out performance changes introduced in 3.3.14
2299 build closed 2007 Apr anonymous   2009 Oct   1 1 Cannot compile sqlite-3.3.15 on linux rhel
2301 build closed 2007 Apr anonymous   2009 Oct   1 1 Latest cvs 3.3.15 fails lock4-1.3 test
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 ?
2306 code fixed 2007 Apr anonymous   2007 Apr   4 3 Maybe detective Boolean-expression in sqlite3Expr() ?
2310 code closed 2007 Apr anonymous   2009 Oct anonymous 4 4 Problem installing on AIX 5.3, ML5 after successful compile with xlc
2370 code closed 2007 May anonymous   2007 May   3 2 Data is converted without me telling it to do so
2289 code fixed 2007 Apr shess   2007 Apr shess 1 1 fts1 and fts2 crash when deleting or replacing rows with a null field.
2309 code fixed 2007 Apr shess   2007 Apr shess 1 1 Assert failure in fts2 MATCH of certain OR cases.
2296 code fixed 2007 Apr anonymous   2007 Apr   3 3 IN clause of UNION of literal SELECT statements with ORDER BY
2307 build fixed 2007 Apr anonymous   2007 Apr   4 4 missing #ifndef SQLITE_OMIT_SHARED_CACHE breaks compilation
2308 build closed 2007 Apr anonymous   2009 Oct   4 3 make sqlite3.c recreates sqlite3.c even though nothing changed
2311 code fixed 2007 Apr anonymous   2007 Apr   4 4 redefinition of 'ARRAYSIZE'
2313 build closed 2007 Apr anonymous   2009 Oct   3 3 readline.h is not properly detected
2314 code fixed 2007 Apr anonymous   2007 Apr   1 1 SQLITE_OMIT_UTF16 Can't be Defined
2315 code closed 2007 Apr anonymous   2007 Apr   1 1 Macro Redefinition Warning
2316 code closed 2007 Apr anonymous   2007 Apr   4 4 2 prepared statements on same database cause RC = 21
2319 code fixed 2007 Apr anonymous   2007 Apr   4 4 Duplicated test identifiers
2358 code closed 2007 May anonymous   2007 May   3 4 Incorrect index chosen for query
2373 new closed 2007 May anonymous   2009 Oct   4 4 "create table as explain <expr>" doesn't work
2374 code closed 2007 May anonymous   2009 Oct   5 5 "ALTER TABLE foo RENAME TO bar" will quote bar (ie. 'bar')
2376 code closed 2007 May anonymous   2009 Oct   3 3 -batch doesn't work soon enough
3985 code closed 2009 Jul anonymous test 2009 Jul   4 4 capi3c.test does not test for SQLITE_OMIT_UTF16
3988 code fixed 2009 Jul anonymous test 2009 Jul   4 4 vacuum2 test does not handle OMIT_INCRBLOB properly
3989 code active 2009 Jul anonymous test 2009 Jul   4 4 lock3 has funky filepath causing problems on windows
2320 code closed 2007 Apr anonymous   2009 Oct drh 1 1 sqlite3_open(sFN_with_umlaut)
2321 code fixed 2007 Apr anonymous   2007 Apr   3 3 sqlite3_value_bytes moves pointer although there is no type conversion
2322 code closed 2007 Apr anonymous   2009 Oct   1 1 Windows error: datetime('2000-10-29 06:00:00','localtime')
2323 code fixed 2007 Apr anonymous   2007 Apr   3 3 invalid TRIM for multibytes
2324 code fixed 2007 Apr anonymous   2007 Apr   2 2 replace('abc', '', 'x') dumps core
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++
2330 code closed 2007 May anonymous   2007 May drh 2 2 Usage of fieldname Session is impossible for where clause
2331 code closed 2007 May anonymous   2007 May   1 1 Performance problem with complex where clause
2334 code fixed 2007 May anonymous   2007 May   3 3 valgrind complains about memcpy in select.c (overlapping memory)
2335 code fixed 2007 May anonymous   2007 May   1 2 real value corruption on different platforms
2336 warn closed 2007 May anonymous   2009 Oct   4 4 Compiler warnings on strcpy(), sprintf(), et al.
2338 todo closed 2007 May anonymous   2007 May   4 3 3.3.17 windows dll download gives 3.2.7
2341 code fixed 2007 May anonymous   2007 May   1 1 Potential buffer overflow in sqlite3_snprintf().
2345 code fixed 2007 May anonymous   2007 May   3 3 NaN is printed as '0.0'
2347 code fixed 2007 May anonymous   2007 May   3 3 sqlite 3.3.17 crashes when doing "IN (select union select)"
2348 doc fixed 2007 May anonymous   2007 May   5 3 deteched -> detected
2349 code fixed 2007 May anonymous   2007 May   3 3 Inconsistent conversion of BLOB to TEXT on UTF-16
2350 code closed 2007 May anonymous   2009 Oct   1 1 Temp files not deleted on WinCE
2351 secure closed 2007 May anonymous   2009 Oct   2 2 UTF-16 convertor accepts malformed UTF-8 sequence
2352 code closed 2007 May anonymous   2009 Oct   5 3 timeout just 500 msec to soon
2353 code closed 2007 May anonymous   2007 May   1 1 Issue with selecting values of indexed column
2354 code fixed 2007 May anonymous   2007 May   2 1 Win32 locking problems
2355 code closed 2007 May anonymous   2007 May   3 4 Segfault with looooong sql string
2359 code fixed 2007 May anonymous   2007 May   1 5 typo error
2360 code fixed 2007 May anonymous   2007 May   2 2 Possible buffer overrun in some text functions
2363 code closed 2007 May anonymous   2009 Oct   3 3 Couldn't build 3.3.17 on Cygwin/Vista
2364 code fixed 2007 May anonymous   2007 May   2 2 cast(as numeric) truncates small number of large integer
2369 code closed 2007 May anonymous   2007 May   3 3 if you do a configure --prefix=/home/someotherdir tcl installs wrong
2372 code closed 2007 May anonymous   2009 Oct   4 4 sqlite3TestLockingStyle not used if SQLITE_FIXED_LOCKING_STYLE defined
2375 doc closed 2007 May anonymous   2007 May   4 4 sqlite3_exec docs mentions sqlite3_reset
2377 build closed 2007 May pweilbacher   2008 Aug   4 3 Allow easy DLL build on OS/2
2383 code closed 2007 May anonymous   2009 Oct   3 3 Inconsistent conversion of BLOB revisited
2384 doc closed 2007 May anonymous   2007 May   1 5 an error in comments
2385 code closed 2007 May anonymous   2007 May   5 4 Comment for SQLITE_VERSION_NUMBER has a typo (missing zero).
2388 code closed 2007 May anonymous   2009 Nov   1 3 ORDER BY fails on compound select
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)
2396 code closed 2007 Jun anonymous   2009 Oct   1 3 -column output truncates characters from varchar field.
2397 build closed 2007 Jun anonymous   2009 Oct   2 4 make install failed on Cygwin
2402 code closed 2007 Jun anonymous   2007 Jun   3 3 Left Outer Join and Where clause
2403 code fixed 2007 Jun anonymous   2007 Jun   3 3 LEFT JOIN inconsistancy with NULL expression in ON clause
2404 code fixed 2007 Jun anonymous   2007 Jun   2 2 Values in INTEGER PRIMARY KEY always less than NULL
2406 code fixed 2007 Jun anonymous   2007 Jun   1 3 C++ style comments unacceptable in C code.
2409 code closed 2007 Jun anonymous   2009 Oct drh 1 1 Database malformed with SQLite3.3.17 on WindowsXP
2411 new closed 2007 Jun anonymous   2009 Oct   5 3 fts2 RFE - Separate index and storage
2412 build closed 2007 Jun anonymous   2007 Jun a.rottmann 1 1 Can't make Sqlite 3.3.17 on Solaris 10 X86
2417 new closed 2007 Jun anonymous   2009 Oct drh 3 3 Idea for read write concurrency.
2418 code fixed 2007 Jun drh   2007 Jun drh 1 1 Database corruption following malloc failure in auto-vacuum mode
2419 build closed 2007 Jun anonymous   2009 Oct   1 2 'CP_UTF8' : undeclared identifier when trying to build the dll
2441 code closed 2007 Jun anonymous   2007 Jun   2 3 Windows only error when deleting tempory files
2448 new fixed 2007 Jun anonymous   2008 Mar   4 3 SQLITE needs to identify public exported symbols
2452 code closed 2007 Jun anonymous   2007 Jun drh 1 1 In Memory Query Performance
2463 todo closed 2007 Jun anonymous   2007 Jun anonymous 1 1 Crash after calling sqlite_close() if SQLITE_ENABLE_MEMORY_MANAGEMENT
2484 new closed 2007 Jul anonymous   2009 Oct   5 4 Support for RETURNING
2485 code closed 2007 Jul anonymous   2007 Jul   1 2 SQLite + Python segfaults at various places in the code
2487 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLite database locked error on NFS mounted home dir
2488 new closed 2007 Jul anonymous   2009 Oct   5 4 autosize on column output mode in sqlite3 program
2493 build closed 2007 Jul anonymous   2007 Jul   2 3 Fails to build under GCC-4.1.3 on FreeBSD-6.2
2497 code closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_errcode does not return the proper error code
2530 code closed 2007 Jul anonymous   2009 Oct   2 3 Unable to write to windows share, even with exclusive lock
2568 new closed 2007 Aug anonymous   2009 Oct   3 3 TEMP_STORE is ignored in some cases
2750 code closed 2007 Oct anonymous   2007 Oct   2 1 for the new.somefield value returns the old value of it
2818 code closed 2007 Dec anonymous   2007 Dec   2 4 Comparison of 8 bytes integer numbers is truncated
2357 code closed 2007 May anonymous   2007 Jun anonymous 2 2 Crash in sqlite3PagerClose when SQLITE_ENABLE_MEMORY_MANAGEMENT is def
2379 code fixed 2007 May anonymous   2007 May   3 3 Concatenation with zeroblob
2356 code fixed 2007 May anonymous   2007 May   1 1 INDEX not used if column in WHERE clause refers to an alias
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
2340 code closed 2007 May anonymous   2009 Oct   3 3 "./configure && make testfixture" link problem
1479 code fixed 2005 Oct anonymous Unknown 2006 Jan   1 3 SQLITE_ALTER_TABLE not authorized for "alter table ... add ...;"
1640 code closed 2006 Jan anonymous VDBE 2006 Jan   3 2 Can't get error message from sqlite3_result_error
1642 code closed 2006 Jan anonymous   2006 Jan   4 4 single time leaks in sqlite3_prepare()
1643 doc closed 2006 Jan anonymous   2009 Oct   1 2 database-name.table-name not working for "PRAGMA table_info" + friends
1645 code fixed 2006 Jan anonymous Shell 2006 Jan   2 3 constraint using "in"
1648 new closed 2006 Jan anonymous   2009 Oct   4 3 meaningless error message: constraint failed
1650 code fixed 2006 Jan anonymous Unknown 2006 Jan   3 4 Third parm of sqlite3_prepare is ignored.
1664 code fixed 2006 Feb anonymous   2006 Feb   1 1 sum() returns wrong result
1666 code fixed 2006 Feb anonymous   2006 Feb   3 3 sqlite3_analyzer has 32-bit overflow errors
1649 doc fixed 2006 Jan anonymous   2006 Jan drh 4 1 changes.tcl incorrect in latest checkin
1651 code fixed 2006 Jan anonymous Shell 2006 Jan   1 1 .import doesn't work in 3.3.3
1652 code fixed 2006 Jan anonymous CodeGen 2006 Feb   3 4 sorting ASC vs DESC changes number of returned rows
1653 new closed 2006 Feb anonymous CodeGen 2009 Oct   4 5 SQLITE_OMIT_COST_REORDERING ?
1654 code fixed 2006 Feb anonymous VDBE 2006 Feb   1 1 crash when executing query on Intel builds
1657 code fixed 2006 Feb anonymous   2006 Feb   1 1 Disk I/O error when used on memory filesystem
1659 event closed 2006 Feb anonymous Shell 2006 Feb anonymous 1 2 Sqlite.exe .import stopped working in latest 3.3.3 release (Win32)
1660 code fixed 2006 Feb anonymous   2006 Feb danielk1977 1 1 OS memory allocation functions may round-up the requested size
1662 code fixed 2006 Feb anonymous Unknown 2006 Mar drh 1 3 Wrong CAST result rsp. missing string trimming on number conversions
1665 code fixed 2006 Feb anonymous Unknown 2006 Feb drh 1 1 Memory corruption using ALTER TABLE
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)
1668 event closed 2006 Feb anonymous Shell 2006 Feb drh 2 3 datetime modifiers "enf of *" and "group * by" do not work
1671 new fixed 2006 Feb anonymous Parser 2006 Feb drh 5 4 Support '@' as a named parameter prefix
1672 code fixed 2006 Feb anonymous Unknown 2006 Feb   1 1 Deadlock when multithreading on unix
1680 build fixed 2006 Feb anonymous   2006 Mar   4 3 configure --enable-debug doesn't enable verbose explain
1686 code closed 2006 Feb anonymous Pager 2006 Feb   2 4 File locking and concurrency problems under Windows
1707 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Internal data are not naturaly aligned, which could affect perfomance
1894 event closed 2006 Jul anonymous Unknown 2006 Jul   4 3 "library routine called out of sequence" when using progress (TCL)
2665 code closed 2007 Sep anonymous   2007 Sep   3 1 Dissapearing exclusive lock when DB is copied...
2146 code closed 2007 Jan anonymous   2007 Jan   1 2 Correlated subqueries as columns of select return a syntax error
1669 code fixed 2006 Feb anonymous   2006 Feb   1 3 sum() still returns wrong result
1670 code fixed 2006 Feb anonymous   2006 Feb   1 3 sum() still returns wrong result - the sequel
1673 code closed 2006 Feb anonymous Shell 2006 Feb   3 3 constraint using "in" -- bug 1645 revisited
1674 code fixed 2006 Feb anonymous   2006 Feb   3 3 sum(-9223372036854775805) returns integer -9223372036854775808
1678 code closed 2006 Feb anonymous Unknown 2006 Feb   1 1 error select like
1681 code closed 2006 Feb anonymous Unknown 2006 Mar   1 3 After upgrading from 3.2.7 to 3.3.4, problems with umlauts
1682 code fixed 2006 Feb anonymous Unknown 2006 Feb   4 4 accessing temp database causes crash
1684 code fixed 2006 Feb anonymous   2006 Mar   2 2 SQLITE_MIN_SLEEP_MS not defined in main.c
1685 code defer 2006 Feb anonymous   2006 Feb   1 1 Stall on multithread application.
1688 code fixed 2006 Feb anonymous VDBE 2006 Mar danielk1977 3 2 Incorrect column names when doing select on views
1691 code closed 2006 Feb anonymous Unknown 2006 Mar   3 3 sqlite3_sleep not built
1693 new closed 2006 Feb anonymous Parser 2009 Oct   4 4 Parser sensitive to position of word AUTOINCREMENT
1694 code closed 2006 Feb anonymous Parser 2006 Feb   3 3 SELECT count(distinct vnum) FROM table generates syntax error.
1695 code fixed 2006 Feb anonymous   2006 Mar anonymous 1 1 Database file not loading ...
1696 build fixed 2006 Feb anonymous Unknown 2006 Jun   4 4 obsolete "sort +4" and friends
1697 code fixed 2006 Mar drh CodeGen 2006 Mar drh 1 1 Segfault while executing SELECT
1700 code closed 2006 Mar anonymous Parser 2009 Dec   2 2 Handling column names for aliased queries is broken
1701 doc closed 2006 Mar anonymous   2009 Oct drh 3 1 3.3 build option not documented?
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
1705 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Default column constant doesn't assign value on NULL insert
1706 code closed 2006 Mar anonymous   2006 Mar   1 2 Group operations like ORDER BY don't work after renaming a table
1709 code fixed 2006 Mar anonymous   2006 Mar   1 1 sqlite3_column_name not apply column alias for views
1710 new closed 2006 Mar anonymous   2006 Aug   1 1 when order by, performance is low
1711 code fixed 2006 Mar anonymous   2006 Mar   1 2 Wrong header names when using subselects with 3.3.4 (3.3.1 is OK)
1712 code closed 2006 Mar anonymous   2006 Mar   1 1 aggregate function return empty row
1714 code closed 2006 Mar anonymous CodeGen 2009 Dec   4 4 Slow query when tables in 2 different files
1718 new closed 2006 Mar anonymous   2009 Oct   1 1 allow *.sqlite as parameter to sqlite3_analyzer
1721 code fixed 2006 Mar anonymous Parser 2006 Mar   3 3 wrong column names in a compound select when used as a subquery
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
1727 code fixed 2006 Mar drh   2006 Mar   1 1 Assertion fault on autovacuum :memory: database
1729 code closed 2006 Mar anonymous   2006 Mar   1 1 SQLite loses precision on 64-bit integers
1731 doc fixed 2006 Mar anonymous   2008 Jun   5 5 Typo in select4.test
1732 doc closed 2006 Mar anonymous   2008 Jun   5 5 Info on Home page
1733 code closed 2006 Mar anonymous VDBE 2009 Oct drh 4 3 Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
1734 code closed 2006 Mar anonymous Parser 2006 Mar drh 5 5 when not null is before integer primary key, syntax error occurs
1736 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 #define SQLITE_OMIT_ALTERTABLE causes unresolved externals
1737 code fixed 2006 Mar anonymous Unknown 2006 Mar   1 1 Duplicate name object created
1739 code closed 2006 Mar anonymous Unknown 2006 Mar   4 1 sqlite3_bind_int on UPDATE * SET COLUMN1='Test' WHERE ID=?
1741 warn closed 2006 Mar anonymous VDBE 2009 Oct   5 4 unused variable with SQLITE_OMIT_UTF16 defined
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
1744 doc fixed 2006 Mar anonymous Parser 2006 Apr drh 1 1 Missing documentation for SQLITE_ALTER_TABLE, SQLITE_REINDEX...
1745 doc fixed 2006 Mar anonymous Parser 2006 Apr drh 3 3 Missing "REVERSE" colation sequence
1746 code fixed 2006 Mar anonymous Parser 2006 Apr   2 1 large number of trigger actions in trigger creation give syntax error
1747 new closed 2006 Apr anonymous Unknown 2009 Oct   4 4 Non descriptive error message
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
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()
1766 new closed 2006 Apr anonymous Unknown 2006 Apr   3 2 Order by NO Case Sensitive
1771 code fixed 2006 Apr anonymous Shell 2006 Jun   5 4 sqlite3 -version should return 0
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
1793 code closed 2006 May anonymous   2006 May   2 3 sqlite3.dll crashes when doing an inner join with limit 0
1812 new closed 2006 May anonymous   2009 Oct   4 1 alter table add column default current_timestamp
1821 code fixed 2006 May anonymous   2006 May   2 3 Optimizer causes IN operator to fail when comparing strings & numbers
1853 code closed 2006 Jun anonymous   2009 Oct   3 4 sqlite3_analyzer-3.3.4 integer overflows on large database
1933 new closed 2006 Aug anonymous   2009 Oct   5 4 Add different date's separators
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.
2569 code closed 2007 Aug anonymous   2007 Aug   3 2 Executing a statement causes an AccessViolation Exception
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
2954 code closed 2008 Feb anonymous   2009 Oct drh 2 1 "database disk image is malformed" Error
2143 doc fixed 2007 Jan anonymous   2007 Jan   3 3 sqlite3_column_name may return NULL
1687 todo closed 2006 Feb dougcurrie   2006 Mar   3 3 tclsqlite.c crashes MinGW/MSYS gcc 3.4.5 on WIndows
1761 code closed 2006 Apr anonymous Unknown 2006 Apr   1 3 SQLite3_BindText fails with a floating point error
1765 code closed 2006 Apr anonymous   2006 Apr   1 2 SQLite3_BindText fails with a floating point error (explicited)
1726 code fixed 2006 Mar anonymous Unknown 2006 Apr drh 1 1 wrong reported datatype when using group-by
1752 code closed 2006 Apr anonymous Unknown 2006 Apr   3 4 New compile warnings with default ./configure && make on MinGW
1754 code closed 2006 Apr anonymous Pager 2009 Oct anonymous 2 2 Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
1755 code fixed 2006 Apr anonymous Unknown 2006 Apr drh 3 3 datatype incorrect when using group-by
1756 code fixed 2006 Apr anonymous   2006 Apr   1 1 Is use of function atof in file func.c really intended?
1758 code closed 2006 Apr anonymous Unknown 2006 Apr   3 1 problem with: select ... UNION ... select .. ORDER BY LOWER(column)
1762 build closed 2006 Apr anonymous Unknown 2009 Oct   3 4 sqlite3_clear_bindings not exported in windows dll
1763 code fixed 2006 Apr anonymous   2006 Apr   3 4 declaration after executable statement
1764 code closed 2006 Apr anonymous Unknown 2006 Apr   1 2 database file format not inter-operable between 32-bit/ 64-bit systems
1767 warn closed 2006 Apr anonymous Unknown 2006 Apr   5 4 Unused variable in function sqlite3VdbeChangeEncoding
1768 code fixed 2006 Apr anonymous   2006 Apr drh 1 1 ORDER BY behaving differently in SQLite2 and 3
1769 new closed 2006 Apr anonymous Unknown 2009 Oct drh 5 5 Is there any djgpp port for 3-3-5
1773 code fixed 2006 Apr anonymous   2006 Apr   2 3 heap corruption reading a corrupted database file
1776 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 1 2 Max(DateTime column) returns a String, not a DateTime
1777 code closed 2006 Apr anonymous   2009 Oct   2 4 Cygwin should be OS_UNIX target, not OS_WIN
1778 new closed 2006 Apr anonymous Parser 2009 Oct   1 3 stdev does not work, workaround not possible due to missing sqrt
1781 new closed 2006 Apr anonymous   2009 Oct   3 5 Interleaved sqlite_step behaves inconsistently
1783 code closed 2006 Apr anonymous Unknown 2009 Oct   3 2 insert times increase with growing table size (when indexed)
1784 code fixed 2006 Apr anonymous   2006 Apr   3 4 LIMIT 0 in sub-query with ORDER BY in outer query causes seg fault
1786 warn closed 2006 Apr anonymous   2009 Oct   4 4 Yet another list of compiler warnings.
1788 new closed 2006 Apr anonymous   2009 Oct   5 5 memory allocator able to return with several allocated bloks at once
1789 doc closed 2006 May anonymous Unknown 2008 Jun drh 4 4 sqlite3_result_error() not adequately documented
1790 code closed 2006 May anonymous Pager 2009 Oct   3 3 :memory: performance difference between v2 and v3
1794 code fixed 2006 May anonymous Parser 2006 May   3 2 Sqlite parser produces incorrect error message for missing commas
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
1797 code active 2006 May anonymous TclLib 2006 May drh 1 1 COPY command doesn't work in tclsqlite 3.3.5
1799 code closed 2006 May anonymous Pager 2009 Oct   2 3 temp_store=MEMORY slower than FILE for large intermediate result sets
1800 new closed 2006 May anonymous   2006 May linus 1 2 possible to have the lastest version of sqlite with PHP 5?????
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()
1804 code closed 2006 May anonymous Unknown 2009 Oct   4 3 Inconsistent value type returned by SUM when using a GROUP BY
1807 code fixed 2006 May drh   2006 May drh 1 1 Assertion fault on a particular query.
1808 code closed 2006 May anonymous   2006 May   1 1 Wrong index is chosen
1810 new closed 2006 May anonymous   2009 Oct   3 3 localtime() not threadsafe on UNIX
1813 new closed 2006 May anonymous   2007 Nov   2 3 select distinct doesn't take advantage of existing indexes
1814 new closed 2006 May anonymous   2009 Oct   3 4 Autoconf support for MacOSX univeral binaries
1815 code closed 2006 May anonymous Parser 2009 Oct   3 3 Support of W3C-DTF(ISO8601 subset) is incomplete
1816 code closed 2006 May anonymous VDBE 2009 Oct   1 2 Database corruption with pragma auto_vacuum
1817 new fixed 2006 May anonymous   2008 Aug   1 2 Patch to enable SQLite again on OS/2
1818 code closed 2006 May anonymous Unknown 2006 May drh 3 3 sqlite3_mprintf() misbehaving on %*. formats
1820 warn closed 2006 May anonymous TclLib 2009 Jan anonymous 5 1 make: *** [tclsqlite.lo] Error 1
1822 code closed 2006 May anonymous   2009 Dec   3 3 Table Alias together with Subquery seems not to work proper
1824 code fixed 2006 May drh   2006 May drh 1 1 UTF-16 encoding flag not honored when using shared cache
1825 code fixed 2006 May anonymous   2006 May   1 1 Crash on ATTACH DATABASE
1827 new fixed 2006 May anonymous TclLib 2006 May   4 4 Tcl-library: SQLITE_MISUSE from progress callback
1828 code closed 2006 Jun anonymous   2006 Jun   1 3 if not exists doesn't work with a qt program I'm designing.
1830 code fixed 2006 Jun anonymous Unknown 2006 Jun   2 1 Problem with INNER JOIN following LEFT JOIN to table with UNIQUE INDEX
1831 code fixed 2006 Jun anonymous Unknown 2006 Jun anonymous 2 1 Crash when using a certain type of index
1833 doc closed 2006 Jun anonymous Unknown 2009 Oct drh 4 3 PRAGMA legacy_file_format not documented
1836 new fixed 2006 Jun pweilbacher Shell 2006 Jun   4 3 Further OS/2 updates
1842 code closed 2006 Jun anonymous Unknown 2006 Jun anonymous 1 1 The field data saved in the table is corrupt
1845 code fixed 2006 Jun anonymous Unknown 2006 Jun   3 3 soundex(null) causes access violation
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
1852 code closed 2006 Jun anonymous   2006 Jun   4 5 AUTOINC NOT NULL problem
1861 code closed 2006 Jun anonymous Pager 2009 Oct   1 1 Problem in using Triggers and multithreading
1881 code closed 2006 Jul anonymous Parser 2006 Jul anonymous 2 1 error in inserting strings with single quotes
1890 doc closed 2006 Jul anonymous Unknown 2009 Oct mihailim 3 4 double quotes ("") in a query are ambiguous
1895 doc closed 2006 Jul anonymous   2008 Jun anonymous 4 3 IS operator not documented
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
1936 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 Altering schema seems to invalidate existing database connections
1948 code closed 2006 Aug anonymous Shell 2009 Oct   2 3 Double quotes are not escaped in csv mode
2079 code closed 2006 Nov anonymous   2006 Nov   1 1 strftime doesn't work in where statement
2173 code fixed 2007 Jan anonymous   2007 Mar   4 4 Incorrect return value test for calls to fcntl()
2278 code fixed 2007 Mar anonymous   2007 May   1 1 sqlite does not support mixed endian between pxa27x and i386 platforms
2339 code fixed 2007 May anonymous   2007 May   1 1 strange behavior for UNION
2420 code closed 2007 Jun anonymous   2007 Jun   5 5 sqlite3_prepare() don't work in php pdo implementation
2641 code closed 2007 Sep anonymous   2007 Sep   2 3 sqlite - Ticket #2638 continued as it was arbitrarily closed unsolved
3464 code closed 2008 Oct anonymous   2008 Oct   2 5 BOOLEAN type accepts all kinds of values, weird!!!
1809 code active 2006 May anonymous CodeGen 2009 Jan   1 3 Huge slowdown/increased memory use when using GROUP BY on big dataset
2482 code closed 2007 Jul anonymous   2007 Jul   3 4 Possible optimizer bug
1835 code closed 2006 Jun anonymous Unknown 2006 Jun   1 2 Memory leak on sqlite3_step with Select with no result row
1837 new closed 2006 Jun anonymous Pager 2009 Oct   4 4 Deadlock detection would be best reported using explicit error code.
1838 code closed 2006 Jun anonymous   2009 Oct   5 5 test types3-1.3 fails on 64-bit Linux
1839 build fixed 2006 Jun anonymous   2006 Jun   1 4 attempting to compile loadext.c fails
1840 code closed 2006 Jun anonymous Unknown 2006 Jun   4 4 sqlite3_get_table returns null pointer for aggregate queries
1846 code closed 2006 Jun anonymous   2006 Jun   1 1 Memory leak after returning error message
1847 new fixed 2006 Jun anonymous   2006 Jun   4 4 Unhelpful error text
1849 code fixed 2006 Jun anonymous VDBE 2006 Jun   1 3 EXPLAIN segfault on linux (3.3.6 and 3.3.5 and 3.3.2)
1856 code closed 2006 Jun anonymous   2009 Oct   2 3 SQLITE_OMIT_UTF16 breaks 'make test'
1857 code tested 2006 Jun anonymous   2009 Oct   3 4 Can't use ISO 8601 dates with time zone designator 'Z'
1858 doc closed 2006 Jun anonymous   2008 Jun   5 5 Typo: Pearl -> Perl
1862 code closed 2006 Jun anonymous TclLib 2009 Oct tclguy 1 1 SQLite cannot load/import data from file
1865 code closed 2006 Jun anonymous   2006 Jun   1 2 Encoding problem using order by
1867 code closed 2006 Jun anonymous BTree 2009 Oct   1 3 Access Violation after set a new page_size
1868 code closed 2006 Jun anonymous Shell 2006 Jun   4 4 where a = b = c
1871 event closed 2006 Jun anonymous   2009 Oct   2 3 VACUUM should not change 3.x file format
1873 code fixed 2006 Jun drh   2006 Jun   1 1 DETACH while query is running results in crash
1874 new closed 2006 Jun anonymous CodeGen 2009 Oct   2 3 IN is much slower than making separate queries
1875 code fixed 2006 Jun anonymous   2006 Jun   1 3 EXPLAIN crashes in strlen
1876 event closed 2006 Jun anonymous Unknown 2006 Jun   4 4 Creating table disrupts previously prepared statement
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
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
1885 code closed 2006 Jul anonymous Shell 2009 Oct   2 3 sqlite3 .mode insert and .dump do not list column names for selects
1891 code closed 2006 Jul anonymous Shell 2006 Jul pweilbacher 4 4 OS/2 may not have access to C:\ drive
1893 code closed 2006 Jul anonymous   2009 Oct   3 3 sqlite doesn't use indexes containing primary key in prim. key selects
1897 new fixed 2006 Jul anonymous Unknown 2009 Oct   1 3 Should be able to call sqlite3_interrupt from a different thread
1898 doc closed 2006 Jul anonymous   2009 Oct   5 4 sqlite3_progress_handler still marked experimental in documentation
1899 new fixed 2006 Jul anonymous   2006 Sep drh 5 4 Is it possible add IF NOT EXISTS Create View and Create Trigger
1900 code closed 2006 Jul anonymous Unknown 2009 Aug a.rottmann 1 1 CURRENT_TIMESTAMP keyword not inserting UTC date in column
1902 new closed 2006 Jul anonymous Parser 2009 Oct   5 3 allow alternate INSERT syntax using SET foo=bar
1903 code closed 2006 Aug anonymous   2006 Aug   2 2 LIKE string search sometimes fails
1904 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 error using drop table "if exists" in exec
1908 code closed 2006 Aug anonymous Unknown 2006 Aug anonymous 2 4 ORDER BY clause does not allow quoting
1909 code closed 2006 Aug anonymous VDBE 2006 Aug anonymous 3 3 cannot use sqlite3_prepare() when DB is in "BEGIN EXCLUSIVE" mode
1923 doc fixed 2006 Aug anonymous   2006 Aug   4 4 INSERT syntax documentation bug
1926 new fixed 2006 Aug anonymous Shell 2006 Aug   3 4 sqlite3.exe cannot find home dir on Windows
1927 doc fixed 2006 Aug anonymous Shell 2006 Aug   4 4 [doc] sqlite3.exe allows "/" as cmd terminator, not "\"
1940 code closed 2006 Aug anonymous   2006 Aug   3 3 insert default values
1946 code closed 2006 Aug anonymous Unknown 2009 Oct   2 2 .read file fails on blob fields with end-of-file char
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
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
1974 code closed 2006 Sep anonymous Unknown 2009 Oct   1 1 column type not consistent in views
1999 code closed 2006 Sep anonymous Unknown 2006 Sep   3 3 Memmory leak and wrong passed argument to calback function
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
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
2042 code closed 2006 Oct anonymous   2006 Oct   2 3 Subquery does not return the expected NULL
2086 code closed 2006 Nov anonymous   2009 Dec   5 4 Alias in update
2483 code closed 2007 Jul anonymous   2007 Jul   1 3 like clause not working
2842 code closed 2007 Dec anonymous   2008 Jun   1 1 .import does not recongnise NULL values
3099 code fixed 2008 May anonymous   2008 Jun   5 3 Enhancement
3400 event closed 2008 Sep anonymous   2009 Oct   1 4 Core error line ***glibc detected free() *** invalid next size (fast)
3417 secure closed 2008 Oct anonymous   2008 Oct   1 1 bug
3484 code closed 2008 Nov anonymous   2008 Nov   3 3 Column affinity not always correctly applied to integers
3638 code closed 2009 Feb anonymous   2009 Feb   1 1 sqlite command line gets stuck if \q is entered, ctl-c ignored
3639 new active 2009 Feb anonymous vfs 2009 Feb   3 1 Syntax error doesn't report a line number
2387 code closed 2007 May anonymous   2007 May   1 1 query: problem with update anagrafica SET nome='nome' where id = '4';
1848 code fixed 2006 Jun anonymous Parser 2006 Jun drh 1 1 C++ ism on generated parse.c from latest CVS head
1911 code fixed 2006 Aug anonymous   2006 Aug   2 3 crash if too many order by expressions
1912 code fixed 2006 Aug anonymous Parser 2006 Aug   4 4 letters following numeric digits parsing error
2674 code closed 2007 Sep anonymous   2009 Oct   3 4 NFS fails without lock manager
1445 code closed 2005 Sep anonymous   2009 Oct   3 3 Errors testing sqlite 3.2.6 (& v3.3.7)
1913 build fixed 2006 Aug anonymous Unknown 2006 Aug   4 3 Extension exports should be added to sqlite3.def in Windows source
1914 code fixed 2006 Aug anonymous   2006 Aug   4 4 btree2.test - invalid command name "btree_cursor_info"
1915 code fixed 2006 Aug anonymous   2006 Aug   4 4 vtab2.test: ./testfixture: can't read "tcl_pkgPath": no such variable
1916 code fixed 2006 Aug anonymous Unknown 2006 Aug drh 4 2 #include <sqlite3.h> in sqlite3ext.h should be #include "sqlite3.h"
1917 code fixed 2006 Aug anonymous VDBE 2006 Aug   3 3 assertion "rc==SQLITE_OK" failed: file "./src/vdbeaux.c", line 1148
1918 event fixed 2006 Aug anonymous VDBE 2006 Aug   4 4 "make test" results in many new false regressions with default build
1919 code fixed 2006 Aug anonymous Unknown 2006 Aug   3 3 PRAGMA table_info meaningless for cols with DEFAULT CURRENT_TIMESTAMP
1920 code fixed 2006 Aug anonymous VDBE 2006 Aug   4 4 vdbe.c: assert( i>=0 && i<=p->nCursor );
1921 code closed 2006 Aug anonymous   2006 Aug   4 4 misc1-10.1 failure on cygwin aborts make test
1922 code closed 2006 Aug anonymous Parser 2006 Aug   1 1 field name with space can not be specified as primary key
1924 new closed 2006 Aug anonymous Parser 2009 Dec   2 3 optimize queries on unions, constant folding
1925 code fixed 2006 Aug anonymous Unknown 2006 Aug   3 4 soundex() function not compatible with Knuth (and PHP/Java/TCL impl.)
1928 new closed 2006 Aug anonymous Parser 2009 Oct   2 2 NULL rowid in views and subqueries
1929 warn closed 2006 Aug anonymous   2007 Sep   4 3 3.3.7 sqlite3_index_info incompatible with C++
1930 code closed 2006 Aug anonymous Unknown 2006 Aug adamd 1 1 the select command can't support NOT_FOUND.
1934 doc closed 2006 Aug anonymous   2009 Oct   5 5 Documentation about default file format
1935 event closed 2006 Aug anonymous Parser 2009 Oct   4 4 GROUP BY and ORDER BY constant expressions valid?
1938 build closed 2006 Aug anonymous   2009 Oct   4 5 Cygwin compilation of v3 fails
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
1943 event tested 2006 Aug anonymous Unknown 2006 Aug   3 2 sqlite3_malloc() not exported from sqlite3.dll
1944 new closed 2006 Aug anonymous Unknown 2006 Aug   4 4 no UTF16 counterpart to sqlite3_exec()
1947 code closed 2006 Aug anonymous Shell 2009 Oct   3 3 ".mode insert" works bad with BLOBs
1950 new closed 2006 Aug anonymous   2006 Sep   4 4 AUTOINCREMENT too picky about type
1951 build fixed 2006 Sep dougcurrie   2006 Sep   3 2 symbols missing from sqlite3.def
1952 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 Memory leak in select with duplicate colum names
1953 code closed 2006 Sep anonymous TclLib 2009 Oct   4 3 Fix for false 64-bit comparisons "make test" failures on Cygwin
1956 code closed 2006 Sep anonymous   2009 Jan   1 1 ALTER TABLE ADD COLUMN does not support asian language column names.
1960 code closed 2006 Sep anonymous   2009 Oct   4 2 Issues with .import in sqlite.exe
1961 build closed 2006 Sep anonymous   2009 Oct   3 3 3.3.7 : wrong readline.h path in Makefile
1964 code fixed 2006 Sep anonymous Unknown 2006 Sep anonymous 3 3 datetime function broken
1965 code closed 2006 Sep anonymous   2006 Sep   3 3 sqlite returns wrong error code
1966 build closed 2006 Sep anonymous Unknown 2007 Feb   3 4 Add a --disable-readline option to configure
1968 code closed 2006 Sep anonymous Unknown 2006 Sep   1 2 sqlite3_column_type() returns 1 instead of 0 since 3.3.7
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
1973 code closed 2006 Sep anonymous Parser 2006 Nov   1 2 sqlite3_prepare (DLL 3.3.7) exception in two programs
1976 code fixed 2006 Sep anonymous   2006 Sep   4 3 wrong call to set error in vacuum.c
1979 doc fixed 2006 Sep anonymous   2006 Sep   4 4 Problem with full text search
1983 code closed 2006 Sep anonymous   2009 Oct   2 2 I/O Error at a size of 4GB and auto_vacuum=1
1984 code closed 2006 Sep anonymous   2006 Sep   1 1 sqlite3_exec problem
1985 doc closed 2006 Sep anonymous   2006 Sep   1 4 how get table names
1986 doc fixed 2006 Sep anonymous   2006 Sep   5 4 typo in documentation
1987 code fixed 2006 Sep drh   2006 Sep drh 1 1 Malformed database results from changing encoding
1988 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 linker error wih SQLITE_OMIT_VIRTUALTABLE
1990 code closed 2006 Sep anonymous   2009 Sep   1 1 sqlite3_close doesn't release always the file handle
1991 code fixed 2006 Sep anonymous Unknown 2006 Sep drh 3 3 strftime precision problem
1994 code closed 2006 Sep anonymous Parser 2009 Dec   1 3 Columns from nested joins aren't properly propagated
1995 code closed 2006 Sep anonymous   2006 Oct   2 1 SHARED lock does not kick in (DEFERRED does not work ?)
1998 build closed 2006 Sep anonymous   2009 Jun   2 3 prefix option to configure ignored in tclinstaller.tcl
2002 code fixed 2006 Sep anonymous Parser 2006 Sep drh 2 2 Memory leak in select with duplicate colum 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
2008 code fixed 2006 Oct anonymous   2006 Oct   3 3 Linux x86_64 sqlite3utfSelfTest fails assert -O2 gcc 4.1.1 (patch)
2009 code fixed 2006 Oct anonymous   2006 Oct   4 3 sqlite3 shell won't issue prompts without isatty() true
2010 code closed 2006 Oct anonymous   2009 Oct   3 3 Timeout ignored in Shared-Cache locking model
2011 code closed 2006 Oct anonymous   2009 Oct   3 2 Escaping Porblem with .mode insert (double apostrophe)
2038 code fixed 2006 Oct anonymous   2006 Oct   3 3 CREATE TRIGGER IF NOT EXISTS fails
2077 code closed 2006 Nov anonymous   2009 Dec   2 1 Problems with using ASCII symbols 0x80 - 0xFF in database path
2085 code closed 2006 Nov anonymous   2006 Nov   5 4 Round statement with different behavior between 3.2.8 and 3.3.7
2087 new closed 2006 Nov anonymous   2009 Dec   3 3 Ability to add a check constraint via the alter table command
2096 code closed 2006 Dec anonymous   2009 Oct   3 3 ATTACH DATABASE returns SQLITE_ERROR when database is locked
2126 code closed 2006 Dec anonymous   2009 Dec   3 1 Update hook not invoked when deleteing all rows from table
2317 code closed 2007 Apr anonymous   2007 Apr   4 4 Floats rendered to strings differently in WHERE and GROUP BY clauses.
2745 code closed 2007 Oct anonymous   2007 Oct shazow 1 1 Sharing File between two processes
3026 code closed 2008 Apr anonymous   2008 Jun   3 1 "drop table if exists" fails
3106 code closed 2008 May anonymous   2008 May   1 1 DB Files kept locked if a failure in loading a page happens
2248 code fixed 2007 Feb anonymous   2007 Feb   2 1 error evaluating IN statement
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
1955 code fixed 2006 Sep anonymous   2006 Sep   3 2 [3381] breaks MinGW ./configure && make sqlite3.dll
1958 code closed 2006 Sep anonymous   2009 Oct   4 4 some printf tests fail with Tcl 8.5a5, ok with Tcl 8.4
2023 build fixed 2006 Oct anonymous   2006 Dec   3 3 sqlite (loadext.c) fails build in _UNICODE mode from v3.3.7
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
2015 code closed 2006 Oct anonymous   2009 Oct anonymous 5 4 Enhancement Req: "EXPRn" PRAGMA for result set expression column names
2016 code fixed 2006 Oct anonymous   2006 Oct   1 1 Unremoved debug code in fts1_porter.c
2017 code closed 2006 Oct anonymous   2009 Oct   1 1 DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
2018 code fixed 2006 Oct drh   2006 Oct drh 1 1 Name resolution problem in correlated compound subqueries.
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
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
2027 code closed 2006 Oct anonymous   2009 Oct   1 1 FTS: Phrase searches return Offsets for individual phrase words
2029 code fixed 2006 Oct anonymous   2006 Oct   2 1 SECURITY: SQLite character encoding conversions are insecure
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)
2037 code closed 2006 Oct anonymous   2009 Oct   1 1 Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
2041 code closed 2006 Oct anonymous   2009 Jan   4 4 sqlite3.pc on Solaris needs -lrt in "Libs:" entry
2044 code fixed 2006 Oct anonymous   2006 Oct   1 1 .dump does not dump create view or create index statements as before
2046 code closed 2006 Oct anonymous   2009 Oct shess 1 1 FTS1 - Error closing database due to unfinished statements
2047 code fixed 2006 Oct anonymous   2006 Oct   1 1 Mozilla Patch: Correct Unicode database names in Win95...
2048 code closed 2006 Oct anonymous   2009 Oct drh 1 1 table_info on columns with no default value are returned as string
2053 code closed 2006 Nov anonymous   2006 Nov   1 1 problem on solaris 10
2056 code fixed 2006 Nov anonymous   2006 Nov   2 2 unable to ".quit' or '.exit' SQLite cmdline tool
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"
2063 code closed 2006 Nov anonymous   2009 Oct   4 4 vtab_err.test fails if sqlite is compiled without -DSQLITE_MEMDEBUG
2068 code closed 2006 Nov anonymous   2009 Jan   4 4 pkgIndex.tcl contains incomplete version number
2069 code fixed 2006 Nov anonymous   2007 Jan   4 3 compilation problem with SQLITE_OMIT_SHARED_CACHE
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
2075 code closed 2006 Nov anonymous   2009 Dec   3 3 Improve VACUUM speed and INDEX page locality
2076 code closed 2006 Nov anonymous   2009 Oct a.rottmann 1 1 % exists as value in varchar
2078 code fixed 2006 Nov anonymous   2006 Nov   2 1 Patch to make PRAGMA backward compatible with 3.3.7 and prior versions
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