# |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
|
1047 |
code
|
fixed
|
2004 Dec
|
|
CodeGen
|
2005 Jan
|
|
1
|
1
|
text column comparison in joins may follow NUMERIC rules
|
edit |
1099 |
code
|
fixed
|
2005 Feb
|
|
VDBE
|
2005 Feb
|
|
1
|
1
|
make test fails on bind1.1.test
|
edit |
2257 |
doc
|
fixed
|
2007 Feb
|
adixon
|
|
2007 Mar
|
|
4
|
4
|
Auto-vacuum documentation misleading
|
edit |
29 |
new
|
fixed
|
2002 Apr
|
anonymous
|
|
2004 Jan
|
drh
|
3
|
1
|
Enhancement of column data types in views
|
edit |
30 |
new
|
fixed
|
2002 Apr
|
anonymous
|
|
2005 Feb
|
drh
|
2
|
4
|
Correlated subqueries are not supported
|
edit |
130 |
code
|
fixed
|
2002 Aug
|
anonymous
|
|
2002 Aug
|
|
3
|
3
|
No transactions across Linux threads seems restrictive.
|
edit |
132 |
new
|
fixed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
|
3
|
3
|
Temp file path
|
edit |
133 |
code
|
fixed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
|
5
|
5
|
sqlite.exe crashes
|
edit |
134 |
code
|
fixed
|
2002 Aug
|
anonymous
|
Parser
|
2002 Aug
|
anonymous
|
2
|
4
|
syntax error in lemon.c on IBM AIX systems (both gcc and xlc)
|
edit |
135 |
new
|
fixed
|
2002 Aug
|
anonymous
|
|
2002 Aug
|
|
5
|
4
|
Code optimizations (to reduce compilation warnings under BC5 Windows)
|
edit |
137 |
code
|
fixed
|
2002 Aug
|
anonymous
|
Shell
|
2002 Aug
|
|
4
|
3
|
shell's find_home_dir() is ineffecient
|
edit |
142 |
code
|
fixed
|
2002 Aug
|
anonymous
|
|
2002 Aug
|
|
1
|
1
|
Incorrect Order By when column is null
|
edit |
147 |
code
|
fixed
|
2002 Sep
|
anonymous
|
|
2002 Sep
|
|
1
|
1
|
"INSERT into xxx SELECT yyy ORDER BY zzz LIMIT 1" ignores the limit
|
edit |
150 |
doc
|
fixed
|
2002 Sep
|
anonymous
|
Unknown
|
2002 Sep
|
anonymous
|
2
|
2
|
Missing documentation files
|
edit |
152 |
code
|
fixed
|
2002 Sep
|
anonymous
|
Unknown
|
2002 Sep
|
|
1
|
1
|
"make test" has errors
|
edit |
153 |
code
|
fixed
|
2002 Sep
|
anonymous
|
Parser
|
2003 Jan
|
|
1
|
1
|
PRAGMA SHOW_DATATYPES bug
|
edit |
155 |
code
|
fixed
|
2002 Sep
|
anonymous
|
Unknown
|
2002 Dec
|
|
2
|
2
|
sqliteSortCompare var dir uninitialized
|
edit |
159 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2003 Apr
|
drh
|
2
|
2
|
Triggers don't work _at all_ in the presence autoincrement fields
|
edit |
160 |
code
|
fixed
|
2002 Oct
|
anonymous
|
|
2005 Jan
|
|
1
|
4
|
trigger not called when user-defined function used
|
edit |
163 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
2
|
2
|
Buggy initialization of random generator on win32
|
edit |
166 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
1
|
1
|
Left outer join doesn't seem to be working
|
edit |
168 |
new
|
fixed
|
2002 Oct
|
anonymous
|
Shell
|
2003 Apr
|
|
4
|
4
|
Startup file complicates dumping a database
|
edit |
171 |
code
|
fixed
|
2002 Oct
|
anonymous
|
|
2002 Oct
|
drh
|
1
|
3
|
incompatibility with Borland run-time library
|
edit |
172 |
code
|
tested
|
2002 Oct
|
anonymous
|
|
2002 Oct
|
drh
|
3
|
3
|
incompatibility with Borland compiler
|
edit |
173 |
todo
|
fixed
|
2002 Oct
|
anonymous
|
|
2002 Oct
|
drh
|
4
|
3
|
publish.sh does not build dll correctly
|
edit |
174 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
drh
|
1
|
3
|
inconsistent data types
|
edit |
178 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
2
|
3
|
Undefinied pointer with sqlite_get_table (empty result set)
|
edit |
185 |
code
|
fixed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
1
|
1
|
Crash when running specific SQL
|
edit |
187 |
code
|
fixed
|
2002 Nov
|
anonymous
|
Parser
|
2002 Dec
|
|
2
|
2
|
Having count(*) issue
|
edit |
189 |
code
|
fixed
|
2002 Nov
|
anonymous
|
|
2002 Nov
|
|
4
|
4
|
sqlite html output format produces extra </TD>
|
edit |
190 |
code
|
fixed
|
2002 Nov
|
anonymous
|
|
2002 Nov
|
|
1
|
3
|
the btree code crashes on LP64 systems
|
edit |
191 |
code
|
fixed
|
2002 Nov
|
anonymous
|
Unknown
|
2003 Jan
|
drh
|
1
|
1
|
Large file support does not work in Windows
|
edit |
193 |
code
|
fixed
|
2002 Nov
|
anonymous
|
Unknown
|
2002 Dec
|
|
3
|
3
|
Incorrect creation of a VIEW when using SELECT ... LIMIT
|
edit |
194 |
new
|
fixed
|
2002 Nov
|
anonymous
|
BTree
|
2003 Apr
|
|
5
|
3
|
Remove warnings in btree.c
|
edit |
195 |
code
|
fixed
|
2002 Nov
|
anonymous
|
|
2002 Nov
|
|
2
|
4
|
Borland Compiler error for long long definition in os.h
|
edit |
197 |
code
|
fixed
|
2002 Dec
|
anonymous
|
Unknown
|
2002 Dec
|
|
1
|
1
|
Missing .yacc & .lex file...
|
edit |
198 |
todo
|
fixed
|
2002 Dec
|
anonymous
|
|
2003 Jan
|
|
1
|
1
|
Descending sort order in indices
|
edit |
200 |
code
|
fixed
|
2002 Dec
|
anonymous
|
Pager
|
2002 Dec
|
|
3
|
3
|
full pathname of database not recorded, so errors when chdir used
|
edit |
202 |
code
|
fixed
|
2002 Dec
|
anonymous
|
|
2002 Dec
|
|
1
|
1
|
make test core-dumps on solaris
|
edit |
206 |
code
|
fixed
|
2002 Dec
|
anonymous
|
Pager
|
2003 Jan
|
|
3
|
3
|
Local variable used before it is initialised
|
edit |
208 |
code
|
fixed
|
2002 Dec
|
anonymous
|
BTree
|
2002 Dec
|
|
2
|
2
|
pager.c uninitlized local variable
|
edit |
210 |
code
|
fixed
|
2002 Dec
|
anonymous
|
Unknown
|
2003 Jan
|
drh
|
1
|
1
|
Segfault on OSX with Perl bindings
|
edit |
211 |
new
|
fixed
|
2002 Dec
|
anonymous
|
Unknown
|
2003 Jan
|
|
4
|
4
|
How to add comments to an SQL-File
|
edit |
213 |
new
|
fixed
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Aug
|
|
4
|
4
|
Cygwin port needs __CYGWIN_USE_BIG_TYPES__ defined
|
edit |
215 |
new
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Feb
|
|
4
|
2
|
sqlite authorizer callback
|
edit |
218 |
new
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
2
|
2
|
MacOS port for submission to CVS
|
edit |
220 |
code
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
4
|
3
|
AS clause disables retrieving data types
|
edit |
221 |
doc
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
2
|
4
|
pragma show_datatypes not documented
|
edit |
222 |
code
|
fixed
|
2003 Jan
|
anonymous
|
VDBE
|
2003 Jan
|
|
3
|
3
|
cleanup tries to access memory out of array bounds
|
edit |
223 |
code
|
fixed
|
2003 Jan
|
anonymous
|
VDBE
|
2003 Jan
|
|
3
|
3
|
using uninitialized memory's value
|
edit |
224 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Pager
|
2003 Jan
|
|
3
|
3
|
read overflows memory
|
edit |
225 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Jan
|
|
3
|
4
|
reading uninitialized memory
|
edit |
226 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Jan
|
|
2
|
2
|
Glob doesn't work for upercase letters
|
edit |
227 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Pager
|
2003 Jan
|
|
2
|
1
|
win32 db locked
|
edit |
231 |
code
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Jan
|
|
2
|
3
|
sqlite deny acces with wrong return value
|
edit |
232 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Parser
|
2003 Feb
|
|
2
|
2
|
group by result is wrong
|
edit |
234 |
code
|
fixed
|
2003 Jan
|
anonymous
|
|
2003 Apr
|
|
4
|
4
|
Impossibility to have Comments and DOT-Commands in an SQL-File
|
edit |
237 |
code
|
fixed
|
2003 Jan
|
anonymous
|
Parser
|
2003 Jan
|
|
2
|
2
|
suspected problem in IN operator
|
edit |
240 |
code
|
fixed
|
2003 Feb
|
anonymous
|
|
2003 Apr
|
|
5
|
4
|
fcntl return code checked instead of errno
|
edit |
245 |
code
|
fixed
|
2003 Feb
|
anonymous
|
Parser
|
2003 Feb
|
|
3
|
3
|
LIMIT and OFFSET clause
|
edit |
246 |
event
|
fixed
|
2003 Feb
|
anonymous
|
Unknown
|
2003 Feb
|
|
2
|
3
|
View not the same as direct query
|
edit |
247 |
code
|
fixed
|
2003 Feb
|
anonymous
|
VDBE
|
2003 Feb
|
drh
|
1
|
1
|
OUTER JOIN problem
|
edit |
249 |
code
|
fixed
|
2003 Feb
|
anonymous
|
Unknown
|
2004 Aug
|
drh
|
1
|
1
|
install
|
edit |
250 |
code
|
fixed
|
2003 Feb
|
anonymous
|
Unknown
|
2003 Mar
|
|
2
|
1
|
SQLite_Changes increments with new non-callback
|
edit |
256 |
code
|
fixed
|
2003 Feb
|
anonymous
|
|
2003 May
|
|
3
|
2
|
Simple Makefile error on HP/UX, may affect other UNIX systems
|
edit |
257 |
code
|
fixed
|
2003 Feb
|
anonymous
|
VDBE
|
2003 Mar
|
|
4
|
3
|
sqliteVdbeList should return SQLITE_DONE not SQLITE_OK
|
edit |
258 |
code
|
fixed
|
2003 Feb
|
anonymous
|
Parser
|
2003 Mar
|
|
3
|
3
|
sqlite_compile doesn't work with (some?) PRAGMAs
|
edit |
262 |
new
|
fixed
|
2003 Mar
|
anonymous
|
Unknown
|
2003 Jun
|
|
4
|
4
|
Non Callback is Slow on scripts
|
edit |
269 |
new
|
fixed
|
2003 Mar
|
anonymous
|
|
2005 Jan
|
|
3
|
3
|
table.column view columns can not be referenced in where clause
|
edit |
270 |
code
|
fixed
|
2003 Mar
|
anonymous
|
Unknown
|
2003 Apr
|
|
3
|
4
|
incorrect check for fcntl error code
|
edit |
272 |
code
|
fixed
|
2003 Mar
|
anonymous
|
|
2003 May
|
|
3
|
3
|
select on view with where clause does not use index
|
edit |
275 |
code
|
fixed
|
2003 Mar
|
anonymous
|
CodeGen
|
2003 Apr
|
|
3
|
5
|
"INSERT INTO x SELECT * FROM x" doesn't work when x is a TEMP table
|
edit |
276 |
new
|
fixed
|
2003 Apr
|
anonymous
|
Shell
|
2003 Apr
|
|
3
|
3
|
Proposal/Bug-Fix for TTY determination
|
edit |
277 |
code
|
fixed
|
2003 Apr
|
anonymous
|
Parser
|
2003 Apr
|
|
1
|
2
|
Multi-line comments cause syntax errors in ".read" files
|
edit |
280 |
code
|
fixed
|
2003 Apr
|
anonymous
|
|
2003 Apr
|
|
2
|
2
|
Revise your code to use <stdarg.h>
|
edit |
281 |
code
|
fixed
|
2003 Apr
|
anonymous
|
|
2003 Apr
|
|
1
|
1
|
expression 0 = '' is true
|
edit |
282 |
code
|
fixed
|
2003 Apr
|
anonymous
|
Unknown
|
2003 May
|
|
2
|
3
|
Echo "\n" on Solaris causes two linebreaks. Makefile problem.
|
edit |
284 |
code
|
fixed
|
2003 Apr
|
anonymous
|
Unknown
|
2003 Apr
|
|
2
|
1
|
"make test" --> Segmentation Fault on Solaris
|
edit |
288 |
code
|
fixed
|
2003 Apr
|
anonymous
|
|
2003 Apr
|
|
1
|
1
|
sqlite don't compile on SuSE 8.2 (gcc 3.3)
|
edit |
289 |
code
|
fixed
|
2003 Apr
|
anonymous
|
BTree
|
2003 Apr
|
|
1
|
1
|
File src/btree_rb.c is missing
|
edit |
293 |
code
|
fixed
|
2003 Apr
|
anonymous
|
|
2003 Apr
|
paul
|
1
|
2
|
configure-script broken by checkin #903
|
edit |
296 |
code
|
fixed
|
2003 Apr
|
anonymous
|
VDBE
|
2003 Apr
|
|
1
|
4
|
crash sqlite or execute via libtclsqlite
|
edit |
297 |
code
|
fixed
|
2003 Apr
|
anonymous
|
|
2003 Apr
|
|
1
|
1
|
sqliteSortCompare crashes when sorting ints by more than one key
|
edit |
299 |
new
|
fixed
|
2003 Apr
|
anonymous
|
Parser
|
2006 Aug
|
|
2
|
3
|
Cannot insert only default values.
|
edit |
300 |
new
|
fixed
|
2003 Apr
|
anonymous
|
|
2005 Feb
|
|
5
|
5
|
Correlated Subqueries are not supported
|
edit |
302 |
code
|
fixed
|
2003 Apr
|
anonymous
|
Shell
|
2003 Apr
|
|
3
|
3
|
.sqliterc can do memory fault
|
edit |
308 |
todo
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
1
|
1
|
can not unzip downloaded binary files
|
edit |
309 |
code
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
5
|
5
|
Source code files are corrupted
|
edit |
310 |
code
|
fixed
|
2003 May
|
anonymous
|
Pager
|
2003 May
|
|
3
|
3
|
win32 locking error
|
edit |
311 |
code
|
fixed
|
2003 May
|
anonymous
|
|
2003 May
|
|
3
|
3
|
configure fails with non gcc compilers due to non escaped \n in test
|
edit |
313 |
code
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
2
|
3
|
Creating a table with a specific name crashes SQLite.
|
edit |
315 |
code
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
3
|
3
|
Usage of potentially changed address
|
edit |
316 |
code
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 Aug
|
|
2
|
3
|
Cygwin with gcc V2.95.3 compilation -- os.h
|
edit |
318 |
code
|
fixed
|
2003 May
|
anonymous
|
Unknown
|
2003 Jul
|
drh
|
1
|
1
|
dl-minimal.c: 128: realloc: Asseration failure...
|
edit |
322 |
code
|
fixed
|
2003 May
|
anonymous
|
|
2003 Aug
|
|
3
|
3
|
Configure problem with ming32 on win32 (XP) and all sqlite version
|
edit |
323 |
code
|
fixed
|
2003 May
|
anonymous
|
CodeGen
|
2003 Jun
|
|
1
|
1
|
Assertion failed by attaching a file
|
edit |
327 |
code
|
fixed
|
2003 May
|
anonymous
|
|
2003 Aug
|
|
1
|
1
|
Cygwin 1.3.22 compile failure
|
edit |
332 |
code
|
tested
|
2003 May
|
anonymous
|
Unknown
|
2003 Jun
|
|
5
|
1
|
Dropping a temp trigger causes an access violation
|
edit |
333 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
1
|
1
|
Temp Triggers cause update/delete statement failure with explicit transaction
|
edit |
336 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
4
|
2
|
Compiler warnings on SQLite 2.8.3
|
edit |
337 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
4
|
4
|
.dll produces database files claiming version 2.0.1
|
edit |
340 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
1
|
2
|
ATTACH database needs an authorization hook
|
edit |
341 |
code
|
fixed
|
2003 Jun
|
anonymous
|
VDBE
|
2003 Jun
|
|
4
|
3
|
vdbe.c calls access() instead of sqliteOsFileExists()
|
edit |
342 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
5
|
3
|
vxprintf() makes invalid assumptions about size of pointer and long
|
edit |
345 |
event
|
fixed
|
2003 Jun
|
anonymous
|
BTree
|
2003 Jun
|
|
4
|
4
|
repeated returns
|
edit |
346 |
code
|
fixed
|
2003 Jun
|
anonymous
|
BTree
|
2003 Jul
|
|
3
|
3
|
Problem with LIMIT 0
|
edit |
347 |
code
|
fixed
|
2003 Jun
|
anonymous
|
BTree
|
2003 Jun
|
|
4
|
3
|
Workaround for warning that print_node() in btree_rb.c is unused
|
edit |
349 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Aug
|
|
3
|
2
|
Cygwin build errors
|
edit |
350 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
2
|
3
|
LEFT JOIN works improperly on static inner queries and views
|
edit |
351 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Pager
|
2003 Jun
|
|
2
|
3
|
Journal pager playback doesn't secure exclusive access
|
edit |
352 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Shell
|
2003 Jun
|
|
3
|
3
|
The sqlite shell ignores empty lines inside SQL strings
|
edit |
353 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
4
|
3
|
Compile errors when SQLITE_OMIT_AUTHORIZATION is defined
|
edit |
354 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jul
|
|
3
|
2
|
ATTACH DATABASE call asserts in build.c in Debug Mode in MSVC7.1
|
edit |
355 |
code
|
fixed
|
2003 Jun
|
anonymous
|
BTree
|
2003 Jun
|
|
4
|
3
|
Compile warning when NDEBUG is defined
|
edit |
357 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Pager
|
2003 Aug
|
drh
|
4
|
3
|
Compilation errors and warnings when compiled on Open VMS
|
edit |
360 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
2
|
3
|
"not N between n and m" in trigger dumps core
|
edit |
361 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
anonymous
|
3
|
3
|
main.c doesn't compile when SQLITE_OMIT_TRACE=1
|
edit |
364 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
3
|
3
|
Assert when doing SELECT ROWID,* against a VIEW
|
edit |
365 |
code
|
fixed
|
2003 Jun
|
anonymous
|
VDBE
|
2003 Jun
|
|
3
|
4
|
Can not define SQLITE_OMIT_AUTHORIZATION
|
edit |
367 |
code
|
fixed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
4
|
1
|
soundex bug
|
edit |
370 |
code
|
fixed
|
2003 Jun
|
anonymous
|
|
2004 Feb
|
dougcurrie
|
2
|
3
|
make fulltest status on Cygwin, failure on 2 tests
|
edit |
373 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Aug
|
|
1
|
2
|
2.8.4 Cygwin compile failure
|
edit |
377 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
1
|
3
|
Comparisons of integer primary key to float are erroneous
|
edit |
378 |
doc
|
fixed
|
2003 Jul
|
anonymous
|
Shell
|
2003 Jul
|
|
5
|
4
|
sqlite command line utility still needs file name
|
edit |
383 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
1
|
3
|
sqlite_changes returns wrong value with non-callback API
|
edit |
384 |
new
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
4
|
4
|
NULL argument for pzTail to sqlite_compile causes access violation
|
edit |
385 |
new
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
4
|
4
|
NULL args for output variables to sqlite_step cause access violation
|
edit |
387 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Parser
|
2003 Jul
|
|
1
|
1
|
Parse has problems with parser names ...
|
edit |
393 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
3
|
4
|
UNION and LIMIT incorrectly
|
edit |
394 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Parser
|
2003 Jul
|
|
4
|
1
|
SELECT 1; syntax throw run-time compiler warning
|
edit |
396 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
3
|
2
|
AGGREGATE FUNCTION WITH LIMIT
|
edit |
397 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
4
|
3
|
tests attach-5.1 and attach2-1.1 fail on w2k mingw
|
edit |
400 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
3
|
4
|
shell.c, when readline() not avail, getline() conflicts with stdio's
|
edit |
401 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
2
|
3
|
Source downloads considered useless..
|
edit |
405 |
todo
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
1
|
1
|
Missing complete unix source tarballs
|
edit |
406 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
1
|
1
|
BEGIN ON CONFLICT ROLLBACK
|
edit |
408 |
code
|
fixed
|
2003 Jul
|
anonymous
|
VDBE
|
2003 Jul
|
|
1
|
1
|
toInt() reports success on overflow, causes comparisons to fail
|
edit |
410 |
code
|
fixed
|
2003 Jul
|
anonymous
|
Pager
|
2003 Jul
|
|
3
|
4
|
Creation and deltions of files should fsync() directory
|
edit |
416 |
code
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
1
|
1
|
An SQL DML which yields a segfault
|
edit |
419 |
new
|
fixed
|
2003 Jul
|
anonymous
|
|
2003 Aug
|
|
4
|
3
|
Return index name with 'uniqueness constraint failed' error message
|
edit |
421 |
code
|
fixed
|
2003 Aug
|
anonymous
|
|
2003 Aug
|
|
3
|
3
|
bug on sqliteRealloc_
|
edit |
427 |
code
|
fixed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Aug
|
|
2
|
2
|
access violation on vacuum with pragma empty_result_callbacks
|
edit |
429 |
code
|
fixed
|
2003 Aug
|
anonymous
|
|
2003 Aug
|
|
1
|
2
|
os.h cygwin compilation patch
|
edit |
433 |
new
|
fixed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Dec
|
dougcurrie
|
3
|
2
|
configure needs updating for mingw/msys
|
edit |
434 |
code
|
fixed
|
2003 Aug
|
anonymous
|
|
2003 Aug
|
|
3
|
3
|
vacuum-3.1 test fails on Win2k needs db2 close
|
edit |
435 |
code
|
fixed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Aug
|
|
3
|
3
|
backslash in Makefile hides clean target
|
edit |
439 |
code
|
fixed
|
2003 Aug
|
anonymous
|
Unknown
|
2005 Jan
|
|
2
|
3
|
Query fails when run as a View
|
edit |
444 |
code
|
fixed
|
2003 Sep
|
anonymous
|
Shell
|
2003 Dec
|
|
3
|
4
|
free (zErrMsg) in shell.c should be sqlite_freemem(zErrMsg)
|
edit |
447 |
event
|
fixed
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
3
|
1
|
Problems compiling on FreeBSD 4.8-STABLE
|
edit |
452 |
code
|
fixed
|
2003 Sep
|
anonymous
|
TclLib
|
2003 Dec
|
|
4
|
3
|
DbMain assumes sscanf likes 0x... syntax for pointers, breaking tests
|
edit |
453 |
code
|
fixed
|
2003 Sep
|
anonymous
|
Parser
|
2003 Sep
|
|
3
|
3
|
"SELECT a, b FROM tt;-" Crashes SQLite
|
edit |
460 |
new
|
fixed
|
2003 Sep
|
anonymous
|
VDBE
|
2003 Nov
|
|
5
|
5
|
[Patch] extending copy command for dump file of PostgerSQL pg_dump.
|
edit |
461 |
code
|
fixed
|
2003 Sep
|
anonymous
|
CodeGen
|
2003 Sep
|
|
3
|
3
|
Nulls are incorrectly returned on an indexed column
|
edit |
468 |
code
|
fixed
|
2003 Oct
|
anonymous
|
|
2003 Oct
|
|
2
|
2
|
DROP TRIGGER w/ single quotes doesn't work.
|
edit |
469 |
code
|
fixed
|
2003 Oct
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
3
|
Qualified column name in subselect not recognized in outer select
|
edit |
480 |
code
|
fixed
|
2003 Oct
|
anonymous
|
CodeGen
|
2005 Sep
|
|
3
|
5
|
Joins with more than 32 tables are broken
|
edit |
481 |
code
|
fixed
|
2003 Oct
|
anonymous
|
VDBE
|
2004 Feb
|
|
1
|
3
|
last_insert_rowid doesn't work within triggers any more
|
edit |
482 |
code
|
fixed
|
2003 Oct
|
anonymous
|
BTree
|
2003 Dec
|
|
1
|
1
|
SIGSEGV inside memRbtreeNext
|
edit |
487 |
code
|
fixed
|
2003 Nov
|
anonymous
|
|
2003 Nov
|
|
2
|
2
|
mac os x build via pear creates invalid bundle
|
edit |
488 |
doc
|
fixed
|
2003 Nov
|
anonymous
|
|
2003 Nov
|
|
5
|
4
|
Lemon Parser Generator page is outdated
|
edit |
502 |
doc
|
fixed
|
2003 Nov
|
anonymous
|
BTree
|
2003 Nov
|
|
5
|
3
|
Typos in Database File Format documentation
|
edit |
504 |
code
|
fixed
|
2003 Nov
|
anonymous
|
|
2004 Feb
|
|
3
|
3
|
'INDEX_INFO' PRAGMA returns invalid data if used with non-callback API
|
edit |
505 |
doc
|
fixed
|
2003 Nov
|
anonymous
|
|
2003 Nov
|
|
5
|
3
|
Typos in SQLite Database File Format document
|
edit |
514 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Unknown
|
2004 Mar
|
|
2
|
3
|
attaching a locked database causes strange errors and a crash
|
edit |
515 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Unknown
|
2003 Dec
|
|
4
|
3
|
VACUUM fails after dependent table DROP,CREATE sequence
|
edit |
520 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
drh
|
2
|
2
|
tokenize bug in simultaneous threaded sqlite_open (with patch)
|
edit |
521 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Unknown
|
2004 Jul
|
|
2
|
1
|
"create as select ..." does not preserve datatypes
|
edit |
523 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Unknown
|
2005 Jan
|
|
2
|
2
|
Select table 'AS' does not work in JOIN USING clause
|
edit |
526 |
code
|
fixed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
1
|
1
|
Primary key not unique (database corruption?)
|
edit |
530 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Pager
|
2003 Dec
|
|
2
|
2
|
sqlite returns SQLITE_BUSY forever (linux multithreaded)
|
edit |
533 |
code
|
fixed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
2
|
1
|
Crash when using datetime() with a NULL value.
|
edit |
534 |
code
|
fixed
|
2003 Dec
|
anonymous
|
|
2004 Jan
|
|
2
|
2
|
possible bug in sqliteMalloc and sqliteMallocRaw
|
edit |
541 |
code
|
fixed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
drh
|
1
|
1
|
Compile error in os.c
|
edit |
542 |
code
|
fixed
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
|
1
|
1
|
crash on date parsing
|
edit |
545 |
code
|
fixed
|
2004 Jan
|
anonymous
|
BTree
|
2004 Jan
|
|
5
|
4
|
Use of uninitialized memory
|
edit |
548 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Parser
|
2004 Jan
|
|
3
|
3
|
SQLite will abort() when utf-8 character is invalid
|
edit |
551 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
3
|
3
|
Date/Time functions: some modifiers cause loss of h:m:s
|
edit |
564 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Parser
|
2005 Jan
|
|
4
|
4
|
Inability to determine column in subquery
|
edit |
565 |
code
|
fixed
|
2004 Jan
|
anonymous
|
VDBE
|
2004 Jan
|
|
2
|
3
|
sqlite: src/vdbe.c:512: sqliteVdbeExec: Assertion `p->tos<=pc' failed.
|
edit |
567 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
3
|
3
|
Erroneous test for rowid >= (fp number) in where clause
|
edit |
568 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Shell
|
2004 Feb
|
|
2
|
2
|
Shell does not handle -init option correctly
|
edit |
576 |
code
|
fixed
|
2004 Jan
|
anonymous
|
CodeGen
|
2004 Feb
|
|
1
|
2
|
last_insert_rowid() returns wrong values in triggers on views
|
edit |
577 |
doc
|
fixed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
5
|
3
|
Typo on main SQLite home page
|
edit |
582 |
build
|
fixed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
4
|
3
|
no permission to execute install-sh
|
edit |
583 |
warn
|
fixed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Feb
|
|
4
|
4
|
_FILE_OFFSET_BITS redefined on 64bit sparc-sun-solaris
|
edit |
587 |
code
|
fixed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
3
|
1
|
easy way to operate on a max () value
|
edit |
593 |
code
|
fixed
|
2004 Feb
|
anonymous
|
VDBE
|
2004 Feb
|
|
3
|
3
|
Interrupted VACUUM returns SQLITE_ERROR not SQLITE_INTERRUPT
|
edit |
594 |
code
|
fixed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
TEMP tables not dropped by ROLLBACK if sqlite_interrupt was called
|
edit |
599 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Pager
|
2004 Feb
|
|
1
|
2
|
Corrupt problem encountered on Windows NT platform
|
edit |
601 |
code
|
fixed
|
2004 Feb
|
anonymous
|
CodeGen
|
2004 Feb
|
|
1
|
1
|
Left-join subquery gives incorrect results
|
edit |
602 |
code
|
fixed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
Update tablename set rowid = rowid -1 fails for more than 1000 records
|
edit |
603 |
code
|
fixed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
4
|
4
|
compile error date.c if SQLITE_OMIT_DATETIME_FUNCS defined
|
edit |
604 |
warn
|
fixed
|
2004 Feb
|
anonymous
|
Parser
|
2004 Feb
|
|
4
|
4
|
'db' has been referenced but never assigned a value
|
edit |
605 |
warn
|
fixed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
_FILE_OFFSET_BITS redefined
|
edit |
610 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Parser
|
2004 Feb
|
|
5
|
4
|
REPLACE INTO syntax not allowed in triggers
|
edit |
612 |
code
|
fixed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
anonymous
|
3
|
1
|
Pointer 'db' not initialized in function lookupname() (expr.c)
|
edit |
614 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Shell
|
2004 Feb
|
|
2
|
1
|
history not saved after quitting the shell with .quit
|
edit |
617 |
new
|
fixed
|
2004 Feb
|
anonymous
|
Unknown
|
2004 Feb
|
|
5
|
4
|
date() conversion seems to fail on -ve dates
|
edit |
620 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Shell
|
2004 Feb
|
|
1
|
1
|
sqlite executable crashes
|
edit |
623 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Unknown
|
2004 Feb
|
|
2
|
3
|
Erroneous min/max on US zip codes
|
edit |
626 |
code
|
fixed
|
2004 Feb
|
anonymous
|
Parser
|
2004 Feb
|
|
2
|
2
|
EXPLAIN BEGIN TRANSACTION really starts a transaction
|
edit |
634 |
warn
|
fixed
|
2004 Feb
|
anonymous
|
Unknown
|
2004 Feb
|
|
3
|
3
|
Compiler warnings when compiling using LCC
|
edit |
641 |
code
|
fixed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
1
|
1
|
select query doen't work with binary equations
|
edit |
654 |
code
|
fixed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
3
|
2
|
Can't compile with CodeWarrior Studio v9.1
|
edit |
655 |
code
|
fixed
|
2004 Mar
|
anonymous
|
VDBE
|
2004 Jul
|
|
1
|
3
|
Numeric/string confusion with "in"
|
edit |
658 |
code
|
fixed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
3
|
3
|
select max(rowid) from union crashes sqlite command-line
|
edit |
659 |
code
|
fixed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
4
|
4
|
+1 month issue (dead or defective code) in date.c
|
edit |
665 |
code
|
fixed
|
2004 Mar
|
anonymous
|
|
2004 Apr
|
|
3
|
3
|
Lemon.c + OpenWatcom 1.3
|
edit |
668 |
code
|
fixed
|
2004 Mar
|
anonymous
|
VDBE
|
2004 Mar
|
|
2
|
2
|
sqlite crash on combinng case and not in
|
edit |
670 |
code
|
fixed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
3
|
3
|
The '.database' trunc file name
|
edit |
680 |
code
|
fixed
|
2004 Mar
|
anonymous
|
Parser
|
2004 Jul
|
|
3
|
3
|
Parser fails on quoted table/alias DOT STAR
|
edit |
683 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Jul
|
|
1
|
1
|
Impossible to drop index with single quotes in the name
|
edit |
686 |
code
|
fixed
|
2004 Apr
|
anonymous
|
|
2004 Jul
|
|
2
|
3
|
select + indexes + left join + "in (set)" causes core dump
|
edit |
687 |
code
|
fixed
|
2004 Apr
|
anonymous
|
|
2004 Jul
|
|
4
|
2
|
Sqlite incorrectly handles invalid filenames.
|
edit |
690 |
code
|
fixed
|
2004 Apr
|
anonymous
|
|
2005 Jan
|
|
3
|
3
|
NATURAL JOIN does not work with table aliases
|
edit |
692 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Parser
|
2004 Apr
|
|
3
|
3
|
lemon.c:void emit_destructor_code() pointer unitialized
|
edit |
703 |
code
|
fixed
|
2004 Apr
|
anonymous
|
|
2004 Jul
|
|
3
|
3
|
Aggregate functions (min/max) fail over sub-queries
|
edit |
705 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Parser
|
2004 Jul
|
|
3
|
3
|
can't handle special char in column name
|
edit |
708 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Jul
|
rdc
|
4
|
1
|
nonASCII Upper & Lower
|
edit |
713 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Jul
|
drh
|
3
|
3
|
Compiling with SQLITE_OMIT_DATETIME_FUNCS causes error
|
edit |
716 |
code
|
fixed
|
2004 Apr
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
4
|
create table as should preserve column types
|
edit |
743 |
code
|
fixed
|
2004 May
|
anonymous
|
Parser
|
2005 Jun
|
|
2
|
2
|
WHERE clause with USING incorrectly requires table name
|
edit |
749 |
code
|
fixed
|
2004 May
|
anonymous
|
CodeGen
|
2004 Jul
|
|
2
|
1
|
SELECT DISTINCT with LIMIT
|
edit |
756 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jul
|
|
2
|
3
|
Core Dump - Select From View
|
edit |
757 |
code
|
fixed
|
2004 Jun
|
anonymous
|
VDBE
|
2004 Jun
|
|
3
|
3
|
Indexes on temporary tables leave cursors open
|
edit |
758 |
code
|
fixed
|
2004 Jun
|
anonymous
|
Shell
|
2004 Jul
|
|
1
|
1
|
Incorrect return value form strftime %W
|
edit |
760 |
code
|
fixed
|
2004 Jun
|
anonymous
|
Parser
|
2005 Jan
|
|
2
|
3
|
Selects leave tablename in tablename.columname
|
edit |
765 |
build
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
dougcurrie
|
3
|
2
|
MinGW/MSYS build fails with vrsion 3.0.0
|
edit |
768 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jul
|
anonymous
|
1
|
2
|
3.0.0 alpha WHERE-AND evaluation
|
edit |
770 |
doc
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
5
|
4
|
Typo in SQLite 3 Overview doc
|
edit |
771 |
doc
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
5
|
4
|
Typo on SQLite 3 Overview page
|
edit |
772 |
build
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
2
|
2
|
configure with cygwin broken
|
edit |
774 |
code
|
fixed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Aug
|
|
1
|
1
|
sqlite3_exec not exported in windows sqlite.dll
|
edit |
777 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
1
|
1
|
MIN() does not return NULL if there is a NULL in the list
|
edit |
778 |
code
|
fixed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
|
1
|
1
|
output of sqlite3_mprintf isn't correct
|
edit |
782 |
new
|
fixed
|
2004 Jun
|
anonymous
|
Unknown
|
2005 Feb
|
|
3
|
2
|
Correlated subqueries are not supported
|
edit |
784 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jul
|
|
2
|
2
|
SQLITE_OMIT_DATETIME_FUNCS code error with Microsoft compilers
|
edit |
785 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
1
|
1
|
local variable 'db' used without having been initialized
|
edit |
786 |
code
|
fixed
|
2004 Jun
|
anonymous
|
BTree
|
2004 Aug
|
drh
|
1
|
1
|
sqlite3 change SQLITE_PAGE_SIZE to 4096 causes assert
|
edit |
789 |
code
|
fixed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
1
|
1
|
the 'LL' qualifier is not supported by MSVC
|
edit |
791 |
code
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
1
|
1
|
3.0.2 fails to build under Mingw
|
edit |
793 |
new
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2005 Feb
|
drh
|
4
|
4
|
Source *.tar.gz Files Should Untar Into Directory sqlite-{version}
|
edit |
794 |
new
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
4
|
3
|
add API to report number of wildcards in sqlite3_prepare*
|
edit |
800 |
todo
|
fixed
|
2004 Jul
|
anonymous
|
VDBE
|
2004 Jul
|
|
3
|
3
|
Handling of NULLs by set function MIN has been changed to non-standard
|
edit |
804 |
code
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
1
|
1
|
sqliteStrNICmp() and sqliteStrICmp() return wrong value.
|
edit |
805 |
code
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
3
|
2
|
coalesce in the where clause doesn't work
|
edit |
806 |
code
|
fixed
|
2004 Jul
|
anonymous
|
VDBE
|
2004 Jul
|
|
3
|
3
|
The maximum number of tables allowed in a join is 32.
|
edit |
807 |
code
|
fixed
|
2004 Jul
|
anonymous
|
VDBE
|
2004 Jul
|
|
1
|
3
|
Cannot run a prepared CREATE TABLE statement more than once
|
edit |
810 |
code
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Sep
|
|
1
|
3
|
SELECT ROWID, * FROM SOMEVIEW -> crash
|
edit |
812 |
code
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
3
|
3
|
sqlite_mprintf ("%s", "") - "%s" alone with empty string arg fails
|
edit |
813 |
code
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
2
|
4
|
LEFT OUTER JOIN give wrong result when an index is present
|
edit |
818 |
doc
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
4
|
3
|
The SQLite 3 API reference says "sqlite *" instead of "sqlite3 *"
|
edit |
819 |
code
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Oct
|
|
1
|
2
|
building on linux/FC2 with --enable-threadsafe needs a -lpthread dep.
|
edit |
827 |
code
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
2
|
3
|
sub-select involving random() does not work
|
edit |
831 |
code
|
fixed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
4
|
3
|
sqlite_mprintf("%q", "") returns random data
|
edit |
834 |
code
|
fixed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Aug
|
|
4
|
3
|
No equivalent to sqlite_libversion() API call in SQLite3
|
edit |
837 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Sep
|
|
1
|
2
|
VACUUM returns "sql logic error or missing database"
|
edit |
838 |
new
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
4
|
2
|
Change os_common.h to allow SQLITE_DEBUG on Windows.
|
edit |
839 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
2
|
2
|
'int isdigit(int)' causes a crash
|
edit |
842 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
2
|
2
|
Ignoring an error return from sqlite3_exec causes invalid db.
|
edit |
844 |
code
|
fixed
|
2004 Aug
|
anonymous
|
VDBE
|
2004 Aug
|
|
1
|
1
|
AFTER DELETE trigger has erroneous values in old.X "variables"!
|
edit |
848 |
code
|
fixed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Sep
|
|
3
|
3
|
make test seg fault in blob-1.5 on x86_64 Linux (Gentoo on Opteron)
|
edit |
855 |
build
|
fixed
|
2004 Aug
|
anonymous
|
Unknown
|
2005 Feb
|
|
4
|
3
|
Unpack directory should include a version: sqlite-3.0.4/
|
edit |
857 |
event
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
1
|
1
|
Unable to download 3.0.4 precompiled binaries for Linux.
|
edit |
859 |
doc
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
5
|
4
|
typo in comment
|
edit |
860 |
code
|
fixed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Oct
|
|
3
|
1
|
SQLite 3.0.4 fails under Solaris 9
|
edit |
862 |
code
|
fixed
|
2004 Aug
|
anonymous
|
VDBE
|
2004 Aug
|
|
2
|
2
|
Memory is being freed twice when performing VACUUM on corrupted DB
|
edit |
869 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
drh
|
3
|
3
|
SQLite 2.x: CREATE INDEX and dbl-quoted index names
|
edit |
870 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
4
|
4
|
Segmentation Fault on sqlite3_step if sqlite3_prepare fails
|
edit |
872 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2005 Sep
|
|
5
|
5
|
SQL does not support non-ASCII IO?
|
edit |
873 |
code
|
fixed
|
2004 Aug
|
anonymous
|
|
2004 Sep
|
|
1
|
2
|
VACUUM of database with ' character in filename causes error
|
edit |
875 |
code
|
fixed
|
2004 Aug
|
anonymous
|
VDBE
|
2004 Aug
|
|
1
|
3
|
Error when INTERSECTing more than two subqueries.
|
edit |
877 |
todo
|
fixed
|
2004 Aug
|
anonymous
|
Parser
|
2004 Aug
|
|
4
|
2
|
Binary garbage in preprocessed source file 'parse.c' (3.0.5)
|
edit |
881 |
code
|
fixed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
|
1
|
3
|
Can not compile under Windows with Borland C++ Builder
|
edit |
886 |
code
|
fixed
|
2004 Sep
|
anonymous
|
Unknown
|
2004 Sep
|
anonymous
|
2
|
2
|
v3 assert with explain
|
edit |
888 |
doc
|
fixed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
|
5
|
4
|
incorrect (obsolete) comment above sqlite3BtreeOpen in btree.c
|
edit |
890 |
code
|
fixed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
anonymous
|
1
|
1
|
Page sizes other than 1024 bytes result in segfaults
|
edit |
891 |
build
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
4
|
4
|
creating directories in makefile
|
edit |
892 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
1
|
LEMON can't generate well-formed Windows parsers with full paths
|
edit |
895 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
4
|
4
|
LEMON doesn't like single-line parse_failure code.
|
edit |
896 |
code
|
fixed
|
2004 Sep
|
anonymous
|
Parser
|
2004 Sep
|
anonymous
|
1
|
3
|
Access violation when attempt to execute invalid query
|
edit |
897 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
4
|
LEMON: Line numbers in generated parser.c are off. (Windows)
|
edit |
898 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
1
|
1
|
nullif() crashes inside trigger
|
edit |
899 |
doc
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Nov
|
|
4
|
3
|
sqlite3_create_function / negative nArg glitch
|
edit |
900 |
new
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
4
|
4
|
sqlite3_trace and reusing prepared statements
|
edit |
901 |
code
|
fixed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
|
1
|
1
|
invalid btree cursor read locks honored?
|
edit |
903 |
build
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
3
|
make doc fails (please use mkdir -p)
|
edit |
904 |
build
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
3
|
x86_64: please use $(libdir) instead of $(prefix)/lib
|
edit |
905 |
code
|
fixed
|
2004 Sep
|
anonymous
|
VDBE
|
2004 Oct
|
|
2
|
4
|
assertion failed in vdbe.c (it fails to not crash upon user error?)
|
edit |
907 |
build
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Oct
|
|
1
|
2
|
If --enable-threadsafe then pthreads library is not linked in
|
edit |
908 |
event
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
5
|
5
|
corrupt sqlite-3.0.7.so.gz file on download page
|
edit |
911 |
code
|
fixed
|
2004 Sep
|
anonymous
|
Shell
|
2004 Oct
|
|
3
|
3
|
The sqlite command ".mode csv" doesn't work correctly
|
edit |
912 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
1
|
1
|
sqlite3 crashes in join statement
|
edit |
913 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Oct
|
|
3
|
2
|
Locking in os_unix.c
|
edit |
914 |
code
|
fixed
|
2004 Sep
|
anonymous
|
Shell
|
2004 Sep
|
|
5
|
4
|
Small typo in shell help for .mode
|
edit |
918 |
code
|
fixed
|
2004 Sep
|
anonymous
|
VDBE
|
2004 Sep
|
|
1
|
1
|
sqlite3_bind_parameter_index produces access violation
|
edit |
922 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
5
|
2
|
SELECT statement crashes sqlite3
|
edit |
924 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Oct
|
drh
|
2
|
2
|
Compile problem using mingw "msys" environment and gcc 3.4.2
|
edit |
925 |
code
|
fixed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
|
1
|
4
|
crash in btree.c:reparentPage when pageSize != usableSize
|
edit |
926 |
new
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
1
|
1
|
create_function after a prepare returns MISUSE error
|
edit |
927 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
2
|
errcode() returning OK even when previous function returned error
|
edit |
932 |
code
|
fixed
|
2004 Sep
|
anonymous
|
VDBE
|
2004 Sep
|
drh
|
3
|
4
|
With NDEBUG, SQLITE_DEBUG breaks
|
edit |
934 |
code
|
fixed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
1
|
pragma table_info
|
edit |
936 |
code
|
fixed
|
2004 Sep
|
anonymous
|
CodeGen
|
2004 Sep
|
|
3
|
1
|
Prototype declaration is not correct
|
edit |
938 |
code
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
3
|
2
|
File locking in os_win.c (related to ticket #913)
|
edit |
939 |
code
|
fixed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
2
|
3
|
.import appends \n to last field (text fields, windows)
|
edit |
940 |
new
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
4
|
3
|
Simplify the makefile
|
edit |
943 |
new
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
5
|
4
|
Missing const declarations.
|
edit |
946 |
code
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
4
|
3
|
Including both sqlite.h and sqlite3.h results in error
|
edit |
948 |
code
|
fixed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
4
|
4
|
glob in attach2.test fails (Fedora Core)
|
edit |
953 |
code
|
fixed
|
2004 Oct
|
anonymous
|
Shell
|
2004 Nov
|
drh
|
2
|
3
|
sqlite3 core dump when delete record by specified rowid range
|
edit |
954 |
build
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
2
|
4
|
Autogerated opcodes.h breaks bulid on MinGW/MSYS
|
edit |
956 |
doc
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
5
|
4
|
Typo on homepage
|
edit |
959 |
build
|
fixed
|
2004 Oct
|
anonymous
|
|
2005 Sep
|
|
4
|
4
|
mkopcodeh.awk requires gawk on Solaris
|
edit |
962 |
new
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
4
|
4
|
Test btree_8.23.3 should use hypen instead of underscore
|
edit |
966 |
code
|
fixed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
1
|
1
|
GROUP BY of aggregate function fails with Out of Memory
|
edit |
973 |
code
|
fixed
|
2004 Oct
|
anonymous
|
Shell
|
2004 Oct
|
|
4
|
4
|
shell: "select" output interferes with future ".databases" output
|
edit |
979 |
code
|
fixed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
1
|
3
|
large heap memory usage when creating VIEW TABLES from schema.sql file
|
edit |
980 |
code
|
fixed
|
2004 Nov
|
anonymous
|
VDBE
|
2004 Dec
|
|
2
|
4
|
Two triggers confusing each other
|
edit |
984 |
code
|
fixed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
sqlite3HexToBlob required & omitted by SQLITE_HAS_CODEC
|
edit |
985 |
code
|
fixed
|
2004 Nov
|
anonymous
|
BTree
|
2005 Jan
|
|
3
|
3
|
"Invalid read of size 1" errors created in btree.c line 2804
|
edit |
987 |
code
|
fixed
|
2004 Nov
|
anonymous
|
TclLib
|
2005 Jan
|
|
1
|
1
|
in Tcl, package require sqlite3 fails
|
edit |
991 |
code
|
fixed
|
2004 Nov
|
anonymous
|
VDBE
|
2004 Nov
|
|
4
|
4
|
misleading error message returned for bad column index
|
edit |
995 |
new
|
fixed
|
2004 Nov
|
anonymous
|
|
2004 Nov
|
|
4
|
3
|
Manual page for SQLite 3 should be named sqlite3.1
|
edit |
1001 |
doc
|
fixed
|
2004 Nov
|
anonymous
|
VDBE
|
2004 Nov
|
|
3
|
3
|
No documentation for VDBE Opcode MakeRecord
|
edit |
1002 |
doc
|
fixed
|
2004 Nov
|
anonymous
|
Parser
|
2004 Nov
|
|
3
|
3
|
documentation of LIMIT clause is misleading
|
edit |
1003 |
doc
|
fixed
|
2004 Nov
|
anonymous
|
VDBE
|
2004 Nov
|
|
3
|
3
|
The documentation of VDBE Opcode SortPut is incorrect
|
edit |
1004 |
doc
|
fixed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
eTextRep argument to sqlite3_create_function not documented
|
edit |
1008 |
code
|
fixed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
4
|
1
|
default_temp_store=0 after VACUUM
|
edit |
1010 |
code
|
fixed
|
2004 Nov
|
anonymous
|
BTree
|
2004 Dec
|
|
3
|
3
|
btree.c: "pagesSize" should be "usableSize" for AutoVacuum and MX_CELL
|
edit |
1012 |
build
|
fixed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
adding "cursor.c" to Makefile.in (diffs included)
|
edit |
1025 |
code
|
fixed
|
2004 Dec
|
anonymous
|
|
2005 Jan
|
|
3
|
3
|
Error starting transaction, SQLite still consider it started.
|
edit |
1032 |
new
|
fixed
|
2004 Dec
|
anonymous
|
VDBE
|
2004 Dec
|
|
2
|
3
|
access violation in sqlite3_bind_parameter_index when name is NULL
|
edit |
1033 |
build
|
fixed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
4
|
4
|
configure --help displays incorrect info for --with-tcl
|
edit |
1035 |
code
|
fixed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
1
|
1
|
union queries with sub-select tables with limits returns no results
|
edit |
1036 |
code
|
fixed
|
2004 Dec
|
anonymous
|
Unknown
|
2007 Mar
|
|
3
|
1
|
Wrong handling of column names from VIEWs
|
edit |
1039 |
code
|
fixed
|
2004 Dec
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
GROUP BY causes a crash
|
edit |
1046 |
code
|
fixed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
2
|
3
|
checkin 2170 breaks SQLite
|
edit |
1048 |
code
|
fixed
|
2004 Dec
|
anonymous
|
|
2005 Jan
|
|
3
|
2
|
Wrong column naming
|
edit |
1049 |
doc
|
fixed
|
2004 Dec
|
anonymous
|
|
2005 Mar
|
|
4
|
4
|
Document that pragma default_synchronous is no longer available in v3.
|
edit |
1051 |
code
|
fixed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
2
|
2
|
pragma.c code breaks build when SQLITE_DEBUG #defined, fix included
|
edit |
1052 |
doc
|
fixed
|
2004 Dec
|
anonymous
|
VDBE
|
2005 Jan
|
|
5
|
5
|
Typo error
|
edit |
1054 |
code
|
fixed
|
2004 Dec
|
anonymous
|
Parser
|
2005 Jan
|
|
1
|
1
|
Query with unknown column crashes when authorizer is set
|
edit |
1057 |
doc
|
fixed
|
2004 Dec
|
anonymous
|
|
2005 Jan
|
|
5
|
5
|
update "MEMORY_DEBUG" to "SQLITE_DEBUG" in several sqlite files
|
edit |
1062 |
code
|
fixed
|
2005 Jan
|
anonymous
|
CodeGen
|
2005 Jan
|
|
2
|
3
|
Home-built sqlite3 gives assertion failed on file where.c, line 383
|
edit |
1066 |
new
|
fixed
|
2005 Jan
|
anonymous
|
Parser
|
2005 Jan
|
|
4
|
1
|
SQLite 3.0.8 does not allow the '$' on Column Names.
|
edit |
1068 |
code
|
fixed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
drh
|
1
|
1
|
Lemon can emit 2 sets of destructor code in certain cases
|
edit |
1069 |
code
|
fixed
|
2005 Jan
|
anonymous
|
BTree
|
2005 Jan
|
|
3
|
3
|
Array bounds read error in Purify
|
edit |
1075 |
build
|
fixed
|
2005 Jan
|
anonymous
|
Unknown
|
2005 Sep
|
anonymous
|
3
|
4
|
Solaris 9 build needs to use gawk instead of awk
|
edit |
1079 |
warn
|
fixed
|
2005 Jan
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
2
|
stddef.h should be included in sqliteint.h
|
edit |
1080 |
doc
|
fixed
|
2005 Jan
|
anonymous
|
|
2005 Feb
|
|
3
|
3
|
Incorrect name in pragma documentation
|
edit |
1081 |
doc
|
fixed
|
2005 Jan
|
anonymous
|
|
2005 Feb
|
|
3
|
3
|
Errors in pragma documentation
|
edit |
1082 |
doc
|
fixed
|
2005 Jan
|
anonymous
|
|
2005 Feb
|
|
3
|
3
|
The new EXISTS predicate is not documented
|
edit |
1083 |
code
|
fixed
|
2005 Jan
|
anonymous
|
VDBE
|
2005 Feb
|
|
1
|
1
|
crash in correlated sub-query
|
edit |
1084 |
code
|
fixed
|
2005 Jan
|
anonymous
|
CodeGen
|
2005 Feb
|
|
1
|
1
|
Reference to outer query in result set can cause an assert() failure
|
edit |
1090 |
new
|
fixed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
tclinstaller.tcl does not support DESTDIR
|
edit |
1094 |
warn
|
fixed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
3
|
2
|
possible error in function OsWrite (in os_win.c)
|
edit |
1095 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
1
|
3
|
Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
|
edit |
1103 |
doc
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
5
|
4
|
the same word twice
|
edit |
1108 |
build
|
fixed
|
2005 Feb
|
anonymous
|
Shell
|
2005 Feb
|
danielk1977
|
2
|
2
|
strcasecmp should be changed to sqlite3StrICmp
|
edit |
1114 |
code
|
fixed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
1
|
1
|
Database corruption when using 'PRAGMA auto_vacuum=ON'
|
edit |
1117 |
build
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
anonymous
|
1
|
1
|
sqlite-2.8.16.tar.gz contains VERSION '3.1.2'
|
edit |
1120 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Feb
|
|
2
|
2
|
lemon: off-by-two error
|
edit |
1121 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
anonymous
|
1
|
2
|
Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
|
edit |
1122 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Shell
|
2005 Feb
|
drh
|
3
|
2
|
strcasecmp in shell.c
|
edit |
1124 |
event
|
fixed
|
2005 Feb
|
anonymous
|
Shell
|
2005 Feb
|
|
4
|
4
|
sqlite.exe .dump & reload broken w/dependent VIEW lower in sort
|
edit |
1127 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Mar
|
|
3
|
3
|
typeof() always returns "text" in unions
|
edit |
1133 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
drh
|
5
|
5
|
double full_column_name flags in pragma
|
edit |
1135 |
doc
|
fixed
|
2005 Feb
|
anonymous
|
|
2005 Mar
|
|
4
|
3
|
Typos in documentation for CREATE VIEW
|
edit |
1137 |
code
|
fixed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
4
|
5
|
couldn't find procedure Tclsqlite_Init
|
edit |
1140 |
code
|
fixed
|
2005 Feb
|
anonymous
|
CodeGen
|
2005 Mar
|
|
1
|
1
|
selectReadsTable infinite loop
|
edit |
1145 |
doc
|
fixed
|
2005 Feb
|
anonymous
|
|
2005 Mar
|
|
4
|
4
|
duplicate text in FAQ
|
edit |
1146 |
build
|
fixed
|
2005 Feb
|
anonymous
|
|
2005 Mar
|
|
4
|
4
|
make doc failure: no target 'arch.png'
|
edit |
1151 |
code
|
fixed
|
2005 Mar
|
anonymous
|
CodeGen
|
2005 Mar
|
|
4
|
3
|
detach does not support database names inside square brakets
|
edit |
1152 |
code
|
fixed
|
2005 Mar
|
anonymous
|
Pager
|
2005 Mar
|
|
3
|
4
|
create silently fails if corresponding journal file already exists
|
edit |
1153 |
code
|
fixed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
1
|
1
|
make test on 3.1.3 throws 11 errors
|
edit |
1159 |
code
|
fixed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
2
|
1
|
SQLite forgets to call the busy handler
|
edit |
1161 |
build
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Sep
|
|
2
|
4
|
Need to use "nawk" to build under Solaris 9
|
edit |
1164 |
warn
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
4
|
1
|
Compile warning about different "const" qualifiers
|
edit |
1165 |
new
|
fixed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
3
|
4
|
On cygwin, sqlite filenames are windows, not cygwin
|
edit |
1166 |
code
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
3
|
3
|
jounal1-1.2 test fails on Windows
|
edit |
1167 |
new
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
4
|
3
|
test Bind-4.1 fails on Windows
|
edit |
1168 |
doc
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
5
|
1
|
Update to the README file
|
edit |
1169 |
code
|
fixed
|
2005 Mar
|
anonymous
|
VDBE
|
2005 Jun
|
|
1
|
1
|
Segmentation fault when deleting range of items using view/trigger
|
edit |
1170 |
new
|
fixed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
3
|
3
|
strfdate Should Support Strict ISO-8601 Date Format
|
edit |
1171 |
code
|
fixed
|
2005 Mar
|
anonymous
|
Pager
|
2005 Jun
|
|
1
|
1
|
Statement transaction rollback can incorrectly update database file.
|
edit |
1188 |
code
|
fixed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
1
|
3
|
Numbers greater than 0x7FFFFFFF are treated as signed in inequalities.
|
edit |
1194 |
code
|
fixed
|
2005 Mar
|
anonymous
|
Pager
|
2005 Mar
|
|
4
|
4
|
64K page size does not work
|
edit |
1198 |
build
|
fixed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
1
|
1
|
3.2.1 build fails test and fulltest
|
edit |
1202 |
code
|
fixed
|
2005 Apr
|
anonymous
|
|
2005 Aug
|
|
2
|
2
|
Library does not support "0x" prefix in cmd context string
|
edit |
1206 |
code
|
fixed
|
2005 Apr
|
anonymous
|
|
2005 Sep
|
drh
|
5
|
4
|
failed to work when running in non-ASCII directory
|
edit |
1210 |
code
|
fixed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Jun
|
|
2
|
2
|
Generating SQLITE_INTERNAL error
|
edit |
1211 |
code
|
fixed
|
2005 Apr
|
anonymous
|
|
2005 Jun
|
anonymous
|
2
|
2
|
too stupid boolean test
|
edit |
1216 |
new
|
fixed
|
2005 Apr
|
anonymous
|
|
2005 Aug
|
|
4
|
3
|
strftime doesn't return milliseconds
|
edit |
1217 |
code
|
fixed
|
2005 Apr
|
anonymous
|
Parser
|
2005 Jun
|
|
3
|
3
|
NATURAL JOIN results in incorrect "ambiguous column name" error
|
edit |
1219 |
code
|
fixed
|
2005 Apr
|
anonymous
|
VDBE
|
2005 Jun
|
anonymous
|
2
|
2
|
dereferencing null ptr in vdbeUnbind()
|
edit |
1224 |
new
|
fixed
|
2005 Apr
|
anonymous
|
|
2005 May
|
|
5
|
4
|
config.h is not required for build.
|
edit |
1229 |
code
|
fixed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
3
|
3
|
SQL code with trigger produces SegFault/BusError
|
edit |
1232 |
code
|
fixed
|
2005 May
|
anonymous
|
BTree
|
2005 May
|
drh
|
1
|
1
|
unaligned memory access on sparc64 with -r1.257 of btree.c
|
edit |
1234 |
code
|
fixed
|
2005 May
|
anonymous
|
BTree
|
2005 May
|
|
1
|
1
|
solaris9 alignment problems
|
edit |
1236 |
todo
|
fixed
|
2005 May
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
3
|
3
|
Linux binary on download page not statically linked
|
edit |
1239 |
doc
|
fixed
|
2005 May
|
anonymous
|
|
2005 Sep
|
|
4
|
3
|
Documentation typos in different.tcl & docs.tcl
|
edit |
1243 |
code
|
fixed
|
2005 May
|
anonymous
|
TclLib
|
2005 Sep
|
|
1
|
1
|
Missing system encoding conversion when accessing files
|
edit |
1244 |
code
|
fixed
|
2005 May
|
anonymous
|
|
2005 May
|
|
1
|
1
|
Test misc2-.10.1 causes seg fault
|
edit |
1247 |
new
|
fixed
|
2005 May
|
anonymous
|
|
2005 May
|
|
4
|
3
|
Default file permissions are too restrictive
|
edit |
1251 |
code
|
fixed
|
2005 May
|
anonymous
|
Parser
|
2005 May
|
|
3
|
2
|
Code fixes for memory leaks and invalid memory accesses
|
edit |
1252 |
code
|
fixed
|
2005 May
|
anonymous
|
Unknown
|
2005 May
|
|
3
|
3
|
SQL error: unknown opcode 0
|
edit |
1253 |
new
|
fixed
|
2005 May
|
anonymous
|
Pager
|
2005 May
|
|
5
|
3
|
Put commonly used items closer to the start of a struct
|
edit |
1256 |
new
|
fixed
|
2005 May
|
anonymous
|
|
2005 May
|
|
3
|
3
|
Allow using non-default calling convention
|
edit |
1257 |
new
|
fixed
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
3.5% speed improvement
|
edit |
1258 |
new
|
fixed
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
20% sqlite speedup? Can it be true?
|
edit |
1259 |
code
|
fixed
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
3
|
2
|
Small memory leak
|
edit |
1260 |
code
|
fixed
|
2005 May
|
anonymous
|
|
2005 May
|
|
4
|
4
|
value of synchronous changes back to full if you change the cache_size
|
edit |
1263 |
code
|
fixed
|
2005 May
|
anonymous
|
|
2005 Jun
|
|
1
|
3
|
full_column_names pragma not always honoured
|
edit |
1270 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
4
|
2
|
Creating views using prepared statements with parameters
|
edit |
1271 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
anonymous
|
1
|
3
|
Timeout not handled correctly, random behaviour on different platforms
|
edit |
1272 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
1
|
3
|
File locks are broken in some multi-threaded environments
|
edit |
1274 |
code
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
2
|
2
|
sqliteOsFullPathname() segfaults due to NULL from getcwd()
|
edit |
1275 |
new
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
4
|
3
|
Method to get sqlite3* from sqlite3_stmt
|
edit |
1277 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
anonymous
|
3
|
3
|
"PRAGMA encoding" cannot be set after "PRAGMA synchronous"
|
edit |
1279 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
4
|
4
|
Missing info about fourth arg to sqlite3_bind_* in API Reference
|
edit |
1282 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
3
|
1
|
Typo in changes.tcl
|
edit |
1283 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
2
|
2
|
Database corrupts when creating table with autoincrement column
|
edit |
1284 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
2
|
3
|
Fail to compile at main.c:301 (old signature of function used)
|
edit |
1285 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Pager
|
2005 Jun
|
|
1
|
3
|
deadlock in multithreaded application
|
edit |
1287 |
code
|
fixed
|
2005 Jun
|
anonymous
|
TclLib
|
2005 Jun
|
|
1
|
1
|
problem comparing with empty string inside tcl variable
|
edit |
1289 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
3
|
3
|
make doc misses a file named arch2.gif
|
edit |
1291 |
build
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
2
|
3
|
makefile fix for Borland dll import lib under windows
|
edit |
1292 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jul
|
|
4
|
4
|
'make test' fails on OS X, includes fix
|
edit |
1297 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
1
|
3
|
sqlite 3.2.2 reproducible access violation
|
edit |
1301 |
code
|
fixed
|
2005 Jun
|
anonymous
|
CodeGen
|
2005 Jun
|
|
2
|
3
|
CREATE UNIQUE INDEX fails with existing rows with NULL as compound key
|
edit |
1303 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
4
|
4
|
Broken `glob' link in documentation
|
edit |
1304 |
new
|
fixed
|
2005 Jun
|
anonymous
|
TclLib
|
2005 Jun
|
|
3
|
4
|
use Tcl_EvalObjv when calling user defined functions in Tcl library
|
edit |
1306 |
doc
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
4
|
4
|
DROP TABLE doc error
|
edit |
1311 |
code
|
fixed
|
2005 Jun
|
anonymous
|
|
2005 Aug
|
|
1
|
2
|
misuse-5.1 crashing on Mac OS X
|
edit |
1314 |
code
|
fixed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jul
|
|
1
|
2
|
Can't compile Sqlite 3.2.2 from .zip sources
|
edit |
1315 |
code
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
|
1
|
1
|
busy callback called in 2 distinct places when starting a transaction
|
edit |
1316 |
code
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
|
4
|
4
|
Output from ROUND function is inconsistent cross-platform
|
edit |
1320 |
doc
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
drh
|
5
|
5
|
comment says sqlite3_create_aggregate which does not exist any more
|
edit |
1321 |
doc
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
5
|
5
|
strange comment
|
edit |
1331 |
event
|
fixed
|
2005 Jul
|
anonymous
|
Pager
|
2005 Sep
|
anonymous
|
1
|
1
|
unicode filename for database
|
edit |
1334 |
doc
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Jul
|
|
1
|
1
|
problem MAX and sqlite3_column_text when no data is returned
|
edit |
1337 |
new
|
fixed
|
2005 Jul
|
anonymous
|
|
2005 Aug
|
|
3
|
4
|
compability problems with column names starting with digits
|
edit |
1338 |
code
|
fixed
|
2005 Jul
|
anonymous
|
Parser
|
2005 Jul
|
|
2
|
2
|
assert triggers inside sqlite3AuthRead()
|
edit |
1340 |
code
|
fixed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Aug
|
anonymous
|
1
|
1
|
round(1e300) dumps core
|
edit |
1345 |
code
|
fixed
|
2005 Jul
|
anonymous
|
VDBE
|
2005 Aug
|
|
4
|
4
|
Small cosmetic defect in code
|
edit |
1346 |
code
|
fixed
|
2005 Aug
|
anonymous
|
BTree
|
2005 Aug
|
|
2
|
2
|
assertion fires when query string goes beyond 865 characters
|
edit |
1347 |
code
|
fixed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
anonymous
|
1
|
1
|
Concatinate operation with BLOB causes assertion fail
|
edit |
1348 |
code
|
fixed
|
2005 Aug
|
anonymous
|
Shell
|
2005 Aug
|
|
3
|
1
|
Ticket #939 is not really fixed
|
edit |
1353 |
new
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
5
|
4
|
Enhance error message when disk is full
|
edit |
1354 |
code
|
fixed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
anonymous
|
3
|
2
|
Misusing sqlite3Error in vdbeapi.c
|
edit |
1356 |
code
|
fixed
|
2005 Aug
|
anonymous
|
Parser
|
2005 Aug
|
|
4
|
4
|
Memory leak on query?
|
edit |
1357 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
1
|
1
|
MemLeak by CreateTable if exists
|
edit |
1358 |
code
|
fixed
|
2005 Aug
|
anonymous
|
Unknown
|
2005 Aug
|
|
1
|
1
|
ORDER By Does not work
|
edit |
1359 |
code
|
fixed
|
2005 Aug
|
anonymous
|
Unknown
|
2005 Aug
|
|
2
|
2
|
Segfault when using primary key plus another index.
|
edit |
1363 |
todo
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
5
|
5
|
More symbols declared as static
|
edit |
1368 |
new
|
fixed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Sep
|
|
2
|
1
|
Aggregate queries against large tables use excessive amounts of memory
|
edit |
1370 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
3
|
4
|
Problem opening non-sqlite files smaller than spageSize.
|
edit |
1371 |
new
|
fixed
|
2005 Aug
|
anonymous
|
Parser
|
2005 Aug
|
|
1
|
1
|
This format not accepted for assigning a double: 12.e-3
|
edit |
1372 |
build
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Sep
|
|
4
|
3
|
Use of incompatible function (gsub) in mkopcode[ch].awk on Solaris
|
edit |
1373 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
1
|
1
|
Assertion fail with empty BLOB
|
edit |
1374 |
doc
|
fixed
|
2005 Aug
|
anonymous
|
Unknown
|
2005 Aug
|
drh
|
4
|
4
|
Documentation error for lang_createview.html
|
edit |
1375 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
4
|
3
|
Multi-database transactions perform undesirable fsyncs
|
edit |
1376 |
code
|
fixed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
|
1
|
3
|
Lengthy WHERE clause with many BETWEEN clauses seg fault
|
edit |
1378 |
build
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
3
|
3
|
Compiling with "./configure --enable-threadsafe; make" is broken
|
edit |
1380 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
1
|
1
|
Crash with IN(correlated subquery)
|
edit |
1384 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
3
|
3
|
misuse-5.1 test fails because of memory corruption
|
edit |
1390 |
build
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
4
|
3
|
Remove GNU-make-ism from Makefile.in
|
edit |
1391 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
1
|
1
|
3.2.4 linux static binary shipped is not really static
|
edit |
1392 |
doc
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
4
|
1
|
Incorrect syntax documented for 'AUTOINCREMENT' keyword
|
edit |
1394 |
code
|
fixed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
|
3
|
3
|
Uninitialized variable in isSortingIndex()
|
edit |
1395 |
code
|
fixed
|
2005 Aug
|
anonymous
|
Shell
|
2005 Aug
|
drh
|
3
|
4
|
SQLite3 segfaults with -DSQLITE_OMIT_MEMORYDB and no filename
|
edit |
1396 |
code
|
fixed
|
2005 Aug
|
anonymous
|
|
2005 Sep
|
|
3
|
3
|
File paths with international characters are don't work on Windows
|
edit |
1398 |
warn
|
fixed
|
2005 Aug
|
anonymous
|
Parser
|
2005 Aug
|
|
5
|
5
|
Low priority warning to to resolve
|
edit |
1399 |
new
|
fixed
|
2005 Aug
|
anonymous
|
|
2006 Jan
|
|
4
|
4
|
Please add "DROP IF EXISTS" support
|
edit |
1405 |
build
|
fixed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
4
|
4
|
awk build problem on Solaris 10
|
edit |
1407 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
3
|
WinAPI, CreateFileA is not utf-8 compatible.
|
edit |
1409 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
pragma empty_Result_callbacks and ANALYZE crashes
|
edit |
1412 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
2
|
C++Builder 6 compilation
|
edit |
1413 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
3
|
SUM returns unexpected results for columns with NULL values
|
edit |
1414 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
2
|
3
|
Complex query that used to work with sqlite 3.2.2 doesn't with 3.2.5
|
edit |
1418 |
code
|
fixed
|
2005 Sep
|
anonymous
|
Parser
|
2005 Sep
|
|
3
|
3
|
assert() when creating a table with duplicate column names
|
edit |
1419 |
code
|
fixed
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
drh
|
1
|
1
|
Shell no longer dumps sqlite_sequence
|
edit |
1420 |
code
|
fixed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
1
|
1
|
Problems with COUNT DISTINCT
|
edit |
1425 |
doc
|
fixed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
5
|
5
|
NDEBUG
|
edit |
1429 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
drh
|
5
|
5
|
Visual C++ 6.0 Error Report
|
edit |
1433 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
3.2.5 behaves differently than 3.2.2 when an index is created
|
edit |
1435 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
query optimizer results in rows being returned in the wrong order
|
edit |
1437 |
code
|
fixed
|
2005 Sep
|
anonymous
|
VDBE
|
2005 Sep
|
drh
|
1
|
1
|
bulid failed on windows
|
edit |
1440 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
2 compilation errors on VC6 (windows)
|
edit |
1444 |
code
|
fixed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
drh
|
1
|
1
|
select union all and order by problems
|
edit |
1449 |
code
|
fixed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
Failed assert at select.c, line 1733: p->pRightmost==p
|
edit |
1453 |
code
|
fixed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
1
|
4
|
make test fails in conflict tests on mac os x
|
edit |
1467 |
build
|
fixed
|
2005 Oct
|
anonymous
|
|
2006 Jan
|
|
1
|
1
|
3.2.7 on Solaris still chokes on fdatasync
|
edit |
1471 |
todo
|
fixed
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
drh
|
5
|
4
|
Add link to home page to SQLite logo
|
edit |
1474 |
code
|
fixed
|
2005 Oct
|
anonymous
|
|
2006 Apr
|
|
2
|
3
|
SQLITE3.DLL fails to load if address 0x60900000 occupied
|
edit |
1478 |
code
|
fixed
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Nov
|
drh
|
3
|
2
|
Large file compile error with table.c
|
edit |
1479 |
code
|
fixed
|
2005 Oct
|
anonymous
|
Unknown
|
2006 Jan
|
|
1
|
3
|
SQLITE_ALTER_TABLE not authorized for "alter table ... add ...;"
|
edit |
1486 |
code
|
fixed
|
2005 Oct
|
anonymous
|
|
2006 Jan
|
|
4
|
3
|
schema which is stored in sqlite_master was not complete
|
edit |
1497 |
code
|
fixed
|
2005 Oct
|
anonymous
|
Parser
|
2005 Oct
|
|
4
|
1
|
SQL with unclosed string is accepted
|
edit |
1501 |
code
|
fixed
|
2005 Oct
|
anonymous
|
|
2005 Nov
|
|
1
|
3
|
Access violation at address 00001002 error.
|
edit |
1512 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
drh
|
3
|
3
|
VACUUM is a no-op on empty databases
|
edit |
1513 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
drh
|
1
|
1
|
last 3.2.7 cvs checkout doesn't compile under ms vc++
|
edit |
1514 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
4
|
3
|
Strange single table query with aggregate and group by causes segfault
|
edit |
1524 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Pager
|
2006 Jan
|
|
2
|
3
|
Crash when using pragma auto_vacuum with :memory: database
|
edit |
1533 |
code
|
fixed
|
2005 Nov
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
file os_win.c, function utf8ToUnicode and unicodeToUtf8 BUG
|
edit |
1536 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
2
|
1
|
insert ... select changes format of columns
|
edit |
1537 |
code
|
fixed
|
2005 Nov
|
anonymous
|
BTree
|
2005 Nov
|
|
2
|
1
|
Left Join broken (wrong results)
|
edit |
1544 |
code
|
fixed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
drh
|
1
|
2
|
last CVS checkout doesn't compile under cygwin or msvc
|
edit |
1554 |
code
|
fixed
|
2005 Dec
|
anonymous
|
Parser
|
2006 Jan
|
|
3
|
3
|
sqlite3_prepare ignores nBytes parameter
|
edit |
1569 |
code
|
fixed
|
2005 Dec
|
anonymous
|
|
2005 Dec
|
drh
|
1
|
1
|
tarball of sqlite 2.8.17 is empty
|
edit |
1570 |
code
|
fixed
|
2005 Dec
|
anonymous
|
Unknown
|
2006 Mar
|
drh
|
3
|
3
|
pragma table_info() incorrect result for columns with NONE affinity
|
edit |
1572 |
code
|
fixed
|
2005 Dec
|
anonymous
|
Parser
|
2006 Jan
|
|
2
|
1
|
Null Mallocation
|
edit |
1575 |
code
|
fixed
|
2005 Dec
|
anonymous
|
Shell
|
2005 Dec
|
|
4
|
3
|
resolve_backslashes in shell.c is broken
|
edit |
1578 |
doc
|
fixed
|
2005 Dec
|
anonymous
|
Unknown
|
2006 Mar
|
|
5
|
4
|
Typo on http://www.sqlite.org/version3.html page
|
edit |
1583 |
code
|
fixed
|
2006 Jan
|
anonymous
|
CodeGen
|
2006 Mar
|
|
2
|
4
|
explain query plan missing length
|
edit |
1584 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
1
|
5
|
Solaris 8: bus error when /dev/urandom is not readable
|
edit |
1585 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
1
|
1
|
Global mutex not released if pthread_key_create fails.
|
edit |
1586 |
new
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
2
|
3
|
ORDER BY with LIMIT clause is sub-optimal in speed and memory usage
|
edit |
1587 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
3
|
3
|
Timezone is parsed reversely
|
edit |
1589 |
doc
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
4
|
Has the SQLite website's "Append Remarks" behavior changed?
|
edit |
1590 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
4
|
2
|
select.c uninitialized variable
|
edit |
1593 |
code
|
fixed
|
2006 Jan
|
anonymous
|
BTree
|
2006 Jan
|
drh
|
1
|
2
|
error compiling with #define SQLITE_OMIT_AUTOVACUUM
|
edit |
1596 |
doc
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
5
|
5
|
obsolete MakeIdxKey opcode references in vdbe.c and documentation
|
edit |
1600 |
new
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
5
|
4
|
WinCE locking implementation
|
edit |
1601 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
anonymous
|
1
|
2
|
3.3.0 multithreaded apps memory leak
|
edit |
1603 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
5
|
5
|
better customization of macro N_GUARD in utils.c
|
edit |
1604 |
build
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
3
|
opcode generation fails on solaris 8 due to ancient awk
|
edit |
1607 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
1
|
1
|
sqlite3_set_authorizer causes subsequent access violation
|
edit |
1608 |
doc
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
3
|
Yet undocumented: create table IF NOT EXISTS
|
edit |
1611 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
3
|
sqlite3_close on wrong thread returns SQLITE_OK but leaks filehandle
|
edit |
1614 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
2
|
2
|
sqlitedll-3_3_1.zip contain no DLL
|
edit |
1615 |
warn
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
2
|
2
|
Metrowerks CodeWarrior compiler errors when build sqlite
|
edit |
1616 |
warn
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
2
|
2
|
RVCT compiler warnings when making sqlite build
|
edit |
1619 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
Can't compile sqlite with SQLITE_ENABLE_MEMORY_MANAGEMENT
|
edit |
1625 |
warn
|
fixed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
3
|
3
|
Compiler errors in building Sqlite3 from source
|
edit |
1628 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
4
|
pragma integrity_check returns "OK" on a corrupt database
|
edit |
1629 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
The fix for #1623 causes an assert in sqlite3MallocAllow()
|
edit |
1630 |
code
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
The TLS data is allocated/deallocated multiple times
|
edit |
1632 |
code
|
fixed
|
2006 Jan
|
anonymous
|
VDBE
|
2006 Jan
|
|
3
|
3
|
sqlite3_result_error doesn't work in user defined aggregate function
|
edit |
1634 |
code
|
fixed
|
2006 Jan
|
anonymous
|
CodeGen
|
2006 Jan
|
|
3
|
3
|
LIMIT in nested select not working properly
|
edit |
1645 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Shell
|
2006 Jan
|
|
2
|
3
|
constraint using "in"
|
edit |
1646 |
doc
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
3
|
4
|
API doc clarification for bind_text: utf8 bytes or chars?
|
edit |
1649 |
doc
|
fixed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
4
|
1
|
changes.tcl incorrect in latest checkin
|
edit |
1650 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
3
|
4
|
Third parm of sqlite3_prepare is ignored.
|
edit |
1651 |
code
|
fixed
|
2006 Jan
|
anonymous
|
Shell
|
2006 Jan
|
|
1
|
1
|
.import doesn't work in 3.3.3
|
edit |
1652 |
code
|
fixed
|
2006 Jan
|
anonymous
|
CodeGen
|
2006 Feb
|
|
3
|
4
|
sorting ASC vs DESC changes number of returned rows
|
edit |
1654 |
code
|
fixed
|
2006 Feb
|
anonymous
|
VDBE
|
2006 Feb
|
|
1
|
1
|
crash when executing query on Intel builds
|
edit |
1657 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
1
|
1
|
Disk I/O error when used on memory filesystem
|
edit |
1658 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
3
|
4
|
SQLITE3.EXE program crash
|
edit |
1660 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
danielk1977
|
1
|
1
|
OS memory allocation functions may round-up the requested size
|
edit |
1661 |
code
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
|
3
|
4
|
The following never returns in v2.8.16 : select 1 limit 1 offset 1;
|
edit |
1662 |
code
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Mar
|
drh
|
1
|
3
|
Wrong CAST result rsp. missing string trimming on number conversions
|
edit |
1664 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
1
|
1
|
sum() returns wrong result
|
edit |
1665 |
code
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
drh
|
1
|
1
|
Memory corruption using ALTER TABLE
|
edit |
1666 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
3
|
3
|
sqlite3_analyzer has 32-bit overflow errors
|
edit |
1669 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
1
|
3
|
sum() still returns wrong result
|
edit |
1670 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
1
|
3
|
sum() still returns wrong result - the sequel
|
edit |
1671 |
new
|
fixed
|
2006 Feb
|
anonymous
|
Parser
|
2006 Feb
|
drh
|
5
|
4
|
Support '@' as a named parameter prefix
|
edit |
1672 |
code
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
|
1
|
1
|
Deadlock when multithreading on unix
|
edit |
1674 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
3
|
3
|
sum(-9223372036854775805) returns integer -9223372036854775808
|
edit |
1680 |
build
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Mar
|
|
4
|
3
|
configure --enable-debug doesn't enable verbose explain
|
edit |
1682 |
code
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
|
4
|
4
|
accessing temp database causes crash
|
edit |
1684 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Mar
|
|
2
|
2
|
SQLITE_MIN_SLEEP_MS not defined in main.c
|
edit |
1688 |
code
|
fixed
|
2006 Feb
|
anonymous
|
VDBE
|
2006 Mar
|
danielk1977
|
3
|
2
|
Incorrect column names when doing select on views
|
edit |
1690 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Feb
|
|
5
|
4
|
utf8ToUnicode allocates too large buffer
|
edit |
1695 |
code
|
fixed
|
2006 Feb
|
anonymous
|
|
2006 Mar
|
anonymous
|
1
|
1
|
Database file not loading ...
|
edit |
1696 |
build
|
fixed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Jun
|
|
4
|
4
|
obsolete "sort +4" and friends
|
edit |
1699 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
1
|
2
|
round(X) does not work correctly when nested in some functions
|
edit |
1709 |
code
|
fixed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
sqlite3_column_name not apply column alias for views
|
edit |
1711 |
code
|
fixed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
2
|
Wrong header names when using subselects with 3.3.4 (3.3.1 is OK)
|
edit |
1713 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
2
|
2
|
Cannot open datafiles in folders with special characters
|
edit |
1716 |
doc
|
fixed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
5
|
4
|
sqlite3_db_handle() has wrong documented signature
|
edit |
1721 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Parser
|
2006 Mar
|
|
3
|
3
|
wrong column names in a compound select when used as a subquery
|
edit |
1726 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Apr
|
drh
|
1
|
1
|
wrong reported datatype when using group-by
|
edit |
1737 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
1
|
1
|
Duplicate name object created
|
edit |
1744 |
doc
|
fixed
|
2006 Mar
|
anonymous
|
Parser
|
2006 Apr
|
drh
|
1
|
1
|
Missing documentation for SQLITE_ALTER_TABLE, SQLITE_REINDEX...
|
edit |
1745 |
doc
|
fixed
|
2006 Mar
|
anonymous
|
Parser
|
2006 Apr
|
drh
|
3
|
3
|
Missing "REVERSE" colation sequence
|
edit |
1746 |
code
|
fixed
|
2006 Mar
|
anonymous
|
Parser
|
2006 Apr
|
|
2
|
1
|
large number of trigger actions in trigger creation give syntax error
|
edit |
1749 |
doc
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
5
|
4
|
typo on FAQ web page
|
edit |
1750 |
doc
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
5
|
4
|
typo on API reference web page
|
edit |
1755 |
code
|
fixed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
drh
|
3
|
3
|
datatype incorrect when using group-by
|
edit |
1756 |
code
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
1
|
1
|
Is use of function atof in file func.c really intended?
|
edit |
1763 |
code
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
3
|
4
|
declaration after executable statement
|
edit |
1768 |
code
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
drh
|
1
|
1
|
ORDER BY behaving differently in SQLite2 and 3
|
edit |
1771 |
code
|
fixed
|
2006 Apr
|
anonymous
|
Shell
|
2006 Jun
|
|
5
|
4
|
sqlite3 -version should return 0
|
edit |
1773 |
code
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
2
|
3
|
heap corruption reading a corrupted database file
|
edit |
1784 |
code
|
fixed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
3
|
4
|
LIMIT 0 in sub-query with ORDER BY in outer query causes seg fault
|
edit |
1792 |
doc
|
fixed
|
2006 May
|
anonymous
|
|
2006 May
|
|
1
|
1
|
"commercial" is misspelled on the SQLite license page
|
edit |
1794 |
code
|
fixed
|
2006 May
|
anonymous
|
Parser
|
2006 May
|
|
3
|
2
|
Sqlite parser produces incorrect error message for missing commas
|
edit |
1803 |
code
|
fixed
|
2006 May
|
anonymous
|
Unknown
|
2006 Jun
|
|
3
|
3
|
sqlite3WinOpenReadWrite() passes wrong share parms to CreateFile()
|
edit |
1805 |
code
|
fixed
|
2006 May
|
anonymous
|
Shell
|
2006 May
|
|
3
|
4
|
missing out-of-memory check at src/shell.c:1485
|
edit |
1806 |
code
|
fixed
|
2006 May
|
anonymous
|
TclLib
|
2006 May
|
|
3
|
4
|
Missing out-of-memory check at db/sqlite3/src/tclsqlite.c:1442
|
edit |
1821 |
code
|
fixed
|
2006 May
|
anonymous
|
|
2006 May
|
|
2
|
3
|
Optimizer causes IN operator to fail when comparing strings & numbers
|
edit |
1825 |
code
|
fixed
|
2006 May
|
anonymous
|
|
2006 May
|
|
1
|
1
|
Crash on ATTACH DATABASE
|
edit |
1827 |
new
|
fixed
|
2006 May
|
anonymous
|
TclLib
|
2006 May
|
|
4
|
4
|
Tcl-library: SQLITE_MISUSE from progress callback
|
edit |
1830 |
code
|
fixed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
2
|
1
|
Problem with INNER JOIN following LEFT JOIN to table with UNIQUE INDEX
|
edit |
1831 |
code
|
fixed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
anonymous
|
2
|
1
|
Crash when using a certain type of index
|
edit |
1839 |
build
|
fixed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
4
|
attempting to compile loadext.c fails
|
edit |
1845 |
code
|
fixed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
3
|
3
|
soundex(null) causes access violation
|
edit |
1847 |
new
|
fixed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
4
|
4
|
Unhelpful error text
|
edit |
1848 |
code
|
fixed
|
2006 Jun
|
anonymous
|
Parser
|
2006 Jun
|
drh
|
1
|
1
|
C++ ism on generated parse.c from latest CVS head
|
edit |
1849 |
code
|
fixed
|
2006 Jun
|
anonymous
|
VDBE
|
2006 Jun
|
|
1
|
3
|
EXPLAIN segfault on linux (3.3.6 and 3.3.5 and 3.3.2)
|
edit |
1863 |
secure
|
fixed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
drh
|
2
|
3
|
authorizing load_extension()
|
edit |
1875 |
code
|
fixed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
3
|
EXPLAIN crashes in strlen
|
edit |
1877 |
code
|
fixed
|
2006 Jun
|
anonymous
|
VDBE
|
2006 Jun
|
|
2
|
2
|
problems with compiling with -DSQLITE_OMIT_VIRTUALTABLE
|
edit |
1879 |
doc
|
fixed
|
2006 Jul
|
anonymous
|
|
2006 Jul
|
|
4
|
4
|
Perl is spelt Pearl on the http://www.sqlite.org page
|
edit |
1887 |
code
|
fixed
|
2006 Jul
|
anonymous
|
TclLib
|
2006 Jul
|
|
1
|
1
|
Bad result on empty [db onecolumn]
|
edit |
1892 |
code
|
fixed
|
2006 Jul
|
anonymous
|
Parser
|
2006 Jul
|
|
4
|
5
|
Degenerate code action causes parser crash.
|
edit |
1897 |
new
|
fixed
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Aug
|
|
1
|
3
|
Should be able to call sqlite3_interrupt from a different thread
|
edit |
1899 |
new
|
fixed
|
2006 Jul
|
anonymous
|
|
2006 Sep
|
drh
|
5
|
4
|
Is it possible add IF NOT EXISTS Create View and Create Trigger
|
edit |
1911 |
code
|
fixed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
2
|
3
|
crash if too many order by expressions
|
edit |
1912 |
code
|
fixed
|
2006 Aug
|
anonymous
|
Parser
|
2006 Aug
|
|
4
|
4
|
letters following numeric digits parsing error
|
edit |
1913 |
build
|
fixed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
4
|
3
|
Extension exports should be added to sqlite3.def in Windows source
|
edit |
1914 |
code
|
fixed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
btree2.test - invalid command name "btree_cursor_info"
|
edit |
1915 |
code
|
fixed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
vtab2.test: ./testfixture: can't read "tcl_pkgPath": no such variable
|
edit |
1916 |
code
|
fixed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
drh
|
4
|
2
|
#include <sqlite3.h> in sqlite3ext.h should be #include "sqlite3.h"
|
edit |
1917 |
code
|
fixed
|
2006 Aug
|
anonymous
|
VDBE
|
2006 Aug
|
|
3
|
3
|
assertion "rc==SQLITE_OK" failed: file "./src/vdbeaux.c", line 1148
|
edit |
1918 |
event
|
fixed
|
2006 Aug
|
anonymous
|
VDBE
|
2006 Aug
|
|
4
|
4
|
"make test" results in many new false regressions with default build
|
edit |
1919 |
code
|
fixed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
3
|
3
|
PRAGMA table_info meaningless for cols with DEFAULT CURRENT_TIMESTAMP
|
edit |
1920 |
code
|
fixed
|
2006 Aug
|
anonymous
|
VDBE
|
2006 Aug
|
|
4
|
4
|
vdbe.c: assert( i>=0 && i<=p->nCursor );
|
edit |
1923 |
doc
|
fixed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
INSERT syntax documentation bug
|
edit |
1925 |
code
|
fixed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
3
|
4
|
soundex() function not compatible with Knuth (and PHP/Java/TCL impl.)
|
edit |
1926 |
new
|
fixed
|
2006 Aug
|
anonymous
|
Shell
|
2006 Aug
|
|
3
|
4
|
sqlite3.exe cannot find home dir on Windows
|
edit |
1927 |
doc
|
fixed
|
2006 Aug
|
anonymous
|
Shell
|
2006 Aug
|
|
4
|
4
|
[doc] sqlite3.exe allows "/" as cmd terminator, not "\"
|
edit |
1937 |
new
|
fixed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
drh
|
4
|
4
|
Tilda substitution not done on db file names.
|
edit |
1943 |
event
|
tested
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
3
|
2
|
sqlite3_malloc() not exported from sqlite3.dll
|
edit |
1955 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
3
|
2
|
[3381] breaks MinGW ./configure && make sqlite3.dll
|
edit |
1957 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
4
|
Incorrect test messages: not compiled with -DSQLITE_DEBUG
|
edit |
1964 |
code
|
fixed
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
anonymous
|
3
|
3
|
datetime function broken
|
edit |
1976 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
3
|
wrong call to set error in vacuum.c
|
edit |
1977 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
2
|
1
|
FTS1: Access violation creating FTS table with no column parameter
|
edit |
1978 |
event
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
Are e-mail addresses from check-in [3417] real ones ?
|
edit |
1979 |
doc
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
4
|
4
|
Problem with full text search
|
edit |
1981 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
fts1.c uses strcasecmp instead of sqlite3StrICmp from utils.c
|
edit |
1982 |
code
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
FTS1: Database error after deleting and reinserting into FTS table
|
edit |
1986 |
doc
|
fixed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
5
|
4
|
typo in documentation
|
edit |
1991 |
code
|
fixed
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
drh
|
3
|
3
|
strftime precision problem
|
edit |
2001 |
code
|
fixed
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
|
2
|
2
|
Views on altered tables are defect
|
edit |
2002 |
code
|
fixed
|
2006 Sep
|
anonymous
|
Parser
|
2006 Sep
|
drh
|
2
|
2
|
Memory leak in select with duplicate colum names
|
edit |
2008 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
3
|
3
|
Linux x86_64 sqlite3utfSelfTest fails assert -O2 gcc 4.1.1 (patch)
|
edit |
2009 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
4
|
3
|
sqlite3 shell won't issue prompts without isatty() true
|
edit |
2016 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
Unremoved debug code in fts1_porter.c
|
edit |
2023 |
build
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Dec
|
|
3
|
3
|
sqlite (loadext.c) fails build in _UNICODE mode from v3.3.7
|
edit |
2029 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
2
|
1
|
SECURITY: SQLite character encoding conversions are insecure
|
edit |
2030 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
CSV output should convert " to "" within values
|
edit |
2036 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
shess
|
1
|
1
|
fts2.c: AVs due to incorret memset() and sizeof() - plus fixes
|
edit |
2038 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
3
|
3
|
CREATE TRIGGER IF NOT EXISTS fails
|
edit |
2044 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
.dump does not dump create view or create index statements as before
|
edit |
2045 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
drh
|
5
|
4
|
Enhancement request: add "bail" command to sqlite3 shell
|
edit |
2047 |
code
|
fixed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
Mozilla Patch: Correct Unicode database names in Win95...
|
edit |
2050 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
3
|
Assert typo in sqlite/src/btree.c ?
|
edit |
2055 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
[patch] fix build errror (os_win.c)
|
edit |
2056 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
2
|
2
|
unable to ".quit' or '.exit' SQLite cmdline tool
|
edit |
2065 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
Make .dump output a few percent smaller
|
edit |
2067 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2007 Dec
|
|
4
|
4
|
Bad syntax caused core dump
|
edit |
2069 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2007 Jan
|
|
4
|
3
|
compilation problem with SQLITE_OMIT_SHARED_CACHE
|
edit |
2071 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
VACUUM doesn't delete temp file on Windows since Check-in [3470]
|
edit |
2072 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
.dump does not dump create index statements
|
edit |
2078 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
2
|
1
|
Patch to make PRAGMA backward compatible with 3.3.7 and prior versions
|
edit |
2088 |
code
|
fixed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
Ticket management problem : type
|
edit |
2107 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
4
|
lemon asserts if you're not careful with MULTITERMINALS
|
edit |
2109 |
doc
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
4
|
Documentation incoherence
|
edit |
2111 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
5
|
Typo
|
edit |
2113 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
4
|
warning if SQLITE_OMIT_LOAD_EXTENSION
|
edit |
2114 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
strdup used
|
edit |
2116 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
3
|
INDEX never selected for ORDER BY when INTEGER PRIMARY KEY present
|
edit |
2117 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
1
|
1
|
Bug in OP_VFilter (vdbe.c) when xFilter returns error
|
edit |
2118 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
2
|
xFilter is optional?
|
edit |
2123 |
code
|
fixed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
5
|
error in new os layer loadable library code (windows ce version)
|
edit |
2129 |
doc
|
fixed
|
2006 Dec
|
anonymous
|
|
2007 Jun
|
|
4
|
1
|
Typo in documentation for sqlite3_create_collation()
|
edit |
2135 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
anonymous
|
4
|
3
|
missing entry sqlite3_clear_bindings in sqlite3_apis
|
edit |
2139 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
1
|
recent pager_unlock change in CVS
|
edit |
2143 |
doc
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
3
|
3
|
sqlite3_column_name may return NULL
|
edit |
2144 |
doc
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
3
|
Cmd shell: Add ".bail" to .help and to website
|
edit |
2145 |
build
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
2
|
3
|
Error in "make install"
|
edit |
2147 |
new
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
5
|
Add /contrib/download/ to robots.txt
|
edit |
2151 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
3
|
3
|
attach database fails
|
edit |
2154 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
2
|
Getting core dump with reused prepare_v2 statements
|
edit |
2156 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
2
|
Statements re-used from preparev2 crashing on vtable errors
|
edit |
2159 |
build
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
pweilbacher
|
3
|
4
|
Interrupt OpenWatcom lang. ext. and sqlite3ext.h
|
edit |
2160 |
doc
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
documentation for busy callback wrong
|
edit |
2161 |
doc
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
Typo in Documentation for callback to sqlite3_exec
|
edit |
2163 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
4
|
3
|
AreFileApisANSI does not exist in Windows CE
|
edit |
2164 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
5
|
Possibly a typo in lemon.c
|
edit |
2168 |
doc
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Aug
|
|
4
|
1
|
Invalid documentation example - BLOB literal X'53514697465'
|
edit |
2172 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
1
|
crash when lemon (wireshark) is built with -DNDEBUG
|
edit |
2173 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
|
4
|
4
|
Incorrect return value test for calls to fcntl()
|
edit |
2175 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
|
3
|
3
|
lemon calling destructors more than once
|
edit |
2176 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
1
|
2
|
integrity check can take very long time on large corrupted db
|
edit |
2177 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
3
|
The same query returns different answers between 3.3.7 and 3.3.9
|
edit |
2184 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
1
|
1
|
OMIT_SHARED_CACHE: missing #define in loadext.c
|
edit |
2189 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
4
|
Incorrect results on LEFT JOINs with IS NULL condition in WHERE clause
|
edit |
2191 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
3
|
Minor C++/C linkage compatibility issue in sqlite3.h
|
edit |
2193 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
incorrect prototypes in tokenize.c
|
edit |
2194 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
possible multiple inclusion with vdbeInt.h
|
edit |
2195 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Feb
|
|
1
|
3
|
OS X: "database locked" when trying to use a database on DVD-ROM
|
edit |
2201 |
code
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
copy in tclsqlite doesn't work
|
edit |
2208 |
todo
|
fixed
|
2007 Jan
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
SQLite CVSTrac attachment corruption?
|
edit |
2210 |
doc
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
4
|
Typos in PRAGMA legacy_file_format;
|
edit |
2211 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
3
|
select A.*, B.* from A join B where A.id=B.a_id order by A.id, B.value
|
edit |
2216 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
4
|
4
|
sqlite3ExprCompare() returns false for sqlite3ExprDup() result
|
edit |
2217 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
pamg
|
1
|
2
|
Incorrect result after first deleting operation (PRAGMA count_changes)
|
edit |
2229 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
2
|
Complex triggers can blow up sqlite
|
edit |
2242 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
2
|
3
|
sqlite3 authorizer is not reentrant
|
edit |
2248 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
2
|
1
|
error evaluating IN statement
|
edit |
2251 |
code
|
fixed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
sqlite3_column_type gives bad type for sum() .. group by
|
edit |
2262 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
drh
|
2
|
1
|
Dynamic allocation of tempory storage for pages
|
edit |
2264 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
3
|
1
|
User defined functions naming problem
|
edit |
2267 |
doc
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
drh
|
2
|
1
|
copyright.html grammer needs fix
|
edit |
2272 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
5
|
5
|
btree.c doc typo
|
edit |
2273 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
1
|
2
|
Under latest release 3.3.13 query results in crash (used to run fine)
|
edit |
2276 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
4
|
3
|
strftime %f zero padding problem
|
edit |
2278 |
code
|
fixed
|
2007 Mar
|
anonymous
|
|
2007 May
|
|
1
|
1
|
sqlite does not support mixed endian between pxa27x and i386 platforms
|
edit |
2281 |
build
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
"CFLAGS=-DSQLITE_DEFAULT_FILE_FORMAT=4" causes alter2.test to fail
|
edit |
2284 |
build
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
make test fails with - undefined external sqlite3_xferopt_count
|
edit |
2287 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
make test fails on latest 3.3.14 cvs code
|
edit |
2290 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Using function result text as a function parameter
|
edit |
2295 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Subquery fails when "order by" is added
|
edit |
2296 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
3
|
3
|
IN clause of UNION of literal SELECT statements with ORDER BY
|
edit |
2298 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
anonymous
|
3
|
2
|
Sqlite 3.3.15 backs out performance changes introduced in 3.3.14
|
edit |
2306 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
3
|
Maybe detective Boolean-expression in sqlite3Expr() ?
|
edit |
2307 |
build
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
missing #ifndef SQLITE_OMIT_SHARED_CACHE breaks compilation
|
edit |
2311 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
redefinition of 'ARRAYSIZE'
|
edit |
2314 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
SQLITE_OMIT_UTF16 Can't be Defined
|
edit |
2318 |
todo
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
5
|
5
|
http://www.sqlite.org/contrib login broken
|
edit |
2319 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
Duplicated test identifiers
|
edit |
2321 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
3
|
3
|
sqlite3_value_bytes moves pointer although there is no type conversion
|
edit |
2323 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
3
|
3
|
invalid TRIM for multibytes
|
edit |
2324 |
code
|
fixed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
2
|
2
|
replace('abc', '', 'x') dumps core
|
edit |
2334 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
valgrind complains about memcpy in select.c (overlapping memory)
|
edit |
2335 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
2
|
real value corruption on different platforms
|
edit |
2337 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Unusual break of functionality (vtab-related?) after check-in 3918
|
edit |
2339 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
strange behavior for UNION
|
edit |
2341 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Potential buffer overflow in sqlite3_snprintf().
|
edit |
2343 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
drh
|
2
|
3
|
mallo.c typo in v 1.168/check in 3925 of Makefile.in
|
edit |
2344 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
Range of INTEGER not ANSI compliant
|
edit |
2345 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
NaN is printed as '0.0'
|
edit |
2347 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
sqlite 3.3.17 crashes when doing "IN (select union select)"
|
edit |
2348 |
doc
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
3
|
deteched -> detected
|
edit |
2349 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
Inconsistent conversion of BLOB to TEXT on UTF-16
|
edit |
2354 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
1
|
Win32 locking problems
|
edit |
2356 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
INDEX not used if column in WHERE clause refers to an alias
|
edit |
2359 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
5
|
typo error
|
edit |
2360 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
2
|
Possible buffer overrun in some text functions
|
edit |
2364 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
2
|
cast(as numeric) truncates small number of large integer
|
edit |
2379 |
code
|
fixed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
Concatenation with zeroblob
|
edit |
2382 |
doc
|
fixed
|
2007 May
|
anonymous
|
|
2007 Jul
|
|
3
|
3
|
VACUUM alters/repacks the ROWIDs if no explicit primary key is given
|
edit |
2403 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
3
|
LEFT JOIN inconsistancy with NULL expression in ON clause
|
edit |
2404 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
2
|
Values in INTEGER PRIMARY KEY always less than NULL
|
edit |
2406 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
3
|
C++ style comments unacceptable in C code.
|
edit |
2407 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
4
|
Problem with ` (0x60) character in LIKE statement
|
edit |
2415 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
1
|
1
|
[4061] propagates SQLITE_ABORT outside nested loops
|
edit |
2416 |
doc
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
5
|
5
|
Spelling error
|
edit |
2422 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
pager.c, line 662: #define pager_datahash(X) 0
|
edit |
2423 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
Check-in [4086] mkdll.sh no longer creates sqlite3.dll
|
edit |
2424 |
doc
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
4
|
Documentation for Tcl-level access to incremental blob I/O is missing.
|
edit |
2425 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
3
|
ftruncate on platform where off_t is not 64 bit
|
edit |
2426 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
Access violation calling sqlite3_column_text after sqlite3_reset
|
edit |
2428 |
build
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
3
|
sqlite 3.4.0 ships with own 'limits.h' interfering with system one.
|
edit |
2430 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
3
|
date and strftime functions returns invalid year
|
edit |
2431 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
segfault with missing order by expression
|
edit |
2432 |
doc
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
Documentation typo in sqlite3_sleep()
|
edit |
2434 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
comment typo in analyze.c
|
edit |
2446 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
2
|
FTS2 Limits Number of Indexed Tables to 3
|
edit |
2453 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
3
|
Can the amalgamation be made entirely static
|
edit |
2455 |
build
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
2
|
3
|
aix linking fails due to missing library
|
edit |
2464 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
4
|
error message not set by sqlite3_blob_write
|
edit |
2465 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
64-bit/tcl regression failure with types3-1.3
|
edit |
2466 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
ENCODING not used in Makefile.linux-gcc
|
edit |
2468 |
doc
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
Spelling error in documentation
|
edit |
2470 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
3
|
subselects causing reproducable SIGSEGV
|
edit |
2475 |
code
|
fixed
|
2007 Jun
|
anonymous
|
|
2007 Jul
|
|
1
|
3
|
Handles being left open on unix
|
edit |
2502 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
Digital Mars static library runtime problem
|
edit |
2507 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
test_expr expr-1.104 fails (64-bit int handling)
|
edit |
2514 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
3
|
max() and min() is wrong when DESC index exists
|
edit |
2518 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
1
|
Complex paging problem
|
edit |
2521 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
4
|
Misplaced prototypes
|
edit |
2522 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
wrong sizeof in vdbe.c
|
edit |
2523 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
4
|
Leaked memory on error return from sqlite3VdbeMemTranslate
|
edit |
2524 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
Missing error check in call to sqlite3PagerWrite() in autoVacuumCommit
|
edit |
2525 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
3
|
Constraint violations fail silently with "insert or replace"
|
edit |
2526 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
4
|
Core dump when issuing a select statement with special having clause
|
edit |
2528 |
doc
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
2
|
PRAGMA auto_vacuum documentation mismatch
|
edit |
2533 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Oct
|
|
1
|
2
|
temporary files are not deleted on WinCe
|
edit |
2546 |
code
|
fixed
|
2007 Jul
|
anonymous
|
|
2007 Oct
|
|
4
|
1
|
Comments are not parsed correctly
|
edit |
2548 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
anonymous
|
4
|
4
|
Pelles C compiler for Windows ANSI prototype / K&R declaration errors
|
edit |
2550 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
drh
|
3
|
3
|
Lemon parser may accept input before EOF is seen
|
edit |
2554 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
Many symbols not marked private/static or SQLITE_API in amalgamation
|
edit |
2556 |
todo
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
5
|
5
|
tabs instead of space in some source files
|
edit |
2560 |
doc
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
5
|
4
|
Documentation typos
|
edit |
2561 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Parser broken -- ORDER BY fails in UNION between two databases
|
edit |
2570 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
unportable assumptions in sqlite3AtoF() / cast.test
|
edit |
2573 |
doc
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
sqlite3_interrupt() + threads
|
edit |
2574 |
build
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
anonymous
|
3
|
3
|
amalgamation 3.4.2 compile errors
|
edit |
2579 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
|
4
|
3
|
the third parameter of substr should be optional
|
edit |
2583 |
build
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
2
|
2
|
3.4.2 fails to build on Solaris due to conflict for B_FALSE and B_TRUE
|
edit |
2588 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
bug in sqlite3_mutex_leave
|
edit |
2591 |
doc
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
4
|
4
|
sqlite3_open() documentation should mention :memory:
|
edit |
2597 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
tclsqlite "db eval" with array-name doesn't have "*" entry. (tcl8.5a7)
|
edit |
2598 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
Failure to delete temporary files on WINCE platforms
|
edit |
2599 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
OS check in mutex.h has no effect
|
edit |
2600 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
#ifdef SQLITE_MUTEX_WIN32 naming error in mutex_w32.c?
|
edit |
2602 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
ATTACH leaks memory
|
edit |
2606 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Sep
|
|
3
|
3
|
PATCH - default configure option enable_threadsafe=yes
|
edit |
2608 |
code
|
fixed
|
2007 Aug
|
anonymous
|
|
2007 Sep
|
|
3
|
3
|
failed allocation leads to unexpected infinite loop
|
edit |
2610 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
drh
|
4
|
3
|
SQLITE_API sqlite3_sleep function header missing in sqlite3ext.h
|
edit |
2611 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
1
|
AV calling sqlite3_vfs_register()
|
edit |
2612 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
enterMutex() misnamer
|
edit |
2615 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
winRandomness without effect due to < vs. > mixup
|
edit |
2616 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Flags parameter not honoured in openDatabase()
|
edit |
2619 |
doc
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
5
|
5
|
typo
|
edit |
2621 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
5
|
another typo
|
edit |
2622 |
doc
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
3
|
SQLITE_OMIT_MEMORY_ALLOCATION undocumented unresolved functions
|
edit |
2623 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
zeroblob(-1) returns non-NULL from sqlite3_column_blob()
|
edit |
2624 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Invalid documentation references in sqlite.h.in
|
edit |
2628 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
4
|
Bad error handling for invalid page-size
|
edit |
2631 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
3
|
Comments at end of "CREATE TABLE" cause SQL error.
|
edit |
2633 |
build
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
building with gcc3.3.4 - undefined reference to `sqlite3KeywordCode'
|
edit |
2640 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
sqlite doesn't treat global identifiers correctly in a subquery
|
edit |
2643 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
bestIndex: Assertion `flags!=0' failed after index creation
|
edit |
2648 |
build
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
compilation error for PocketPC/WindowsCE
|
edit |
2658 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
sqlite3VtabOverloadFunction broken
|
edit |
2666 |
doc
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
Typos/spelling errors in sqlite3.h
|
edit |
2672 |
doc
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
1
|
3
|
icu ext init failure: sqlite3_create_function returns SQLITE_BUSY
|
edit |
2673 |
build
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
3.5.0 amalgamation on OS X, "#define _XOPEN_SOURCE 500" fails build
|
edit |
2678 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
amalgamation zip file should include sqlite3ext.h
|
edit |
2680 |
code
|
fixed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
2
|
2
|
sqlite_int64 vs sqlite3_int64 type confusion in headers and docs
|
edit |
2681 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
#ifndef _XOPEN_SOURCE needed around #define _XOPEN_SOURCE 500
|
edit |
2683 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Windows CE won't compile, also a problem with sqlite3OsFullPath on CE
|
edit |
2685 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
anonymous
|
2
|
1
|
Compilation under MSVC gives warning on TryEnterCriticalSection
|
edit |
2686 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
Integrity check fails if you hit max_page_count and dont rollback
|
edit |
2687 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Nov
|
|
3
|
2
|
Building with _UNICODE fails in Win32 (3.5.1)
|
edit |
2693 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
drh
|
2
|
2
|
mutex.h missing in a10n of sqlite3internal.h
|
edit |
2694 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
drh
|
2
|
2
|
Makefile.in is missing invokation of mksqlite3internalh.tcl for a10n
|
edit |
2696 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
sqlite3.c with SQLITE_OMIT_FLOATING_POINT cannot compile on Linux
|
edit |
2697 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
3
|
sqlite3_open_v2 fails then filename includes non-english chars
|
edit |
2698 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
memory leak in WIN CE because tempfilename is not freed at WinClose
|
edit |
2699 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
2
|
Performance issues in 3.5.1 (Windows)
|
edit |
2700 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
invalid name in winOpen when compiling under WinCE
|
edit |
2702 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Errors in CreateFileW function use on WinCE
|
edit |
2710 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Typo in code specific to WinCE (checkin 4479)
|
edit |
2711 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
WinCE: flags incorrectly checked
|
edit |
2713 |
build
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
5
|
build fails for 3.5.1 on win32/cygwin - duplicate opcode labels
|
edit |
2722 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
data mis-alignment in UTF16 collation callback arguments
|
edit |
2732 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
2
|
sqlite3Step crashes if called with a null argument (easy fix)
|
edit |
2733 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
OP_Real and OP_Int64 inefficient for constants
|
edit |
2737 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
save 35 bytes in VACUUM with new 2 argument substr()
|
edit |
2738 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
2
|
vfsUnlink breaks when building with OS_OTHER=1
|
edit |
2739 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
3
|
large-file enable macros should be defined before first #include
|
edit |
2740 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
4
|
incorrect assertions in vdbe.c
|
edit |
2741 |
code
|
fixed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
_XOPEN_SOURCE may be necessary for pread/pwrite as well as threads
|
edit |
2762 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
fts3 is cavalier about malloc vs sqlite3_malloc
|
edit |
2767 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
2
|
1
|
UPDATE causes ./src/vdbe.c:503: sqlite3VdbeExec: Assertion `pTos<=&p->
|
edit |
2780 |
build
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
sqliteint.h: test to disable _XOPEN_SOURCE uses wrong macro for OSX
|
edit |
2781 |
doc
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
Make documentation available offline (i.e. pdf, chm, etc)
|
edit |
2783 |
doc
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
Broken links into the website
|
edit |
2784 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
3
|
Low memory double free and SEGV from flattenSubquery()
|
edit |
2785 |
doc
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Broken Anchors in C API Reference
|
edit |
2786 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
4
|
sqlite3.pc does not mention -lpthread when used with --static flag
|
edit |
2788 |
build
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
drh
|
3
|
3
|
FormatMessageA not defined for Windows Mobile
|
edit |
2789 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Low memory double free from addWhereTerm
|
edit |
2792 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
invalidateCursorsOnModifiedBtrees has no scoping
|
edit |
2794 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Low memory SEGV in isLikeOrGlob()
|
edit |
2795 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Low memory SEGV in exprAnalyze()
|
edit |
2796 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Another low memory SEGV in exprAnalyze()
|
edit |
2797 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
Low memory SEGV in whereClauseClear()
|
edit |
2799 |
build
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
3
|
'configure ' cannot locate VERSION file
|
edit |
2800 |
build
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
5
|
-lpthread not needed for publish.sh for CLI binary
|
edit |
2801 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
5
|
superfluous -lpthread for CLI in publish_osx.sh
|
edit |
2803 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
3
|
test: io-4.2.2 fails on 64-bit --- signed extension
|
edit |
2805 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Checkin [4573] Home grown recursive mutexes
|
edit |
2806 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
4
|
Low memory assert in insertCell()
|
edit |
2807 |
doc
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
4
|
3
|
Link errors in Documentation
|
edit |
2811 |
code
|
fixed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
"appropriate" misspelled "approriate" on SQLite Documentation page
|
edit |
2815 |
doc
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
3
|
sqlite3_blob_close closes blob even when reporting error!
|
edit |
2820 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
rollback doesn't work
|
edit |
2822 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
ORDER BY term number 1 does not match any result column in select.c
|
edit |
2826 |
build
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
4
|
4
|
test_thread.c won't build if !SQLITE_THREADSAFE || !TCL_THREADS
|
edit |
2827 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
make test: vacuum2.test did not close all files: 1
|
edit |
2829 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Win32: temp files left over in temp area
|
edit |
2832 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Data corruption with UPDATE or DELETE clause ...
|
edit |
2833 |
doc
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
5
|
1
|
typo on SQLite home page
|
edit |
2835 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Lemon memory read/write errors
|
edit |
2838 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
3
|
Request: use traditional way to build CLI
|
edit |
2840 |
doc
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
5
|
4
|
Punctuation errors in comment
|
edit |
2843 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
Low memory crash in sqlite3ExprCodeAndCache
|
edit |
2846 |
build
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
--disable-tcl does not work
|
edit |
2849 |
doc
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
5
|
5
|
unary operator !
|
edit |
2850 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
2
|
CSV output missing quotes if contains equals character
|
edit |
2851 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
make test double free or corruption error
|
edit |
2852 |
code
|
fixed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
4
|
4
|
sqlite library is sometimes 40K bigger when built on OpenBSD
|
edit |
2877 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Unescaped quotation marks in mkopcodeh.awk (CVS [4693])
|
edit |
2880 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
problem with reals bigger then 1e18
|
edit |
2883 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
compile error - missing data
|
edit |
2894 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
virtual table calls Next() and Column() after Eof() returns true
|
edit |
2904 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Feb
|
pweilbacher
|
3
|
3
|
os_os2.c - 2 dysfunctional functions
|
edit |
2913 |
code
|
fixed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
vtab regression failures
|
edit |
305 |
code
|
fixed
|
2003 May
|
chw
|
|
2003 Dec
|
|
1
|
1
|
Problems with locale specific "," as the radix point character
|
edit |
177 |
code
|
tested
|
2002 Oct
|
danielk1977
|
VDBE
|
2003 Jan
|
|
1
|
4
|
Memory handling problem for very large aggregate results
|
edit |
2399 |
code
|
fixed
|
2007 Jun
|
danielk1977
|
|
2007 Jun
|
|
1
|
1
|
Compiling with msvc fails due to use of "isnan()"
|
edit |
569 |
code
|
fixed
|
2004 Jan
|
dougcurrie
|
Pager
|
2004 Jan
|
dougcurrie
|
3
|
3
|
Newer Cygwin (>1.50) doesn't want __CYGWIN_USE_BIG_TYPES__
|
edit |
667 |
build
|
fixed
|
2004 Mar
|
dougcurrie
|
Unknown
|
2004 Mar
|
dougcurrie
|
2
|
1
|
Makefile.in needs updates for encode, .defs, Makefile target
|
edit |
871 |
code
|
fixed
|
2004 Aug
|
dougcurrie
|
TclLib
|
2004 Aug
|
|
3
|
1
|
sqlite_temp_directory only defined in os_unix but used in tcl
|
edit |
910 |
build
|
fixed
|
2004 Sep
|
dougcurrie
|
Unknown
|
2004 Oct
|
dougcurrie
|
2
|
2
|
Windows doesn't (usually) have or need pthread
|
edit |
1951 |
build
|
fixed
|
2006 Sep
|
dougcurrie
|
|
2006 Sep
|
|
3
|
2
|
symbols missing from sqlite3.def
|
edit |
97 |
todo
|
fixed
|
2002 Jul
|
drh
|
|
2003 Jan
|
|
1
|
1
|
Document and test the SHOW_DATATYPES pragma
|
edit |
131 |
code
|
fixed
|
2002 Aug
|
drh
|
|
2002 Aug
|
drh
|
1
|
1
|
ORDER BY ignored when used with GROUP BY on an indexed column
|
edit |
136 |
code
|
fixed
|
2002 Aug
|
drh
|
CodeGen
|
2002 Aug
|
drh
|
1
|
1
|
Segfault on VIEW of a subquery
|
edit |
140 |
todo
|
fixed
|
2002 Aug
|
drh
|
CodeGen
|
2002 Aug
|
drh
|
4
|
4
|
Enhance INSERT ... SELECT to omit the intermediate temporary table
|
edit |
146 |
code
|
fixed
|
2002 Sep
|
drh
|
Pager
|
2002 Sep
|
drh
|
1
|
1
|
Disk I/O error encountered on very large transactions
|
edit |
179 |
code
|
fixed
|
2002 Oct
|
drh
|
|
2002 Oct
|
anonymous
|
1
|
1
|
Column names and string constants in parentheses cause errors.
|
edit |
212 |
code
|
fixed
|
2003 Jan
|
drh
|
Pager
|
2003 Jan
|
|
2
|
1
|
Corrupt database results if the very first transaction rolls back.
|
edit |
238 |
code
|
fixed
|
2003 Feb
|
drh
|
CodeGen
|
2003 Feb
|
|
1
|
1
|
Assertion failure after some incorrect SQL
|
edit |
266 |
new
|
fixed
|
2003 Mar
|
drh
|
|
2003 Apr
|
|
1
|
1
|
Make the VACUUM command work.
|
edit |
290 |
event
|
fixed
|
2003 Apr
|
drh
|
VDBE
|
2003 Apr
|
|
1
|
1
|
interaction of last_insert_rowid() and AFTER triggers
|
edit |
291 |
code
|
fixed
|
2003 Apr
|
drh
|
|
2003 Apr
|
drh
|
1
|
1
|
autoincrement does not work with triggers
|
edit |
292 |
code
|
fixed
|
2003 Apr
|
drh
|
|
2005 Jan
|
|
4
|
4
|
Multiple indices created for a UNIQUE PRIMARY KEY
|
edit |
295 |
code
|
fixed
|
2003 Apr
|
drh
|
CodeGen
|
2003 Apr
|
|
1
|
1
|
ATTACH does not work on a database containing triggers
|
edit |
298 |
code
|
fixed
|
2003 Apr
|
drh
|
CodeGen
|
2003 Apr
|
|
1
|
1
|
SELECT sometimes ignores constant WHERE clause
|
edit |
306 |
code
|
fixed
|
2003 May
|
drh
|
CodeGen
|
2003 May
|
|
1
|
1
|
Left outer join fails when right table is a view of a join.
|
edit |
334 |
code
|
fixed
|
2003 Jun
|
drh
|
CodeGen
|
2003 Jun
|
|
1
|
1
|
REPLACE statement corrupts indices
|
edit |
430 |
code
|
fixed
|
2003 Aug
|
drh
|
|
2003 Aug
|
|
1
|
1
|
Dropping a trigger with the same name as a table corrupts the database
|
edit |
432 |
code
|
fixed
|
2003 Aug
|
drh
|
|
2003 Aug
|
|
3
|
3
|
Returns "Disk I/O Error" when the filename is an empty string
|
edit |
519 |
code
|
fixed
|
2003 Dec
|
drh
|
VDBE
|
2003 Dec
|
|
1
|
1
|
3-way join causes segfault
|
edit |
529 |
code
|
fixed
|
2003 Dec
|
drh
|
|
2003 Dec
|
|
1
|
1
|
An aborted update can corrupt the database
|
edit |
552 |
code
|
fixed
|
2004 Jan
|
drh
|
|
2004 Jan
|
|
1
|
1
|
Integer overflow results in database corruption
|
edit |
561 |
code
|
fixed
|
2004 Jan
|
drh
|
Pager
|
2004 Jan
|
|
1
|
1
|
Database corruption when using Linux threads
|
edit |
574 |
code
|
fixed
|
2004 Jan
|
drh
|
|
2004 Jan
|
|
1
|
1
|
ATTACH fails when invoked from sqlite_compile()
|
edit |
615 |
code
|
fixed
|
2004 Feb
|
drh
|
Pager
|
2004 Feb
|
|
2
|
3
|
Assertion fault in pager when synchronous changed within a transaction
|
edit |
640 |
code
|
fixed
|
2004 Mar
|
drh
|
CodeGen
|
2004 Mar
|
|
1
|
1
|
Trigger causes assertion failure
|
edit |
811 |
code
|
fixed
|
2004 Jul
|
drh
|
|
2004 Jul
|
drh
|
1
|
1
|
When ATTACH fails, strange things happen.
|
edit |
826 |
code
|
fixed
|
2004 Jul
|
drh
|
CodeGen
|
2004 Aug
|
drh
|
1
|
1
|
Nested views do not process * correctly.
|
edit |
829 |
code
|
fixed
|
2004 Jul
|
drh
|
CodeGen
|
2004 Jul
|
drh
|
1
|
1
|
VACUUM fails if there is a UNIQUE index
|
edit |
885 |
code
|
fixed
|
2004 Sep
|
drh
|
VDBE
|
2004 Sep
|
|
1
|
1
|
Sqlite3_step() does not return SQLITE_BUSY after a commit fails
|
edit |
975 |
code
|
fixed
|
2004 Oct
|
drh
|
BTree
|
2004 Nov
|
drh
|
1
|
1
|
Non-standard page sizes cause problems for large files
|
edit |
1115 |
code
|
fixed
|
2005 Feb
|
drh
|
|
2005 Feb
|
|
1
|
1
|
Creating unique index on non-unique column leads to corruption
|
edit |
1116 |
code
|
fixed
|
2005 Feb
|
drh
|
VDBE
|
2005 Feb
|
|
1
|
1
|
VACUUM results in corrupt database
|
edit |
1163 |
code
|
fixed
|
2005 Mar
|
drh
|
VDBE
|
2005 Mar
|
|
1
|
1
|
Database corruption possible on records with large numbers of columns.
|
edit |
1212 |
code
|
fixed
|
2005 Apr
|
drh
|
VDBE
|
2005 Apr
|
|
1
|
1
|
Large integers stored incorrectly.
|
edit |
1362 |
code
|
fixed
|
2005 Aug
|
drh
|
VDBE
|
2005 Aug
|
|
1
|
1
|
Dump and restore converts floating-point values to integers
|
edit |
1432 |
code
|
fixed
|
2005 Sep
|
drh
|
|
2005 Sep
|
|
1
|
1
|
Database corruption following VACUUM failure
|
edit |
1473 |
code
|
fixed
|
2005 Oct
|
drh
|
CodeGen
|
2005 Oct
|
drh
|
1
|
1
|
Incorrect results when a subquery contains UNION ALL
|
edit |
1567 |
code
|
fixed
|
2005 Dec
|
drh
|
Pager
|
2005 Dec
|
|
1
|
1
|
Database corruption following statement rollback
|
edit |
1605 |
code
|
fixed
|
2006 Jan
|
drh
|
VDBE
|
2006 Jan
|
|
1
|
1
|
Assertion fault when trying to LIKE a BLOB in UTF-16 mode.
|
edit |
1697 |
code
|
fixed
|
2006 Mar
|
drh
|
CodeGen
|
2006 Mar
|
drh
|
1
|
1
|
Segfault while executing SELECT
|
edit |
1717 |
code
|
fixed
|
2006 Mar
|
drh
|
CodeGen
|
2006 Mar
|
drh
|
1
|
1
|
CHECK constraints always use ABORT conflict resolution
|
edit |
1727 |
code
|
fixed
|
2006 Mar
|
drh
|
|
2006 Mar
|
|
1
|
1
|
Assertion fault on autovacuum :memory: database
|
edit |
1728 |
code
|
fixed
|
2006 Mar
|
drh
|
VDBE
|
2006 Mar
|
|
1
|
1
|
Integrity_check fails after dropping tables in autovacuumed database
|
edit |
1807 |
code
|
fixed
|
2006 May
|
drh
|
|
2006 May
|
drh
|
1
|
1
|
Assertion fault on a particular query.
|
edit |
1824 |
code
|
fixed
|
2006 May
|
drh
|
|
2006 May
|
drh
|
1
|
1
|
UTF-16 encoding flag not honored when using shared cache
|
edit |
1873 |
code
|
fixed
|
2006 Jun
|
drh
|
|
2006 Jun
|
|
1
|
1
|
DETACH while query is running results in crash
|
edit |
1886 |
code
|
fixed
|
2006 Jul
|
drh
|
|
2006 Jul
|
|
1
|
1
|
Memory leak when malloc fails
|
edit |
1889 |
new
|
fixed
|
2006 Jul
|
drh
|
|
2006 Jul
|
|
1
|
1
|
Make sqlite3_interrupt() accessible from the TCL interface
|
edit |
1987 |
code
|
fixed
|
2006 Sep
|
drh
|
|
2006 Sep
|
drh
|
1
|
1
|
Malformed database results from changing encoding
|
edit |
2018 |
code
|
fixed
|
2006 Oct
|
drh
|
|
2006 Oct
|
drh
|
1
|
1
|
Name resolution problem in correlated compound subqueries.
|
edit |
2141 |
code
|
fixed
|
2007 Jan
|
drh
|
|
2007 Jan
|
|
1
|
1
|
Assertion fault on valid query
|
edit |
2153 |
code
|
fixed
|
2007 Jan
|
drh
|
|
2007 Jan
|
|
1
|
1
|
Error in the strftime() function
|
edit |
2192 |
code
|
fixed
|
2007 Jan
|
drh
|
|
2007 Jan
|
|
1
|
1
|
Assertion fault on a deeply nested view
|
edit |
2249 |
code
|
fixed
|
2007 Feb
|
drh
|
|
2007 Feb
|
drh
|
1
|
1
|
OR clause optimizer confused by column affinities
|
edit |
2252 |
code
|
fixed
|
2007 Feb
|
drh
|
|
2007 Feb
|
drh
|
1
|
1
|
New INSERT optimization bypasses CHECK constraint checks
|
edit |
2285 |
code
|
fixed
|
2007 Apr
|
drh
|
|
2007 Apr
|
|
1
|
1
|
Rolling back a CREATE TEMP TABLE wedges the database
|
edit |
2286 |
code
|
fixed
|
2007 Apr
|
drh
|
|
2007 Apr
|
|
1
|
1
|
Extra NULL value returned by a descending SELECT
|
edit |
2291 |
code
|
fixed
|
2007 Apr
|
drh
|
|
2007 Apr
|
|
1
|
1
|
VACUUM fails when NULLs appear in a UNIQUE constraint
|
edit |
2418 |
code
|
fixed
|
2007 Jun
|
drh
|
|
2007 Jun
|
drh
|
1
|
1
|
Database corruption following malloc failure in auto-vacuum mode
|
edit |
2454 |
code
|
fixed
|
2007 Jun
|
drh
|
|
2007 Jun
|
|
1
|
1
|
Leading zeros cause large integers to be convert to floating point.
|
edit |
2565 |
code
|
fixed
|
2007 Aug
|
drh
|
|
2007 Aug
|
|
1
|
1
|
Database corruption following ROLLBACK when soft_heap_limit set
|
edit |
1644 |
code
|
fixed
|
2006 Jan
|
ghaering
|
VDBE
|
2006 Jan
|
|
3
|
3
|
CREATE TEMP/DROP TEMP do not modify schema cookie
|
edit |
138 |
code
|
fixed
|
2002 Aug
|
jadams
|
|
2002 Aug
|
|
4
|
4
|
Makefile doesn't use exec_prefix, has some install problems
|
edit |
317 |
code
|
fixed
|
2003 May
|
jplyon
|
CodeGen
|
2003 May
|
|
2
|
3
|
ATTACH fails for external database containing an index
|
edit |
176 |
code
|
fixed
|
2002 Oct
|
mike
|
|
2002 Oct
|
drh
|
1
|
3
|
locking mechanism fails under Windows
|
edit |
1836 |
new
|
fixed
|
2006 Jun
|
pweilbacher
|
Shell
|
2006 Jun
|
|
4
|
3
|
Further OS/2 updates
|
edit |
2149 |
build
|
fixed
|
2007 Jan
|
pweilbacher
|
|
2007 Jan
|
|
4
|
3
|
BEXE missing for lemon in Makefile.in
|
edit |
648 |
code
|
fixed
|
2004 Mar
|
rdc
|
Unknown
|
2004 Mar
|
|
3
|
3
|
duplicate tracing with revised sqlite_exec implementation
|
edit |
2410 |
doc
|
fixed
|
2007 Jun
|
rdc
|
|
2007 Jun
|
|
5
|
3
|
typo in checkin 4053
|
edit |
2433 |
code
|
fixed
|
2007 Jun
|
rse
|
|
2007 Jun
|
|
1
|
2
|
sqlite CLI's reading of ".sqliterc" broken in 3.4.0
|
edit |
2436 |
code
|
fixed
|
2007 Jun
|
rse
|
|
2007 Jun
|
|
1
|
1
|
SQLite has to link against -lm for isnan(3)
|
edit |
2437 |
code
|
fixed
|
2007 Jun
|
rse
|
|
2007 Jun
|
|
3
|
3
|
Consistently use $(NAWK) in Makefile.in
|
edit |
2544 |
code
|
fixed
|
2007 Jul
|
rse
|
|
2007 Jul
|
|
4
|
3
|
"sqlite3 foo.db .dump | sqlite3 bar.db" fail because of verbose output
|
edit |
2659 |
code
|
fixed
|
2007 Sep
|
rse
|
|
2007 Sep
|
danielk1977
|
2
|
2
|
openDirectory function broken
|
edit |
2845 |
code
|
fixed
|
2007 Dec
|
rse
|
|
2007 Dec
|
|
3
|
3
|
SQLite 3.5.4 requires TCL during built-time
|
edit |
2166 |
code
|
fixed
|
2007 Jan
|
shess
|
|
2007 Jan
|
shess
|
2
|
3
|
fts modules corrupt data during UPDATE.
|
edit |
2268 |
code
|
fixed
|
2007 Mar
|
shess
|
|
2007 Mar
|
drh
|
1
|
4
|
SQLITE_OMIT_ATTACH doesn't disable sqlite_attach() function.
|
edit |
2289 |
code
|
fixed
|
2007 Apr
|
shess
|
|
2007 Apr
|
shess
|
1
|
1
|
fts1 and fts2 crash when deleting or replacing rows with a null field.
|
edit |
2309 |
code
|
fixed
|
2007 Apr
|
shess
|
|
2007 Apr
|
shess
|
1
|
1
|
Assert failure in fts2 MATCH of certain OR cases.
|
edit |
2774 |
code
|
fixed
|
2007 Nov
|
shess
|
|
2007 Nov
|
shess
|
1
|
1
|
Crash merging empty OR queries in fts3.
|
edit |
458 |
new
|
fixed
|
2003 Sep
|
xdong
|
Unknown
|
2003 Sep
|
xdong
|
5
|
5
|
configure file and libtool doesnot work for cross compiling
|
edit |
459 |
new
|
fixed
|
2003 Sep
|
xdong
|
Unknown
|
2003 Sep
|
xdong
|
5
|
5
|
adding releasemode option to allow libtool link release
|
edit |