bgcolor # Type Status Created By Subsys Changed Assigned Svr Pri Title #f2dcdc 2917 code active 2008 Feb anonymous 2008 Feb 4 4 Tcl interface - busy callback confusion script/procedure #f2dcdc 2916 code active 2008 Feb anonymous 2008 Feb 1 1 sqlitedll-3_5_5.zip is older 3.5.4 binary #e8e8bd 2228 new active 2007 Feb anonymous 2008 Feb 3 4 horizontal partitioning #e8e8bd 2915 build active 2008 Feb pweilbacher 2008 Feb 4 3 fix Makefile for platforms that need .exe extension #f2dcdc 2914 code active 2008 Jan anonymous 2008 Jan 3 3 ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY #f2dcdc 2905 code active 2008 Jan anonymous 2008 Jan pweilbacher 2 2 mutex_os2.c - incorrect mutex implementation #f2dcdc 2902 code active 2008 Jan anonymous 2008 Jan drh 3 3 Add watch support to SQLite #e8e8bd 2912 new active 2008 Jan anonymous 2008 Jan 5 4 merge join #f2dcdc 2903 code active 2008 Jan anonymous 2008 Jan 2 2 tclinstaller.tcl fails on path and permissions issue #f2dcdc 2911 code active 2008 Jan anonymous 2008 Jan 2 2 Adding parentheses to a FROM clause #e8e8bd 2909 build active 2008 Jan aswift 2008 Jan aswift 4 4 Omit the _XOPEN_SOURCE 500 define on Mac OS-X (check for __APPLE__) #f2dcdc 2613 code active 2007 Sep anonymous 2008 Jan drh 3 3 replace doesn't work with blobs containing \x0, otherwise it does #f2dcdc 2907 code active 2008 Jan anonymous 2008 Jan 1 1 Issues of sqlite3 with Windows Mobile 5/6 #f2dcdc 2908 code active 2008 Jan anonymous 2008 Jan 3 3 Add support to examine whether statements modify the database #f2dcdc 2898 code active 2008 Jan anonymous 2008 Jan 1 1 Latest CVS for 3.5.4 fails to build test1.c #f2dcdc 2901 code active 2008 Jan anonymous 2008 Jan 3 3 ROLLBACK and COMMIT statements should not expire #e8e8bd 2506 new active 2007 Jul anonymous 2008 Jan 3 2 New API to retrieve ROWID from SQLite3_stmt structire #f2dcdc 2899 code active 2008 Jan anonymous 2008 Jan 4 4 sqlite3_reset() after exec() takes > 100 ms to complete #f2dcdc 2885 code active 2008 Jan anonymous 2008 Jan 4 4 (minor) fulltest failures #f2dcdc 2878 code active 2008 Jan anonymous 2008 Jan 1 1 Memory leaks with latest CVS [4693] #f2dcdc 2897 code active 2008 Jan anonymous 2008 Jan 1 1 String or BLOB exceed size limit #e8e8bd 2892 new active 2008 Jan anonymous 2008 Jan 5 5 There should be a way in the api to read more precise error message. #f2dcdc 2893 code active 2008 Jan anonymous 2008 Jan 1 1 incorrect integer range tests #f2dcdc 2886 code active 2008 Jan anonymous 2008 Jan 3 3 testfixture: -fPIC needed when building extension(s) #f2dcdc 2882 code active 2008 Jan anonymous 2008 Jan 3 3 fulltest failure: ./testfixture: wrong # args: should be "cksum db" #e8e8bd 2884 new active 2008 Jan anonymous 2008 Jan 4 4 Way to find out limits #e8e8bd 489 new active 2003 Nov anonymous 2008 Jan 4 4 DLL exports suggestion #e8e8bd 2881 build active 2008 Jan anonymous 2008 Jan 1 1 Latest sqlite-3.5.4 build fail on latest Fedora 2.6.23.12-52.fc7 #e8e8bd 2847 new active 2007 Dec anonymous 2008 Jan 5 4 Include major, minor, and patch version numbers in sqlite.h #f2dcdc 2879 code active 2008 Jan anonymous 2008 Jan anonymous 4 3 VACUUM enters temporary sequence numbers in sqlite_sequence #e8e8bd 2336 warn active 2007 May anonymous 2008 Jan 4 4 Compiler warnings on strcpy(), sprintf(), et al. #f2dcdc 2875 code active 2008 Jan anonymous 2008 Jan 3 2 LIKE does not work with lowercase swedish characters #e8e8bd 2853 new active 2007 Dec anonymous 2008 Jan 2 3 optimizer fails to use an index on MAX subquery #f2dcdc 2874 code active 2008 Jan anonymous 2008 Jan 1 1 THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c #f2dcdc 2873 code active 2008 Jan anonymous 2008 Jan 1 1 HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make #f2dcdc 2872 code active 2008 Jan anonymous 2008 Jan 4 4 Some table scan operations could use an index for better data density #e8e8bd 2869 new active 2008 Jan anonymous 2008 Jan 5 5 add "sqlite3_open16_v2" to the C API #f2dcdc 2867 code active 2008 Jan anonymous 2008 Jan 2 2 doesn't build on Cygwin - wrong sqlite3 exe suffix #e8e8bd 2866 build active 2008 Jan anonymous 2008 Jan 1 3 Problems building Windows native in cygwin/mingw environment #e8e8bd 2864 doc active 2007 Dec anonymous 2007 Dec 5 3 ext/fts3/README.txt #f2dcdc 2865 code active 2007 Dec anonymous 2007 Dec 1 2 FTS3 does not build with amalgamation in CVS #f2dcdc 2863 code active 2007 Dec anonymous 2007 Dec 2 3 test cast-3.14, cast-3.18 and cast-3.24 fail #e8e8bd 2860 todo active 2007 Dec anonymous 2007 Dec 3 1 Database file fragmentation #f2dcdc 2859 code active 2007 Dec anonymous 2007 Dec drh 3 2 Inconsistent column names with DISTINCT #f2dcdc 2761 code active 2007 Nov anonymous 2007 Dec 3 3 CLI (shell.c) should be bundled with amalgamation #f2dcdc 2857 code active 2007 Dec anonymous 2007 Dec 2 2 GROUP BY cost estimate wrong with WHERE clause #e8e8bd 2856 doc active 2007 Dec anonymous 2007 Dec anonymous 4 3 SQLite Documentation - Tcl API - Link broken #e8e8bd 1648 new active 2006 Jan anonymous Shell 2007 Dec 4 3 meaningful error message: constraint failed #f2dcdc 2508 code active 2007 Jul anonymous 2007 Dec 1 1 utf8ToUnicode() does not work on some WinCE devices #e8e8bd 558 build active 2004 Jan anonymous 2007 Dec 4 4 Makefile.in should honor libdir and bindir #f2dcdc 368 code active 2003 Jun anonymous 2007 Dec 3 4 UPDATE trigger doesn't fire on INSERT OR REPLACE #e8e8bd 916 new active 2004 Sep anonymous Unknown 2007 Dec 1 1 No delete notification for INSERT OR REPLACE #e8e8bd 2844 build active 2007 Dec anonymous 2007 Dec 4 1 lemon is being built without respecting LDFLAGS #f2dcdc 2842 code active 2007 Dec anonymous 2007 Dec 1 1 .import does not recongnise NULL values #e8e8bd 2841 todo active 2007 Dec anonymous 2007 Dec 1 1 The sqlite mailing list has become overrun by trolls #f2dcdc 2721 code active 2007 Oct anonymous 2007 Dec 2 1 if db file is in a folder with non-ansi character some functions fail #e8e8bd 2831 new active 2007 Dec anonymous 2007 Dec 3 4 alter view #f2dcdc 2825 code active 2007 Dec anonymous 2007 Dec 3 3 FormatMessage (win32) should use extra flag and convert from Unicode #e8e8bd 2821 new active 2007 Dec anonymous 2007 Dec 3 4 hashtable indicies #f2dcdc 2814 code active 2007 Nov anonymous 2007 Dec 3 3 _XOPEN_SOURCE again #e8e8bd 2813 build active 2007 Nov anonymous 2007 Nov 1 1 compile error on Windows CE #f2dcdc 2809 code active 2007 Nov anonymous 2007 Nov 1 1 PRAGMA collation_list shows unregistered collations #f2dcdc 2810 code active 2007 Nov anonymous 2007 Nov 1 1 Unregistered collation problems with simple subselects #e8e8bd 2808 doc active 2007 Nov anonymous 2007 Nov 4 2 Documentation GIF images take up too much space #f2dcdc 2223 code active 2007 Feb scouten 2007 Nov 3 3 pragma auto_vacuum doesn't survive .dump & reconstitute #f2dcdc 2793 code active 2007 Nov anonymous 2007 Nov 3 3 fts3 lacks scoping #e8e8bd 285 build active 2003 Apr anonymous Unknown 2007 Nov 2 2 Configure doesn't honour LDFLAGS during build #f2dcdc 2791 code active 2007 Nov anonymous 2007 Nov 1 1 Allow building FTS[123] as part of sqlite library with configure #e8e8bd 2787 build active 2007 Nov anonymous 2007 Nov 4 5 sqlite3.pc is not remade #f2dcdc 2770 code active 2007 Nov anonymous 2007 Nov 1 1 Problem with BLOB in 3.5.x ? #e8e8bd 2776 warn active 2007 Nov anonymous 2007 Nov 5 1 mailing list #f2dcdc 2771 code active 2007 Nov anonymous 2007 Nov 4 4 Lemon: Generated parser needs stdlib.h (not in default template) #f2dcdc 2766 code active 2007 Nov drh 2007 Nov 1 1 TCL transaction started from within a query does not commit #e8e8bd 2417 new active 2007 Jun anonymous 2007 Nov drh 3 3 Idea for read write concurrency. #e8e8bd 2763 build active 2007 Nov anonymous 2007 Nov 4 4 AIX build failure due to explicit _XOPEN_SOURCE definition #e8e8bd 2760 new active 2007 Nov anonymous 2007 Nov 5 4 request: sqlite3_unlink() to delete db files. #e8e8bd 2756 new active 2007 Nov anonymous 2007 Nov 1 1 allow vacuum to change pragma setting instead of using existing ones #f2dcdc 2755 code active 2007 Nov anonymous 2007 Nov 3 3 trace interfere with transaction Tcl interface #f2dcdc 2753 code active 2007 Nov anonymous 2007 Nov drh 3 3 Master journal files sometimes not deleted #e8e8bd 2716 new active 2007 Oct anonymous 2007 Oct 5 1 Create Clear Command #e8e8bd 2749 warn active 2007 Oct anonymous 2007 Oct 3 4 SQLITE_OMIT_FLOATING_POINT, int constants too large #e8e8bd 2748 warn active 2007 Oct anonymous 2007 Oct 4 4 amalgamation: SQLITE_OMIT_ALTERTABLE warnings #f2dcdc 2392 code active 2007 May anonymous 2007 Oct 4 4 Reduce MemPage and PgHdr struct sizes. Better page memory utilization. #f2dcdc 2728 code active 2007 Oct anonymous 2007 Oct 4 4 Some indexes could contain pointers not the data #e8e8bd 2736 build active 2007 Oct anonymous 2007 Oct 2 2 build problems on freebsd #f2dcdc 2715 code active 2007 Oct anonymous 2007 Oct 1 1 no authorization needed to remove authorizer #f2dcdc 2714 code active 2007 Oct anonymous 2007 Oct drh 3 4 Shell cannot import large files greater than 2 GB [patch] #e8e8bd 2729 doc active 2007 Oct anonymous 2007 Oct 1 1 Lemon: %fallback, %wildcard, and @X uncodumented #f2dcdc 2725 code active 2007 Oct anonymous 2007 Oct 1 1 memory leak in sqlite3_open_v2() when it fails #e8e8bd 2701 new active 2007 Oct anonymous 2007 Oct 5 5 Make INSERT-ing multiple rows MySQL-compatible #e8e8bd 2727 build active 2007 Oct anonymous 2007 Oct 4 4 building with -malign-double causes strange behavior #f2dcdc 2708 code active 2007 Oct anonymous 2007 Oct 4 2 SQL error:disk I/O error #f2dcdc 2705 code active 2007 Oct anonymous 2007 Oct 4 4 testfixture unresolved externals with SQLITE_OMIT_GET_TABLE #f2dcdc 2704 code active 2007 Oct anonymous 2007 Oct 4 4 "make test" aborts before completion with SQLITE_OMIT_BLOB_LITERAL #f2dcdc 2703 code active 2007 Oct anonymous 2007 Oct 3 4 make test does not work with SQLITE_OMIT_FLOATING_POINT #f2dcdc 2684 code active 2007 Oct anonymous 2007 Oct 1 1 Accessing sqlite from an NT service will lock the complete databse. #e8e8bd 55 new active 2002 Jun anonymous 2007 Oct drh 5 3 instead of triggers for inserts (updates) on regular tablesxx #f2dcdc 2674 code active 2007 Sep anonymous 2007 Sep 3 4 NFS fails without lock manager #e8e8bd 2677 new active 2007 Sep anonymous 2007 Sep danielk1977 5 3 CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events #f2dcdc 2671 code active 2007 Sep shess 2007 Sep shess 2 4 Fts field-based queries are not correctly case-insensitive. #f2dcdc 2664 code active 2007 Sep danielk1977 2007 Sep 1 1 attaching the same db twice in shared-cache mode fails #f2dcdc 2294 code active 2007 Apr anonymous 2007 Sep 2 1 segfault when destroying lock on WinCE with threads #f2dcdc 2652 code active 2007 Sep drh 2007 Sep 1 1 Aggregate function cannot be used from within a subquery #f2dcdc 2539 code active 2007 Jul anonymous 2007 Sep 2 2 WinCE: Temporary etilqs_ files are not removed from temporary folder #f2dcdc 2653 code active 2007 Sep anonymous 2007 Sep 3 4 Exclusive Transactions do not work with a Database File attached twice #e8e8bd 2651 new active 2007 Sep anonymous 2007 Sep 5 4 Add support for overriding home directory location #e8e8bd 2649 new active 2007 Sep anonymous 2007 Sep 4 4 Add an "--enable-extensions" (default=no) to the configure script #e8e8bd 2645 build active 2007 Sep anonymous 2007 Sep 5 4 Conflict between tclConfig.sh and tclinstaller.tcl #f2dcdc 2627 code active 2007 Sep anonymous 2007 Sep 3 2 Improper parsing of nested JOIN #f2dcdc 2634 code active 2007 Sep anonymous 2007 Sep 3 3 .schema uses incorrect ORDER BY giving wrong dependency order #e8e8bd 2629 doc active 2007 Sep anonymous 2007 Sep 4 4 typo in os_unix.c for nolock #e8e8bd 2607 event active 2007 Aug anonymous 2007 Sep 2 1 Data loss, continuation to Re: [sqlite] how to flush database to disk? #e8e8bd 2604 new active 2007 Aug anonymous 2007 Aug 4 4 CREATE VIRTUAL TABLE does not allow IF NOT EXISTS #e8e8bd 2595 doc active 2007 Aug anonymous 2007 Aug 4 4 sqlite3_commit_hook doc typo #f2dcdc 2559 code active 2007 Aug anonymous 2007 Aug 4 4 "make clean" does not delete sqlite3.c and tsrc/ #e8e8bd 2587 build active 2007 Aug anonymous 2007 Aug 3 4 Build problem when using the SQLITE_OMIT_FLOATING_POINT define. #e8e8bd 2568 new active 2007 Aug anonymous 2007 Aug 3 3 TEMP_STORE is ignored in some cases #f2dcdc 1242 code active 2005 May anonymous Shell 2007 Aug 3 4 EXPLAIN causes segmentation fault on OSX (and linux) #e8e8bd 2582 doc active 2007 Aug anonymous 2007 Aug anonymous 5 5 documenation clarification #f2dcdc 2580 code active 2007 Aug anonymous 2007 Aug anonymous 1 2 Can't open a query if text to search is Greek #e8e8bd 2567 build active 2007 Aug anonymous 2007 Aug 3 2 Build fails to install #e8e8bd 2566 build active 2007 Aug anonymous 2007 Aug 2 1 fts2 broken after vacuum #f2dcdc 2558 code active 2007 Aug anonymous 2007 Aug 2 3 Multiple JOIN USING() gives incorrect results #e8e8bd 2555 new active 2007 Aug anonymous 2007 Aug 1 1 FTS index without original text #f2dcdc 2547 code active 2007 Aug danielk1977 2007 Aug 5 3 Changing db encoding of an attached db can confuse shared cache mode. #e8e8bd 2488 new active 2007 Jul anonymous 2007 Jul 5 4 autosize on column output mode in sqlite3 program #f2dcdc 2545 code active 2007 Jul anonymous 2007 Jul 1 4 Group by returns table name with field name #f2dcdc 2543 code active 2007 Jul anonymous 2007 Jul 1 1 Chinese charset not support?? #f2dcdc 2540 code active 2007 Jul anonymous 2007 Jul 5 4 Display dlopen() errors for errors when loading modules on Unix system #f2dcdc 2530 code active 2007 Jul anonymous 2007 Jul 2 3 Unable to write to windows share, even with exclusive lock #e8e8bd 2469 build active 2007 Jun anonymous 2007 Jul 1 1 test fails on Solaris #e8e8bd 2520 new active 2007 Jul anonymous 2007 Jul 4 1 User defined aggregate functions are not reentrant #f2dcdc 2517 code active 2007 Jul anonymous 2007 Jul dflam 1 1 exception on reading text in vista but not xp #f2dcdc 2510 code active 2007 Jul anonymous 2007 Jul 1 1 Vacuum modified FTS2 rowids #f2dcdc 2503 code active 2007 Jul anonymous 2007 Jul 3 4 sqlite3PagerReleaseMemory does not decrement page count #f2dcdc 2512 code active 2007 Jul shess 2007 Jul 1 1 FTS virtual table name quoting problem #f2dcdc 2511 code active 2007 Jul anonymous 2007 Jul drh 3 2 Inconsistent Pragma output #f2dcdc 2509 code active 2007 Jul anonymous 2007 Jul 1 1 SQLITE_DATE #f2dcdc 2498 code active 2007 Jul anonymous 2007 Jul 3 2 sqlite memory org on linux #f2dcdc 2496 code active 2007 Jul anonymous 2007 Jul 5 4 "No such column" error should include table information #f2dcdc 2491 code active 2007 Jul anonymous 2007 Jul 1 1 Mingw Warnings w/ 3.4.0 Amalgamation #f2dcdc 2487 code active 2007 Jul anonymous 2007 Jul 1 1 SQLite database locked error on NFS mounted home dir #e8e8bd 2484 new active 2007 Jul anonymous 2007 Jul 5 4 Support for RETURNING #e8e8bd 2377 build active 2007 May pweilbacher 2007 Jul 4 3 Allow easy DLL build on OS/2 #f2dcdc 2459 code active 2007 Jun anonymous 2007 Jun 4 4 changes() not reporting correctly after "failed" multiline INSERT #f2dcdc 2479 code active 2007 Jun anonymous 2007 Jun 1 1 WinCE regression on some systems. Any db open fails. #e8e8bd 2474 new active 2007 Jun anonymous 2007 Jun 5 4 Multiple-record comma-delineated INSERT command #e8e8bd 2476 todo active 2007 Jun anonymous 2007 Jun 4 3 SQLite3 ignores ORDER BY clause when performing SELECT ... GROUP BY #e8e8bd 2473 warn active 2007 Jun anonymous 2007 Jun anonymous 3 2 sqlite memory org. on linux #f2dcdc 2467 code active 2007 Jun anonymous 2007 Jun 4 4 changes() not reporting correctly after DELETE FROM table #e8e8bd 2457 build active 2007 Jun anonymous 2007 Jun drh 1 2 Build fails with internal compiler error (Windows, MS VC++ 6.0) #e8e8bd 2456 new active 2007 Jun anonymous 2007 Jun 5 5 REQ: use index where applicable instead of full table scan #e8e8bd 2448 new active 2007 Jun anonymous 2007 Jun 4 3 SQLITE needs to identify public exported symbols #e8e8bd 2443 new active 2007 Jun anonymous 2007 Jun 3 3 sqlite should return different exit codes for different errors #e8e8bd 2442 doc active 2007 Jun anonymous 2007 Jun 1 4 mailing list link doesn't always exist in website header #f2dcdc 2440 code active 2007 Jun rse 2007 Jun 2 2 pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS #e8e8bd 2438 new active 2007 Jun rse 2007 Jun 3 3 More easily allow the building of SQLite with FTS1 and FTS2 #e8e8bd 2427 doc active 2007 Jun anonymous 2007 Jun 4 3 HTML Tidy warnings on new capi3ref.html #e8e8bd 2419 build active 2007 Jun anonymous 2007 Jun 1 2 'CP_UTF8' : undeclared identifier when trying to build the dll #f2dcdc 2414 code active 2007 Jun anonymous 2007 Jun 1 1 Unable t #f2dcdc 2409 code active 2007 Jun anonymous 2007 Jun drh 1 1 Database malformed with SQLite3.3.17 on WindowsXP #f2dcdc 2413 code active 2007 Jun anonymous 2007 Jun drh 1 1 1 bug and 2 suggestions in lemon #e8e8bd 2411 new active 2007 Jun anonymous 2007 Jun 5 3 fts2 RFE - Separate index and storage #f2dcdc 2408 code active 2007 Jun anonymous 2007 Jun 2 1 BLOBs not output correctly in .mode insert (shell.c - isnumber) #e8e8bd 2401 warn active 2007 Jun anonymous 2007 Jun 1 1 I can't send anything to the contrib page #f2dcdc 2398 code active 2007 Jun anonymous 2007 Jun 2 3 systemcalls should be restarted when they return EINTR #f2dcdc 2396 code active 2007 Jun anonymous 2007 Jun 1 3 -column output truncates characters from varchar field. #f2dcdc 154 code active 2002 Sep drh Pager 2007 Jun drh 3 3 Prohibit links on database files. #e8e8bd 2397 build active 2007 Jun anonymous 2007 Jun 2 4 make install failed on Cygwin #f2dcdc 2393 code active 2007 May anonymous 2007 May 4 4 pragma cache_size not accurate when set to less than 10 #f2dcdc 2388 code active 2007 May anonymous 2007 May 1 3 ORDER BY fails on compound select #f2dcdc 2383 code active 2007 May anonymous 2007 May 3 3 Inconsistent conversion of BLOB revisited #e8e8bd 2381 doc active 2007 May anonymous 2007 May 3 3 'VACUUM' aborts an active transaction. #f2dcdc 2363 code active 2007 May anonymous 2007 May 3 3 Couldn't build 3.3.17 on Cygwin/Vista #f2dcdc 2378 code active 2007 May anonymous 2007 May 2 2 Quoted fields come back corrupted, using GROUP BY #e8e8bd 1597 new active 2006 Jan anonymous Unknown 2007 May 1 3 wish: support DROP COLUMN #e8e8bd 1924 new active 2006 Aug anonymous Parser 2007 May 2 3 optimize queries on unions, constant folding #f2dcdc 2376 code active 2007 May anonymous 2007 May 3 3 -batch doesn't work soon enough #e8e8bd 2207 new active 2007 Jan anonymous 2007 May 3 4 "CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints #f2dcdc 2374 code active 2007 May anonymous 2007 May 5 5 "ALTER TABLE foo RENAME TO bar" will quote bar (ie. 'bar') #e8e8bd 2373 new active 2007 May anonymous 2007 May 4 4 "create table as explain " doesn't work #f2dcdc 2372 code active 2007 May anonymous 2007 May 4 4 sqlite3TestLockingStyle not used if SQLITE_FIXED_LOCKING_STYLE defined #f2dcdc 2371 code active 2007 May anonymous 2007 May 2 2 sqlite3_errcode() and sqlite3_errmsg() return unexpected results #f2dcdc 2350 code active 2007 May anonymous 2007 May 1 1 Temp files not deleted on WinCE #f2dcdc 2352 code active 2007 May anonymous 2007 May 5 3 timeout just 500 msec to soon #e8e8bd 2351 secure active 2007 May anonymous 2007 May 2 2 UTF-16 convertor accepts malformed UTF-8 sequence #e8e8bd 2342 doc active 2007 May anonymous 2007 May 1 1 Document that prepared incremental vacuum needs multiple sqlite3_step #f2dcdc 2340 code active 2007 May anonymous 2007 May 3 3 "./configure && make testfixture" link problem #e8e8bd 2333 new active 2007 May anonymous 2007 May 5 4 support memory mapped files #e8e8bd 2329 new active 2007 Apr anonymous 2007 Apr 5 4 add a feature to .dump : partial dumps #f2dcdc 2328 code active 2007 Apr anonymous 2007 Apr 1 1 Makefile sqlite3.c target breakage for C++ #e8e8bd 2327 new active 2007 Apr anonymous 2007 Apr anonymous 2 1 "DELETE" operation makes memory rise #f2dcdc 2322 code active 2007 Apr anonymous 2007 Apr 1 1 Windows error: datetime('2000-10-29 06:00:00','localtime') #e8e8bd 2326 doc active 2007 Apr anonymous 2007 Apr a.rottmann 5 2 miss one word 'list' #f2dcdc 2320 code active 2007 Apr anonymous 2007 Apr drh 1 1 sqlite3_open(sFN_with_umlaut) #f2dcdc 2282 code active 2007 Apr anonymous 2007 Apr 3 4 Update on view with no matching trigger does not raise error #e8e8bd 2313 build active 2007 Apr anonymous 2007 Apr 3 3 readline.h is not properly detected #f2dcdc 2303 code active 2007 Apr anonymous 2007 Apr 1 1 Encrypted databases: No page cache due to problem in pagerSharedLock #e8e8bd 2308 build active 2007 Apr anonymous 2007 Apr 4 3 make sqlite3.c recreates sqlite3.c even though nothing changed #f2dcdc 2310 code active 2007 Apr anonymous 2007 Apr anonymous 4 4 Problem installing on AIX 5.3, ML5 after successful compile with xlc #e8e8bd 2304 new active 2007 Apr anonymous 2007 Apr 1 1 resolve "databas is locked" problem under DEFERRED transaction #e8e8bd 2302 build active 2007 Apr anonymous 2007 Apr anonymous 4 4 sqlite3 does not honor configure --disable-threads anymore #e8e8bd 2299 build active 2007 Apr anonymous 2007 Apr 1 1 Cannot compile sqlite-3.3.15 on linux rhel #e8e8bd 2301 build active 2007 Apr anonymous 2007 Apr 1 1 Latest cvs 3.3.15 fails lock4-1.3 test #f2dcdc 2297 code active 2007 Apr anonymous 2007 Apr drh 3 3 uninitialized var (with patch) #e8e8bd 2256 new active 2007 Feb anonymous 2007 Apr drh 5 1 Add POSITION() function (SQL-92 standard) #f2dcdc 2288 code active 2007 Apr anonymous 2007 Apr 4 2 FTS does not support REPLACE #e8e8bd 2283 warn active 2007 Apr anonymous 2007 Apr 1 1 Compile warning by VCToolkit2003 #e8e8bd 2280 new active 2007 Mar anonymous 2007 Mar 4 3 Check constraint failure message should include field name #e8e8bd 930 new active 2004 Sep anonymous Unknown 2007 Mar drh 2 2 djgpp port for sqlite3 #e8e8bd 1802 build active 2006 May anonymous Unknown 2007 Mar 4 4 sqlite.pc needs -lrt on Solaris for fdatasync() #f2dcdc 2041 code active 2006 Oct anonymous 2007 Mar 4 4 sqlite3.pc on Solaris needs -lrt in "Libs:" entry #e8e8bd 2270 build active 2007 Mar anonymous 2007 Mar 3 4 Build on Solaris 8 does not include other libs in .so build #e8e8bd 2136 new active 2007 Jan anonymous 2007 Mar 1 3 sqlite locking does not handle afs; patch included #e8e8bd 2231 new active 2007 Feb anonymous 2007 Mar 4 4 shell should ignore leading whitespace for meta commands #f2dcdc 2241 code active 2007 Feb scouten 2007 Mar 3 3 pragma integrity_check no longer affects command-line tool's exit code #e8e8bd 2233 new active 2007 Feb anonymous 2007 Mar 4 3 extend xBestIndex in vtables to carry the values for each contraint #e8e8bd 2258 new active 2007 Feb anonymous 2007 Mar 4 3 Include field name in check constraint failure message #e8e8bd 1778 new active 2006 Apr anonymous Parser 2007 Mar 1 3 stdev does not work, workaround not possible due to missing sqrt #e8e8bd 2274 todo active 2007 Mar anonymous 2007 Mar drh 5 3 Sqlite segfaults consistently in FTS2 #e8e8bd 2133 build active 2006 Dec anonymous 2007 Mar 4 4 meta ticket for outstanding autoconf issues #e8e8bd 151 new active 2002 Sep anonymous 2007 Mar 5 5 Add 'configure' options for locating readline headers and library #e8e8bd 2266 new active 2007 Mar anonymous 2007 Mar anonymous 3 3 Add support for Row_Number() Over #e8e8bd 2254 new active 2007 Feb anonymous 2007 Feb 5 4 ATTACH support IF NOT ATTACHED statement #e8e8bd 2247 doc active 2007 Feb anonymous 2007 Feb 3 3 documentation of DEFUALT cluase in CREATE TABLE should be fixed #e8e8bd 2246 doc active 2007 Feb anonymous 2007 Feb 5 4 SQL docs for CREATE TABLE should include FOREIGN KEY syntax #f2dcdc 2075 code active 2006 Nov anonymous 2007 Feb 3 3 Improve VACUUM speed and INDEX page locality #e8e8bd 2238 new active 2007 Feb anonymous 2007 Feb 2 3 Streams as datbase #f2dcdc 2237 code active 2007 Feb anonymous 2007 Feb 4 4 Test suite regressions using Tcl 8.5 #e8e8bd 2235 new active 2007 Feb anonymous 2007 Feb 4 3 Missing xml support in FTS2 for the snippet function #f2dcdc 2060 code active 2006 Nov anonymous 2007 Feb 1 1 Table references enclosed in parenthesis become "invisible" #f2dcdc 2225 code active 2007 Feb scouten 2007 Feb 5 4 Request count of number of inserts and deletes from the free page list #e8e8bd 2224 new active 2007 Feb scouten 2007 Feb 4 4 Option to have one-bit "journal should exist" flag #f2dcdc 2226 code active 2007 Feb scouten 2007 Feb 5 4 Report on unused indices (and tables?) #e8e8bd 2222 build active 2007 Feb anonymous 2007 Feb 4 4 Type mismatch in fts2.c [5091] when compile as fastcall or stdcall #e8e8bd 2221 new active 2007 Feb anonymous 2007 Feb drh 3 4 Store blobs using inode-like lookup of pages rather than linked list #e8e8bd 2220 new active 2007 Feb anonymous 2007 Feb drh 2 4 fsck for database files #f2dcdc 2219 code active 2007 Feb shess 2007 Feb shess 2 2 Creating an fts table in an attached database works wrong. #f2dcdc 2218 code active 2007 Feb anonymous 2007 Feb 3 4 select columns from views with table prefix #f2dcdc 2215 code active 2007 Feb anonymous 2007 Feb 1 2 error messages in virtual table are not propagated #f2dcdc 2214 code active 2007 Feb anonymous 2007 Feb 5 4 lemon generates bad error messages for %destructor #e8e8bd 2204 new active 2007 Jan anonymous 2007 Feb 5 3 Stable, documented metadata interface #e8e8bd 1126 new active 2005 Feb anonymous Unknown 2007 Jan drh 2 3 sqlite 2.8.16 port to djgpp #f2dcdc 2203 code active 2007 Jan anonymous 2007 Jan 2 3 table_info pragma "default" column format changed? #e8e8bd 2206 new active 2007 Jan anonymous 2007 Jan 5 4 Support for foreign key constraints in virtual tables #e8e8bd 2205 build active 2007 Jan anonymous 2007 Jan anonymous 1 1 Problem while using with tcl on ARM #e8e8bd 2202 new active 2007 Jan anonymous 2007 Jan 5 4 function request: sqlite3_attach() #e8e8bd 2200 new active 2007 Jan anonymous 2007 Jan 5 4 threadsafe status not reported in .pc file #e8e8bd 2199 build active 2007 Jan anonymous 2007 Jan 1 1 configure doesn't find libreadline if its in uncommon place #e8e8bd 2198 new active 2007 Jan anonymous 2007 Jan 5 4 API: opening only existing databases #f2dcdc 2183 code active 2007 Jan anonymous 2007 Jan drh 1 1 OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT #e8e8bd 2188 doc active 2007 Jan anonymous 2007 Jan 5 4 Doc bug in src/vdbe.c, should s/P1/P2/ in NotFound #e8e8bd 2187 todo active 2007 Jan anonymous 2007 Jan 3 4 RAISE in trigger not being caught by CONFLICT clause in calling SQL #e8e8bd 2185 new active 2007 Jan anonymous 2007 Jan 5 3 API access to opened database pathname - helpful for virtual tables #f2dcdc 2182 code active 2007 Jan anonymous 2007 Jan 4 4 sqlite3BtreeGetMeta does not check the file format #e8e8bd 2181 new active 2007 Jan anonymous 2007 Jan 5 4 Generalize ON CONFLICT to failure trapping for all SQL statements #e8e8bd 2180 new active 2007 Jan anonymous 2007 Jan 5 4 feature request: DROP TABLE IF [EXISTS AND] EMPTY #e8e8bd 2167 new active 2007 Jan anonymous 2007 Jan 1 3 add sqlite3_copy_bindings (parallel to sqlite3_transfer_bindings) #f2dcdc 2165 code active 2007 Jan anonymous 2007 Jan drh 4 3 pager performance and checksum #e8e8bd 1722 new active 2006 Mar anonymous Unknown 2007 Jan 4 2 agregate sum() of strings #e8e8bd 2148 doc active 2007 Jan anonymous 2007 Jan 5 5 3.3.9 changes.html addition #f2dcdc 2140 code active 2007 Jan anonymous 2007 Jan 3 1 sqlite doesn't link to readline #e8e8bd 931 new active 2004 Sep anonymous 2006 Dec 5 4 Makefile for mingw on Win32, makes DLL, EXE and docs #f2dcdc 2132 code active 2006 Dec anonymous 2006 Dec 3 4 table_info, index_list, index_info & friends should be virtual tables #f2dcdc 2131 code active 2006 Dec anonymous 2006 Dec 2 3 Add substring() function (Part of SQL 99) #f2dcdc 2130 code active 2006 Dec anonymous 2006 Dec 4 4 replace "long long int" type with "sqlite_int64" defined in sqlite3.h #f2dcdc 2125 code new 2006 Dec anonymous 2006 Dec 4 4 SQLite strings/blobs limited to 1GB/2GB due to 'int' in api #f2dcdc 2128 code active 2006 Dec anonymous 2006 Dec 4 3 virtual table code doesn't verify type of rowid (calling xUpdate) #f2dcdc 2127 code active 2006 Dec anonymous 2006 Dec 2 3 Virtual tables do not always free zErrmsg #f2dcdc 2126 code active 2006 Dec anonymous 2006 Dec 3 1 Update hook not invoked when deleteing all rows from table #e8e8bd 2120 new active 2006 Dec anonymous 2006 Dec 5 4 Date Column support #f2dcdc 2112 code active 2006 Dec anonymous 2006 Dec 5 4 code compatibility with C++ #e8e8bd 2110 build active 2006 Dec anonymous 2006 Dec 4 3 Non-optional linking with readline makes sqlite3 binary GPL #f2dcdc 1946 code new 2006 Aug anonymous Unknown 2006 Dec 2 2 .read file fails on blob fields with end-of-file char #e8e8bd 2106 doc active 2006 Dec anonymous 2006 Dec 4 4 FtsOne wiki page neglects to mention Porter stemming #e8e8bd 2105 new active 2006 Dec anonymous 2006 Dec 5 5 sqlite3_exec does not return modified rows #e8e8bd 2104 build active 2006 Dec anonymous 2006 Dec 2 3 manual link on Mac OS X fails due to common symbol #f2dcdc 2100 code active 2006 Dec anonymous 2006 Dec 1 1 Fixes for SQL lower() and upper() #e8e8bd 2099 doc active 2006 Dec anonymous 2006 Dec 3 3 virtual table xDestroy/xDisconnect and cleanups #e8e8bd 2098 warn active 2006 Dec anonymous 2006 Dec 1 1 php sqlite problem after commit transaction #f2dcdc 2096 code active 2006 Dec anonymous 2006 Dec 3 3 ATTACH DATABASE returns SQLITE_ERROR when database is locked #e8e8bd 2095 doc active 2006 Dec anonymous 2006 Dec 1 3 xFindFunction documentation incomplete #f2dcdc 2093 code active 2006 Dec anonymous 2006 Dec 2 3 sqlite3_vtab_cursor doesn't have errMsg #e8e8bd 2090 build active 2006 Nov anonymous 2006 Nov 4 3 Test corrupt2.test fails: Solaris #e8e8bd 2087 new active 2006 Nov anonymous 2006 Nov 3 3 Ability to add a check constraint via the alter table command #f2dcdc 2046 code active 2006 Oct anonymous 2006 Nov shess 1 1 FTS1 - Error closing database due to unfinished statements #f2dcdc 2089 code active 2006 Nov anonymous 2006 Nov 3 3 Decouple sqlite_int64 from other 64bit datatypes #f2dcdc 2086 code active 2006 Nov anonymous 2006 Nov 5 4 Alias in update #f2dcdc 2084 code active 2006 Nov anonymous 2006 Nov 4 3 Add API function mapping column decl string to SQLite type #f2dcdc 2083 code active 2006 Nov anonymous 2006 Nov 4 4 Give more detailed extension loading error information with dlerror #f2dcdc 2082 code active 2006 Nov anonymous 2006 Nov 3 4 UNIX: configure script doesn't enable loading of extensions #f2dcdc 2081 code active 2006 Nov anonymous 2006 Nov doughenry 1 1 sqlite3_column_decltype throws exception, if selection is grouped #f2dcdc 2080 code active 2006 Nov anonymous 2006 Nov 4 4 Tranfering large BLOB data not efficient #f2dcdc 2077 code active 2006 Nov anonymous 2006 Nov 2 1 Problems with using ASCII symbols 0x80 - 0xFF in database path #f2dcdc 2076 code active 2006 Nov anonymous 2006 Nov a.rottmann 1 1 % exists as value in varchar #f2dcdc 2074 code active 2006 Nov anonymous 2006 Nov 4 4 feature request: .dump with page_size #f2dcdc 2070 code active 2006 Nov anonymous 2006 Nov 4 4 No error for ambiguous result alias in WHERE clause #f2dcdc 2068 code active 2006 Nov anonymous 2006 Nov 4 4 pkgIndex.tcl contains incomplete version number #f2dcdc 2066 code active 2006 Nov anonymous 2006 Nov 2 2 Incorrect error message in the case of ENOLCK #f2dcdc 1992 code active 2006 Sep anonymous 2006 Nov shess 1 1 FTS1: Problems after dropping utility tables #f2dcdc 2063 code active 2006 Nov anonymous 2006 Nov 4 4 vtab_err.test fails if sqlite is compiled without -DSQLITE_MEMDEBUG #f2dcdc 2062 code active 2006 Nov anonymous 2006 Nov 4 4 document 'pk' column of PRAGMA table_info() #f2dcdc 2061 code active 2006 Nov anonymous 2006 Nov anonymous 5 5 cleanup for quickstart.html #f2dcdc 2059 code active 2006 Nov anonymous 2006 Nov 1 1 Still missing .DEF file from Windows 3.3.8 source code distribution #f2dcdc 2057 code active 2006 Nov anonymous 2006 Nov 3 1 full_column_names when 2 or more tables are joined is not working #f2dcdc 2051 code active 2006 Nov anonymous 2006 Nov 5 5 minor documentation bug #f2dcdc 2048 code active 2006 Oct anonymous 2006 Oct drh 1 1 table_info on columns with no default value are returned as string #f2dcdc 2043 code active 2006 Oct anonymous 2006 Oct 1 1 Spaces in view statement #e8e8bd 1820 warn active 2006 May anonymous TclLib 2006 Oct anonymous 5 1 make: *** [tclsqlite.lo] Error 1 #f2dcdc 2037 code active 2006 Oct anonymous 2006 Oct 1 1 Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP. #f2dcdc 2032 code active 2006 Oct anonymous 2006 Oct 1 1 AV in btree.c running FTS2 compiled with SQLITE_OMIT_SHARED_CACHE #f2dcdc 2028 code active 2006 Oct anonymous 2006 Oct 4 2 FTS1: UNIQUE() expression and UPDATE command not working #f2dcdc 2027 code active 2006 Oct anonymous 2006 Oct 1 1 FTS: Phrase searches return Offsets for individual phrase words #f2dcdc 2026 code active 2006 Oct anonymous 2006 Oct 4 5 \n in .output is not allowed even with quote #f2dcdc 2025 code active 2006 Oct anonymous 2006 Oct drh 5 5 Add pragama command to return loaded extension list #f2dcdc 2024 code active 2006 Oct anonymous 2006 Oct drh 5 5 Add If not exist syntax to Create Virtual Table #f2dcdc 2022 code active 2006 Oct anonymous 2006 Oct 1 1 .import command is not working #f2dcdc 2019 code active 2006 Oct anonymous 2006 Oct 1 1 FTS1: Create table in transaction raises Out of Sequence error (21) #f2dcdc 2017 code active 2006 Oct anonymous 2006 Oct 1 1 DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined #f2dcdc 2015 code active 2006 Oct anonymous 2006 Oct anonymous 5 4 Enhancement Req: "EXPRn" PRAGMA for result set expression column names #f2dcdc 2014 code active 2006 Oct anonymous 2006 Oct anonymous 4 3 Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE #f2dcdc 2013 code active 2006 Oct anonymous 2006 Oct drh 4 3 Autoincrement increments on failing INSERT OR IGNORE #f2dcdc 2012 code active 2006 Oct anonymous 2006 Oct 4 3 trigger4.test aborts "make test" on Windows #f2dcdc 2011 code active 2006 Oct anonymous 2006 Oct 3 2 Escaping Porblem with .mode insert (double apostrophe) #f2dcdc 2010 code active 2006 Oct anonymous 2006 Oct 3 3 Timeout ignored in Shared-Cache locking model #e8e8bd 2006 event active 2006 Sep anonymous 2006 Sep 1 1 Strange data in a table. #e8e8bd 2005 event active 2006 Sep anonymous 2006 Sep 1 1 Multiple rows with the same primary key, and null values in "not null" #e8e8bd 2004 warn active 2006 Sep anonymous 2006 Sep 1 4 vtab.c:142: warning: pointer targets in initialization differ in signe #f2dcdc 1822 code active 2006 May anonymous 2006 Sep 3 3 Table Alias together with Subquery seems not to work proper #e8e8bd 1998 build active 2006 Sep anonymous 2006 Sep 2 3 prefix option to configure ignored in tclinstaller.tcl #e8e8bd 1996 new active 2006 Sep anonymous Unknown 2006 Sep drh 2 3 Data type CHAR #f2dcdc 1994 code active 2006 Sep anonymous Parser 2006 Sep 1 3 Columns from nested joins aren't properly propagated #f2dcdc 1990 code active 2006 Sep anonymous 2006 Sep 1 1 sqlite3_close doesn't release always the file handle #f2dcdc 1983 code active 2006 Sep anonymous 2006 Sep 2 2 I/O Error at a size of 4GB and auto_vacuum=1 #f2dcdc 1980 code active 2006 Sep drh 2006 Sep 1 1 Initializing FTS1 twice causes it to fail. #e8e8bd 1975 new active 2006 Sep anonymous 2006 Sep 5 4 Request for sqlite3_table_column_metadata16 #f2dcdc 1972 code active 2006 Sep anonymous 2006 Sep 2 4 segfault on empty query #f2dcdc 1974 code active 2006 Sep anonymous Unknown 2006 Sep 1 1 column type not consistent in views #f2dcdc 1445 code active 2005 Sep anonymous 2006 Sep 3 3 Errors testing sqlite 3.2.6 (& v3.3.7) #e8e8bd 1961 build active 2006 Sep anonymous 2006 Sep 3 3 3.3.7 : wrong readline.h path in Makefile #f2dcdc 1960 code active 2006 Sep anonymous 2006 Sep 4 2 Issues with .import in sqlite.exe #e8e8bd 1959 new active 2006 Sep anonymous 2006 Sep 4 3 Unblockable TEMP TABLES #f2dcdc 1958 code active 2006 Sep anonymous 2006 Sep 4 4 some printf tests fail with Tcl 8.5a5, ok with Tcl 8.4 #f2dcdc 1953 code active 2006 Sep anonymous TclLib 2006 Sep 4 3 Fix for false 64-bit comparisons "make test" failures on Cygwin #f2dcdc 1954 code active 2006 Sep anonymous Unknown 2006 Sep 1 1 Dual Core Processor Lockup #e8e8bd 725 new active 2004 May anonymous 2006 Aug anonymous 5 5 Implement ATTACH LIB comand #f2dcdc 1948 code active 2006 Aug anonymous Shell 2006 Aug 2 3 Double quotes are not escaped in csv mode #f2dcdc 1947 code active 2006 Aug anonymous Shell 2006 Aug 3 3 ".mode insert" works bad with BLOBs #e8e8bd 1938 build active 2006 Aug anonymous 2006 Aug 4 5 Cygwin compilation of v3 fails #e8e8bd 1942 new active 2006 Aug anonymous 2006 Aug 4 4 select without left join with the *= operator #f2dcdc 518 code active 2003 Dec anonymous Unknown 2006 Aug 3 4 PRIMARY KEY does not imply UNIQUE and NOT NULL #f2dcdc 1941 code active 2006 Aug anonymous 2006 Aug 1 1 Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER #e8e8bd 1939 event active 2006 Aug anonymous Unknown 2006 Aug 2 1 SQLite hangs with WHERE condition in an SELECT with joined table #e8e8bd 1928 new active 2006 Aug anonymous Parser 2006 Aug 2 2 NULL rowid in views and subqueries #e8e8bd 1935 event active 2006 Aug anonymous Parser 2006 Aug 4 4 GROUP BY and ORDER BY constant expressions valid? #e8e8bd 1934 doc active 2006 Aug anonymous 2006 Aug 5 5 Documentation about default file format #e8e8bd 1933 new active 2006 Aug anonymous 2006 Aug 5 4 Add different date's separators #e8e8bd 1907 new active 2006 Aug anonymous 2006 Aug 4 4 date and time types #e8e8bd 1906 new active 2006 Aug anonymous Unknown 2006 Aug 1 2 date.c line 417 uses non-thread safe localtime() call #f2dcdc 1893 code active 2006 Jul anonymous 2006 Aug 3 3 sqlite doesn't use indexes containing primary key in prim. key selects #e8e8bd 1905 new active 2006 Aug anonymous VDBE 2006 Aug 5 4 Get bound param as sqlite3_value? #e8e8bd 1902 new active 2006 Jul anonymous Parser 2006 Jul 5 3 allow alternate INSERT syntax using SET foo=bar #f2dcdc 1901 code active 2006 Jul anonymous Unknown 2006 Jul adamd 2 2 problem in select request with a alias table #f2dcdc 1900 code active 2006 Jul anonymous Unknown 2006 Jul a.rottmann 1 1 CURRENT_TIMESTAMP keyword not inserting UTC date in column #e8e8bd 1898 doc active 2006 Jul anonymous 2006 Jul 5 4 sqlite3_progress_handler still marked experimental in documentation #e8e8bd 1896 new active 2006 Jul drh 2006 Jul 1 1 All extensions to be statically linked #e8e8bd 1895 doc active 2006 Jul anonymous 2006 Jul anonymous 4 3 IS operator not documented #f2dcdc 1890 code active 2006 Jul anonymous Unknown 2006 Jul 3 4 double quotes ("") in a query are ambiguous #f2dcdc 1885 code active 2006 Jul anonymous Shell 2006 Jul 2 3 sqlite3 .mode insert and .dump do not list column names for selects #f2dcdc 1884 code active 2006 Jul anonymous 2006 Jul 3 2 pragma table_info caches results from previous query #f2dcdc 1882 code active 2006 Jul anonymous 2006 Jul 1 1 Wrong algorithm of SQLITE_VERSION_NUMBER calculation #f2dcdc 1878 code active 2006 Jun anonymous CodeGen 2006 Jun 2 3 No index used when specifying alias name in ORDER BY clause #e8e8bd 1817 new active 2006 May anonymous 2006 Jun 1 2 Patch to enable SQLite again on OS/2 #e8e8bd 1874 new active 2006 Jun anonymous CodeGen 2006 Jun 2 3 IN is much slower than making separate queries #f2dcdc 1872 code active 2006 Jun anonymous 2006 Jun 4 3 sqlite3_open doesn't support RFC1738 format for filename #e8e8bd 1871 event active 2006 Jun anonymous 2006 Jun 2 3 VACUUM should not change 3.x file format #e8e8bd 1869 doc active 2006 Jun anonymous Unknown 2006 Jun anonymous 4 4 Website typo #f2dcdc 1867 code active 2006 Jun anonymous BTree 2006 Jun 1 3 Access Violation after set a new page_size #e8e8bd 1864 new active 2006 Jun anonymous 2006 Jun drh 3 3 List availabe SQL functions #f2dcdc 1862 code active 2006 Jun anonymous TclLib 2006 Jun tclguy 1 1 SQLite cannot load/import data from file #f2dcdc 1861 code active 2006 Jun anonymous Pager 2006 Jun 1 1 Problem in using Triggers and multithreading #e8e8bd 1860 doc active 2006 Jun anonymous Pager 2006 Jun danielk1977 1 1 Problem in using SQLite3 with trigger and multithreading #e8e8bd 1858 doc active 2006 Jun anonymous 2006 Jun 5 5 Typo: Pearl -> Perl #f2dcdc 1857 code active 2006 Jun anonymous 2006 Jun 3 4 Can't use ISO 8601 dates with time zone designator 'Z' #f2dcdc 1856 code active 2006 Jun anonymous 2006 Jun 2 3 SQLITE_OMIT_UTF16 breaks 'make test' #f2dcdc 1853 code active 2006 Jun anonymous 2006 Jun 3 4 sqlite3_analyzer-3.3.4 integer overflows on large database #f2dcdc 1851 code active 2006 Jun anonymous Unknown 2006 Jun 2 1 USE "ORDER BY" error on uClinux #f2dcdc 1850 code active 2006 Jun anonymous Unknown 2006 Jun 2 1 NUMERIC data type ERROE when read on uClinux #f2dcdc 1838 code active 2006 Jun anonymous 2006 Jun 5 5 test types3-1.3 fails on 64-bit Linux #e8e8bd 1837 new active 2006 Jun anonymous Pager 2006 Jun 4 4 Deadlock detection would be best reported using explicit error code. #e8e8bd 1833 doc active 2006 Jun anonymous Unknown 2006 Jun drh 4 3 PRAGMA legacy_file_format not documented #f2dcdc 1816 code active 2006 May anonymous VDBE 2006 May 1 2 Database corruption with pragma auto_vacuum #f2dcdc 1815 code active 2006 May anonymous Parser 2006 May 3 3 Support of W3C-DTF(ISO8601 subset) is incomplete #e8e8bd 1814 new active 2006 May anonymous 2006 May 3 4 Autoconf support for MacOSX univeral binaries #e8e8bd 1812 new active 2006 May anonymous 2006 May 4 1 alter table add column default current_timestamp #e8e8bd 1811 doc active 2006 May anonymous 2006 May 5 3 how many open cursors are allowed for one application? #f2dcdc 1797 code active 2006 May anonymous TclLib 2006 May drh 1 1 COPY command doesn't work in tclsqlite 3.3.5 #e8e8bd 1810 new active 2006 May anonymous 2006 May 3 3 localtime() not threadsafe on UNIX #f2dcdc 1809 code active 2006 May anonymous CodeGen 2006 May 1 3 Huge slowdown/increased memory use when using GROUP BY on big dataset #f2dcdc 1804 code active 2006 May anonymous Unknown 2006 May 4 3 Inconsistent value type returned by SUM when using a GROUP BY #e8e8bd 1801 new active 2006 May anonymous Pager 2006 May owensmk 5 4 Include Support for User-defined Lock Synchronization #f2dcdc 1799 code active 2006 May anonymous Pager 2006 May 2 3 temp_store=MEMORY slower than FILE for large intermediate result sets #f2dcdc 1790 code active 2006 May anonymous Pager 2006 May 3 3 :memory: performance difference between v2 and v3 #e8e8bd 1798 doc active 2006 May anonymous 2006 May 5 4 preprocessed is misspelled on download page #f2dcdc 1791 code active 2006 May anonymous Unknown 2006 May 1 1 Native threads support for BeOS #e8e8bd 1789 doc active 2006 May anonymous Unknown 2006 May drh 4 4 sqlite3_result_error() not adequately documented #e8e8bd 1788 new active 2006 Apr anonymous 2006 Apr 5 5 memory allocator able to return with several allocated bloks at once #e8e8bd 1786 warn active 2006 Apr anonymous 2006 Apr 4 4 Yet another list of compiler warnings. #e8e8bd 1785 new active 2006 Apr anonymous Shell 2006 Apr 4 3 rl_readline_name not set #f2dcdc 1783 code active 2006 Apr anonymous Unknown 2006 Apr 3 2 insert times increase with growing table size (when indexed) #f2dcdc 1633 code active 2006 Jan anonymous VDBE 2006 Apr 3 3 sqlite3_step returns SQLITE_ERROR when interrupted #f2dcdc 1782 code active 2006 Apr anonymous Unknown 2006 Apr 1 1 journal file exclusion #e8e8bd 1781 new active 2006 Apr anonymous 2006 Apr 3 5 Interleaved sqlite_step behaves inconsistently #f2dcdc 1777 code active 2006 Apr anonymous 2006 Apr 2 4 Cygwin should be OS_UNIX target, not OS_WIN #f2dcdc 1775 code active 2006 Apr anonymous Unknown 2006 Apr 1 1 strftime() not working in Windows Mobile 2005 #e8e8bd 1772 new active 2006 Apr anonymous TclLib 2006 Apr 5 5 db eval {QUERY} { do something } ELSE { there was no match } #e8e8bd 1770 new active 2006 Apr anonymous 2006 Apr 5 4 Request for expanded DELETE USING keyword like PostgreSQL #e8e8bd 1769 new active 2006 Apr anonymous Unknown 2006 Apr drh 5 5 Is there any djgpp port for 3-3-5 #e8e8bd 1762 build active 2006 Apr anonymous Unknown 2006 Apr 3 4 sqlite3_clear_bindings not exported in windows dll #f2dcdc 1754 code active 2006 Apr anonymous Pager 2006 Apr anonymous 2 2 Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined #e8e8bd 1747 new active 2006 Apr anonymous Unknown 2006 Apr 4 4 Non descriptive error message #f2dcdc 1743 code active 2006 Mar anonymous Parser 2006 Mar 3 3 A very very deep IN statement failure #f2dcdc 1742 code active 2006 Mar anonymous Unknown 2006 Mar drh 2 3 ORDER BY on more than one column causes a big slowdown #e8e8bd 1741 warn active 2006 Mar anonymous VDBE 2006 Mar 5 4 unused variable with SQLITE_OMIT_UTF16 defined #f2dcdc 1735 code active 2006 Mar anonymous Unknown 2006 Mar 1 3 Encoding problem #f2dcdc 1733 code active 2006 Mar anonymous VDBE 2006 Mar drh 4 3 Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned #e8e8bd 1732 doc active 2006 Mar anonymous 2006 Mar 5 5 Info on Home page #e8e8bd 1731 doc active 2006 Mar anonymous 2006 Mar 5 5 Typo in select4.test #f2dcdc 1700 code active 2006 Mar anonymous Parser 2006 Mar 2 2 Handling column names for aliased queries is broken #e8e8bd 1720 new active 2006 Mar anonymous 2006 Mar 3 4 Actions made by a trigger are not triggered #f2dcdc 1719 code active 2006 Mar anonymous 2006 Mar 4 4 Solaris 8(SQL: bus error while creating temporary file #e8e8bd 1718 new active 2006 Mar anonymous 2006 Mar 1 1 allow *.sqlite as parameter to sqlite3_analyzer #f2dcdc 1714 code active 2006 Mar anonymous CodeGen 2006 Mar 4 4 Slow query when tables in 2 different files #e8e8bd 1689 new active 2006 Feb anonymous 2006 Mar 2 4 triggers and temporary tables #e8e8bd 1655 new active 2006 Feb anonymous VDBE 2006 Mar 4 4 Every function can have their private data like agreagates #e8e8bd 1656 doc active 2006 Feb anonymous Parser 2006 Mar 5 4 lemon versions and changelog #e8e8bd 1693 new active 2006 Feb anonymous Parser 2006 Mar 4 4 Parser sensitive to position of word AUTOINCREMENT #e8e8bd 1704 new active 2006 Mar anonymous 2006 Mar 4 3 extern "C" block in sqliteInt.h #e8e8bd 1703 new active 2006 Mar anonymous Pager 2006 Mar 2 3 Second parameter to gettimeofday() in os_unix.c should be NULL #e8e8bd 1702 new active 2006 Mar anonymous 2006 Mar 5 4 feature request: API to write in-memory DB to file. #e8e8bd 1701 doc active 2006 Mar anonymous 2006 Mar drh 3 1 3.3 build option not documented? #e8e8bd 1698 build active 2006 Mar anonymous 2006 Mar 1 1 sqlite_4y6ngs9FlYvAMGO 0kb 3/1/2006 1:16 PM #e8e8bd 1683 new active 2006 Feb anonymous Unknown 2006 Feb anonymous 4 3 .mode html produces uppercase tags #e8e8bd 1679 new active 2006 Feb anonymous 2006 Feb 4 4 SQLite requires code modification to replace memory allocation funcs #e8e8bd 1675 new active 2006 Feb anonymous 2006 Feb 5 4 sqlite3_db_dup() ? #e8e8bd 1663 new active 2006 Feb anonymous Unknown 2006 Feb 4 4 Suggestion: DATETYPE field type using David Tribble's work? #e8e8bd 1653 new active 2006 Feb anonymous CodeGen 2006 Feb 4 5 SQLITE_OMIT_COST_REORDERING ? #e8e8bd 1647 doc active 2006 Jan anonymous Unknown 2006 Jan paul 3 1 i want to use this lib in my project #e8e8bd 867 new active 2004 Aug anonymous Parser 2006 Jan 3 2 update on multiple tables #e8e8bd 1638 warn active 2006 Jan anonymous 2006 Jan 3 2 rows place change and some row element missing #f2dcdc 1637 code active 2006 Jan anonymous Parser 2006 Jan 4 4 Multiple JOIN USING() doesn't work. #e8e8bd 1636 todo active 2006 Jan anonymous Shell 2006 Jan drh 4 3 stdev does not work #e8e8bd 1626 new active 2006 Jan anonymous Unknown 2006 Jan 4 4 ALTER TABLE BUG/MISHEAVIOR #e8e8bd 1635 doc active 2006 Jan anonymous 2006 Jan 4 4 SQLite Ticket "Version" field #e8e8bd 1627 warn active 2006 Jan anonymous 2006 Jan 4 4 warnings on BCB and how to resolve them + couple of minor fixes #f2dcdc 1622 code active 2006 Jan danielk1977 2006 Jan 1 1 Compiling with OMIT_PRAGMA causes an error in the test suite #f2dcdc 1621 code active 2006 Jan danielk1977 2006 Jan 5 5 Compiling with OMIT_FLOATING_POINT causes a segfault in the test suite #e8e8bd 1591 build active 2006 Jan anonymous 2006 Jan 3 2 Missing TEXE suffix in linking and install rules for sqlite3 #e8e8bd 1588 new active 2006 Jan anonymous 2006 Jan 4 4 common subexpression elimination not performed in SELECT #e8e8bd 1576 build active 2005 Dec anonymous 2005 Dec 4 4 PREFIX is not honored (cannot install as non-root) #e8e8bd 1577 build active 2005 Dec anonymous Unknown 2005 Dec drh 3 3 32bit compile on 64bit system fails to build sqlite3 #f2dcdc 1573 code active 2005 Dec anonymous Shell 2005 Dec 3 3 Bad CSV output when data contains double quotes #e8e8bd 974 new active 2004 Oct anonymous 2005 Dec 5 4 Version-Resource in pre-compiled windows dll #e8e8bd 1566 new active 2005 Dec ghaering VDBE 2005 Dec 5 4 Implement sqlite3_clone() #e8e8bd 1565 doc active 2005 Dec anonymous 2005 Dec 4 4 wrong return-type specified for sqlite3_db_handle in c-api-reference #e8e8bd 1564 build active 2005 Dec anonymous 2005 Dec 4 4 Need GNU awk #e8e8bd 1562 warn active 2005 Dec anonymous Unknown 2005 Dec 3 1 i64 not defined in 32bit compiler #e8e8bd 1558 new active 2005 Dec anonymous VDBE 2005 Dec 3 4 Request more debugging info when SQL statements in progress #e8e8bd 1555 doc active 2005 Dec anonymous BTree 2005 Dec appledev 2 4 sqlite+Crystal reports connection #e8e8bd 1552 new active 2005 Dec anonymous Unknown 2005 Dec 5 4 Adding .read FILE support to the C API #e8e8bd 1550 new active 2005 Dec anonymous Unknown 2005 Dec 3 3 Triggers across attached databases #e8e8bd 1549 build active 2005 Dec anonymous 2005 Dec 5 4 install fails for non-root user when TCL active #e8e8bd 1547 event active 2005 Nov anonymous Unknown 2005 Dec 1 1 slow insert into indexed table and slow index create on huge table #f2dcdc 1546 code active 2005 Nov anonymous 2005 Nov 1 1 Creating unique index on non-unique column leads to corr. on SQLite2 #e8e8bd 1543 build active 2005 Nov anonymous 2005 Nov 2 1 File encrypted or corrupted while using french characters #f2dcdc 1542 code active 2005 Nov anonymous Unknown 2005 Nov 2 4 wrong field names in views with quoted table name qualifiers #f2dcdc 1541 code active 2005 Nov anonymous Unknown 2005 Nov 1 1 Ticket #924 not fixed in the 2.8 branch #e8e8bd 1532 new active 2005 Nov anonymous TclLib 2005 Nov 4 4 Variables don't get replaced in ATTACH statements. #e8e8bd 1528 new active 2005 Nov anonymous Unknown 2005 Nov 5 4 Add Build Date To Command Line Greeting #e8e8bd 1525 event active 2005 Nov anonymous Unknown 2005 Nov anonymous 1 2 error creating database #f2dcdc 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 #f2dcdc 1521 code active 2005 Nov anonymous Unknown 2005 Nov 3 2 ORDER BY sorts incorrectly with aliased fields #f2dcdc 1519 code active 2005 Nov anonymous Unknown 2005 Nov 3 4 Size double with blob data on UPDATE ? #f2dcdc 1515 code active 2005 Nov anonymous Unknown 2005 Nov 4 3 Quotes incorrect included in colum names. #f2dcdc 1508 code active 2005 Nov anonymous BTree 2005 Nov 1 3 sqlite 2.8.16 crashes on 64-bit / strict memory alignment archs #e8e8bd 1506 new active 2005 Nov anonymous Shell 2005 Nov 1 4 Add some flags to .import command #f2dcdc 1504 code active 2005 Nov anonymous Pager 2005 Nov 1 3 Multithreaded DB lock not released using Begin/Commit between threads #e8e8bd 1503 doc active 2005 Oct anonymous 2005 Oct 5 4 typo in datatype3.html #f2dcdc 1494 code active 2005 Oct anonymous Unknown 2005 Oct 1 2 intermittent null reference exception in sqlite3_open #f2dcdc 1502 code active 2005 Oct anonymous Unknown 2005 Oct anonymous 2 3 When selected in a union, view column names are incorrect. #f2dcdc 1500 code active 2005 Oct anonymous Unknown 2005 Oct 4 4 MIssing file listing permission causes DB opening/creation to fail #e8e8bd 1498 build active 2005 Oct anonymous 2005 Oct 4 3 SQLite Cygwin support #f2dcdc 1493 code active 2005 Oct anonymous Parser 2005 Oct 3 3 lemon: pathsearch uses wrong directory separator under Win32 #e8e8bd 1491 new active 2005 Oct anonymous Shell 2005 Oct 4 4 syntax error with " .mode column: #f2dcdc 1489 code active 2005 Oct anonymous 2005 Oct 3 2 Bad permissions on install-sh prevent 'make install' from completing #f2dcdc 1488 code active 2005 Oct anonymous 2005 Oct 1 1 Collate Reverse does not exists? #f2dcdc 1487 code active 2005 Oct anonymous BTree 2005 Oct 1 3 Corrupt database causes indefinite loop in sqlite3_step() #f2dcdc 1485 code active 2005 Oct anonymous Unknown 2005 Oct jshen 3 1 cyrilic problem(suppose Unicode as a whole, for PPC) #f2dcdc 1484 code active 2005 Oct anonymous Unknown 2005 Oct 4 4 Solaris8 awk problem #e8e8bd 1483 doc active 2005 Oct anonymous Unknown 2005 Oct xdong 1 3 expression document:describe ERROR. #e8e8bd 1480 event active 2005 Oct anonymous Unknown 2005 Oct 1 3 Wrong SQL statement crashes PHP+Apache #e8e8bd 1476 new active 2005 Oct anonymous 2005 Oct 5 4 Patch for SQLite sequence manipulation functions #e8e8bd 1475 new active 2005 Oct anonymous Parser 2005 Oct anonymous 5 5 sytax error near autoincrement #e8e8bd 1469 event active 2005 Oct anonymous Parser 2005 Oct 1 1 Having problems with subselects that work on mySQL #e8e8bd 1468 new active 2005 Oct anonymous Parser 2005 Oct 5 5 Added Mysql function CONCAT #f2dcdc 1298 code active 2005 Jun anonymous Shell 2005 Oct drh 4 3 sqlite3.exe not recognizing newline as comment terminator #e8e8bd 1466 warn active 2005 Oct anonymous 2005 Oct 5 5 compile warnings #f2dcdc 1465 code active 2005 Oct anonymous CodeGen 2005 Oct 1 1 fdatasync not available and not yet fixed #e8e8bd 1464 new active 2005 Oct anonymous 2005 Oct 4 3 Improving PRAGMA table_info() #f2dcdc 1312 code active 2005 Jun anonymous Shell 2005 Sep 1 1 CSV file import / export is all wrong! #f2dcdc 1351 code active 2005 Aug anonymous Shell 2005 Sep 1 1 Unable to parse UTF8 input #f2dcdc 1397 code new 2005 Aug anonymous Shell 2005 Sep 1 1 .mode csv creates ASCII output instead of UTF-8 #f2dcdc 1461 code active 2005 Sep anonymous Unknown 2005 Sep drh 1 2 3.2.7 DLL can not deal File paths with international characters #f2dcdc 1458 code active 2005 Sep anonymous Shell 2005 Sep 2 2 Error at .importing in csv format (another) #f2dcdc 1457 code active 2005 Sep anonymous Shell 2005 Sep 3 1 non-latin chars not recognized by CLI #f2dcdc 1455 code active 2005 Sep anonymous Shell 2005 Sep 3 2 .import error: comma inside a string is read as field separator #e8e8bd 1454 doc active 2005 Sep anonymous 2005 Sep 4 4 Functions should all be documented in one place #f2dcdc 1451 code active 2005 Sep anonymous Shell 2005 Sep 4 3 .mode insert does not output BLOBs in an usable way #f2dcdc 1447 code active 2005 Sep anonymous BTree 2005 Sep 1 1 Abnormal program termination in src/btree.c line 1339 #f2dcdc 1441 code active 2005 Sep anonymous VDBE 2005 Sep 4 4 sqlite3_clear_bindings routine missing #e8e8bd 1431 doc active 2005 Sep anonymous 2005 Sep 1 1 Please can FAQ 7 reference http://www.sqlite.org/lockingv3.html #f2dcdc 1428 code active 2005 Sep anonymous TclLib 2005 Sep 3 3 tclinstaller.tcl script problems #e8e8bd 1427 build active 2005 Sep anonymous 2005 Sep 4 3 tclsqlite.lo target should define USE_TCL_STUBS #e8e8bd 229 new active 2003 Jan anonymous Parser 2005 Sep 5 4 DECLARE ... CURSOR FOR ... would be really nice #e8e8bd 1426 event active 2005 Sep anonymous Unknown 2005 Sep drh 2 2 Problem with DETACH in 2.8.16 #e8e8bd 1424 new active 2005 Sep anonymous Unknown 2005 Sep drh 5 3 Pivot table creation #e8e8bd 1423 new active 2005 Sep anonymous 2005 Sep drh 3 4 Binding NULL does not work as expected #e8e8bd 1417 new active 2005 Sep anonymous 2005 Sep drh 3 3 Fix successive access to a DB handler (unix broken thread file lock) #f2dcdc 1415 code active 2005 Sep anonymous Unknown 2005 Sep drh 1 1 Querying for BLOB type fields #e8e8bd 1400 new active 2005 Aug anonymous 2005 Sep 5 5 Use of indexes in queries to VIEWS built from UNION SELECTS #f2dcdc 1403 code active 2005 Sep anonymous Pager 2005 Sep 4 4 Newly initialized pages aren't completely cleared #f2dcdc 1401 code active 2005 Aug anonymous Shell 2005 Aug 4 4 concatenating html in select list #e8e8bd 1393 event active 2005 Aug anonymous Unknown 2005 Aug 4 3 failure in select2-2.0.3... test #f2dcdc 1382 code active 2005 Aug anonymous 2005 Aug drh 1 1 Assert nErr==0 on corrupt db #e8e8bd 1381 new active 2005 Aug anonymous Parser 2005 Aug 5 4 missing important builtin function stdev #e8e8bd 1379 warn active 2005 Aug anonymous Unknown 2005 Aug 1 1 cannot install . phpize failed #f2dcdc 1365 code active 2005 Aug anonymous 2005 Aug 3 3 64 bit types not completely overridable #e8e8bd 676 build active 2004 Mar anonymous 2005 Aug 1 1 Problem with Makefile #f2dcdc 1342 code active 2005 Jul anonymous 2005 Jul 1 1 sqlite 3.2.2 will not load on Suse Linux 9.3 #e8e8bd 1332 new active 2005 Jul anonymous Unknown 2005 Jul 5 5 update 20x slower when using a temp table #f2dcdc 1327 code active 2005 Jul ghaering VDBE 2005 Jul 2 3 UNION causes sqlite3_column_decltype to always return NULL #f2dcdc 1325 code active 2005 Jul anonymous Unknown 2005 Jul 1 4 sqlite3_bind_value not implemented #f2dcdc 1323 code active 2005 Jul anonymous 2005 Jul 1 1 misuse-4.4...gmake: *** [test] Segmentation Fault (core dumped) #e8e8bd 1319 new active 2005 Jul anonymous 2005 Jul 5 4 Extend sqlite3_expired to detect schema changes #e8e8bd 1318 build active 2005 Jul anonymous 2005 Jul 2 4 Build broken under Windows/MinGW #e8e8bd 1313 new active 2005 Jun anonymous 2005 Jun 4 4 Allow headers in imported text files #f2dcdc 1308 code active 2005 Jun anonymous 2005 Jun 3 4 PRAGMA TABLE_INFO does not recognize attached database syntax. #f2dcdc 1305 code active 2005 Jun anonymous TclLib 2005 Jun 1 1 Tcl installs pkgIndex with wrong path #e8e8bd 1302 event active 2005 Jun anonymous Unknown 2005 Jun 1 4 malloc error after dumping table #e8e8bd 1300 event active 2005 Jun anonymous Unknown 2005 Jun 2 2 Apache.exe has encountered a problem and needs to close. #e8e8bd 241 new active 2003 Feb anonymous 2005 Jun anonymous 5 5 lack of alter table statement #e8e8bd 1295 event active 2005 Jun anonymous Unknown 2005 Jun 1 1 SQL query involving subqueries causes reproduceable segfault in 2.8.14 #e8e8bd 1294 new active 2005 Jun anonymous 2005 Jun 3 3 API to get ordinal table name #e8e8bd 1293 build active 2005 Jun anonymous 2005 Jun 1 1 No file .LIB in sqlitedll-3_2_2.zip for links in Windows. #f2dcdc 1286 code active 2005 Jun anonymous 2005 Jun 4 4 The downloadable DLL file does not work with Intel VTune #f2dcdc 1111 code active 2005 Feb anonymous Unknown 2005 Jun 3 1 no such column error with a subselect as a table #f2dcdc 1278 code active 2005 Jun anonymous 2005 Jun 1 2 sqlite3_finalize doesn't clear previous error code or message #f2dcdc 1264 code active 2005 May anonymous Unknown 2005 May 3 3 access() undefined on MSVC #e8e8bd 1262 new active 2005 May anonymous VDBE 2005 May 5 3 5-15% performance increase for slow joins #f2dcdc 1255 code active 2005 May anonymous 2005 May 4 3 Decrease number of warnings with Microsoft Visual C++ #e8e8bd 1254 new active 2005 May anonymous Pager 2005 May 3 3 better pager_cksum #e8e8bd 1250 new active 2005 May anonymous Pager 2005 May 1 3 FlushFileBuffers makes Windows sqlite dead slow compared to Linux #e8e8bd 1249 new active 2005 May anonymous Unknown 2005 May 5 4 transaction #f2dcdc 1248 code active 2005 May anonymous Unknown 2005 May 3 1 sqlite3_get_table returns garbage for BLOB data #e8e8bd 1246 warn active 2005 May anonymous 2005 May 4 3 Many warnings from gcc4 #e8e8bd 1240 new active 2005 May anonymous Pager 2005 May drh 1 3 Need integration of Apple's file locking callbacks improvement #f2dcdc 1241 code active 2005 May anonymous 2005 May 4 5 sqlite3_create_collation16 - should have 'const void* zName' arg #f2dcdc 1235 code active 2005 May anonymous Unknown 2005 May drh 4 3 inconsistent pragma handling #e8e8bd 972 warn active 2004 Oct anonymous 2005 May 3 3 building SQLite on Irix #f2dcdc 1228 code active 2005 Apr anonymous Unknown 2005 Apr 4 3 problem with select+union on a view with aliased columns #e8e8bd 1227 new active 2005 Apr anonymous Shell 2005 Apr 5 2 Small patch for timing commands in shell.c #f2dcdc 1223 code active 2005 Apr anonymous 2005 Apr 3 4 .read FILENAME fails #f2dcdc 1222 code active 2005 Apr anonymous Unknown 2005 Apr 2 4 spec file errors #e8e8bd 1221 new active 2005 Apr anonymous 2005 Apr 5 4 Implementation of PRAGMA trigger_info(table) #e8e8bd 1220 new active 2005 Apr anonymous 2005 Apr 4 3 Selectable calling convention #f2dcdc 1214 code active 2005 Apr anonymous Unknown 2005 Apr 2 3 sqlite3_column_bytes returns 0 on p3 column with EXPLAINed selects #f2dcdc 1213 code active 2005 Apr anonymous Parser 2005 Apr 3 2 Problem with alias columns in subqueries #e8e8bd 1209 doc active 2005 Apr anonymous Unknown 2005 Apr anonymous 3 5 SQLite3_Free_Table returns not #SQLITE_OK if suceeds #e8e8bd 1208 new active 2005 Apr anonymous Unknown 2005 Apr 4 4 no version info provided in precompiled sqlite3.dll #f2dcdc 1205 code active 2005 Apr anonymous Unknown 2005 Apr 3 1 accent ecu etc. in connectionstring #f2dcdc 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) #e8e8bd 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) #e8e8bd 1204 new active 2005 Apr anonymous TclLib 2005 Apr drh 4 2 (visible) version provided by tclsqlite package #e8e8bd 1203 todo active 2005 Apr anonymous 2005 Apr 4 5 Web site problem, download links #f2dcdc 1201 code active 2005 Apr anonymous CodeGen 2005 Apr danielk1977 1 1 erro defined type UINT8_TYPE #f2dcdc 1200 code active 2005 Apr anonymous 2005 Apr 2 3 new versions of SQLite return different (incorrect) results. #e8e8bd 1199 doc active 2005 Apr anonymous 2005 Apr 4 3 Update the README file #e8e8bd 1190 new active 2005 Mar anonymous Unknown 2005 Mar drh 4 4 strftime() does not Support Years with 3 or 5 digits #f2dcdc 1191 code active 2005 Mar anonymous Unknown 2005 Mar 2 3 last_insert_id() Does Not Work after Insert on View #e8e8bd 1189 new active 2005 Mar anonymous Parser 2005 Mar 1 1 Make where-clause item count limit dynamic #e8e8bd 1187 build active 2005 Mar anonymous Parser 2005 Mar drh 3 3 OMIT_TRIGGER OMIT_VIEW do not compile properly #e8e8bd 1186 new active 2005 Mar anonymous Shell 2005 Mar 4 4 Pragma page_size doesn't set the pagesize immediately #e8e8bd 1184 todo active 2005 Mar danielk1977 CodeGen 2005 Mar 4 3 UTF-8 and UTF-16 substr() functions are subtly different #e8e8bd 1176 new active 2005 Mar anonymous Unknown 2005 Mar 4 3 Blocking Writes #f2dcdc 1177 code active 2005 Mar anonymous Shell 2005 Mar 1 4 (Win32) .import inserts extra carrier character in every row #e8e8bd 1162 new active 2005 Mar anonymous 2005 Mar drh 1 2 Column names in sqlite views differ from oracle/informix column names #f2dcdc 1158 code active 2005 Mar anonymous VDBE 2005 Mar 1 1 core dump on solaris, #f2dcdc 1149 code active 2005 Feb anonymous 2005 Feb 2 1 VACUUM, DUMP/RESTORE fail in certain cases #f2dcdc 1142 code active 2005 Feb anonymous Parser 2005 Feb danielk1977 1 1 Column names #e8e8bd 1138 build active 2005 Feb anonymous 2005 Feb 4 3 make install fails on MinGW/MSYS trying to install into tclsh #f2dcdc 1134 code active 2005 Feb anonymous 2005 Feb drh 3 3 select command with a view and a condition gets no result #e8e8bd 1128 event active 2005 Feb anonymous Shell 2005 Feb 2 3 sqlite3-3.1.2.bin segfaults #e8e8bd 1123 build active 2005 Feb anonymous TclLib 2005 Feb 3 4 cannot find tcl.h #f2dcdc 1112 code active 2005 Feb anonymous 2005 Feb 3 4 make test failures (108 out of 19721) on AIX 5.2, Power5 CPU #f2dcdc 1100 code active 2005 Feb anonymous 2005 Feb 3 3 make test segfaults at capi2-7.12 on amd64 system #f2dcdc 1085 code active 2005 Jan anonymous 2005 Jan 2 3 pragma full_column_names and short_column_names still broken #e8e8bd 1031 new active 2004 Dec anonymous 2005 Jan 3 4 sqlite command line does not allow intermixing of dot commands and sql #f2dcdc 1078 code active 2005 Jan anonymous 2005 Jan 2 3 Lemon destructor bugs that don't affect sqlite #f2dcdc 709 code active 2004 Apr anonymous Unknown 2005 Jan drh 1 1 Unable to unregister or replace functions #e8e8bd 1070 build active 2005 Jan anonymous CodeGen 2005 Jan 1 1 error by compiling windows vcc / vc# not found #f2dcdc 1063 code active 2005 Jan anonymous 2005 Jan 1 3 Lemon bug: Strings in rule code should not be interpreted #e8e8bd 1061 new active 2005 Jan anonymous Shell 2005 Jan 4 4 shell.c .import from stdin #e8e8bd 1059 doc active 2005 Jan anonymous Unknown 2005 Jan 5 4 Full support for IEEE 754 floating points #f2dcdc 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 #f2dcdc 1058 code active 2005 Jan anonymous BTree 2005 Jan 3 3 btree.c pageSize -> usableSize #f2dcdc 1056 code active 2004 Dec anonymous Shell 2004 Dec 3 3 test pragma-9.4 fails during second pass in "make fulltest" #f2dcdc 1053 code active 2004 Dec anonymous Pager 2004 Dec 3 3 SQLITE_IOERR and strange rollback when db is busy #e8e8bd 1043 doc active 2004 Dec anonymous 2004 Dec 3 3 SQLITE3_ANY does not exist #e8e8bd 1034 build active 2004 Dec anonymous TclLib 2004 Dec 2 4 configure generated Makefile doesn't use TCL on MinGW on Windows #e8e8bd 1029 doc active 2004 Dec anonymous Unknown 2004 Dec 4 5 SQLITE_ not SQLITE3_ constants in the C/C++ interface . html #f2dcdc 1026 code active 2004 Dec anonymous Unknown 2004 Dec 3 3 sqlite automake sqlite3.pc file does not have version information #e8e8bd 1020 doc active 2004 Nov anonymous 2004 Nov 5 4 in html (.tcl) <,> is not always <, > #e8e8bd 1014 doc new 2004 Nov anonymous Parser 2004 Nov 5 5 Can't have column name "first" any more... #e8e8bd 1011 new active 2004 Nov anonymous 2004 Nov 5 4 No .lib file for in windows precompiled binaries #e8e8bd 971 todo active 2004 Oct anonymous Unknown 2004 Oct peter 2 1 how to recompile sqlite with THREADSAFE preprocessor macro set to 1? #e8e8bd 965 new active 2004 Oct anonymous VDBE 2004 Oct 3 3 Busy Handler not invoked for SELECT et.al. in SQLite <= 2.8.15 #e8e8bd 960 doc active 2004 Oct anonymous 2004 Oct 3 2 Make archive unpack into directory sqlite-VERSION/ #e8e8bd 955 warn active 2004 Oct anonymous Unknown 2004 Oct 1 1 When installing SQLite it says that a file is missing. #e8e8bd 947 warn active 2004 Oct anonymous Unknown 2004 Oct 3 3 Cygwin: integer constant is too large for "long" type #e8e8bd 944 new active 2004 Oct anonymous Shell 2004 Oct 4 3 Command to abort current expression. #f2dcdc 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 #e8e8bd 919 event active 2004 Sep anonymous Unknown 2004 Sep 1 1 'make test' RESETS macOSX at ioerr 2.73.1 #e8e8bd 883 new active 2004 Sep anonymous Shell 2004 Sep 1 4 Choose appropriate column widths for column output #e8e8bd 878 build active 2004 Aug anonymous Unknown 2004 Aug 5 5 Wrong shared library file-names #e8e8bd 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 #e8e8bd 864 build active 2004 Aug anonymous Unknown 2004 Aug 2 2 3.0.4 uses readling #e8e8bd 853 doc active 2004 Aug anonymous Parser 2004 Aug 4 3 syntax of DEFAULT in a CREATE TABLE statement not as documented #e8e8bd 852 doc active 2004 Aug anonymous 2004 Aug 5 4 Typos found in the Syntax documentation #e8e8bd 851 doc active 2004 Aug anonymous Parser 2004 Aug 5 2 SQLite allows Zero length table column names #e8e8bd 845 new active 2004 Aug anonymous 2004 Aug 5 4 Support shared-memory databases #e8e8bd 843 new active 2004 Aug anonymous Unknown 2004 Aug 3 3 Introducing I64 printf size prefix #f2dcdc 841 code active 2004 Aug anonymous Unknown 2004 Aug 3 2 inner group by query isn't honored by outer count(*) aggregate #e8e8bd 833 todo active 2004 Jul anonymous Unknown 2004 Jul 1 3 port of sqlite 2.8.15 to djgpp #f2dcdc 832 code active 2004 Jul anonymous Unknown 2004 Jul anonymous 4 4 os_win.c :: sqlite3OsUnlock() method has an unused variable: rc #e8e8bd 828 warn active 2004 Jul anonymous Unknown 2004 Jul 3 3 integer constants to long #e8e8bd 824 new active 2004 Jul anonymous Unknown 2004 Jul 5 4 StrSum - new build-in aggreate function suggestion #e8e8bd 823 new active 2004 Jul anonymous Unknown 2004 Jul 5 4 absent VERSIONINFO into any Win32 DLL #f2dcdc 822 code active 2004 Jul anonymous Unknown 2004 Jul drh 1 4 port of sqlite to dos with djgpp + small general bugfixes #e8e8bd 816 doc active 2004 Jul anonymous Unknown 2004 Jul 1 4 sqlite3_changes - absent in sqlitedll-3_0_2.zip #e8e8bd 815 build active 2004 Jul anonymous 2004 Jul 2 1 SQLite3.dll exports #e8e8bd 802 warn active 2004 Jul anonymous 2004 Jul anonymous 1 1 Unable to compile the sqlite #e8e8bd 239 new active 2003 Feb anonymous Unknown 2004 Jul 4 2 ANSI/Unicode(Wide) version file-handling functions for Win32 #f2dcdc 798 code active 2004 Jul anonymous Unknown 2004 Jul 1 1 Unable to run tests on Tru64 bit Linux platform #e8e8bd 797 new active 2004 Jul anonymous Parser 2004 Jul 4 3 require basic named subquery / WITH sql support #f2dcdc 783 code active 2004 Jun anonymous Unknown 2004 Jun 3 3 Build on MAC with -DSQLITE_DEBUG=1 compile error #e8e8bd 780 warn active 2004 Jun anonymous Unknown 2004 Jun 3 2 Builkd gice src code errors on MacOS #f2dcdc 763 code active 2004 Jun anonymous Unknown 2004 Jun 5 4 tclsqlite.dll not showing the correct version #e8e8bd 762 todo active 2004 Jun anonymous Unknown 2004 Jun anonymous 4 3 Windows pre-compiled binaries are 2.8.13, not 2.8.14 #e8e8bd 755 new active 2004 Jun anonymous TclLib 2004 Jun drh 5 2 Adding aggregate function to the tcl binding #f2dcdc 754 code active 2004 Jun anonymous Shell 2004 Jun drh 2 3 problem opening a dbfile in the upper directory (../dbname) #e8e8bd 752 doc active 2004 Jun anonymous 2004 Jun 4 4 FAQ-Entry: How to escape quotes #e8e8bd 748 new active 2004 May anonymous 2004 May 3 3 option to allow ignoring trailing whitespace in selects #e8e8bd 746 warn active 2004 May anonymous CodeGen 2004 May anonymous 5 5 How can I make sqlite support serial term? #f2dcdc 744 code active 2004 May anonymous BTree 2004 May anonymous 2 2 make test seg faults on x86_64 Linux #e8e8bd 742 new active 2004 May anonymous VDBE 2004 May anonymous 5 5 database is locked #e8e8bd 741 new active 2004 May anonymous CodeGen 2004 May anonymous 5 5 command tool does not support history #e8e8bd 738 new active 2004 May anonymous 2004 May danielk1977 4 1 Sort order array in memory #e8e8bd 739 new active 2004 May anonymous Unknown 2004 May danielk1977 3 1 Suggestion speed query #e8e8bd 737 new active 2004 May anonymous Shell 2004 May anonymous 3 3 xml export #e8e8bd 736 new active 2004 May anonymous 2004 May 4 4 Would like to be able to list the LAST 10 lines of a query #f2dcdc 735 code active 2004 May anonymous Shell 2004 May 4 3 .sqliterc not processed if running on a driver other than C: #f2dcdc 656 code active 2004 Mar anonymous Unknown 2004 May 5 5 The 'sum' and 'avg' functions don't work on Solaris (UNIX) #e8e8bd 734 build active 2004 May anonymous TclLib 2004 May 4 4 libtclsqlite.xxx not built by default make all target #e8e8bd 732 doc active 2004 May anonymous 2004 May 5 5 Odd columns lead to odder selections #e8e8bd 727 event active 2004 May anonymous 2004 May 4 3 "wrong" affected row value returned by REPLACE #e8e8bd 726 new active 2004 May anonymous Parser 2004 May anonymous 5 5 As to single quote #e8e8bd 724 new active 2004 May anonymous 2004 May 4 5 VACUUM resets settings for the current session #e8e8bd 723 new active 2004 May anonymous Unknown 2004 May 5 4 BatchScript: Example windows batch script for creating databases. #f2dcdc 721 code active 2004 May anonymous Shell 2004 May drh 3 2 empty .databases information #e8e8bd 720 event active 2004 May anonymous 2004 May 1 1 Write problem on MS Windows 98 #e8e8bd 697 event active 2004 Apr anonymous Unknown 2004 May 3 4 Questionable locking #e8e8bd 718 new active 2004 May anonymous 2004 May anonymous 2 2 Case insensitive index ? #e8e8bd 717 new active 2004 May anonymous Unknown 2004 May drh 2 2 minor fixes and port to dos #e8e8bd 714 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 Change sqlite_decode_binary to return buffer size #e8e8bd 712 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 Allow temporary databases to be created in specified folder #e8e8bd 711 new active 2004 Apr anonymous 2004 Apr drh 3 3 Provide a callback function to verify values before insert or update #e8e8bd 710 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 4 Provide the ability to pass a user-data value during sqlite_compile #e8e8bd 707 new active 2004 Apr anonymous Unknown 2004 Apr drh 3 3 how to use internal functions? #f2dcdc 700 code active 2004 Apr anonymous VDBE 2004 Apr 2 3 Solaris-sparc segfaults on sum() #e8e8bd 699 new active 2004 Apr anonymous 2004 Apr 5 4 Data types and implicit conversions #f2dcdc 698 code active 2004 Apr anonymous Unknown 2004 Apr 1 3 .mode list - not going to next line #e8e8bd 169 new active 2002 Oct anonymous Unknown 2004 Apr anonymous 5 5 CE version #f2dcdc 691 code active 2004 Apr anonymous Unknown 2004 Apr drh 1 1 OS X File Sharing #e8e8bd 689 doc active 2004 Apr anonymous 2004 Apr anonymous 4 4 Old Comment for sqlite_decode_binary in sources ? #f2dcdc 685 code active 2004 Apr anonymous CodeGen 2004 Apr 1 3 SELECT from a VIEW with GROUP BY #e8e8bd 673 new active 2004 Mar anonymous Shell 2004 Apr 4 3 Format .dump nicer (patch) #f2dcdc 684 code active 2004 Apr anonymous Unknown 2004 Apr 3 2 Incorrect function result type when using SQLITE_ARGS #e8e8bd 682 new active 2004 Apr anonymous 2004 Apr 5 1 sqlite_aggregate_context() valid in xFunc callback routine #e8e8bd 48 doc active 2002 May anonymous 2004 Mar drh 1 1 use sqlite from a tclsh.exe #f2dcdc 575 code active 2004 Jan anonymous VDBE 2004 Mar drh 3 3 pragma (default_)temp_store implementations seems incomplete #f2dcdc 666 code active 2004 Mar anonymous Unknown 2004 Mar anonymous 5 4 Error message indicates wrong error #e8e8bd 662 new active 2004 Mar anonymous 2004 Mar drh 5 5 Stored Procedures? #e8e8bd 660 new active 2004 Mar anonymous 2004 Mar 5 5 compression/encoding feature? #e8e8bd 652 doc active 2004 Mar anonymous Unknown 2004 Mar anonymous 5 5 small addition needed in pragma table_info #e8e8bd 651 new active 2004 Mar anonymous 2004 Mar 5 4 Update optimisation #e8e8bd 647 warn active 2004 Mar anonymous Shell 2004 Mar 5 4 Shell.c compilation warnings #e8e8bd 646 warn active 2004 Mar anonymous Pager 2004 Mar 5 4 Pager.c compilation warnings #e8e8bd 645 new active 2004 Mar anonymous 2004 Mar 5 5 OpenWatcom makefile #e8e8bd 644 todo active 2004 Mar anonymous Unknown 2004 Mar 1 3 How do you fix "SQL error: database disk image is malformed" #e8e8bd 638 new active 2004 Mar anonymous 2004 Mar 5 5 Lemon.c could not be compiled - source dated 27.02.2004 #f2dcdc 637 code active 2004 Mar anonymous Parser 2004 Mar 5 4 union uses non-standard column names #e8e8bd 633 build active 2004 Feb anonymous 2004 Feb 1 1 new build system does not run correctly under MinGW/MSYS #f2dcdc 627 code active 2004 Feb anonymous 2004 Feb 3 3 sqliteRunVacuum returning wrong code? #e8e8bd 622 doc active 2004 Feb anonymous 2004 Feb 1 3 Should mention PRAGMA table_info() in FAQ #e8e8bd 621 todo active 2004 Feb anonymous Unknown 2004 Feb anonymous 3 3 Assorted errors running test's on MAC OSX #e8e8bd 613 doc active 2004 Feb anonymous 2004 Feb 3 4 Doc is wrong with some prototypes and const is missing for errmsg #e8e8bd 611 new active 2004 Feb anonymous VDBE 2004 Feb 1 3 Remove giant SWITCH statement in VM for better portability #e8e8bd 609 build active 2004 Feb anonymous Unknown 2004 Feb 1 4 Makefile errors #f2dcdc 608 code active 2004 Feb anonymous 2004 Feb 3 3 Problem with "pragma show_datatypes = on" and busy timeout #e8e8bd 451 build active 2003 Sep anonymous 2004 Feb 1 1 Makefile fails on FreeBSD #e8e8bd 592 event active 2004 Feb anonymous Unknown 2004 Feb 1 1 VIEW produces strange result set #e8e8bd 591 todo active 2004 Feb anonymous Unknown 2004 Feb anonymous 5 4 "PRAGMA table_info" doesn't show you which column is unique #e8e8bd 590 new active 2004 Jan anonymous Parser 2004 Jan 5 4 Treat ` like spaces outside of quoted strings. #e8e8bd 588 new active 2004 Jan anonymous 2004 Jan 5 4 Please provide support for NULLS LAST in ORDER BY clauses. #e8e8bd 93 new active 2002 Jul anonymous 2004 Jan 3 3 Can't open database when TEMP environment variable is not defined well #e8e8bd 572 new active 2004 Jan anonymous Unknown 2004 Jan drh 3 3 sqlite 2.8.11 port to djgpp #e8e8bd 566 new active 2004 Jan anonymous Unknown 2004 Jan 4 4 [PATCH] Port of sqlite and lemon to an EBCDIC mainframe #e8e8bd 563 new active 2004 Jan anonymous Parser 2004 Jan 4 3 Support for autoincrement type "SERIAL" (from PostgreSQL) #f2dcdc 369 code active 2003 Jun anonymous 2004 Jan 3 2 Testsuite fails on btree-1.1.1 (Mac OS X, SQLite 2.8.4) #e8e8bd 560 warn active 2004 Jan anonymous 2004 Jan 4 4 Warnings on commpiling using Visual C++ 6.0 #e8e8bd 550 new active 2004 Jan anonymous Unknown 2004 Jan anonymous 1 1 change of MASTER_NAME and TEMP_MASTER_NAME definition error #e8e8bd 544 new active 2004 Jan anonymous 2004 Jan 5 4 Feature Request: Indicate UNIQUE columns in table_info. #e8e8bd 540 event active 2003 Dec drh 2003 Dec 1 5 Database corruption observed #e8e8bd 539 new active 2003 Dec anonymous VDBE 2003 Dec 5 4 Addition of engine 'Suspension' interface #e8e8bd 538 new active 2003 Dec anonymous 2003 Dec 4 3 Different warnings in windows #e8e8bd 503 warn active 2003 Nov anonymous Unknown 2003 Dec anonymous 5 2 Include sqlite source in Visual C++ 6.0 SP5 #e8e8bd 391 warn active 2003 Jul anonymous 2003 Dec 4 3 signed/unsiged compiler warnings from Borland C++6 #e8e8bd 348 warn active 2003 Jun anonymous Unknown 2003 Dec drh 4 3 SQLite and GCC using enhanced warning levels #e8e8bd 180 event active 2002 Oct anonymous 2003 Dec anonymous 1 1 on WIN32 - multithreaded process causes crash on assert(mutext) #e8e8bd 445 build active 2003 Sep anonymous Unknown 2003 Dec anonymous 3 1 Compilation problem on MinGW #e8e8bd 409 event active 2003 Jul anonymous Unknown 2003 Dec anonymous 3 1 sqlite_open will cause segfault when using Rational PurifyPlus/Linux #e8e8bd 312 build active 2003 May anonymous Shell 2003 Dec 1 3 libreadline.so.0.0 causes unidentified token error #e8e8bd 307 event active 2003 May anonymous Shell 2003 Dec anonymous 1 1 fail to rpm install on redhat 9 #e8e8bd 477 new active 2003 Oct anonymous 2003 Dec anonymous 4 4 Are there any plans to enchance SQLite to support Unicode #e8e8bd 404 new active 2003 Jul anonymous 2003 Dec 3 3 new C API: sqlite_get_table_with_types with type information #e8e8bd 524 new active 2003 Dec anonymous Unknown 2003 Dec 2 1 port of sqlite to dos with short file names #e8e8bd 525 new active 2003 Dec anonymous 2003 Dec 4 4 DB testing #e8e8bd 207 event active 2002 Dec anonymous Shell 2003 Dec 2 1 After installation cannot create any databases #e8e8bd 517 new active 2003 Dec anonymous Parser 2003 Dec drh 1 1 \' sequence unrecognized token error enhancement request #e8e8bd 510 new active 2003 Nov anonymous Unknown 2003 Nov 5 2 trigger: addition of create ability #e8e8bd 509 event active 2003 Nov anonymous 2003 Nov 5 3 SQLite on Pocket PC - question - how to do that step by step? #e8e8bd 508 doc active 2003 Nov anonymous 2003 Nov 4 4 Build instructions on home page needs link to page with platform help #e8e8bd 501 doc active 2003 Nov anonymous Unknown 2003 Nov anonymous 4 4 missing sqlite_encode_binary #e8e8bd 498 new active 2003 Nov anonymous Unknown 2003 Nov 4 4 Suggestion: Allow named parameters. #e8e8bd 500 doc active 2003 Nov anonymous Unknown 2003 Nov 4 4 Discrepancies in comments in encode.c #e8e8bd 496 build active 2003 Nov anonymous 2003 Nov 1 1 SQLite Ignores Autoconf Options #e8e8bd 398 build active 2003 Jul anonymous Unknown 2003 Nov 3 3 configure.ac is wrong for Windows Mingw/Msys #e8e8bd 339 build active 2003 Jun anonymous Shell 2003 Nov 2 3 readline headers not found (because of readline/ prefix) #e8e8bd 259 new active 2003 Mar anonymous CodeGen 2003 Nov 1 2 ORDER BY queries including an integer primary key don't use index #e8e8bd 456 build active 2003 Sep anonymous 2003 Nov anonymous 1 1 compilation problem under winnt 4 using Lcc-win32 #e8e8bd 268 new active 2003 Mar anonymous Parser 2003 Nov 1 3 columns of subselects containing joins are not recognized #e8e8bd 209 new active 2002 Dec anonymous BTree 2003 Nov 1 1 update libtool #e8e8bd 338 new active 2003 Jun anonymous Unknown 2003 Nov 5 1 lowerFunc and upperFunc Fail on foreign characters #e8e8bd 303 build active 2003 May anonymous Unknown 2003 Nov a.rottmann 4 4 Makefile issues #e8e8bd 235 new active 2003 Jan anonymous Unknown 2003 Nov chw 5 1 Local language do not support! #e8e8bd 473 build active 2003 Oct anonymous 2003 Nov drh 3 3 makefile's target_source fails to create opcodes.c #e8e8bd 478 new active 2003 Oct anonymous Parser 2003 Nov drh 1 3 select into is lacking #e8e8bd 483 build active 2003 Oct anonymous Shell 2003 Nov 2 3 history.h from readline library not checked for #e8e8bd 484 build active 2003 Oct anonymous 2003 Nov 5 4 make clean cleans doc/ completely #e8e8bd 495 build active 2003 Nov anonymous 2003 Nov 1 1 Makefile syntax errors #e8e8bd 472 new active 2003 Oct anonymous VDBE 2003 Nov 5 5 [Patch] Using localtime instead UTC time to 'now' #f2dcdc 414 code active 2003 Jul anonymous VDBE 2003 Nov 3 4 sqlite_compile() and database schema changes #e8e8bd 493 event active 2003 Nov anonymous Unknown 2003 Nov 3 3 Problem compiling sqlite #e8e8bd 491 new active 2003 Nov anonymous 2003 Nov 4 4 Want to use SET col = 'val' with INSERT statement #e8e8bd 490 new active 2003 Nov anonymous VDBE 2003 Nov xdong 4 3 a few api improvements for recordset operations #e8e8bd 486 new active 2003 Oct anonymous VDBE 2003 Oct 5 4 index on expressions (general solution to case-insensitive problem) #e8e8bd 485 new active 2003 Oct anonymous BTree 2003 Oct 5 4 Comparing strings: user defined callback, strcoll? #e8e8bd 128 event active 2002 Jul anonymous Unknown 2003 Oct 4 4 Workaround for problem reported in ticket 127- #e8e8bd 479 new active 2003 Oct anonymous Parser 2003 Oct drh 4 3 Sequences #e8e8bd 243 new active 2003 Feb anonymous Unknown 2003 Oct anonymous 3 4 Performance problem with MSVC precompiled DLL #e8e8bd 465 new active 2003 Sep anonymous 2003 Sep 4 3 data types should be implemented as formated strings #e8e8bd 463 event active 2003 Sep anonymous 2003 Sep 2 1 list index out of bounds(1) #e8e8bd 462 event active 2003 Sep anonymous 2003 Sep 2 1 list index out of bounds(1) #e8e8bd 457 new active 2003 Sep anonymous 2003 Sep 1 1 Ported to NetWare #e8e8bd 454 new active 2003 Sep anonymous 2003 Sep 4 4 schema column types with parenthesis to automatically invoke functions #e8e8bd 450 new active 2003 Sep anonymous Shell 2003 Sep 5 4 Make HTML Output XHTML compliant #e8e8bd 448 new active 2003 Sep anonymous 2003 Sep drh 3 3 a general bug-fix and dos support without lfn #e8e8bd 446 doc active 2003 Sep anonymous 2003 Sep drh 3 3 sqlite_compile can return no virtual machine with code SQLITE_OK #e8e8bd 442 new active 2003 Sep anonymous 2003 Sep 5 2 [PATCH] sqlite: allow configure --enable-threadsafe #e8e8bd 428 new active 2003 Aug anonymous TclLib 2003 Aug drh 5 5 missing prepare/fetch functions to be compatible with other DBs #e8e8bd 425 new active 2003 Aug anonymous VDBE 2003 Aug 5 3 Datetime enhancements: fractional seconds, addmonth #e8e8bd 424 new active 2003 Aug anonymous Shell 2003 Aug 4 3 Provide access to internal function _all_whitespace() #e8e8bd 420 new active 2003 Jul anonymous VDBE 2003 Jul 3 3 Not abort transaction when callback is cancelled #f2dcdc 395 code active 2003 Jul anonymous Unknown 2003 Jul 4 4 Error opening db on Mac OS X not reported correctly #e8e8bd 413 new active 2003 Jul anonymous 2003 Jul 5 1 SQL_CALC_FOUND_ROWS & FOUND_ROWS() not supported #e8e8bd 412 new active 2003 Jul anonymous Unknown 2003 Jul drh 1 1 sign function: quick hack for func.c (hope this helps) #e8e8bd 411 todo active 2003 Jul anonymous 2003 Jul drh 1 1 support for sign function in select #e8e8bd 407 new active 2003 Jul anonymous 2003 Jul 4 4 sqlite_compile etc. and pragma empty_result_callbacks. #f2dcdc 403 code active 2003 Jul anonymous 2003 Jul 4 4 Two small fixes in .spec file for RPMS #e8e8bd 184 new active 2002 Oct mike 2003 Jul drh 5 3 auto update mechanism for CVS #e8e8bd 386 new active 2003 Jul anonymous 2003 Jul 5 1 compile on WinCE ? #e8e8bd 381 new active 2003 Jul anonymous 2003 Jul 1 3 Support for DJGPP and DOS #e8e8bd 366 new active 2003 Jun anonymous Unknown 2003 Jun drh 4 3 Functions sqlite_(en/de)code_binary() not in sqlite.h #e8e8bd 362 event active 2003 Jun anonymous Shell 2003 Jun jadams 4 2 Problem with select count #e8e8bd 363 new active 2003 Jun anonymous VDBE 2003 Jun jadams 5 5 sqlite support domain as user defined type #e8e8bd 356 new active 2003 Jun anonymous VDBE 2003 Jun 5 2 Returns real error codes #e8e8bd 335 event active 2003 Jun anonymous Unknown 2003 Jun drh 2 2 ChangeCount still failing #e8e8bd 331 new active 2003 May anonymous Unknown 2003 Jun mike 5 5 Went to compile Win32 project and found a missing header reference #f2dcdc 330 code active 2003 May anonymous VDBE 2003 May 3 4 Aggregator's error are ignored #e8e8bd 326 new active 2003 May anonymous 2003 May 4 4 Request for additional callback for various functions #e8e8bd 321 new active 2003 May anonymous 2003 May 4 3 Make SQLITE_ISO8859 and SQLITE_UTF8 overridable by compiler define #e8e8bd 279 new active 2003 Apr anonymous 2003 May 3 3 WinCE port of CVS version as of 02 Apr 2003 #f2dcdc 301 code active 2003 Apr anonymous Unknown 2003 Apr 2 3 Can't acquire lock for database on Mac OS X AppleShare volume #e8e8bd 294 new active 2003 Apr anonymous Shell 2003 Apr a.rottmann 1 4 Diff for OpenBSD #e8e8bd 286 doc active 2003 Apr anonymous 2003 Apr 3 3 Tcl command documentation does not explain (minus) options. #e8e8bd 278 doc active 2003 Apr anonymous Unknown 2003 Apr anonymous 3 3 Possible documentation bug in "expression" section. #e8e8bd 273 new active 2003 Mar drh CodeGen 2003 Mar drh 1 1 Make NULL_ALWAYS_DISTINCT a pragma rather than a compile-time option #e8e8bd 271 event active 2003 Mar anonymous Unknown 2003 Mar drh 3 2 'make test' fails on MacOS X #e8e8bd 263 new active 2003 Mar anonymous CodeGen 2003 Mar 1 4 sqlite locking strategy can lead to deadlock #e8e8bd 255 event active 2003 Feb anonymous 2003 Feb 1 1 Database locked on HP64 (B11.11) #e8e8bd 254 event active 2003 Feb anonymous 2003 Feb 1 1 make test does not work on HP64 (B11.11) #e8e8bd 253 event active 2003 Feb anonymous 2003 Feb 1 1 make install does not work with install-sh script #e8e8bd 252 new active 2003 Feb anonymous 2003 Feb 4 1 Add optional regex matching similar to what Postgres & Oracle have #e8e8bd 236 new active 2003 Jan anonymous 2003 Feb 3 3 Add RENAME TABLE - will be easier to work around missing ALTER TABLE #e8e8bd 244 new active 2003 Feb anonymous Unknown 2003 Feb drh 5 4 Combining CREATE TABLE with its populating from some flat file #e8e8bd 233 event active 2003 Jan anonymous Unknown 2003 Jan 1 4 test bigfile-1.1 dumps core on Tru64 platform #e8e8bd 230 event active 2003 Jan anonymous Shell 2003 Jan anonymous 4 5 Problems compiling on AIX 4.3.3 #e8e8bd 68 new active 2002 Jun anonymous 2003 Jan 5 5 PRAGMA table_info(table-name) for queries #e8e8bd 219 new active 2003 Jan anonymous 2003 Jan 5 5 MySQL style enums #e8e8bd 216 new active 2003 Jan anonymous 2003 Jan 1 1 Add "DISTINCT ON()" clause to specify the fields to apply the unicity #e8e8bd 204 event active 2002 Dec anonymous Unknown 2002 Dec anonymous 1 1 Select statement takes hours (or more!) #e8e8bd 203 new active 2002 Dec anonymous Unknown 2002 Dec anonymous 2 1 Missing Win32 open flag if shared database #e8e8bd 192 doc active 2002 Nov anonymous Unknown 2002 Nov anonymous 4 4 Finishing build on MacOS 10.x (and other *nix's, likely) #e8e8bd 186 new active 2002 Nov anonymous Shell 2002 Nov 5 4 ./configure --enable-threads-safe ? #e8e8bd 175 new active 2002 Oct anonymous Pager 2002 Oct 5 3 journal file should be kept open #e8e8bd 164 event active 2002 Oct anonymous CodeGen 2002 Oct anonymous 3 4 Compiler warnings with MS Visual C++ 6.0 #e8e8bd 139 new active 2002 Aug anonymous Pager 2002 Aug 3 3 Named transactions are misleading as documented #e8e8bd 129 event active 2002 Jul anonymous Unknown 2002 Jul 4 4 tcl-2.2 test fails #e8e8bd 126 event active 2002 Jul anonymous VDBE 2002 Jul 4 5 malloc-1.195 test aborts from assert in vdbe.c #e8e8bd 96 todo active 2002 Jul drh 2002 Jul drh 1 1 Handle problems resulting from fork() #e8e8bd 98 todo active 2002 Jul drh 2002 Jul drh 1 1 Document and test TEMPORARY views #e8e8bd 82 new active 2002 Jun anonymous 2002 Jun 1 4 Add IsCacheable, IsNullable to sqlite_create_function #e8e8bd 43 event active 2002 May anonymous 2002 May drh 1 1 sqlite compile without readline on linux slackware 8.0