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