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