SQLite CVSTrac

Status color codes:

Active

Review

Fixed

Tested

Deferred

Closed

#	Type	Status	Created	By	Subsys	Changed	Assigned	Svr	Pri	Title
12	new	review	2002 Apr	anonymous		2002 Jul		2	4	adding win32 multi process support using a Mutex
13	new	review	2002 Apr	anonymous		2002 Jul		3	4	DSO DLL , solaris and FREEBSD
29	new	fixed	2002 Apr	anonymous		2004 Jan	drh	3	1	Enhancement of column data types in views
30	new	fixed	2002 Apr	anonymous		2005 Feb	drh	2	4	Correlated subqueries are not supported
56	event	defer	2002 Jun	anonymous		2002 Jun		1	1	'Permission Denied' while trying to use SQLITE in a Familiar iPAQ
74	new	defer	2002 Jun	anonymous		2004 Nov		4	2	2.5 database file still says "SQLite 2.1 database"
81	code	defer	2002 Jun			2002 Jun		4	3	Single process on NFS
86	new	defer	2002 Jun	anonymous		2002 Jun		5	2	Add SAFEARRAY support for WIN32 clients of SQLite.DLL.
97	todo	fixed	2002 Jul	drh		2003 Jan		1	1	Document and test the SHOW_DATATYPES pragma
130	code	fixed	2002 Aug	anonymous		2002 Aug		3	3	No transactions across Linux threads seems restrictive.
131	code	fixed	2002 Aug	drh		2002 Aug	drh	1	1	ORDER BY ignored when used with GROUP BY on an indexed column
132	new	fixed	2002 Aug	anonymous	Unknown	2002 Aug		3	3	Temp file path
133	code	fixed	2002 Aug	anonymous	Unknown	2002 Aug		5	5	sqlite.exe crashes
134	code	fixed	2002 Aug	anonymous	Parser	2002 Aug	anonymous	2	4	syntax error in lemon.c on IBM AIX systems (both gcc and xlc)
135	new	fixed	2002 Aug	anonymous		2002 Aug		5	4	Code optimizations (to reduce compilation warnings under BC5 Windows)
136	code	fixed	2002 Aug	drh	CodeGen	2002 Aug	drh	1	1	Segfault on VIEW of a subquery
137	code	fixed	2002 Aug	anonymous	Shell	2002 Aug		4	3	shell's find_home_dir() is ineffecient
138	code	fixed	2002 Aug	jadams		2002 Aug		4	4	Makefile doesn't use exec_prefix, has some install problems
140	todo	fixed	2002 Aug	drh	CodeGen	2002 Aug	drh	4	4	Enhance INSERT ... SELECT to omit the intermediate temporary table
142	code	fixed	2002 Aug	anonymous		2002 Aug		1	1	Incorrect Order By when column is null
146	code	fixed	2002 Sep	drh	Pager	2002 Sep	drh	1	1	Disk I/O error encountered on very large transactions
147	code	fixed	2002 Sep	anonymous		2002 Sep		1	1	"INSERT into xxx SELECT yyy ORDER BY zzz LIMIT 1" ignores the limit
150	doc	fixed	2002 Sep	anonymous	Unknown	2002 Sep	anonymous	2	2	Missing documentation files
152	code	fixed	2002 Sep	anonymous	Unknown	2002 Sep		1	1	"make test" has errors
153	code	fixed	2002 Sep	anonymous	Parser	2003 Jan		1	1	PRAGMA SHOW_DATATYPES bug
155	code	fixed	2002 Sep	anonymous	Unknown	2002 Dec		2	2	sqliteSortCompare var dir uninitialized
159	code	fixed	2002 Oct	anonymous	Unknown	2003 Apr	drh	2	2	Triggers don't work _at all_ in the presence autoincrement fields
160	code	fixed	2002 Oct	anonymous		2005 Jan		1	4	trigger not called when user-defined function used
163	code	fixed	2002 Oct	anonymous	Unknown	2002 Oct		2	2	Buggy initialization of random generator on win32
166	code	fixed	2002 Oct	anonymous	Unknown	2002 Oct		1	1	Left outer join doesn't seem to be working
168	new	fixed	2002 Oct	anonymous	Shell	2003 Apr		4	4	Startup file complicates dumping a database
171	code	fixed	2002 Oct	anonymous		2002 Oct	drh	1	3	incompatibility with Borland run-time library
172	code	tested	2002 Oct	anonymous		2002 Oct	drh	3	3	incompatibility with Borland compiler
173	todo	fixed	2002 Oct	anonymous		2002 Oct	drh	4	3	publish.sh does not build dll correctly
174	code	fixed	2002 Oct	anonymous	Unknown	2002 Oct	drh	1	3	inconsistent data types
176	code	fixed	2002 Oct	mike		2002 Oct	drh	1	3	locking mechanism fails under Windows
177	code	tested	2002 Oct	danielk1977	VDBE	2003 Jan		1	4	Memory handling problem for very large aggregate results
178	code	fixed	2002 Oct	anonymous	Unknown	2002 Oct		2	3	Undefinied pointer with sqlite_get_table (empty result set)
179	code	fixed	2002 Oct	drh		2002 Oct	anonymous	1	1	Column names and string constants in parentheses cause errors.
185	code	fixed	2002 Oct	anonymous	Unknown	2002 Oct		1	1	Crash when running specific SQL
187	code	fixed	2002 Nov	anonymous	Parser	2002 Dec		2	2	Having count(*) issue
189	code	fixed	2002 Nov	anonymous		2002 Nov		4	4	sqlite html output format produces extra </TD>
190	code	fixed	2002 Nov	anonymous		2002 Nov		1	3	the btree code crashes on LP64 systems
191	code	fixed	2002 Nov	anonymous	Unknown	2003 Jan	drh	1	1	Large file support does not work in Windows
193	code	fixed	2002 Nov	anonymous	Unknown	2002 Dec		3	3	Incorrect creation of a VIEW when using SELECT ... LIMIT
194	new	fixed	2002 Nov	anonymous	BTree	2003 Apr		5	3	Remove warnings in btree.c
195	code	fixed	2002 Nov	anonymous		2002 Nov		2	4	Borland Compiler error for long long definition in os.h
197	code	fixed	2002 Dec	anonymous	Unknown	2002 Dec		1	1	Missing .yacc & .lex file...
198	todo	fixed	2002 Dec	anonymous		2003 Jan		1	1	Descending sort order in indices
200	code	fixed	2002 Dec	anonymous	Pager	2002 Dec		3	3	full pathname of database not recorded, so errors when chdir used
202	code	fixed	2002 Dec	anonymous		2002 Dec		1	1	make test core-dumps on solaris
206	code	fixed	2002 Dec	anonymous	Pager	2003 Jan		3	3	Local variable used before it is initialised
208	code	fixed	2002 Dec	anonymous	BTree	2002 Dec		2	2	pager.c uninitlized local variable
210	code	fixed	2002 Dec	anonymous	Unknown	2003 Jan	drh	1	1	Segfault on OSX with Perl bindings
211	new	fixed	2002 Dec	anonymous	Unknown	2003 Jan		4	4	How to add comments to an SQL-File
212	code	fixed	2003 Jan	drh	Pager	2003 Jan		2	1	Corrupt database results if the very first transaction rolls back.
213	new	fixed	2003 Jan	anonymous	Unknown	2003 Aug		4	4	Cygwin port needs __CYGWIN_USE_BIG_TYPES__ defined
215	new	fixed	2003 Jan	anonymous		2003 Feb		4	2	sqlite authorizer callback
217	code	review	2003 Jan	anonymous	Unknown	2003 Jan	anonymous	4	4	opcodes.c missing from the makefile SRC macro
218	new	fixed	2003 Jan	anonymous		2003 Jan		2	2	MacOS port for submission to CVS
220	code	fixed	2003 Jan	anonymous		2003 Jan		4	3	AS clause disables retrieving data types
221	doc	fixed	2003 Jan	anonymous		2003 Jan		2	4	pragma show_datatypes not documented
222	code	fixed	2003 Jan	anonymous	VDBE	2003 Jan		3	3	cleanup tries to access memory out of array bounds
223	code	fixed	2003 Jan	anonymous	VDBE	2003 Jan		3	3	using uninitialized memory's value
224	code	fixed	2003 Jan	anonymous	Pager	2003 Jan		3	3	read overflows memory
225	code	fixed	2003 Jan	anonymous	Unknown	2003 Jan		3	4	reading uninitialized memory
226	code	fixed	2003 Jan	anonymous	Unknown	2003 Jan		2	2	Glob doesn't work for upercase letters
227	code	fixed	2003 Jan	anonymous	Pager	2003 Jan		2	1	win32 db locked
231	code	fixed	2003 Jan	anonymous		2003 Jan		2	3	sqlite deny acces with wrong return value
232	code	fixed	2003 Jan	anonymous	Parser	2003 Feb		2	2	group by result is wrong
234	code	fixed	2003 Jan	anonymous		2003 Apr		4	4	Impossibility to have Comments and DOT-Commands in an SQL-File
237	code	fixed	2003 Jan	anonymous	Parser	2003 Jan		2	2	suspected problem in IN operator
238	code	fixed	2003 Feb	drh	CodeGen	2003 Feb		1	1	Assertion failure after some incorrect SQL
240	code	fixed	2003 Feb	anonymous		2003 Apr		5	4	fcntl return code checked instead of errno
245	code	fixed	2003 Feb	anonymous	Parser	2003 Feb		3	3	LIMIT and OFFSET clause
246	event	fixed	2003 Feb	anonymous	Unknown	2003 Feb		2	3	View not the same as direct query
247	code	fixed	2003 Feb	anonymous	VDBE	2003 Feb	drh	1	1	OUTER JOIN problem
249	code	fixed	2003 Feb	anonymous	Unknown	2004 Aug	drh	1	1	install
250	code	fixed	2003 Feb	anonymous	Unknown	2003 Mar		2	1	SQLite_Changes increments with new non-callback
256	code	fixed	2003 Feb	anonymous		2003 May		3	2	Simple Makefile error on HP/UX, may affect other UNIX systems
257	code	fixed	2003 Feb	anonymous	VDBE	2003 Mar		4	3	sqliteVdbeList should return SQLITE_DONE not SQLITE_OK
258	code	fixed	2003 Feb	anonymous	Parser	2003 Mar		3	3	sqlite_compile doesn't work with (some?) PRAGMAs
262	new	fixed	2003 Mar	anonymous	Unknown	2003 Jun		4	4	Non Callback is Slow on scripts
266	new	fixed	2003 Mar	drh		2003 Apr		1	1	Make the VACUUM command work.
269	new	fixed	2003 Mar	anonymous		2005 Jan		3	3	table.column view columns can not be referenced in where clause
270	code	fixed	2003 Mar	anonymous	Unknown	2003 Apr		3	4	incorrect check for fcntl error code
272	code	fixed	2003 Mar	anonymous		2003 May		3	3	select on view with where clause does not use index
275	code	fixed	2003 Mar	anonymous	CodeGen	2003 Apr		3	5	"INSERT INTO x SELECT * FROM x" doesn't work when x is a TEMP table
276	new	fixed	2003 Apr	anonymous	Shell	2003 Apr		3	3	Proposal/Bug-Fix for TTY determination
277	code	fixed	2003 Apr	anonymous	Parser	2003 Apr		1	2	Multi-line comments cause syntax errors in ".read" files
280	code	fixed	2003 Apr	anonymous		2003 Apr		2	2	Revise your code to use <stdarg.h>
281	code	fixed	2003 Apr	anonymous		2003 Apr		1	1	expression 0 = '' is true
282	code	fixed	2003 Apr	anonymous	Unknown	2003 May		2	3	Echo "\n" on Solaris causes two linebreaks. Makefile problem.
284	code	fixed	2003 Apr	anonymous	Unknown	2003 Apr		2	1	"make test" --> Segmentation Fault on Solaris
288	code	fixed	2003 Apr	anonymous		2003 Apr		1	1	sqlite don't compile on SuSE 8.2 (gcc 3.3)
289	code	fixed	2003 Apr	anonymous	BTree	2003 Apr		1	1	File src/btree_rb.c is missing
290	event	fixed	2003 Apr	drh	VDBE	2003 Apr		1	1	interaction of last_insert_rowid() and AFTER triggers
291	code	fixed	2003 Apr	drh		2003 Apr	drh	1	1	autoincrement does not work with triggers
292	code	fixed	2003 Apr	drh		2005 Jan		4	4	Multiple indices created for a UNIQUE PRIMARY KEY
293	code	fixed	2003 Apr	anonymous		2003 Apr	paul	1	2	configure-script broken by checkin #903
295	code	fixed	2003 Apr	drh	CodeGen	2003 Apr		1	1	ATTACH does not work on a database containing triggers
296	code	fixed	2003 Apr	anonymous	VDBE	2003 Apr		1	4	crash sqlite or execute via libtclsqlite
297	code	fixed	2003 Apr	anonymous		2003 Apr		1	1	sqliteSortCompare crashes when sorting ints by more than one key
298	code	fixed	2003 Apr	drh	CodeGen	2003 Apr		1	1	SELECT sometimes ignores constant WHERE clause
299	new	fixed	2003 Apr	anonymous	Parser	2006 Aug		2	3	Cannot insert only default values.
300	new	fixed	2003 Apr	anonymous		2005 Feb		5	5	Correlated Subqueries are not supported
302	code	fixed	2003 Apr	anonymous	Shell	2003 Apr		3	3	.sqliterc can do memory fault
305	code	fixed	2003 May	chw		2003 Dec		1	1	Problems with locale specific "," as the radix point character
306	code	fixed	2003 May	drh	CodeGen	2003 May		1	1	Left outer join fails when right table is a view of a join.
308	todo	fixed	2003 May	anonymous	Unknown	2003 May		1	1	can not unzip downloaded binary files
309	code	fixed	2003 May	anonymous	Unknown	2003 May		5	5	Source code files are corrupted
310	code	fixed	2003 May	anonymous	Pager	2003 May		3	3	win32 locking error
311	code	fixed	2003 May	anonymous		2003 May		3	3	configure fails with non gcc compilers due to non escaped \n in test
313	code	fixed	2003 May	anonymous	Unknown	2003 May		2	3	Creating a table with a specific name crashes SQLite.
315	code	fixed	2003 May	anonymous	Unknown	2003 May		3	3	Usage of potentially changed address
316	code	fixed	2003 May	anonymous	Unknown	2003 Aug		2	3	Cygwin with gcc V2.95.3 compilation -- os.h
317	code	fixed	2003 May	jplyon	CodeGen	2003 May		2	3	ATTACH fails for external database containing an index
318	code	fixed	2003 May	anonymous	Unknown	2003 Jul	drh	1	1	dl-minimal.c: 128: realloc: Asseration failure...
322	code	fixed	2003 May	anonymous		2003 Aug		3	3	Configure problem with ming32 on win32 (XP) and all sqlite version
323	code	fixed	2003 May	anonymous	CodeGen	2003 Jun		1	1	Assertion failed by attaching a file
327	code	fixed	2003 May	anonymous		2003 Aug		1	1	Cygwin 1.3.22 compile failure
332	code	tested	2003 May	anonymous	Unknown	2003 Jun		5	1	Dropping a temp trigger causes an access violation
333	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun		1	1	Temp Triggers cause update/delete statement failure with explicit transaction
334	code	fixed	2003 Jun	drh	CodeGen	2003 Jun		1	1	REPLACE statement corrupts indices
336	code	fixed	2003 Jun	anonymous		2003 Jun		4	2	Compiler warnings on SQLite 2.8.3
337	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun		4	4	.dll produces database files claiming version 2.0.1
340	code	fixed	2003 Jun	anonymous		2003 Jun		1	2	ATTACH database needs an authorization hook
341	code	fixed	2003 Jun	anonymous	VDBE	2003 Jun		4	3	vdbe.c calls access() instead of sqliteOsFileExists()
342	code	fixed	2003 Jun	anonymous		2003 Jun		5	3	vxprintf() makes invalid assumptions about size of pointer and long
345	event	fixed	2003 Jun	anonymous	BTree	2003 Jun		4	4	repeated returns
346	code	fixed	2003 Jun	anonymous	BTree	2003 Jul		3	3	Problem with LIMIT 0
347	code	fixed	2003 Jun	anonymous	BTree	2003 Jun		4	3	Workaround for warning that print_node() in btree_rb.c is unused
349	code	fixed	2003 Jun	anonymous		2003 Aug		3	2	Cygwin build errors
350	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun		2	3	LEFT JOIN works improperly on static inner queries and views
351	code	fixed	2003 Jun	anonymous	Pager	2003 Jun		2	3	Journal pager playback doesn't secure exclusive access
352	code	fixed	2003 Jun	anonymous	Shell	2003 Jun		3	3	The sqlite shell ignores empty lines inside SQL strings
353	code	fixed	2003 Jun	anonymous		2003 Jun		4	3	Compile errors when SQLITE_OMIT_AUTHORIZATION is defined
354	code	fixed	2003 Jun	anonymous	Unknown	2003 Jul		3	2	ATTACH DATABASE call asserts in build.c in Debug Mode in MSVC7.1
355	code	fixed	2003 Jun	anonymous	BTree	2003 Jun		4	3	Compile warning when NDEBUG is defined
357	code	fixed	2003 Jun	anonymous	Pager	2003 Aug	drh	4	3	Compilation errors and warnings when compiled on Open VMS
360	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun		2	3	"not N between n and m" in trigger dumps core
361	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun	anonymous	3	3	main.c doesn't compile when SQLITE_OMIT_TRACE=1
364	code	fixed	2003 Jun	anonymous		2003 Jun		3	3	Assert when doing SELECT ROWID,* against a VIEW
365	code	fixed	2003 Jun	anonymous	VDBE	2003 Jun		3	4	Can not define SQLITE_OMIT_AUTHORIZATION
367	code	fixed	2003 Jun	anonymous	Unknown	2003 Jun		4	1	soundex bug
370	code	fixed	2003 Jun	anonymous		2004 Feb	dougcurrie	2	3	make fulltest status on Cygwin, failure on 2 tests
373	code	fixed	2003 Jul	anonymous		2003 Aug		1	2	2.8.4 Cygwin compile failure
377	code	fixed	2003 Jul	anonymous		2003 Jul		1	3	Comparisons of integer primary key to float are erroneous
378	doc	fixed	2003 Jul	anonymous	Shell	2003 Jul		5	4	sqlite command line utility still needs file name
383	code	fixed	2003 Jul	anonymous	Unknown	2003 Jul		1	3	sqlite_changes returns wrong value with non-callback API
384	new	fixed	2003 Jul	anonymous		2003 Jul		4	4	NULL argument for pzTail to sqlite_compile causes access violation
385	new	fixed	2003 Jul	anonymous		2003 Jul		4	4	NULL args for output variables to sqlite_step cause access violation
387	code	fixed	2003 Jul	anonymous	Parser	2003 Jul		1	1	Parse has problems with parser names ...
393	code	fixed	2003 Jul	anonymous	Unknown	2003 Jul		3	4	UNION and LIMIT incorrectly
394	code	fixed	2003 Jul	anonymous	Parser	2003 Jul		4	1	SELECT 1; syntax throw run-time compiler warning
396	code	fixed	2003 Jul	anonymous	Unknown	2003 Jul		3	2	AGGREGATE FUNCTION WITH LIMIT
397	code	fixed	2003 Jul	anonymous	Unknown	2003 Jul		4	3	tests attach-5.1 and attach2-1.1 fail on w2k mingw
400	code	fixed	2003 Jul	anonymous		2003 Jul		3	4	shell.c, when readline() not avail, getline() conflicts with stdio's
401	code	fixed	2003 Jul	anonymous		2003 Jul		2	3	Source downloads considered useless..
403	code	fixed	2003 Jul	anonymous		2008 Jun		4	4	Two small fixes in .spec file for RPMS
405	todo	fixed	2003 Jul	anonymous		2003 Jul		1	1	Missing complete unix source tarballs
406	code	fixed	2003 Jul	anonymous		2003 Jul		1	1	BEGIN ON CONFLICT ROLLBACK
408	code	fixed	2003 Jul	anonymous	VDBE	2003 Jul		1	1	toInt() reports success on overflow, causes comparisons to fail
410	code	fixed	2003 Jul	anonymous	Pager	2003 Jul		3	4	Creation and deltions of files should fsync() directory
416	code	fixed	2003 Jul	anonymous		2003 Jul		1	1	An SQL DML which yields a segfault
419	new	fixed	2003 Jul	anonymous		2003 Aug		4	3	Return index name with 'uniqueness constraint failed' error message
421	code	fixed	2003 Aug	anonymous		2003 Aug		3	3	bug on sqliteRealloc_
427	code	fixed	2003 Aug	anonymous	Unknown	2003 Aug		2	2	access violation on vacuum with pragma empty_result_callbacks
429	code	fixed	2003 Aug	anonymous		2003 Aug		1	2	os.h cygwin compilation patch
430	code	fixed	2003 Aug	drh		2003 Aug		1	1	Dropping a trigger with the same name as a table corrupts the database
432	code	fixed	2003 Aug	drh		2003 Aug		3	3	Returns "Disk I/O Error" when the filename is an empty string
433	new	fixed	2003 Aug	anonymous	Unknown	2003 Dec	dougcurrie	3	2	configure needs updating for mingw/msys
434	code	fixed	2003 Aug	anonymous		2003 Aug		3	3	vacuum-3.1 test fails on Win2k needs db2 close
435	code	fixed	2003 Aug	anonymous	Unknown	2003 Aug		3	3	backslash in Makefile hides clean target
439	code	fixed	2003 Aug	anonymous	Unknown	2005 Jan		2	3	Query fails when run as a View
444	code	fixed	2003 Sep	anonymous	Shell	2003 Dec		3	4	free (zErrMsg) in shell.c should be sqlite_freemem(zErrMsg)
447	event	fixed	2003 Sep	anonymous		2003 Sep		3	1	Problems compiling on FreeBSD 4.8-STABLE
450	new	defer	2003 Sep	anonymous	Shell	2008 Jun		5	4	Make HTML Output XHTML compliant
452	code	fixed	2003 Sep	anonymous	TclLib	2003 Dec		4	3	DbMain assumes sscanf likes 0x... syntax for pointers, breaking tests
453	code	fixed	2003 Sep	anonymous	Parser	2003 Sep		3	3	"SELECT a, b FROM tt;-" Crashes SQLite
458	new	fixed	2003 Sep	xdong	Unknown	2003 Sep	xdong	5	5	configure file and libtool doesnot work for cross compiling
459	new	fixed	2003 Sep	xdong	Unknown	2003 Sep	xdong	5	5	adding releasemode option to allow libtool link release
460	new	fixed	2003 Sep	anonymous	VDBE	2003 Nov		5	5	[Patch] extending copy command for dump file of PostgerSQL pg_dump.
461	code	fixed	2003 Sep	anonymous	CodeGen	2003 Sep		3	3	Nulls are incorrectly returned on an indexed column
468	code	fixed	2003 Oct	anonymous		2003 Oct		2	2	DROP TRIGGER w/ single quotes doesn't work.
469	code	fixed	2003 Oct	anonymous	Unknown	2005 Jan		4	3	Qualified column name in subselect not recognized in outer select
480	code	fixed	2003 Oct	anonymous	CodeGen	2005 Sep		3	5	Joins with more than 32 tables are broken
481	code	fixed	2003 Oct	anonymous	VDBE	2004 Feb		1	3	last_insert_rowid doesn't work within triggers any more
482	code	fixed	2003 Oct	anonymous	BTree	2003 Dec		1	1	SIGSEGV inside memRbtreeNext
487	code	fixed	2003 Nov	anonymous		2003 Nov		2	2	mac os x build via pear creates invalid bundle
488	doc	fixed	2003 Nov	anonymous		2003 Nov		5	4	Lemon Parser Generator page is outdated
489	new	fixed	2003 Nov	anonymous		2008 Jun		4	4	DLL exports suggestion
502	doc	fixed	2003 Nov	anonymous	BTree	2003 Nov		5	3	Typos in Database File Format documentation
504	code	fixed	2003 Nov	anonymous		2004 Feb		3	3	'INDEX_INFO' PRAGMA returns invalid data if used with non-callback API
505	doc	fixed	2003 Nov	anonymous		2003 Nov		5	3	Typos in SQLite Database File Format document
514	code	fixed	2003 Dec	anonymous	Unknown	2004 Mar		2	3	attaching a locked database causes strange errors and a crash
515	code	fixed	2003 Dec	anonymous	Unknown	2003 Dec		4	3	VACUUM fails after dependent table DROP,CREATE sequence
519	code	fixed	2003 Dec	drh	VDBE	2003 Dec		1	1	3-way join causes segfault
520	code	fixed	2003 Dec	anonymous	Parser	2003 Dec	drh	2	2	tokenize bug in simultaneous threaded sqlite_open (with patch)
521	code	fixed	2003 Dec	anonymous	Unknown	2004 Jul		2	1	"create as select ..." does not preserve datatypes
523	code	fixed	2003 Dec	anonymous	Unknown	2005 Jan		2	2	Select table 'AS' does not work in JOIN USING clause
526	code	fixed	2003 Dec	anonymous		2003 Dec		1	1	Primary key not unique (database corruption?)
529	code	fixed	2003 Dec	drh		2003 Dec		1	1	An aborted update can corrupt the database
530	code	fixed	2003 Dec	anonymous	Pager	2003 Dec		2	2	sqlite returns SQLITE_BUSY forever (linux multithreaded)
533	code	fixed	2003 Dec	anonymous		2003 Dec		2	1	Crash when using datetime() with a NULL value.
534	code	fixed	2003 Dec	anonymous		2004 Jan		2	2	possible bug in sqliteMalloc and sqliteMallocRaw
541	code	fixed	2003 Dec	anonymous		2003 Dec	drh	1	1	Compile error in os.c
542	code	fixed	2003 Dec	anonymous	Parser	2003 Dec		1	1	crash on date parsing
545	code	fixed	2004 Jan	anonymous	BTree	2004 Jan		5	4	Use of uninitialized memory
548	code	fixed	2004 Jan	anonymous	Parser	2004 Jan		3	3	SQLite will abort() when utf-8 character is invalid
551	code	fixed	2004 Jan	anonymous	Unknown	2004 Jan		3	3	Date/Time functions: some modifiers cause loss of h:m:s
552	code	fixed	2004 Jan	drh		2004 Jan		1	1	Integer overflow results in database corruption
558	build	fixed	2004 Jan	anonymous		2008 Mar		4	4	Makefile.in should honor libdir and bindir
561	code	fixed	2004 Jan	drh	Pager	2004 Jan		1	1	Database corruption when using Linux threads
564	code	fixed	2004 Jan	anonymous	Parser	2005 Jan		4	4	Inability to determine column in subquery
565	code	fixed	2004 Jan	anonymous	VDBE	2004 Jan		2	3	sqlite: src/vdbe.c:512: sqliteVdbeExec: Assertion `p->tos<=pc' failed.
567	code	fixed	2004 Jan	anonymous	Unknown	2004 Jan		3	3	Erroneous test for rowid >= (fp number) in where clause
568	code	fixed	2004 Jan	anonymous	Shell	2004 Feb		2	2	Shell does not handle -init option correctly
569	code	fixed	2004 Jan	dougcurrie	Pager	2004 Jan	dougcurrie	3	3	Newer Cygwin (>1.50) doesn't want __CYGWIN_USE_BIG_TYPES__
574	code	fixed	2004 Jan	drh		2004 Jan		1	1	ATTACH fails when invoked from sqlite_compile()
576	code	fixed	2004 Jan	anonymous	CodeGen	2004 Feb		1	2	last_insert_rowid() returns wrong values in triggers on views
577	doc	fixed	2004 Jan	anonymous		2004 Jan		5	3	Typo on main SQLite home page
582	build	fixed	2004 Jan	anonymous		2004 Jan		4	3	no permission to execute install-sh
583	warn	fixed	2004 Jan	anonymous	Unknown	2004 Feb		4	4	_FILE_OFFSET_BITS redefined on 64bit sparc-sun-solaris
587	code	fixed	2004 Jan	anonymous	Unknown	2004 Jan		3	1	easy way to operate on a max () value
593	code	fixed	2004 Feb	anonymous	VDBE	2004 Feb		3	3	Interrupted VACUUM returns SQLITE_ERROR not SQLITE_INTERRUPT
594	code	fixed	2004 Feb	anonymous		2004 Feb		1	1	TEMP tables not dropped by ROLLBACK if sqlite_interrupt was called
599	code	fixed	2004 Feb	anonymous	Pager	2004 Feb		1	2	Corrupt problem encountered on Windows NT platform
601	code	fixed	2004 Feb	anonymous	CodeGen	2004 Feb		1	1	Left-join subquery gives incorrect results
602	code	fixed	2004 Feb	anonymous		2004 Feb		1	1	Update tablename set rowid = rowid -1 fails for more than 1000 records
603	code	fixed	2004 Feb	anonymous		2004 Feb		4	4	compile error date.c if SQLITE_OMIT_DATETIME_FUNCS defined
604	warn	fixed	2004 Feb	anonymous	Parser	2004 Feb		4	4	'db' has been referenced but never assigned a value
605	warn	fixed	2004 Feb	anonymous		2004 Feb		1	1	_FILE_OFFSET_BITS redefined
610	code	fixed	2004 Feb	anonymous	Parser	2004 Feb		5	4	REPLACE INTO syntax not allowed in triggers
612	code	fixed	2004 Feb	anonymous		2004 Feb	anonymous	3	1	Pointer 'db' not initialized in function lookupname() (expr.c)
614	code	fixed	2004 Feb	anonymous	Shell	2004 Feb		2	1	history not saved after quitting the shell with .quit
615	code	fixed	2004 Feb	drh	Pager	2004 Feb		2	3	Assertion fault in pager when synchronous changed within a transaction
617	new	fixed	2004 Feb	anonymous	Unknown	2004 Feb		5	4	date() conversion seems to fail on -ve dates
620	code	fixed	2004 Feb	anonymous	Shell	2004 Feb		1	1	sqlite executable crashes
623	code	fixed	2004 Feb	anonymous	Unknown	2004 Feb		2	3	Erroneous min/max on US zip codes
626	code	fixed	2004 Feb	anonymous	Parser	2004 Feb		2	2	EXPLAIN BEGIN TRANSACTION really starts a transaction
634	warn	fixed	2004 Feb	anonymous	Unknown	2004 Feb		3	3	Compiler warnings when compiling using LCC
640	code	fixed	2004 Mar	drh	CodeGen	2004 Mar		1	1	Trigger causes assertion failure
641	code	fixed	2004 Mar	anonymous	Unknown	2004 Mar		1	1	select query doen't work with binary equations
648	code	fixed	2004 Mar	rdc	Unknown	2004 Mar		3	3	duplicate tracing with revised sqlite_exec implementation
651	new	active	2004 Mar	anonymous		2009 Aug		5	4	Update optimization
654	code	fixed	2004 Mar	anonymous	Unknown	2004 Mar		3	2	Can't compile with CodeWarrior Studio v9.1
655	code	fixed	2004 Mar	anonymous	VDBE	2004 Jul		1	3	Numeric/string confusion with "in"
658	code	fixed	2004 Mar	anonymous		2004 Mar		3	3	select max(rowid) from union crashes sqlite command-line
659	code	fixed	2004 Mar	anonymous		2004 Mar		4	4	+1 month issue (dead or defective code) in date.c
665	code	fixed	2004 Mar	anonymous		2004 Apr		3	3	Lemon.c + OpenWatcom 1.3
667	build	fixed	2004 Mar	dougcurrie	Unknown	2004 Mar	dougcurrie	2	1	Makefile.in needs updates for encode, .defs, Makefile target
668	code	fixed	2004 Mar	anonymous	VDBE	2004 Mar		2	2	sqlite crash on combinng case and not in
670	code	fixed	2004 Mar	anonymous		2004 Mar		3	3	The '.database' trunc file name
680	code	fixed	2004 Mar	anonymous	Parser	2004 Jul		3	3	Parser fails on quoted table/alias DOT STAR
683	code	fixed	2004 Apr	anonymous	Unknown	2004 Jul		1	1	Impossible to drop index with single quotes in the name
686	code	fixed	2004 Apr	anonymous		2004 Jul		2	3	select + indexes + left join + "in (set)" causes core dump
687	code	fixed	2004 Apr	anonymous		2004 Jul		4	2	Sqlite incorrectly handles invalid filenames.
690	code	fixed	2004 Apr	anonymous		2005 Jan		3	3	NATURAL JOIN does not work with table aliases
692	code	fixed	2004 Apr	anonymous	Parser	2004 Apr		3	3	lemon.c:void emit_destructor_code() pointer unitialized
703	code	fixed	2004 Apr	anonymous		2004 Jul		3	3	Aggregate functions (min/max) fail over sub-queries
705	code	fixed	2004 Apr	anonymous	Parser	2004 Jul		3	3	can't handle special char in column name
708	code	fixed	2004 Apr	anonymous	Unknown	2004 Jul	rdc	4	1	nonASCII Upper & Lower
713	code	fixed	2004 Apr	anonymous	Unknown	2004 Jul	drh	3	3	Compiling with SQLITE_OMIT_DATETIME_FUNCS causes error
716	code	fixed	2004 Apr	anonymous	Unknown	2005 Jan		4	4	create table as should preserve column types
743	code	fixed	2004 May	anonymous	Parser	2005 Jun		2	2	WHERE clause with USING incorrectly requires table name
749	code	fixed	2004 May	anonymous	CodeGen	2004 Jul		2	1	SELECT DISTINCT with LIMIT
756	code	fixed	2004 Jun	anonymous		2004 Jul		2	3	Core Dump - Select From View
757	code	fixed	2004 Jun	anonymous	VDBE	2004 Jun		3	3	Indexes on temporary tables leave cursors open
758	code	fixed	2004 Jun	anonymous	Shell	2004 Jul		1	1	Incorrect return value form strftime %W
760	code	fixed	2004 Jun	anonymous	Parser	2005 Jan		2	3	Selects leave tablename in tablename.columname
765	build	fixed	2004 Jun	anonymous		2004 Jun	dougcurrie	3	2	MinGW/MSYS build fails with vrsion 3.0.0
766	code	review	2004 Jun	anonymous	Pager	2005 Aug		3	5	cygwin, absolute path problem
768	code	fixed	2004 Jun	anonymous		2004 Jul	anonymous	1	2	3.0.0 alpha WHERE-AND evaluation
770	doc	fixed	2004 Jun	anonymous		2004 Jun		5	4	Typo in SQLite 3 Overview doc
771	doc	fixed	2004 Jun	anonymous		2004 Jun		5	4	Typo on SQLite 3 Overview page
772	build	fixed	2004 Jun	anonymous		2004 Jun		2	2	configure with cygwin broken
774	code	fixed	2004 Jun	anonymous	Unknown	2004 Aug		1	1	sqlite3_exec not exported in windows sqlite.dll
777	code	fixed	2004 Jun	anonymous		2004 Jun		1	1	MIN() does not return NULL if there is a NULL in the list
778	code	fixed	2004 Jun	anonymous	Unknown	2004 Jun		1	1	output of sqlite3_mprintf isn't correct
782	new	fixed	2004 Jun	anonymous	Unknown	2005 Feb		3	2	Correlated subqueries are not supported
784	code	fixed	2004 Jun	anonymous		2004 Jul		2	2	SQLITE_OMIT_DATETIME_FUNCS code error with Microsoft compilers
785	code	fixed	2004 Jun	anonymous		2004 Jun		1	1	local variable 'db' used without having been initialized
786	code	fixed	2004 Jun	anonymous	BTree	2004 Aug	drh	1	1	sqlite3 change SQLITE_PAGE_SIZE to 4096 causes assert
789	code	fixed	2004 Jun	anonymous		2004 Jun		1	1	the 'LL' qualifier is not supported by MSVC
791	code	fixed	2004 Jul	anonymous		2004 Jul		1	1	3.0.2 fails to build under Mingw
793	new	fixed	2004 Jul	anonymous	Unknown	2005 Feb	drh	4	4	Source *.tar.gz Files Should Untar Into Directory sqlite-{version}
794	new	fixed	2004 Jul	anonymous	Unknown	2004 Jul		4	3	add API to report number of wildcards in sqlite3_prepare*
800	todo	fixed	2004 Jul	anonymous	VDBE	2004 Jul		3	3	Handling of NULLs by set function MIN has been changed to non-standard
804	code	fixed	2004 Jul	anonymous		2004 Jul		1	1	sqliteStrNICmp() and sqliteStrICmp() return wrong value.
805	code	fixed	2004 Jul	anonymous		2004 Jul		3	2	coalesce in the where clause doesn't work
806	code	fixed	2004 Jul	anonymous	VDBE	2004 Jul		3	3	The maximum number of tables allowed in a join is 32.
807	code	fixed	2004 Jul	anonymous	VDBE	2004 Jul		1	3	Cannot run a prepared CREATE TABLE statement more than once
810	code	fixed	2004 Jul	anonymous	Unknown	2004 Sep		1	3	SELECT ROWID, * FROM SOMEVIEW -> crash
811	code	fixed	2004 Jul	drh		2004 Jul	drh	1	1	When ATTACH fails, strange things happen.
812	code	fixed	2004 Jul	anonymous	Unknown	2004 Jul		3	3	sqlite_mprintf ("%s", "") - "%s" alone with empty string arg fails
813	code	fixed	2004 Jul	anonymous		2004 Jul		2	4	LEFT OUTER JOIN give wrong result when an index is present
818	doc	fixed	2004 Jul	anonymous		2004 Jul		4	3	The SQLite 3 API reference says "sqlite " instead of "sqlite3 "
819	code	fixed	2004 Jul	anonymous	Unknown	2004 Oct		1	2	building on linux/FC2 with --enable-threadsafe needs a -lpthread dep.
826	code	fixed	2004 Jul	drh	CodeGen	2004 Aug	drh	1	1	Nested views do not process * correctly.
827	code	fixed	2004 Jul	anonymous	Unknown	2004 Jul		2	3	sub-select involving random() does not work
829	code	fixed	2004 Jul	drh	CodeGen	2004 Jul	drh	1	1	VACUUM fails if there is a UNIQUE index
831	code	fixed	2004 Jul	anonymous		2004 Jul		4	3	sqlite_mprintf("%q", "") returns random data
834	code	fixed	2004 Jul	anonymous	Unknown	2004 Aug		4	3	No equivalent to sqlite_libversion() API call in SQLite3
837	code	fixed	2004 Aug	anonymous		2004 Sep		1	2	VACUUM returns "sql logic error or missing database"
838	new	fixed	2004 Aug	anonymous		2004 Aug		4	2	Change os_common.h to allow SQLITE_DEBUG on Windows.
839	code	fixed	2004 Aug	anonymous		2004 Aug		2	2	'int isdigit(int)' causes a crash
842	code	fixed	2004 Aug	anonymous		2004 Aug		2	2	Ignoring an error return from sqlite3_exec causes invalid db.
844	code	fixed	2004 Aug	anonymous	VDBE	2004 Aug		1	1	AFTER DELETE trigger has erroneous values in old.X "variables"!
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)
855	build	fixed	2004 Aug	anonymous	Unknown	2005 Feb		4	3	Unpack directory should include a version: sqlite-3.0.4/
857	event	fixed	2004 Aug	anonymous		2004 Aug		1	1	Unable to download 3.0.4 precompiled binaries for Linux.
859	doc	fixed	2004 Aug	anonymous		2004 Aug		5	4	typo in comment
860	code	fixed	2004 Aug	anonymous	Unknown	2004 Oct		3	1	SQLite 3.0.4 fails under Solaris 9
862	code	fixed	2004 Aug	anonymous	VDBE	2004 Aug		2	2	Memory is being freed twice when performing VACUUM on corrupted DB
869	code	fixed	2004 Aug	anonymous		2004 Aug	drh	3	3	SQLite 2.x: CREATE INDEX and dbl-quoted index names
870	code	fixed	2004 Aug	anonymous		2004 Aug		4	4	Segmentation Fault on sqlite3_step if sqlite3_prepare fails
871	code	fixed	2004 Aug	dougcurrie	TclLib	2004 Aug		3	1	sqlite_temp_directory only defined in os_unix but used in tcl
872	code	fixed	2004 Aug	anonymous		2005 Sep		5	5	SQL does not support non-ASCII IO?
873	code	fixed	2004 Aug	anonymous		2004 Sep		1	2	VACUUM of database with ' character in filename causes error
875	code	fixed	2004 Aug	anonymous	VDBE	2004 Aug		1	3	Error when INTERSECTing more than two subqueries.
877	todo	fixed	2004 Aug	anonymous	Parser	2004 Aug		4	2	Binary garbage in preprocessed source file 'parse.c' (3.0.5)
881	code	fixed	2004 Sep	anonymous	BTree	2004 Sep		1	3	Can not compile under Windows with Borland C++ Builder
885	code	fixed	2004 Sep	drh	VDBE	2004 Sep		1	1	Sqlite3_step() does not return SQLITE_BUSY after a commit fails
886	code	fixed	2004 Sep	anonymous	Unknown	2004 Sep	anonymous	2	2	v3 assert with explain
888	doc	fixed	2004 Sep	anonymous	BTree	2004 Sep		5	4	incorrect (obsolete) comment above sqlite3BtreeOpen in btree.c
890	code	fixed	2004 Sep	anonymous	BTree	2004 Sep	anonymous	1	1	Page sizes other than 1024 bytes result in segfaults
891	build	fixed	2004 Sep	anonymous		2004 Sep		4	4	creating directories in makefile
892	code	fixed	2004 Sep	anonymous		2004 Sep		3	1	LEMON can't generate well-formed Windows parsers with full paths
895	code	fixed	2004 Sep	anonymous		2004 Sep		4	4	LEMON doesn't like single-line parse_failure code.
896	code	fixed	2004 Sep	anonymous	Parser	2004 Sep	anonymous	1	3	Access violation when attempt to execute invalid query
897	code	fixed	2004 Sep	anonymous		2004 Sep		3	4	LEMON: Line numbers in generated parser.c are off. (Windows)
898	code	fixed	2004 Sep	anonymous		2004 Sep		1	1	nullif() crashes inside trigger
899	doc	fixed	2004 Sep	anonymous		2004 Nov		4	3	sqlite3_create_function / negative nArg glitch
900	new	fixed	2004 Sep	anonymous		2004 Sep		4	4	sqlite3_trace and reusing prepared statements
901	code	fixed	2004 Sep	anonymous	BTree	2004 Sep		1	1	invalid btree cursor read locks honored?
903	build	fixed	2004 Sep	anonymous		2004 Sep		3	3	make doc fails (please use mkdir -p)
904	build	fixed	2004 Sep	anonymous		2004 Sep		3	3	x86_64: please use $(libdir) instead of $(prefix)/lib
905	code	fixed	2004 Sep	anonymous	VDBE	2004 Oct		2	4	assertion failed in vdbe.c (it fails to not crash upon user error?)
907	build	fixed	2004 Sep	anonymous		2004 Oct		1	2	If --enable-threadsafe then pthreads library is not linked in
908	event	fixed	2004 Sep	anonymous		2004 Sep		5	5	corrupt sqlite-3.0.7.so.gz file on download page
910	build	fixed	2004 Sep	dougcurrie	Unknown	2004 Oct	dougcurrie	2	2	Windows doesn't (usually) have or need pthread
911	code	fixed	2004 Sep	anonymous	Shell	2004 Oct		3	3	The sqlite command ".mode csv" doesn't work correctly
912	code	fixed	2004 Sep	anonymous		2004 Sep		1	1	sqlite3 crashes in join statement
913	code	fixed	2004 Sep	anonymous		2004 Oct		3	2	Locking in os_unix.c
914	code	fixed	2004 Sep	anonymous	Shell	2004 Sep		5	4	Small typo in shell help for .mode
918	code	fixed	2004 Sep	anonymous	VDBE	2004 Sep		1	1	sqlite3_bind_parameter_index produces access violation
922	code	fixed	2004 Sep	anonymous		2004 Sep		5	2	SELECT statement crashes sqlite3
924	code	fixed	2004 Sep	anonymous		2004 Oct	drh	2	2	Compile problem using mingw "msys" environment and gcc 3.4.2
925	code	fixed	2004 Sep	anonymous	BTree	2004 Sep		1	4	crash in btree.c:reparentPage when pageSize != usableSize
926	new	fixed	2004 Sep	anonymous		2004 Sep		1	1	create_function after a prepare returns MISUSE error
927	code	fixed	2004 Sep	anonymous		2004 Sep		3	2	errcode() returning OK even when previous function returned error
932	code	fixed	2004 Sep	anonymous	VDBE	2004 Sep	drh	3	4	With NDEBUG, SQLITE_DEBUG breaks
934	code	fixed	2004 Sep	anonymous		2004 Sep		3	1	pragma table_info
936	code	fixed	2004 Sep	anonymous	CodeGen	2004 Sep		3	1	Prototype declaration is not correct
938	code	fixed	2004 Oct	anonymous		2004 Oct		3	2	File locking in os_win.c (related to ticket #913)
939	code	fixed	2004 Oct	anonymous	Unknown	2004 Oct		2	3	.import appends \n to last field (text fields, windows)
940	new	fixed	2004 Oct	anonymous		2004 Oct		4	3	Simplify the makefile
943	new	fixed	2004 Oct	anonymous		2004 Oct		5	4	Missing const declarations.
946	code	fixed	2004 Oct	anonymous		2004 Oct		4	3	Including both sqlite.h and sqlite3.h results in error
948	code	fixed	2004 Oct	anonymous	Unknown	2004 Oct		4	4	glob in attach2.test fails (Fedora Core)
953	code	fixed	2004 Oct	anonymous	Shell	2004 Nov	drh	2	3	sqlite3 core dump when delete record by specified rowid range
956	doc	fixed	2004 Oct	anonymous		2004 Oct		5	4	Typo on homepage
959	build	fixed	2004 Oct	anonymous		2005 Sep		4	4	mkopcodeh.awk requires gawk on Solaris
962	new	fixed	2004 Oct	anonymous		2004 Oct		4	4	Test btree_8.23.3 should use hypen instead of underscore
966	code	fixed	2004 Oct	anonymous		2004 Oct		1	1	GROUP BY of aggregate function fails with Out of Memory
969	code	new	2004 Oct	anonymous	TclLib	2005 Jan		3	3	PRAGMA empty_result_callbacks not working in tclsqlite-3.0.8.so part 2
973	code	fixed	2004 Oct	anonymous	Shell	2004 Oct		4	4	shell: "select" output interferes with future ".databases" output
975	code	fixed	2004 Oct	drh	BTree	2004 Nov	drh	1	1	Non-standard page sizes cause problems for large files
979	code	fixed	2004 Nov	anonymous	Unknown	2004 Nov		1	3	large heap memory usage when creating VIEW TABLES from schema.sql file
980	code	fixed	2004 Nov	anonymous	VDBE	2004 Dec		2	4	Two triggers confusing each other
984	code	fixed	2004 Nov	anonymous	Unknown	2004 Nov		3	3	sqlite3HexToBlob required & omitted by SQLITE_HAS_CODEC
985	code	fixed	2004 Nov	anonymous	BTree	2005 Jan		3	3	"Invalid read of size 1" errors created in btree.c line 2804
991	code	fixed	2004 Nov	anonymous	VDBE	2004 Nov		4	4	misleading error message returned for bad column index
995	new	fixed	2004 Nov	anonymous		2004 Nov		4	3	Manual page for SQLite 3 should be named sqlite3.1
1001	doc	fixed	2004 Nov	anonymous	VDBE	2004 Nov		3	3	No documentation for VDBE Opcode MakeRecord
1002	doc	fixed	2004 Nov	anonymous	Parser	2004 Nov		3	3	documentation of LIMIT clause is misleading
1003	doc	fixed	2004 Nov	anonymous	VDBE	2004 Nov		3	3	The documentation of VDBE Opcode SortPut is incorrect
1004	doc	fixed	2004 Nov	anonymous	Unknown	2004 Nov		3	3	eTextRep argument to sqlite3_create_function not documented
1007	code	defer	2004 Nov	anonymous		2004 Nov		3	2	SQLite ignores SQLITE_CORRUPT error and continues executing SQL query
1008	code	fixed	2004 Nov	anonymous	Unknown	2004 Nov	anonymous	4	1	default_temp_store=0 after VACUUM
1010	code	fixed	2004 Nov	anonymous	BTree	2004 Dec		3	3	btree.c: "pagesSize" should be "usableSize" for AutoVacuum and MX_CELL
1012	build	fixed	2004 Nov	anonymous	Unknown	2004 Nov		3	3	adding "cursor.c" to Makefile.in (diffs included)
1025	code	fixed	2004 Dec	anonymous		2005 Jan		3	3	Error starting transaction, SQLite still consider it started.
1032	new	fixed	2004 Dec	anonymous	VDBE	2004 Dec		2	3	access violation in sqlite3_bind_parameter_index when name is NULL
1033	build	fixed	2004 Dec	anonymous		2004 Dec		4	4	configure --help displays incorrect info for --with-tcl
1035	code	fixed	2004 Dec	anonymous	Unknown	2004 Dec		1	1	union queries with sub-select tables with limits returns no results
1036	code	fixed	2004 Dec	anonymous	Unknown	2007 Mar		3	1	Wrong handling of column names from VIEWs
1039	code	fixed	2004 Dec	anonymous		2005 Jan		1	1	GROUP BY causes a crash
1046	code	fixed	2004 Dec	anonymous		2004 Dec		2	3	checkin 2170 breaks SQLite
1047	code	fixed	2004 Dec		CodeGen	2005 Jan		1	1	text column comparison in joins may follow NUMERIC rules
1048	code	fixed	2004 Dec	anonymous		2005 Jan		3	2	Wrong column naming
1049	doc	fixed	2004 Dec	anonymous		2005 Mar		4	4	Document that pragma default_synchronous is no longer available in v3.
1051	code	fixed	2004 Dec	anonymous	Unknown	2004 Dec		2	2	pragma.c code breaks build when SQLITE_DEBUG #defined, fix included
1052	doc	fixed	2004 Dec	anonymous	VDBE	2005 Jan		5	5	Typo error
1054	code	fixed	2004 Dec	anonymous	Parser	2005 Jan		1	1	Query with unknown column crashes when authorizer is set
1057	doc	fixed	2004 Dec	anonymous		2005 Jan		5	5	update "MEMORY_DEBUG" to "SQLITE_DEBUG" in several sqlite files
1062	code	fixed	2005 Jan	anonymous	CodeGen	2005 Jan		2	3	Home-built sqlite3 gives assertion failed on file where.c, line 383
1063	code	active	2005 Jan	anonymous		2005 Jan		1	3	Lemon bug: Strings in rule code should not be interpreted
1066	new	fixed	2005 Jan	anonymous	Parser	2005 Jan		4	1	SQLite 3.0.8 does not allow the '$' on Column Names.
1068	code	fixed	2005 Jan	anonymous		2005 Jan	drh	1	1	Lemon can emit 2 sets of destructor code in certain cases
1069	code	fixed	2005 Jan	anonymous	BTree	2005 Jan		3	3	Array bounds read error in Purify
1072	code	defer	2005 Jan	anonymous		2005 Jan		3	3	Non-standard behaviour for date/time functions in SELECT
1075	build	fixed	2005 Jan	anonymous	Unknown	2005 Sep	anonymous	3	4	Solaris 9 build needs to use gawk instead of awk
1078	code	active	2005 Jan	anonymous		2005 Jan		2	3	Lemon destructor bugs that don't affect sqlite
1079	warn	fixed	2005 Jan	anonymous	Unknown	2005 Jan		4	2	stddef.h should be included in sqliteint.h
1080	doc	fixed	2005 Jan	anonymous		2005 Feb		3	3	Incorrect name in pragma documentation
1081	doc	fixed	2005 Jan	anonymous		2005 Feb		3	3	Errors in pragma documentation
1082	doc	fixed	2005 Jan	anonymous		2005 Feb		3	3	The new EXISTS predicate is not documented
1083	code	fixed	2005 Jan	anonymous	VDBE	2005 Feb		1	1	crash in correlated sub-query
1084	code	fixed	2005 Jan	anonymous	CodeGen	2005 Feb		1	1	Reference to outer query in result set can cause an assert() failure
1094	warn	fixed	2005 Feb	anonymous		2005 Feb		3	2	possible error in function OsWrite (in os_win.c)
1095	code	fixed	2005 Feb	anonymous	Unknown	2005 Feb		1	3	Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
1099	code	fixed	2005 Feb		VDBE	2005 Feb		1	1	make test fails on bind1.1.test
1103	doc	fixed	2005 Feb	anonymous	Unknown	2005 Feb		5	4	the same word twice
1108	build	fixed	2005 Feb	anonymous	Shell	2005 Feb	danielk1977	2	2	strcasecmp should be changed to sqlite3StrICmp
1111	code	active	2005 Feb	anonymous	Unknown	2005 Jun		3	1	no such column error with a subselect as a table
1114	code	fixed	2005 Feb	anonymous		2005 Feb		1	1	Database corruption when using 'PRAGMA auto_vacuum=ON'
1115	code	fixed	2005 Feb	drh		2005 Feb		1	1	Creating unique index on non-unique column leads to corruption
1116	code	fixed	2005 Feb	drh	VDBE	2005 Feb		1	1	VACUUM results in corrupt database
1117	build	fixed	2005 Feb	anonymous	Unknown	2005 Feb	anonymous	1	1	sqlite-2.8.16.tar.gz contains VERSION '3.1.2'
1120	code	fixed	2005 Feb	anonymous	Parser	2005 Feb		2	2	lemon: off-by-two error
1121	code	fixed	2005 Feb	anonymous	Unknown	2005 Feb	anonymous	1	2	Vacuum error with column type INTEGER PRIMARY KEY AUTOINCREMENT
1122	code	fixed	2005 Feb	anonymous	Shell	2005 Feb	drh	3	2	strcasecmp in shell.c
1124	event	fixed	2005 Feb	anonymous	Shell	2005 Feb		4	4	sqlite.exe .dump & reload broken w/dependent VIEW lower in sort
1127	code	fixed	2005 Feb	anonymous	Unknown	2005 Mar		3	3	typeof() always returns "text" in unions
1133	code	fixed	2005 Feb	anonymous	Unknown	2005 Feb	drh	5	5	double full_column_name flags in pragma
1135	doc	fixed	2005 Feb	anonymous		2005 Mar		4	3	Typos in documentation for CREATE VIEW
1137	code	fixed	2005 Feb	anonymous	Unknown	2005 Feb		4	5	couldn't find procedure Tclsqlite_Init
1140	code	fixed	2005 Feb	anonymous	CodeGen	2005 Mar		1	1	selectReadsTable infinite loop
1145	doc	fixed	2005 Feb	anonymous		2005 Mar		4	4	duplicate text in FAQ
1146	build	fixed	2005 Feb	anonymous		2005 Mar		4	4	make doc failure: no target 'arch.png'
1151	code	fixed	2005 Mar	anonymous	CodeGen	2005 Mar		4	3	detach does not support database names inside square brakets
1152	code	fixed	2005 Mar	anonymous	Pager	2005 Mar		3	4	create silently fails if corresponding journal file already exists
1153	code	fixed	2005 Mar	anonymous	Unknown	2005 Mar		1	1	make test on 3.1.3 throws 11 errors
1159	code	fixed	2005 Mar	anonymous	Unknown	2005 Mar		2	1	SQLite forgets to call the busy handler
1161	build	fixed	2005 Mar	anonymous		2005 Sep		2	4	Need to use "nawk" to build under Solaris 9
1163	code	fixed	2005 Mar	drh	VDBE	2005 Mar		1	1	Database corruption possible on records with large numbers of columns.
1164	warn	fixed	2005 Mar	anonymous		2005 Mar		4	1	Compile warning about different "const" qualifiers
1165	new	fixed	2005 Mar	anonymous	Unknown	2005 Mar		3	4	On cygwin, sqlite filenames are windows, not cygwin
1166	code	fixed	2005 Mar	anonymous		2005 Mar		3	3	jounal1-1.2 test fails on Windows
1167	new	fixed	2005 Mar	anonymous		2005 Mar		4	3	test Bind-4.1 fails on Windows
1168	doc	fixed	2005 Mar	anonymous		2005 Mar		5	1	Update to the README file
1169	code	fixed	2005 Mar	anonymous	VDBE	2005 Jun		1	1	Segmentation fault when deleting range of items using view/trigger
1170	new	fixed	2005 Mar	anonymous	Unknown	2005 Mar		3	3	strfdate Should Support Strict ISO-8601 Date Format
1171	code	fixed	2005 Mar	anonymous	Pager	2005 Jun		1	1	Statement transaction rollback can incorrectly update database file.
1184	todo	fixed	2005 Mar	danielk1977	CodeGen	2008 Jul		4	3	UTF-8 and UTF-16 substr() functions are subtly different
1188	code	fixed	2005 Mar	anonymous		2005 Mar		1	3	Numbers greater than 0x7FFFFFFF are treated as signed in inequalities.
1194	code	fixed	2005 Mar	anonymous	Pager	2005 Mar		4	4	64K page size does not work
1198	build	fixed	2005 Apr	anonymous	Unknown	2005 Apr		1	1	3.2.1 build fails test and fulltest
1202	code	fixed	2005 Apr	anonymous		2005 Aug		2	2	Library does not support "0x" prefix in cmd context string
1206	code	fixed	2005 Apr	anonymous		2005 Sep	drh	5	4	failed to work when running in non-ASCII directory
1210	code	fixed	2005 Apr	anonymous	Unknown	2005 Jun		2	2	Generating SQLITE_INTERNAL error
1211	code	fixed	2005 Apr	anonymous		2005 Jun	anonymous	2	2	too stupid boolean test
1212	code	fixed	2005 Apr	drh	VDBE	2005 Apr		1	1	Large integers stored incorrectly.
1216	new	fixed	2005 Apr	anonymous		2005 Aug		4	3	strftime doesn't return milliseconds
1217	code	fixed	2005 Apr	anonymous	Parser	2009 Jan		3	3	NATURAL JOIN results in incorrect "ambiguous column name" error
1219	code	fixed	2005 Apr	anonymous	VDBE	2005 Jun	anonymous	2	2	dereferencing null ptr in vdbeUnbind()
1224	new	fixed	2005 Apr	anonymous		2005 May		5	4	config.h is not required for build.
1229	code	fixed	2005 Apr	anonymous	Unknown	2005 Apr		3	3	SQL code with trigger produces SegFault/BusError
1232	code	fixed	2005 May	anonymous	BTree	2005 May	drh	1	1	unaligned memory access on sparc64 with -r1.257 of btree.c
1234	code	fixed	2005 May	anonymous	BTree	2005 May		1	1	solaris9 alignment problems
1236	todo	fixed	2005 May	anonymous	Unknown	2005 Sep	drh	3	3	Linux binary on download page not statically linked
1239	doc	fixed	2005 May	anonymous		2005 Sep		4	3	Documentation typos in different.tcl & docs.tcl
1243	code	fixed	2005 May	anonymous	TclLib	2005 Sep		1	1	Missing system encoding conversion when accessing files
1244	code	fixed	2005 May	anonymous		2005 May		1	1	Test misc2-.10.1 causes seg fault
1247	new	fixed	2005 May	anonymous		2005 May		4	3	Default file permissions are too restrictive
1251	code	fixed	2005 May	anonymous	Parser	2005 May		3	2	Code fixes for memory leaks and invalid memory accesses
1252	code	fixed	2005 May	anonymous	Unknown	2005 May		3	3	SQL error: unknown opcode 0
1253	new	fixed	2005 May	anonymous	Pager	2005 May		5	3	Put commonly used items closer to the start of a struct
1256	new	fixed	2005 May	anonymous		2005 May		3	3	Allow using non-default calling convention
1257	new	fixed	2005 May	anonymous	VDBE	2005 May		5	3	3.5% speed improvement
1258	new	fixed	2005 May	anonymous	VDBE	2005 May		5	3	20% sqlite speedup? Can it be true?
1259	code	fixed	2005 May	anonymous	VDBE	2005 May		3	2	Small memory leak
1260	code	fixed	2005 May	anonymous		2005 May		4	4	value of synchronous changes back to full if you change the cache_size
1262	new	active	2005 May	anonymous	VDBE	2005 May		5	3	5-15% performance increase for slow joins
1263	code	fixed	2005 May	anonymous		2005 Jun		1	3	full_column_names pragma not always honoured
1270	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun		4	2	Creating views using prepared statements with parameters
1271	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun	anonymous	1	3	Timeout not handled correctly, random behaviour on different platforms
1272	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun		1	3	File locks are broken in some multi-threaded environments
1274	code	fixed	2005 Jun	anonymous		2005 Jun		2	2	sqliteOsFullPathname() segfaults due to NULL from getcwd()
1275	new	fixed	2005 Jun	anonymous		2005 Jun		4	3	Method to get sqlite3* from sqlite3_stmt
1277	doc	fixed	2005 Jun	anonymous	Unknown	2005 Jun	anonymous	3	3	"PRAGMA encoding" cannot be set after "PRAGMA synchronous"
1279	doc	fixed	2005 Jun	anonymous		2005 Jun		4	4	Missing info about fourth arg to sqlite3_bind_* in API Reference
1282	doc	fixed	2005 Jun	anonymous		2005 Jun		3	1	Typo in changes.tcl
1283	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun		2	2	Database corrupts when creating table with autoincrement column
1284	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun		2	3	Fail to compile at main.c:301 (old signature of function used)
1285	code	fixed	2005 Jun	anonymous	Pager	2005 Jun		1	3	deadlock in multithreaded application
1287	code	fixed	2005 Jun	anonymous	TclLib	2005 Jun		1	1	problem comparing with empty string inside tcl variable
1289	doc	fixed	2005 Jun	anonymous	Unknown	2005 Jun		3	3	make doc misses a file named arch2.gif
1291	build	fixed	2005 Jun	anonymous		2005 Jun		2	3	makefile fix for Borland dll import lib under windows
1292	code	fixed	2005 Jun	anonymous	Unknown	2005 Jul		4	4	'make test' fails on OS X, includes fix
1297	code	fixed	2005 Jun	anonymous	Unknown	2005 Jun		1	3	sqlite 3.2.2 reproducible access violation
1301	code	fixed	2005 Jun	anonymous	CodeGen	2005 Jun		2	3	CREATE UNIQUE INDEX fails with existing rows with NULL as compound key
1303	doc	fixed	2005 Jun	anonymous	Unknown	2005 Jun		4	4	Broken `glob' link in documentation
1304	new	fixed	2005 Jun	anonymous	TclLib	2005 Jun		3	4	use Tcl_EvalObjv when calling user defined functions in Tcl library
1306	doc	fixed	2005 Jun	anonymous		2005 Jun		4	4	DROP TABLE doc error
1311	code	fixed	2005 Jun	anonymous		2005 Aug		1	2	misuse-5.1 crashing on Mac OS X
1314	code	fixed	2005 Jun	anonymous	Unknown	2005 Jul		1	2	Can't compile Sqlite 3.2.2 from .zip sources
1315	code	fixed	2005 Jul	anonymous	Unknown	2005 Jul		1	1	busy callback called in 2 distinct places when starting a transaction
1316	code	fixed	2005 Jul	anonymous	Unknown	2005 Jul		4	4	Output from ROUND function is inconsistent cross-platform
1320	doc	fixed	2005 Jul	anonymous	Unknown	2005 Jul	drh	5	5	comment says sqlite3_create_aggregate which does not exist any more
1321	doc	fixed	2005 Jul	anonymous	Unknown	2005 Sep	drh	5	5	strange comment
1331	event	fixed	2005 Jul	anonymous	Pager	2005 Sep	anonymous	1	1	unicode filename for database
1334	doc	fixed	2005 Jul	anonymous	Unknown	2005 Jul		1	1	problem MAX and sqlite3_column_text when no data is returned
1337	new	fixed	2005 Jul	anonymous		2005 Aug		3	4	compability problems with column names starting with digits
1338	code	fixed	2005 Jul	anonymous	Parser	2005 Jul		2	2	assert triggers inside sqlite3AuthRead()
1340	code	fixed	2005 Jul	anonymous	Unknown	2005 Aug	anonymous	1	1	round(1e300) dumps core
1345	code	fixed	2005 Jul	anonymous	VDBE	2005 Aug		4	4	Small cosmetic defect in code
1346	code	fixed	2005 Aug	anonymous	BTree	2005 Aug		2	2	assertion fires when query string goes beyond 865 characters
1347	code	fixed	2005 Aug	anonymous	VDBE	2005 Aug	anonymous	1	1	Concatinate operation with BLOB causes assertion fail
1348	code	fixed	2005 Aug	anonymous	Shell	2005 Aug		3	1	Ticket #939 is not really fixed
1353	new	fixed	2005 Aug	anonymous		2005 Aug		5	4	Enhance error message when disk is full
1354	code	fixed	2005 Aug	anonymous	VDBE	2005 Aug	anonymous	3	2	Misusing sqlite3Error in vdbeapi.c
1356	code	fixed	2005 Aug	anonymous	Parser	2005 Aug		4	4	Memory leak on query?
1357	code	fixed	2005 Aug	anonymous		2005 Aug		1	1	MemLeak by CreateTable if exists
1358	code	fixed	2005 Aug	anonymous	Unknown	2005 Aug		1	1	ORDER By Does not work
1359	code	fixed	2005 Aug	anonymous	Unknown	2005 Aug		2	2	Segfault when using primary key plus another index.
1362	code	fixed	2005 Aug	drh	VDBE	2005 Aug		1	1	Dump and restore converts floating-point values to integers
1363	todo	fixed	2005 Aug	anonymous		2005 Aug		5	5	More symbols declared as static
1368	new	fixed	2005 Aug	anonymous	VDBE	2005 Sep		2	1	Aggregate queries against large tables use excessive amounts of memory
1370	code	fixed	2005 Aug	anonymous		2005 Aug		3	4	Problem opening non-sqlite files smaller than spageSize.
1371	new	fixed	2005 Aug	anonymous	Parser	2005 Aug		1	1	This format not accepted for assigning a double: 12.e-3
1372	build	fixed	2005 Aug	anonymous		2005 Sep		4	3	Use of incompatible function (gsub) in mkopcode[ch].awk on Solaris
1373	code	fixed	2005 Aug	anonymous		2005 Aug		1	1	Assertion fail with empty BLOB
1374	doc	fixed	2005 Aug	anonymous	Unknown	2005 Aug	drh	4	4	Documentation error for lang_createview.html
1375	code	fixed	2005 Aug	anonymous		2005 Aug		4	3	Multi-database transactions perform undesirable fsyncs
1376	code	fixed	2005 Aug	anonymous	VDBE	2005 Aug		1	3	Lengthy WHERE clause with many BETWEEN clauses seg fault
1378	build	fixed	2005 Aug	anonymous		2005 Aug		3	3	Compiling with "./configure --enable-threadsafe; make" is broken
1380	code	fixed	2005 Aug	anonymous		2005 Aug		1	1	Crash with IN(correlated subquery)
1384	code	fixed	2005 Aug	anonymous		2005 Aug		3	3	misuse-5.1 test fails because of memory corruption
1390	build	fixed	2005 Aug	anonymous		2005 Aug		4	3	Remove GNU-make-ism from Makefile.in
1391	code	fixed	2005 Aug	anonymous		2005 Aug		1	1	3.2.4 linux static binary shipped is not really static
1392	doc	fixed	2005 Aug	anonymous		2005 Aug		4	1	Incorrect syntax documented for 'AUTOINCREMENT' keyword
1394	code	fixed	2005 Aug	anonymous	VDBE	2005 Aug		3	3	Uninitialized variable in isSortingIndex()
1395	code	fixed	2005 Aug	anonymous	Shell	2005 Aug	drh	3	4	SQLite3 segfaults with -DSQLITE_OMIT_MEMORYDB and no filename
1396	code	fixed	2005 Aug	anonymous		2005 Sep		3	3	File paths with international characters are don't work on Windows
1398	warn	fixed	2005 Aug	anonymous	Parser	2005 Aug		5	5	Low priority warning to to resolve
1399	new	fixed	2005 Aug	anonymous		2006 Jan		4	4	Please add "DROP IF EXISTS" support
1405	build	fixed	2005 Sep	anonymous	Unknown	2005 Sep		4	4	awk build problem on Solaris 10
1407	code	fixed	2005 Sep	anonymous		2005 Sep		3	3	WinAPI, CreateFileA is not utf-8 compatible.
1409	code	fixed	2005 Sep	anonymous		2005 Sep		1	1	pragma empty_Result_callbacks and ANALYZE crashes
1412	code	fixed	2005 Sep	anonymous		2005 Sep		3	2	C++Builder 6 compilation
1413	code	fixed	2005 Sep	anonymous		2005 Sep		3	3	SUM returns unexpected results for columns with NULL values
1414	code	fixed	2005 Sep	anonymous		2005 Sep		2	3	Complex query that used to work with sqlite 3.2.2 doesn't with 3.2.5
1418	code	fixed	2005 Sep	anonymous	Parser	2005 Sep		3	3	assert() when creating a table with duplicate column names
1419	code	fixed	2005 Sep	anonymous	Shell	2005 Sep	drh	1	1	Shell no longer dumps sqlite_sequence
1420	code	fixed	2005 Sep	anonymous	Unknown	2005 Sep	drh	1	1	Problems with COUNT DISTINCT
1425	doc	fixed	2005 Sep	anonymous	Unknown	2005 Sep	drh	5	5	NDEBUG
1429	code	fixed	2005 Sep	anonymous		2005 Sep	drh	5	5	Visual C++ 6.0 Error Report
1431	doc	active	2005 Sep	anonymous		2008 Jun	mihailim	1	1	Please can FAQ 7 reference http://www.sqlite.org/lockingv3.html
1432	code	fixed	2005 Sep	drh		2005 Sep		1	1	Database corruption following VACUUM failure
1433	code	fixed	2005 Sep	anonymous		2005 Sep		1	1	3.2.5 behaves differently than 3.2.2 when an index is created
1435	code	fixed	2005 Sep	anonymous		2005 Sep		1	1	query optimizer results in rows being returned in the wrong order
1437	code	fixed	2005 Sep	anonymous	VDBE	2005 Sep	drh	1	1	bulid failed on windows
1440	code	fixed	2005 Sep	anonymous		2005 Sep		1	1	2 compilation errors on VC6 (windows)
1444	code	fixed	2005 Sep	anonymous	Unknown	2005 Sep	drh	1	1	select union all and order by problems
1449	code	fixed	2005 Sep	anonymous		2005 Sep		1	1	Failed assert at select.c, line 1733: p->pRightmost==p
1453	code	fixed	2005 Sep	anonymous	Unknown	2005 Sep		1	4	make test fails in conflict tests on mac os x
1467	build	fixed	2005 Oct	anonymous		2006 Jan		1	1	3.2.7 on Solaris still chokes on fdatasync
1471	todo	fixed	2005 Oct	anonymous		2005 Oct	drh	5	4	Add link to home page to SQLite logo
1473	code	fixed	2005 Oct	drh	CodeGen	2005 Oct	drh	1	1	Incorrect results when a subquery contains UNION ALL
1474	code	fixed	2005 Oct	anonymous		2006 Apr		2	3	SQLITE3.DLL fails to load if address 0x60900000 occupied
1478	code	fixed	2005 Oct	anonymous	Unknown	2005 Nov	drh	3	2	Large file compile error with table.c
1479	code	fixed	2005 Oct	anonymous	Unknown	2006 Jan		1	3	SQLITE_ALTER_TABLE not authorized for "alter table ... add ...;"
1486	code	fixed	2005 Oct	anonymous		2006 Jan		4	3	schema which is stored in sqlite_master was not complete
1493	code	active	2005 Oct	anonymous	Parser	2005 Oct		3	3	lemon: pathsearch uses wrong directory separator under Win32
1497	code	fixed	2005 Oct	anonymous	Parser	2005 Oct		4	1	SQL with unclosed string is accepted
1501	code	fixed	2005 Oct	anonymous		2005 Nov		1	3	Access violation at address 00001002 error.
1512	code	fixed	2005 Nov	anonymous	Unknown	2005 Nov	drh	3	3	VACUUM is a no-op on empty databases
1513	code	fixed	2005 Nov	anonymous	Unknown	2005 Nov	drh	1	1	last 3.2.7 cvs checkout doesn't compile under ms vc++
1514	code	fixed	2005 Nov	anonymous	Unknown	2005 Nov		4	3	Strange single table query with aggregate and group by causes segfault
1524	code	fixed	2005 Nov	anonymous	Pager	2006 Jan		2	3	Crash when using pragma auto_vacuum with :memory: database
1527	code	defer	2005 Nov	anonymous		2005 Nov		1	1	DROP TABLE returns "database disk image is malformed" error
1533	code	fixed	2005 Nov	anonymous		2006 Mar		1	1	file os_win.c, function utf8ToUnicode and unicodeToUtf8 BUG
1536	code	fixed	2005 Nov	anonymous	Unknown	2005 Nov		2	1	insert ... select changes format of columns
1537	code	fixed	2005 Nov	anonymous	BTree	2005 Nov		2	1	Left Join broken (wrong results)
1544	code	fixed	2005 Nov	anonymous	Unknown	2005 Nov	drh	1	2	last CVS checkout doesn't compile under cygwin or msvc
1554	code	fixed	2005 Dec	anonymous	Parser	2006 Jan		3	3	sqlite3_prepare ignores nBytes parameter
1567	code	fixed	2005 Dec	drh	Pager	2005 Dec		1	1	Database corruption following statement rollback
1569	code	fixed	2005 Dec	anonymous		2005 Dec	drh	1	1	tarball of sqlite 2.8.17 is empty
1570	code	fixed	2005 Dec	anonymous	Unknown	2006 Mar	drh	3	3	pragma table_info() incorrect result for columns with NONE affinity
1572	code	fixed	2005 Dec	anonymous	Parser	2006 Jan		2	1	Null Mallocation
1575	code	fixed	2005 Dec	anonymous	Shell	2005 Dec		4	3	resolve_backslashes in shell.c is broken
1578	doc	fixed	2005 Dec	anonymous	Unknown	2006 Mar		5	4	Typo on http://www.sqlite.org/version3.html page
1583	code	fixed	2006 Jan	anonymous	CodeGen	2006 Mar		2	4	explain query plan missing length
1584	code	fixed	2006 Jan	anonymous	Unknown	2006 Jan		1	5	Solaris 8: bus error when /dev/urandom is not readable
1585	code	fixed	2006 Jan	anonymous		2006 Jan		1	1	Global mutex not released if pthread_key_create fails.
1586	new	fixed	2006 Jan	anonymous		2006 Jan		2	3	ORDER BY with LIMIT clause is sub-optimal in speed and memory usage
1587	code	fixed	2006 Jan	anonymous	Unknown	2006 Jan		3	3	Timezone is parsed reversely
1589	doc	fixed	2006 Jan	anonymous		2006 Jan		4	4	Has the SQLite website's "Append Remarks" behavior changed?
1590	code	fixed	2006 Jan	anonymous		2006 Jan	drh	4	2	select.c uninitialized variable
1593	code	fixed	2006 Jan	anonymous	BTree	2006 Jan	drh	1	2	error compiling with #define SQLITE_OMIT_AUTOVACUUM
1596	doc	fixed	2006 Jan	anonymous		2006 Jan		5	5	obsolete MakeIdxKey opcode references in vdbe.c and documentation
1598	code	review	2006 Jan	anonymous		2006 Jan		3	2	Incorrect case-insensitive comparison of non-latin UTF-8 characters
1600	new	fixed	2006 Jan	anonymous		2006 Jan		5	4	WinCE locking implementation
1601	code	fixed	2006 Jan	anonymous	Unknown	2006 Jan	anonymous	1	2	3.3.0 multithreaded apps memory leak
1603	code	fixed	2006 Jan	anonymous		2006 Jan		5	5	better customization of macro N_GUARD in utils.c
1604	build	fixed	2006 Jan	anonymous		2006 Jan		4	3	opcode generation fails on solaris 8 due to ancient awk
1605	code	fixed	2006 Jan	drh	VDBE	2006 Jan		1	1	Assertion fault when trying to LIKE a BLOB in UTF-16 mode.
1607	code	fixed	2006 Jan	anonymous		2006 Jan		1	1	sqlite3_set_authorizer causes subsequent access violation
1608	doc	fixed	2006 Jan	anonymous		2006 Jan		4	3	Yet undocumented: create table IF NOT EXISTS
1611	code	fixed	2006 Jan	anonymous		2006 Jan		4	3	sqlite3_close on wrong thread returns SQLITE_OK but leaks filehandle
1614	code	fixed	2006 Jan	anonymous		2006 Jan		2	2	sqlitedll-3_3_1.zip contain no DLL
1615	warn	fixed	2006 Jan	anonymous		2006 Jan	drh	2	2	Metrowerks CodeWarrior compiler errors when build sqlite
1616	warn	fixed	2006 Jan	anonymous		2006 Jan	drh	2	2	RVCT compiler warnings when making sqlite build
1619	code	fixed	2006 Jan	anonymous		2006 Jan	drh	1	1	Can't compile sqlite with SQLITE_ENABLE_MEMORY_MANAGEMENT
1625	warn	fixed	2006 Jan	anonymous	Unknown	2006 Jan		3	3	Compiler errors in building Sqlite3 from source
1628	code	fixed	2006 Jan	anonymous		2006 Jan		4	4	pragma integrity_check returns "OK" on a corrupt database
1629	code	fixed	2006 Jan	anonymous		2006 Jan	drh	1	1	The fix for #1623 causes an assert in sqlite3MallocAllow()
1630	code	fixed	2006 Jan	anonymous		2006 Jan	drh	1	1	The TLS data is allocated/deallocated multiple times
1632	code	fixed	2006 Jan	anonymous	VDBE	2006 Jan		3	3	sqlite3_result_error doesn't work in user defined aggregate function
1634	code	fixed	2006 Jan	anonymous	CodeGen	2006 Jan		3	3	LIMIT in nested select not working properly
1644	code	fixed	2006 Jan	ghaering	VDBE	2006 Jan		3	3	CREATE TEMP/DROP TEMP do not modify schema cookie
1645	code	fixed	2006 Jan	anonymous	Shell	2006 Jan		2	3	constraint using "in"
1646	doc	fixed	2006 Jan	anonymous		2006 Jan		3	4	API doc clarification for bind_text: utf8 bytes or chars?
1649	doc	fixed	2006 Jan	anonymous		2006 Jan	drh	4	1	changes.tcl incorrect in latest checkin
1650	code	fixed	2006 Jan	anonymous	Unknown	2006 Jan		3	4	Third parm of sqlite3_prepare is ignored.
1651	code	fixed	2006 Jan	anonymous	Shell	2006 Jan		1	1	.import doesn't work in 3.3.3
1652	code	fixed	2006 Jan	anonymous	CodeGen	2006 Feb		3	4	sorting ASC vs DESC changes number of returned rows
1654	code	fixed	2006 Feb	anonymous	VDBE	2006 Feb		1	1	crash when executing query on Intel builds
1657	code	fixed	2006 Feb	anonymous		2006 Feb		1	1	Disk I/O error when used on memory filesystem
1658	code	fixed	2006 Feb	anonymous		2006 Feb		3	4	SQLITE3.EXE program crash
1660	code	fixed	2006 Feb	anonymous		2006 Feb	danielk1977	1	1	OS memory allocation functions may round-up the requested size
1661	code	fixed	2006 Feb	anonymous	Unknown	2006 Feb		3	4	The following never returns in v2.8.16 : select 1 limit 1 offset 1;
1662	code	fixed	2006 Feb	anonymous	Unknown	2006 Mar	drh	1	3	Wrong CAST result rsp. missing string trimming on number conversions
1664	code	fixed	2006 Feb	anonymous		2006 Feb		1	1	sum() returns wrong result
1665	code	fixed	2006 Feb	anonymous	Unknown	2006 Feb	drh	1	1	Memory corruption using ALTER TABLE
1666	code	fixed	2006 Feb	anonymous		2006 Feb		3	3	sqlite3_analyzer has 32-bit overflow errors
1669	code	fixed	2006 Feb	anonymous		2006 Feb		1	3	sum() still returns wrong result
1670	code	fixed	2006 Feb	anonymous		2006 Feb		1	3	sum() still returns wrong result - the sequel
1671	new	fixed	2006 Feb	anonymous	Parser	2006 Feb	drh	5	4	Support '@' as a named parameter prefix
1672	code	fixed	2006 Feb	anonymous	Unknown	2006 Feb		1	1	Deadlock when multithreading on unix
1674	code	fixed	2006 Feb	anonymous		2006 Feb		3	3	sum(-9223372036854775805) returns integer -9223372036854775808
1680	build	fixed	2006 Feb	anonymous		2006 Mar		4	3	configure --enable-debug doesn't enable verbose explain
1682	code	fixed	2006 Feb	anonymous	Unknown	2006 Feb		4	4	accessing temp database causes crash
1684	code	fixed	2006 Feb	anonymous		2006 Mar		2	2	SQLITE_MIN_SLEEP_MS not defined in main.c
1685	code	defer	2006 Feb	anonymous		2006 Feb		1	1	Stall on multithread application.
1688	code	fixed	2006 Feb	anonymous	VDBE	2006 Mar	danielk1977	3	2	Incorrect column names when doing select on views
1690	code	fixed	2006 Feb	anonymous		2006 Feb		5	4	utf8ToUnicode allocates too large buffer
1695	code	fixed	2006 Feb	anonymous		2006 Mar	anonymous	1	1	Database file not loading ...
1696	build	fixed	2006 Feb	anonymous	Unknown	2006 Jun		4	4	obsolete "sort +4" and friends
1697	code	fixed	2006 Mar	drh	CodeGen	2006 Mar	drh	1	1	Segfault while executing SELECT
1699	code	fixed	2006 Mar	anonymous	Unknown	2006 Mar		1	2	round(X) does not work correctly when nested in some functions
1702	new	fixed	2006 Mar	anonymous		2009 Feb		5	4	feature request: API to write in-memory DB to file.
1709	code	fixed	2006 Mar	anonymous		2006 Mar		1	1	sqlite3_column_name not apply column alias for views
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)
1713	code	fixed	2006 Mar	anonymous	Unknown	2006 Mar		2	2	Cannot open datafiles in folders with special characters
1716	doc	fixed	2006 Mar	anonymous		2006 Mar		5	4	sqlite3_db_handle() has wrong documented signature
1717	code	fixed	2006 Mar	drh	CodeGen	2006 Mar	drh	1	1	CHECK constraints always use ABORT conflict resolution
1721	code	fixed	2006 Mar	anonymous	Parser	2006 Mar		3	3	wrong column names in a compound select when used as a subquery
1726	code	fixed	2006 Mar	anonymous	Unknown	2006 Apr	drh	1	1	wrong reported datatype when using group-by
1727	code	fixed	2006 Mar	drh		2006 Mar		1	1	Assertion fault on autovacuum :memory: database
1728	code	fixed	2006 Mar	drh	VDBE	2006 Mar		1	1	Integrity_check fails after dropping tables in autovacuumed database
1731	doc	fixed	2006 Mar	anonymous		2008 Jun		5	5	Typo in select4.test
1737	code	fixed	2006 Mar	anonymous	Unknown	2006 Mar		1	1	Duplicate name object created
1744	doc	fixed	2006 Mar	anonymous	Parser	2006 Apr	drh	1	1	Missing documentation for SQLITE_ALTER_TABLE, SQLITE_REINDEX...
1745	doc	fixed	2006 Mar	anonymous	Parser	2006 Apr	drh	3	3	Missing "REVERSE" colation sequence
1746	code	fixed	2006 Mar	anonymous	Parser	2006 Apr		2	1	large number of trigger actions in trigger creation give syntax error
1749	doc	fixed	2006 Apr	anonymous		2006 Apr		5	4	typo on FAQ web page
1750	doc	fixed	2006 Apr	anonymous		2006 Apr		5	4	typo on API reference web page
1755	code	fixed	2006 Apr	anonymous	Unknown	2006 Apr	drh	3	3	datatype incorrect when using group-by
1756	code	fixed	2006 Apr	anonymous		2006 Apr		1	1	Is use of function atof in file func.c really intended?
1763	code	fixed	2006 Apr	anonymous		2006 Apr		3	4	declaration after executable statement
1768	code	fixed	2006 Apr	anonymous		2006 Apr	drh	1	1	ORDER BY behaving differently in SQLite2 and 3
1771	code	fixed	2006 Apr	anonymous	Shell	2006 Jun		5	4	sqlite3 -version should return 0
1773	code	fixed	2006 Apr	anonymous		2006 Apr		2	3	heap corruption reading a corrupted database file
1784	code	fixed	2006 Apr	anonymous		2006 Apr		3	4	LIMIT 0 in sub-query with ORDER BY in outer query causes seg fault
1792	doc	fixed	2006 May	anonymous		2006 May		1	1	"commercial" is misspelled on the SQLite license page
1794	code	fixed	2006 May	anonymous	Parser	2006 May		3	2	Sqlite parser produces incorrect error message for missing commas
1797	code	active	2006 May	anonymous	TclLib	2006 May	drh	1	1	COPY command doesn't work in tclsqlite 3.3.5
1798	doc	fixed	2006 May	anonymous		2008 Jun	mihailim	5	4	preprocessed is misspelled on download page
1803	code	fixed	2006 May	anonymous	Unknown	2006 Jun		3	3	sqlite3WinOpenReadWrite() passes wrong share parms to CreateFile()
1805	code	fixed	2006 May	anonymous	Shell	2006 May		3	4	missing out-of-memory check at src/shell.c:1485
1806	code	fixed	2006 May	anonymous	TclLib	2006 May		3	4	Missing out-of-memory check at db/sqlite3/src/tclsqlite.c:1442
1807	code	fixed	2006 May	drh		2006 May	drh	1	1	Assertion fault on a particular query.
1809	code	active	2006 May	anonymous	CodeGen	2009 Jan		1	3	Huge slowdown/increased memory use when using GROUP BY on big dataset
1817	new	fixed	2006 May	anonymous		2008 Aug		1	2	Patch to enable SQLite again on OS/2
1821	code	fixed	2006 May	anonymous		2006 May		2	3	Optimizer causes IN operator to fail when comparing strings & numbers
1824	code	fixed	2006 May	drh		2006 May	drh	1	1	UTF-16 encoding flag not honored when using shared cache
1825	code	fixed	2006 May	anonymous		2006 May		1	1	Crash on ATTACH DATABASE
1827	new	fixed	2006 May	anonymous	TclLib	2006 May		4	4	Tcl-library: SQLITE_MISUSE from progress callback
1830	code	fixed	2006 Jun	anonymous	Unknown	2006 Jun		2	1	Problem with INNER JOIN following LEFT JOIN to table with UNIQUE INDEX
1831	code	fixed	2006 Jun	anonymous	Unknown	2006 Jun	anonymous	2	1	Crash when using a certain type of index
1836	new	fixed	2006 Jun	pweilbacher	Shell	2006 Jun		4	3	Further OS/2 updates
1839	build	fixed	2006 Jun	anonymous		2006 Jun		1	4	attempting to compile loadext.c fails
1845	code	fixed	2006 Jun	anonymous	Unknown	2006 Jun		3	3	soundex(null) causes access violation
1847	new	fixed	2006 Jun	anonymous		2006 Jun		4	4	Unhelpful error text
1848	code	fixed	2006 Jun	anonymous	Parser	2006 Jun	drh	1	1	C++ ism on generated parse.c from latest CVS head
1849	code	fixed	2006 Jun	anonymous	VDBE	2006 Jun		1	3	EXPLAIN segfault on linux (3.3.6 and 3.3.5 and 3.3.2)
1857	code	tested	2006 Jun	anonymous		2009 Oct		3	4	Can't use ISO 8601 dates with time zone designator 'Z'
1863	secure	fixed	2006 Jun	anonymous	Unknown	2006 Jun	drh	2	3	authorizing load_extension()
1873	code	fixed	2006 Jun	drh		2006 Jun		1	1	DETACH while query is running results in crash
1875	code	fixed	2006 Jun	anonymous		2006 Jun		1	3	EXPLAIN crashes in strlen
1877	code	fixed	2006 Jun	anonymous	VDBE	2006 Jun		2	2	problems with compiling with -DSQLITE_OMIT_VIRTUALTABLE
1879	doc	fixed	2006 Jul	anonymous		2006 Jul		4	4	Perl is spelt Pearl on the http://www.sqlite.org page
1886	code	fixed	2006 Jul	drh		2006 Jul		1	1	Memory leak when malloc fails
1887	code	fixed	2006 Jul	anonymous	TclLib	2006 Jul		1	1	Bad result on empty [db onecolumn]
1889	new	fixed	2006 Jul	drh		2006 Jul		1	1	Make sqlite3_interrupt() accessible from the TCL interface
1892	code	fixed	2006 Jul	anonymous	Parser	2006 Jul		4	5	Degenerate code action causes parser crash.
1897	new	fixed	2006 Jul	anonymous	Unknown	2009 Oct		1	3	Should be able to call sqlite3_interrupt from a different thread
1899	new	fixed	2006 Jul	anonymous		2006 Sep	drh	5	4	Is it possible add IF NOT EXISTS Create View and Create Trigger
1906	new	fixed	2006 Aug	anonymous	Unknown	2008 Mar		1	2	date.c line 417 uses non-thread safe localtime() call
1911	code	fixed	2006 Aug	anonymous		2006 Aug		2	3	crash if too many order by expressions
1912	code	fixed	2006 Aug	anonymous	Parser	2006 Aug		4	4	letters following numeric digits parsing error
1913	build	fixed	2006 Aug	anonymous	Unknown	2006 Aug		4	3	Extension exports should be added to sqlite3.def in Windows source
1914	code	fixed	2006 Aug	anonymous		2006 Aug		4	4	btree2.test - invalid command name "btree_cursor_info"
1915	code	fixed	2006 Aug	anonymous		2006 Aug		4	4	vtab2.test: ./testfixture: can't read "tcl_pkgPath": no such variable
1916	code	fixed	2006 Aug	anonymous	Unknown	2006 Aug	drh	4	2	#include <sqlite3.h> in sqlite3ext.h should be #include "sqlite3.h"
1917	code	fixed	2006 Aug	anonymous	VDBE	2006 Aug		3	3	assertion "rc==SQLITE_OK" failed: file "./src/vdbeaux.c", line 1148
1918	event	fixed	2006 Aug	anonymous	VDBE	2006 Aug		4	4	"make test" results in many new false regressions with default build
1919	code	fixed	2006 Aug	anonymous	Unknown	2006 Aug		3	3	PRAGMA table_info meaningless for cols with DEFAULT CURRENT_TIMESTAMP
1920	code	fixed	2006 Aug	anonymous	VDBE	2006 Aug		4	4	vdbe.c: assert( i>=0 && i<=p->nCursor );
1923	doc	fixed	2006 Aug	anonymous		2006 Aug		4	4	INSERT syntax documentation bug
1925	code	fixed	2006 Aug	anonymous	Unknown	2006 Aug		3	4	soundex() function not compatible with Knuth (and PHP/Java/TCL impl.)
1926	new	fixed	2006 Aug	anonymous	Shell	2006 Aug		3	4	sqlite3.exe cannot find home dir on Windows
1927	doc	fixed	2006 Aug	anonymous	Shell	2006 Aug		4	4	[doc] sqlite3.exe allows "/" as cmd terminator, not "\"
1937	new	fixed	2006 Aug	anonymous	Unknown	2006 Aug	drh	4	4	Tilda substitution not done on db file names.
1943	event	tested	2006 Aug	anonymous	Unknown	2006 Aug		3	2	sqlite3_malloc() not exported from sqlite3.dll
1951	build	fixed	2006 Sep	dougcurrie		2006 Sep		3	2	symbols missing from sqlite3.def
1955	code	fixed	2006 Sep	anonymous		2006 Sep		3	2	[3381] breaks MinGW ./configure && make sqlite3.dll
1957	code	fixed	2006 Sep	anonymous		2006 Sep		4	4	Incorrect test messages: not compiled with -DSQLITE_DEBUG
1964	code	fixed	2006 Sep	anonymous	Unknown	2006 Sep	anonymous	3	3	datetime function broken
1976	code	fixed	2006 Sep	anonymous		2006 Sep		4	3	wrong call to set error in vacuum.c
1977	code	fixed	2006 Sep	anonymous		2006 Sep		2	1	FTS1: Access violation creating FTS table with no column parameter
1978	event	fixed	2006 Sep	anonymous		2006 Sep		1	1	Are e-mail addresses from check-in [3417] real ones ?
1979	doc	fixed	2006 Sep	anonymous		2006 Sep		4	4	Problem with full text search
1981	code	fixed	2006 Sep	anonymous		2006 Sep		1	1	fts1.c uses strcasecmp instead of sqlite3StrICmp from utils.c
1982	code	fixed	2006 Sep	anonymous		2006 Sep		1	1	FTS1: Database error after deleting and reinserting into FTS table
1986	doc	fixed	2006 Sep	anonymous		2006 Sep		5	4	typo in documentation
1987	code	fixed	2006 Sep	drh		2006 Sep	drh	1	1	Malformed database results from changing encoding
1991	code	fixed	2006 Sep	anonymous	Unknown	2006 Sep	drh	3	3	strftime precision problem
2001	code	fixed	2006 Sep	anonymous	Unknown	2006 Sep		2	2	Views on altered tables are defect
2002	code	fixed	2006 Sep	anonymous	Parser	2006 Sep	drh	2	2	Memory leak in select with duplicate colum names
2008	code	fixed	2006 Oct	anonymous		2006 Oct		3	3	Linux x86_64 sqlite3utfSelfTest fails assert -O2 gcc 4.1.1 (patch)
2009	code	fixed	2006 Oct	anonymous		2006 Oct		4	3	sqlite3 shell won't issue prompts without isatty() true
2016	code	fixed	2006 Oct	anonymous		2006 Oct		1	1	Unremoved debug code in fts1_porter.c
2018	code	fixed	2006 Oct	drh		2006 Oct	drh	1	1	Name resolution problem in correlated compound subqueries.
2023	build	fixed	2006 Oct	anonymous		2006 Dec		3	3	sqlite (loadext.c) fails build in _UNICODE mode from v3.3.7
2029	code	fixed	2006 Oct	anonymous		2006 Oct		2	1	SECURITY: SQLite character encoding conversions are insecure
2030	code	fixed	2006 Oct	anonymous		2006 Oct		1	1	CSV output should convert " to "" within values
2032	code	fixed	2006 Oct	anonymous		2009 Oct		1	1	AV in btree.c running FTS2 compiled with SQLITE_OMIT_SHARED_CACHE
2036	code	fixed	2006 Oct	anonymous		2006 Oct	shess	1	1	fts2.c: AVs due to incorret memset() and sizeof() - plus fixes
2038	code	fixed	2006 Oct	anonymous		2006 Oct		3	3	CREATE TRIGGER IF NOT EXISTS fails
2044	code	fixed	2006 Oct	anonymous		2006 Oct		1	1	.dump does not dump create view or create index statements as before
2045	code	fixed	2006 Oct	anonymous		2006 Oct	drh	5	4	Enhancement request: add "bail" command to sqlite3 shell
2047	code	fixed	2006 Oct	anonymous		2006 Oct		1	1	Mozilla Patch: Correct Unicode database names in Win95...
2050	code	fixed	2006 Nov	anonymous		2006 Nov		3	3	Assert typo in sqlite/src/btree.c ?
2051	code	fixed	2006 Nov	anonymous		2008 Jun	mihailim	5	5	minor documentation bug
2055	code	fixed	2006 Nov	anonymous		2006 Nov		1	1	[patch] fix build errror (os_win.c)
2056	code	fixed	2006 Nov	anonymous		2006 Nov		2	2	unable to ".quit' or '.exit' SQLite cmdline tool
2065	code	fixed	2006 Nov	anonymous		2006 Nov		4	4	Make .dump output a few percent smaller
2067	code	fixed	2006 Nov	anonymous		2007 Dec		4	4	Bad syntax caused core dump
2069	code	fixed	2006 Nov	anonymous		2007 Jan		4	3	compilation problem with SQLITE_OMIT_SHARED_CACHE
2071	code	fixed	2006 Nov	anonymous		2006 Nov		1	1	VACUUM doesn't delete temp file on Windows since Check-in [3470]
2072	code	fixed	2006 Nov	anonymous		2006 Nov		1	1	.dump does not dump create index statements
2078	code	fixed	2006 Nov	anonymous		2006 Nov		2	1	Patch to make PRAGMA backward compatible with 3.3.7 and prior versions
2088	code	fixed	2006 Nov	anonymous		2006 Nov		1	1	Ticket management problem : type
2089	code	active	2006 Nov	anonymous		2006 Nov		3	3	Decouple sqlite_int64 from other 64bit datatypes
2093	code	active	2006 Dec	anonymous		2006 Dec		2	3	sqlite3_vtab_cursor doesn't have errMsg
2107	code	fixed	2006 Dec	anonymous		2006 Dec		4	4	lemon asserts if you're not careful with MULTITERMINALS
2109	doc	fixed	2006 Dec	anonymous		2006 Dec		3	4	Documentation incoherence
2111	code	fixed	2006 Dec	anonymous		2006 Dec		5	5	Typo
2113	code	fixed	2006 Dec	anonymous		2006 Dec		4	4	warning if SQLITE_OMIT_LOAD_EXTENSION
2114	code	fixed	2006 Dec	anonymous		2006 Dec		5	4	strdup used
2116	code	fixed	2006 Dec	anonymous		2006 Dec		3	3	INDEX never selected for ORDER BY when INTEGER PRIMARY KEY present
2117	code	fixed	2006 Dec	anonymous		2006 Dec		1	1	Bug in OP_VFilter (vdbe.c) when xFilter returns error
2118	code	fixed	2006 Dec	anonymous		2006 Dec		3	2	xFilter is optional?
2122	code	review	2006 Dec	anonymous		2006 Dec		1	3	Potential wrong string could stay in with convertUtf8Filename
2123	code	fixed	2006 Dec	anonymous		2006 Dec		5	5	error in new os layer loadable library code (windows ce version)
2127	code	active	2006 Dec	anonymous		2006 Dec		2	3	Virtual tables do not always free zErrmsg
2128	code	active	2006 Dec	anonymous		2006 Dec		4	3	virtual table code doesn't verify type of rowid (calling xUpdate)
2129	doc	fixed	2006 Dec	anonymous		2007 Jun		4	1	Typo in documentation for sqlite3_create_collation()
2135	code	fixed	2007 Jan	anonymous		2007 Mar	anonymous	4	3	missing entry sqlite3_clear_bindings in sqlite3_apis
2139	code	fixed	2007 Jan	anonymous		2007 Jan		1	1	recent pager_unlock change in CVS
2141	code	fixed	2007 Jan	drh		2007 Jan		1	1	Assertion fault on valid query
2143	doc	fixed	2007 Jan	anonymous		2007 Jan		3	3	sqlite3_column_name may return NULL
2144	doc	fixed	2007 Jan	anonymous		2007 Jan		5	3	Cmd shell: Add ".bail" to .help and to website
2145	build	fixed	2007 Jan	anonymous		2007 Jan		2	3	Error in "make install"
2147	new	fixed	2007 Jan	anonymous		2007 Jan		5	5	Add /contrib/download/ to robots.txt
2149	build	fixed	2007 Jan	pweilbacher		2007 Jan		4	3	BEXE missing for lemon in Makefile.in
2151	code	fixed	2007 Jan	anonymous		2007 Jan		3	3	attach database fails
2153	code	fixed	2007 Jan	drh		2007 Jan		1	1	Error in the strftime() function
2154	code	fixed	2007 Jan	anonymous		2007 Jan		1	2	Getting core dump with reused prepare_v2 statements
2156	code	fixed	2007 Jan	anonymous		2007 Jan		1	2	Statements re-used from preparev2 crashing on vtable errors
2159	build	fixed	2007 Jan	anonymous		2007 Jan	pweilbacher	3	4	Interrupt OpenWatcom lang. ext. and sqlite3ext.h
2160	doc	fixed	2007 Jan	anonymous		2007 Jan		4	4	documentation for busy callback wrong
2161	doc	fixed	2007 Jan	anonymous		2007 Jan		4	4	Typo in Documentation for callback to sqlite3_exec
2163	code	fixed	2007 Jan	anonymous		2007 Jan	drh	4	3	AreFileApisANSI does not exist in Windows CE
2164	code	fixed	2007 Jan	anonymous		2007 Jan		4	5	Possibly a typo in lemon.c
2166	code	fixed	2007 Jan	shess		2007 Jan	shess	2	3	fts modules corrupt data during UPDATE.
2168	doc	fixed	2007 Jan	anonymous		2007 Aug		4	1	Invalid documentation example - BLOB literal X'53514697465'
2171	code	review	2007 Jan	anonymous		2007 Jan	drh	3	3	Fix a major leakage of token minors in lemon generated parsers
2172	code	fixed	2007 Jan	anonymous		2007 Jan		5	1	crash when lemon (wireshark) is built with -DNDEBUG
2173	code	fixed	2007 Jan	anonymous		2007 Mar		4	4	Incorrect return value test for calls to fcntl()
2175	code	fixed	2007 Jan	anonymous		2007 Mar		3	3	lemon calling destructors more than once
2176	code	fixed	2007 Jan	anonymous		2007 Jan	drh	1	2	integrity check can take very long time on large corrupted db
2177	code	fixed	2007 Jan	anonymous		2007 Jan		1	3	The same query returns different answers between 3.3.7 and 3.3.9
2184	code	fixed	2007 Jan	anonymous		2007 Jan	drh	1	1	OMIT_SHARED_CACHE: missing #define in loadext.c
2189	code	fixed	2007 Jan	anonymous		2007 Jan		1	4	Incorrect results on LEFT JOINs with IS NULL condition in WHERE clause
2191	code	fixed	2007 Jan	anonymous		2007 Jan		4	3	Minor C++/C linkage compatibility issue in sqlite3.h
2192	code	fixed	2007 Jan	drh		2007 Jan		1	1	Assertion fault on a deeply nested view
2193	code	fixed	2007 Jan	anonymous		2007 Jan		4	4	incorrect prototypes in tokenize.c
2194	code	fixed	2007 Jan	anonymous		2007 Jan		4	4	possible multiple inclusion with vdbeInt.h
2195	code	fixed	2007 Jan	anonymous		2007 Feb		1	3	OS X: "database locked" when trying to use a database on DVD-ROM
2201	code	fixed	2007 Jan	anonymous		2007 Feb		1	1	copy in tclsqlite doesn't work
2208	todo	fixed	2007 Jan	anonymous		2007 Feb		1	1	SQLite CVSTrac attachment corruption?
2210	doc	fixed	2007 Feb	anonymous		2007 Feb		5	4	Typos in PRAGMA legacy_file_format;
2211	code	fixed	2007 Feb	anonymous		2007 Feb		1	3	select A., B. from A join B where A.id=B.a_id order by A.id, B.value
2214	code	active	2007 Feb	anonymous		2007 Feb		5	4	lemon generates bad error messages for %destructor
2216	code	fixed	2007 Feb	anonymous		2007 Feb		4	4	sqlite3ExprCompare() returns false for sqlite3ExprDup() result
2217	code	fixed	2007 Feb	anonymous		2007 Feb	pamg	1	2	Incorrect result after first deleting operation (PRAGMA count_changes)
2227	new	defer	2007 Feb	scouten		2007 Apr		5	4	Feature request: CHECKPOINT command
2229	code	fixed	2007 Feb	anonymous		2007 Feb		1	2	Complex triggers can blow up sqlite
2242	code	fixed	2007 Feb	anonymous		2007 Feb		2	3	sqlite3 authorizer is not reentrant
2248	code	fixed	2007 Feb	anonymous		2007 Feb		2	1	error evaluating IN statement
2249	code	fixed	2007 Feb	drh		2007 Feb	drh	1	1	OR clause optimizer confused by column affinities
2251	code	fixed	2007 Feb	anonymous		2007 Feb		1	1	sqlite3_column_type gives bad type for sum() .. group by
2252	code	fixed	2007 Feb	drh		2007 Feb	drh	1	1	New INSERT optimization bypasses CHECK constraint checks
2257	doc	fixed	2007 Feb	adixon		2007 Mar		4	4	Auto-vacuum documentation misleading
2262	code	fixed	2007 Mar	anonymous		2007 Mar	drh	2	1	Dynamic allocation of tempory storage for pages
2264	code	fixed	2007 Mar	anonymous		2007 Mar		3	1	User defined functions naming problem
2267	doc	fixed	2007 Mar	anonymous		2007 Mar	drh	2	1	copyright.html grammer needs fix
2268	code	fixed	2007 Mar	shess		2007 Mar	drh	1	4	SQLITE_OMIT_ATTACH doesn't disable sqlite_attach() function.
2270	build	fixed	2007 Mar	anonymous		2008 Mar		3	4	Build on Solaris 8 does not include other libs in .so build
2272	code	fixed	2007 Mar	anonymous		2007 Mar		5	5	btree.c doc typo
2273	code	fixed	2007 Mar	anonymous		2007 Mar		1	2	Under latest release 3.3.13 query results in crash (used to run fine)
2276	code	fixed	2007 Mar	anonymous		2007 Mar		4	3	strftime %f zero padding problem
2278	code	fixed	2007 Mar	anonymous		2007 May		1	1	sqlite does not support mixed endian between pxa27x and i386 platforms
2281	build	fixed	2007 Apr	anonymous		2007 Apr		4	4	"CFLAGS=-DSQLITE_DEFAULT_FILE_FORMAT=4" causes alter2.test to fail
2282	code	active	2007 Apr	anonymous		2007 Apr		3	4	Update on view with no matching trigger does not raise error
2284	build	fixed	2007 Apr	anonymous		2007 Apr		1	1	make test fails with - undefined external sqlite3_xferopt_count
2285	code	fixed	2007 Apr	drh		2007 Apr		1	1	Rolling back a CREATE TEMP TABLE wedges the database
2286	code	fixed	2007 Apr	drh		2007 Apr		1	1	Extra NULL value returned by a descending SELECT
2287	code	fixed	2007 Apr	anonymous		2007 Apr		1	1	make test fails on latest 3.3.14 cvs code
2289	code	fixed	2007 Apr	shess		2007 Apr	shess	1	1	fts1 and fts2 crash when deleting or replacing rows with a null field.
2290	code	fixed	2007 Apr	anonymous		2007 Apr		1	1	Using function result text as a function parameter
2291	code	fixed	2007 Apr	drh		2007 Apr		1	1	VACUUM fails when NULLs appear in a UNIQUE constraint
2295	code	fixed	2007 Apr	anonymous		2007 Apr		1	1	Subquery fails when "order by" is added
2296	code	fixed	2007 Apr	anonymous		2007 Apr		3	3	IN clause of UNION of literal SELECT statements with ORDER BY
2298	code	fixed	2007 Apr	anonymous		2007 Apr	anonymous	3	2	Sqlite 3.3.15 backs out performance changes introduced in 3.3.14
2306	code	fixed	2007 Apr	anonymous		2007 Apr		4	3	Maybe detective Boolean-expression in sqlite3Expr() ?
2307	build	fixed	2007 Apr	anonymous		2007 Apr		4	4	missing #ifndef SQLITE_OMIT_SHARED_CACHE breaks compilation
2309	code	fixed	2007 Apr	shess		2007 Apr	shess	1	1	Assert failure in fts2 MATCH of certain OR cases.
2311	code	fixed	2007 Apr	anonymous		2007 Apr		4	4	redefinition of 'ARRAYSIZE'
2314	code	fixed	2007 Apr	anonymous		2007 Apr		1	1	SQLITE_OMIT_UTF16 Can't be Defined
2318	todo	fixed	2007 Apr	anonymous		2007 Apr		5	5	http://www.sqlite.org/contrib login broken
2319	code	fixed	2007 Apr	anonymous		2007 Apr		4	4	Duplicated test identifiers
2321	code	fixed	2007 Apr	anonymous		2007 Apr		3	3	sqlite3_value_bytes moves pointer although there is no type conversion
2323	code	fixed	2007 Apr	anonymous		2007 Apr		3	3	invalid TRIM for multibytes
2324	code	fixed	2007 Apr	anonymous		2007 Apr		2	2	replace('abc', '', 'x') dumps core
2326	doc	fixed	2007 Apr	anonymous		2008 Jun	mihailim	5	2	miss one word 'list'
2334	code	fixed	2007 May	anonymous		2007 May		3	3	valgrind complains about memcpy in select.c (overlapping memory)
2335	code	fixed	2007 May	anonymous		2007 May		1	2	real value corruption on different platforms
2337	code	fixed	2007 May	anonymous		2007 May		1	1	Unusual break of functionality (vtab-related?) after check-in 3918
2339	code	fixed	2007 May	anonymous		2007 May		1	1	strange behavior for UNION
2341	code	fixed	2007 May	anonymous		2007 May		1	1	Potential buffer overflow in sqlite3_snprintf().
2343	code	fixed	2007 May	anonymous		2007 May	drh	2	3	mallo.c typo in v 1.168/check in 3925 of Makefile.in
2344	code	fixed	2007 May	anonymous		2007 Jun		2	3	Range of INTEGER not ANSI compliant
2345	code	fixed	2007 May	anonymous		2007 May		3	3	NaN is printed as '0.0'
2347	code	fixed	2007 May	anonymous		2007 May		3	3	sqlite 3.3.17 crashes when doing "IN (select union select)"
2348	doc	fixed	2007 May	anonymous		2007 May		5	3	deteched -> detected
2349	code	fixed	2007 May	anonymous		2007 May		3	3	Inconsistent conversion of BLOB to TEXT on UTF-16
2354	code	fixed	2007 May	anonymous		2007 May		2	1	Win32 locking problems
2356	code	fixed	2007 May	anonymous		2007 May		1	1	INDEX not used if column in WHERE clause refers to an alias
2359	code	fixed	2007 May	anonymous		2007 May		1	5	typo error
2360	code	fixed	2007 May	anonymous		2007 May		2	2	Possible buffer overrun in some text functions
2364	code	fixed	2007 May	anonymous		2007 May		2	2	cast(as numeric) truncates small number of large integer
2371	code	new	2007 May	anonymous		2009 Jul		2	2	sqlite3_errcode() and sqlite3_errmsg() return unexpected results
2379	code	fixed	2007 May	anonymous		2007 May		3	3	Concatenation with zeroblob
2382	doc	fixed	2007 May	anonymous		2007 Jul		3	3	VACUUM alters/repacks the ROWIDs if no explicit primary key is given
2399	code	fixed	2007 Jun	danielk1977		2007 Jun		1	1	Compiling with msvc fails due to use of "isnan()"
2403	code	fixed	2007 Jun	anonymous		2007 Jun		3	3	LEFT JOIN inconsistancy with NULL expression in ON clause
2404	code	fixed	2007 Jun	anonymous		2007 Jun		2	2	Values in INTEGER PRIMARY KEY always less than NULL
2406	code	fixed	2007 Jun	anonymous		2007 Jun		1	3	C++ style comments unacceptable in C code.
2407	code	fixed	2007 Jun	anonymous		2007 Jun		1	4	Problem with ` (0x60) character in LIKE statement
2410	doc	fixed	2007 Jun	rdc		2007 Jun		5	3	typo in checkin 4053
2413	code	active	2007 Jun	anonymous		2008 Feb	drh	1	1	1 bug and 2 suggestions in lemon
2415	code	fixed	2007 Jun	anonymous		2007 Jun	drh	1	1	[4061] propagates SQLITE_ABORT outside nested loops
2416	doc	fixed	2007 Jun	anonymous		2007 Jun	drh	5	5	Spelling error
2418	code	fixed	2007 Jun	drh		2007 Jun	drh	1	1	Database corruption following malloc failure in auto-vacuum mode
2422	code	fixed	2007 Jun	anonymous		2007 Jun		1	1	pager.c, line 662: #define pager_datahash(X) 0
2423	code	fixed	2007 Jun	anonymous		2007 Jun		4	4	Check-in [4086] mkdll.sh no longer creates sqlite3.dll
2424	doc	fixed	2007 Jun	anonymous		2007 Jun		3	4	Documentation for Tcl-level access to incremental blob I/O is missing.
2425	code	fixed	2007 Jun	anonymous		2007 Jun		3	3	ftruncate on platform where off_t is not 64 bit
2426	code	fixed	2007 Jun	anonymous		2007 Jun		4	4	Access violation calling sqlite3_column_text after sqlite3_reset
2428	build	fixed	2007 Jun	anonymous		2007 Jun		4	3	sqlite 3.4.0 ships with own 'limits.h' interfering with system one.
2430	code	fixed	2007 Jun	anonymous		2007 Jun		3	3	date and strftime functions returns invalid year
2431	code	fixed	2007 Jun	anonymous		2007 Jun		2	3	segfault with missing order by expression
2432	doc	fixed	2007 Jun	anonymous		2007 Jun		5	5	Documentation typo in sqlite3_sleep()
2433	code	fixed	2007 Jun	rse		2007 Jun		1	2	sqlite CLI's reading of ".sqliterc" broken in 3.4.0
2434	code	fixed	2007 Jun	anonymous		2007 Jun		5	5	comment typo in analyze.c
2436	code	fixed	2007 Jun	rse		2007 Jun		1	1	SQLite has to link against -lm for isnan(3)
2437	code	fixed	2007 Jun	rse		2007 Jun		3	3	Consistently use $(NAWK) in Makefile.in
2446	code	fixed	2007 Jun	anonymous		2007 Jun		1	2	FTS2 Limits Number of Indexed Tables to 3
2448	new	fixed	2007 Jun	anonymous		2008 Mar		4	3	SQLITE needs to identify public exported symbols
2453	code	fixed	2007 Jun	anonymous		2007 Jun		4	3	Can the amalgamation be made entirely static
2454	code	fixed	2007 Jun	drh		2007 Jun		1	1	Leading zeros cause large integers to be convert to floating point.
2455	build	fixed	2007 Jun	anonymous		2007 Jun	drh	2	3	aix linking fails due to missing library
2464	code	fixed	2007 Jun	anonymous		2007 Jun		5	4	error message not set by sqlite3_blob_write
2465	code	fixed	2007 Jun	anonymous		2007 Jun		4	4	64-bit/tcl regression failure with types3-1.3
2466	code	fixed	2007 Jun	anonymous		2007 Jun		5	5	ENCODING not used in Makefile.linux-gcc
2468	doc	fixed	2007 Jun	anonymous		2007 Jun		5	5	Spelling error in documentation
2470	code	fixed	2007 Jun	anonymous		2007 Jun		1	3	subselects causing reproducable SIGSEGV
2475	code	fixed	2007 Jun	anonymous		2007 Jul		1	3	Handles being left open on unix
2499	build	defer	2007 Jul	anonymous		2007 Aug	drh	1	1	undefined reference to `_WinMain@16'
2502	code	fixed	2007 Jul	anonymous		2007 Jul		4	4	Digital Mars static library runtime problem
2507	code	fixed	2007 Jul	anonymous		2007 Jul		1	1	test_expr expr-1.104 fails (64-bit int handling)
2514	code	fixed	2007 Jul	anonymous		2007 Jul		3	3	max() and min() is wrong when DESC index exists
2518	code	fixed	2007 Jul	anonymous		2007 Jul		2	1	Complex paging problem
2521	code	fixed	2007 Jul	anonymous		2007 Jul		2	4	Misplaced prototypes
2522	code	fixed	2007 Jul	anonymous		2007 Jul		4	4	wrong sizeof in vdbe.c
2523	code	fixed	2007 Jul	anonymous		2007 Jul		3	4	Leaked memory on error return from sqlite3VdbeMemTranslate
2524	code	fixed	2007 Jul	anonymous		2007 Jul		4	4	Missing error check in call to sqlite3PagerWrite() in autoVacuumCommit
2525	code	fixed	2007 Jul	anonymous		2007 Jul		1	3	Constraint violations fail silently with "insert or replace"
2526	code	fixed	2007 Jul	anonymous		2007 Jul		2	4	Core dump when issuing a select statement with special having clause
2528	doc	fixed	2007 Jul	anonymous		2007 Jul		3	2	PRAGMA auto_vacuum documentation mismatch
2533	code	fixed	2007 Jul	anonymous		2007 Oct		1	2	temporary files are not deleted on WinCe
2544	code	fixed	2007 Jul	rse		2007 Jul		4	3	"sqlite3 foo.db .dump \| sqlite3 bar.db" fail because of verbose output
2545	code	active	2007 Jul	anonymous		2007 Jul		1	4	Group by returns table name with field name
2546	code	fixed	2007 Jul	anonymous		2007 Oct		4	1	Comments are not parsed correctly
2547	code	active	2007 Aug	danielk1977		2007 Aug		5	3	Changing db encoding of an attached db can confuse shared cache mode.
2548	code	fixed	2007 Aug	anonymous		2007 Oct	anonymous	4	4	Pelles C compiler for Windows ANSI prototype / K&R declaration errors
2550	code	fixed	2007 Aug	anonymous		2007 Oct	drh	3	3	Lemon parser may accept input before EOF is seen
2554	code	fixed	2007 Aug	anonymous		2007 Aug		3	3	Many symbols not marked private/static or SQLITE_API in amalgamation
2556	todo	fixed	2007 Aug	anonymous		2007 Aug		5	5	tabs instead of space in some source files
2558	code	active	2007 Aug	anonymous		2007 Aug		2	3	Multiple JOIN USING() gives incorrect results
2559	code	fixed	2007 Aug	anonymous		2008 Mar		4	4	"make clean" does not delete sqlite3.c and tsrc/
2560	doc	fixed	2007 Aug	anonymous		2007 Aug		5	4	Documentation typos
2561	code	fixed	2007 Aug	anonymous		2007 Dec		1	1	Parser broken -- ORDER BY fails in UNION between two databases
2565	code	fixed	2007 Aug	drh		2007 Aug		1	1	Database corruption following ROLLBACK when soft_heap_limit set
2570	code	fixed	2007 Aug	anonymous		2007 Aug		3	3	unportable assumptions in sqlite3AtoF() / cast.test
2573	doc	fixed	2007 Aug	anonymous		2007 Aug		3	3	sqlite3_interrupt() + threads
2574	build	fixed	2007 Aug	anonymous		2007 Aug	anonymous	3	3	amalgamation 3.4.2 compile errors
2579	code	fixed	2007 Aug	anonymous		2007 Oct		4	3	the third parameter of substr should be optional
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
2588	code	fixed	2007 Aug	anonymous		2007 Aug		1	1	bug in sqlite3_mutex_leave
2591	doc	fixed	2007 Aug	anonymous		2007 Aug		4	4	sqlite3_open() documentation should mention :memory:
2597	code	fixed	2007 Aug	anonymous		2007 Oct		1	1	tclsqlite "db eval" with array-name doesn't have "*" entry. (tcl8.5a7)
2598	code	fixed	2007 Aug	anonymous		2007 Oct		3	3	Failure to delete temporary files on WINCE platforms
2599	code	fixed	2007 Aug	anonymous		2007 Aug		1	1	OS check in mutex.h has no effect
2600	code	fixed	2007 Aug	anonymous		2007 Aug		1	1	#ifdef SQLITE_MUTEX_WIN32 naming error in mutex_w32.c?
2602	code	fixed	2007 Aug	anonymous		2007 Aug		1	1	ATTACH leaks memory
2606	code	fixed	2007 Aug	anonymous		2007 Sep		3	3	PATCH - default configure option enable_threadsafe=yes
2608	code	fixed	2007 Aug	anonymous		2007 Sep		3	3	failed allocation leads to unexpected infinite loop
2610	code	fixed	2007 Sep	anonymous		2007 Sep	drh	4	3	SQLITE_API sqlite3_sleep function header missing in sqlite3ext.h
2611	code	fixed	2007 Sep	anonymous		2007 Sep		2	1	AV calling sqlite3_vfs_register()
2612	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	enterMutex() misnamer
2615	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	winRandomness without effect due to < vs. > mixup
2616	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	Flags parameter not honoured in openDatabase()
2619	doc	fixed	2007 Sep	anonymous		2007 Sep		5	5	typo
2621	code	fixed	2007 Sep	anonymous		2007 Sep		1	5	another typo
2622	doc	fixed	2007 Sep	anonymous		2007 Sep		3	3	SQLITE_OMIT_MEMORY_ALLOCATION undocumented unresolved functions
2623	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	zeroblob(-1) returns non-NULL from sqlite3_column_blob()
2624	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	Invalid documentation references in sqlite.h.in
2628	code	fixed	2007 Sep	anonymous		2007 Sep		3	4	Bad error handling for invalid page-size
2629	doc	fixed	2007 Sep	anonymous		2008 Jun		4	4	typo in os_unix.c for nolock
2631	code	fixed	2007 Sep	anonymous		2007 Sep		3	3	Comments at end of "CREATE TABLE" cause SQL error.
2632	code	fixed	2007 Sep	anonymous		2008 Mar	danielk1977	5	2	sqlite3* not available within loadable extension <sqlite3ext.h>
2633	build	fixed	2007 Sep	anonymous		2007 Sep		1	1	building with gcc3.3.4 - undefined reference to `sqlite3KeywordCode'
2640	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	sqlite doesn't treat global identifiers correctly in a subquery
2643	code	fixed	2007 Sep	anonymous		2007 Sep		1	1	bestIndex: Assertion `flags!=0' failed after index creation
2648	build	fixed	2007 Sep	anonymous		2007 Sep		1	1	compilation error for PocketPC/WindowsCE
2649	new	fixed	2007 Sep	anonymous		2008 Mar		4	4	Add an "--enable-extensions" (default=no) to the configure script
2652	code	active	2007 Sep	drh		2007 Sep		1	1	Aggregate function cannot be used from within a subquery
2658	code	fixed	2007 Sep	anonymous		2007 Sep		2	3	sqlite3VtabOverloadFunction broken
2659	code	fixed	2007 Sep	rse		2007 Sep	danielk1977	2	2	openDirectory function broken
2664	code	active	2007 Sep	danielk1977		2007 Sep		1	1	attaching the same db twice in shared-cache mode fails
2666	doc	fixed	2007 Sep	anonymous		2007 Oct		4	4	Typos/spelling errors in sqlite3.h
2672	doc	fixed	2007 Sep	anonymous		2007 Oct		1	3	icu ext init failure: sqlite3_create_function returns SQLITE_BUSY
2673	build	fixed	2007 Sep	anonymous		2007 Oct		4	4	3.5.0 amalgamation on OS X, "#define _XOPEN_SOURCE 500" fails build
2678	code	fixed	2007 Sep	anonymous		2007 Oct		1	1	amalgamation zip file should include sqlite3ext.h
2680	code	fixed	2007 Sep	anonymous		2007 Oct		2	2	sqlite_int64 vs sqlite3_int64 type confusion in headers and docs
2681	code	fixed	2007 Oct	anonymous		2007 Oct		3	3	#ifndef _XOPEN_SOURCE needed around #define _XOPEN_SOURCE 500
2683	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	Windows CE won't compile, also a problem with sqlite3OsFullPath on CE
2685	code	fixed	2007 Oct	anonymous		2007 Oct	anonymous	2	1	Compilation under MSVC gives warning on TryEnterCriticalSection
2686	code	fixed	2007 Oct	anonymous		2007 Oct		3	3	Integrity check fails if you hit max_page_count and dont rollback
2687	code	fixed	2007 Oct	anonymous		2007 Nov		3	2	Building with _UNICODE fails in Win32 (3.5.1)
2693	code	fixed	2007 Oct	anonymous		2007 Oct	drh	2	2	mutex.h missing in a10n of sqlite3internal.h
2694	code	fixed	2007 Oct	anonymous		2007 Oct	drh	2	2	Makefile.in is missing invokation of mksqlite3internalh.tcl for a10n
2696	code	fixed	2007 Oct	anonymous		2007 Oct		3	3	sqlite3.c with SQLITE_OMIT_FLOATING_POINT cannot compile on Linux
2697	code	fixed	2007 Oct	anonymous		2007 Oct		1	3	sqlite3_open_v2 fails then filename includes non-english chars
2698	code	fixed	2007 Oct	anonymous		2007 Oct		3	4	memory leak in WIN CE because tempfilename is not freed at WinClose
2699	code	fixed	2007 Oct	anonymous		2007 Oct		2	2	Performance issues in 3.5.1 (Windows)
2700	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	invalid name in winOpen when compiling under WinCE
2702	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	Errors in CreateFileW function use on WinCE
2710	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	Typo in code specific to WinCE (checkin 4479)
2711	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	WinCE: flags incorrectly checked
2713	build	fixed	2007 Oct	anonymous		2007 Oct		1	5	build fails for 3.5.1 on win32/cygwin - duplicate opcode labels
2722	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	data mis-alignment in UTF16 collation callback arguments
2729	doc	active	2007 Oct	anonymous		2007 Oct		1	1	Lemon: %fallback, %wildcard, and @X uncodumented
2732	code	fixed	2007 Oct	anonymous		2007 Oct		2	2	sqlite3Step crashes if called with a null argument (easy fix)
2733	code	fixed	2007 Oct	anonymous		2007 Oct		1	1	OP_Real and OP_Int64 inefficient for constants
2737	code	fixed	2007 Oct	anonymous		2007 Oct		4	4	save 35 bytes in VACUUM with new 2 argument substr()
2738	code	fixed	2007 Oct	anonymous		2007 Oct		2	2	vfsUnlink breaks when building with OS_OTHER=1
2739	code	fixed	2007 Oct	anonymous		2007 Oct		2	3	large-file enable macros should be defined before first #include
2740	code	fixed	2007 Oct	anonymous		2007 Oct		4	4	incorrect assertions in vdbe.c
2741	code	fixed	2007 Oct	anonymous		2007 Oct		3	3	_XOPEN_SOURCE may be necessary for pread/pwrite as well as threads
2755	code	active	2007 Nov	anonymous		2007 Nov		3	3	trace interfere with transaction Tcl interface
2762	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	fts3 is cavalier about malloc vs sqlite3_malloc
2766	code	active	2007 Nov	drh		2007 Nov		1	1	TCL transaction started from within a query does not commit
2767	code	fixed	2007 Nov	anonymous		2007 Nov		2	1	UPDATE causes ./src/vdbe.c:503: sqlite3VdbeExec: Assertion `pTos<=&p->
2771	code	active	2007 Nov	anonymous		2007 Nov		4	4	Lemon: Generated parser needs stdlib.h (not in default template)
2774	code	fixed	2007 Nov	shess		2007 Nov	shess	1	1	Crash merging empty OR queries in fts3.
2780	build	fixed	2007 Nov	anonymous		2007 Nov		3	3	sqliteint.h: test to disable _XOPEN_SOURCE uses wrong macro for OSX
2781	doc	fixed	2007 Nov	anonymous		2007 Nov		5	4	Make documentation available offline (i.e. pdf, chm, etc)
2783	doc	fixed	2007 Nov	anonymous		2007 Nov		5	4	Broken links into the website
2784	code	fixed	2007 Nov	anonymous		2007 Nov		1	3	Low memory double free and SEGV from flattenSubquery()
2785	doc	fixed	2007 Nov	anonymous		2007 Nov		3	3	Broken Anchors in C API Reference
2788	build	fixed	2007 Nov	anonymous		2007 Nov	drh	3	3	FormatMessageA not defined for Windows Mobile
2789	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	Low memory double free from addWhereTerm
2792	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	invalidateCursorsOnModifiedBtrees has no scoping
2794	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	Low memory SEGV in isLikeOrGlob()
2795	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	Low memory SEGV in exprAnalyze()
2796	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	Another low memory SEGV in exprAnalyze()
2797	code	fixed	2007 Nov	anonymous		2007 Nov		3	3	Low memory SEGV in whereClauseClear()
2799	build	fixed	2007 Nov	anonymous		2007 Nov		3	3	'configure ' cannot locate VERSION file
2800	build	fixed	2007 Nov	anonymous		2007 Nov		5	5	-lpthread not needed for publish.sh for CLI binary
2801	code	fixed	2007 Nov	anonymous		2007 Nov		5	5	superfluous -lpthread for CLI in publish_osx.sh
2803	code	fixed	2007 Nov	anonymous		2007 Nov		4	3	test: io-4.2.2 fails on 64-bit --- signed extension
2805	code	fixed	2007 Nov	anonymous		2007 Nov		1	1	Checkin [4573] Home grown recursive mutexes
2806	code	fixed	2007 Nov	anonymous		2007 Nov		3	4	Low memory assert in insertCell()
2807	doc	fixed	2007 Nov	anonymous		2007 Nov		4	3	Link errors in Documentation
2811	code	fixed	2007 Nov	anonymous		2007 Nov		5	4	"appropriate" misspelled "approriate" on SQLite Documentation page
2815	doc	fixed	2007 Dec	anonymous		2007 Dec		2	3	sqlite3_blob_close closes blob even when reporting error!
2820	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	rollback doesn't work
2822	code	fixed	2007 Dec	anonymous		2007 Dec		3	3	ORDER BY term number 1 does not match any result column in select.c
2826	build	fixed	2007 Dec	anonymous		2007 Dec		4	4	test_thread.c won't build if !SQLITE_THREADSAFE \|\| !TCL_THREADS
2827	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	make test: vacuum2.test did not close all files: 1
2829	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	Win32: temp files left over in temp area
2832	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	Data corruption with UPDATE or DELETE clause ...
2833	doc	fixed	2007 Dec	anonymous		2007 Dec		5	1	typo on SQLite home page
2835	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	Lemon memory read/write errors
2838	code	fixed	2007 Dec	anonymous		2007 Dec		3	3	Request: use traditional way to build CLI
2839	new	defer	2007 Dec	anonymous		2007 Dec		4	4	Deleting row from sqlite_stat1 will not take effect until next connect
2840	doc	fixed	2007 Dec	anonymous		2007 Dec		5	4	Punctuation errors in comment
2843	code	fixed	2007 Dec	anonymous		2007 Dec		3	4	Low memory crash in sqlite3ExprCodeAndCache
2846	build	fixed	2007 Dec	anonymous		2007 Dec		1	1	--disable-tcl does not work
2849	doc	fixed	2007 Dec	anonymous		2007 Dec		5	5	unary operator !
2850	code	fixed	2007 Dec	anonymous		2007 Dec		2	2	CSV output missing quotes if contains equals character
2851	code	fixed	2007 Dec	anonymous		2007 Dec		1	1	make test double free or corruption error
2852	code	fixed	2007 Dec	anonymous		2007 Dec		4	4	sqlite library is sometimes 40K bigger when built on OpenBSD
2853	new	active	2007 Dec	anonymous		2008 Jan		2	3	optimizer fails to use an index on MAX subquery
2873	code	fixed	2008 Jan	anonymous		2008 Mar		1	1	HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make
2877	code	fixed	2008 Jan	anonymous		2008 Jan		1	1	Unescaped quotation marks in mkopcodeh.awk (CVS [4693])
2880	code	fixed	2008 Jan	anonymous		2008 Jan		1	1	problem with reals bigger then 1e18
2883	code	fixed	2008 Jan	anonymous		2008 Jan		1	1	compile error - missing data
2894	code	fixed	2008 Jan	anonymous		2008 Jan		1	1	virtual table calls Next() and Column() after Eof() returns true
2898	code	fixed	2008 Jan	anonymous		2008 Mar		1	1	Latest CVS for 3.5.4 fails to build test1.c
2904	code	fixed	2008 Jan	anonymous		2008 Feb	pweilbacher	3	3	os_os2.c - 2 dysfunctional functions
2905	code	fixed	2008 Jan	anonymous		2008 Feb	pweilbacher	2	2	mutex_os2.c - incorrect mutex implementation
2909	build	fixed	2008 Jan	aswift		2008 Feb	aswift	4	4	Omit the _XOPEN_SOURCE 500 define on Mac OS-X (check for __APPLE__)
2913	code	fixed	2008 Jan	anonymous		2008 Jan		3	3	vtab regression failures
2914	code	fixed	2008 Jan	anonymous		2008 Feb		3	3	ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
2915	build	fixed	2008 Feb	pweilbacher		2008 Mar		4	3	fix Makefile for platforms that need .exe extension
2916	code	fixed	2008 Feb	anonymous		2008 Feb		1	1	sqlitedll-3_5_5.zip is older 3.5.4 binary
2917	code	active	2008 Feb	anonymous		2008 Feb		4	4	Tcl interface - busy callback confusion script/procedure
2920	code	fixed	2008 Feb	anonymous		2008 Feb		1	3	SQLITE_FULL error is given even if the max_page_count is increased
2923	build	fixed	2008 Feb	pweilbacher		2008 Feb		3	3	Duplicate symbol pager3_refinfo_enable when linking with debug & test
2924	doc	fixed	2008 Feb	anonymous		2008 Feb		4	2	Random noise in code on web page
2927	code	fixed	2008 Feb	anonymous		2008 Feb		1	2	custom (user) function misbehaves in union-ed select statement
2935	code	fixed	2008 Feb	anonymous		2008 Apr		3	3	fts3 and PRAGMA count_changes problems
2936	code	fixed	2008 Feb	anonymous		2008 Apr	danielk1977	3	4	Too many error or warning messages with BDS2006
2938	code	fixed	2008 Feb	anonymous		2008 Feb		3	5	UPDATE/DELETE of views (via triggers) performs poorly
2940	code	review	2008 Feb	anonymous		2008 Apr		3	3	error codes and messages from functions don't get through step()
2942	code	fixed	2008 Feb	anonymous		2008 Feb		1	2	a bug occured in output.c
2943	code	fixed	2008 Feb	anonymous		2008 Feb		4	4	group_concat + order by
2949	code	fixed	2008 Feb	anonymous		2008 Feb		1	1	SQLITE_OMIT_UTF16 compile error
2953	new	defer	2008 Feb	anonymous		2008 Mar		1	5	Threading, mutexes, and pthread_atfork
2955	doc	fixed	2008 Feb	anonymous		2008 Feb		5	4	typo on website
2959	code	fixed	2008 Feb	anonymous		2008 Feb		1	1	Inconsistent behavior for LIKE query on indexed COLLATE NOCASE column
2963	doc	fixed	2008 Feb	anonymous		2008 Feb		5	4	sqlite.org website errors
2964	code	active	2008 Feb	anonymous		2008 Mar	drh	1	1	Access Violation from VACUUM with 3.5.6 on Corrupt Database
2969	doc	fixed	2008 Mar	anonymous		2008 Mar		5	4	Website typos
2975	code	fixed	2008 Mar	anonymous		2008 Apr		4	4	sqlite3_bind_parameter_name for ?NNN is not null
2978	code	fixed	2008 Mar	anonymous		2008 Mar		3	3	usleep (and fdatasync?) not used even if available.
2979	build	fixed	2008 Mar	anonymous		2008 Mar		4	3	Configure does not respect prefix
2980	doc	fixed	2008 Mar	anonymous		2008 Mar		5	5	Typos in create_function.html lang_select.html
2981	build	fixed	2008 Mar	anonymous		2008 Mar		1	2	Solution to Tcl compile error.
2982	code	fixed	2008 Mar	anonymous		2008 Mar		3	3	amalg inconsistant declaration sqlite3_version, sqlite3_temp_directory
2985	code	fixed	2008 Mar	anonymous		2008 Mar	drh	2	1	possible incorrect assignment in if statement
2990	code	fixed	2008 Mar	anonymous		2008 Mar		2	1	Incorrect result of union all query with subquery
2991	code	fixed	2008 Mar	rdc		2008 Apr		1	1	sqlite3.exe termiantes due to bad table name
2993	code	fixed	2008 Mar	anonymous		2008 Mar	appledev	1	1	file locking fails on OS X network volumes
2994	code	fixed	2008 Mar	anonymous		2008 Apr		2	2	DROP fts3 table causes crash
2998	code	fixed	2008 Mar	anonymous		2008 Mar		2	2	bad vdbe code generated for natural join of virtual tables
3001	code	fixed	2008 Mar	anonymous		2008 Apr		3	4	lemon: repeat %include
3004	doc	fixed	2008 Mar	anonymous		2008 Mar		3	3	Invalid HTML in 3.5.7 documentaion
3009	code	fixed	2008 Mar	anonymous		2008 Mar		3	3	Bug with function Group_Concat
3015	code	fixed	2008 Mar	anonymous		2008 Mar		2	3	Adding index changes LEFT OUTER JOIN to act as INNER JOIN
3016	doc	fixed	2008 Mar	anonymous		2008 Mar		5	5	SQLITE_MAX_ATTACHED
3019	doc	fixed	2008 Mar	anonymous		2008 Jun	mihailim	5	5	Typo in SEC(11) of the SQLite FAQ
3020	build	fixed	2008 Mar	rdc		2008 Mar		3	3	make fails while building sqlite3.c
3024	code	fixed	2008 Mar	rse		2008 Apr	drh	4	3	small compile-time fix related to symbols "sqlite3Apis"
3029	code	fixed	2008 Apr	anonymous		2009 Feb	shane	4	3	Defining SQLITE_OMIT_FLOATING_POINT does not remove all FP ops.
3031	doc	fixed	2008 Apr	anonymous		2008 Apr		5	4	Typo in "Atomic Commit In SQLite" document
3036	code	active	2008 Apr	anonymous		2008 Apr		4	4	ANALYZE considers all NULL values unique
3037	code	fixed	2008 Apr	anonymous		2008 Apr		3	3	sqlite3_open_v2 doesn't verify flags parameter
3038	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	sqlite3_changes returns 0 on UPDATE on a virtual table
3039	code	fixed	2008 Apr	anonymous		2008 Apr		3	2	missing error in db copy command
3040	code	fixed	2008 Apr	anonymous		2008 Apr		1	4	solaris 8 gcc 32-bit build crashes
3047	code	fixed	2008 Apr	anonymous		2008 Apr		5	4	improvement for EBCDIC hexToInt() in checkin 4967
3048	code	fixed	2008 Apr	anonymous		2008 Apr		5	4	Unused variable warning in sqlite3GenerateRowIndexDelete
3049	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	sprintf() still used in FTS (all versions)
3050	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	sqlite3BitvecSet crash
3051	code	review	2008 Apr	anonymous		2008 Jun		4	3	Even after setting pragma short_column_names the complete name is stil
3052	code	fixed	2008 Apr	pweilbacher		2008 Apr	pweilbacher	2	3	Handle UTF-8 filenames on OS/2
3053	build	fixed	2008 Apr	anonymous		2008 Apr	pweilbacher	3	3	Bashism in configure
3054	doc	fixed	2008 Apr	anonymous		2008 Apr		5	4	column is used as a keyword but is not listed on website documentation
3055	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	INSTEAD of trigger (on view) fails with 3.5.7+ (worked with 3.2.7+)
3056	code	fixed	2008 Apr	anonymous		2008 Apr		3	3	CVS regression with handling of strings with trailing null
3058	new	active	2008 Apr	anonymous		2008 Apr		3	5	optimizer chooses wrong indicies
3059	code	fixed	2008 Apr	anonymous		2008 Apr	drh	1	2	sqlite3_column_metadata race condition
3060	code	fixed	2008 Apr	anonymous		2008 Apr		3	3	NaN
3062	code	fixed	2008 Apr	anonymous		2008 Apr		2	3	regression failures on second pass
3069	code	fixed	2008 Apr	anonymous		2008 Apr		4	4	Cannot compile with -DSQLITE_MAX_COLUMN=0
3079	code	fixed	2008 Apr	anonymous		2008 Apr	drh	3	3	Lemon parser trips over assertions
3082	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	sqlite3VdbeExec: Assertion `p->apCsr[i]!=0' failed
3083	code	fixed	2008 Apr	anonymous		2008 Apr		1	1	fulltextBegin: Assertion `v->nPendingData<0' failed
3084	code	fixed	2008 Apr	anonymous		2008 May	danielk1977	2	2	3.5.8 writer starvation with "begin immediate" transaction
3085	code	fixed	2008 Apr	anonymous		2008 Apr		1	3	F12764 not implemented
3087	code	fixed	2008 Apr	anonymous		2008 Apr		1	2	Slow queries with 3.5.8.
3089	code	fixed	2008 Apr	drh		2008 Apr		1	1	Fix the implementation of sqlite3_isnan()
3093	code	fixed	2008 May	anonymous		2008 May		1	2	Busy handler never succeeds on update retry under 3.5.8
3094	code	fixed	2008 May	anonymous		2008 May		3	4	3.5.8 "disk I/O error" when slt reaches 2gig. Fine with 3.5.2
3096	code	fixed	2008 May	drh		2008 May		1	1	Small-file CLI segfaults when given a large file
3099	code	fixed	2008 May	anonymous		2008 Jun		5	3	Enhancement
3100	code	fixed	2008 May	anonymous		2008 May		5	4	The MAX_6BYTE macro in vdbeaux.c has a too small value
3101	code	fixed	2008 May	anonymous		2008 May		2	2	3.5.9 NaN / gcc issues
3102	code	fixed	2008 May	anonymous		2008 May		2	2	rename table fails with error 11 if CREATE TABLE contains comments
3105	code	fixed	2008 May	anonymous		2008 May		4	4	Sun Workshop 6 compiler warnings
3115	code	active	2008 May	anonymous		2008 Jun		3	2	CREATE TABLE AS SELECT - file size
3117	code	active	2008 May	anonymous		2008 May		5	4	Lemon parser automaton listing improvement
3118	code	fixed	2008 May	anonymous		2008 May		4	4	fault.c does not contain a version comment
3119	code	fixed	2008 May	anonymous		2008 May		4	4	loadexe.c missing version comment
3124	doc	fixed	2008 May	anonymous		2008 May		5	3	missing ] in sqlite.h.in
3126	warn	fixed	2008 May	anonymous		2008 May	shane	4	4	Use localtime_s when available (on Windows/MSVC)
3128	code	active	2008 May	anonymous		2009 Mar		3	3	DISTINCT -> GROUP BY can lead to performance degradation
3129	code	fixed	2008 May	shane		2008 May		4	4	tkt2854.test is failing 2 test cases
3132	doc	fixed	2008 May	shane		2008 May		5	4	update documentation on shared cache/filename matching relationship
3134	code	fixed	2008 May	anonymous		2008 May		5	4	sqlite3Prepare has off by one bug
3136	doc	fixed	2008 May	anonymous		2008 Jun		1	3	sentence on intro page is in error
3139	code	fixed	2008 May	anonymous		2008 May		2	2	COLLATE NOCASE thinks '^' LIKE '@%'
3140	new	active	2008 May	anonymous		2008 May		4	3	[PATCH] Make the default FTS3 tokenizer UTF8-aware
3142	doc	fixed	2008 May	anonymous		2008 Aug		4	4	Documentation doesn't clearly list which functions are experimental
3143	code	fixed	2008 May	anonymous		2008 May		3	4	compile error with SQLITE_MAX_EXPR_DEPTH=0
3146	code	fixed	2008 May	anonymous		2008 May		1	1	vdbe code regression from 3.5.7 to 3.5.9
3148	code	fixed	2008 May	drh		2008 May	drh	1	1	sqlite3_sequence corruption following empty INSERT
3150	code	fixed	2008 May	anonymous		2008 May		1	1	Multi-column index is not used properly with LIKE and ORDER BY
3156	code	fixed	2008 Jun	anonymous		2008 Jun	shane	2	1	PATCH: fix failure to build on x86-64 (provide sqlite3Hwtime)
3172	code	fixed	2008 Jun	anonymous		2008 Jun		2	3	C++ comments in C code
3177	doc	fixed	2008 Jun	anonymous		2008 Jun		1	1	Miswriting in article "SQLite's Use Of Temporary Disk Files"
3179	code	fixed	2008 Jun	anonymous		2008 Jun		1	1	Aggregate functions that take 4 parameters crash (SEGV)
3193	code	fixed	2008 Jun	anonymous		2008 Jun		5	4	wrong description in comment describing sequnce
3202	code	fixed	2008 Jul	anonymous		2008 Jul		2	3	Selecting the result of a binary operation on two columns fails
3209	code	fixed	2008 Jul	drh		2008 Jul	drh	1	1	Segfault when writing into a corrupt database file
3210	doc	fixed	2008 Jul	anonymous		2008 Jul	anonymous	4	4	Documentation error in capi3.html. * fourth* should read fifth.
3211	code	fixed	2008 Jul	anonymous		2008 Jul		2	2	equals comparison failing
3214	code	fixed	2008 Jul	anonymous		2008 Jul		5	4	lemon: [5335] stops #line being generated for %include
3215	code	fixed	2008 Jul	anonymous		2008 Jul		5	4	lemon: Patches to fix comment typos
3216	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	sqlite3_memory_used() prone to over-optimization
3217	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	sqlite3_initialize() not wrapped by SQLITE_OMIT_AUTOINIT
3219	doc	fixed	2008 Jul	anonymous		2008 Jul		4	3	SQLITE_CONFIG_GETMUTEX documention has incorrect header
3221	code	fixed	2008 Jul	anonymous		2008 Jul		2	2	short/full_column_names do not do what they are supposed to in JOINs
3223	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	memsys3Size() causes access violation for NULL pointers
3224	code	fixed	2008 Jul	anonymous		2008 Jul		4	3	sqlite3_mutex_try() is implemented inconsistently
3225	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	non-dereferenced sqlite3Config.m struct assignments in main.c
3226	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	mem3.c: memsys3Size() roundup error
3228	code	fixed	2008 Jul	anonymous		2008 Jul		1	2	btree compilation error with SQLITE_OMIT_AUTOVACUUM
3229	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	view on virtual table causes segmentation fault
3232	code	fixed	2008 Jul	anonymous		2008 Jul		4	3	Possible mem.leak in winDlOpen() under WINCE
3244	code	fixed	2008 Jul	anonymous		2008 Jul		2	3	sqlite_next_stmt fails with null database pointer
3248	code	fixed	2008 Jul	anonymous		2008 Jul		1	2	integer overflow sqlite3Strlen in comparison
3256	code	fixed	2008 Jul	anonymous		2008 Aug	shane	2	4	PATCH: fix failure to build on gcc-powerpc (provide sqlite3Hwtime)
3257	todo	fixed	2008 Jul	anonymous		2008 Jul		2	4	implicit cast from string to integer gets wrong answer
3259	code	fixed	2008 Jul	anonymous		2008 Jul		1	1	pre-3.6.1 testfixture coredump
3260	code	fixed	2008 Jul	anonymous		2008 Jul		2	3	Unable to open multiple new databases on FAT filesystem (OSX)
3263	code	fixed	2008 Jul	anonymous		2008 Jul		4	3	_GNU_SOURCE can redefined by sqliteInt.h
3266	doc	active	2008 Aug	anonymous		2008 Aug	shess	2	3	"TokenizeR" or "Tokenize"? Docs conflict code
3274	code	active	2008 Aug	anonymous		2008 Aug		1	1	"LIKE" does not work when searching for Arabic text
3277	code	fixed	2008 Aug	anonymous		2008 Aug		1	1	Lookaside AV with user mem if number of slots is not multiple of 8
3281	code	active	2008 Aug	anonymous		2008 Aug		2	3	FTS3 and JOIN, cannot use MATCH operator
3282	doc	active	2008 Aug	anonymous		2008 Aug		5	4	VFS xAccess says parameter is flags - should be flag (singular)
3283	code	fixed	2008 Aug	drh		2008 Aug		1	1	sqlite3_complete() incorrect for a trigger with an empty body.
3284	code	fixed	2008 Aug	drh		2008 Aug		1	1	CREATE INDEX on sqlite_stat1 is allowed
3285	new	active	2008 Aug	anonymous		2008 Aug	drh	5	5	Add a module_list pragma to display all modules installed
3288	code	fixed	2008 Aug	anonymous		2008 Aug	drh	1	2	Parsers generated with lemon do not compile as c++
3289	code	fixed	2008 Aug	anonymous		2008 Aug		1	1	lookaside tests failed with memory error
3290	doc	fixed	2008 Aug	anonymous		2008 Aug	drh	5	1	error in documentation of glob(X,Y) and like(X,Y) functions
3292	code	fixed	2008 Aug	anonymous		2008 Aug		2	3	Order by clause affects the number of rows returned.
3293	build	fixed	2008 Aug	anonymous		2008 Aug		4	4	Fix a bunch of Win64 compilation errors by cowardly casting size_ts to
3298	code	fixed	2008 Aug	anonymous		2008 Aug	drh	1	4	Problem resolving references to view columns when updating a view
3299	code	fixed	2008 Aug	anonymous		2008 Aug		3	3	invalid lemon parser from implicit token destruction
3300	code	fixed	2008 Aug	anonymous		2008 Aug	drh	1	3	Join on a subquery returns incorrect results
3301	code	fixed	2008 Aug	anonymous		2008 Aug	drh	1	4	Problem resolving columns in a nested subquery
3303	new	active	2008 Aug	anonymous		2008 Aug		3	3	faster index creation for large tables
3308	code	fixed	2008 Aug	anonymous		2008 Aug		3	4	compatibility issue with RowID column name
3309	warn	fixed	2008 Aug	anonymous		2008 Aug		3	3	Compiler warnings: "X shadows Y"
3310	code	active	2008 Aug	anonymous		2008 Aug		3	4	VFS xClose docs need update, code ignores returns mostly
3318	code	fixed	2008 Aug	anonymous		2008 Sep		1	1	Bus Error for any operation on sparc64
3324	code	fixed	2008 Aug	anonymous		2008 Aug		3	3	count with argument is acting odd in a grouped query w/ join
3326	code	fixed	2008 Aug	anonymous		2008 Aug		3	3	assert() in sqlite3VdbeMemFinalize fires for some queries
3327	doc	fixed	2008 Aug	anonymous		2008 Aug		5	4	OP_MoveTo
3328	code	fixed	2008 Aug	anonymous		2008 Aug	pweilbacher	1	2	Temporary file do not deleted under OS/2
3330	new	active	2008 Aug	anonymous		2008 Aug		3	4	faster large updates
3331	code	fixed	2008 Aug	anonymous		2008 Aug		4	3	Minor problems in printf.c
3333	code	fixed	2008 Aug	anonymous		2008 Aug		4	3	Empty bodies of if statements in where.c
3334	code	fixed	2008 Aug	anonymous		2008 Aug		2	2	Bug in a query returning COUNT(*) with subselect query
3335	code	fixed	2008 Aug	rdc		2008 Aug		1	1	vacuum crashes with :memory: database
3336	code	fixed	2008 Aug	anonymous		2008 Aug		1	1	Transaction on error return authorizer code instead of trigger error
3343	code	active	2008 Aug	rdc		2009 Jul		1	3	incorrect results for queries using alias names
3344	build	fixed	2008 Aug	anonymous		2008 Dec		4	4	Core dump on AIX 5.2, VAC 9.0 with optmization, sqlite 3.6.1
3345	warn	fixed	2008 Aug	anonymous		2008 Sep		4	3	Override like(X,Y) function with -1 as num of args
3346	code	fixed	2008 Aug	anonymous		2008 Sep	drh	1	2	Crash in sqlite3ExprCollSeq
3347	build	fixed	2008 Sep	anonymous		2008 Sep		4	3	_MSC_VER usage for VC6
3349	code	fixed	2008 Sep	anonymous		2008 Sep		1	1	Left-over sqlite3PagerAlwaysRollback interface in pager.h
3360	code	active	2008 Sep	anonymous		2008 Sep		4	4	undetected ambiguous column name
3362	code	tested	2008 Sep	anonymous		2008 Sep		1	1	3.6.2 test suite failures on x86_64 (Mandriva Linux)
3369	code	fixed	2008 Sep	anonymous		2008 Sep		5	4	isInterrupted
3370	code	fixed	2008 Sep	rdc		2008 Sep		2	3	wrong results for columns with quoted identifiers
3371	code	fixed	2008 Sep	rdc		2008 Sep		2	3	wrong column names for queries with aggregate functions
3372	todo	fixed	2008 Sep	anonymous		2008 Sep		3	3	Quoted identifiers show incorrect column name in results w/aggregates.
3376	code	fixed	2008 Sep	anonymous		2008 Sep		3	3	SELECT DISTINCT returns incorrect results with collate nocase strings
3381	code	active	2008 Sep	anonymous		2008 Sep		2	1	SELECT DISTINCT returns incorrect results with alias in WHERE expr
3383	code	fixed	2008 Sep	anonymous		2008 Sep		4	3	sqlite3PageMalloc lacks a type identifier for parameter
3384	code	fixed	2008 Sep	anonymous		2008 Oct		1	3	Performance regression in 3.6.2 with in memory db
3386	code	active	2008 Sep	anonymous		2008 Sep		4	4	insert default values does not work at the start of a trigger
3387	code	fixed	2008 Sep	anonymous		2008 Sep	drh	4	3	Workaround for Vista's cache manger
3392	code	fixed	2008 Sep	anonymous		2008 Sep		3	3	Some pcache symbols unintentially public
3395	code	fixed	2008 Sep	anonymous		2008 Sep		3	3	SQLITE_EXPERIMENTAL on MSVC 2003 causes error
3396	build	fixed	2008 Sep	aswift		2008 Sep	drh	4	4	tcl 8.5 warns about version number re: require package sqlite3
3397	code	fixed	2008 Sep	aswift		2008 Sep	drh	3	3	load libtclsqlite3.dylib fails with tcl 8.5: missing symbol
3405	code	fixed	2008 Sep	anonymous		2008 Sep	danielk1977	1	1	test_async.c unsafely modifies the async queue
3406	code	defer	2008 Sep	anonymous		2008 Oct		3	4	Error running on dual-core
3411	doc	fixed	2008 Oct	anonymous		2008 Oct		3	4	datetime '+1 month' returns values outside of next month
3415	code	fixed	2008 Oct	anonymous		2008 Oct		1	3	winTruncate does no error checking, always returns SQLITE_OK
3418	code	fixed	2008 Oct	anonymous		2008 Oct		5	4	Bind functions lack assert before sqlite3_mutex_enter(p->db->mutex)
3419	code	fixed	2008 Oct	anonymous		2008 Oct		2	3	Incorrect SELECT results depending on order of tables
3420	build	fixed	2008 Oct	anonymous		2008 Oct	shane	2	3	sqlite doesn't link on Windows/CE
3421	build	fixed	2008 Oct	anonymous		2008 Oct		2	3	SQLITE_MUTEX_APPDEF=1 causes undefined symbol when running
3422	code	fixed	2008 Oct	anonymous		2008 Oct		4	3	Unnecessary use of double in date.c
3427	build	fixed	2008 Oct	anonymous		2008 Oct		5	3	RTREE support in Windows binary builds
3430	code	fixed	2008 Oct	anonymous		2008 Oct		4	2	SQLITE_ENABLE_MEMORY_MANAGEMENT missing from pcache.h
3435	code	fixed	2008 Oct	anonymous		2008 Nov		4	4	vacuum2 regression test does not check for SQLITE_OMIT_AUTOVACUUM
3438	code	fixed	2008 Oct	anonymous		2008 Oct	drh	1	3	Building amalgamation with Rtree fails
3439	code	fixed	2008 Oct	anonymous		2008 Nov		1	1	btree.c: setChildPtrmaps and SQLITE_OMIT_AUTOVACUUM
3441	code	fixed	2008 Oct	anonymous		2008 Oct		2	4	inconsistent/weird handling of parameters to date/time functions
3442	code	fixed	2008 Oct	anonymous		2008 Oct		1	1	Slow memory tables
3444	doc	fixed	2008 Oct	anonymous		2008 Oct	shane	1	1	The compile option SQLITE_OMIT_DEPRECATED was not documented yet.
3446	code	active	2008 Oct	anonymous		2008 Oct		2	3	select hex(randomblob(8)) as a, count(*) from Table where b = a;
3447	doc	fixed	2008 Oct	anonymous		2008 Oct		4	4	documentation error in sqlite3_free
3453	doc	fixed	2008 Oct	anonymous		2008 Nov		4	4	pragma.c documention error
3457	code	fixed	2008 Oct	aswift		2009 Oct	drh	3	4	Return error for mismatched permissions on journal file
3461	code	fixed	2008 Oct	anonymous		2008 Nov		2	1	Incorrect query results (when using index?)
3467	code	fixed	2008 Oct	anonymous		2008 Oct		3	3	low memory assert in multiSelectOrderBy in select.c
3475	doc	fixed	2008 Nov	anonymous		2008 Nov		5	4	Spelling error in documentation of "vacuum" command.
3476	code	fixed	2008 Nov	anonymous		2008 Nov		3	1	Print errors to stderr
3477	doc	fixed	2008 Nov	anonymous		2008 Nov		5	5	Missing comma in documentation of Create Index...
3478	code	fixed	2008 Nov	anonymous		2008 Nov		3	3	low memory crash in sqlite3VdbeMakeReady()
3480	build	fixed	2008 Nov	anonymous		2008 Nov		1	1	Build failure without TCL (--disable-amalgamation)
3481	code	fixed	2008 Nov	anonymous		2008 Nov		4	3	Useless mutexIsNT function
3482	code	fixed	2008 Nov	drh		2008 Nov		1	1	Buffer overrun on UTF-16BE to UTF-8 conversion
3485	code	fixed	2008 Nov	anonymous		2008 Nov		3	3	low memory crash in flattenSubquery()
3488	code	fixed	2008 Nov	anonymous		2008 Nov		3	3	low memory crash in sqlite3VdbeExec()
3489	doc	fixed	2008 Nov	anonymous		2008 Nov		4	4	SQLITE_FUNCTION authorizer name passed in wrong parameter
3490	code	fixed	2008 Nov	anonymous		2008 Nov		1	1	Reading dump causes string errors
3491	warn	fixed	2008 Nov	anonymous		2008 Nov		3	3	If statements using "=" instead of "=="
3494	code	fixed	2008 Nov	anonymous		2008 Nov		3	3	Low memory assert in sqlite3SelectNew()
3496	code	active	2008 Nov	anonymous		2008 Nov		4	4	FTS3: simple tokenizer ignores its first argument
3508	code	fixed	2008 Nov	anonymous		2008 Nov	anonymous	3	4	malformed SQL query causes segfault
3509	code	fixed	2008 Nov	anonymous		2008 Nov		5	4	spelling errors in sqliteInt.h 1.798
3510	code	fixed	2008 Nov	anonymous		2008 Nov		3	3	serious warnings from algamation 3.6.6.1 on Windows
3512	code	fixed	2008 Nov	anonymous		2009 Jan		2	1	unknown errno code ENOTSUP used
3516	doc	fixed	2008 Dec	anonymous		2008 Dec		4	4	Syntax diagram allows HAVING without GROUP BY
3517	code	fixed	2008 Dec	anonymous		2008 Dec		3	2	memory leak in .import handling in shell.c
3518	code	fixed	2008 Dec	anonymous		2008 Dec		1	1	Crashes when building with -DSQLITE_OMIT_BLOB_LITERAL
3519	code	fixed	2008 Dec	anonymous		2008 Dec		1	1	Crash when deleting from a view
3522	code	fixed	2008 Dec	shane		2008 Dec	drh	1	3	assertion with JOIN/USING with correlation
3527	code	fixed	2008 Dec	anonymous		2008 Dec		2	3	access violation / segfault when using multiple view subqueries
3530	code	fixed	2008 Dec	shane		2008 Dec	drh	1	3	assertion failure referencing outer correlation in an inner FROM
3536	code	fixed	2008 Dec	drh		2008 Dec		1	1	Incorrect evaluation of: WHERE rowid>922337236854775807
3537	code	active	2008 Dec	anonymous		2008 Dec		5	4	sqlite3_bind_text + SQLITE_TRANSIENT + different encoding
3541	code	fixed	2008 Dec	drh		2008 Dec		1	1	Use of ~ operator on repeated aggregate terms causes incorrect result.
3542	code	fixed	2008 Dec	anonymous		2008 Dec		1	1	Reproducable bus error on LP64 alignement critical architecture
3544	code	fixed	2008 Dec	anonymous		2008 Dec		3	3	Die <Enter SQL statements terminated with a "/">
3545	code	fixed	2008 Dec	anonymous		2008 Dec		4	4	Please add (void) to declaration of sqlite3MemJournalSize
3546	warn	fixed	2008 Dec	anonymous		2008 Dec		4	4	Function sqlite3MemJournalSize should have "void" as the default param
3547	code	fixed	2008 Dec	anonymous		2008 Dec		3	3	LL suffix breaking VC6 build
3564	code	fixed	2009 Jan	anonymous		2009 Jan		1	4	recursive commit_hook problem
3570	code	fixed	2009 Jan	anonymous		2009 Jan		2	3	create table fail with a database file on the root directory
3578	doc	fixed	2009 Jan	anonymous		2009 Jan		5	4	Incorrect comment in pragma.c regarding journal_size_limit
3579	doc	fixed	2009 Jan	anonymous		2009 Jan		4	3	rowset.c missing versioning tags
3581	code	fixed	2009 Jan	drh		2009 Jan		1	1	Adding an index changes the results of a query
3583	build	fixed	2009 Jan	anonymous	build	2009 Feb	danielk1977	3	3	sqlite3.pc not installed with default source tarball
3584	code	fixed	2009 Jan	drh		2009 Jan		1	1	Cache corruption following COMMIT with pending reads
3585	code	fixed	2009 Jan	anonymous		2009 Jan		5	5	.schema doesn't work with full_column_names=1
3588	code	fixed	2009 Jan	anonymous		2009 Jan		2	3	Small error when compiling sqlite 3.6.9 with gcc on Ubuntu 8.04
3594	code	fixed	2009 Jan	anonymous		2009 Jan		2	1	tcl interface broken on NetBSD for latest 3.6.10
3598	code	fixed	2009 Jan	anonymous		2009 Jan		3	3	sqlite3_get_table() does not always initialise its pzErrMsg parameter
3599	code	fixed	2009 Jan	anonymous		2009 Jan		4	3	configure --enable-tempstore does not correspond to SQLITE_TEMP_STORE
3600	code	active	2009 Jan	anonymous		2009 Jan		5	4	Unnecessary ephemeral table
3603	code	fixed	2009 Jan	anonymous		2009 Jan		1	3	Segmentation fault with PRAGMA journal_mode = OFF
3610	warn	fixed	2009 Jan	anonymous		2009 Jan		5	5	msvc8(2005) warnings whilst compiling
3612	doc	fixed	2009 Jan	anonymous		2009 Jan		2	5	Double quotes and key-words detection
3614	code	fixed	2009 Jan	shane		2009 Jan	shane	4	4	incrvacuum-15.1 test case failing on Windows
3615	code	fixed	2009 Jan	shane		2009 Jan	shane	4	4	filectrl-1.4 test case is failing on Windows.
3616	code	fixed	2009 Jan	shane		2009 Jan	shane	4	4	Lookaside still enabled even if configured buffer size is 0.
3618	code	fixed	2009 Jan	anonymous	func	2009 Jan		2	4	julianday math/rounding issue
3619	doc	fixed	2009 Jan	anonymous	back	2009 Feb		4	4	obsolete MakeIdxRec opcode references in vdbe.c
3621	xplatform	fixed	2009 Jan	anonymous	test	2009 Feb		4	3	patch to fix sqlite3_mprintf_int in src/test1.c (fails on big-endian)
3622	build	fixed	2009 Jan	anonymous		2009 Feb		3	1	ROLLBACK TO syntax error when compiled with SQLITE_OMIT_ALTERTABLE
3623	code	fixed	2009 Jan	drh	front	2009 Jan		5	1	Misleading error message with coalesce() function
3624	code	fixed	2009 Feb	drh	func	2009 Feb		4	1	REPLACE() returns NULL when the second argument is an empty string
3625	new	fixed	2009 Feb	drh	func	2009 Feb		4	1	Negative value to 3rd argument of SUBSTR() gives strange answer
3626	code	fixed	2009 Feb	drh	func	2009 Feb		3	1	SUBSTR returns non-NULL when 2nd or 3rd argument are NULL
3627	code	fixed	2009 Feb	drh	func	2009 Feb		5	1	The RANDOM() function accepts parameters without giving an error.
3628	code	fixed	2009 Feb	drh	func	2009 Feb		3	1	SUBSTR off-by-one when 2nd argument is 0
3629	doc	active	2009 Feb	anonymous	front	2009 Feb		4	4	No error when selecting inappropriate columns when grouping.
3630	code	fixed	2009 Feb	anonymous	front	2009 Feb		2	4	ALTER TEMP TABLE
3631	build	fixed	2009 Feb	anonymous	vfs	2009 Feb		4	3	sqlite3OsDlSym not marked private
3633	code	fixed	2009 Feb	drh	vfs	2009 Feb		3	1	Unchecked return value from write()
3639	new	active	2009 Feb	anonymous	vfs	2009 Feb		3	1	Syntax error doesn't report a line number
3640	code	fixed	2009 Feb	shane	vfs	2009 Feb	shane	1	1	winTruncate() in os_win.c not detecting errors correctly.
3641	code	fixed	2009 Feb	anonymous		2009 Feb		4	3	group_concat(distinct [field], 'separator') fails
3647	new	active	2009 Feb	anonymous	front	2009 Feb		4	3	parsing natural join over more than 2 tables is too inefficient
3648	code	fixed	2009 Feb	drh	back	2009 Feb		1	1	DB page written that was not synced to the journal
3650	doc	active	2009 Feb	anonymous		2009 Feb		4	3	documentation error in c3ref/changes.html
3651	code	fixed	2009 Feb	drh	front	2009 Feb	drh	3	1	Assertion fault on ALTER TABLE ADD COLUMN
3658	code	active	2009 Feb	anonymous		2009 Feb		1	2	Queries return inconsistent results
3659	build	active	2009 Feb	anonymous	build	2009 Feb		4	3	Building sqlite-tea: TEA version, install location, no tests
3662	build	fixed	2009 Feb	anonymous	back	2009 Feb		5	3	sqlite3PagerBackupPtr not marked private
3663	code	fixed	2009 Feb	drh	back	2009 Feb		2	1	VACUUM changes auto_vacuum=INCREMENTAL into auto_vacuum=FULL
3664	build	fixed	2009 Feb	anonymous	build	2009 Feb		4	3	[PATCH] Invalid sqlite3.pc generated by build
3666	code	active	2009 Feb	anonymous		2009 Feb		3	1	softHeapLimitEnforcer called too many times
3668	build	fixed	2009 Feb	anonymous	build	2009 Mar		2	3	sqlite3.1 manpage not included in amalgamation tarball
3669	code	fixed	2009 Feb	anonymous	build	2009 Feb		1	1	maki install error "libtool: install: error: relink `libtclsqlite3.la"
3670	new	active	2009 Feb	anonymous	cli	2009 Feb		5	3	Shell: The "backup_timeout" method for backup/restore operations
3671	build	fixed	2009 Feb	anonymous	build	2009 Feb		5	4	backup api was not exported in sqlite3.def
3678	new	active	2009 Feb	anonymous	front	2009 Mar		3	5	index not selected with re-ordered distinct columns
3696	warn	fixed	2009 Mar	anonymous		2009 Mar		4	3	compile time warning, solaris
3701	warn	fixed	2009 Mar	anonymous	func	2009 Mar	shane	5	4	compiler warning on x64 (Visual Studio 2005)
3702	code	fixed	2009 Mar	anonymous		2009 Mar	shane	5	4	Misspelling in sqlite3.c (succesfully instead of successfully)
3708	new	active	2009 Mar	anonymous		2009 Mar		3	4	UNION + ORDER BY
3718	code	fixed	2009 Mar	danielk1977	back	2009 May	danielk1977	1	1	Race condition in shared cache mode
3723	code	fixed	2009 Mar	anonymous	cli	2009 Mar		3	4	.rekey command requires -key on sqlite3 command line
3724	code	fixed	2009 Mar	anonymous	cli	2009 Mar		4	4	.rekey command fails silently if sqlite3 doesn't have write access
3730	doc	fixed	2009 Mar	anonymous		2009 Mar		5	3	Documentation typo rtree.html (common -> comma)
3731	code	fixed	2009 Mar	danielk1977	back	2009 Mar		1	1	Corruption caused by "INSERT INTO ... SELECT" + AFTER INSERT trigger
3734	code	active	2009 Mar	danielk1977	back	2009 Mar		3	3	A read/write db connection may connect to a read-only shared cache.
3742	new	active	2009 Mar	aswift		2009 Mar	drh	3	4	Performance improvements for common ORDER BY clauses
3743	code	fixed	2009 Mar	drh	back	2009 Mar		1	1	Lookaside memory allocator incompatible with shared cache
3744	code	fixed	2009 Mar	anonymous	test	2009 Mar		1	1	sqlite-3.6.11 segfaults in make test
3749	new	active	2009 Mar	anonymous		2009 Mar		5	4	Condition for indexes
3757	code	fixed	2009 Mar	drh	front	2009 Mar		1	1	Query optimizer cost estimation on IN operators can be improved.
3759	build	fixed	2009 Mar	anonymous		2009 Mar		1	1	Error Compiling with Borland BCC
3761	code	fixed	2009 Mar	drh	back	2009 Mar		1	1	ROLLBACK after incremental_vacuum causes database corruption
3762	code	fixed	2009 Mar	drh	back	2009 Mar		1	1	ROLLBACK after incremental_vacuum causes database corruption (2)
3766	code	fixed	2009 Apr	drh	front	2009 Apr		4	1	pzTail pointer set incorrectly on the sqlite3_prepare16_v2() interface
3769	code	fixed	2009 Apr	drh	func	2009 Apr		1	1	The %s format in strftime() fails after 2038-01-19 03:14:07
3773	code	fixed	2009 Apr	anonymous		2009 Apr		1	3	bug which may leads to segmentation fault in sqlite
3774	code	fixed	2009 Apr	anonymous	back	2009 Apr		2	3	select count(*) from sqlite_master fails on new database
3775	doc	fixed	2009 Apr	anonymous		2009 Apr		4	4	SQLITE_LOCKED_SHAREDCACHE missing from constlist.html
3777	code	fixed	2009 Apr	anonymous	back	2009 Apr		1	1	CREATE TABLE with a UNIQUE column causes bus error (sigbus) on SPARC
3780	code	fixed	2009 Apr	drh	front	2009 Apr		4	1	The reverse_unordered_sorts pragma does not always work.
3781	code	fixed	2009 Apr	anonymous	vfs	2009 Apr		4	4	Wrong assert in unixOpen()
3791	code	fixed	2009 Apr	drh	front	2009 Apr		1	1	INSERT into table with DEFAULT column value segfaults.
3793	code	fixed	2009 Apr	anonymous	back	2009 May	danielk1977	2	3	SQLite assert indicates BtShared object points to wrong db connection
3801	code	fixed	2009 Apr	anonymous	test	2009 Apr		4	4	temptrigger.test is run when compiled with SQLITE_OMIT_SHARED_CACHE
3804	code	fixed	2009 Apr	anonymous	vfs	2009 Apr	shane	1	1	Access violation on WinCE
3805	website	fixed	2009 Apr	anonymous		2009 Apr		1	2	CREATE VIRTUAL TABLE doesn't work anymore
3806	code	fixed	2009 Apr	anonymous		2009 Apr		3	3	GROUP_CONCAT treats empty strings as NULL sometimes
3807	code	fixed	2009 Apr	drh	front	2009 Apr		1	1	Malformed SQL causes crash
3808	code	fixed	2009 Apr	anonymous		2009 Apr		3	1	strftime conversion regression
3809	code	fixed	2009 Apr	anonymous		2009 Apr		1	2	Reverse behavior of SQLITE_HAVE_ISNAN
3811	code	fixed	2009 Apr	anonymous		2009 Apr		1	2	journal_mode=off and locking_mode inconsistency
3813	code	fixed	2009 Apr	anonymous	func	2009 Apr		2	2	func.c uses sqlite3_aggregate_count() despite SQLITE_OMIT_DEPRECATED
3815	doc	fixed	2009 Apr	anonymous		2009 Apr		1	3	sqlite3_interrupt() can interrupt queries started after its return
3821	code	fixed	2009 Apr	anonymous	vfs	2009 Apr	shane	1	3	Incorrect handling of hot journals on Windows
3824	code	fixed	2009 Apr	anonymous	front	2009 Apr		1	3	Select with order by in some conditions
3828	code	fixed	2009 Apr	drh	front	2009 Apr		3	1	EXPLAIN QUERY PLAN confuses sqlite3_complete()
3830	doc	fixed	2009 Apr	anonymous	test	2009 Apr		4	4	blob.test test numbers out of sequence
3832	code	fixed	2009 May	drh	front	2009 May		1	1	assertion fault on an INSERT with a BEFORE trigger
3838	code	fixed	2009 May	drh	front	2009 May		1	1	DEFAULT VALUE incorrect on UTF16 database
3840	warn	active	2009 May	anonymous	build	2009 May		3	4	Missing header files in amalgamation
3841	code	fixed	2009 May	anonymous		2009 May		1	1	group_concat bug with subselect
3843	warn	fixed	2009 May	anonymous	build	2009 May		4	2	Compiler warning inside sqlite-amalgamation
3857	code	active	2009 May	anonymous		2009 May		3	3	Lemon parser generator: No configurable location for lempar.c
3860	build	fixed	2009 May	anonymous	build	2009 May		1	2	Compilation fails with Apples llvm-gcc-4.2
3862	code	fixed	2009 May	anonymous		2009 May	drh	5	5	debug code checked in [6642]
3863	code	fixed	2009 May	drh	front	2009 May		4	1	Memory leak following ill-formed SQL
3865	code	fixed	2009 May	drh	back	2009 May		1	1	Database corruption following VACUUM on >4GiB database file
3867	code	fixed	2009 May	anonymous	cli	2009 May		4	4	dump of certain database creates sqlite_sequence insertion too early
3869	code	fixed	2009 May	anonymous	front	2009 May		1	3	Alignment error on HP-UX 11.23/IA, 11.31/IA
3870	doc	fixed	2009 May	anonymous		2009 May		5	3	total_change_count documentation typo
3872	code	fixed	2009 May	drh	back	2009 May		1	1	Incomplete shutdown of the default pcache implementation
3875	code	fixed	2009 May	anonymous		2009 May		4	3	Changes in error reporting for function registration
3876	doc	fixed	2009 May	anonymous		2009 May		4	3	Documentation for sqlite3_create_function and H16124
3879	code	fixed	2009 May	anonymous	front	2009 May		1	4	Rows lost in sort
3883	code	fixed	2009 May	anonymous	back	2009 May		1	1	TOCTOU pager bug in 3.6.14.2
3887	code	fixed	2009 May	drh	front	2009 May		4	1	Collating sequence ignore for min()/max() with more than 32 arguments
3888	code	fixed	2009 May	anonymous		2009 May	drh	5	5	Typo in [6994]
3891	code	fixed	2009 May	anonymous	cli	2009 May		3	3	NULL-dereference after failed realloc, and leak
3893	code	fixed	2009 Jun	anonymous	front	2009 Jun		1	1	Double quotes are not handled properly in subqueries
3901	code	fixed	2009 Jun	drh	front	2009 Jun		2	1	LIKE of indexed non-text column in WHERE clause gives incorrect answer
3902	code	review	2009 Jun	anonymous	front	2009 Jun		3	2	The PRAGMA full_column_names is not working
3904	code	fixed	2009 Jun	drh	front	2009 Jun		2	1	Assertion fault with reverse_unordered_selects pragma
3908	code	fixed	2009 Jun	anonymous	back	2009 Jun		4	4	SQLITE_OPEN_READONLY and :memory: database allow write operations on d
3911	code	fixed	2009 Jun	drh	front	2009 Jun		3	1	Memory leak on SELECT statements with subquery in FROM clause
3912	code	fixed	2009 Jun	anonymous		2009 Jun		1	1	tokenize.c: variable declared after beginning of block
3913	code	active	2009 Jun	anonymous	tcl	2009 Jun		4	4	Some variables in bubble-generator.tcl are being used before being set
3914	code	fixed	2009 Jun	anonymous	back	2009 Jun	shane	4	4	Linkage error in where.c when compiled with SQLITE_OMIT_VIRTUALTABLE
3922	code	fixed	2009 Jun	drh	back	2009 Jun		1	1	Incorrect string to numeric conversion of -9223372036854775809
3923	code	fixed	2009 Jun	anonymous	func	2009 Jun		2	4	group_concat includes null if first in the groiup
3924	doc	fixed	2009 Jun	anonymous	back	2009 Jun		4	4	Comment in expr.c doesn't make sense
3925	doc	fixed	2009 Jun	anonymous	vfs	2009 Jun		4	4	More clarity needed around VFS xOpen & xClose methods.
3928	code	fixed	2009 Jun	anonymous	front	2009 Jun	drh	2	1	integer primary key autoincrement & sqlite_sequence Datum
3933	code	fixed	2009 Jun	anonymous	cli	2009 Jul		1	1	pthread_create 's return value is not determine.
3942	code	fixed	2009 Jul	danielk1977	back	2009 Jul	danielk1977	1	1	Commiting transaction with active selects drops all shared-cache locks
3947	code	fixed	2009 Jul	anonymous	front	2009 Jul		1	1	Bug in triggers
3965	code	fixed	2009 Jul	drh	back	2009 Jul		1	1	IN operator combined with zeroblob() yields wrong answer.
3968	code	fixed	2009 Jul	anonymous	back	2009 Jul		4	3	ignored error
3973	warn	fixed	2009 Jul	anonymous	func	2009 Jul	danielk1977	5	5	sqlite3ExprListDup assigns to but does not use pNewExpr
3975	code	fixed	2009 Jul	anonymous	test	2009 Jul	shane	4	4	tableapi.test section 3 runs when compiled with SQLITE_OMIT_GET_TABLE
3981	doc	fixed	2009 Jul	anonymous	front	2009 Jul	paul	1	1	Source file "sqlite3.c":the comment about how many lines for sqlite3.h
3987	code	active	2009 Jul	anonymous		2009 Jul		4	3	limit + order by speed
3988	code	fixed	2009 Jul	anonymous	test	2009 Jul		4	4	vacuum2 test does not handle OMIT_INCRBLOB properly
3989	code	active	2009 Jul	anonymous	test	2009 Jul		4	4	lock3 has funky filepath causing problems on windows
3991	xplatform	fixed	2009 Jul	anonymous	vfs	2009 Aug	shane	2	3	Windows CE fix for Microsoft ARM emulator, code simplification
3992	code	fixed	2009 Jul	anonymous	front	2009 Jul		2	1	CHECK constraint one column one effects unrelated second column
3998	new	active	2009 Jul	anonymous	func	2009 Aug		3	3	Optimization for UPDATE statement
4008	new	active	2009 Aug	anonymous	func	2009 Aug		1	1	2-digit year number in strftime() function by new 'y' switch
4009	code	active	2009 Aug	anonymous		2009 Aug		2	1	group_concat too slow
4010	code	active	2009 Aug	anonymous	back	2009 Aug		4	4	review design decision on JOURNAL_CHUNKSIZE in memjournal.c
4011	code	fixed	2009 Aug	anonymous	vfs	2009 Aug	shane	3	3	mutexes are not freed when using sqlite on windows
4022	code	fixed	2009 Aug	anonymous	vfs	2009 Aug		1	3	Large file support is disabled due to placement of definitions
4027	warn	fixed	2009 Aug	anonymous		2009 Aug		4	4	GCC warning.
4028	doc	fixed	2009 Aug	anonymous		2009 Aug		5	4	typo in blob_open.html
4029	doc	fixed	2009 Aug	anonymous		2009 Aug		5	4	typo in result_blob.html
4039	warn	fixed	2009 Aug	anonymous	back	2009 Oct		3	3	Invalid address in unixWrite() and sqlite3MemSize() on MacOSX

Rows: 1439

sqlite - All unclosed tickets