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