bgcolor # Type Status Created By Subsys Changed Assigned Svr Pri Title
#c8c8c8 1460 code closed 2005 Sep anonymous VDBE 2008 Jan drh 2 2 sqlite3_clear_bindings not implemented in sources
#c8c8c8 2003 warn closed 2006 Sep anonymous VDBE 2006 Sep 4 4 vdbeaux.c:1585: warning: unused variable 'sqlite3_search_count'
#c8c8c8 1481 code closed 2005 Oct anonymous VDBE 2006 Sep 4 4 sqlite 3.2.7 does not report column names properly in joined queries
#c8c8c8 1909 code closed 2006 Aug anonymous VDBE 2006 Aug anonymous 3 3 cannot use sqlite3_prepare() when DB is in "BEGIN EXCLUSIVE" mode
#c8c8c8 1748 code closed 2006 Apr anonymous VDBE 2006 Apr 3 3 Memory leak in insert.c: sqlite3TableAffinityStr
#c8c8c8 1640 code closed 2006 Jan anonymous VDBE 2006 Jan 3 2 Can't get error message from sqlite3_result_error
#c8c8c8 1507 code closed 2005 Nov anonymous VDBE 2005 Nov 2 2 Embarassing buffer overflow in sqlite3VdbeMemPrettyPrint( )
#c8c8c8 1462 code closed 2005 Sep anonymous VDBE 2005 Sep drh 1 2 sqlite3_bind_parameter_name() always return nulls
#c8c8c8 1383 code closed 2005 Aug anonymous VDBE 2005 Aug 1 1 Whole doubles get a dot zero when promoted to string
#c8c8c8 1366 code closed 2005 Aug anonymous VDBE 2005 Aug 3 3 not getting SQLITE_CORRUPT when corruption detected in a SELECT
#c8c8c8 1290 new closed 2005 Jun anonymous VDBE 2005 Jun drh 1 1 optimize VBDE, reordening ID numbers of OP_????? codes
#c8c8c8 1266 code closed 2005 May anonymous VDBE 2005 May 2 2 crash when using instead of update triggers on views
#c8c8c8 1261 new closed 2005 May anonymous VDBE 2005 May 5 3 Optimization
#c8c8c8 1178 code closed 2005 Mar anonymous VDBE 2005 Mar 1 1 sqlite 3 returns SQLITE_ERROR instead of SQLITE_SCHEMA
#c8c8c8 1154 event closed 2005 Mar anonymous VDBE 2005 Mar 1 1 PRIMARY KEY AUTOINCREMENT and TRIGGER problem
#c8c8c8 1104 code closed 2005 Feb anonymous VDBE 2005 Feb 1 1 Integer overflow
#c8c8c8 1102 code closed 2005 Feb anonymous VDBE 2005 Feb 3 3 uninitialized memory copy in sqlite3VdbeExec
#c8c8c8 1 new closed 2002 Mar drh VDBE 2005 Feb 3 4 Make the LIKE operator a user-installable function
#c8c8c8 745 code closed 2004 May anonymous VDBE 2005 Jan 5 3 no error message when two statements cause a conflict
#c8c8c8 751 code closed 2004 Jun anonymous VDBE 2005 Jan 1 2 sqliteVdbeExec: Assertion `db->magic==***' failed.
#c8c8c8 324 todo closed 2003 May anonymous VDBE 2005 Jan 1 4 ESCAPE clause in LIKE predicate not implemented
#c8c8c8 937 code closed 2004 Oct anonymous VDBE 2004 Oct drh 2 4 mixed wildcard "?" and ":abc" cause msvcrt.dll raise a exception.
#c8c8c8 928 code closed 2004 Sep anonymous VDBE 2004 Sep drh 3 3 delete record by rowid would core dump
#c8c8c8 917 code closed 2004 Sep anonymous VDBE 2004 Sep drh 1 1 bug with named parameters
#c8c8c8 722 code closed 2004 May anonymous VDBE 2004 Jul drh 2 1 long long format specifier in sqlite_exec_printf missing
#c8c8c8 616 code closed 2004 Feb anonymous VDBE 2004 Feb 1 1 variable 'db' is not initialized before being used (expr.c line 418)
#c8c8c8 580 code closed 2004 Jan anonymous VDBE 2004 Jan 2 3 Incorrect Select when specifying same field value as column name
#c8c8c8 555 code closed 2004 Jan anonymous VDBE 2004 Jan 1 1 sqlite_step and sqlite_compile cause locking problem
#c8c8c8 537 code closed 2003 Dec anonymous VDBE 2003 Dec 1 2 Problems using sqlite_bind() with INSERT INTO ... SELECT statements
#c8c8c8 415 code closed 2003 Jul anonymous VDBE 2003 Dec 3 3 Stringify can loose digits in doubles
#c8c8c8 426 code closed 2003 Aug anonymous VDBE 2003 Dec 2 3 TIME produces JDs off by 12 hours
#c8c8c8 511 code closed 2003 Nov anonymous VDBE 2003 Nov 1 1 confused error of nested calling of "sqlite_compile"
#c8c8c8 205 code closed 2002 Dec anonymous VDBE 2002 Dec 4 4 select order by on a column with null values causes uninitialized-read
#c8c8c8 165 code closed 2002 Oct anonymous VDBE 2002 Oct anonymous 1 1 can create and change tickets, without logged in
#c8c8c8 62 code closed 2002 Jun danielk1977 VDBE 2002 Sep 3 4 TEMP tables with a read-only database
#c8c8c8 10 code closed 2002 Apr drh VDBE 2002 May 1 1 Stack grows without bound on UPDATE OR IGNORE
#c8c8c8 7 code closed 2002 Apr danielk1977 VDBE 2002 May 5 2 VDBE trace prints out garbage for P3 of Function opcodes
#c8c8c8 1966 build closed 2006 Sep anonymous Unknown 2007 Feb 3 4 Add a --disable-readline option to configure
#c8c8c8 1971 code closed 2006 Sep anonymous Unknown 2006 Oct 4 4 66 tests fail out of 26937
#c8c8c8 1999 code closed 2006 Sep anonymous Unknown 2006 Sep 3 3 Memmory leak and wrong passed argument to calback function
#c8c8c8 2000 doc closed 2006 Sep anonymous Unknown 2006 Sep 1 3 Teorical questions.
#c8c8c8 1477 code closed 2005 Oct anonymous Unknown 2006 Sep 1 2 first "select count(*) from mytable" takes a very long time
#c8c8c8 1968 code closed 2006 Sep anonymous Unknown 2006 Sep 1 2 sqlite3_column_type() returns 1 instead of 0 since 3.3.7
#c8c8c8 1989 build closed 2006 Sep anonymous Unknown 2006 Sep a.rottmann 2 2 100's daily in XP temp folder-Cannot delete w/out reboot-Stop create?
#c8c8c8 1970 build closed 2006 Sep anonymous Unknown 2006 Sep 4 4 Cannot make Loadable Extensions to work for me.
#c8c8c8 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
#c8c8c8 1751 code closed 2006 Apr anonymous Unknown 2006 Sep mike 1 1 sqlite doesn't work on a cifs-mounted drive
#c8c8c8 1944 new closed 2006 Aug anonymous Unknown 2006 Aug 4 4 no UTF16 counterpart to sqlite3_exec()
#c8c8c8 1936 code closed 2006 Aug anonymous Unknown 2006 Aug 2 3 Altering schema seems to invalidate existing database connections
#c8c8c8 1930 code closed 2006 Aug anonymous Unknown 2006 Aug adamd 1 1 the select command can't support NOT_FOUND.
#c8c8c8 1795 code closed 2006 May anonymous Unknown 2006 Aug 1 1 Incorrect result if a nested view contains a union
#c8c8c8 1908 code closed 2006 Aug anonymous Unknown 2006 Aug anonymous 2 4 ORDER BY clause does not allow quoting
#c8c8c8 1904 code closed 2006 Aug anonymous Unknown 2006 Aug 2 3 error using drop table "if exists" in exec
#c8c8c8 1894 event closed 2006 Jul anonymous Unknown 2006 Jul 4 3 "library routine called out of sequence" when using progress (TCL)
#c8c8c8 1888 code closed 2006 Jul anonymous Unknown 2006 Jul anonymous 1 1 connetion to db extremely slow
#c8c8c8 1876 event closed 2006 Jun anonymous Unknown 2006 Jun 4 4 Creating table disrupts previously prepared statement
#c8c8c8 1859 code closed 2006 Jun anonymous Unknown 2006 Jun danielk1977 4 3 Wrong calculation og log2() in check-in [3274]
#c8c8c8 1842 code closed 2006 Jun anonymous Unknown 2006 Jun anonymous 1 1 The field data saved in the table is corrupt
#c8c8c8 1840 code closed 2006 Jun anonymous Unknown 2006 Jun 4 4 sqlite3_get_table returns null pointer for aggregate queries
#c8c8c8 1835 code closed 2006 Jun anonymous Unknown 2006 Jun 1 2 Memory leak on sqlite3_step with Select with no result row
#c8c8c8 1819 code closed 2006 May anonymous Unknown 2006 May persicom 4 3 faulty html code for concatenated field with "<" character
#c8c8c8 1818 code closed 2006 May anonymous Unknown 2006 May drh 3 3 sqlite3_mprintf() misbehaving on %*. formats
#c8c8c8 1776 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 1 2 Max(DateTime column) returns a String, not a DateTime
#c8c8c8 1767 warn closed 2006 Apr anonymous Unknown 2006 Apr 5 4 Unused variable in function sqlite3VdbeChangeEncoding
#c8c8c8 1766 new closed 2006 Apr anonymous Unknown 2006 Apr 3 2 Order by NO Case Sensitive
#c8c8c8 1764 code closed 2006 Apr anonymous Unknown 2006 Apr 1 2 database file format not inter-operable between 32-bit/ 64-bit systems
#c8c8c8 1761 code closed 2006 Apr anonymous Unknown 2006 Apr 1 3 SQLite3_BindText fails with a floating point error
#c8c8c8 1758 code closed 2006 Apr anonymous Unknown 2006 Apr 3 1 problem with: select ... UNION ... select .. ORDER BY LOWER(column)
#c8c8c8 1752 code closed 2006 Apr anonymous Unknown 2006 Apr 3 4 New compile warnings with default ./configure && make on MinGW
#c8c8c8 1753 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 2 1 Order by not working on a column with random() function
#c8c8c8 1739 code closed 2006 Mar anonymous Unknown 2006 Mar 4 1 sqlite3_bind_int on UPDATE * SET COLUMN1='Test' WHERE ID=?
#c8c8c8 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.
#c8c8c8 1736 code closed 2006 Mar anonymous Unknown 2006 Mar 4 4 #define SQLITE_OMIT_ALTERTABLE causes unresolved externals
#c8c8c8 1592 code closed 2006 Jan anonymous Unknown 2006 Mar 1 2 [patch] fixes for mbcs in os_win.c
#c8c8c8 1708 code closed 2006 Mar anonymous Unknown 2006 Mar anonymous 4 3 Spurious warning: no such table: faculty(1) at dbdimp.c line 269
#c8c8c8 1707 code closed 2006 Mar anonymous Unknown 2006 Mar 4 4 Internal data are not naturaly aligned, which could affect perfomance
#c8c8c8 1568 code closed 2005 Dec anonymous Unknown 2006 Mar 1 1 sqlite3_column_decltype( ) returning BadPointer with "UNION"
#c8c8c8 1639 code closed 2006 Jan anonymous Unknown 2006 Mar 3 3 pkgconfig file in 3.3.1 says version is 3.3
#c8c8c8 1691 code closed 2006 Feb anonymous Unknown 2006 Mar 3 3 sqlite3_sleep not built
#c8c8c8 1705 code closed 2006 Mar anonymous Unknown 2006 Mar 4 4 Default column constant doesn't assign value on NULL insert
#c8c8c8 1681 code closed 2006 Feb anonymous Unknown 2006 Mar 1 3 After upgrading from 3.2.7 to 3.3.4, problems with umlauts
#c8c8c8 1678 code closed 2006 Feb anonymous Unknown 2006 Feb 1 1 error select like
#c8c8c8 1296 new closed 2005 Jun anonymous Unknown 2006 Feb 5 5 Nested Transactions needed
#c8c8c8 679 code closed 2004 Mar anonymous Unknown 2006 Jan a.rottmann 2 1 database closed
#c8c8c8 1609 code closed 2006 Jan anonymous Unknown 2006 Jan 2 3 ALTER TABLE ADD COLUMN failed if table name has multibyte character
#c8c8c8 1559 new closed 2005 Dec anonymous Unknown 2005 Dec 4 4 SQLite file is corrupt
#c8c8c8 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
#c8c8c8 1556 event closed 2005 Dec anonymous Unknown 2005 Dec anonymous 1 1 database locked if used on mounted nfs shares (linux)
#c8c8c8 1540 code closed 2005 Nov anonymous Unknown 2005 Nov 2 3 Failure to create a primary key
#c8c8c8 1535 code closed 2005 Nov anonymous Unknown 2005 Nov 2 3 Segmentation fault on query
#c8c8c8 1518 code closed 2005 Nov anonymous Unknown 2005 Nov 4 4 can not vacuum an empty db-file
#c8c8c8 1470 new closed 2005 Oct anonymous Unknown 2005 Oct anonymous 2 4 International support
#c8c8c8 1456 code closed 2005 Sep anonymous Unknown 2005 Sep 4 4 get_table16 ?
#c8c8c8 1439 code closed 2005 Sep anonymous Unknown 2005 Sep 3 3 Format String inserting a text
#c8c8c8 1361 code closed 2005 Aug anonymous Unknown 2005 Sep 1 1 sqlite3_mprintf function(s) don't account for commas with %q flag
#c8c8c8 1404 event closed 2005 Sep anonymous Unknown 2005 Sep 1 1 pragma case_sensitive_like is broken?
#c8c8c8 1410 code closed 2005 Sep anonymous Unknown 2005 Sep 2 3 count(*) confused by newlines in data
#c8c8c8 1402 code closed 2005 Sep anonymous Unknown 2005 Sep 1 2 (Windows 2K) file handle on file not released after use
#c8c8c8 1326 code closed 2005 Jul anonymous Unknown 2005 Aug 4 1 using callbacks with two exact queries duplicate results
#c8c8c8 1349 code closed 2005 Aug anonymous Unknown 2005 Aug anonymous 4 4 NULL handling UNIQUE indexes is not consistent
#c8c8c8 1281 code closed 2005 Jun anonymous Unknown 2005 Jun 1 1 Errors testing sqlite 3.2.1
#c8c8c8 1238 code closed 2005 May anonymous Unknown 2005 Jun 1 3 Failure to compile with SQLITE_OMIT_... macros enabled
#c8c8c8 1273 code closed 2005 Jun anonymous Unknown 2005 Jun 3 3 Numeric affinity problem with views + coalesce (maybe all functions?)
#c8c8c8 1144 code closed 2005 Feb anonymous Unknown 2005 May 1 3 Changing page_size causes a GPF on memory databases
#c8c8c8 1218 code closed 2005 Apr anonymous Unknown 2005 Apr 2 1 'select rowid' does not return 'rowid' as column title
#c8c8c8 1225 code closed 2005 Apr anonymous Unknown 2005 Apr 3 3 Empty resultset when unreferenced empty "table AS name" is given.
#c8c8c8 1195 code closed 2005 Apr anonymous Unknown 2005 Apr 3 3 memory leak
#c8c8c8 1192 code closed 2005 Mar anonymous Unknown 2005 Mar 2 3 Defaults not Respected by View Triggers
#c8c8c8 1183 code closed 2005 Mar anonymous Unknown 2005 Mar danielk1977 3 2 Memory coruption related to syntax errors
#c8c8c8 1175 code closed 2005 Mar anonymous Unknown 2005 Mar 1 1 busy handler is not being called
#c8c8c8 1107 new closed 2005 Feb anonymous Unknown 2005 Mar 5 3 please add function to query endianness match/mismatch for BLOB
#c8c8c8 1139 code closed 2005 Feb anonymous Unknown 2005 Mar 1 1 error while loading shared libraries
#c8c8c8 1156 new closed 2005 Mar anonymous Unknown 2005 Mar 3 1 Cant fetch records in between one DATE to another DATE
#c8c8c8 1136 code closed 2005 Feb anonymous Unknown 2005 Feb 3 3 make test: syntax error in alter-1.8.2
#c8c8c8 1131 new closed 2005 Feb anonymous Unknown 2005 Feb 2 3 triggers don't seem to work across databases
#c8c8c8 1129 new closed 2005 Feb anonymous Unknown 2005 Feb drh 4 3 allow having the same object in several open databases
#c8c8c8 1113 code closed 2005 Feb anonymous Unknown 2005 Feb 2 2 Problem with TYPEOF function in triggers
#c8c8c8 1096 new closed 2005 Feb Unknown 2005 Feb 3 3 ? placeholder not allowed in LIMIT or OFFSET clause
#c8c8c8 1093 doc closed 2005 Feb anonymous Unknown 2005 Feb 5 4 possible mistake in a comment sqlite3_get_table sqlite3.h:~line312
#c8c8c8 1092 code closed 2005 Feb anonymous Unknown 2005 Feb 1 2 wrong result of a query
#c8c8c8 814 todo closed 2004 Jul anonymous Unknown 2005 Jan anonymous 1 1 How can I get the recent bug-fixed branch version 2?
#c8c8c8 470 code closed 2003 Oct anonymous Unknown 2005 Jan 2 3 Unnecessary 31-character name limit on Mac
#c8c8c8 199 new closed 2002 Dec anonymous Unknown 2005 Jan drh 4 4 Encryption
#c8c8c8 1076 todo closed 2005 Jan anonymous Unknown 2005 Jan 2 3 data loss possible with fsync on Mac OS X 10.3
#c8c8c8 1074 code closed 2005 Jan anonymous Unknown 2005 Jan drh 3 3 CREATE INDEX and dbl-quoted index names
#c8c8c8 1018 code closed 2004 Nov anonymous Unknown 2005 Jan 1 3 Some functions not defined for OS_MAC
#c8c8c8 847 code closed 2004 Aug anonymous Unknown 2005 Jan 4 1 sqlite3_changes doesn't reset to zero after inserts
#c8c8c8 1065 new closed 2005 Jan anonymous Unknown 2005 Jan 3 3 Uppercase and foreign chars problems in searches
#c8c8c8 787 code closed 2004 Jun anonymous Unknown 2005 Jan 4 4 Bad free() ignored (PERL_CORE)
#c8c8c8 1019 code closed 2004 Nov anonymous Unknown 2005 Jan 1 3 Improper handling of 8bit data
#c8c8c8 438 code closed 2003 Aug anonymous Unknown 2005 Jan 1 4 Minute function off between 11:16 and 11:20
#c8c8c8 418 code closed 2003 Jul anonymous Unknown 2005 Jan 4 4 sometimes web page returns error, hitting refresh makes it work
#c8c8c8 1055 code closed 2004 Dec anonymous Unknown 2005 Jan 3 3 Please archive files in PACKAGE-VERSION/ directory
#c8c8c8 1042 code closed 2004 Dec anonymous Unknown 2004 Dec 1 2 where does not work
#c8c8c8 1041 code closed 2004 Dec anonymous Unknown 2004 Dec 1 1 select x<2 from table does not work anymore
#c8c8c8 1037 code closed 2004 Dec anonymous Unknown 2004 Dec 1 1 .Net Interop Problem
#c8c8c8 1028 new closed 2004 Dec anonymous Unknown 2004 Dec 2 2 Without COPY: need alt. method to import data (not .import)
#c8c8c8 1023 new closed 2004 Nov anonymous Unknown 2004 Dec 4 4 don't link against pthreads if not configured with --enable-threadsafe
#c8c8c8 1017 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 1 1 error while loading shared libraries: /lib/libsqlite.so.0
#c8c8c8 1013 build closed 2004 Nov anonymous Unknown 2004 Nov peter 1 1 undefined reference to sqlite_open
#c8c8c8 935 code closed 2004 Sep anonymous Unknown 2004 Nov 4 4 several crash.test tests fail (spuriously) when [sqlite3 -has-codec]
#c8c8c8 728 code closed 2004 May anonymous Unknown 2004 Nov anonymous 4 3 .schema table fails if followed by a semicolon
#c8c8c8 753 code closed 2004 Jun anonymous Unknown 2004 Nov drh 4 4 view always report numeric as data type
#c8c8c8 986 code closed 2004 Nov anonymous Unknown 2004 Nov 3 4 indexed "between" is slower than manually typing out constraints
#c8c8c8 958 code closed 2004 Oct anonymous Unknown 2004 Nov drh 3 2 sqlite3_create_function() dose not really delete an user function
#c8c8c8 977 code closed 2004 Oct anonymous Unknown 2004 Nov 3 3 View Bug
#c8c8c8 992 code closed 2004 Nov anonymous Unknown 2004 Nov 3 3 sqliteStrRealloc: Return early under malloc failure.
#c8c8c8 989 code closed 2004 Nov anonymous Unknown 2004 Nov 3 3 Followup to #984, same issue with hexToInt
#c8c8c8 994 code closed 2004 Nov anonymous Unknown 2004 Nov 3 3 Brackets in JOIN statements break
. SELECT syntax
#c8c8c8 996 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 2 4 Error in primary key fields for temp tables
#c8c8c8 1000 code closed 2004 Nov anonymous Unknown 2004 Nov anonymous 1 1 use popen function and sqlite3_open is dummy..
#c8c8c8 1009 code closed 2004 Nov anonymous Unknown 2004 Nov 3 3 sqlite3RunVacuum: "forever" loop exists in error code path.
#c8c8c8 1005 code closed 2004 Nov anonymous Unknown 2004 Nov 1 1 No error from sqlite3_exec
#c8c8c8 998 event closed 2004 Nov anonymous Unknown 2004 Nov anonymous 2 1 Database table is locked accessing SQLite through QT library.
#c8c8c8 988 code closed 2004 Nov anonymous Unknown 2004 Nov 4 4 column type "int primary key" doesn't autoincrement
#c8c8c8 968 code closed 2004 Oct anonymous Unknown 2004 Oct anonymous 5 5 Access overrun (sometimes) with use of SELECT DISTINCT
#c8c8c8 963 code closed 2004 Oct anonymous Unknown 2004 Oct 3 3 PRIMARY KEY
#c8c8c8 729 new closed 2004 May anonymous Unknown 2004 Oct 5 3 Support wiki-style bulleted lists in tickets
#c8c8c8 951 code closed 2004 Oct anonymous Unknown 2004 Oct 1 1 DBD telling me table doesnt exist
#c8c8c8 952 code closed 2004 Oct anonymous Unknown 2004 Oct 1 2 Serious memory leak for insert into table with primary key
#c8c8c8 909 code closed 2004 Sep anonymous Unknown 2004 Oct 1 1 Inconsistent unordered and ordered selects (index corruption?)
#c8c8c8 950 new closed 2004 Oct anonymous Unknown 2004 Oct 2 4 No access to sqlite3ErrStr and sqlite3_temp_directory
#c8c8c8 949 new closed 2004 Oct anonymous Unknown 2004 Oct 3 3 add user-level test for file validity
#c8c8c8 945 code closed 2004 Oct anonymous Unknown 2004 Oct 2 2 sqlite3 opens sqlite2 databases without complaining
#c8c8c8 941 code closed 2004 Oct anonymous Unknown 2004 Oct 2 3 Updates are not atomic with respect to unique constraints
#c8c8c8 906 code closed 2004 Sep anonymous Unknown 2004 Oct anonymous 3 3 Wrong error code returned when there's not enough disk space available
#c8c8c8 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
#c8c8c8 920 code closed 2004 Sep anonymous Unknown 2004 Sep anonymous 3 3 group by without having not supported
#c8c8c8 861 code closed 2004 Aug anonymous Unknown 2004 Sep anonymous 1 1 SqLite is accent-sensitive?
#c8c8c8 876 code closed 2004 Aug anonymous Unknown 2004 Aug 1 3 select from ... where ... or ... is dead slow on indexed column
#c8c8c8 775 code closed 2004 Jun anonymous Unknown 2004 Aug 1 1 windows sqlite3.dll corrupt?
#c8c8c8 858 code closed 2004 Aug anonymous Unknown 2004 Aug 2 3 core dump when peforming bind
#c8c8c8 854 code closed 2004 Aug anonymous Unknown 2004 Aug anonymous 3 1 Index don't work with NULL field
#c8c8c8 835 doc closed 2004 Jul anonymous Unknown 2004 Aug 4 4 Locks reference on the FAQ - Read while writing?
#c8c8c8 750 code closed 2004 May anonymous Unknown 2004 Jul 2 3 copy command does not work with existing table
#c8c8c8 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
#c8c8c8 808 code closed 2004 Jul anonymous Unknown 2004 Jul 1 1 Lower() function with UNICODE
#c8c8c8 799 build closed 2004 Jul anonymous Unknown 2004 Jul 5 4 Missing exports in 3.0.2 Win32 DLL
#c8c8c8 803 new closed 2004 Jul anonymous Unknown 2004 Jul drh 1 1 sqlite3_create_function needs a userdata parameter
#c8c8c8 781 code closed 2004 Jun anonymous Unknown 2004 Jun 4 4 unable to run malloc test even with -DMEMORY_DEBUG
#c8c8c8 773 code closed 2004 Jun anonymous Unknown 2004 Jun 3 4 user-defined sql function called unexpected number of times
#c8c8c8 761 todo closed 2004 Jun anonymous Unknown 2004 Jun 5 5 the current sqlite_source.zip is 2.8.13, not 2.8.14
#c8c8c8 759 event closed 2004 Jun anonymous Unknown 2004 Jun a.rottmann 2 1 record can't be inserted
#c8c8c8 715 code closed 2004 Apr anonymous Unknown 2004 Apr 2 3 reference counted file locking attempts to unlock on different thread
#c8c8c8 706 build closed 2004 Apr anonymous Unknown 2004 Apr 1 1 undefined reference
#c8c8c8 694 code closed 2004 Apr anonymous Unknown 2004 Apr 3 4 uninitialised or unaddressable byte(s) in os.c
#c8c8c8 672 warn closed 2004 Mar anonymous Unknown 2004 Mar 1 1 THE DLL FILE FOR WINDOWS IS CURRUPTED
#c8c8c8 657 code closed 2004 Mar anonymous Unknown 2004 Mar 1 1 Wrong reported columncount in CallBack routine
#c8c8c8 653 code closed 2004 Mar anonymous Unknown 2004 Mar 1 1 sqlite db 'create table t(f)' dumps core
#c8c8c8 643 code closed 2004 Mar anonymous Unknown 2004 Mar 3 2 local variable 'db' used without having been initialized
#c8c8c8 636 new closed 2004 Mar anonymous Unknown 2004 Mar 1 1 Retaining autoincrement (Primary key) generated values
#c8c8c8 499 code closed 2003 Nov anonymous Unknown 2004 Feb 1 3 dot in table name and in column name makes full_column_names unusable
#c8c8c8 618 code closed 2004 Feb anonymous Unknown 2004 Feb 3 3 fails test btree-1.1.1
#c8c8c8 597 code closed 2004 Feb anonymous Unknown 2004 Feb 3 2 SELECT * FROM TB_LINFPSP_CONFIG WHERE LINFPSP_CUST_CODE='HBC'
#c8c8c8 571 code closed 2004 Jan anonymous Unknown 2004 Jan 1 1 Execution of comment via sqlite_step raise Access violation
#c8c8c8 562 code closed 2004 Jan anonymous Unknown 2004 Jan 2 3 System needs to rename duplicate named columns.
#c8c8c8 559 code closed 2004 Jan anonymous Unknown 2004 Jan 1 1 Very slow insert into ... under Win2K
#c8c8c8 557 code closed 2004 Jan anonymous Unknown 2004 Jan 3 1 sqlite_close SQLITE_MAGIC_ERROR reply.
#c8c8c8 554 code closed 2004 Jan anonymous Unknown 2004 Jan 3 1 sqlite_close SQLITE_MAGIC_ERROR
#c8c8c8 535 code closed 2003 Dec anonymous Unknown 2003 Dec 1 1 Use of uninitialised value of size 4
#c8c8c8 161 code closed 2002 Oct anonymous Unknown 2003 Dec 1 1 Left join with 3 tables bug ?
#c8c8c8 528 code closed 2003 Dec anonymous Unknown 2003 Dec 4 2 compiled c code shows queries in executable
#c8c8c8 423 code closed 2003 Aug anonymous Unknown 2003 Dec 1 1 'data schema has been changed error' how will overcome this
#c8c8c8 422 code closed 2003 Aug anonymous Unknown 2003 Dec 4 1 Memory leak in src/build.c
#c8c8c8 522 code closed 2003 Dec anonymous Unknown 2003 Dec 1 1 Error in comparision equal and less-equal
#c8c8c8 507 code closed 2003 Nov anonymous Unknown 2003 Nov 2 4 string comparison in where-clause of select
#c8c8c8 497 new closed 2003 Nov anonymous Unknown 2003 Nov 3 3 not able to escape quotes
#c8c8c8 248 code closed 2003 Feb anonymous Unknown 2003 Nov 1 2 SQLColumn function in ODBC returns incorrect datatype
#c8c8c8 201 doc closed 2002 Dec anonymous Unknown 2003 Nov 1 1 it is very well if there is a table lock! but ...
#c8c8c8 115 new closed 2002 Jul anonymous Unknown 2003 Nov 1 5 table_info() missing datatypes
#c8c8c8 492 code closed 2003 Nov anonymous Unknown 2003 Nov 2 4 database image is malformed
#c8c8c8 474 code closed 2003 Oct anonymous Unknown 2003 Oct 4 1 Problem with showing the datatypes of columns of a empty table
#c8c8c8 467 code closed 2003 Sep anonymous Unknown 2003 Oct 2 1 Problem with renaming fields
#c8c8c8 437 code closed 2003 Aug anonymous Unknown 2003 Aug 3 3 Wrong order for results of SELECT
#c8c8c8 417 code closed 2003 Jul anonymous Unknown 2003 Aug 4 4 Resultset differs between ..LIMIT 20 OFFSET 100 and ..LIMIT 20, 100
#c8c8c8 382 code closed 2003 Jul Unknown 2003 Jul 2 2 Triggers stop firing under certain situations
#c8c8c8 388 code closed 2003 Jul anonymous Unknown 2003 Jul 2 1 sqlite-2.8.4.tar.gz doesn't have the Constants.java file
#c8c8c8 380 code closed 2003 Jul anonymous Unknown 2003 Jul 2 2 "uniqueness constraint failed" on insertion of distinct rows
#c8c8c8 261 code closed 2003 Mar anonymous Unknown 2003 Jul 2 3 Non Callback Finalize Bug
#c8c8c8 372 event closed 2003 Jul anonymous Unknown 2003 Jul anonymous 1 1 tcl.h missing in windows source code
#c8c8c8 358 code closed 2003 Jun anonymous Unknown 2003 Jun 1 1 Problems with inserting file (.bmp; .jpg) in BLOB field
#c8c8c8 328 code closed 2003 May anonymous Unknown 2003 May 2 1 Trigger accessing temp table now does not work
#c8c8c8 329 code closed 2003 May anonymous Unknown 2003 May 3 3 sqlite_get_table() returns 1 row when there should be none
#c8c8c8 319 code closed 2003 May anonymous Unknown 2003 May 1 1 Large Encoded Strings Get Truncated
#c8c8c8 314 event closed 2003 May anonymous Unknown 2003 May 4 4 Memory usage
#c8c8c8 274 code closed 2003 Mar anonymous Unknown 2003 Apr 2 3 bug in sqlite_free_table
#c8c8c8 267 code closed 2003 Mar anonymous Unknown 2003 Mar anonymous 1 4 sqlite.dll / sqlite.def does not export an Init function
#c8c8c8 214 code closed 2003 Jan anonymous Unknown 2003 Jan 1 1 segmentation fault on ETRAX board - started in version 2.7.4
#c8c8c8 127 event closed 2002 Jul anonymous Unknown 2003 Jan 4 5 testfixture crashes with bus error following misuse-5.3 test
#c8c8c8 228 event closed 2003 Jan anonymous Unknown 2003 Jan drh 1 1 The size of database file is not decreased .
#c8c8c8 182 event closed 2002 Oct anonymous Unknown 2002 Oct 1 1 Win32 DBI Interface crashes Perl.exe
#c8c8c8 181 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 5 5 MAX Function on NULL Values
#c8c8c8 162 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 3 2 mismatch in response column and Group by column is ignored
#c8c8c8 158 code closed 2002 Oct anonymous Unknown 2002 Oct 3 2 Union doesn't check for data types
#c8c8c8 157 code closed 2002 Oct anonymous Unknown 2002 Oct anonymous 3 2 Doesn't check for data types
#c8c8c8 156 code closed 2002 Oct anonymous Unknown 2002 Oct 1 1 Cannot log in to CVSTraq because no "create account page"
#c8c8c8 124 code closed 2002 Jul anonymous Unknown 2002 Sep anonymous 2 1 Segfault on a join using an INTEGER PRIMARY KEY.
#c8c8c8 114 code closed 2002 Jul anonymous Unknown 2002 Sep 2 3 Concurrency problem in sqlite_open when automatic upgrading
#c8c8c8 110 new closed 2002 Jul anonymous Unknown 2002 Sep anonymous 5 4 Refuse multiple begin transaction or commit
#c8c8c8 149 new closed 2002 Sep anonymous Unknown 2002 Sep 5 4 SELECT UNIQUE
#c8c8c8 148 code closed 2002 Sep anonymous Unknown 2002 Sep anonymous 3 3 sqlHashFind() segfaults in a created function
#c8c8c8 145 code closed 2002 Aug anonymous Unknown 2002 Aug 1 1 Tests failing
#c8c8c8 144 new closed 2002 Aug anonymous Unknown 2002 Aug 4 3 Read/Write Locks under Windows NT/2000/XP (simul. access)
#c8c8c8 143 code closed 2002 Aug anonymous Unknown 2002 Aug anonymous 1 3 order by and null columns
#c8c8c8 141 code closed 2002 Aug anonymous Unknown 2002 Aug 1 3 Using the incorrect format inhibits record update
#c8c8c8 1505 code closed 2005 Nov anonymous TclLib 2005 Nov 2 3 Sqlite3 tcl bindings return "{}" instead of {} for the empty result
#c8c8c8 1230 event closed 2005 Apr anonymous TclLib 2005 May 1 1 coredump in tclsqlite on HPUX 11.11 64 bit
#c8c8c8 1179 code closed 2005 Mar anonymous TclLib 2005 Mar 2 1 Unable to use NULL for an AUTOINCREMENT field in TclSQLite
#c8c8c8 696 code closed 2004 Apr anonymous TclLib 2005 Jan 1 1 tclsqlite does not build on RH 7.3
#c8c8c8 1067 code closed 2005 Jan anonymous TclLib 2005 Jan anonymous 2 4 Tcl parsing failure in SQL statement DELETE?
#c8c8c8 547 code closed 2004 Jan anonymous TclLib 2005 Jan 3 4 tcl array not cleared between queries
#c8c8c8 967 event closed 2004 Oct anonymous TclLib 2004 Oct 3 2 PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so
#c8c8c8 795 new closed 2004 Jul anonymous TclLib 2004 Oct 5 3 Separate TCL library from libsqlite3
#c8c8c8 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
#c8c8c8 671 build closed 2004 Mar anonymous TclLib 2004 Mar 4 4 Missing tcl.h from /src
#c8c8c8 170 code closed 2002 Oct anonymous TclLib 2002 Oct anonymous 2 2 Insert / select text with cp1250 characters
#c8c8c8 1545 build closed 2005 Nov anonymous Shell 2007 Feb 4 4 Solaris systems require -lrt to link sqlite3
#c8c8c8 1891 code closed 2006 Jul anonymous Shell 2006 Jul pweilbacher 4 4 OS/2 may not have access to C:\ drive
#c8c8c8 1868 code closed 2006 Jun anonymous Shell 2006 Jun 4 4 where a = b = c
#c8c8c8 1724 code closed 2006 Mar anonymous Shell 2006 Mar anonymous 1 1 sqlite doesn't work with "cifs-mounted-directories"
#c8c8c8 1673 code closed 2006 Feb anonymous Shell 2006 Feb 3 3 constraint using "in" -- bug 1645 revisited
#c8c8c8 1668 event closed 2006 Feb anonymous Shell 2006 Feb drh 2 3 datetime modifiers "enf of *" and "group * by" do not work
#c8c8c8 1659 event closed 2006 Feb anonymous Shell 2006 Feb anonymous 1 2 Sqlite.exe .import stopped working in latest 3.3.3 release (Win32)
#c8c8c8 1582 code closed 2006 Jan anonymous Shell 2006 Jan anonymous 1 1 the sqlite328.exe generates Application error -memory cold not be read
#c8c8c8 1579 code closed 2006 Jan anonymous Shell 2006 Jan anonymous 1 1 database locked
#c8c8c8 1574 event closed 2005 Dec anonymous Shell 2005 Dec 1 3 corrupt database due to .dump process
#c8c8c8 1523 code closed 2005 Nov anonymous Shell 2005 Nov danielk1977 5 1 size of database dose not change smaller after delete records
#c8c8c8 1450 code closed 2005 Sep anonymous Shell 2005 Sep 1 1 Unable to compile on SCO Openserver(gcc)
#c8c8c8 1411 code closed 2005 Sep anonymous Shell 2005 Sep anonymous 3 1 how to change database name
#c8c8c8 589 new closed 2004 Jan anonymous Shell 2005 Sep 5 4 HTML tags in shell.c should be lower case
#c8c8c8 1369 new closed 2005 Aug anonymous Shell 2005 Aug drh 5 5 Inefficient restoration of indexed dumps
#c8c8c8 1367 new closed 2005 Aug anonymous Shell 2005 Aug peter 1 1 connection string for SQLite with some examples
#c8c8c8 1330 code closed 2005 Jul anonymous Shell 2005 Aug 2 5 The internal function max doesn't work properly
#c8c8c8 1333 code closed 2005 Jul anonymous Shell 2005 Jul 2 3 sqlite3 command line interfaces segfaults when getpwd() fails
#c8c8c8 1148 new closed 2005 Feb anonymous Shell 2005 Mar 5 5 patch to print query execute time on shell.c
#c8c8c8 1132 code closed 2005 Feb anonymous Shell 2005 Feb 1 1 database migration from sqlite 2.8.12 to sqlite 3.0.8
#c8c8c8 1089 code closed 2005 Jan anonymous Shell 2005 Jan 1 1 Segmentation fault
#c8c8c8 1077 code closed 2005 Jan anonymous Shell 2005 Jan 1 1 auto_increment and insert into ~ select
#c8c8c8 402 code closed 2003 Jul anonymous Shell 2005 Jan anonymous 2 3 linebreake
#c8c8c8 1073 code closed 2005 Jan anonymous Shell 2005 Jan 2 3 Windows Shell: .read commands need '/' in filenames to work
#c8c8c8 1071 code closed 2005 Jan anonymous Shell 2005 Jan 4 3 Typo in .help
#c8c8c8 894 code closed 2004 Sep anonymous Shell 2004 Sep 3 3 COUNT does not work with DISTINCT SUBSTR
#c8c8c8 649 code closed 2004 Mar anonymous Shell 2004 Mar 1 1 sqlite-2.8.12 segmentation fault in shell command-line usage
#c8c8c8 642 code closed 2004 Mar anonymous Shell 2004 Mar 1 1 Problem when adding a SQL string on the command line - THIS IS REAL!!
#c8c8c8 631 code closed 2004 Feb anonymous Shell 2004 Feb 2 3 command line SQL paramater doesn't work on windows pre-compiled binary
#c8c8c8 527 code closed 2003 Dec anonymous Shell 2004 Feb 3 3 Sqlite shell: lack of checks
#c8c8c8 549 code closed 2004 Jan anonymous Shell 2004 Jan 1 1 number of week change in wendesday/thursday
#c8c8c8 431 new closed 2003 Aug anonymous Shell 2003 Aug 5 4 possibility to use sql scripts in a file on the command line
#c8c8c8 389 event closed 2003 Jul anonymous Shell 2003 Jul 1 1 Undefined symbol
#c8c8c8 392 event closed 2003 Jul anonymous Shell 2003 Jul anonymous 1 1 Unable to link libsqlite.so file on SunOS 5.8
#c8c8c8 390 code closed 2003 Jul anonymous Shell 2003 Jul 3 4 database creation
#c8c8c8 304 code closed 2003 May anonymous Shell 2003 May 3 3 DELETE on read-only db reporting error inconsistently
#c8c8c8 167 new closed 2002 Oct anonymous Shell 2002 Dec 5 4 Difficult to quickly quit sqlite
#c8c8c8 64 code closed 2002 Jun danielk1977 Shell 2002 Sep 5 5 TEMP tables in a read-only db using the shell tool
#c8c8c8 21 code closed 2002 Apr anonymous Shell 2002 May 1 1 2.4.8 SQLITE.EXE: out of memory! (Windows98)
#c8c8c8 4 new closed 2002 Mar persicom Shell 2002 May 2 3 Change prompt of 'sqlite' query tool.
#c8c8c8 1973 code closed 2006 Sep anonymous Parser 2006 Nov 1 2 sqlite3_prepare (DLL 3.3.7) exception in two programs
#c8c8c8 1988 code closed 2006 Sep anonymous Parser 2006 Sep 2 2 linker error wih SQLITE_OMIT_VIRTUALTABLE
#c8c8c8 1952 code closed 2006 Sep anonymous Parser 2006 Sep 2 2 Memory leak in select with duplicate colum names
#c8c8c8 1922 code closed 2006 Aug anonymous Parser 2006 Aug 1 1 field name with space can not be specified as primary key
#c8c8c8 1881 code closed 2006 Jul anonymous Parser 2006 Jul anonymous 2 1 error in inserting strings with single quotes
#c8c8c8 1826 code closed 2006 May anonymous Parser 2006 May anonymous 4 4 Select unused table in from clause produces no results
#c8c8c8 1734 code closed 2006 Mar anonymous Parser 2006 Mar drh 5 5 when not null is before integer primary key, syntax error occurs
#c8c8c8 1557 event closed 2005 Dec anonymous Parser 2006 Mar 1 1 sqlite core dumps in exprNodeIsConstant
#c8c8c8 1694 code closed 2006 Feb anonymous Parser 2006 Feb 3 3 SELECT count(distinct vnum) FROM table generates syntax error.
#c8c8c8 1530 code closed 2005 Nov anonymous Parser 2005 Nov xdong 2 1 error on where clause with serial-type.
#c8c8c8 1442 code closed 2005 Sep anonymous Parser 2005 Sep 1 1 sqlite3 3.2.6/3.2.2/3.2.1 reproductible crash
#c8c8c8 1408 code closed 2005 Sep anonymous Parser 2005 Sep 1 1 ATTACH DATABASE doesn't support *.db files
#c8c8c8 1341 code closed 2005 Jul anonymous Parser 2005 Aug 3 2 sqlite_exec() returns always 1 on error
#c8c8c8 1141 code closed 2005 Feb anonymous Parser 2005 Apr 4 1 Select rowid for integer primary key does not return rowid
#c8c8c8 1147 code closed 2005 Feb anonymous Parser 2005 Apr 1 1 column names do not respect pragma settings
#c8c8c8 1174 build closed 2005 Mar anonymous Parser 2005 Mar 4 4 Link problem using SQLITE_OMIT_xxx
#c8c8c8 1125 code closed 2005 Feb anonymous Parser 2005 Mar 1 2 Syntax error: create index with table name qualified by database name
#c8c8c8 1150 code closed 2005 Feb anonymous Parser 2005 Feb 4 4 'insert' is not a legal transaction name
#c8c8c8 1119 code closed 2005 Feb anonymous Parser 2005 Feb 4 3 Field name interpreted as SQL command. (GROUP)
#c8c8c8 1110 code closed 2005 Feb anonymous Parser 2005 Feb 4 4 Detection of invalid create table statement
#c8c8c8 1101 code closed 2005 Feb anonymous Parser 2005 Feb 3 3 uninitialized memory copy in yy_shift (in win32 version of parse.c)
#c8c8c8 1087 event closed 2005 Jan anonymous Parser 2005 Jan 5 1 CREATE TRIGGER with SQLite3 --> Error "near "WHEN" : syntaxe error
#c8c8c8 443 new closed 2003 Sep anonymous Parser 2005 Jan anonymous 3 3 LIKE ... should support ESCAPE as per SQL spec
#c8c8c8 970 code closed 2004 Oct anonymous Parser 2005 Jan 2 3 Crush in authorization procedure
#c8c8c8 1006 new closed 2004 Nov anonymous Parser 2004 Nov 4 3 Creation of sqlite3_exec16 ?
#c8c8c8 820 code closed 2004 Jul anonymous Parser 2004 Oct 4 4 problem with sqlite3_prepare and variables
#c8c8c8 929 code closed 2004 Sep anonymous Parser 2004 Sep 2 1 Inserting duplicate primary key value returns success
#c8c8c8 849 code closed 2004 Aug anonymous Parser 2004 Sep 1 1 error(1) for Statement "PRAGMA table_info(?)"
#c8c8c8 884 new closed 2004 Sep anonymous Parser 2004 Sep 5 1 Allow read only transactions.
#c8c8c8 882 code closed 2004 Sep anonymous Parser 2004 Sep 1 1 crash on insert
#c8c8c8 874 code closed 2004 Aug anonymous Parser 2004 Aug 2 3 Inconsistent treatment of quoted strings: "x" vs 'x'
#c8c8c8 846 code closed 2004 Aug anonymous Parser 2004 Aug 1 1 error(1) at dbdimp.c line 250 [for Statement "PRAGMA table_info(?)"]
#c8c8c8 650 new closed 2004 Mar anonymous Parser 2004 Mar 4 4 DISTINCT aggregates
#c8c8c8 629 code closed 2004 Feb anonymous Parser 2004 Feb 3 3 Variable used without having been initialized
#c8c8c8 581 code closed 2004 Jan anonymous Parser 2004 Jan 3 1 Failure for lemon.c to compile on MacOSX (fixed as well ;-))
#c8c8c8 532 code closed 2003 Dec anonymous Parser 2003 Dec 2 3 crashes on gigantic query
#c8c8c8 441 code closed 2003 Sep anonymous Parser 2003 Dec drh 1 1 Cannot find table under Managed C++
#c8c8c8 516 code closed 2003 Dec anonymous Parser 2003 Dec 1 1 unrecognized token error when a string contains a \' escape sequence
#c8c8c8 512 code closed 2003 Dec anonymous Parser 2003 Dec 2 2 order by clause is not ordering data properly in aggregate functions
#c8c8c8 471 code closed 2003 Oct anonymous Parser 2003 Oct 5 1 Parser accepts faulty SQL
#c8c8c8 343 new closed 2003 Jun anonymous Parser 2003 Jun 3 1 insert single quote value in SQL statement
#c8c8c8 325 code closed 2003 May anonymous Parser 2003 May 3 3 Memory Leak with a cancelled sqlite_exec() using a callback routine
#c8c8c8 283 code closed 2003 Apr anonymous Parser 2003 Apr 3 1 Defect in sqlite_exec_vprintf
#c8c8c8 265 new closed 2003 Mar anonymous Parser 2003 Mar drh 2 3 SQLITE does not like prefixed columns
#c8c8c8 89 new closed 2002 Jun chw Parser 2002 Sep 1 4 table aliases broken
#c8c8c8 3 code closed 2002 Mar anonymous Parser 2002 May 1 1 Rejects "view" as column name
#c8c8c8 1686 code closed 2006 Feb anonymous Pager 2006 Feb 2 4 File locking and concurrency problems under Windows
#c8c8c8 1352 code closed 2005 Aug anonymous Pager 2005 Aug 3 3 Databases created via ATTACH do not respect page_size pragma
#c8c8c8 1276 code closed 2005 Jun anonymous Pager 2005 Jun 1 1 Failing assertion in pager.c
#c8c8c8 1265 new closed 2005 May anonymous Pager 2005 May 3 3 10% speed improvement for huge inserts
#c8c8c8 964 code closed 2004 Oct anonymous Pager 2004 Oct 3 1 Possible segfault from bad call
#c8c8c8 887 code closed 2004 Sep anonymous Pager 2004 Sep 3 2 Unable to recover from SQLITE_FULL error until DB file is reopened
#c8c8c8 628 code closed 2004 Feb anonymous Pager 2004 Feb 1 3 Assertion failure in syncJournal
#c8c8c8 553 code closed 2004 Jan anonymous Pager 2004 Jan 2 2 conversion error in compiling pager.c
#c8c8c8 546 code closed 2004 Jan anonymous Pager 2004 Jan 3 3 (Program received signal SIGSEGV) when sqlite_open()
#c8c8c8 536 code closed 2003 Dec anonymous Pager 2003 Dec 1 1 Syscall param write(buf) contains unaddressable byte(s)
#c8c8c8 374 code closed 2003 Jul anonymous Pager 2003 Jul 1 1 btree crash in moveto - sqlitepager_get
#c8c8c8 94 code closed 2002 Jul drh Pager 2002 Sep 1 1 ROLLBACK fails to restore all pages
#c8c8c8 1160 code closed 2005 Mar anonymous CodeGen 2005 Mar 4 4 GROUP BY is broken
#c8c8c8 1064 code closed 2005 Jan anonymous CodeGen 2005 Jan 2 1 problems with queries and aggregate functions
#c8c8c8 287 new closed 2003 Apr anonymous CodeGen 2005 Jan drh 3 2 query execution time depend from tables order in FROM clause
#c8c8c8 942 code closed 2004 Oct anonymous CodeGen 2004 Oct 1 2 Horrible time complexity for certain triple joins.
#c8c8c8 681 build closed 2004 Apr anonymous CodeGen 2004 Apr 1 1 undefined reference to 'sqlite_open'
#c8c8c8 556 warn closed 2004 Jan anonymous CodeGen 2004 Jan 3 4 double to int warnings in date.c
#c8c8c8 105 code closed 2002 Jul anonymous CodeGen 2002 Sep 2 1 Assertion fails on UPDATE of indexed table with subquery in WHERE
#c8c8c8 95 code closed 2002 Jul drh CodeGen 2002 Sep 1 1 DROP INDEX on an automatically created internal index is allowed
#c8c8c8 78 code closed 2002 Jun drh CodeGen 2002 Sep 1 1 Assertion failure when closing database in the middle of a transaction
#c8c8c8 75 code closed 2002 Jun drh CodeGen 2002 Sep 1 1 Auto-increment not working on an INSERT from a SELECT
#c8c8c8 73 code closed 2002 Jun drh CodeGen 2002 Sep drh 1 1 ORDER BY clause is ignored on subqueries
#c8c8c8 63 new closed 2002 Jun drh CodeGen 2002 Sep 3 3 Add optimizations for "WHERE rowid IN (SELECT...)"
#c8c8c8 49 code closed 2002 May drh CodeGen 2002 Sep 2 1 DELETE Trigger causes extra rows to be deleted
#c8c8c8 46 code closed 2002 May drh CodeGen 2002 Sep 3 2 CREATE TABLE accepts duplicate column names
#c8c8c8 35 code closed 2002 May drh CodeGen 2002 Sep 1 1 An ORDER BY clause on a subquery causes a segfault
#c8c8c8 34 code closed 2002 May drh CodeGen 2002 Sep 1 1 Segfault when a VIEW contains an ORDER BY clause
#c8c8c8 33 code closed 2002 May drh CodeGen 2002 Sep 1 1 Segfault when a VIEW contains a compound SELECT with an ORDER BY
#c8c8c8 31 code closed 2002 Apr danielk1977 CodeGen 2002 Sep 4 4 SELECT without FROM
#c8c8c8 51 doc closed 2002 May danielk1977 CodeGen 2002 May danielk1977 5 3 Triggers problem with INTEGER PRIMARY KEY
#c8c8c8 16 code closed 2002 Apr anonymous CodeGen 2002 May 2 2 sqlite cores
#c8c8c8 15 code closed 2002 Apr anonymous CodeGen 2002 May 5 4 getting the number of affected lines is harder than necessary
#c8c8c8 11 code closed 2002 Apr drh CodeGen 2002 May 1 1 Wrong number of inserts reported after an IGNORE
#c8c8c8 8 code closed 2002 Apr danielk1977 CodeGen 2002 May 2 1 More problems with where.c
#c8c8c8 6 code closed 2002 Apr danielk1977 CodeGen 2002 May 1 1 Query optimizer does not consider function arguments
#c8c8c8 2 new closed 2002 Mar drh CodeGen 2002 May 2 3 Add support for TABLE.* in a query
#c8c8c8 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?
#c8c8c8 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)
#c8c8c8 1594 code closed 2006 Jan anonymous BTree 2006 Jan danielk1977 2 2 Schema pointer is freed twice
#c8c8c8 1421 code closed 2005 Sep anonymous BTree 2005 Sep 2 2 Assertion when I try to create a index
#c8c8c8 1344 code closed 2005 Jul anonymous BTree 2005 Aug anonymous 3 1 sqlite does 40 times allocations for a single sql statement
#c8c8c8 1329 code closed 2005 Jul anonymous BTree 2005 Jul 5 1 A bug About select from a table
#c8c8c8 1233 code closed 2005 May anonymous BTree 2005 May 1 1 Triggers assert
#c8c8c8 1231 code closed 2005 May anonymous BTree 2005 May 1 1 Solaris9: Bus error, alignment issues
#c8c8c8 1109 code closed 2005 Feb anonymous BTree 2005 Feb 1 1 assert in btree
#c8c8c8 978 code closed 2004 Oct anonymous BTree 2004 Oct anonymous 3 3 bug in sql_step related to INTEGER PRIMARY INDEX values.
#c8c8c8 889 event closed 2004 Sep anonymous BTree 2004 Sep anonymous 1 2 btree.c with new malloc
#c8c8c8 863 code closed 2004 Aug anonymous BTree 2004 Sep 2 2 Stack overflow in the btree.c module
#c8c8c8 821 code closed 2004 Jul anonymous BTree 2004 Jul 3 3 Allows string data on indexes INTEGER fields
#c8c8c8 740 code closed 2004 May anonymous BTree 2004 May 1 1 Unable to compile on Fedora core 1
#c8c8c8 436 code closed 2003 Aug drh BTree 2003 Aug drh 1 1 In-memory database backend segfaults on recursive access
#c8c8c8 376 code closed 2003 Jul anonymous BTree 2003 Aug 2 3 btree-1.1.1...../src/btree.c:2687: failed assertion `pPage->isInit'
#c8c8c8 196 code closed 2002 Nov anonymous BTree 2003 Jul 4 3 there are the same record in a table,why?
#c8c8c8 9 new closed 2002 Apr anonymous BTree 2002 Sep 1 3 platform-independent db files
#c8c8c8 19 new closed 2002 Apr danielk1977 BTree 2002 May 3 4 synchronous pragma does not effect TEMP tables
#c8c8c8 1268 build closed 2005 May anonymous 2017 Apr 1 1 /usr/include/sys/context.h:155: parse error before "sigset64_t"
#c8c8c8 2910 new closed 2008 Jan anonymous 2008 Jan 1 2 Number of rows in result set - new API
#c8c8c8 2906 code closed 2008 Jan anonymous 2008 Jan anonymous 2 2 Error in MSVC v.6.0 (optimization: Maximize Speed mode)
#c8c8c8 2900 code closed 2008 Jan anonymous 2008 Jan 3 4 Can't ESCAPE in GLOB
#c8c8c8 2896 code closed 2008 Jan anonymous 2008 Jan 1 1 FTS3 misses document, but finds non-matching ones instead
#c8c8c8 2895 build closed 2008 Jan anonymous 2008 Jan 3 1 Please describe how to run an indvidual test out of the test suite
#c8c8c8 2890 build closed 2008 Jan anonymous 2008 Jan 1 1 Assistance request fixing six 3.5.4 i/o test failures
#c8c8c8 2891 code closed 2008 Jan anonymous 2008 Jan 2 3 col with "NOT NULL", no default: works on table create, not col add
#c8c8c8 2887 code closed 2008 Jan anonymous 2008 Jan anonymous 5 5 || not outputing correctly with empty fields
#c8c8c8 2888 code closed 2008 Jan anonymous 2008 Jan 3 4 statement not commited
#c8c8c8 2889 build closed 2008 Jan anonymous 2008 Jan 3 2 Cannot disable TCL
#c8c8c8 2876 build closed 2008 Jan anonymous 2008 Jan 1 1 3.5.4 fails to build on OpenBSD...
#c8c8c8 2871 build closed 2008 Jan anonymous 2008 Jan 3 3 SQLite 3.5.4 build process does not listen to --disable-tcl
#c8c8c8 2870 code closed 2008 Jan anonymous 2008 Jan danielk1977 5 5 Comment error
#c8c8c8 2868 code closed 2008 Jan anonymous 2008 Jan 1 1 Encryption user can't link latest SQLite
#c8c8c8 2862 warn closed 2007 Dec anonymous 2008 Jan 4 3 Small warning fix
#c8c8c8 2861 doc closed 2007 Dec anonymous 2008 Jan 1 1 How do I connect to Crystal Reports - I am using vs2003 & the Finisar
#c8c8c8 2858 build closed 2007 Dec anonymous 2008 Jan danielk1977 3 3 amalgamated sqlite3.c requires sqlite3ext.h
#c8c8c8 2855 code closed 2007 Dec anonymous 2007 Dec drh 2 3 Get an error "11:database disk image is malformed" during queries
#c8c8c8 2854 code closed 2007 Dec danielk1977 2007 Dec danielk1977 1 1 BEGIN EXCLUSIVE does not prevent other shared-cache users from reading
#c8c8c8 2848 code closed 2007 Dec anonymous 2007 Dec 4 4 windows CRLF is incorrectly handled by .dump
#c8c8c8 2804 code closed 2007 Nov anonymous 2007 Dec 1 1 PRAGMA legacy_file_format=OFF setting lost with VACUUM
#c8c8c8 2758 code closed 2007 Nov anonymous 2007 Dec 1 1 Why this?
#c8c8c8 2724 code closed 2007 Oct anonymous 2007 Dec drh 2 2 Load Ext api missing error_toobig function.
#c8c8c8 2717 doc closed 2007 Oct anonymous 2007 Dec anonymous 5 5 Document clarification around SQLITE_OMIT_MEMORY_ALLOCATION
#c8c8c8 2812 new closed 2007 Nov anonymous 2007 Dec 3 4 SQLITE_SECURE_DELETE overwrites with 0, but should use random data
#c8c8c8 2824 code closed 2007 Dec anonymous 2007 Dec 1 1 enable shared cache problem
#c8c8c8 2837 code closed 2007 Dec anonymous 2007 Dec 2 2 can't build testfixture in latest CVS
#c8c8c8 2836 build closed 2007 Dec anonymous 2007 Dec 1 1 Undefined symbol 'OP_StackDepth'
#c8c8c8 2830 code closed 2007 Dec anonymous 2007 Dec 5 5 tkt2822.test refers to tkt2820 ?
#c8c8c8 2834 event closed 2007 Dec anonymous 2007 Dec 2 1 Is Version 3.1.3 not compatible with 3.5.3 ?
#c8c8c8 2828 code closed 2007 Dec anonymous 2007 Dec 1 2 SQLITE_OMIT_SUBQUERY compile error: sqlite3CodeSubselect() missing.
#c8c8c8 2802 code closed 2007 Nov anonymous 2007 Dec 1 1 SELECT UNION and EXCEPT seem to have a memory allocation bug
#c8c8c8 2816 code closed 2007 Dec anonymous 2007 Dec drh 4 3 .timer missing from CLI
#c8c8c8 2823 code closed 2007 Dec anonymous 2007 Dec 1 1 query not return values
#c8c8c8 2819 code closed 2007 Dec anonymous 2007 Dec 2 1 Blocking and crashing
#c8c8c8 2818 code closed 2007 Dec anonymous 2007 Dec 2 4 Comparison of 8 bytes integer numbers is truncated
#c8c8c8 2817 code closed 2007 Dec danielk1977 2007 Dec danielk1977 1 1 Temp-tables with the same name as database tables can cause corruption
#c8c8c8 2798 build closed 2007 Nov anonymous 2007 Nov 3 4 Wrong nm used when cross-compiling
#c8c8c8 2777 code closed 2007 Nov anonymous 2007 Nov shess 1 1 FTS[23] compile bug
#c8c8c8 2773 code closed 2007 Nov danielk1977 2007 Nov 2 1 sqlite crashes in sqlite3_step when compiled with SQLITE_THREADS=1
#c8c8c8 2790 code closed 2007 Nov anonymous 2007 Nov danielk1977 2 2 sqlite3_compile returns NULL for empty statements
#c8c8c8 2782 code closed 2007 Nov anonymous 2007 Nov 1 1 bind_text(...) into transaction
#c8c8c8 2779 code closed 2007 Nov anonymous 2007 Nov 2 2 Performance optimizations
#c8c8c8 2778 code closed 2007 Nov anonymous 2007 Nov adixon 1 1 Error 0
#c8c8c8 2775 code closed 2007 Nov anonymous 2007 Nov danielk1977 3 4 Low-memory SEGV from sqlite3CodeRowTrigger()
#c8c8c8 2772 code closed 2007 Nov anonymous 2007 Nov danielk1977 3 3 Low memory assert in analyze
#c8c8c8 2769 new closed 2007 Nov anonymous 2007 Nov danielk1977 3 3 Enable access to the sql string used to prepare a statement
#c8c8c8 1813 new closed 2006 May anonymous 2007 Nov 2 3 select distinct doesn't take advantage of existing indexes
#c8c8c8 2744 code closed 2007 Oct drh 2007 Nov danielk1977 1 1 Cannot quote collating sequence name
#c8c8c8 2768 code closed 2007 Nov anonymous 2007 Nov danielk1977 3 3 asserts in wrong order
#c8c8c8 2765 code closed 2007 Nov anonymous 2007 Nov 1 3 bad rollback if temporary table created during transaction
#c8c8c8 2747 code closed 2007 Oct anonymous 2007 Nov maria.khomenko 1 1 How to use Composite Key in Sqlite
#c8c8c8 2764 todo closed 2007 Nov anonymous 2007 Nov 2 2 Since I installed Leopard I keep getting sqlite3 data bases in trash
#c8c8c8 2751 build closed 2007 Oct anonymous 2007 Nov 2 3 Regression - Solaris/sparc throws BUS ERROR on count()/sum()/etc.
#c8c8c8 2759 code closed 2007 Nov anonymous 2007 Nov danielk1977 1 2 crash due to 'select * from virtualTable where x is null'
#c8c8c8 2757 doc closed 2007 Nov anonymous 2007 Nov 1 1 Special characters handling in SQLite Like Query
#c8c8c8 1779 new closed 2006 Apr anonymous 2007 Nov 5 4 enhancement request (+ pointer) -- group_concat() aggregate function
#c8c8c8 2752 code closed 2007 Nov anonymous 2007 Nov 5 5 redundant assignment?
#c8c8c8 2750 code closed 2007 Oct anonymous 2007 Oct 2 1 for the new.somefield value returns the old value of it
#c8c8c8 2746 code closed 2007 Oct anonymous 2007 Oct 1 1 PRIMARY KEY does not treat NULL as unique
#c8c8c8 2745 code closed 2007 Oct anonymous 2007 Oct shazow 1 1 Sharing File between two processes
#c8c8c8 2743 doc closed 2007 Oct anonymous 2007 Oct 1 1 Comparison of SQLite against McObject Fusion
#c8c8c8 2742 code closed 2007 Oct anonymous 2007 Oct 1 1 codeInteger and codeReal
#c8c8c8 2731 code closed 2007 Oct anonymous 2007 Oct 1 1 sqlite3ExprCode TK_UMINUS inefficient with large negative floats
#c8c8c8 2663 code closed 2007 Sep anonymous 2007 Oct 3 3 Adding a column with default value not reflected in view
#c8c8c8 2735 code closed 2007 Oct anonymous 2007 Oct nmadhav 3 1 Error : Unrecognized Token
#c8c8c8 2734 code closed 2007 Oct anonymous 2007 Oct 3 1 2 bug under the wince
#c8c8c8 2730 code closed 2007 Oct anonymous 2007 Oct anonymous 3 2 Can't compile for WindowsCE
#c8c8c8 2679 code closed 2007 Sep anonymous 2007 Oct 2 3 locking errors lead to disk i/o failure with bulk operations on winxp
#c8c8c8 2726 code closed 2007 Oct anonymous 2007 Oct 4 3 solaris 10 compilation B_FALSE, B_TRUE clash from sys/types.h
#c8c8c8 2277 code closed 2007 Mar anonymous 2007 Oct 1 1 Incorrect usage of CRITICAL_SECTION and TLS on Windows
#c8c8c8 2490 code closed 2007 Jul anonymous 2007 Oct 1 1 Latest cvs 3.4.0 seg fault
#c8c8c8 2603 new closed 2007 Aug anonymous 2007 Oct 1 3 B-tree and B+tree allow bidirectional cursor but VDBE does not.
#c8c8c8 2657 build closed 2007 Sep anonymous 2007 Oct anonymous 1 1 fail to compile
#c8c8c8 2707 code closed 2007 Oct anonymous 2007 Oct appledev 1 3 SQLite on Mac OS X seems to have a 4GB database limit
#c8c8c8 2630 code closed 2007 Sep anonymous 2007 Oct a.rottmann 2 2 sqlite3PagerOpen set a wrong temp file name in pPager->zFilename
#c8c8c8 2723 new closed 2007 Oct anonymous 2007 Oct anonymous 5 4 After execution of SQL, the Data Returned should display the col.name
#c8c8c8 2720 code closed 2007 Oct anonymous 2007 Oct 1 1 WinCE - Can't write
#c8c8c8 2719 code closed 2007 Oct anonymous 2007 Oct 3 1 WinCE winFullPathName doesn't return a value
#c8c8c8 2718 build closed 2007 Oct anonymous 2007 Oct 2 1 WinCE compile error
#c8c8c8 2709 code closed 2007 Oct anonymous 2007 Oct 2 3 Some SQLITE_OMIT_* keys break the sqlite3.c amalgamation compilation
#c8c8c8 2712 code closed 2007 Oct anonymous 2007 Oct 5 4 Expose a function to change the journal filename location
#c8c8c8 2706 warn closed 2007 Oct anonymous 2007 Oct danielk1977 4 4 make test aborts when built with SQLITE_OMIT_ATTACH
#c8c8c8 2695 new closed 2007 Oct anonymous 2007 Oct drh 3 3 sqlite3 CLI unresolved externals with SQLITE_OMIT_GET_TABLE
#c8c8c8 2689 build closed 2007 Oct anonymous 2007 Oct 3 4 make test fails in 3.5.1 - unresolved externals in testfixture
#c8c8c8 2585 code closed 2007 Aug anonymous 2007 Oct anonymous 1 1 Error Function GetAtomNameA
#c8c8c8 2601 code closed 2007 Aug anonymous 2007 Oct 1 1 Problem with opening database with Unicode filename
#c8c8c8 2639 code closed 2007 Sep anonymous 2007 Oct 1 2 Russian charset
#c8c8c8 2692 build closed 2007 Oct anonymous 2007 Oct 1 1 COmpilation of Sqlite amalgamation v3.4.2. failed
#c8c8c8 2688 build closed 2007 Oct anonymous 2007 Oct 3 1 SQLITE_OMIT_AUTHORIZATION build failure
#c8c8c8 2691 code closed 2007 Oct anonymous 2007 Oct 1 1 SQLITE_OMIT_AUTHORIZATION compilation error
#c8c8c8 2690 code closed 2007 Oct anonymous 2007 Oct 3 4 "PRAGMA synchronous = OFF;" is more dangerous than documented
#c8c8c8 2519 new closed 2007 Jul anonymous 2007 Oct 1 1 Page cache and schema should be shared between all connections/threads
#c8c8c8 2656 doc closed 2007 Sep anonymous 2007 Oct 2 1 missing documentation: END TRANSACTION
#c8c8c8 2682 code closed 2007 Oct anonymous 2007 Oct 1 1 SQLite Text Problem
#c8c8c8 2668 code closed 2007 Sep anonymous 2007 Oct 3 4 Build failure due to syntax error under Cygwin
#c8c8c8 2670 doc closed 2007 Sep anonymous 2007 Oct 5 4 Document for EXPLAIN doesn't mention using EXPLAIN QUERY PLAN
#c8c8c8 2667 code closed 2007 Sep anonymous 2007 Oct 1 1 no such function: hex no such function: regexp
#c8c8c8 2654 code closed 2007 Sep anonymous 2007 Oct jadams 1 1 sqlite3_prepare return 1(fail)
#c8c8c8 2675 new closed 2007 Sep anonymous 2007 Sep 1 1 TEMP_STORE does not appear to be set by the compile time switch
#c8c8c8 2676 code closed 2007 Sep anonymous 2007 Sep 1 1 TEMP_STORE does not appear to be set by the compile time switch
#c8c8c8 2669 code closed 2007 Sep anonymous 2007 Sep anonymous 2 3 INSERT of Large REAL value fails with Floating Point Exception
#c8c8c8 2665 code closed 2007 Sep anonymous 2007 Sep 3 1 Dissapearing exclusive lock when DB is copied...
#c8c8c8 2662 code closed 2007 Sep anonymous 2007 Sep 1 1 Serious Performance Degradation from 3.3.4 to 3.3.5 & latest versions
#c8c8c8 1929 warn closed 2006 Aug anonymous 2007 Sep 4 3 3.3.7 sqlite3_index_info incompatible with C++
#c8c8c8 2661 code closed 2007 Sep anonymous 2007 Sep 2 3 Single line, multi inserts
#c8c8c8 2660 code closed 2007 Sep anonymous 2007 Sep 4 4 Spelling error in comment for SQLITE_CONSTRAINT
#c8c8c8 2655 code closed 2007 Sep anonymous 2007 Sep 2 3 Reuse prepared statement after locked(5) gives called out of seq(21)
#c8c8c8 2650 build closed 2007 Sep anonymous 2007 Sep 1 1 lack ; in os_win.c:1329
#c8c8c8 2647 code closed 2007 Sep anonymous 2007 Sep 1 1 sqlite-3.5.0 Cygwin: Compilation fails on src/os_win.c - ';' missing
#c8c8c8 2646 code closed 2007 Sep anonymous 2007 Sep a.rottmann 4 1 sqlite3_get_table loses one table row
#c8c8c8 2644 code closed 2007 Sep anonymous 2007 Sep 1 1 sqlite
#c8c8c8 2636 code closed 2007 Sep anonymous 2007 Sep 1 1 Bug in sqlite3_prepare_v2
#c8c8c8 2642 code closed 2007 Sep anonymous 2007 Sep 5 5 CYGWIN compile error due to missing semicolon
#c8c8c8 2641 code closed 2007 Sep anonymous 2007 Sep 2 3 sqlite - Ticket #2638 continued as it was arbitrarily closed unsolved
#c8c8c8 2638 code closed 2007 Sep anonymous 2007 Sep 2 3 selects on japanese text okay in 3.3.5 bad in later versions
#c8c8c8 2637 code closed 2007 Sep anonymous 2007 Sep 1 1 Segfault in pthread_getspecific ()
#c8c8c8 2635 code closed 2007 Sep anonymous 2007 Sep 3 2 problem with calculation of juliand date
#c8c8c8 2626 code closed 2007 Sep anonymous 2007 Sep 1 1 The Amalgamation compile error
#c8c8c8 2625 build closed 2007 Sep anonymous 2007 Sep 2 2 http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet has problem
#c8c8c8 2617 code closed 2007 Sep anonymous 2007 Sep drh 2 3 Check in #4357 may lead to bugs in SMP aware systems in windows vfs
#c8c8c8 2486 code closed 2007 Jul anonymous 2007 Sep 2 3 pragma index_list does not detect index created on 2nd connection
#c8c8c8 2620 doc closed 2007 Sep anonymous 2007 Sep 5 5 doc note needed for sqlite3_memory_alarm()
#c8c8c8 2618 code closed 2007 Sep anonymous 2007 Sep linus 4 1 Dabase is Locked
#c8c8c8 2614 code closed 2007 Sep anonymous 2007 Sep 1 1 Custom VFS still calls default xRandomness
#c8c8c8 2609 code closed 2007 Sep anonymous 2007 Sep 1 1 Is non-thread safe binaries dangerous for multi-threaded app design ?
#c8c8c8 2605 build closed 2007 Aug anonymous 2007 Aug 1 3 Amalgamated version 3.4.2 doesn't compile (VC++6)
#c8c8c8 1677 new closed 2006 Feb anonymous 2007 Aug 4 3 No way to know if library was compiled with threadsafety
#c8c8c8 2596 code closed 2007 Aug anonymous 2007 Aug 2 2 wrong specifier for extern char arrays
#c8c8c8 2594 code closed 2007 Aug anonymous 2007 Aug 5 4 ability to replace allocator
#c8c8c8 2593 code closed 2007 Aug anonymous 2007 Aug 1 1 btshared unlock bug
#c8c8c8 2592 warn closed 2007 Aug anonymous 2007 Aug 1 1 The Entry C:\Windows\Temp\sqlite_z6onAYdsVGqLG3Q is Invalid
#c8c8c8 2589 doc closed 2007 Aug anonymous 2007 Aug danielk1977 4 4 s/effected/affected/ in PRAGMA locking_mode
#c8c8c8 2590 todo closed 2007 Aug anonymous 2007 Aug danielk1977 2 2 return value of strftime('%s', 'now') being determined as 'text'
#c8c8c8 2586 code closed 2007 Aug anonymous 2007 Aug 3 3 INSERT of large number fails on Windows
#c8c8c8 2584 new closed 2007 Aug anonymous 2007 Aug 1 2 On Windows function sqlite3WinSleep needs to dispatch messages
#c8c8c8 2581 code closed 2007 Aug anonymous 2007 Aug 1 1 ./configure && make broken: new source files: mem[12].c, mutex.c, etc
#c8c8c8 2578 code closed 2007 Aug anonymous 2007 Aug 1 1 sqlite3BtreeEnter, sqlite3BtreeLeave threading issues
#c8c8c8 2577 code closed 2007 Aug anonymous 2007 Aug 5 5 Initilizing pointers to 0 instead of NULL.
#c8c8c8 2576 code closed 2007 Aug anonymous 2007 Aug 1 1 Check-in [4239] mutex race conditions
#c8c8c8 2575 code closed 2007 Aug anonymous 2007 Aug 1 1 sqlite3_mutex_enter missing return
#c8c8c8 2572 warn closed 2007 Aug anonymous 2007 Aug 1 1 Sqlitw error unrecognize token
#c8c8c8 2563 code closed 2007 Aug anonymous 2007 Aug 1 1 sqlite3_column_database_name16() is broken
#c8c8c8 2571 todo closed 2007 Aug anonymous 2007 Aug 1 1 SQLite opening in Access
#c8c8c8 2536 code closed 2007 Jul anonymous 2007 Aug 2 3 Possible non-ID index corruption when max_page_count exceeded
#c8c8c8 2569 code closed 2007 Aug anonymous 2007 Aug 3 2 Executing a statement causes an AccessViolation Exception
#c8c8c8 2564 event closed 2007 Aug anonymous 2007 Aug anonymous 4 4 in C:\windows\temp are 50 files like sqlite_fMyj88gwaTTNgUF and 0 kb
#c8c8c8 2562 code closed 2007 Aug anonymous 2007 Aug 2 3 Multithreaded transactions deadlock (Windows)
#c8c8c8 2557 build closed 2007 Aug anonymous 2007 Aug 3 3 make test errors on Rhel4 x86_64
#c8c8c8 2553 code closed 2007 Aug anonymous 2007 Aug 3 3 AUTOINCREMENT not working when primary key has multiple columns
#c8c8c8 2551 code closed 2007 Aug anonymous 2007 Aug 3 3 sqlite3 shell gets into bad state with unexpected input
#c8c8c8 2552 code closed 2007 Aug anonymous 2007 Aug 1 3 sqlite3_column_double causes invalid floating point operation
#c8c8c8 2480 code closed 2007 Jun anonymous 2007 Aug 4 4 typo in faq.tcl
#c8c8c8 2549 build closed 2007 Aug anonymous 2007 Aug 1 3 3.4.1 fails to upgrade from 3.3.1.7 on freeBSD
#c8c8c8 2439 code closed 2007 Jun rse 2007 Jul 1 1 FTS1 and FTS2 use the unportable
#c8c8c8 2542 code closed 2007 Jul anonymous 2007 Jul 2 1 select 3/2 * avg(x) gives wrong result
#c8c8c8 2541 doc closed 2007 Jul anonymous 2007 Jul danielk1977 4 4 ALTER TABLE RENAME TO doesn't update (all) trigger schema
#c8c8c8 2534 code closed 2007 Jul anonymous 2007 Jul danielk1977 2 3 sqlite3_set_auxdata may cause memory to be leaked
#c8c8c8 2538 code closed 2007 Jul anonymous 2007 Jul 1 1 calling sqlite3_interrupt() randomly leaves db->ul.isInterrupted = 1
#c8c8c8 2537 code closed 2007 Jul anonymous 2007 Jul 4 4 sqlite3_column_type() function problem.
#c8c8c8 2532 code closed 2007 Jul anonymous 2007 Jul 3 4 Endless loop in Parser?
#c8c8c8 2531 code closed 2007 Jul anonymous 2007 Jul a.rottmann 1 1 Can't find head files in icu.c
#c8c8c8 2527 doc closed 2007 Jul anonymous 2007 Jul 4 2 sqlite3_create_module() API documentation missing
#c8c8c8 2529 code closed 2007 Jul anonymous 2007 Jul anonymous 1 1 Bug in sqlite3_prepare_v2( ) function
#c8c8c8 2493 build closed 2007 Jul anonymous 2007 Jul 2 3 Fails to build under GCC-4.1.3 on FreeBSD-6.2
#c8c8c8 2516 code closed 2007 Jul anonymous 2007 Jul 3 3 REGRESSION:sqlite3_prepare ignores nBytes parameter
#c8c8c8 2515 code closed 2007 Jul anonymous 2007 Jul 1 1 Entered to ASCII zeros as a text string was return a single zero.
#c8c8c8 2513 code closed 2007 Jul anonymous 2007 Jul 1 2 Internal compiler error tclsqlite.c
#c8c8c8 2500 code closed 2007 Jul anonymous 2007 Jul 2 4 Possible memory leak on avr32 arch
#c8c8c8 2505 code closed 2007 Jul anonymous 2007 Jul 1 1 does not return error when use sqlite_open to open an non-sqlite db
#c8c8c8 2504 build closed 2007 Jul anonymous 2007 Jul 1 1 sqlite 3.4.0 fails to build FreeBSD 6.2 64-bit system
#c8c8c8 2501 build closed 2007 Jul anonymous 2007 Jul 2 3 limits.h confilct with visual studio limits.h
#c8c8c8 2497 code closed 2007 Jul anonymous 2007 Jul 4 2 sqlite3_errcode does not return the proper error code
#c8c8c8 2495 code closed 2007 Jul anonymous 2007 Jul 4 4 standard C library Naming conflict - limits.h
#c8c8c8 2494 code closed 2007 Jul anonymous 2007 Jul 1 1 DRow["ID"] = reader.GetString(reader.GetOrdinal("ID")); fails
#c8c8c8 2492 code closed 2007 Jul anonymous 2007 Jul 4 4 Incorrect protoype for function sqlite3_result_zeroblob
#c8c8c8 2489 build closed 2007 Jul anonymous 2007 Jul 1 1 Latest cvs 3.4.0 make test fails related to TCL
#c8c8c8 2243 code closed 2007 Feb anonymous 2007 Jul 2 3 sqlite3 authorizer cannot be exposed in garbage collected languages
#c8c8c8 2485 code closed 2007 Jul anonymous 2007 Jul 1 2 SQLite + Python segfaults at various places in the code
#c8c8c8 2483 code closed 2007 Jul anonymous 2007 Jul 1 3 like clause not working
#c8c8c8 2482 code closed 2007 Jul anonymous 2007 Jul 3 4 Possible optimizer bug
#c8c8c8 2481 code closed 2007 Jul anonymous 2007 Jul 1 3 sqlite leaks memory (after 3.3.13)
#c8c8c8 2449 doc closed 2007 Jun anonymous 2007 Jun 1 1 BLOB and binary data
#c8c8c8 2461 code closed 2007 Jun anonymous 2007 Jun 2 3 BLOB retrieval produces garbled data in UTF-16
#c8c8c8 2478 code closed 2007 Jun anonymous 2007 Jun 2 2 LIMIT and OFFSET abbreviation to LIMIT x,y bug!
#c8c8c8 2472 code closed 2007 Jun anonymous 2007 Jun 1 1 smart quotes turning question marks while storing in oracle 9i DB
#c8c8c8 2471 secure closed 2007 Jun anonymous 2007 Jun 1 1 a bug for 64 bit driver under operation system
#c8c8c8 2463 todo closed 2007 Jun anonymous 2007 Jun anonymous 1 1 Crash after calling sqlite_close() if SQLITE_ENABLE_MEMORY_MANAGEMENT
#c8c8c8 2357 code closed 2007 May anonymous 2007 Jun anonymous 2 2 Crash in sqlite3PagerClose when SQLITE_ENABLE_MEMORY_MANAGEMENT is def
#c8c8c8 2462 todo closed 2007 Jun anonymous 2007 Jun 5 5 www.sqlite.org/cvstrac/tktnew suggestion
#c8c8c8 2444 code closed 2007 Jun anonymous 2007 Jun 2 3 SIGFPE from division of (1<<63)==9223372036854775808
#c8c8c8 2460 code closed 2007 Jun anonymous 2007 Jun 1 1 VC6 Compile Error
#c8c8c8 2458 code closed 2007 Jun anonymous 2007 Jun 1 1 sqlite caching results between calls to select on an open database
#c8c8c8 2445 code closed 2007 Jun anonymous 2007 Jun 1 1 crash in sqlite3_prepare16
#c8c8c8 2452 code closed 2007 Jun anonymous 2007 Jun drh 1 1 In Memory Query Performance
#c8c8c8 2451 code closed 2007 Jun anonymous 2007 Jun 5 5 vdbe.c comment typo
#c8c8c8 2450 code closed 2007 Jun anonymous 2007 Jun 1 1 Crashes and random wrong results with certain column names
#c8c8c8 2441 code closed 2007 Jun anonymous 2007 Jun 2 3 Windows only error when deleting tempory files
#c8c8c8 2447 code closed 2007 Jun anonymous 2007 Jun 1 4 select where TABLENAME="TABLENAME" returns whole table.
#c8c8c8 2420 code closed 2007 Jun anonymous 2007 Jun 5 5 sqlite3_prepare() don't work in php pdo implementation
#c8c8c8 2435 code closed 2007 Jun anonymous 2007 Jun 1 1 Data corruption in version 3.4.0
#c8c8c8 2429 code closed 2007 Jun danielk1977 2007 Jun shess 1 3 problem with fts2 snippet() function
#c8c8c8 2421 code closed 2007 Jun anonymous 2007 Jun 1 1 unresolved external
#c8c8c8 2405 code closed 2007 Jun anonymous 2007 Jun 1 1 sqlite3_prepare() don't work in php pdo implementation
#c8c8c8 2412 build closed 2007 Jun anonymous 2007 Jun a.rottmann 1 1 Can't make Sqlite 3.3.17 on Solaris 10 X86
#c8c8c8 2389 code closed 2007 May anonymous 2007 Jun 1 1 database placed in the non ASCII named folder could not be opened
#c8c8c8 2402 code closed 2007 Jun anonymous 2007 Jun 3 3 Left Outer Join and Where clause
#c8c8c8 2400 code closed 2007 Jun anonymous 2007 Jun 4 4 SELECT COUNT (*); returns 1 rather than 0.
#c8c8c8 2395 todo closed 2007 Jun anonymous 2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
#c8c8c8 2394 todo closed 2007 Jun anonymous 2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
#c8c8c8 2390 code closed 2007 May anonymous 2007 May drh 1 1 defect in select with max(id)
#c8c8c8 2391 todo closed 2007 May danielk1977 2007 May danielk1977 1 1 Inconsistent behaviour from explicit collate clauses.
#c8c8c8 2385 code closed 2007 May anonymous 2007 May 5 4 Comment for SQLITE_VERSION_NUMBER has a typo (missing zero).
#c8c8c8 2387 code closed 2007 May anonymous 2007 May 1 1 query: problem with update anagrafica SET nome='nome' where id = '4';
#c8c8c8 2386 doc closed 2007 May anonymous 2007 May 5 4 Suggestion for wiki speed comparisson: order by, group by, subselect
#c8c8c8 2384 doc closed 2007 May anonymous 2007 May 1 5 an error in comments
#c8c8c8 2380 code closed 2007 May anonymous 2007 May 1 1 Order By Collum1, Collum2, Collum3 for Pocket PC incorrect in device
#c8c8c8 2375 doc closed 2007 May anonymous 2007 May 4 4 sqlite3_exec docs mentions sqlite3_reset
#c8c8c8 2369 code closed 2007 May anonymous 2007 May 3 3 if you do a configure --prefix=/home/someotherdir tcl installs wrong
#c8c8c8 2370 code closed 2007 May anonymous 2007 May 3 2 Data is converted without me telling it to do so
#c8c8c8 2368 code closed 2007 May anonymous 2007 May 1 1 vdbeblob.c missing from Makefile.in
#c8c8c8 2367 code closed 2007 May anonymous 2007 May 2 2 SQLITE_OMIT_INCRBLOB breaks default "make test"
#c8c8c8 2366 code closed 2007 May anonymous 2007 May 4 4 "make test" failures: pragma-1.15, pragma-1.16
#c8c8c8 2365 code closed 2007 May anonymous 2007 May 1 1 incrvacuum2, zeroblob regressions from check-ins on 2007-May-16
#c8c8c8 2362 code closed 2007 May anonymous 2007 May 4 4 Can't add a column with ALTER TABLE
#c8c8c8 2361 new closed 2007 May anonymous 2007 May 3 3 Why is no LIMIT suported in UPDATE-queries?
#c8c8c8 2355 code closed 2007 May anonymous 2007 May 3 4 Segfault with looooong sql string
#c8c8c8 2358 code closed 2007 May anonymous 2007 May 3 4 Incorrect index chosen for query
#c8c8c8 2353 code closed 2007 May anonymous 2007 May 1 1 Issue with selecting values of indexed column
#c8c8c8 2346 code closed 2007 May anonymous 2007 May 1 1 Inserting a certain integer
#c8c8c8 2338 todo closed 2007 May anonymous 2007 May 4 3 3.3.17 windows dll download gives 3.2.7
#c8c8c8 2332 code closed 2007 May anonymous 2007 May danielk1977 1 1 incrblob: Data error writing large blobs
#c8c8c8 2331 code closed 2007 May anonymous 2007 May 1 1 Performance problem with complex where clause
#c8c8c8 2330 code closed 2007 May anonymous 2007 May drh 2 2 Usage of fieldname Session is impossible for where clause
#c8c8c8 2325 code closed 2007 Apr anonymous 2007 Apr 1 1 Link Fails w/ SQLITE_OMIT_ALTERTABLE
#c8c8c8 2178 code closed 2007 Jan anonymous 2007 Apr 1 1 On Windows Vista, a simple select returns different results.
#c8c8c8 2317 code closed 2007 Apr anonymous 2007 Apr 4 4 Floats rendered to strings differently in WHERE and GROUP BY clauses.
#c8c8c8 2315 code closed 2007 Apr anonymous 2007 Apr 1 1 Macro Redefinition Warning
#c8c8c8 2316 code closed 2007 Apr anonymous 2007 Apr 4 4 2 prepared statements on same database cause RC = 21
#c8c8c8 2312 code closed 2007 Apr anonymous 2007 Apr mike 1 1 Using ODBC. Only saves first 5 characters of text fields. Can you help
#c8c8c8 2305 doc closed 2007 Apr anonymous 2007 Apr 4 4 Function replace(X,Y,Z) doesn't exist ?
#c8c8c8 2300 code closed 2007 Apr anonymous 2007 Apr 1 1 compound query ORDER BY expression problem
#c8c8c8 2293 code closed 2007 Apr anonymous 2007 Apr 2 2 Extra file operations with sub journal when DB in MEM
#c8c8c8 2292 code closed 2007 Apr anonymous 2007 Apr 1 1 VACUUM => constraint failed
#c8c8c8 2279 code closed 2007 Mar anonymous 2007 Mar 3 4 sqlite3_exec NULL pointer crash
#c8c8c8 2170 code closed 2007 Jan anonymous 2007 Mar anonymous 3 3 -init does not execute .exit/.quit
#c8c8c8 2169 code closed 2007 Jan anonymous 2007 Mar adamd 2 1 cast function
#c8c8c8 2255 code closed 2007 Feb scouten 2007 Mar 3 3 Temporary DB files are deleted twice in pager_unwritelock, once implic
#c8c8c8 2269 code closed 2007 Mar anonymous 2007 Mar anonymous 2 1 SQLite3_Column_decltype treat [char] (32) as 'char',but not 'char(32)'
#c8c8c8 2275 code closed 2007 Mar anonymous 2007 Mar 2 4 Can't get where clause to recognize equality with generated value
#c8c8c8 2271 doc closed 2007 Mar anonymous 2007 Mar 3 4 Can't use "limit" as column name
#c8c8c8 2265 doc closed 2007 Mar anonymous 2007 Mar 1 1 windows + xampp (php) + sqlite3 ... how?
#c8c8c8 2263 code closed 2007 Mar anonymous 2007 Mar 1 1 Apparent potential leak or concurrency problem when using codec
#c8c8c8 2261 build closed 2007 Mar anonymous 2007 Mar 1 1 Problem under Windows 95
#c8c8c8 2260 code closed 2007 Feb anonymous 2007 Mar 1 1 virtual table/vdbe does not call xFilter() making xColumn segv
#c8c8c8 2253 code closed 2007 Feb anonymous 2007 Mar danielk1977 1 1 src/vdbe.c:3639: sqlite3VdbeExec: Assertion `pC!=0' failed.
#c8c8c8 2250 code closed 2007 Feb anonymous 2007 Mar danielk1977 1 1 segmentation violation when using "select max(rowid)" in fts1
#c8c8c8 2245 new closed 2007 Feb anonymous 2007 Feb a.rottmann 5 1 Union Problem on Empty Table
#c8c8c8 2244 code closed 2007 Feb anonymous 2007 Feb danielk1977 1 2 xUpdate in virtual table being called when no record exists
#c8c8c8 2240 code closed 2007 Feb anonymous 2007 Feb 1 1 Parser command termination problem fails to catch illegal statements
#c8c8c8 2239 doc closed 2007 Feb anonymous 2007 Feb 1 1 Size of database in Speed Comparison?
#c8c8c8 2236 code closed 2007 Feb anonymous 2007 Feb 1 1 inserts with selects do not work in 3.1.13
#c8c8c8 2234 code closed 2007 Feb anonymous 2007 Feb 1 1 3.3.13 is identical to 3.3.12 except VERSION file
#c8c8c8 2232 build closed 2007 Feb anonymous 2007 Feb 3 3 corrupt2.test fails with newer versions of Tcl
#c8c8c8 2230 code closed 2007 Feb danielk1977 2007 Feb danielk1977 1 1 Problem with virtual tables and grouping by aggregate function.
#c8c8c8 2212 code closed 2007 Feb anonymous 2007 Feb 5 4 function request: sqlite3_bind_literal()
#c8c8c8 2213 code closed 2007 Feb danielk1977 2007 Feb danielk1977 1 1 Bug handling strings that are not nul-terminated.
#c8c8c8 2209 doc closed 2007 Feb anonymous 2007 Feb 5 5 Wrong Comment in the change #3622
#c8c8c8 2197 code closed 2007 Jan anonymous 2007 Jan 4 5 invalid(?) join syntax results in runnable sql code
#c8c8c8 2196 code closed 2007 Jan anonymous 2007 Jan 5 3 Bug in PRAGMA full_column_names with SELECT *
#c8c8c8 2190 code closed 2007 Jan anonymous 2007 Jan 3 4 bogus lines on "left join" with a "where right_table.column is NULL"
#c8c8c8 2186 code closed 2007 Jan anonymous 2007 Jan drh 1 1 database seems to be corrupted during a huge transaction
#c8c8c8 2179 new closed 2007 Jan anonymous 2007 Jan 4 1 Odbc driver for sqlite takes more time in executing a query.
#c8c8c8 2174 code closed 2007 Jan anonymous 2007 Jan anonymous 2 3 DBD::SQLite does not return number of rows affected. Count(XXX) OK
#c8c8c8 2162 code closed 2007 Jan anonymous 2007 Jan 1 1 c code compile fails with "Undefined reference to sqlite3_open()"
#c8c8c8 2158 code closed 2007 Jan anonymous 2007 Jan 1 2 SCHEMA error still returned if SQL becomes invalid
#c8c8c8 2157 code closed 2007 Jan anonymous 2007 Jan 1 2 Profile called back too many times if a prepare_v2 statement is reused
#c8c8c8 2155 code closed 2007 Jan anonymous 2007 Jan 4 4 Should %s in strftime() be rounded up?
#c8c8c8 2150 code closed 2007 Jan anonymous 2007 Jan 3 3 use of %W in strftime produces unreliable results
#c8c8c8 2152 code closed 2007 Jan anonymous 2007 Jan 1 1 there is not tclsqlite.h in sqlite3.3.9
#c8c8c8 2146 code closed 2007 Jan anonymous 2007 Jan 1 2 Correlated subqueries as columns of select return a syntax error
#c8c8c8 2142 build closed 2007 Jan anonymous 2007 Jan 2 2 make fails on cygwin
#c8c8c8 2138 code closed 2007 Jan anonymous 2007 Jan 1 2 COLLATE and multiple order by problem
#c8c8c8 2137 code closed 2007 Jan anonymous 2007 Jan shess 4 4 I cannot find tcl.h header file. So, I am not able to compile the code
#c8c8c8 2134 code closed 2006 Dec anonymous 2006 Dec 2 1 is this a bug of sqlite3_prepare?
#c8c8c8 2124 code closed 2006 Dec anonymous 2006 Dec 1 1 default ./configure && make broken on Linux in latest CVS
#c8c8c8 2121 code closed 2006 Dec anonymous 2006 Dec 3 4 Paths on Win9x following API specs (UTF-8) will fail
#c8c8c8 2119 new closed 2006 Dec anonymous 2006 Dec 5 4 Unable to use place holders as part of the actual SQL query
#c8c8c8 2115 code closed 2006 Dec anonymous 2006 Dec 5 4 mix of allocator functions
#c8c8c8 2108 code closed 2006 Dec anonymous 2006 Dec 4 3 potential memory leak in prepare.c
#c8c8c8 2094 code closed 2006 Dec anonymous 2006 Dec 1 3 Virtual table cursors are not freed (memory leak)
#c8c8c8 2102 code closed 2006 Dec anonymous 2006 Dec 1 1 locking failing on w2k on vmware
#c8c8c8 2103 secure closed 2006 Dec anonymous 2006 Dec 2 2 No bound check for the insert string data!
#c8c8c8 2101 event closed 2006 Dec anonymous 2006 Dec 1 1 sqlite files filling up Temp folder 7,700 files so far can not delete
#c8c8c8 2097 code closed 2006 Dec anonymous 2006 Dec 1 1 MAX function broken
#c8c8c8 2092 code closed 2006 Dec anonymous 2006 Dec 4 5 Bind null on an insert doesn't allow a WHERE bound with null
#c8c8c8 2091 code closed 2006 Nov anonymous 2006 Nov 3 3 thread unsafety + solution
#c8c8c8 2085 code closed 2006 Nov anonymous 2006 Nov 5 4 Round statement with different behavior between 3.2.8 and 3.3.7
#c8c8c8 1945 code closed 2006 Aug anonymous 2006 Nov 1 1 symbol not found: sqlite_freemem
#c8c8c8 2040 code closed 2006 Oct anonymous 2006 Nov 1 1 Fatal reloc error: Using sqlite-3.3.6 with apache-2.2.0 on SPARC Solar
#c8c8c8 2079 code closed 2006 Nov anonymous 2006 Nov 1 1 strftime doesn't work in where statement
#c8c8c8 2073 code closed 2006 Nov anonymous 2006 Nov 4 4 Ordering by a named expression which includes random doesn't work
#c8c8c8 2064 code closed 2006 Nov anonymous 2006 Nov 3 4 Table Name ignored if table Alias specified
#c8c8c8 2058 code closed 2006 Nov anonymous 2006 Nov 1 1 sum or total result in only 1 row returned
#c8c8c8 2054 code closed 2006 Nov anonymous 2006 Nov 1 1 material to learn SQLite
#c8c8c8 2053 code closed 2006 Nov anonymous 2006 Nov 1 1 problem on solaris 10
#c8c8c8 2052 code closed 2006 Nov anonymous 2006 Nov 1 1 BLOBs still do not work on version 3.0
#c8c8c8 2049 code closed 2006 Oct anonymous 2006 Oct 1 1 sqlite_HrmKZy6ma4XBUGl is in my temp file and cannot be deleted.
#c8c8c8 2042 code closed 2006 Oct anonymous 2006 Oct 2 3 Subquery does not return the expected NULL
#c8c8c8 2039 code closed 2006 Oct anonymous 2006 Oct 1 1 How to delete SQLITE Temp files
#c8c8c8 2034 code closed 2006 Oct anonymous 2006 Oct jenglish 1 1 lazarus and sqlite3
#c8c8c8 2035 code closed 2006 Oct anonymous 2006 Oct jenglish 1 1 lazarus and sqlite3
#c8c8c8 2033 code closed 2006 Oct anonymous 2006 Oct 1 1 SQLite 3.3.8 breaks Rails 1.1.6 (SQLite 3.3.6 OK)
#c8c8c8 2031 code closed 2006 Oct anonymous 2006 Oct 1 1 .DEF file missing from 3.3.8 source code distribution
#c8c8c8 2021 code closed 2006 Oct anonymous 2006 Oct a.rottmann 2 1 Expression Always Returning String
#c8c8c8 2020 code closed 2006 Oct anonymous 2006 Oct 1 1 sqlite3_column_type always returns 1
#c8c8c8 1995 code closed 2006 Sep anonymous 2006 Oct 2 1 SHARED lock does not kick in (DEFERRED does not work ?)
#c8c8c8 2007 code closed 2006 Oct anonymous 2006 Oct 1 1 Server has unexpecedly died/u've found a bug/ i cant connect to hub
#c8c8c8 1997 code closed 2006 Sep anonymous 2006 Sep 2 3 can't select rows if column name is contained in data
#c8c8c8 1993 event closed 2006 Sep anonymous 2006 Sep 3 1 bit operators problemm
#c8c8c8 1956 code closed 2006 Sep anonymous 2006 Sep 1 1 ALTER TABLE ADD COLUMN does not support asian language column names.
#c8c8c8 1985 doc closed 2006 Sep anonymous 2006 Sep 1 4 how get table names
#c8c8c8 1984 code closed 2006 Sep anonymous 2006 Sep 1 1 sqlite3_exec problem
#c8c8c8 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
#c8c8c8 1965 code closed 2006 Sep anonymous 2006 Sep 3 3 sqlite returns wrong error code
#c8c8c8 1962 new closed 2006 Sep anonymous 2006 Sep 4 2 sqlite3_column_value() not exported
#c8c8c8 1963 new closed 2006 Sep anonymous 2006 Sep 2 2 sqlite3_aggregate_context() should be improved
#c8c8c8 1950 new closed 2006 Aug anonymous 2006 Sep 4 4 AUTOINCREMENT too picky about type
#c8c8c8 1949 new closed 2006 Aug anonymous 2006 Aug 4 1 Missing 64Bit type
#c8c8c8 1940 code closed 2006 Aug anonymous 2006 Aug 3 3 insert default values
#c8c8c8 1932 new closed 2006 Aug anonymous 2006 Aug 3 4 I want a way to make db open fail if file does not exist
#c8c8c8 1931 new closed 2006 Aug anonymous 2006 Aug 3 3 timezone difference between PDO/Sqlite and PHP
#c8c8c8 1710 new closed 2006 Mar anonymous 2006 Aug 1 1 when order by, performance is low
#c8c8c8 1921 code closed 2006 Aug anonymous 2006 Aug 4 4 misc1-10.1 failure on cygwin aborts make test
#c8c8c8 1910 event closed 2006 Aug anonymous 2006 Aug 3 4 Lost clusters generated by "create TEMP Table" (DJGPP/GCC2.953)
#c8c8c8 1903 code closed 2006 Aug anonymous 2006 Aug 2 2 LIKE string search sometimes fails
#c8c8c8 1520 new closed 2005 Nov anonymous 2006 Jul 4 4 sqlite3_column_type do not work for empty table
#c8c8c8 1883 code closed 2006 Jul anonymous 2006 Jul 1 2 "no such table error" using sqlite-odbc driver
#c8c8c8 1880 code closed 2006 Jul anonymous 2006 Jul 3 3 Errors testing sqlite 3.3.6
#c8c8c8 1870 code closed 2006 Jun anonymous 2006 Jun 2 2 dbWriteTable in RSQLite can't write strings that contain commas.
#c8c8c8 1866 event closed 2006 Jun anonymous 2006 Jun 1 1 SQLite.NET ExecuteNonQuery() limit of text size
#c8c8c8 1865 code closed 2006 Jun anonymous 2006 Jun 1 2 Encoding problem using order by
#c8c8c8 1855 doc closed 2006 Jun anonymous 2006 Jun 5 5 how to configure SQLite with jboss
#c8c8c8 1854 event closed 2006 Jun anonymous 2006 Jun 3 3 i am unable to view the tables by using .tables command
#c8c8c8 1852 code closed 2006 Jun anonymous 2006 Jun 4 5 AUTOINC NOT NULL problem
#c8c8c8 1846 code closed 2006 Jun anonymous 2006 Jun 1 1 Memory leak after returning error message
#c8c8c8 1844 warn closed 2006 Jun anonymous 2006 Jun 2 3 compiler warnings with gcc 3.3.4 on Tru64 V5.1B
#c8c8c8 1843 code closed 2006 Jun anonymous 2006 Jun 3 2 compile with gcc 3.3.4 on Tru64 V5.1B
#c8c8c8 1841 warn closed 2006 Jun anonymous 2006 Jun mani 3 2 a scan in safe mode says my sqlite file is wrong size
#c8c8c8 1834 code closed 2006 Jun anonymous 2006 Jun 5 5 Can't create database with the é name (french E)
#c8c8c8 1832 code closed 2006 Jun anonymous 2006 Jun 1 1 Segmentation fault when placing a 0 limit on a joined subquery.
#c8c8c8 1828 code closed 2006 Jun anonymous 2006 Jun 1 3 if not exists doesn't work with a qt program I'm designing.
#c8c8c8 1829 code closed 2006 Jun anonymous 2006 Jun 1 1 Odbc driver parameter bind offset pointer does not work
#c8c8c8 1529 code closed 2005 Nov anonymous 2006 May 1 1 can not uses japanese as table name to create table
#c8c8c8 1823 code closed 2006 May anonymous 2006 May 1 1 pysqlite2.dbapi2.OperationalError: unable to open database file
#c8c8c8 1808 code closed 2006 May anonymous 2006 May 1 1 Wrong index is chosen
#c8c8c8 1800 new closed 2006 May anonymous 2006 May linus 1 2 possible to have the lastest version of sqlite with PHP 5?????
#c8c8c8 1796 code closed 2006 May anonymous 2006 May 1 1 .import command not working in 3.3.5
#c8c8c8 1793 code closed 2006 May anonymous 2006 May 2 3 sqlite3.dll crashes when doing an inner join with limit 0
#c8c8c8 1787 code closed 2006 Apr anonymous 2006 Apr 1 1 Certain integer values are written/read incorrectly to/from database
#c8c8c8 1774 code closed 2006 Apr ghaering 2006 Apr 1 1 sqlite3_column_decltype() stopped working in SQLite 3.3
#c8c8c8 1765 code closed 2006 Apr anonymous 2006 Apr 1 2 SQLite3_BindText fails with a floating point error (explicited)
#c8c8c8 1757 code closed 2006 Apr anonymous 2006 Apr 2 1 sqlite not using index
#c8c8c8 1760 code closed 2006 Apr anonymous 2006 Apr 4 4 sqlite3_open(), then sqlite3_close()
#c8c8c8 1759 code closed 2006 Apr anonymous 2006 Apr 3 4 "int primary key" not the same as "integer primary key"
#c8c8c8 1539 code closed 2005 Nov anonymous 2006 Mar 4 4 sqlite3Realloc is a trap for the unwary
#c8c8c8 1499 code closed 2005 Oct anonymous 2006 Mar anonymous 3 1 Sqlite 3.2.7 does not support Chinese path.
#c8c8c8 1563 code closed 2005 Dec anonymous 2006 Mar 1 1 The system crash when creating a database!
#c8c8c8 1706 code closed 2006 Mar anonymous 2006 Mar 1 2 Group operations like ORDER BY don't work after renaming a table
#c8c8c8 1712 code closed 2006 Mar anonymous 2006 Mar 1 1 aggregate function return empty row
#c8c8c8 1725 code closed 2006 Mar anonymous 2006 Mar 2 1 sql "HAVING" fails to filter query grouping "UNION ALL" subqueries
#c8c8c8 1730 new closed 2006 Mar anonymous 2006 Mar 2 5 referential integrity
#c8c8c8 1729 code closed 2006 Mar anonymous 2006 Mar 1 1 SQLite loses precision on 64-bit integers
#c8c8c8 1723 code closed 2006 Mar anonymous 2006 Mar 1 1 Crash (floating point error) when dealing with BIGINT datatypes
#c8c8c8 1715 doc closed 2006 Mar anonymous 2006 Mar 5 4 int sqlite3_release_memory(int) documented but not implemented
#c8c8c8 1553 new closed 2005 Dec anonymous 2006 Mar 5 4 API suggestion: sqlite3_has_more_rows()
#c8c8c8 1687 todo closed 2006 Feb dougcurrie 2006 Mar 3 3 tclsqlite.c crashes MinGW/MSYS gcc 3.4.5 on WIndows
#c8c8c8 1692 code closed 2006 Feb anonymous 2006 Mar 1 2 Collation dont work in functions
#c8c8c8 1676 code closed 2006 Feb anonymous 2006 Feb 2 2 When binding the wrong type sqlite3 bails out but retuns an SQLITE_OK
#c8c8c8 1642 code closed 2006 Jan anonymous 2006 Jan 4 4 single time leaks in sqlite3_prepare()
#c8c8c8 1641 doc closed 2006 Jan anonymous 2006 Jan 5 4 Very minor documentation thing
#c8c8c8 1581 code closed 2006 Jan anonymous 2006 Jan 4 3 incompatible pointer types lead to compilation errors
#c8c8c8 1631 code closed 2006 Jan anonymous 2006 Jan 2 3 Sqlite3 reports fdatasync type referenced symbol not found on Solaris
#c8c8c8 1624 code closed 2006 Jan anonymous 2006 Jan drh 1 1 OSMALLOC(int n) implementation does not allow OOM testing
#c8c8c8 1620 todo closed 2006 Jan anonymous 2006 Jan 1 1 error database or disk is full
#c8c8c8 1623 code closed 2006 Jan anonymous 2006 Jan drh 1 1 ThreadData instance never gets freed
#c8c8c8 1610 code closed 2006 Jan anonymous 2006 Jan 1 2 SQLITE_OMIT_SUBQUERY can cause access violation
#c8c8c8 1618 code closed 2006 Jan anonymous 2006 Jan drh 1 1 Problematic ENTER_MALLOC() macro definition
#c8c8c8 1617 code closed 2006 Jan anonymous 2006 Jan drh 1 1 Memory allocation routines always return non-zero value
#c8c8c8 1612 code closed 2006 Jan anonymous 2006 Jan 1 3 "malformed database schema" when opening 3.2.8 database with SQLITE_OM
#c8c8c8 1613 new closed 2006 Jan anonymous 2006 Jan 4 4 "between" doesn't take advantage of indexes
#c8c8c8 1606 code closed 2006 Jan anonymous 2006 Jan 1 1 sqlite3_prepare16 broken
#c8c8c8 1602 code closed 2006 Jan anonymous 2006 Jan 4 5 likely typo in shell.c
#c8c8c8 1599 doc closed 2006 Jan anonymous 2006 Jan 5 5 Typo in FAQ not quite fixed
#c8c8c8 1595 doc closed 2006 Jan anonymous 2006 Jan 4 1 tcl-devel is required to build. This requirement is not listed
#c8c8c8 1580 code closed 2006 Jan anonymous 2006 Jan 4 2 3.2.8 does not compile under Solaris 10
#c8c8c8 1571 code closed 2005 Dec anonymous 2005 Dec 1 1 SQLiteCC crashes when you rollback create table
#c8c8c8 1561 build closed 2005 Dec anonymous 2005 Dec 3 1 compile sqlite 3.2.7 failed on Unix
#c8c8c8 1551 code closed 2005 Dec anonymous 2005 Dec 1 1 sqlite3_reset seems not to be exported correctly
#c8c8c8 1548 warn closed 2005 Dec 2005 Dec 1 1 Command failed for target `sqlite3'
#c8c8c8 1538 code closed 2005 Nov anonymous 2005 Nov 1 1 Access Violation error
#c8c8c8 1534 code closed 2005 Nov anonymous 2005 Nov 1 1 error:
#c8c8c8 1531 code closed 2005 Nov anonymous 2005 Nov 4 3 Crash when evaluating SELECT ... HAVING NOT EXISTS
#c8c8c8 1526 new closed 2005 Nov anonymous 2005 Nov 1 1 Unused data structure fields when trace support is omitted.
#c8c8c8 1490 code closed 2005 Oct anonymous 2005 Nov 1 1 Create Temp Index has problem
#c8c8c8 1492 code closed 2005 Oct anonymous 2005 Nov 1 4 CURRENT_TIMESTAMP bad for PM times.
#c8c8c8 1517 code closed 2005 Nov anonymous 2005 Nov 1 1 unable to drop a temporary table when database is locked
#c8c8c8 1516 code closed 2005 Nov anonymous 2005 Nov 1 2 comparison error in WHERE clause
#c8c8c8 1511 event closed 2005 Nov anonymous 2005 Nov 1 1 how to use the index with "order by"
#c8c8c8 1510 build closed 2005 Nov anonymous 2005 Nov 3 2 Can't seem to get autoincrement to work no matter what I try
#c8c8c8 1509 code closed 2005 Nov anonymous 2005 Nov 3 2 Different performance - SELECT COUNT(*) AND SELECT *
#c8c8c8 1495 code closed 2005 Oct anonymous 2005 Oct 2 4 SELECT DISTINCT "col_name" from "TablName fails on first & last fields
#c8c8c8 1496 code closed 2005 Oct anonymous 2005 Oct 4 3 No index creation possible on :memory: DB
#c8c8c8 1482 code closed 2005 Oct anonymous 2005 Oct 1 1 Cannot finish a transaction if a previous transaction was rolled back;
#c8c8c8 1472 build closed 2005 Oct anonymous 2005 Oct 1 5 Borland command line compiler v 5.5 and SQLite
#c8c8c8 1463 code closed 2005 Sep anonymous 2005 Sep 3 1 can't see views in browser 1.0
#c8c8c8 1459 code closed 2005 Sep anonymous 2005 Sep 1 1 Division operation
#c8c8c8 1452 code closed 2005 Sep anonymous 2005 Sep 3 2 segmentation fault on OS X tiger
#c8c8c8 1448 code closed 2005 Sep anonymous 2005 Sep 1 4 Parse Error In sqlite.c While Compiling PHP-5.0.5
#c8c8c8 1446 todo closed 2005 Sep 2005 Sep 4 4 Milestones are not tagged in CVS
#c8c8c8 1443 code closed 2005 Sep anonymous 2005 Sep drh 3 3 pragma full_column_names and short_column_names seems not working.
#c8c8c8 1438 code closed 2005 Sep anonymous 2005 Sep 4 4 UPDATE bug
#c8c8c8 1436 code closed 2005 Sep anonymous 2005 Sep 1 1 cvs HEAD does not return rows for a query that works on older versions
#c8c8c8 1434 code closed 2005 Sep anonymous 2005 Sep 1 1 .dump dumps sqlite_stat1, which makes it impossible to load dump
#c8c8c8 1430 event closed 2005 Sep anonymous 2005 Sep 3 3 pragma index_list(table) doesn' twork correct with integer PKs
#c8c8c8 1422 code closed 2005 Sep anonymous 2005 Sep 1 1 incorrect error codes from sqlite3_errCode
#c8c8c8 1416 code closed 2005 Sep anonymous 2005 Sep xdong 1 1 database is same size as before when we do clearing operation.
#c8c8c8 1309 build closed 2005 Jun anonymous 2005 Sep 1 1 make problem
#c8c8c8 1355 code closed 2005 Aug anonymous 2005 Sep 4 4 mixing GROUP and non-GROUP queries in a query should be an error
#c8c8c8 1406 code closed 2005 Sep anonymous 2005 Sep 1 1 no result with order by
#c8c8c8 1377 warn closed 2005 Aug anonymous 2005 Aug dwong 1 1 can't connect to database
#c8c8c8 1364 code closed 2005 Aug anonymous 2005 Aug 3 3 variable Timeout does not exist anymore in main.c
#c8c8c8 1317 code closed 2005 Jul anonymous 2005 Aug 3 3 Aggregate aliases result in assert() failure
#c8c8c8 1324 code closed 2005 Jul anonymous 2005 Aug anonymous 3 3 main.c (line 301): 'Timeout' meant to be ptr->busyTimeout ?
#c8c8c8 1307 new closed 2005 Jun anonymous 2005 Aug 1 1 BLOBs and Tcl library (again)
#c8c8c8 1322 code closed 2005 Jul anonymous 2005 Aug 4 4 after "select * from sqlite_master;" ".databases" command doesnt work
#c8c8c8 1335 new closed 2005 Jul anonymous 2005 Aug 5 3 AllowNull
#c8c8c8 1360 code closed 2005 Aug anonymous 2005 Aug 4 4 Unsafe casting in table.c
#c8c8c8 1350 code closed 2005 Aug 2005 Aug 3 3 sqlite gives errors with valgrind
#c8c8c8 1310 event closed 2005 Jun anonymous 2005 Aug 2 4 Problem after create a new table
#c8c8c8 1343 code closed 2005 Jul anonymous 2005 Jul 1 1 segmentation fault on select on view
#c8c8c8 1339 code closed 2005 Jul anonymous 2005 Jul 1 1 Table Create in exists db with exists table = MemoryLeak
#c8c8c8 1336 code closed 2005 Jul anonymous 2005 Jul 2 3 cannot find the symbol Timeout
#c8c8c8 1269 code closed 2005 May anonymous 2005 Jul 1 1 Bus Error during import
#c8c8c8 1299 new closed 2005 Jun anonymous 2005 Jun 3 3 need NOT EXISTS
#c8c8c8 1288 code closed 2005 Jun anonymous 2005 Jun 1 1 Win32 Resource leak - InitializeCriticalSection(...)
#c8c8c8 1280 new closed 2005 Jun anonymous 2005 Jun 5 4 Make tests can be run as root
#c8c8c8 1245 code closed 2005 May anonymous 2005 Jun 3 1 Query causes 'unable to open database' after ~1000 operations
#c8c8c8 1267 code closed 2005 May anonymous 2005 May 5 4 exists and case don't work together on an empty table
#c8c8c8 1237 code closed 2005 May anonymous 2005 May anonymous 1 1 I like to use SQLite in php
#c8c8c8 1226 code closed 2005 Apr anonymous 2005 Apr 2 3 Problem when several processes attempt inserts within on the same base
#c8c8c8 1215 code closed 2005 Apr anonymous 2005 Apr 1 1 PRAGMA table_info and INTEGER UNSIGNED - sqlite3 client
#c8c8c8 1207 code closed 2005 Apr anonymous 2005 Apr anonymous 2 1 How to Install SQLite
#c8c8c8 1197 code closed 2005 Apr anonymous 2005 Apr 1 1 race condition in sqlite3_close
#c8c8c8 1196 build closed 2005 Apr anonymous 2005 Apr 1 1 out-of memory on powerpc on linux
#c8c8c8 1193 new closed 2005 Mar anonymous 2005 Mar 1 2 umask not respected... please change 644 to 666 in src/os_unix.c
#c8c8c8 1185 code closed 2005 Mar anonymous 2005 Mar 1 3 Race condition causing crash in busily-threaded application
#c8c8c8 1182 code closed 2005 Mar anonymous 2005 Mar danielk1977 2 3 ALTER TABLE...ADD COLUMN fails if table has user-defined collation
#c8c8c8 1181 code closed 2005 Mar anonymous 2005 Mar 2 3 Field types problem with INSERT
#c8c8c8 1180 code closed 2005 Mar anonymous 2005 Mar 2 3 Field types problem with .import
#c8c8c8 1015 doc closed 2004 Nov a.rottmann 2005 Mar 5 4 Manpage fixes for SQLite3
#c8c8c8 1172 code closed 2005 Mar anonymous 2005 Mar 1 3 sqlite3_step() seems to not reset database lock check
#c8c8c8 1173 code closed 2005 Mar anonymous 2005 Mar 1 1 C : if there is count(*) in a select then bug
#c8c8c8 1157 new closed 2005 Mar anonymous 2005 Mar drh 1 1 Is there a roadmap?
#c8c8c8 1155 doc closed 2005 Mar anonymous 2005 Mar 1 1 how i can get a month from a date with a SELECT
#c8c8c8 1143 code closed 2005 Feb anonymous 2005 Feb 2 2 prepare/step give incorrect results, compared to the sqlite3 tool
#c8c8c8 1130 doc closed 2005 Feb anonymous 2005 Feb 4 4 documentation for PRAGMA short-column-names incorrect
#c8c8c8 1118 build closed 2005 Feb anonymous 2005 Feb 1 1 pa
#c8c8c8 1106 code closed 2005 Feb anonymous 2005 Feb 2 1 sqlite3FinishCoding is masking errors during parsing
#c8c8c8 1105 code closed 2005 Feb 2005 Feb 1 3 SQLite Crashes when do a Correlated subqueries
#c8c8c8 1097 new closed 2005 Feb 2005 Feb 4 1 Please provide a numeric version number in sqlite3.h
#c8c8c8 1098 code closed 2005 Feb anonymous 2005 Feb 1 1 DBs created with PHP and the command line are incompatible
#c8c8c8 1091 code closed 2005 Jan anonymous 2005 Jan 1 1 not the function of ".export TABLE FILE"
#c8c8c8 1088 code closed 2005 Jan anonymous 2005 Jan 2 3 Allow Collations to work in Views
#c8c8c8 1086 code closed 2005 Jan anonymous 2005 Jan 2 3 sqlite crashes while executing query
#c8c8c8 747 code closed 2004 May anonymous 2005 Jan 3 3 database not closed if un-finalized VMs exist
#c8c8c8 840 code closed 2004 Aug anonymous 2005 Jan 1 1 Query returns invalid results (Index problem?).
#c8c8c8 999 build closed 2004 Nov anonymous 2005 Jan 5 4 CVS conflict files left in the source
#c8c8c8 466 todo closed 2003 Sep anonymous 2005 Jan 4 4 index internationalisation
#c8c8c8 449 new closed 2003 Sep anonymous 2005 Jan 3 4 Date and time functions for SELECTs
#c8c8c8 87 new closed 2002 Jun anonymous 2005 Jan 1 4 ORDER BY & ISO 8859-2
#c8c8c8 776 code closed 2004 Jun anonymous 2005 Jan 1 1 sqlite says Database is locked when database file is on Novel disk
#c8c8c8 981 code closed 2004 Nov anonymous 2005 Jan 1 1 UTF8 characters in database directory or filename not supported
#c8c8c8 695 code closed 2004 Apr anonymous 2005 Jan 3 3 CREATE INDEX and dbl-quoted index names
#c8c8c8 1060 code closed 2005 Jan anonymous 2005 Jan anonymous 1 2 result of calcul
#c8c8c8 990 code closed 2004 Nov anonymous 2005 Jan 1 1 PRAGMA empty_result_callbacks in tclsqlite-3.0.8.so eliminated?
#c8c8c8 598 code closed 2004 Feb anonymous 2005 Jan 1 4 Joins not supported in DELETE
#c8c8c8 264 code closed 2003 Mar anonymous 2005 Jan 5 4 Result of lseek for UNIX version of sqliteOsSeek() is not checked
#c8c8c8 1050 doc closed 2004 Dec anonymous 2004 Dec 4 4 Correct front page information - SQLite is not ACID
#c8c8c8 1045 event closed 2004 Dec anonymous 2004 Dec 1 5 MAJOR Problem with accessing databases
#c8c8c8 1044 code closed 2004 Dec anonymous 2004 Dec 3 3 Insert an integer as a string
#c8c8c8 1038 code closed 2004 Dec anonymous 2004 Dec 2 2 multi-word type names confuse pragma table_info
#c8c8c8 1027 code closed 2004 Dec anonymous 2004 Dec 1 3 Deletion of records that don't meet the condition set
#c8c8c8 1024 code closed 2004 Dec anonymous 2004 Dec 1 1 trunk blob data
#c8c8c8 1022 code closed 2004 Nov anonymous 2004 Dec 4 4 Table column naming differs between versions 2.8.15 and 3.0.8
#c8c8c8 1021 code closed 2004 Nov anonymous 2004 Dec 1 3 LIKE operator % wildcarding broken
#c8c8c8 1016 code closed 2004 Nov anonymous 2004 Nov 3 3 UPDATE command with invalid SQL Syntax executes
#c8c8c8 993 new closed 2004 Nov anonymous 2004 Nov 3 4 Plug-in codec support.
#c8c8c8 997 code closed 2004 Nov anonymous 2004 Nov 2 4 Returned column names include table name or alias.
#c8c8c8 37 code closed 2002 May anonymous 2004 Nov 3 3 can't open dbfile by apache process under mod_perl env.
#c8c8c8 983 code closed 2004 Nov anonymous 2004 Nov 1 1 assert()'s broken on both (some) 32 bit and (most) 64 bit platforms
#c8c8c8 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
#c8c8c8 976 code closed 2004 Oct anonymous 2004 Oct 1 1 Locale & upper/lower
#c8c8c8 961 new closed 2004 Oct anonymous 2004 Oct anonymous 5 5 a varchar value can be longer than its definition
#c8c8c8 957 new closed 2004 Oct ghaering 2004 Oct 1 1 Old callback-based API should still return column types
#c8c8c8 915 code closed 2004 Sep anonymous 2004 Sep 3 2 problem #901, but on read-only databases
#c8c8c8 921 code closed 2004 Sep anonymous 2004 Sep 5 5 2nd time: SQL does not support non-ASCII IO?
#c8c8c8 893 new closed 2004 Sep anonymous 2004 Sep 1 3 No string searches INSTR, LOCATE
#c8c8c8 792 code closed 2004 Jul anonymous 2004 Sep 1 1 ODBC support is broken for 3.0.2
#c8c8c8 796 code closed 2004 Jul anonymous 2004 Sep 1 2 sqlite3_open16 Unworkable
#c8c8c8 801 code closed 2004 Jul anonymous 2004 Sep 1 3 Multiple problems with v3.0.2
#c8c8c8 880 code closed 2004 Sep anonymous 2004 Sep 1 1 dropping a temporary table locks the database
#c8c8c8 879 new closed 2004 Aug anonymous 2004 Aug 5 3 Makefile should produce GCC compatible import library for DLL as well
#c8c8c8 733 code closed 2004 May anonymous 2004 Aug anonymous 3 3 About Ticket #731
#c8c8c8 868 doc closed 2004 Aug anonymous 2004 Aug 1 1 Conflict resolution fails when attempting to create duplicate key
#c8c8c8 866 code closed 2004 Aug anonymous 2004 Aug 2 3 Breakage when repeatedly creating tables in an attached database
#c8c8c8 856 code closed 2004 Aug anonymous 2004 Aug 1 1 memory leak within sqlite3_open()/sqlite3_close() pair
#c8c8c8 850 code closed 2004 Aug anonymous 2004 Aug 1 1 quoted table names not allowed in combination with *
#c8c8c8 836 code closed 2004 Aug anonymous 2004 Aug 1 1 sqlite3_prepare() fails when a temp table does not yet exists.
#c8c8c8 830 code closed 2004 Jul anonymous 2004 Jul 1 1 sqlite3_get_table() error
#c8c8c8 825 code closed 2004 Jul anonymous 2004 Jul 3 3 lower(X) / upper(X) - not work correctly on non Latin characters
#c8c8c8 817 new closed 2004 Jul anonymous 2004 Jul 4 2 Return size of blob
#c8c8c8 702 code closed 2004 Apr anonymous 2004 Jul 3 3 Bug in sorting: some strings sort in the middle of numerical values
#c8c8c8 809 code closed 2004 Jul anonymous 2004 Jul 2 1 Sqlite also fetches the hooks
#c8c8c8 790 code closed 2004 Jul anonymous 2004 Jul 1 1 Missing include file for the SQLITE distribution 3.0.x
#c8c8c8 779 code closed 2004 Jun anonymous 2004 Jun 4 1 duplicated declaration of sqlite3_changes() in sqlite.h.in
#c8c8c8 769 code closed 2004 Jun anonymous 2004 Jun 2 2 macro SQLITE_OMIT_AUTHORIZATION is not honored
#c8c8c8 767 new closed 2004 Jun anonymous 2004 Jun 1 1 Metadata of query
#c8c8c8 764 code closed 2004 Jun drh 2004 Jun drh 1 1 ROLLBACK disables TEMP triggers.
#c8c8c8 731 code closed 2004 May anonymous 2004 May 2 3 UNIQUE constraint not working when one of the fields is null
#c8c8c8 730 new closed 2004 May anonymous 2004 May 4 3 Differentiate context-sensetive user actions and navigation in UI
#c8c8c8 719 code closed 2004 May anonymous 2004 May 2 3 index_list not reporting my indeces
#c8c8c8 704 event closed 2004 Apr anonymous 2004 Apr 5 5 .database && .databases
#c8c8c8 701 todo closed 2004 Apr anonymous 2004 Apr drh 3 3 INSERT FAILED?
#c8c8c8 693 build closed 2004 Apr anonymous 2004 Apr 1 1 Compiling for freeBSD
#c8c8c8 688 code closed 2004 Apr anonymous 2004 Apr 1 1 Scope problem in subselect
#c8c8c8 677 code closed 2004 Mar anonymous 2004 Mar 2 3 Failure to convert to FP on division involving a constant
#c8c8c8 675 code closed 2004 Mar anonymous 2004 Mar 2 1 Malformed error at GET BLOB DATA from database file
#c8c8c8 674 code closed 2004 Mar anonymous 2004 Mar 3 4 insert record fails mpatrol tests
#c8c8c8 669 new closed 2004 Mar anonymous 2004 Mar 5 5 named-field?
#c8c8c8 664 new closed 2004 Mar anonymous 2004 Mar 5 5 In-Memory convert to disk database file?
#c8c8c8 663 new closed 2004 Mar anonymous 2004 Mar drh 5 5 SELECT TOP n?
#c8c8c8 661 new closed 2004 Mar anonymous 2004 Mar 5 5 In-Memory feature?
#c8c8c8 635 new closed 2004 Feb anonymous 2004 Mar 5 5 ROWID as ref. number
#c8c8c8 639 event closed 2004 Mar anonymous 2004 Mar 1 1 Why fixed tickets are not closed ?
#c8c8c8 632 doc closed 2004 Feb anonymous 2004 Feb 2 2 fix links on wrappers page
#c8c8c8 578 code closed 2004 Jan anonymous 2004 Feb 4 2 calling isdigit in sqliteIsNumber cause asserts (VC.NET)
#c8c8c8 607 code closed 2004 Feb anonymous 2004 Feb 1 1 odbc doesn't like field name date
#c8c8c8 606 code closed 2004 Feb anonymous 2004 Feb 1 1 odbc doesn't like datetime type - returns a null
#c8c8c8 600 code closed 2004 Feb anonymous 2004 Feb 1 1 unable to open database file, win32, Java jdbc
#c8c8c8 630 code closed 2004 Feb anonymous 2004 Feb 1 1 using uninitialized variable
#c8c8c8 625 code closed 2004 Feb anonymous 2004 Feb 1 1 CORE DUMPED when running sum() in DBD::SQLite
#c8c8c8 624 new closed 2004 Feb anonymous 2004 Feb 1 1 SQLite transaction...
#c8c8c8 619 code closed 2004 Feb anonymous 2004 Feb 1 1 Multiple BEGIN and COMMIT transaction problem...
#c8c8c8 595 code closed 2004 Feb anonymous 2004 Feb 1 4 Big joins dont work as I expect
#c8c8c8 596 code closed 2004 Feb anonymous 2004 Feb 1 1 sqlite_exec OR sqlite_get_table can not handle empty results sets
#c8c8c8 586 code closed 2004 Jan anonymous 2004 Jan 2 1 Memory allocation problem ?
#c8c8c8 585 code closed 2004 Jan anonymous 2004 Jan 1 1 sqlite is not thread safe
#c8c8c8 584 new closed 2004 Jan anonymous 2004 Jan anonymous 5 1 Cursor support in SQLite
#c8c8c8 570 event closed 2004 Jan anonymous 2004 Jan 5 5 database created on x86 can't work on arm
#c8c8c8 579 code closed 2004 Jan anonymous 2004 Jan 3 1 condition where sqlite_decode_binary will return -1
#c8c8c8 543 new closed 2003 Dec anonymous 2003 Dec 5 4 Feature Request: Indicate NOT NULL columns in table_info.
#c8c8c8 440 code closed 2003 Sep anonymous 2003 Dec drh 3 3 dayofmonth("now") returns one more than actual day
#c8c8c8 531 code closed 2003 Dec anonymous 2003 Dec 4 4 INT is not treated the same as INTEGER
#c8c8c8 464 code closed 2003 Sep anonymous 2003 Dec 2 2 VACUUM doesn't compile with sqlite_compile
#c8c8c8 513 code closed 2003 Dec anonymous 2003 Dec 2 3 C++-style comments prevent compilation
#c8c8c8 506 code closed 2003 Nov anonymous 2003 Nov 2 1 Result tuple not formed correctly on select query
#c8c8c8 371 event closed 2003 Jul anonymous 2003 Nov 1 1 crash in conflict.test
#c8c8c8 476 doc closed 2003 Oct anonymous 2003 Nov 3 3 Define for omitting time and date functions
#c8c8c8 494 new closed 2003 Nov anonymous 2003 Nov 4 4 No way to get a list of table columns without parsing the schema
#c8c8c8 475 code closed 2003 Oct anonymous 2003 Oct 1 1 question:how to use the sqlite in my VC6 project?
#c8c8c8 455 doc closed 2003 Sep anonymous 2003 Sep 4 2 undocumented functions: sqlite_mprintf,and sqlite_vmprintf
#c8c8c8 23 code closed 2002 Apr anonymous 2003 Aug drh 1 1 FieldName Returned Not Correct When Use Fast-East Chararctor Set
#c8c8c8 399 event closed 2003 Jul anonymous 2003 Jul drh 3 3 SELECT COUNT(*) FROM TABLE
#c8c8c8 379 new closed 2003 Jul anonymous 2003 Jul 5 1 use \' and \" instead of '' and "" only
#c8c8c8 375 new closed 2003 Jul anonymous 2003 Jul anonymous 4 4 I'm missing DB metadata.
#c8c8c8 119 doc closed 2002 Jul anonymous 2003 Jul 5 5 How to Compile Sqlite.dll With VC++
#c8c8c8 359 code closed 2003 Jun anonymous 2003 Jun 1 1 sum() returns incorrect value
#c8c8c8 320 doc closed 2003 May anonymous 2003 Jun jplyon 5 3 PRAGMA documentation should include numeric values of settings
#c8c8c8 344 event closed 2003 Jun anonymous 2003 Jun 1 1 select
#c8c8c8 85 todo closed 2002 Jun drh 2003 Apr 1 1 Document and test the sqlite_open_aux_file() API.
#c8c8c8 260 doc closed 2003 Mar anonymous 2003 Mar 5 4 may i add a contributed by to the wiki HowToCompile ?
#c8c8c8 251 code closed 2003 Feb anonymous 2003 Mar 1 1 ORDER BY doesn't work on TIMESTAMP column type
#c8c8c8 188 todo closed 2002 Nov drh 2002 Nov 1 1 Serialize disk I/O
#c8c8c8 183 code closed 2002 Oct anonymous 2002 Nov drh 1 1 Bug regarding grouping, left joining, aggregate functions
#c8c8c8 112 code closed 2002 Jul anonymous 2002 Sep 4 4 Segmentation fault in 2.5.5 when opening a 2.6.1 database
#c8c8c8 111 doc closed 2002 Jul anonymous 2002 Sep 1 3 2.6.1 does not permit SELECT within TRANSACTION whereas 2.5.5 did
#c8c8c8 108 code closed 2002 Jul anonymous 2002 Sep 1 1 Sqlite's Windows Dll Version Still Is 2.56
#c8c8c8 107 code closed 2002 Jul anonymous 2002 Sep 1 1 Incorrect query results
#c8c8c8 104 code closed 2002 Jul anonymous 2002 Sep 1 2 error in trigger on view after closing and reopening database
#c8c8c8 102 code closed 2002 Jul drh 2002 Sep 1 1 ORDER BY ignored in subquery
#c8c8c8 100 code closed 2002 Jul anonymous 2002 Sep 1 2 view not properly restored after closing and reopening database
#c8c8c8 99 todo closed 2002 Jul drh 2002 Sep 1 1 Document and export the sqlite_mprintf() API.
#c8c8c8 92 code closed 2002 Jul anonymous 2002 Sep 2 2 max() looks boggus in a view
#c8c8c8 91 todo closed 2002 Jul anonymous 2002 Sep 4 3 A command-line program for windows
#c8c8c8 90 code closed 2002 Jul anonymous 2002 Sep 1 1 table aliases in select commands stopped working
#c8c8c8 88 doc closed 2002 Jun anonymous 2002 Sep 4 4 Typo on web page
#c8c8c8 84 code closed 2002 Jun drh 2002 Sep 1 1 Complex left outer joins might give the wrong answer
#c8c8c8 83 todo closed 2002 Jun drh 2002 Sep drh 1 1 Add test cases
#c8c8c8 80 code closed 2002 Jun anonymous 2002 Sep 2 2 Heap corruption on select with ORDER BY, LIMIT, and OFFSET
#c8c8c8 79 code closed 2002 Jun drh 2002 Sep 1 1 Tables are not being dropped correctly under certain circumstances.
#c8c8c8 77 code closed 2002 Jun anonymous 2002 Sep 2 2 more than one LIMIT on nested select shows 0 rows
#c8c8c8 76 code closed 2002 Jun anonymous 2002 Sep 1 3 sqlite corruption possibly relating to drop of index
#c8c8c8 72 code closed 2002 Jun anonymous 2002 Sep 1 1 malloc test in testbed fails Win32 build of 2.4.12
#c8c8c8 71 code closed 2002 Jun anonymous 2002 Sep drh 2 4 "COPY table FROM file" expects lines to end with LF.
#c8c8c8 70 doc closed 2002 Jun anonymous 2002 Sep 5 5 Error in online documentation for DROP VIEW
#c8c8c8 66 code closed 2002 Jun anonymous 2002 Sep drh 1 2 LIMIT clause ignored in subselects
#c8c8c8 65 code closed 2002 Jun anonymous 2002 Sep 2 2 Error in .dump'ed INSERT statements
#c8c8c8 59 doc closed 2002 Jun anonymous 2002 Sep 3 4 Undocumented Concatenation Operator
#c8c8c8 54 todo closed 2002 Jun anonymous 2002 Sep 2 2 win32 binaries are missing symbols
#c8c8c8 53 new closed 2002 May anonymous 2002 Sep 5 4 Single checkpoint file enhancement
#c8c8c8 52 new closed 2002 May anonymous 2002 Sep 5 4 Backslash check on temporary file names under Win32
#c8c8c8 50 code closed 2002 May drh 2002 Sep 3 2 Memory leak in triggers on TEMP tables
#c8c8c8 47 code closed 2002 May anonymous 2002 Sep 5 4 Compiler Warning using MingW/gcc
#c8c8c8 45 code closed 2002 May anonymous 2002 Sep 4 4 Unique constraint problem on updating PRIMARY KEY column
#c8c8c8 44 code closed 2002 May anonymous 2002 Sep 3 3 UNIQUE constraint (incorrectly) applies to NULL
#c8c8c8 42 doc closed 2002 May drh 2002 Sep 1 1 Add comments to Trigger structures in sqliteInt.h
#c8c8c8 41 code closed 2002 May drh 2002 Sep 1 2 sqlite_complete() failure
#c8c8c8 40 code closed 2002 May drh 2002 Sep 3 3 Compiler warnings on RedHat 7.2
#c8c8c8 39 todo closed 2002 May drh 2002 Sep 5 1 Reformat the TRIGGER code for consistent style.
#c8c8c8 32 code closed 2002 May drh 2002 Sep 1 1 Columns in views are not always named correctly.
#c8c8c8 28 code closed 2002 Apr anonymous 2002 Sep drh 3 1 sqlite_changes not exported in sqlite.def in SQLite_source.zip
#c8c8c8 26 doc closed 2002 Apr anonymous 2002 Sep drh 5 4 Proc-1 Not Refresh Newer SQLITE_MASTER Info After Proc-2 CreateTable
#c8c8c8 22 code closed 2002 Apr anonymous 2002 Sep drh 2 1 compound selects as expressions
#c8c8c8 17 new closed 2002 Apr anonymous 2002 Sep drh 5 5 Enhancement of %q in sqlite...printf API
#c8c8c8 113 doc closed 2002 Jul anonymous 2002 Aug 5 5 Incorrect description of SQLite
#c8c8c8 125 code closed 2002 Jul anonymous 2002 Jul 2 1 Data and Category SELECT bug
#c8c8c8 121 code closed 2002 Jul anonymous 2002 Jul 1 1 Bug LEFT JOIN - GROUP BY
#c8c8c8 120 code closed 2002 Jul anonymous 2002 Jul 1 1 Strange comparison logic
#c8c8c8 123 new closed 2002 Jul anonymous 2002 Jul 3 3 Would like Query type info
#c8c8c8 122 new closed 2002 Jul anonymous 2002 Jul 3 3 BLOB support needs only an escape_string() function.
#c8c8c8 118 code closed 2002 Jul anonymous 2002 Jul 1 1 Under WinNT4.04 Call Opendatabase or Else Function Generate Error
#c8c8c8 117 code closed 2002 Jul anonymous 2002 Jul 1 1 run err with Hint Call msvcrt.dll.
#c8c8c8 116 code closed 2002 Jul anonymous 2002 Jul 1 1 run err with Hint Call msvcrt.dll.
#c8c8c8 109 new closed 2002 Jul anonymous 2002 Jul 5 4 Can the build process include a way to make a static library?
#c8c8c8 106 code closed 2002 Jul anonymous 2002 Jul 1 1 Bad handling of nulls
#c8c8c8 103 code closed 2002 Jul anonymous 2002 Jul 2 1 Memory Leak in the Server
#c8c8c8 101 new closed 2002 Jul anonymous 2002 Jul 3 3 builtin functions do not work properly with LIMIT clause
#c8c8c8 69 new closed 2002 Jun anonymous 2002 Jun 5 4 Sequences (some sort of auto-incremental fields...)
#c8c8c8 60 new closed 2002 Jun anonymous 2002 Jun 3 4 UPDATE Statement with FROM Clause FAILS
#c8c8c8 57 code closed 2002 Jun anonymous 2002 Jun 4 4 UPDATE Command Fails When Table Name is Part of SET Statement
#c8c8c8 61 new closed 2002 Jun anonymous 2002 Jun 1 1 Enhancement Request: Capability to Specify Table Join Type
#c8c8c8 58 new closed 2002 Jun anonymous 2002 Jun 4 4 Table JOIN Syntax Not Recognized
#c8c8c8 36 code closed 2002 May anonymous 2002 May 4 3 drop table doesn't clean up database
#c8c8c8 5 code closed 2002 Mar anonymous 2002 May 3 4 Bug submitter ignores severity/priority
#c8c8c8 27 code closed 2002 Apr anonymous 2002 Apr drh 2 2 incorrect result when doing select using quotes in where
#c8c8c8 25 code closed 2002 Apr anonymous 2002 Apr drh 1 1 continu ticket 23, I Direct Access Sqlite.dll
#c8c8c8 24 code closed 2002 Apr anonymous 2002 Apr drh 4 3 Make "update ... where ..." fail if where clause is false.
#c8c8c8 20 code closed 2002 Apr anonymous 2002 Apr drh 1 1 Order By clause not sorting correctly for string columns
#c8c8c8 18 event closed 2002 Apr anonymous 2002 Apr drh 1 1 The sqlite server does not run under windows xp
#c8c8c8 14 new closed 2002 Apr anonymous 2002 Apr drh 5 4 decouple the BTREE implementaion from sqlite