Small. Fast. Reliable.
Choose any three.

This information is obsolete. You are looking at the CVSTrac source management system display for SQLite that was replaced by Fossil on 2009-08-11. The information shown here has not been updated since that cut-over. These pages are retained for historical reference only.

Key: Active Review Fixed Tested Deferred Closed
# Type Status Created By Subsys Changed Assigned Svr Pri Title
4047 build closed 2009 Dec anonymous ext 2009 Dec danielk1977 1 1 FTS3 Select match crash
4046 code closed 2009 Dec anonymous cli 2009 Dec   4 4 Command-line id displayed incorrectly
4045 doc closed 2009 Dec anonymous   2009 Dec   3 2 Missing documentation for "PRAGMA ignore_check_constraints"
4044 code closed 2009 Nov anonymous   2009 Nov   5 3 For Wince Patch Or Dll ?
4043 code closed 2009 Oct anonymous   2009 Oct   1 1 x NATURAL JOIN x BUG
4042 code closed 2009 Oct anonymous   2009 Oct   3 3 Tests from icu.test fail in SQLite 3.6.19
4041 code closed 2009 Oct anonymous   2009 Oct   1 1 sqlite3_create_function and INDEXED column values
4040 code closed 2009 Sep anonymous front 2009 Oct   3 4 sqlite3_bind_text( , , NULL, 0, ) binds null not the empty string
4039 warn fixed 2009 Aug anonymous back 2009 Oct   3 3 Invalid address in unixWrite() and sqlite3MemSize() on MacOSX
4038 doc closed 2009 Aug anonymous   2009 Sep   4 4 Documentation error
4037 code closed 2009 Aug anonymous front 2009 Nov   2 3 unsupported syntax: databasename.tablename.*
4036 new closed 2009 Aug anonymous back 2009 Oct   4 3 Especial Use of BackSlach characters
4035 warn closed 2009 Aug anonymous ext 2009 Oct   4 3 Fix for compiler warning in fts3.c
4034 code closed 2009 Aug anonymous front 2009 Sep   4 4 EXPLAIN changes settings
4033 code closed 2009 Aug anonymous   2009 Aug   1 1 Can not INSERT INTO (with WHERE TEST)
4032 new closed 2009 Aug anonymous   2009 Oct   5 3 Create TableObject future
4031 doc closed 2009 Aug anonymous   2009 Aug   4 4 Document behavoir of SQLITE_OMIT_INCRBLOB compiler flag
4030 code closed 2009 Aug anonymous back 2009 Aug   3 3 Checkin 6906 has unintended side affect in how zero blobs are stored
4029 doc fixed 2009 Aug anonymous   2009 Aug   5 4 typo in result_blob.html
4028 doc fixed 2009 Aug anonymous   2009 Aug   5 4 typo in blob_open.html
4027 warn fixed 2009 Aug anonymous   2009 Aug   4 4 GCC warning.
4026 build closed 2009 Aug anonymous build 2009 Aug   2 3 Error when compiling for Windows CE
4025 warn closed 2009 Aug anonymous back 2009 Oct   3 3 Add assertions to createVarMap
4024 new closed 2009 Aug anonymous back 2009 Oct   4 3 createVarMap race condition fix
4023 code closed 2009 Aug anonymous   2009 Aug   3 3 Error when connect to SQLite on Linux platform
4022 code fixed 2009 Aug anonymous vfs 2009 Aug   1 3 Large file support is disabled due to placement of definitions
4021 website closed 2009 Aug anonymous   2009 Sep   5 4 List of well know users
4020 code closed 2009 Aug anonymous   2009 Oct   5 4 sqlite3FindFunction() - too long loop
4019 build closed 2009 Aug anonymous build 2009 Oct   3 2 Configure clean is not enough
4018 code closed 2009 Aug anonymous vfs 2009 Oct   1 1 File handle leak
4017 code closed 2009 Aug anonymous   2009 Aug   1 1 "SELECT OR IGNORE" causes insert!
4016 build closed 2009 Aug anonymous build 2009 Aug   3 2 `make install` rebuilds SQLite
4015 code closed 2009 Aug anonymous test 2009 Aug   4 4 test1.c needs to test for SQLITE_OMIT_DEPRECATED
4014 new closed 2009 Aug anonymous front 2009 Aug   4 4 Special Caracter '\' doesn't work!
4013 doc closed 2009 Aug anonymous tcl 2009 Aug   5 4 http://www.sqlite.org/tclsqlite.html#profile is not defined
4012 new closed 2009 Aug anonymous back 2009 Oct   3 2 Drop tables/indexes in the presence of active statements
4011 code fixed 2009 Aug anonymous vfs 2009 Aug shane 3 3 mutexes are not freed when using sqlite on windows
4010 code active 2009 Aug anonymous back 2009 Aug   4 4 review design decision on JOURNAL_CHUNKSIZE in memjournal.c
4009 code active 2009 Aug anonymous   2009 Aug   2 1 group_concat too slow
4008 new active 2009 Aug anonymous func 2009 Aug   1 1 2-digit year number in strftime() function by new 'y' switch
4007 new closed 2009 Aug anonymous func 2009 Aug   1 1 New group_split() function as inverse of group_concat()
4006 new closed 2009 Aug anonymous back 2009 Aug   3 3 PRAGMA to define journal location
4005 code closed 2009 Jul anonymous   2009 Oct   3 4 sqlite3AtoF() returns incorrect value for "7.4576373809917618"
4004 new closed 2009 Jul anonymous   2009 Nov   5 2 Implement a "counter" SQL function
4003 code closed 2009 Jul anonymous func 2009 Oct   3 5 wrong rounding
4002 new closed 2009 Jul anonymous back 2009 Oct   5 4 PRAGMA to force all tables to use AUTOINCREMENT behavior
4001 code closed 2009 Jul anonymous func 2009 Oct   1 1 "SQL error: database table is locked" for user function
4000 code closed 2009 Jul anonymous front 2009 Jul   1 1 Bug in column names and returned data with subselect
3999 code closed 2009 Jul anonymous   2009 Jul danielk1977 3 3 FTS3 : Use other separator than space for matches in offsets function
3998 new active 2009 Jul anonymous func 2009 Aug   3 3 Optimization for UPDATE statement
3997 code closed 2009 Jul anonymous front 2009 Jul danielk1977 2 1 sqlite3_create_collation doesn't work or specified collation not used
3996 new closed 2009 Jul anonymous ext 2009 Jul   5 3 fts3 syntax: case insensitive column names
3995 new closed 2009 Jul anonymous ext 2009 Jul   5 3 fts3 legacy syntax: whitespace before '-' prefix
3994 code closed 2009 Jul anonymous   2009 Oct   2 2 REPLACE statements fail on FTS3 tables when data already exists
3993 warn closed 2009 Jul anonymous   2009 Sep   2 2 warnings in 3.6.16
3992 code fixed 2009 Jul anonymous front 2009 Jul   2 1 CHECK constraint one column one effects unrelated second column
3991 xplatform fixed 2009 Jul anonymous vfs 2009 Aug shane 2 3 Windows CE fix for Microsoft ARM emulator, code simplification
3990 code closed 2009 Jul anonymous vfs 2009 Oct   1 1 bus error on sparc arch
3989 code active 2009 Jul anonymous test 2009 Jul   4 4 lock3 has funky filepath causing problems on windows
3988 code fixed 2009 Jul anonymous test 2009 Jul   4 4 vacuum2 test does not handle OMIT_INCRBLOB properly
3987 code active 2009 Jul anonymous   2009 Jul   4 3 limit + order by speed
3986 code closed 2009 Jul anonymous front 2009 Jul   3 3 EXPLAIN causes Segmentation Fault
3985 code closed 2009 Jul anonymous test 2009 Jul   4 4 capi3c.test does not test for SQLITE_OMIT_UTF16
3984 doc closed 2009 Jul anonymous   2009 Oct   3 3 Requirement H13015 does not specify value for pzTail
3983 code closed 2009 Jul sdwilsh build 2009 Jul   2 2 SQLITE_API not used in sqlite3.h
3982 new closed 2009 Jul anonymous front 2009 Oct   2 1 'INSERT OR REPLACE' changes rowid
3981 doc fixed 2009 Jul anonymous front 2009 Jul paul 1 1 Source file "sqlite3.c":the comment about how many lines for sqlite3.h
3980 code closed 2009 Jul anonymous   2009 Jul   1 3 Primary key with NULL not enforced
3979 code closed 2009 Jul anonymous   2009 Oct   2 3 DISTINCT performance
3978 code closed 2009 Jul danielk1977 ext 2009 Jul   1 1 Asynchronous IO is incompatible with multi-file transactions
3977 todo closed 2009 Jul danielk1977   2009 Jul danielk1977 3 3 Defining SQLITE_OMIT_INCRBLOB breaks sqlite3_result_zeroblob()
3976 code closed 2009 Jul anonymous test 2009 Jul danielk1977 4 4 savepoint does not handle SQLITE_OMIT_INCRBLOB properly
3975 code fixed 2009 Jul anonymous test 2009 Jul shane 4 4 tableapi.test section 3 runs when compiled with SQLITE_OMIT_GET_TABLE
3974 new closed 2009 Jul anonymous front 2009 Oct   4 3 support for SQL:2008 <result offset clause> and <fetch first clause>
3973 warn fixed 2009 Jul anonymous func 2009 Jul danielk1977 5 5 sqlite3ExprListDup assigns to but does not use pNewExpr
3972 code closed 2009 Jul anonymous ext 2009 Jul danielk1977 3 3 zNew is used uninitialized in getNextString if !zTemp
3971 code closed 2009 Jul anonymous back 2009 Oct   4 4 TRACE error in btree.c when page is null
3970 code closed 2009 Jul anonymous ext 2009 Jul   5 4 Rtree gives poor error message with column named index
3969 doc closed 2009 Jul anonymous   2009 Jul   3 3 jump is a keyword?
3968 code fixed 2009 Jul anonymous back 2009 Jul   4 3 ignored error
3967 code closed 2009 Jul anonymous func 2009 Jul anonymous 3 2 sqlite3_mprintf
3966 code closed 2009 Jul anonymous cli 2009 Oct   1 3 sqlite shell does not return fail status from fail during .import
3965 code fixed 2009 Jul drh back 2009 Jul   1 1 IN operator combined with zeroblob() yields wrong answer.
3964 code closed 2009 Jul anonymous front 2009 Jul   1 1 Delete trigger error
3963 code closed 2009 Jul anonymous ext 2009 Oct danielk1977 1 1 the icu tokenizer of fts3 does not work properly under some situation.
3962 code closed 2009 Jul anonymous back 2009 Jul   1 1 Can't ATTACH encrypted database
3961 code closed 2009 Jul anonymous vfs 2009 Jul drh 1 1 database is locked error while using linux kernel above 2.6.28
3960 code closed 2009 Jul danielk1977 ext 2009 Jul danielk1977 1 1 crash in fts3 with (... MATCH '1-2.3')
3959 code closed 2009 Jul anonymous func 2009 Jul   1 1 The time which is returned by datetime("now", "utc") is earlier.
3958 code closed 2009 Jul anonymous back 2009 Jul   4 3 Quering out the rowid works diferent
3957 code closed 2009 Jul anonymous front 2009 Jul   4 4 CONSTRAINT PRIMARY KEY don't respect the given name
3956 code closed 2009 Jul anonymous front 2009 Jul   2 1 PRIMARY KEY index not created
3955 build closed 2009 Jul anonymous   2009 Oct   3 2 Compilation errors on GCC4.4.0 (My case: MinGW32)
3954 code closed 2009 Jul anonymous   2009 Jul   1 1 SELECT date('now') returns previous days date after midnight
3953 new closed 2009 Jul anonymous front 2009 Oct a.rottmann 3 5 create view from SQL with noname expressions generates unusable names
3952 new closed 2009 Jul anonymous   2009 Jul   5 4 Feature request: sqlite3_create_function_v2()
3951 code closed 2009 Jul anonymous   2009 Oct   3 1 tkt3922.2 and tkt3922.3 tests fail
3950 code closed 2009 Jul anonymous vfs 2009 Oct   2 3 sqlite3_last_insert_rowid returns the wrong rowid
3949 code closed 2009 Jul anonymous   2009 Jul   1 1 About COMMIT and ROLLBACK
3948 new closed 2009 Jul anonymous func 2009 Jul   5 2 Add contextRealloc function similar to contextMalloc
3947 code fixed 2009 Jul anonymous front 2009 Jul   1 1 Bug in triggers
3946 code closed 2009 Jul anonymous back 2009 Oct   3 4 Error return from VFS xUnlock ignored
3945 code closed 2009 Jul anonymous   2009 Jul   1 1 select error
3944 code closed 2009 Jul anonymous front 2009 Jul danielk1977 1 3 Access violation in sqlite3AuthRead
3943 build closed 2009 Jul anonymous build 2009 Oct   4 4 Problems when linking a not-threaded program to a shared sqlite
3942 code fixed 2009 Jul danielk1977 back 2009 Jul danielk1977 1 1 Commiting transaction with active selects drops all shared-cache locks
3941 code closed 2009 Jul anonymous func 2009 Jul drh 4 1 incorrect result on group_concat() function
3940 code closed 2009 Jul anonymous build 2009 Jul   1 1 3.6.16 won't link if SQLITE_OMIT_AUTOVACUUM is defined.
3939 code closed 2009 Jul anonymous   2009 Jul   3 3 Dropping a table with open statements fails
3938 code closed 2009 Jun anonymous test 2009 Oct   3 3 v 3..6.16 do not pass unit tests: 'make test'
3937 code closed 2009 Jun anonymous vfs 2009 Oct   2 3 Cygwin 1.7 compatibility patch
3936 warn closed 2009 Jun anonymous build 2009 Oct   4 3 Newer libtool needs LT_INIT
3935 code closed 2009 Jun anonymous front 2009 Jul   2 3 Error in table alias since 3.6.15
3934 xplatform closed 2009 Jun anonymous   2009 Jul   1 1 shocking difference between filesystem
3933 code fixed 2009 Jun anonymous cli 2009 Jul   1 1 pthread_create 's return value is not determine.
3932 doc closed 2009 Jun anonymous front 2009 Jun   4 3 Accent grave (`) does not appear supported for table and column names
3931 code closed 2009 Jun anonymous   2009 Jun   1 1 Incorrect query results for SELECT ... WHERE ... IN ((SELECT ...))
3930 warn closed 2009 Jun anonymous front 2009 Jun   1 1 SELECT 0.09 + 0.01 - 0.1 <> 0
3929 code closed 2009 Jun danielk1977 back 2009 Jun danielk1977 1 1 Spurious SQLITE_CORRUPT caused by AFTER INSERT trigger.
3928 code fixed 2009 Jun anonymous front 2009 Jun drh 2 1 integer primary key autoincrement & sqlite_sequence Datum
3927 code closed 2009 Jun anonymous   2009 Jun   4 4 incorrect syntax error message on "select * from Group" query
3926 code closed 2009 Jun anonymous back 2009 Oct   4 4 invalid error message
3925 doc fixed 2009 Jun anonymous vfs 2009 Jun   4 4 More clarity needed around VFS xOpen & xClose methods.
3924 doc fixed 2009 Jun anonymous back 2009 Jun   4 4 Comment in expr.c doesn't make sense
3923 code fixed 2009 Jun anonymous func 2009 Jun   2 4 group_concat includes null if first in the groiup
3922 code fixed 2009 Jun drh back 2009 Jun   1 1 Incorrect string to numeric conversion of -9223372036854775809
3921 xplatform closed 2009 Jun anonymous vfs 2009 Oct   1 4 Sqlite don't work for palm os
3920 new closed 2009 Jun anonymous ext 2009 Oct   1 1 Add callback to sqlite3async about actual file closing
3919 code closed 2009 Jun anonymous ext 2009 Oct   1 1 findLock() in sqlite3async should use filename with full path
3918 code closed 2009 Jun anonymous back 2009 Jun danielk1977 1 1 Bug causing false corruption report.
3917 event closed 2009 Jun anonymous   2009 Oct   1 4 Illegal instruction (core dumped)
3916 code closed 2009 Jun anonymous back 2009 Jun   4 4 unneed assignment in build.c
3915 code closed 2009 Jun anonymous back 2009 Jun   4 4 assert statement repeated in btree.c
3914 code fixed 2009 Jun anonymous back 2009 Jun shane 4 4 Linkage error in where.c when compiled with SQLITE_OMIT_VIRTUALTABLE
3913 code active 2009 Jun anonymous tcl 2009 Jun   4 4 Some variables in bubble-generator.tcl are being used before being set
3912 code fixed 2009 Jun anonymous   2009 Jun   1 1 tokenize.c: variable declared after beginning of block
3911 code fixed 2009 Jun drh front 2009 Jun   3 1 Memory leak on SELECT statements with subquery in FROM clause
3910 build closed 2009 Jun anonymous build 2009 Nov   1 1 DJGPP build errors
3909 code closed 2009 Jun anonymous   2009 Jun   1 1 Check-in [6746] needs pager.c to follow suit
3908 code fixed 2009 Jun anonymous back 2009 Jun   4 4 SQLITE_OPEN_READONLY and :memory: database allow write operations on d
3907 code closed 2009 Jun anonymous   2009 Jun   1 1 wrong result returned with sql query using no table and EXISTS
3906 code closed 2009 Jun anonymous cli 2009 Oct   4 4 patch for mode insert in CLI to preserve number-like strings
3905 build closed 2009 Jun anonymous build 2009 Sep   1 1 Build issue on Solaris with the latest gcc - undefined referenes.
3904 code fixed 2009 Jun drh front 2009 Jun   2 1 Assertion fault with reverse_unordered_selects pragma
3903 doc closed 2009 Jun anonymous   2009 Jun   3 3 Problem with affinities
3902 code review 2009 Jun anonymous front 2009 Jun   3 2 The PRAGMA full_column_names is not working
3901 code fixed 2009 Jun drh front 2009 Jun   2 1 LIKE of indexed non-text column in WHERE clause gives incorrect answer
3900 code closed 2009 Jun anonymous back 2009 Jun   3 4 Execution of sqlite3_mutex_leave without prior sqlite3_mutex_enter
3899 code closed 2009 Jun anonymous   2009 Jun   3 5 Random SQLITE_ERROR returned instead of SQLITE_BUSY
3898 todo closed 2009 Jun anonymous front 2009 Jun   3 4 Expressions are not being converted as expected.
3897 code closed 2009 Jun anonymous   2009 Oct   1 1 Error inserting trough instead of insert trigger using fts3
3896 new closed 2009 Jun anonymous   2009 Oct   3 3 Optional Locking for Virtual Tables
3895 code closed 2009 Jun anonymous back 2009 Jun   1 3 Bus Error on DELETE FROM on hpux-ia64 in 32bit mode (ELF-32)
3894 code closed 2009 Jun anonymous front 2009 Jun   3 3 No such column error when using quoted names in subqueries.
3893 code fixed 2009 Jun anonymous front 2009 Jun   1 1 Double quotes are not handled properly in subqueries
3892 website closed 2009 Jun anonymous   2009 Jun   5 5 typo on download page
3891 code fixed 2009 May anonymous cli 2009 May   3 3 NULL-dereference after failed realloc, and leak
3890 code closed 2009 May anonymous   2009 Jun   1 1 synchronous=full hides newly created table from 2nd connection
3889 todo closed 2009 May anonymous func 2009 May   1 1 UPDATE TRIGGER works in all records
3888 code fixed 2009 May anonymous   2009 May drh 5 5 Typo in [6994]
3887 code fixed 2009 May drh front 2009 May   4 1 Collating sequence ignore for min()/max() with more than 32 arguments
3886 doc closed 2009 May anonymous func 2009 Oct   4 5 Unclear documentation regarding built-in function overriding
3885 build closed 2009 May anonymous   2009 May   1 1 tclsqlite for linux64
3884 code closed 2009 May anonymous back 2009 Jun   1 1 Gettting 'disk image malformed' error
3883 code fixed 2009 May anonymous back 2009 May   1 1 TOCTOU pager bug in 3.6.14.2
3882 code closed 2009 May anonymous back 2009 May   1 3 On sparc/linux, sqlite-3.6.14.x series can generate a bus error.
3881 code closed 2009 May anonymous back 2009 Sep   3 4 zeroblob function causes memory problems
3880 code closed 2009 May anonymous vfs 2009 Oct   1 2 incorrect return value when delete journaling file on WCE.
3879 code fixed 2009 May anonymous front 2009 May   1 4 Rows lost in sort
3878 code closed 2009 May anonymous   2009 May   1 1 lower / lower case problem with UNICODE
3877 code closed 2009 May anonymous func 2009 May   1 5 substr problem
3876 doc fixed 2009 May anonymous   2009 May   4 3 Documentation for sqlite3_create_function and H16124
3875 code fixed 2009 May anonymous   2009 May   4 3 Changes in error reporting for function registration
3874 xplatform closed 2009 May anonymous   2009 Oct   3 2 Missing proper file locking on Hurd
3873 build closed 2009 May anonymous   2009 Oct   1 1 WinCE and Pelles C x64 build errors/warnings
3872 code fixed 2009 May drh back 2009 May   1 1 Incomplete shutdown of the default pcache implementation
3871 code closed 2009 May danielk1977 front 2009 May   1 1 vtab logic fails to optimize some WHERE ... OR ... clauses.
3870 doc fixed 2009 May anonymous   2009 May   5 3 total_change_count documentation typo
3869 code fixed 2009 May anonymous front 2009 May   1 3 Alignment error on HP-UX 11.23/IA, 11.31/IA
3868 code closed 2009 May anonymous   2009 May   1 3 sqlite3AtoF is wrong
3867 code fixed 2009 May anonymous cli 2009 May   4 4 dump of certain database creates sqlite_sequence insertion too early
3866 code closed 2009 May anonymous ext 2009 May anonymous 4 4 Make ext/async/sqlite3async.h includable to C++
3865 code fixed 2009 May drh back 2009 May   1 1 Database corruption following VACUUM on >4GiB database file
3864 code closed 2009 May anonymous   2009 May   2 1 Wrong result set
3863 code fixed 2009 May drh front 2009 May   4 1 Memory leak following ill-formed SQL
3862 code fixed 2009 May anonymous   2009 May drh 5 5 debug code checked in [6642]
3861 code closed 2009 May anonymous func 2009 May a.rottmann 3 1 I am not able to use variables with INSERT
3860 build fixed 2009 May anonymous build 2009 May   1 2 Compilation fails with Apples llvm-gcc-4.2
3859 code closed 2009 May anonymous func 2009 Oct   1 1 sqlite3_prepare returns SQLITE_BUSY but problem is on Windows level
3858 code closed 2009 May danielk1977 back 2009 May danielk1977 1 1 backup db corrupted if source is updated during backup operation
3857 code active 2009 May anonymous   2009 May   3 3 Lemon parser generator: No configurable location for lempar.c
3856 warn closed 2009 May anonymous   2009 Oct   4 1 compiler warning on x86 (Visual Studio 2005)
3855 code closed 2009 May anonymous func 2009 May shane 2 2 Problem width compatibility version 3.6.14 width 3.6.13 (<)
3854 code closed 2009 May anonymous tcl 2009 May   4 4 Tcl Interface does not recognize dbcmd in "sqlite 3 dbcmd name"
3853 secure closed 2009 May anonymous front 2009 Jun   1 1 Crash when inserting
3852 doc closed 2009 May anonymous   2009 Oct   5 4 H35230 requirement refers itself
3851 code closed 2009 May anonymous   2009 May   2 4 Table names no longer enclosed in brackets
3850 new closed 2009 May anonymous test 2009 Oct   5 4 additional test
3849 doc closed 2009 May anonymous func 2009 Oct   5 4 Mispelling in util.c
3848 code closed 2009 May anonymous   2009 Oct   1 1 unable to create a database with shell script running via cron/at
3847 warn closed 2009 May anonymous vfs 2009 May   4 4 Warning on Mac OSX
3846 code closed 2009 May anonymous front 2009 Jul   4 4 join operators without join
3845 doc closed 2009 May anonymous   2009 May sdwilsh 1 1 sqlite3_table_column_metadata
3844 code closed 2009 May anonymous back 2009 May   1 1 Page cache not re-used after a pager_reset()
3843 warn fixed 2009 May anonymous build 2009 May   4 2 Compiler warning inside sqlite-amalgamation
3842 code closed 2009 May anonymous back 2009 May a.rottmann 1 1 Sqlite3_exec is crashing when I am retrieving 1450 plus messages
3841 code fixed 2009 May anonymous   2009 May   1 1 group_concat bug with subselect
3840 warn active 2009 May anonymous build 2009 May   3 4 Missing header files in amalgamation
3839 code closed 2009 May anonymous vfs 2009 Sep   5 3 make internal functions and variables static
3838 code fixed 2009 May drh front 2009 May   1 1 DEFAULT VALUE incorrect on UTF16 database
3837 code closed 2009 May anonymous vfs 2009 Jun adamd 1 1 MissingMethod exception cant find Can't find PInvoke DLL 'sqlite3.dll'
3836 code closed 2009 May anonymous   2009 May   3 3 select * where rowid > 10 fails, but >=10 works
3835 code closed 2009 May anonymous front 2009 May   2 4 "having max()" causes non-aligned pointers being freed
3834 code closed 2009 May anonymous func 2009 Oct   1 1 last_row_id() does not give the right answer
3833 code closed 2009 May anonymous back 2009 Jun   1 3 Concurrent sqlite3OsAccess() and sqlite3OsDelete()
3832 code fixed 2009 May drh front 2009 May   1 1 assertion fault on an INSERT with a BEFORE trigger
3831 code closed 2009 Apr anonymous back 2009 Oct   3 3 Database corrupted during proper usage of sqlite
3830 doc fixed 2009 Apr anonymous test 2009 Apr   4 4 blob.test test numbers out of sequence
3829 code closed 2009 Apr anonymous front 2009 Oct   4 4 invalid join types
3828 code fixed 2009 Apr drh front 2009 Apr   3 1 EXPLAIN QUERY PLAN confuses sqlite3_complete()
3827 doc closed 2009 Apr anonymous cli 2009 Apr   4 5 Type in online help
3826 code closed 2009 Apr anonymous vfs 2009 Oct   2 2 sqlite3VXPrintf optimization suggestions
3825 code closed 2009 Apr anonymous   2009 Oct   2 1 -DTEMP_STORE=3 compile option doesn't work
3824 code fixed 2009 Apr anonymous front 2009 Apr   1 3 Select with order by in some conditions
3823 code closed 2009 Apr anonymous back 2009 Oct   3 3 busy timeout is ignored in shared-cache mode
3822 website closed 2009 Apr anonymous   2009 Apr drh 5 4 Sitemap says "browse bug beports"
3821 code fixed 2009 Apr anonymous vfs 2009 Apr shane 1 3 Incorrect handling of hot journals on Windows
3820 code closed 2009 Apr anonymous front 2009 Oct   4 3 multi-line comments don't work when followed by "." directive
3819 code closed 2009 Apr anonymous front 2009 Oct   2 1 Table was updated but my SQL stmt still generated an error message
3818 code closed 2009 Apr anonymous   2009 Apr   1 1 sq3lite_close segfaults
3817 new closed 2009 Apr anonymous front 2009 Oct   5 4 Function to duplicate prepared statements
3816 build closed 2009 Apr anonymous ext 2009 Oct a.rottmann 1 1 RTREE
3815 doc fixed 2009 Apr anonymous   2009 Apr   1 3 sqlite3_interrupt() can interrupt queries started after its return
3814 code closed 2009 Apr anonymous func 2009 May   1 3 sum function won't work if the "group by" fields heaving unicode data
3813 code fixed 2009 Apr anonymous func 2009 Apr   2 2 func.c uses sqlite3_aggregate_count() despite SQLITE_OMIT_DEPRECATED
3812 code closed 2009 Apr anonymous cli 2009 Oct   1 4 Quotes appears around data when importing exported csv file
3811 code fixed 2009 Apr anonymous   2009 Apr   1 2 journal_mode=off and locking_mode inconsistency
3810 code closed 2009 Apr anonymous back 2009 Oct danielk1977 2 3 SQLITE_ERROR on concurrent CREATE TEMP TRIGGER and sqlite3_close()
3809 code fixed 2009 Apr anonymous   2009 Apr   1 2 Reverse behavior of SQLITE_HAVE_ISNAN
3808 code fixed 2009 Apr anonymous   2009 Apr   3 1 strftime conversion regression
3807 code fixed 2009 Apr drh front 2009 Apr   1 1 Malformed SQL causes crash
3806 code fixed 2009 Apr anonymous   2009 Apr   3 3 GROUP_CONCAT treats empty strings as NULL sometimes
3805 website fixed 2009 Apr anonymous   2009 Apr   1 2 CREATE VIRTUAL TABLE doesn't work anymore
3804 code fixed 2009 Apr anonymous vfs 2009 Apr shane 1 1 Access violation on WinCE
3803 code closed 2009 Apr anonymous build 2009 Sep   3 3 size of sqlite3.c overflows stabs fields making some debugging fail
3802 code closed 2009 Apr anonymous test 2009 Apr   4 4 bindxfer.test fails compiled with SQLITE_OMIT_DEPRECATED
3801 code fixed 2009 Apr anonymous test 2009 Apr   4 4 temptrigger.test is run when compiled with SQLITE_OMIT_SHARED_CACHE
3800 code closed 2009 Apr anonymous cli 2009 Apr   1 1 .genfkey does not work on quoted table names
3799 doc closed 2009 Apr anonymous front 2009 Oct   5 4 Comment is incomplete in where.c
3798 code closed 2009 Apr anonymous   2009 Apr   1 1 segmentation fault on tables with default date column
3797 new closed 2009 Apr anonymous front 2009 Oct   3 3 Not optimal join implementation in some case
3796 new closed 2009 Apr anonymous   2009 Sep   2 3 Async "attach" command
3795 code closed 2009 Apr anonymous func 2009 Apr   4 3 SQLITE returns SQLITE_CONSTRAINT twice on Trigger error.
3794 code closed 2009 Apr anonymous func 2009 Apr   4 3 FAIL on SQL query causes sliqte3 to return SQLITE_CONSTRAINT twice
3793 code fixed 2009 Apr anonymous back 2009 May danielk1977 2 3 SQLite assert indicates BtShared object points to wrong db connection
3792 secure closed 2009 Apr anonymous cli 2009 Sep   3 4 HTML mode does not quote special characters in headers
3791 code fixed 2009 Apr drh front 2009 Apr   1 1 INSERT into table with DEFAULT column value segfaults.
3790 code closed 2009 Apr anonymous build 2009 Apr   3 4 Define SQLITE_OMIT_TRIGGER
3789 todo closed 2009 Apr anonymous   2009 Apr   1 1 Cannot turn INTEGER auto-inc *off*
3788 code closed 2009 Apr anonymous   2009 Apr   2 3 Extremely excessive memory usage and slowness when using 32k page_size
3787 doc closed 2009 Apr anonymous   2009 Apr   5 4 Funny "ah" in http://www.sqlite.org/limits.html
3786 code closed 2009 Apr anonymous   2009 Apr   1 1 sqlite3TriggerList still used despite of SQLITE_OMIT_TRIGGER
3785 code closed 2009 Apr anonymous front 2009 Oct   3 3 cannot join using column oid - column not present in both tables
3784 code closed 2009 Apr anonymous   2009 Apr   3 3 With check-in [6454], "PRAGMA default;" still reports syntax error
3783 code closed 2009 Apr anonymous build 2009 Apr   4 3 notify.c: Missing (void) in procedure defs
3782 new closed 2009 Apr anonymous front 2009 Oct   5 4 parse ADD CONSTRAINT in ALTER TABLE statements
3781 code fixed 2009 Apr anonymous vfs 2009 Apr   4 4 Wrong assert in unixOpen()
3780 code fixed 2009 Apr drh front 2009 Apr   4 1 The reverse_unordered_sorts pragma does not always work.
3779 code closed 2009 Apr anonymous cli 2009 Oct   4 4 sqlite3 .dump sqlite_sequence table details out of sequence for .read
3778 build closed 2009 Apr anonymous   2009 Apr   1 1 SQLITE_OMIT_VIRTUALTABLE - compile error
3777 code fixed 2009 Apr anonymous back 2009 Apr   1 1 CREATE TABLE with a UNIQUE column causes bus error (sigbus) on SPARC
3776 code closed 2009 Apr anonymous cli 2009 Apr anonymous 3 2 when use 'case' in a view, the where subclause is type awared
3775 doc fixed 2009 Apr anonymous   2009 Apr   4 4 SQLITE_LOCKED_SHAREDCACHE missing from constlist.html
3774 code fixed 2009 Apr anonymous back 2009 Apr   2 3 select count(*) from sqlite_master fails on new database
3773 code fixed 2009 Apr anonymous   2009 Apr   1 3 bug which may leads to segmentation fault in sqlite
3772 build closed 2009 Apr anonymous   2009 Apr   1 1 3.6.12 (today's cvs) fails to configure
3771 code closed 2009 Apr danielk1977 front 2009 Apr danielk1977 1 1 Missing OP_VerifyCookie in "<expr> IN (SELECT c FROM t)"
3770 new closed 2009 Apr anonymous front 2009 Oct   3 3 Optimizations
3769 code fixed 2009 Apr drh func 2009 Apr   1 1 The %s format in strftime() fails after 2038-01-19 03:14:07
3768 code closed 2009 Apr anonymous front 2009 Apr   5 4 No syntax error when FROM is mistyped
3767 new closed 2009 Apr anonymous front 2009 Oct   3 4 Significant GROUP BY speed-up
3766 code fixed 2009 Apr drh front 2009 Apr   4 1 pzTail pointer set incorrectly on the sqlite3_prepare16_v2() interface
3765 build closed 2009 Mar anonymous build 2009 Jun anonymous 3 3 Warning during make of amalgamation version 3.6.12
3764 code closed 2009 Mar anonymous ext 2009 Oct   3 4 contrib: extension-functions.c
3763 new closed 2009 Mar anonymous func 2009 Sep dwong 1 1 Database handle for smart pointers
3762 code fixed 2009 Mar drh back 2009 Mar   1 1 ROLLBACK after incremental_vacuum causes database corruption (2)
3761 code fixed 2009 Mar drh back 2009 Mar   1 1 ROLLBACK after incremental_vacuum causes database corruption
3760 code closed 2009 Mar anonymous front 2009 Mar   1 1 Sqlite3 crashes when using the where command on solaris 8
3759 build fixed 2009 Mar anonymous   2009 Mar   1 1 Error Compiling with Borland BCC
3758 build closed 2009 Mar anonymous test 2009 Mar   1 1 Today's 3.6.11 cvs code fails make test
3757 code fixed 2009 Mar drh front 2009 Mar   1 1 Query optimizer cost estimation on IN operators can be improved.
3756 code closed 2009 Mar danielk1977 back 2009 Mar danielk1977 1 1 Obscure way to corrupt pointer page in auto-vacuum mode.
3755 code closed 2009 Mar anonymous   2009 Mar   1 4 out-of-memory trying to fetch a column value in sqlite3
3754 xplatform closed 2009 Mar anonymous   2009 Oct   5 3 MySQL syntax compatibility: AUTO_INCREMENT as alias of AUTOINCREMENT
3753 build closed 2009 Mar anonymous test 2009 Mar danielk1977 1 1 3.6.12 (today's cvs) fails make test
3752 new closed 2009 Mar anonymous   2009 May   3 3 Provide a method to override assert in SQLite
3751 code closed 2009 Mar mlcreech   2009 Mar danielk1977 2 4 I/O error using journal_mode = TRUNCATE
3750 new closed 2009 Mar anonymous   2009 Jul   5 4 Use other separator than space for matches in offsets function of FTS3
3749 new active 2009 Mar anonymous   2009 Mar   5 4 Condition for indexes
3748 build closed 2009 Mar anonymous build 2009 Mar   4 3 "make clean" errors out if doc/lemon.html doesn't exist
3747 build closed 2009 Mar anonymous build 2009 Mar   2 3 "make install" must install libsqlite3.la before libtclsqlite3.la
3746 code closed 2009 Mar anonymous front 2009 Mar   1 2 Bus Error on CREATE TABLE
3745 code closed 2009 Mar danielk1977 back 2009 Mar danielk1977 3 3 Incorrect SQLITE_BUSY return in persistent-journal mode
3744 code fixed 2009 Mar anonymous test 2009 Mar   1 1 sqlite-3.6.11 segfaults in make test
3742 new active 2009 Mar aswift   2009 Mar drh 3 4 Performance improvements for common ORDER BY clauses
3743 code fixed 2009 Mar drh back 2009 Mar   1 1 Lookaside memory allocator incompatible with shared cache
3741 warn closed 2009 Mar anonymous   2009 Oct   4 5 1 = '1'
3740 code closed 2009 Mar anonymous func 2009 Mar   1 1 DB ahngs when doing "pragma integrity_check;"
3739 code closed 2009 Mar anonymous   2009 Mar   2 3 NULL in one of attributes messes up entire query that uses LIKE
3738 code closed 2009 Mar anonymous build 2009 Mar   1 1 compile error due to missing in Makefile.in
3737 build closed 2009 Mar anonymous build 2009 Oct   2 3 [Unix] libsqlite3.so should be linked with -ldl
3736 code closed 2009 Mar anonymous func 2009 Mar   1 3 Bus error in HP-UX B.11.23 Itanium, problem in WhereInfo init ...
3735 code closed 2009 Mar anonymous back 2009 Oct   2 3 DB connections fail to share cache correctly
3734 code active 2009 Mar danielk1977 back 2009 Mar   3 3 A read/write db connection may connect to a read-only shared cache.
3733 code closed 2009 Mar anonymous front 2009 Mar   2 3 Double quotation marks in WHERE-statement works incorrect
3732 build closed 2009 Mar anonymous   2009 Mar   1 1 ./src/shell.c:1101: error: 'sqlite3_backup' undeclared
3731 code fixed 2009 Mar danielk1977 back 2009 Mar   1 1 Corruption caused by "INSERT INTO ... SELECT" + AFTER INSERT trigger
3730 doc fixed 2009 Mar anonymous   2009 Mar   5 3 Documentation typo rtree.html (common -> comma)
3729 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_AUTOVACUUM compile error
3728 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_INCRBLOB compile error
3727 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_XFER_OPT compile error
3726 build closed 2009 Mar anonymous build 2009 Mar   3 4 SQLITE_OMIT_COMPOUND_SELECT compile error
3725 doc closed 2009 Mar anonymous   2009 Mar   5 5 Incorrect diagram on http://www.sqlite.org/lang_createtable.html
3724 code fixed 2009 Mar anonymous cli 2009 Mar   4 4 .rekey command fails silently if sqlite3 doesn't have write access
3723 code fixed 2009 Mar anonymous cli 2009 Mar   3 4 .rekey command requires -key on sqlite3 command line
3722 code closed 2009 Mar anonymous cli 2009 Mar   3 3 buffer overflow in genfkey
3721 new closed 2009 Mar anonymous   2009 Oct   5 4 CAST with custom data types is not very useful
3720 xplatform closed 2009 Mar anonymous front 2009 Mar   4 1 group by doesn't work as it should work (doesn't group aggregates)
3719 code closed 2009 Mar anonymous   2009 Mar danielk1977 3 4 "Create Table As" fails on tables with a specific type of definition.
3718 code fixed 2009 Mar danielk1977 back 2009 May danielk1977 1 1 Race condition in shared cache mode
3717 code closed 2009 Mar anonymous ext 2009 Jun   2 2 Crash when querying fts3 for MATCH '""'
3716 todo closed 2009 Mar anonymous   2009 Mar   1 3 Mac OS X archive not working
3715 code closed 2009 Mar anonymous front 2009 Mar   5 4 How to query table from an encrypted sqlite file?
3714 xplatform closed 2009 Mar anonymous cli 2009 Oct   4 3 sqllite does not accept --help for help
3713 code closed 2009 Mar anonymous   2009 Mar   4 4 ATTACHED Dbase Speed Variation
3712 code closed 2009 Mar anonymous   2009 Mar   1 3 sqlite3.c:40187: sqlite3BtreeCommitStmt: Assertion `pBt->readOnly==0'
3711 new closed 2009 Mar anonymous   2009 Oct   4 3 ATTACH + :memory: + atomic commit
3710 code closed 2009 Mar anonymous func 2009 Mar   5 1 Unable to open the database file
3709 new closed 2009 Mar anonymous back 2009 Sep   5 4 Page locking to improve concurrency for application server
3708 new active 2009 Mar anonymous   2009 Mar   3 4 UNION + ORDER BY
3707 code closed 2009 Mar anonymous func 2009 Mar   1 2 SUBSTR is returning 1 character less than it should
3706 build closed 2009 Mar anonymous build 2009 Mar anonymous 4 3 Make file in sqlite-3.6.11.tar.gz does not compile and link backup.c
3705 code closed 2009 Mar anonymous front 2009 Mar   2 1 ROLLBACK TO SAVEPOINT problem
3704 doc closed 2009 Mar anonymous front 2009 Oct   4 5 Clarify parameter documentation for isLikeOrGlob in where.c
3702 code fixed 2009 Mar anonymous   2009 Mar shane 5 4 Misspelling in sqlite3.c (succesfully instead of successfully)
3701 warn fixed 2009 Mar anonymous func 2009 Mar shane 5 4 compiler warning on x64 (Visual Studio 2005)
3700 doc closed 2009 Mar anonymous   2009 Mar   5 4 mispelling in .../sqlite-3_6_11-docs/lang_indexedby.html
3699 doc closed 2009 Mar anonymous back 2009 Mar   5 5 Clarify parameter documentation for pager_playback_one_page in pager.c
3698 event closed 2009 Mar anonymous front 2009 Mar   1 1 error to create more the one table
3697 build closed 2009 Mar anonymous   2009 Mar   1 1 compiling on solaris-10 fails: undefined symbol: sqlite3_backup
3696 warn fixed 2009 Mar anonymous   2009 Mar   4 3 compile time warning, solaris
3695 build closed 2009 Mar anonymous build 2009 Mar   3 3 sqlite-3.6.11.tar.gz: Outdated configure+Makefile.in
3694 warn closed 2009 Feb anonymous   2009 Oct   3 3 Unpredictable uninitialized variables
3693 new closed 2009 Feb anonymous   2009 Oct   4 4 index_info
3692 new closed 2009 Feb anonymous front 2009 Oct   5 3 New define such as SQLITE_DISABLE_VIEW_ON_ATTACHED_DATABASE
3691 new closed 2009 Feb anonymous tcl 2009 Oct   5 3 persist parameters in views
3690 new closed 2009 Feb anonymous func 2009 Feb shane 5 4 UnEscape function should be there in SQLite
3689 code closed 2009 Feb anonymous   2009 Mar   3 4 amalgamation not building with SQLITE_OMIT_VIRTUALTABLE gcc 4.1.2
3688 code closed 2009 Feb danielk1977 front 2009 Feb danielk1977 1 1 Disappearing temp triggers
3687 new closed 2009 Feb anonymous ext 2009 Oct   1 3 Make genfkey code available in amalgamation
3686 build closed 2009 Feb anonymous build 2009 Feb   4 4 @RELEASE@ isn't set in sqlite3.pc in amalgamation tarball
3685 new closed 2009 Feb anonymous front 2009 Oct   3 3 Enhance INSERT syntax, allowing multiple VALUES
3684 code closed 2009 Feb anonymous   2009 Feb   2 2 db size quadruplicated
3683 code closed 2009 Feb anonymous ext 2009 Nov anonymous 3 4 Broken Query with FTS3
3682 code closed 2009 Feb anonymous   2009 Feb   3 1 strftime format problem
3681 new closed 2009 Feb anonymous front 2009 Oct   1 1 have AUTOINCREMENT in column-indexed statment, not only in column-def
3680 code closed 2009 Feb anonymous back 2009 Jul   1 1 Enormous database file size
3679 code closed 2009 Feb anonymous front 2009 Feb danielk1977 3 3 sqlite3_table_column_metadata fails in havy threading environment
3678 new active 2009 Feb anonymous front 2009 Mar   3 5 index not selected with re-ordered distinct columns
3677 warn closed 2009 Feb anonymous vfs 2009 Feb danielk1977 5 5 os_common.h may have unneeded definition of sqlite3_pending_byte
3676 code closed 2009 Feb anonymous cli 2009 Feb   5 5 SQLite error no such table: syringes
3675 code closed 2009 Feb anonymous back 2009 Feb   3 3 load_extension does not work in trigger
3674 code closed 2009 Feb anonymous func 2009 Feb   1 1 sum() function error
3673 build closed 2009 Feb anonymous build 2009 Oct   2 3 makefile doesn't clean pkgIndex.tcl and sqlite3_analyzer
3672 code closed 2009 Feb anonymous front 2009 Oct   4 4 Inconsistent column names returned
3671 build fixed 2009 Feb anonymous build 2009 Feb   5 4 backup api was not exported in sqlite3.def
3670 new active 2009 Feb anonymous cli 2009 Feb   5 3 Shell: The "backup_timeout" method for backup/restore operations
3669 code fixed 2009 Feb anonymous build 2009 Feb   1 1 maki install error "libtool: install: error: relink `libtclsqlite3.la"
3668 build fixed 2009 Feb anonymous build 2009 Mar   2 3 sqlite3.1 manpage not included in amalgamation tarball
3667 build closed 2009 Feb anonymous build 2009 Feb   4 3 ./configure does not recognize --enable-dynamic-extensions
3666 code active 2009 Feb anonymous   2009 Feb   3 1 softHeapLimitEnforcer called too many times
3665 code closed 2009 Feb anonymous   2009 Feb danielk1977 2 1 sqlite3_errmsg16 returns unaligned string
3664 build fixed 2009 Feb anonymous build 2009 Feb   4 3 [PATCH] Invalid sqlite3.pc generated by build
3663 code fixed 2009 Feb drh back 2009 Feb   2 1 VACUUM changes auto_vacuum=INCREMENTAL into auto_vacuum=FULL
3662 build fixed 2009 Feb anonymous back 2009 Feb   5 3 sqlite3PagerBackupPtr not marked private
3661 code closed 2009 Feb anonymous front 2009 Feb   1 2 ADD COLUMN produces fatal error on a particular table.
3660 code closed 2009 Feb anonymous func 2009 Feb   1 1 SQLite truncates my blob data
3659 build active 2009 Feb anonymous build 2009 Feb   4 3 Building sqlite-tea: TEA version, install location, no tests
3658 code active 2009 Feb anonymous   2009 Feb   1 2 Queries return inconsistent results
3657 build closed 2009 Feb anonymous cli 2009 Feb drh 3 3 Broken again: Oracle and MS-sql command terminator logic
3656 code closed 2009 Feb anonymous   2009 Feb   3 3 Strange behavior on jointure
3655 new closed 2009 Feb anonymous   2009 Feb   5 3 Add month() and year() functions
3654 doc closed 2009 Feb anonymous   2009 Oct   4 4 INSTALL doc should mention libreadline5-dev
3653 secure closed 2009 Feb anonymous   2009 Feb   1 1 how to register
3652 new closed 2009 Feb anonymous   2009 Oct   5 4 possible future compability problem
3651 code fixed 2009 Feb drh front 2009 Feb drh 3 1 Assertion fault on ALTER TABLE ADD COLUMN
3650 doc active 2009 Feb anonymous   2009 Feb   4 3 documentation error in c3ref/changes.html
3649 xplatform closed 2009 Feb anonymous cli 2009 Oct   2 3 sqlite3 hangs in Cygwin rxvt bash shell window
3648 code fixed 2009 Feb drh back 2009 Feb   1 1 DB page written that was not synced to the journal
3647 new active 2009 Feb anonymous front 2009 Feb   4 3 parsing natural join over more than 2 tables is too inefficient
3646 code closed 2009 Feb anonymous front 2009 Feb danielk1977 1 1 can not insert data to table which has field name with space
3645 build closed 2009 Feb anonymous build 2009 Oct   1 1 SQLite 3.6.10 build process is broken on Solaris 10 (again)
3644 code closed 2009 Feb anonymous vfs 2009 Oct   1 1 WinCE: Can't delete files on storage cards when running in Emulator
3643 code closed 2009 Feb anonymous front 2009 Feb   2 3 sqlite_bind_parameter_name() failure
3642 code closed 2009 Feb anonymous vfs 2009 Feb danielk1977 2 3 Journal recovery fails when fcntl stub macro is enabled
3641 code fixed 2009 Feb anonymous   2009 Feb   4 3 group_concat(distinct [field], 'separator') fails
3640 code fixed 2009 Feb shane vfs 2009 Feb shane 1 1 winTruncate() in os_win.c not detecting errors correctly.
3639 new active 2009 Feb anonymous vfs 2009 Feb   3 1 Syntax error doesn't report a line number
3638 code closed 2009 Feb anonymous   2009 Feb   1 1 sqlite command line gets stuck if \q is entered, ctl-c ignored
3637 code closed 2009 Feb anonymous   2009 Feb   1 1 segmentation fail ossurs then execute create table on arm
3636 code closed 2009 Feb danielk1977 back 2009 Feb danielk1977 1 1 Statement/savepoint transaction related crash with journal_mode=off
3635 build closed 2009 Feb anonymous build 2009 Oct   4 4 configure should define SQLITE_ENABLE_COLUMN_METADATA by default
3634 new closed 2009 Feb anonymous   2009 Oct   3 4 imputed column type of functions is not set
3633 code fixed 2009 Feb drh vfs 2009 Feb   3 1 Unchecked return value from write()
3632 event closed 2009 Feb anonymous back 2009 Feb   1 2 Temporary tables are bound on reconnection
3631 build fixed 2009 Feb anonymous vfs 2009 Feb   4 3 sqlite3OsDlSym not marked private
3630 code fixed 2009 Feb anonymous front 2009 Feb   2 4 ALTER TEMP TABLE
3629 doc active 2009 Feb anonymous front 2009 Feb   4 4 No error when selecting inappropriate columns when grouping.
3628 code fixed 2009 Feb drh func 2009 Feb   3 1 SUBSTR off-by-one when 2nd argument is 0
3627 code fixed 2009 Feb drh func 2009 Feb   5 1 The RANDOM() function accepts parameters without giving an error.
3626 code fixed 2009 Feb drh func 2009 Feb   3 1 SUBSTR returns non-NULL when 2nd or 3rd argument are NULL
3625 new fixed 2009 Feb drh func 2009 Feb   4 1 Negative value to 3rd argument of SUBSTR() gives strange answer
3624 code fixed 2009 Feb drh func 2009 Feb   4 1 REPLACE() returns NULL when the second argument is an empty string
3623 code fixed 2009 Jan drh front 2009 Jan   5 1 Misleading error message with coalesce() function
3622 build fixed 2009 Jan anonymous   2009 Feb   3 1 ROLLBACK TO syntax error when compiled with SQLITE_OMIT_ALTERTABLE
3621 xplatform fixed 2009 Jan anonymous test 2009 Feb   4 3 patch to fix sqlite3_mprintf_int in src/test1.c (fails on big-endian)
3620 code closed 2009 Jan danielk1977 back 2009 Jan danielk1977 1 1 Running vacuum on an in-memory database may cause a segfault.
3619 doc fixed 2009 Jan anonymous back 2009 Feb   4 4 obsolete MakeIdxRec opcode references in vdbe.c
3618 code fixed 2009 Jan anonymous func 2009 Jan   2 4 julianday math/rounding issue
3617 doc closed 2009 Jan anonymous   2009 Oct   3 3 Documentation does not discuss PRAGMA collation_list
3616 code fixed 2009 Jan shane   2009 Jan shane 4 4 Lookaside still enabled even if configured buffer size is 0.
3615 code fixed 2009 Jan shane   2009 Jan shane 4 4 filectrl-1.4 test case is failing on Windows.
3614 code fixed 2009 Jan shane   2009 Jan shane 4 4 incrvacuum-15.1 test case failing on Windows
3613 code closed 2009 Jan anonymous   2009 Mar   1 1 core with BUS_ADRALN on HPUX on IA64 Platform
3612 doc fixed 2009 Jan anonymous   2009 Jan   2 5 Double quotes and key-words detection
3611 warn closed 2009 Jan anonymous   2009 Oct   5 5 mingw gcc warnings
3610 warn fixed 2009 Jan anonymous   2009 Jan   5 5 msvc8(2005) warnings whilst compiling
3609 new closed 2009 Jan anonymous   2009 Oct   5 5 New boundary tests dont check for 32bit row id
3608 code closed 2009 Jan anonymous   2009 Jan drh 4 3 delete: alias for table not accepted => delete from tabelle t ...
3607 code closed 2009 Jan anonymous   2009 Mar   1 3 Vista64 + SMB server - journal creation fails (concurrency issue)
3606 code closed 2009 Jan anonymous   2009 Jan anonymous 1 4 page cache unmetch times bigger than read() called times
3605 warn closed 2009 Jan anonymous   2009 Jan   3 3 Possibly incorrect assignment in function pager_playback_one_page
3604 code closed 2009 Jan anonymous   2009 Jan   3 3 getNextToken contains off-by-1 error
3603 code fixed 2009 Jan anonymous   2009 Jan   1 3 Segmentation fault with PRAGMA journal_mode = OFF
3602 code closed 2009 Jan anonymous   2009 Oct   1 1 assert() when executing DELETE statement
3601 code closed 2009 Jan anonymous   2009 Oct   1 1 link failure on Fedora 10 with --enable-load-extension
3600 code active 2009 Jan anonymous   2009 Jan   5 4 Unnecessary ephemeral table
3599 code fixed 2009 Jan anonymous   2009 Jan   4 3 configure --enable-tempstore does not correspond to SQLITE_TEMP_STORE
3598 code fixed 2009 Jan anonymous   2009 Jan   3 3 sqlite3_get_table() does not always initialise its pzErrMsg parameter
3597 code closed 2009 Jan anonymous   2009 Jan   2 1 UTF-8 sorting is inconsistent between sqlite3 shell and Tcl interface.
3596 code closed 2009 Jan anonymous   2009 Oct   4 5 "make test" return errors when SQLITE_DEFAULT_PAGE_SIZE=4096
3595 build closed 2009 Jan anonymous   2009 Jan a.rottmann 1 1 can't execute the make command --> error
3594 code fixed 2009 Jan anonymous   2009 Jan   2 1 tcl interface broken on NetBSD for latest 3.6.10
3593 code closed 2009 Jan anonymous   2009 Oct   2 1 gmake test core dumps in 64-bit build of SQLite3 3.6.10 on Solaris amd
3592 code closed 2009 Jan anonymous   2009 Oct   4 3 sqlite3_changes return last value for drop table
3591 code closed 2009 Jan anonymous   2009 Oct   3 3 Print: "-- Loading resources from ..." in -batch mode
3590 code closed 2009 Jan anonymous   2009 Jan   2 3 unable to use 'release' as column name without quotes
3589 doc closed 2009 Jan anonymous   2009 Oct   4 1 Create a one-file version of the documentation
3588 code fixed 2009 Jan anonymous   2009 Jan   2 3 Small error when compiling sqlite 3.6.9 with gcc on Ubuntu 8.04
3587 code closed 2009 Jan anonymous   2009 Jan   1 1 db collation not working in the tcl interface
3586 code closed 2009 Jan anonymous   2009 Jan   4 3 Unable to build shell in VS6. Plus encryption.
3585 code fixed 2009 Jan anonymous   2009 Jan   5 5 .schema doesn't work with full_column_names=1
3584 code fixed 2009 Jan drh   2009 Jan   1 1 Cache corruption following COMMIT with pending reads
3583 build fixed 2009 Jan anonymous build 2009 Feb danielk1977 3 3 sqlite3.pc not installed with default source tarball
3582 new closed 2009 Jan anonymous   2009 Jan   5 4 ALTER TABLE and FOREIGN KEY support
3581 code fixed 2009 Jan drh   2009 Jan   1 1 Adding an index changes the results of a query
3580 new closed 2009 Jan anonymous   2009 Jan chw 3 5 conect vbscript
3579 doc fixed 2009 Jan anonymous   2009 Jan   4 3 rowset.c missing versioning tags
3578 doc fixed 2009 Jan anonymous   2009 Jan   5 4 Incorrect comment in pragma.c regarding journal_size_limit
3577 code closed 2009 Jan anonymous   2009 Jan drh 3 5 Result of "select string_value || NULL_value from some_table" is NULL
3576 doc closed 2009 Jan anonymous   2009 Jan   4 4 Not a bug
3575 code closed 2009 Jan anonymous   2009 Jan   3 3 Uninitialized memory read in sqlite3VdbeMemShallowCopy
3574 code closed 2009 Jan anonymous   2009 Jan   1 1 isLikeOrGlob denies glob optimization
3573 new closed 2009 Jan anonymous   2009 Jan   3 4 journal_mode = truncate calls unlink(journal_file)
3572 code closed 2009 Jan anonymous   2009 Oct   2 2 BusyTimeout is not being used.
3571 code closed 2009 Jan sdwilsh   2009 Jan   3 4 Crash when compiling SQLite with PGO
3570 code fixed 2009 Jan anonymous   2009 Jan   2 3 create table fail with a database file on the root directory
3569 code closed 2009 Jan anonymous   2009 Oct   3 4 Should Shared-Cache Mode recognize busy timeouts?
3568 code closed 2009 Jan anonymous   2009 Jan   4 4 sqlite3shell.h needs "extern "C" protection for c++ code
3567 doc closed 2009 Jan anonymous   2009 Jan   5 4 sqlite3_create_function invariant H16124 reports incorrect upper bound
3566 code closed 2009 Jan anonymous   2009 Oct   1 1 "unable to open database file" under cygwin build
3565 doc closed 2009 Jan anonymous   2009 Oct   5 4 Unsupported feature addiction
3564 code fixed 2009 Jan anonymous   2009 Jan   1 4 recursive commit_hook problem
3563 new closed 2009 Jan anonymous   2009 Oct   5 4 AUTOINCREMENT FROM i BY j enhancement
3562 new closed 2008 Dec anonymous   2009 Jan   3 3 sqlite3_create_meta_function -- add const to first parameter
3561 code closed 2008 Dec anonymous   2008 Dec   3 3 gcc 4.1.2 complains about illegal char in keywordCode() zText[]
3560 code closed 2008 Dec anonymous   2008 Dec   1 3 join with mis-specified index confuses query planner
3559 doc closed 2008 Dec anonymous   2008 Dec   4 4 Typo in tokenizer specification in ext/fts3/README.tokenizers
3558 code closed 2008 Dec anonymous   2008 Dec   4 4 syntax error : 'bad suffix on number'
3557 new closed 2008 Dec anonymous   2008 Dec   1 4 GUID primary keys
3556 code closed 2008 Dec anonymous   2008 Dec   1 3 Upgrade from 3.6.1 to 3.6.7 under WinCE resulted in Invalid Querys
3555 build closed 2008 Dec anonymous   2009 Oct   3 3 Need to check for and use -ldl
3554 code closed 2008 Dec anonymous   2008 Dec   3 3 before insert trigger odd behavior
3553 code closed 2008 Dec anonymous   2009 Oct   1 3 Bus error with 32bit build on Solaris SPARC
3552 build closed 2008 Dec anonymous   2009 Oct   3 4 shell.exe does not build correctly on windows/ce 5.0
3551 new closed 2008 Dec anonymous   2009 Oct   4 3 pragma table_info, declared collation of the column
3550 code closed 2008 Dec anonymous   2008 Dec   2 3 Problem in ATTACH or DETACH
3549 code closed 2008 Dec danielk1977   2008 Dec danielk1977 1 1 Segfault in rtree code.
3548 code closed 2008 Dec anonymous   2008 Dec   3 3 "count() .. group by" stmt return nothing instead of 0 when no record
3547 code fixed 2008 Dec anonymous   2008 Dec   3 3 LL suffix breaking VC6 build
3546 warn fixed 2008 Dec anonymous   2008 Dec   4 4 Function sqlite3MemJournalSize should have "void" as the default param
3545 code fixed 2008 Dec anonymous   2008 Dec   4 4 Please add (void) to declaration of sqlite3MemJournalSize
3544 code fixed 2008 Dec anonymous   2008 Dec   3 3 Die <Enter SQL statements terminated with a "/">
3543 code closed 2008 Dec anonymous   2008 Dec   2 2 Crash bug in icuOpen()
3542 code fixed 2008 Dec anonymous   2008 Dec   1 1 Reproducable bus error on LP64 alignement critical architecture
3541 code fixed 2008 Dec drh   2008 Dec   1 1 Use of ~ operator on repeated aggregate terms causes incorrect result.
3540 todo closed 2008 Dec anonymous   2008 Dec   1 2 Impossible to determine field type INTEGER PRIMARY KEY using PRAGMA
3539 code closed 2008 Dec anonymous   2008 Dec   3 3 Segmentation/bus error when creating complex view
3538 code closed 2008 Dec anonymous   2009 Oct   1 1 Decimal columns do integer division if no decimal places in numerator
3537 code active 2008 Dec anonymous   2008 Dec   5 4 sqlite3_bind_text + SQLITE_TRANSIENT + different encoding
3536 code fixed 2008 Dec drh   2008 Dec   1 1 Incorrect evaluation of: WHERE rowid>922337236854775807
3535 code closed 2008 Dec anonymous   2008 Dec   2 2 PRIMARY KEY constraint not enforced in case of null values
3534 new closed 2008 Dec anonymous   2009 Oct   4 4 sqlite3_stmt_status api include row change counters.
3533 code closed 2008 Dec anonymous   2009 Oct   1 1 "NULL" string in CSV file is not treated as a NULL value
3532 doc closed 2008 Dec anonymous   2009 Oct   3 3 lang_select.html claims conformance to sql-92 join syntax
3531 code closed 2008 Dec anonymous   2009 Oct   3 4 Command line client hides value types
3530 code fixed 2008 Dec shane   2008 Dec drh 1 3 assertion failure referencing outer correlation in an inner FROM
3529 new closed 2008 Dec anonymous   2009 Oct   3 5 Progress callback not invoked by PRAGMA integrity_check
3528 todo closed 2008 Dec anonymous   2008 Dec   1 4 Crashed ssh session on Xen causes disk I/O error on SQLite query
3527 code fixed 2008 Dec anonymous   2008 Dec   2 3 access violation / segfault when using multiple view subqueries
3526 warn closed 2008 Dec anonymous   2008 Dec   1 1 warnings
3525 build closed 2008 Dec anonymous   2009 Oct   2 2 sqlite3's tcl interface does not build with Tcl 8.6 (patch)
3524 doc closed 2008 Dec anonymous   2009 Oct   5 4 Wish item: examples in documentation
3523 doc closed 2008 Dec anonymous   2009 Oct   4 3 sqlite_docs_<version>.zip changes directory back and forth
3522 code fixed 2008 Dec shane   2008 Dec drh 1 3 assertion with JOIN/USING with correlation
3521 todo closed 2008 Dec anonymous   2008 Dec danielk1977 3 1 memory leak in sqlite3_column_text
3520 code closed 2008 Dec anonymous   2009 Oct   3 2 sqlite3_update_hook isn't called
3519 code fixed 2008 Dec anonymous   2008 Dec   1 1 Crash when deleting from a view
3518 code fixed 2008 Dec anonymous   2008 Dec   1 1 Crashes when building with -DSQLITE_OMIT_BLOB_LITERAL
3517 code fixed 2008 Dec anonymous   2008 Dec   3 2 memory leak in .import handling in shell.c
3516 doc fixed 2008 Dec anonymous   2008 Dec   4 4 Syntax diagram allows HAVING without GROUP BY
3515 code closed 2008 Dec drh   2009 Oct   1 1 INTERSECT operator should have higher precedence
3514 code closed 2008 Nov anonymous   2009 Oct   2 3 sqlite3_analyzer reports weird numbers
3513 code closed 2008 Nov anonymous   2008 Nov   2 2 SQLite crashes with simple invalid SELECT statement.
3512 code fixed 2008 Nov anonymous   2009 Jan   2 1 unknown errno code ENOTSUP used
3511 code closed 2008 Nov anonymous   2009 Oct   3 3 apparent incorrect return constant in do_meta_command
3510 code fixed 2008 Nov anonymous   2008 Nov   3 3 serious warnings from algamation 3.6.6.1 on Windows
3509 code fixed 2008 Nov anonymous   2008 Nov   5 4 spelling errors in sqliteInt.h 1.798
3508 code fixed 2008 Nov anonymous   2008 Nov anonymous 3 4 malformed SQL query causes segfault
3507 code closed 2008 Nov anonymous   2009 Sep   3 3 sqlite3_overload_function ignores errors from sqlite3CreateFunc
3506 build closed 2008 Nov anonymous   2009 Oct   2 3 configure needs to check libthread.so, not just libpthread.so
3505 code closed 2008 Nov anonymous   2009 Oct   1 1 failure with OP_Concat
3504 code closed 2008 Nov anonymous   2008 Nov   5 4 pragma table_info returns quoted text
3503 doc closed 2008 Nov anonymous   2008 Nov   5 5 SELECT documentation uses "as" instead of "has"
3502 doc closed 2008 Nov anonymous   2008 Nov danielk1977 5 5 Compiling genfkey.c without sqlite3.c
3501 code closed 2008 Nov anonymous   2008 Nov   3 3 like-search with german umlaut is case-sensitive, should not be
3500 doc closed 2008 Nov anonymous   2008 Nov   5 4 documentation typo at SQLITE_OMIT_TRIGGER
3499 doc closed 2008 Nov anonymous   2008 Nov   4 3 are registrations by createFunction permanent
3498 code closed 2008 Nov anonymous   2009 Sep   2 3 sqlite3_errmsg and errcode should be per thread
3497 code closed 2008 Nov anonymous   2008 Nov   1 1 FTS3 crash with 3.6.5
3496 code active 2008 Nov anonymous   2008 Nov   4 4 FTS3: simple tokenizer ignores its first argument
3495 code closed 2008 Nov anonymous   2008 Nov   1 1 mem5.c does not compile: POW2_MAX macro removed in [5848]
3494 code fixed 2008 Nov anonymous   2008 Nov   3 3 Low memory assert in sqlite3SelectNew()
3493 code closed 2008 Nov anonymous   2008 Nov   1 1 GROUP BY breaks affinities
3492 code closed 2008 Nov anonymous   2008 Nov a.rottmann 1 1 callback is wrong!
3491 warn fixed 2008 Nov anonymous   2008 Nov   3 3 If statements using "=" instead of "=="
3490 code fixed 2008 Nov anonymous   2008 Nov   1 1 Reading dump causes string errors
3489 doc fixed 2008 Nov anonymous   2008 Nov   4 4 SQLITE_FUNCTION authorizer name passed in wrong parameter
3488 code fixed 2008 Nov anonymous   2008 Nov   3 3 low memory crash in sqlite3VdbeExec()
3487 new closed 2008 Nov anonymous   2009 Oct   3 4 JOIN USING (rowid)?
3486 code closed 2008 Nov anonymous   2008 Nov   1 1 sqlite3MemMalloc post an error
3485 code fixed 2008 Nov anonymous   2008 Nov   3 3 low memory crash in flattenSubquery()
3484 code closed 2008 Nov anonymous   2008 Nov   3 3 Column affinity not always correctly applied to integers
3483 code closed 2008 Nov anonymous   2009 Oct   5 5 Have a cache of prepared statements
3482 code fixed 2008 Nov drh   2008 Nov   1 1 Buffer overrun on UTF-16BE to UTF-8 conversion
3481 code fixed 2008 Nov anonymous   2008 Nov   4 3 Useless mutexIsNT function
3480 build fixed 2008 Nov anonymous   2008 Nov   1 1 Build failure without TCL (--disable-amalgamation)
3479 build closed 2008 Nov anonymous   2008 Nov   2 3 Compile error when SQLITE_MUTEX_NOOP is defined
3478 code fixed 2008 Nov anonymous   2008 Nov   3 3 low memory crash in sqlite3VdbeMakeReady()
3477 doc fixed 2008 Nov anonymous   2008 Nov   5 5 Missing comma in documentation of Create Index...
3476 code fixed 2008 Nov anonymous   2008 Nov   3 1 Print errors to stderr
3475 doc fixed 2008 Nov anonymous   2008 Nov   5 4 Spelling error in documentation of "vacuum" command.
3474 code closed 2008 Nov anonymous   2008 Nov danielk1977 1 1 Memory Leak in sqlite3_close
3473 code closed 2008 Nov anonymous   2008 Nov   3 3 low memory assert in sqlite3VdbeExec()
3472 code closed 2008 Oct anonymous   2009 Oct   3 3 SQLITE_THREAD_OVERRIDE_LOCK depends on first DB accessed by process
3471 code closed 2008 Oct anonymous   2009 Oct   3 4 SQLite does not detect truncated database files well
3470 code closed 2008 Oct anonymous   2008 Oct   3 3 low memory assert in sqlite3_exec() in legacy.c
3469 code closed 2008 Oct anonymous   2008 Oct danielk1977 1 1 Memory Leak in SQL Lite version in Adobe PDF Reader
3468 code closed 2008 Oct anonymous   2008 Oct   3 3 low memory crash in sqlite3ValueFromExpr() in vdbemem.c
3467 code fixed 2008 Oct anonymous   2008 Oct   3 3 low memory assert in multiSelectOrderBy in select.c
3466 code closed 2008 Oct anonymous   2008 Oct   1 1 crash involving prepared statements using virtual tables
3465 code closed 2008 Oct anonymous   2008 Oct   1 1 Bad result in select order with *
3464 code closed 2008 Oct anonymous   2008 Oct   2 5 BOOLEAN type accepts all kinds of values, weird!!!
3463 code closed 2008 Oct anonymous   2008 Oct   1 3 UNIQUE does not work according to SQL 92 standard
3462 code closed 2008 Oct anonymous   2009 Oct   4 3 H10336 is not true
3461 code fixed 2008 Oct anonymous   2008 Nov   2 1 Incorrect query results (when using index?)
3460 new closed 2008 Oct anonymous   2008 Oct   2 1 Can i check if an Input has the rigth format?
3459 code closed 2008 Oct anonymous   2008 Oct   2 1 insert Blob value into sqlite3 db
3458 code closed 2008 Oct anonymous   2008 Oct   4 4 PRAGMA show_table erronous info
3457 code fixed 2008 Oct aswift   2009 Oct drh 3 4 Return error for mismatched permissions on journal file
3456 code closed 2008 Oct aswift   2009 Oct drh 3 3 Add extended error codes for SQLITE_ERROR
3455 code closed 2008 Oct anonymous   2008 Oct   3 3 low-memory assert in sqlite3CreateIndex() in build.c
3454 code closed 2008 Oct anonymous   2008 Oct   3 3 hardcoded 32KB pagesize max may be too low
3453 doc fixed 2008 Oct anonymous   2008 Nov   4 4 pragma.c documention error
3452 new closed 2008 Oct anonymous   2009 Oct   3 3 os_unix.c:unixSectorSize() should use statvfs() to get pref blk size
3451 code closed 2008 Oct anonymous   2008 Oct   3 4 Syntax error creating a trigger using "UPDATE ON (column) OF table"
3450 code closed 2008 Oct anonymous   2009 Oct   3 3 sqlite3 foo.db .dump emits COMMIT; after interrupt
3449 build closed 2008 Oct anonymous   2009 Jan   4 4 configure fails to detect TCL
3448 code closed 2008 Oct anonymous   2008 Oct   3 2 References to ASCII windows routines are not WINCE-guarded
3447 doc fixed 2008 Oct anonymous   2008 Oct   4 4 documentation error in sqlite3_free
3446 code active 2008 Oct anonymous   2008 Oct   2 3 select hex(randomblob(8)) as a, count(*) from Table where b = a;
3445 new closed 2008 Oct anonymous   2009 Oct   5 4 No read-only attached database support
3444 doc fixed 2008 Oct anonymous   2008 Oct shane 1 1 The compile option SQLITE_OMIT_DEPRECATED was not documented yet.
3443 doc closed 2008 Oct anonymous   2008 Oct   3 1 Syntax in BNF?!
3442 code fixed 2008 Oct anonymous   2008 Oct   1 1 Slow memory tables
3441 code fixed 2008 Oct anonymous   2008 Oct   2 4 inconsistent/weird handling of parameters to date/time functions
3440 code closed 2008 Oct anonymous   2008 Oct   1 1 WinCE : unresolved external symbols when link
3439 code fixed 2008 Oct anonymous   2008 Nov   1 1 btree.c: setChildPtrmaps and SQLITE_OMIT_AUTOVACUUM
3438 code fixed 2008 Oct anonymous   2008 Oct drh 1 3 Building amalgamation with Rtree fails
3437 code closed 2008 Oct anonymous   2008 Oct   3 4 subquery not working
3436 new closed 2008 Oct anonymous   2009 Oct   1 1 Provide API method to test for available extensions
3435 code fixed 2008 Oct anonymous   2008 Nov   4 4 vacuum2 regression test does not check for SQLITE_OMIT_AUTOVACUUM
3434 code closed 2008 Oct anonymous   2008 Oct shazow 1 2 crask sqlite with statment "create table " with
3433 build closed 2008 Oct anonymous   2009 Oct   1 1 Sqlite 3.6.3 build test failed
3432 code closed 2008 Oct anonymous   2008 Oct   3 3 ORDER BY doesn't work with single quoted alias
3431 build closed 2008 Oct anonymous   2008 Oct   4 3 Can't compile 3.6.3 (amalgameaed) withIntel compiler on Windows
3430 code fixed 2008 Oct anonymous   2008 Oct   4 2 SQLITE_ENABLE_MEMORY_MANAGEMENT missing from pcache.h
3429 code closed 2008 Oct anonymous   2008 Oct   3 3 sqlite3_column_name returns name of wrong column
3428 code closed 2008 Oct anonymous   2008 Oct   1 3 Possible memory leak in sqlite3_open_v2
3427 build fixed 2008 Oct anonymous   2008 Oct   5 3 RTREE support in Windows binary builds
3426 code closed 2008 Oct anonymous   2008 Oct   1 4 newline in query causes all field types to appear as DBI_TYPE_STRING
3425 code closed 2008 Oct anonymous   2009 Oct   3 3 virtual tables don't play well with .dump
3424 code closed 2008 Oct anonymous   2008 Oct   1 1 Left outer join problem with multi-column indexes matching NULL values
3423 code closed 2008 Oct anonymous   2008 Oct   2 3 SQLite 3.6.3 fails to compile with Visual Studio .NET 2003
3422 code fixed 2008 Oct anonymous   2008 Oct   4 3 Unnecessary use of double in date.c
3421 build fixed 2008 Oct anonymous   2008 Oct   2 3 SQLITE_MUTEX_APPDEF=1 causes undefined symbol when running
3420 build fixed 2008 Oct anonymous   2008 Oct shane 2 3 sqlite doesn't link on Windows/CE
3419 code fixed 2008 Oct anonymous   2008 Oct   2 3 Incorrect SELECT results depending on order of tables
3418 code fixed 2008 Oct anonymous   2008 Oct   5 4 Bind functions lack assert before sqlite3_mutex_enter(p->db->mutex)
3417 secure closed 2008 Oct anonymous   2008 Oct   1 1 bug
3416 code closed 2008 Oct anonymous   2008 Oct   2 3 Can't compile in Visual C++ 2003
3415 code fixed 2008 Oct anonymous   2008 Oct   1 3 winTruncate does no error checking, always returns SQLITE_OK
3414 code closed 2008 Oct anonymous   2008 Oct   1 1 NULL is returned when subtracting
3413 code closed 2008 Oct anonymous   2008 Oct drh 2 4 strftime("%w", "whatever") returns wrong weekday number
3412 new closed 2008 Oct anonymous   2009 Oct   3 1 "primary key" virtual table columns and pragma table_info(table_name)
3411 doc fixed 2008 Oct anonymous   2008 Oct   3 4 datetime '+1 month' returns values outside of next month
3410 code closed 2008 Oct anonymous   2009 Oct   3 4 "ON CONFLICT IGNORE" not completely ignored -- sqlite_sequence updated
3409 build closed 2008 Oct aswift   2008 Oct drh 4 4 bind-9.2 leaks fd with larger SQLITE_MAX_VARIABLE_NUMBER
3408 code closed 2008 Sep anonymous   2008 Oct   1 3 wrong WHERE clause with RowID column
3407 code closed 2008 Sep anonymous   2008 Sep   2 3 Tcl Interface - backslash substitution in strings retrieved from db
3406 code defer 2008 Sep anonymous   2008 Oct   3 4 Error running on dual-core
3405 code fixed 2008 Sep anonymous   2008 Sep danielk1977 1 1 test_async.c unsafely modifies the async queue
3404 code closed 2008 Sep anonymous   2009 Oct   1 3 NaN handling not consistent between architectures on Mac OS X
3403 new closed 2008 Sep anonymous   2009 Oct   4 4 Don't create new database by default when file not found
3402 code closed 2008 Sep anonymous   2008 Sep   4 1 Compiler warning, variable used without being initialized!
3401 code closed 2008 Sep anonymous   2008 Sep   2 3 failure to detect bogus virtual table column usage
3400 event closed 2008 Sep anonymous   2009 Oct   1 4 Core error line ***glibc detected free() *** invalid next size (fast)
3399 code closed 2008 Sep anonymous   2008 Sep   4 4 Bad C function declarations
3398 build closed 2008 Sep anonymous   2008 Sep   1 1 FTS3+ICU compilation
3397 code fixed 2008 Sep aswift   2008 Sep drh 3 3 load libtclsqlite3.dylib fails with tcl 8.5: missing symbol
3396 build fixed 2008 Sep aswift   2008 Sep drh 4 4 tcl 8.5 warns about version number re: require package sqlite3
3395 code fixed 2008 Sep anonymous   2008 Sep   3 3 SQLITE_EXPERIMENTAL on MSVC 2003 causes error
3394 code closed 2008 Sep anonymous   2009 Sep   1 3 Return (error code) of xCurrentTime is always ignored
3393 code closed 2008 Sep anonymous   2009 Oct   3 3 VACUUM destroys certain databases.
3392 code fixed 2008 Sep anonymous   2008 Sep   3 3 Some pcache symbols unintentially public
3391 code closed 2008 Sep anonymous   2009 Oct   3 4 Clang static analyzer finds several warnings
3390 code closed 2008 Sep anonymous   2008 Sep   3 4 sqlite crash on select rowid in sub-select
3389 code closed 2008 Sep anonymous   2008 Sep   1 1 SQLITE_BUSY in spite of calling sqlite3_busy_timeout()
3388 code closed 2008 Sep anonymous   2008 Sep   1 1 sqlite3 says database is locked, for no good reason
3387 code fixed 2008 Sep anonymous   2008 Sep drh 4 3 Workaround for Vista's cache manger
3386 code active 2008 Sep anonymous   2008 Sep   4 4 insert default values does not work at the start of a trigger
3385 code closed 2008 Sep anonymous   2008 Sep   1 3 SELECT DISTINCT and ORDER BY misbehave
3384 code fixed 2008 Sep anonymous   2008 Oct   1 3 Performance regression in 3.6.2 with in memory db
3383 code fixed 2008 Sep anonymous   2008 Sep   4 3 sqlite3PageMalloc lacks a type identifier for parameter
3382 code closed 2008 Sep anonymous   2008 Sep   1 3 Lib crashes then use UNION ALL and ORDER BY
3381 code active 2008 Sep anonymous   2008 Sep   2 1 SELECT DISTINCT returns incorrect results with alias in WHERE expr
3380 code closed 2008 Sep anonymous   2008 Sep   5 5 Timeline shows dates in weird format
3379 code closed 2008 Sep anonymous   2008 Sep   1 1 Full index performance lost with WHERE clausule
3378 code closed 2008 Sep anonymous   2009 Oct   3 2 ORDER BY broken in substr query
3377 code closed 2008 Sep anonymous   2008 Sep   1 3 Compiler errors while trying to compile SQLite amalgamation
3376 code fixed 2008 Sep anonymous   2008 Sep   3 3 SELECT DISTINCT returns incorrect results with collate nocase strings
3375 code closed 2008 Sep anonymous   2009 Jan   1 2 unknown errno code ENOTSUP used
3374 code closed 2008 Sep anonymous   2009 Oct   5 4 insert several times into the same column doesn't fail
3373 code closed 2008 Sep anonymous   2009 Oct   1 3 unixFullPathname poor behaviour with long strings
3372 todo fixed 2008 Sep anonymous   2008 Sep   3 3 Quoted identifiers show incorrect column name in results w/aggregates.
3371 code fixed 2008 Sep rdc   2008 Sep   2 3 wrong column names for queries with aggregate functions
3370 code fixed 2008 Sep rdc   2008 Sep   2 3 wrong results for columns with quoted identifiers
3369 code fixed 2008 Sep anonymous   2008 Sep   5 4 isInterrupted
3368 event closed 2008 Sep anonymous   2009 Oct jenglish 5 1 drop a column form table is not working
3367 doc closed 2008 Sep anonymous   2008 Sep a.rottmann 5 4 Data Base Samples downloads?
3366 secure closed 2008 Sep anonymous   2008 Sep   4 4 I want to register
3365 build closed 2008 Sep anonymous   2008 Sep   3 2 new SQLITE_DEPRECATED and SQLITE_EXPERIMENTAL on MSVC6
3364 code closed 2008 Sep anonymous   2009 Oct   4 4 compiler warnings about potentially uninitialized variables
3363 code closed 2008 Sep anonymous   2008 Sep   1 3 RTree corruption
3362 code tested 2008 Sep anonymous   2008 Sep   1 1 3.6.2 test suite failures on x86_64 (Mandriva Linux)
3361 build closed 2008 Sep anonymous   2008 Sep   1 1 ICU module can't be compiled into SQLite
3360 code active 2008 Sep anonymous   2008 Sep   4 4 undetected ambiguous column name
3359 code closed 2008 Sep anonymous   2008 Sep   1 1 SQlite is inadvertently changing a DOUBLE field
3358 code closed 2008 Sep anonymous   2008 Sep   1 3 segfault in sqlite3ExprAffinity
3357 code closed 2008 Sep anonymous   2008 Sep drh 1 1 Outer join produces garbage result when nested subselect is DISTINCT
3356 new closed 2008 Sep anonymous   2009 Oct drh 5 3 CURRENT_TIMESTAMP Default value
3355 new closed 2008 Sep anonymous   2008 Sep   2 2 Multi-instance support of SQLite Engine
3354 doc closed 2008 Sep anonymous   2009 Oct   1 3 concurrent write access fails on ReiserFS
3353 todo closed 2008 Sep anonymous   2009 Oct   2 3 sqlite3: "no space left on device" error lost when writing .output
3352 build closed 2008 Sep anonymous   2009 Oct   4 4 Makefile does not install the manpage
3351 secure closed 2008 Sep anonymous   2008 Sep   3 3 Insecure use of vsprintf() in lemon.c
3350 code closed 2008 Sep anonymous   2008 Sep   1 2 can't compile 3.6.2 with VC6
3349 code fixed 2008 Sep anonymous   2008 Sep   1 1 Left-over sqlite3PagerAlwaysRollback interface in pager.h
3348 doc closed 2008 Sep anonymous   2008 Sep   4 4 null primary key
3347 build fixed 2008 Sep anonymous   2008 Sep   4 3 _MSC_VER usage for VC6
3346 code fixed 2008 Aug anonymous   2008 Sep drh 1 2 Crash in sqlite3ExprCollSeq
3345 warn fixed 2008 Aug anonymous   2008 Sep   4 3 Override like(X,Y) function with -1 as num of args
3344 build fixed 2008 Aug anonymous   2008 Dec   4 4 Core dump on AIX 5.2, VAC 9.0 with optmization, sqlite 3.6.1
3343 code active 2008 Aug rdc   2009 Jul   1 3 incorrect results for queries using alias names
3342 new closed 2008 Aug aswift   2009 Oct drh 3 4 Allow manual configuration of locking style via sqlite3_file_control
3341 new closed 2008 Aug aswift   2009 Oct drh 3 3 Add support for compile-time mutex config SQLITE_CONFIG_MULTITHREAD
3340 code closed 2008 Aug anonymous   2008 Aug   2 1 how to use Sqlite Source Code in Vb.net Program (without dll files)
3339 code closed 2008 Aug anonymous   2009 Oct   1 1 typo in fts3_icu.c:icuOpen
3338 code closed 2008 Aug anonymous   2009 Oct   2 3 last_insert_rowid() result not correct when operating on FTS3 tables
3337 new closed 2008 Aug aswift   2009 Sep drh 3 3 Need API access to system error codes
3336 code fixed 2008 Aug anonymous   2008 Aug   1 1 Transaction on error return authorizer code instead of trigger error
3335 code fixed 2008 Aug rdc   2008 Aug   1 1 vacuum crashes with :memory: database
3334 code fixed 2008 Aug anonymous   2008 Aug   2 2 Bug in a query returning COUNT(*) with subselect query
3333 code fixed 2008 Aug anonymous   2008 Aug   4 3 Empty bodies of if statements in where.c
3332 todo closed 2008 Aug anonymous   2008 Aug drh 3 3 Switching auto_vacuum settings fails on certain files
3331 code fixed 2008 Aug anonymous   2008 Aug   4 3 Minor problems in printf.c
3330 new active 2008 Aug anonymous   2008 Aug   3 4 faster large updates
3329 code closed 2008 Aug anonymous   2008 Aug   2 1 execute "select 1/2" then return 0 but not 0.5
3328 code fixed 2008 Aug anonymous   2008 Aug pweilbacher 1 2 Temporary file do not deleted under OS/2
3327 doc fixed 2008 Aug anonymous   2008 Aug   5 4 OP_MoveTo
3326 code fixed 2008 Aug anonymous   2008 Aug   3 3 assert() in sqlite3VdbeMemFinalize fires for some queries
3325 code closed 2008 Aug anonymous   2008 Aug   1 1 pcache.c compile error
3324 code fixed 2008 Aug anonymous   2008 Aug   3 3 count with argument is acting odd in a grouped query w/ join
3323 code closed 2008 Aug anonymous   2008 Aug   1 1 pager.c compile error: left-over PGHDR_TO_DATA macro
3322 code closed 2008 Aug anonymous   2008 Aug   1 1 dropoing table will drop from an attached database
3321 new closed 2008 Aug anonymous   2009 Oct   5 4 Investigate Transactional NTFS on Vista
3320 code closed 2008 Aug anonymous   2008 Aug   1 1 pragma table_info() gives erroneous results in some cases
3319 code closed 2008 Aug anonymous   2008 Aug   3 2 Incorrect references to SQLITE_MAX_ATTACH in main.c
3318 code fixed 2008 Aug anonymous   2008 Sep   1 1 Bus Error for any operation on sparc64
3317 code closed 2008 Aug anonymous   2009 Oct drh 1 1 crash in sqlite3BtreeParseCellPtr
3316 code closed 2008 Aug anonymous   2008 Aug   1 1 Transaction does not work.
3315 build closed 2008 Aug anonymous   2009 Oct   3 3 configure "--enable-load-extension" doesn't work "--without-tcl"
3314 code closed 2008 Aug anonymous   2008 Aug   3 3 "ORDER BY term number 1 does not match any result column" during UNION
3313 build closed 2008 Aug anonymous   2008 Aug   3 4 Compiling for VxWorks
3312 code closed 2008 Aug anonymous   2008 Sep   3 3 rtreeBestIndex never sets estimatedCost
3311 code closed 2008 Aug anonymous   2008 Aug   1 1 crash in pager_recycle
3310 code active 2008 Aug anonymous   2008 Aug   3 4 VFS xClose docs need update, code ignores returns mostly
3309 warn fixed 2008 Aug anonymous   2008 Aug   3 3 Compiler warnings: "X shadows Y"
3308 code fixed 2008 Aug anonymous   2008 Aug   3 4 compatibility issue with RowID column name
3307 code closed 2008 Aug anonymous   2008 Aug   2 2 Try to enter a String with the first 2 letters 0e or 0E ( Zero E)
3306 doc closed 2008 Aug anonymous   2009 Oct   4 4 Doc for VFS xRandomness needs update, unixRandomness returns wrong val
3305 code closed 2008 Aug anonymous   2009 Sep   5 4 Suggested improvement for sqlite30OsDlOpen failure
3304 doc closed 2008 Aug anonymous   2009 Oct   1 1 Erroneous strftime documentation
3303 new active 2008 Aug anonymous   2008 Aug   3 3 faster index creation for large tables
3302 code closed 2008 Aug anonymous   2008 Aug   2 2 Bug in CREATE TABLE xyz AS SELECT * command.
3301 code fixed 2008 Aug anonymous   2008 Aug drh 1 4 Problem resolving columns in a nested subquery
3300 code fixed 2008 Aug anonymous   2008 Aug drh 1 3 Join on a subquery returns incorrect results
3299 code fixed 2008 Aug anonymous   2008 Aug   3 3 invalid lemon parser from implicit token destruction
3298 code fixed 2008 Aug anonymous   2008 Aug drh 1 4 Problem resolving references to view columns when updating a view
3297 code closed 2008 Aug anonymous   2009 Oct   4 3 mixing GROUP columns with no GROUP columns with no GROUP BY: no error
3296 code closed 2008 Aug anonymous   2009 Oct   3 2 Compiling under CE (Unicode vs. ANSI)
3295 code closed 2008 Aug anonymous   2008 Aug   4 4 unspecified result after group by
3294 code closed 2008 Aug anonymous   2008 Aug   3 3 sqlite3_open_v2
3293 build fixed 2008 Aug anonymous   2008 Aug   4 4 Fix a bunch of Win64 compilation errors by cowardly casting size_ts to
3292 code fixed 2008 Aug anonymous   2008 Aug   2 3 Order by clause affects the number of rows returned.
3291 code closed 2008 Aug anonymous   2009 Oct   3 4 Speed Test 1-4 add "PRAGMA synchronous=OFF" to speedn-1.0 setup
3290 doc fixed 2008 Aug anonymous   2008 Aug drh 5 1 error in documentation of glob(X,Y) and like(X,Y) functions
3289 code fixed 2008 Aug anonymous   2008 Aug   1 1 lookaside tests failed with memory error
3288 code fixed 2008 Aug anonymous   2008 Aug drh 1 2 Parsers generated with lemon do not compile as c++
3287 code closed 2008 Aug anonymous   2008 Aug   3 3 Case-insensitive search doesn't spread to Cyrillic characters
3286 code closed 2008 Aug anonymous   2008 Aug   3 3 Reading long text generates error
3285 new active 2008 Aug anonymous   2008 Aug drh 5 5 Add a module_list pragma to display all modules installed
3284 code fixed 2008 Aug drh   2008 Aug   1 1 CREATE INDEX on sqlite_stat1 is allowed
3283 code fixed 2008 Aug drh   2008 Aug   1 1 sqlite3_complete() incorrect for a trigger with an empty body.
3282 doc active 2008 Aug anonymous   2008 Aug   5 4 VFS xAccess says parameter is flags - should be flag (singular)
3281 code active 2008 Aug anonymous   2008 Aug   2 3 FTS3 and JOIN, cannot use MATCH operator
3280 doc closed 2008 Aug anonymous   2009 Oct   5 4 explain query plan not documented
3279 code closed 2008 Aug anonymous   2008 Aug   2 3 bug in +marking of where column
3278 code closed 2008 Aug anonymous   2008 Aug   1 1 New behavior of 'between' gives headaches
3277 code fixed 2008 Aug anonymous   2008 Aug   1 1 Lookaside AV with user mem if number of slots is not multiple of 8
3276 code closed 2008 Aug anonymous   2009 Oct   2 3 double quotes and separators are not handled correctly (csv mode)
3275 code closed 2008 Aug anonymous   2008 Aug peter 1 2 mem1.c : memory allocation: bad memory block type
3274 code active 2008 Aug anonymous   2008 Aug   1 1 "LIKE" does not work when searching for Arabic text
3273 code closed 2008 Aug anonymous   2008 Aug   1 1 build.c compile failure with SQLITE_OMIT_FOREIGN_KEY
3272 new closed 2008 Aug anonymous   2008 Aug   4 4 Impossible to insert an empty row in an sqlite database
3271 code closed 2008 Aug anonymous   2008 Aug   5 5 Minor doc typo in sqlite3.h.in
3270 code closed 2008 Aug anonymous   2008 Aug   1 1 sqlite3_step returns SQLITE_OK
3269 code closed 2008 Aug anonymous   2008 Aug drh 1 1 API functions not exported from sqlite
3268 code closed 2008 Aug anonymous   2009 Oct drh 5 4 Add additonal flag(s) to sqlite3_open_v2()
3267 code closed 2008 Aug anonymous   2008 Aug doughenry 1 3 Sqlite3_prepare16 problem
3266 doc active 2008 Aug anonymous   2008 Aug shess 2 3 "TokenizeR" or "Tokenize"? Docs conflict code
3265 doc closed 2008 Aug anonymous   2009 Oct   5 5 Not implemented features - triggers
3264 code closed 2008 Jul anonymous   2008 Jul drh 1 1 Parser crash while creating a view
3263 code fixed 2008 Jul anonymous   2008 Jul   4 3 _GNU_SOURCE can redefined by sqliteInt.h
3262 code closed 2008 Jul anonymous   2008 Jul   3 3 pre-3.6.1 fulltest regression (argument mismatch for perm-memsubsys1)
3261 code closed 2008 Jul anonymous   2009 Oct   1 1 crash in sqlite3PagerReleaseMemory
3260 code fixed 2008 Jul anonymous   2008 Jul   2 3 Unable to open multiple new databases on FAT filesystem (OSX)
3259 code fixed 2008 Jul anonymous   2008 Jul   1 1 pre-3.6.1 testfixture coredump
3258 new closed 2008 Jul anonymous   2009 Oct   5 4 csv import
3257 todo fixed 2008 Jul anonymous   2008 Jul   2 4 implicit cast from string to integer gets wrong answer
3256 code fixed 2008 Jul anonymous   2008 Aug shane 2 4 PATCH: fix failure to build on gcc-powerpc (provide sqlite3Hwtime)
3255 code closed 2008 Jul anonymous   2009 Oct   1 1 db corrupted if disk full
3254 code closed 2008 Jul anonymous   2009 Dec   4 4 sqlite3_config() suggestions
3253 build closed 2008 Jul anonymous   2008 Jul   1 1 Missing mem6.c in tsrc
3252 doc closed 2008 Jul anonymous   2008 Jul   4 4 SQLITE_CONFIG_MEMSTATUS documented with unknown 'boolean' type
3251 doc closed 2008 Jul anonymous   2009 Oct   3 3 sqlite3_close() documentation may lead to crashing applications
3250 code closed 2008 Jul anonymous   2009 Oct   1 1 native crash in sqlite3_reset, most likely v->db is NULL
3249 code closed 2008 Jul anonymous   2008 Jul   2 3 ROLLBACK fails if statement was prepare before BEGIN
3248 code fixed 2008 Jul anonymous   2008 Jul   1 2 integer overflow sqlite3Strlen in comparison
3247 code closed 2008 Jul anonymous   2009 Oct   3 4 failed malloc
3246 code closed 2008 Jul anonymous   2008 Jul   3 4 Various memory routines should be using size_t
3245 build closed 2008 Jul anonymous   2008 Aug   1 1 ICU extension compilation
3244 code fixed 2008 Jul anonymous   2008 Jul   2 3 sqlite_next_stmt fails with null database pointer
3243 code closed 2008 Jul anonymous   2008 Aug   5 5 constant in the code
3242 build closed 2008 Jul anonymous   2008 Aug   5 4 make it easier for packagers to override where the .pc file goes
3241 build closed 2008 Jul anonymous   2008 Jul   3 4 Fix Makefile.in TCC setting so includes from current sources are first
3240 new closed 2008 Jul anonymous   2008 Jul   4 4 primary key column must not be null according to SQL 92 standard
3239 code closed 2008 Jul anonymous   2009 Oct   5 5 ALTER TABLE sqlite_master - invalid error message
3238 code closed 2008 Jul anonymous   2008 Jul   1 1 load_extension did not redefine sql function
3237 code closed 2008 Jul anonymous   2009 Oct   1 2 sqlite3HashFindElem called with wrong parameter type -> EXC_BAD_ACCESS
3236 code closed 2008 Jul anonymous   2008 Jul   1 1 SELECT DISTINCT WHERE returns invalid result set if column is indexed
3235 code closed 2008 Jul anonymous   2008 Aug   1 1 select.c error with SQLITE_OMIT_COMPOUND_SELECT
3234 doc closed 2008 Jul anonymous   2008 Jul   4 4 Error in doc lang_createtrigger.html#instead_of_trigger
3233 code closed 2008 Jul anonymous   2008 Jul   5 4 There's no way to format wide character strings using sqlite3_*printf
3232 code fixed 2008 Jul anonymous   2008 Jul   4 3 Possible mem.leak in winDlOpen() under WINCE
3231 code closed 2008 Jul anonymous   2008 Jul   4 4 numeric strings managed as integers in requests
3230 code closed 2008 Jul anonymous   2008 Jul anonymous 1 1 How to get month difference between 2 dates across years?
3229 code fixed 2008 Jul anonymous   2008 Jul   1 1 view on virtual table causes segmentation fault
3228 code fixed 2008 Jul anonymous   2008 Jul   1 2 btree compilation error with SQLITE_OMIT_AUTOVACUUM
3227 code closed 2008 Jul anonymous   2008 Jul anonymous 1 1 how to get the difference b/w two dates across year in sqlite???
3226 code fixed 2008 Jul anonymous   2008 Jul   1 1 mem3.c: memsys3Size() roundup error
3225 code fixed 2008 Jul anonymous   2008 Jul   1 1 non-dereferenced sqlite3Config.m struct assignments in main.c
3224 code fixed 2008 Jul anonymous   2008 Jul   4 3 sqlite3_mutex_try() is implemented inconsistently
3223 code fixed 2008 Jul anonymous   2008 Jul   1 1 memsys3Size() causes access violation for NULL pointers
3222 new closed 2008 Jul anonymous   2009 Oct   3 4 UPDATE with joined tables
3221 code fixed 2008 Jul anonymous   2008 Jul   2 2 short/full_column_names do not do what they are supposed to in JOINs
3220 code closed 2008 Jul anonymous   2008 Jul   1 1 install on hp unix error
3219 doc fixed 2008 Jul anonymous   2008 Jul   4 3 SQLITE_CONFIG_GETMUTEX documention has incorrect header
3218 code closed 2008 Jul anonymous   2009 Oct   2 2 Patch to Initialize and Delete critical sections at init/shutdown
3217 code fixed 2008 Jul anonymous   2008 Jul   1 1 sqlite3_initialize() not wrapped by SQLITE_OMIT_AUTOINIT
3216 code fixed 2008 Jul anonymous   2008 Jul   1 1 sqlite3_memory_used() prone to over-optimization
3215 code fixed 2008 Jul anonymous   2008 Jul   5 4 lemon: Patches to fix comment typos
3214 code fixed 2008 Jul anonymous   2008 Jul   5 4 lemon: [5335] stops #line being generated for %include
3213 code closed 2008 Jul anonymous   2009 Oct   3 3 pre-3.6.0 x86-64 fulltest failures
3212 code closed 2008 Jul anonymous   2008 Jul   2 3 autoincrement columns are not shown as primary key on sqlite_master
3211 code fixed 2008 Jul anonymous   2008 Jul   2 2 equals comparison failing
3210 doc fixed 2008 Jul anonymous   2008 Jul anonymous 4 4 Documentation error in capi3.html. * fourth* should read *fifth*.
3209 code fixed 2008 Jul drh   2008 Jul drh 1 1 Segfault when writing into a corrupt database file
3208 new closed 2008 Jul anonymous   2008 Jul   1 1 new function :sqlite3_columns_values()
3207 code closed 2008 Jul anonymous   2008 Jul   1 1 comparison logic
3206 new closed 2008 Jul anonymous   2009 Oct   5 4 Add additional columns to several schema pragmas
3205 build closed 2008 Jul anonymous   2009 Oct   5 5 nan test failing - "inf" versus "Infinity"?
3204 code closed 2008 Jul anonymous   2008 Jul anonymous 1 1 SQLITE3 Update Statement: Fails for non-root user (Linux)
3203 build closed 2008 Jul anonymous   2008 Aug   1 1 config.h missing from sqlite-source-3_5_9.zip
3202 code fixed 2008 Jul anonymous   2008 Jul   2 3 Selecting the result of a binary operation on two columns fails
3201 code closed 2008 Jul danielk1977   2008 Jul danielk1977 1 1 integer primary key/self-join related bug
3200 code closed 2008 Jul anonymous   2008 Jul   1 1 memory leak in sqlite3_open
3199 todo closed 2008 Jul anonymous   2008 Jul   3 3 AUTOINCREMENT and rollback reuses PKs
3198 code closed 2008 Jul anonymous   2008 Jul   3 3 Strange memory leak on some kind of queries with virtual tables
3197 code closed 2008 Jul anonymous   2008 Jul   3 1 Files are not closed during the select call
3196 code closed 2008 Jul anonymous   2009 Oct   1 1 memory leak in sqlite3VdbeMemSetNull().
3195 doc closed 2008 Jun anonymous   2009 Oct   3 3 Are SQLITE_MAX_* variables official API or not?
3194 code closed 2008 Jun anonymous   2009 Oct   3 3 query parameter is treated as zero / ignored in SUM with GROUP BY
3193 code fixed 2008 Jun anonymous   2008 Jun   5 4 wrong description in comment describing sequnce
3192 new closed 2008 Jun anonymous   2008 Jun   4 3 Feature Request: Add Date & Time Functions to 'DEFAULT' table syntax
3191 code closed 2008 Jun anonymous back 2009 Oct   1 1 The database disk image is malformed
3190 code closed 2008 Jun anonymous   2008 Jun   1 1 No result on name= query but results in name like
3189 build closed 2008 Jun anonymous build 2009 Mar   1 1 [PATCH] configure.ac doesn't handle --enable-dynamic-extensions=no
3188 code closed 2008 Jun anonymous   2008 Jun   1 4 Can't cast results from external functions
3187 doc closed 2008 Jun anonymous   2009 Oct   4 3 VirtualTable cursor recylcing undocumented (xFilter called twice)
3186 todo closed 2008 Jun anonymous   2008 Jun   2 1 select 5/9.0; Does not yield a result
3185 code closed 2008 Jun anonymous   2008 Jun   1 1 bug in Alter table command
3184 code closed 2008 Jun anonymous   2009 Oct   1 1 page lost from all page list
3183 doc closed 2008 Jun anonymous   2009 Oct   4 4 Documentation clarification request: ROLLBACK & step/reset/finalize
3182 build closed 2008 Jun anonymous   2009 Oct   1 2 sqlite3-3_5_9-osx-x86 crashes on startup
3181 new closed 2008 Jun anonymous   2009 Oct   1 1 sqlite3_open16 doesn't work with unicode characters
3180 code closed 2008 Jun anonymous   2008 Jun   3 3 Invalid column name in subselect does not generate an error
3179 code fixed 2008 Jun anonymous   2008 Jun   1 1 Aggregate functions that take 4 parameters crash (SEGV)
3178 new closed 2008 Jun anonymous   2009 Oct   5 4 A bit more built-in functions
3177 doc fixed 2008 Jun anonymous   2008 Jun   1 1 Miswriting in article "SQLite's Use Of Temporary Disk Files"
3176 code closed 2008 Jun anonymous   2008 Jun a.rottmann 1 1 is encryption supported ?
3175 new closed 2008 Jun anonymous   2009 Oct   1 1 multiple row insert
3174 build closed 2008 Jun anonymous   2009 Oct peter 1 1 compiled with Microsoft vs2005
3173 new closed 2008 Jun anonymous   2008 Jun   3 3 No way to get fractional seconds since epoch
3172 code fixed 2008 Jun anonymous   2008 Jun   2 3 C++ comments in C code
3171 build closed 2008 Jun anonymous   2008 Jun   5 1 about SQLite3 on C++Builder 2007?
3170 doc closed 2008 Jun anonymous   2009 Oct   5 4 typo in locking documentation
3169 code closed 2008 Jun anonymous   2009 Oct   4 4 sqlite3_exec callback function can't identify table name
3168 code closed 2008 Jun anonymous   2008 Jun   1 2 64 bit integral types
3167 new closed 2008 Jun anonymous   2009 Oct   5 5 Use threaded dispatch in the VDBE interpreter
3166 code closed 2008 Jun anonymous   2008 Jun   1 3 potential stack overflow from sqlite3VdbeMemRelease()
3165 code closed 2008 Jun anonymous   2008 Jun   1 1 Buffer underruns and use of freed memory
3164 code closed 2008 Jun anonymous   2008 Jun danielk1977 4 4 Either a documentation error or a code probelm
3163 code closed 2008 Jun anonymous   2009 Oct   1 2 Column name resolution in nested SELECT in WHERE-clause
3162 code closed 2008 Jun anonymous   2009 Oct dwong 1 1 sqlite3_prepare16_v2 return SQLITE_SCHEMA
3161 build closed 2008 Jun anonymous   2009 Oct   2 4 Solaris 10 egrep is not GNU egrep, so make fails
3160 new closed 2008 Jun anonymous   2009 Oct   4 4 publisch the progress handler for the virtual table hander
3159 code closed 2008 Jun anonymous   2009 Oct   1 4 Could not use sqlite3_open( ":memory:", &db); on FreeBSD 6.3
3158 code closed 2008 Jun anonymous   2008 Jun   4 4 Apparently bogus assertion in sqlite3ValueText
3157 code closed 2008 Jun anonymous   2008 Jun   4 4 fulltest warning --- vacuum3.test did not close all files: 1
3156 code fixed 2008 Jun anonymous   2008 Jun shane 2 1 PATCH: fix failure to build on x86-64 (provide sqlite3Hwtime)
3155 code closed 2008 Jun anonymous   2008 Jun   3 3 SQLite breaks when interrupting while preparing a CREATE TABLE
3154 code closed 2008 May anonymous   2009 Oct   3 4 SELECT * FROM Table ON Column=1 runs, but produces all rows
3153 code closed 2008 May anonymous   2009 Oct   4 4 Earlier detection of corrupt databases would be an advantage
3152 doc closed 2008 May anonymous   2009 Oct mihailim 5 4 Minor SQL documentation improvement suggestions
3151 code closed 2008 May shane   2008 Jun shane 4 4 winAccess return undefined on invalid flags with assertions disabled
3150 code fixed 2008 May anonymous   2008 May   1 1 Multi-column index is not used properly with LIKE and ORDER BY
3149 code closed 2008 May drh   2009 Oct   1 1 UPDATE does not adjust the sqlite_sequence table
3148 code fixed 2008 May drh   2008 May drh 1 1 sqlite3_sequence corruption following empty INSERT
3147 code closed 2008 May anonymous   2009 Oct   1 1 string formatting cause loss of precision
3146 code fixed 2008 May anonymous   2008 May   1 1 vdbe code regression from 3.5.7 to 3.5.9
3145 new closed 2008 May anonymous   2009 Oct   5 4 .CREATE command for sqlite3.exe
3144 code closed 2008 May anonymous   2009 Oct   5 4 F10336 is not true
3143 code fixed 2008 May anonymous   2008 May   3 4 compile error with SQLITE_MAX_EXPR_DEPTH=0
3142 doc fixed 2008 May anonymous   2008 Aug   4 4 Documentation doesn't clearly list which functions are experimental
3141 code closed 2008 May anonymous   2009 Oct   4 4 Feature Request: create_function_v2 that takes destructor
3140 new active 2008 May anonymous   2008 May   4 3 [PATCH] Make the default FTS3 tokenizer UTF8-aware
3139 code fixed 2008 May anonymous   2008 May   2 2 COLLATE NOCASE thinks '^' LIKE '@%'
3138 doc closed 2008 May anonymous   2008 Jun   5 4 global cache size
3137 code closed 2008 May anonymous   2009 Oct   5 5 a small patch to support loading enable extension automatically
3136 doc fixed 2008 May anonymous   2008 Jun   1 3 sentence on intro page is in error
3135 code closed 2008 May anonymous   2009 Oct   5 5 simple generic sqlite3_exec16 implemantation
3134 code fixed 2008 May anonymous   2008 May   5 4 sqlite3Prepare has off by one bug
3133 todo closed 2008 May anonymous   2009 Oct   1 2 Erratic behaviour of select command for FTS virtual table
3132 doc fixed 2008 May shane   2008 May   5 4 update documentation on shared cache/filename matching relationship
3131 code closed 2008 May anonymous func 2009 Oct   4 4 PRAGMA encoding doesnt return encoding compiled with SQLITE_OMIT_UTF16
3130 code closed 2008 May anonymous   2009 Oct danielk1977 1 2 MJ file still created with pragma journal_mode=off
3129 code fixed 2008 May shane   2008 May   4 4 tkt2854.test is failing 2 test cases
3128 code active 2008 May anonymous   2009 Mar   3 3 DISTINCT -> GROUP BY can lead to performance degradation
3127 code closed 2008 May anonymous   2008 May drh 1 1 Segfault using pragma journal_mode=off
3126 warn fixed 2008 May anonymous   2008 May shane 4 4 Use localtime_s when available (on Windows/MSVC)
3125 build closed 2008 May anonymous   2009 Oct   3 2 loadextension must link with libdl
3124 doc fixed 2008 May anonymous   2008 May   5 3 missing ] in sqlite.h.in
3123 code closed 2008 May anonymous   2009 Oct   2 3 zErrMsg does not work for Virtual Tables
3122 code closed 2008 May anonymous   2009 Oct   1 1 sqlite3 crash with damaged db
3121 code closed 2008 May anonymous   2008 May   3 3 Bad encoding change in vdbe Op_Column.
3120 code closed 2008 May anonymous   2008 May   4 4 All the os_.c source files are missing version tags
3119 code fixed 2008 May anonymous   2008 May   4 4 loadexe.c missing version comment
3118 code fixed 2008 May anonymous   2008 May   4 4 fault.c does not contain a version comment
3117 code active 2008 May anonymous   2008 May   5 4 Lemon parser automaton listing improvement
3116 build closed 2008 May anonymous   2009 Oct   1 2 sqlite-3.5.9 Fedora FC8 has 40 test failures
3115 code active 2008 May anonymous   2008 Jun   3 2 CREATE TABLE AS SELECT - file size
3114 code closed 2008 May anonymous   2008 May   1 1 Memory corruption (?) and compilation warnings on x86_64
3113 new closed 2008 May anonymous   2009 Oct   5 4 Accept "LAST_INSERT_ID()" function for MySQL compatibility
3112 new closed 2008 May anonymous   2009 Oct   5 4 Accept "AUTO_INCREMENT" attribute for MySQL compatibility
3111 code closed 2008 May anonymous   2009 Oct   5 1 sqlite3RunParser error in linux muti-threaded environment
3110 doc closed 2008 May anonymous   2008 Jun   1 1 Minor typo in sqlite3_step()
3109 code closed 2008 May anonymous   2009 Oct   4 4 ROLLBACK doesn't halt properly
3108 code closed 2008 May anonymous   2009 Oct   5 4 Code could be inefficient
3107 code closed 2008 May anonymous   2009 Oct   3 1 SQLite doesn't correctly check for "file system full" on writes
3106 code closed 2008 May anonymous   2008 May   1 1 DB Files kept locked if a failure in loading a page happens
3105 code fixed 2008 May anonymous   2008 May   4 4 Sun Workshop 6 compiler warnings
3104 new closed 2008 May anonymous   2009 Oct   2 2 Patch that fixes some problems with mutex_w32.c implementation
3103 code closed 2008 May anonymous   2008 May   4 2 Core Dump on command .show on Solaris 9
3102 code fixed 2008 May anonymous   2008 May   2 2 rename table fails with error 11 if CREATE TABLE contains comments
3101 code fixed 2008 May anonymous   2008 May   2 2 3.5.9 NaN / gcc issues
3100 code fixed 2008 May anonymous   2008 May   5 4 The MAX_6BYTE macro in vdbeaux.c has a too small value
3099 code fixed 2008 May anonymous   2008 Jun   5 3 Enhancement
3098 new closed 2008 May anonymous   2009 Oct   5 4 Accept "INSERT IGNORE" for MySQL compatibility
3097 code closed 2008 May anonymous   2008 May   2 4 intptr potentially wrong (amalgamation)
3096 code fixed 2008 May drh   2008 May   1 1 Small-file CLI segfaults when given a large file
3095 new closed 2008 May anonymous   2009 Oct   1 1 DELETE FROM should support aliasing
3094 code fixed 2008 May anonymous   2008 May   3 4 3.5.8 "disk I/O error" when slt reaches 2gig. Fine with 3.5.2
3093 code fixed 2008 May anonymous   2008 May   1 2 Busy handler never succeeds on update retry under 3.5.8
3092 code closed 2008 May anonymous   2008 May   2 2 Query on nested union view returns garbage (regression)
3091 code closed 2008 Apr anonymous   2008 Apr   2 3 AIX problems with 3.5.7 and 3.5.8 - possibly unixGetTempname related
3090 code closed 2008 Apr anonymous   2008 May drh 5 4 Proposition for sqlite3GetVarint() optimization
3089 code fixed 2008 Apr drh   2008 Apr   1 1 Fix the implementation of sqlite3_isnan()
3088 code closed 2008 Apr anonymous   2008 Apr   1 1 warning C4311: 'type cast' : pointer truncation from 'char *' to 'sqli
3087 code fixed 2008 Apr anonymous   2008 Apr   1 2 Slow queries with 3.5.8.
3086 code closed 2008 Apr anonymous   2008 Apr   1 1 sqlite3BtreeCursorSize() missing (void)
3085 code fixed 2008 Apr anonymous   2008 Apr   1 3 F12764 not implemented
3084 code fixed 2008 Apr anonymous   2008 May danielk1977 2 2 3.5.8 writer starvation with "begin immediate" transaction
3083 code fixed 2008 Apr anonymous   2008 Apr   1 1 fulltextBegin: Assertion `v->nPendingData<0' failed
3082 code fixed 2008 Apr anonymous   2008 Apr   1 1 sqlite3VdbeExec: Assertion `p->apCsr[i]!=0' failed
3081 new closed 2008 Apr anonymous   2008 Apr   5 5 Primary key violated with UPDATE
3080 code closed 2008 Apr anonymous   2008 Apr   2 4 crash in sqlite3VtabSync if virtual table was dropped during transacti
3079 code fixed 2008 Apr anonymous   2008 Apr drh 3 3 Lemon parser trips over assertions
3078 code closed 2008 Apr anonymous   2008 Apr   2 3 blob i/o doesn't work with virtual tables
3077 build closed 2008 Apr anonymous   2008 Sep   4 4 sqlite pkgconfig doesn't provide full version string
3076 code closed 2008 Apr anonymous   2008 Apr   1 1 group_concat() produces incorrect result with UTF16 database
3075 warn closed 2008 Apr anonymous   2008 Apr   3 3 warnings when compiling with Visual Studio 2005
3074 new closed 2008 Apr anonymous   2009 Oct   1 1 support for parentheses around UNION sub-queries
3073 code closed 2008 Apr anonymous   2009 Oct anonymous 1 1 Critical section doesn't be deleted while not using sqlite3.
3072 doc closed 2008 Apr anonymous   2008 Apr   5 4 F17868 incorrect
3071 doc closed 2008 Apr anonymous   2008 Apr   2 1 BNF for CREATE TABLE on sqlite.org is wrong
3070 code closed 2008 Apr anonymous   2008 Apr   1 1 sqlite3_changes bug (?)
3069 code fixed 2008 Apr anonymous   2008 Apr   4 4 Cannot compile with -DSQLITE_MAX_COLUMN=0
3068 build closed 2008 Apr anonymous   2009 Oct   4 4 configure: BEXE incorrect for cygwin -> linux cross compile
3067 code closed 2008 Apr anonymous   2008 Apr   5 4 Useless compiler directive #if SQLITE_MAX_COLUMN
3066 code closed 2008 Apr anonymous   2008 Apr   5 4 vdbeaux needs version control comment
3065 code closed 2008 Apr anonymous   2008 Apr   4 4 redundant code can be removed
3064 code closed 2008 Apr anonymous   2008 Apr   3 4 String buffer used after memory freed
3063 code closed 2008 Apr anonymous   2009 Sep   4 3 sqlite3_clear_bindings() clears error message as well
3062 code fixed 2008 Apr anonymous   2008 Apr   2 3 regression failures on second pass
3061 code closed 2008 Apr anonymous   2009 Oct   3 4 sqlite can't import from STDIN on windows if newlines exist
3060 code fixed 2008 Apr anonymous   2008 Apr   3 3 NaN
3059 code fixed 2008 Apr anonymous   2008 Apr drh 1 2 sqlite3_column_metadata race condition
3058 new active 2008 Apr anonymous   2008 Apr   3 5 optimizer chooses wrong indicies
3057 code closed 2008 Apr anonymous   2009 Oct   1 2 VC6 optimization code results in: SQL logic error or missing database
3056 code fixed 2008 Apr anonymous   2008 Apr   3 3 CVS regression with handling of strings with trailing null
3055 code fixed 2008 Apr anonymous   2008 Apr   1 1 INSTEAD of trigger (on view) fails with 3.5.7+ (worked with 3.2.7+)
3054 doc fixed 2008 Apr anonymous   2008 Apr   5 4 column is used as a keyword but is not listed on website documentation
3053 build fixed 2008 Apr anonymous   2008 Apr pweilbacher 3 3 Bashism in configure
3052 code fixed 2008 Apr pweilbacher   2008 Apr pweilbacher 2 3 Handle UTF-8 filenames on OS/2
3051 code review 2008 Apr anonymous   2008 Jun   4 3 Even after setting pragma short_column_names the complete name is stil
3050 code fixed 2008 Apr anonymous   2008 Apr   1 1 sqlite3BitvecSet crash
3049 code fixed 2008 Apr anonymous   2008 Apr   1 1 sprintf() still used in FTS (all versions)
3048 code fixed 2008 Apr anonymous   2008 Apr   5 4 Unused variable warning in sqlite3GenerateRowIndexDelete
3047 code fixed 2008 Apr anonymous   2008 Apr   5 4 improvement for EBCDIC hexToInt() in checkin 4967
3046 warn closed 2008 Apr anonymous   2009 Oct   4 4 semmingly false errors reported by crash tests on solaris
3045 doc closed 2008 Apr anonymous   2009 Oct drh 4 4 Various typo errors in lang.in
3044 warn closed 2008 Apr anonymous   2009 Oct   3 2 Using insecure function on Windows.
3043 code closed 2008 Apr anonymous   2008 Apr   1 4 assertion fails in 32 bit testfixture on little-endian platform
3042 new closed 2008 Apr anonymous   2009 Oct   4 4 use current work directory as home when environment HOME not defined
3041 build closed 2008 Apr anonymous   2008 Apr   4 3 Build problem with SQLITE_OMIT_VIEW
3040 code fixed 2008 Apr anonymous   2008 Apr   1 4 solaris 8 gcc 32-bit build crashes
3039 code fixed 2008 Apr anonymous   2008 Apr   3 2 missing error in db copy command
3038 code fixed 2008 Apr anonymous   2008 Apr   1 1 sqlite3_changes returns 0 on UPDATE on a virtual table
3037 code fixed 2008 Apr anonymous   2008 Apr   3 3 sqlite3_open_v2 doesn't verify flags parameter
3036 code active 2008 Apr anonymous   2008 Apr   4 4 ANALYZE considers all NULL values unique
3035 todo closed 2008 Apr anonymous   2008 Apr   1 4 Trigger with RAISE ROLLBACK
3034 code closed 2008 Apr anonymous   2008 Apr danielk1977 1 1 sqlite3_mprintf does not format 64bit integer (sqlite3_int64)
3033 code closed 2008 Apr anonymous   2008 Apr   3 3 Index unused in join, unless dropped and recreated
3032 code closed 2008 Apr anonymous   2008 Apr   1 3 sqlite3_exec() can not get column count for blob data
3031 doc fixed 2008 Apr anonymous   2008 Apr   5 4 Typo in "Atomic Commit In SQLite" document
3030 code closed 2008 Apr anonymous   2008 May   2 3 Failure of read during begin transaction leaves database locked.
3029 code fixed 2008 Apr anonymous   2009 Feb shane 4 3 Defining SQLITE_OMIT_FLOATING_POINT does not remove all FP ops.
3028 build closed 2008 Apr anonymous   2009 Oct   4 3 Build problem on 64 bit Windows.
3027 code closed 2008 Apr anonymous   2008 Apr   2 1 Segmentation fault on WinXP
3026 code closed 2008 Apr anonymous   2008 Jun   3 1 "drop table if exists" fails
3025 code closed 2008 Mar anonymous   2008 Apr   1 1 sqlite application
3024 code fixed 2008 Mar rse   2008 Apr drh 4 3 small compile-time fix related to symbols "sqlite3Apis"
3023 code closed 2008 Mar anonymous   2008 Mar   2 2 NUMERIC datatype error, with UNION ALL, TOTAL and SELECT
3022 code closed 2008 Mar anonymous   2008 Mar danielk1977 2 1 Select on view of indexed table broken
3021 new closed 2008 Mar anonymous   2009 Oct   1 1 Delete trigger not fired when "insert or replace" does a replace
3020 build fixed 2008 Mar rdc   2008 Mar   3 3 make fails while building sqlite3.c
3019 doc fixed 2008 Mar anonymous   2008 Jun mihailim 5 5 Typo in SEC(11) of the SQLite FAQ
3018 code closed 2008 Mar anonymous   2008 Mar   1 1 how can i implement moveprev() i.e. step prev.
3017 build closed 2008 Mar anonymous   2008 Mar   1 1 query order by not working for any other column except than rowid
3016 doc fixed 2008 Mar anonymous   2008 Mar   5 5 SQLITE_MAX_ATTACHED
3015 code fixed 2008 Mar anonymous   2008 Mar   2 3 Adding index changes LEFT OUTER JOIN to act as INNER JOIN
3014 new closed 2008 Mar anonymous   2008 Apr chw 4 4 SQLite3 Don't support charIndex and IndexOf methods
3013 code closed 2008 Mar anonymous   2008 Apr   4 3 sqlite3.nChange not (always) reset
3012 code closed 2008 Mar anonymous   2008 Mar   1 1 called in inappropriate state
3011 code closed 2008 Mar anonymous   2008 Mar drh 1 1 Invalid Blob result on UTF-16 encoding
3010 code closed 2008 Mar anonymous   2008 Mar   1 1 with UTF-16BE or UTF-16LE encoding, sqlite3_column_blob return invalid
3009 code fixed 2008 Mar anonymous   2008 Mar   3 3 Bug with function Group_Concat
3008 doc closed 2008 Mar anonymous   2009 Oct   3 3 HTML bad links on tclsqlite.html page
3007 new closed 2008 Mar anonymous   2009 Oct drh 3 2 Optional journal creation flag
3006 code closed 2008 Mar anonymous   2008 Mar   3 3 Straneg behaviour during LEFT JOIN with column AS statement
3005 code closed 2008 Mar anonymous   2008 Mar drh 3 3 Some Compilation Options not work
3004 doc fixed 2008 Mar anonymous   2008 Mar   3 3 Invalid HTML in 3.5.7 documentaion
3003 event closed 2008 Mar anonymous   2008 Mar   2 1 I dot connection help me
3002 new closed 2008 Mar anonymous   2008 Apr anonymous 4 4 Memory leak within sqlite3_open_v32()
3001 code fixed 2008 Mar anonymous   2008 Apr   3 4 lemon: repeat %include
3000 code closed 2008 Mar anonymous   2008 Mar   1 2 Rejects "Group" as column name
2999 doc closed 2008 Mar anonymous   2008 Mar   1 1 Visual Basic Commands
2998 code fixed 2008 Mar anonymous   2008 Mar   2 2 bad vdbe code generated for natural join of virtual tables
2997 code closed 2008 Mar anonymous   2008 Mar   1 4 cann't execute "select count(*) ..." operator in a TRANSACTION
2996 code closed 2008 Mar anonymous   2009 Oct   3 3 Can't open long filename/pathnames on windows
2995 code closed 2008 Mar anonymous   2008 Mar   4 4 excessive calls to Sqlite3Error
2994 code fixed 2008 Mar anonymous   2008 Apr   2 2 DROP fts3 table causes crash
2993 code fixed 2008 Mar anonymous   2008 Mar appledev 1 1 file locking fails on OS X network volumes
2992 event closed 2008 Mar anonymous   2009 Oct mlcreech 1 1 sqlite compatibility with windows mobile 6.0
2991 code fixed 2008 Mar rdc   2008 Apr   1 1 sqlite3.exe termiantes due to bad table name
2990 code fixed 2008 Mar anonymous   2008 Mar   2 1 Incorrect result of union all query with subquery
2989 code closed 2008 Mar anonymous   2008 Mar   1 1 cannot DELETE from table named: 'catalogs'
2988 new closed 2008 Mar aswift   2009 Dec drh 3 4 Add support for configuring limits at run-time and per-connection
2987 code closed 2008 Mar anonymous   2009 Oct   1 1 unable to open database file
2986 doc closed 2008 Mar anonymous   2008 Mar   4 4 Documentation Error
2985 code fixed 2008 Mar anonymous   2008 Mar drh 2 1 possible incorrect assignment in if statement
2984 new closed 2008 Mar anonymous   2009 Oct   3 3 Plans to add "end of ..." date/time functions?
2983 code closed 2008 Mar anonymous   2008 Mar   3 3 "SQL logic error or missing database" with INSERT
2982 code fixed 2008 Mar anonymous   2008 Mar   3 3 amalg inconsistant declaration sqlite3_version, sqlite3_temp_directory
2981 build fixed 2008 Mar anonymous   2008 Mar   1 2 Solution to Tcl compile error.
2980 doc fixed 2008 Mar anonymous   2008 Mar   5 5 Typos in create_function.html lang_select.html
2979 build fixed 2008 Mar anonymous   2008 Mar   4 3 Configure does not respect prefix
2978 code fixed 2008 Mar anonymous   2008 Mar   3 3 usleep (and fdatasync?) not used even if available.
2977 build closed 2008 Mar anonymous   2008 Mar   4 3 The load extension mechanism does not have a configure option
2976 build closed 2008 Mar anonymous   2009 Oct   1 2 Can't link against SQLite when build for ARM9 with uClibc
2975 code fixed 2008 Mar anonymous   2008 Apr   4 4 sqlite3_bind_parameter_name for ?NNN is not null
2974 code closed 2008 Mar anonymous   2008 Apr   1 1 Select problem in transition from Version 3.2.2 to 3.5.4
2973 new closed 2008 Mar anonymous   2008 Jun   1 1 Any possibilties that yall could add math functions into the distro
2972 todo closed 2008 Mar anonymous   2009 Oct   1 1 Can't download contributions from contribution page on www.sqlite.org
2971 doc closed 2008 Mar anonymous   2009 Oct   1 1 Web site link to math extensions downlaod is broken
2970 code closed 2008 Mar danielk1977   2009 Oct   1 1 Mozilla crash related to sqlite3_enable_shared_cache()
2969 doc fixed 2008 Mar anonymous   2008 Mar   5 4 Website typos
2968 doc closed 2008 Feb anonymous   2008 Mar   5 4 Documentation typo
2967 code closed 2008 Feb anonymous   2008 Feb danielk1977 3 4 order of columns in index substantially affects the execution time
2966 code closed 2008 Feb anonymous   2008 Feb   1 1 SQL error: database disk image is malformed
2965 event closed 2008 Feb anonymous   2008 Mar   3 5 crash of: SELECT DISTINCT .... FROM .... ORDER BY ROWID DESC;
2964 code active 2008 Feb anonymous   2008 Mar drh 1 1 Access Violation from VACUUM with 3.5.6 on Corrupt Database
2963 doc fixed 2008 Feb anonymous   2008 Feb   5 4 sqlite.org website errors
2962 code closed 2008 Feb anonymous   2008 Apr   2 2 64 bit integer support could be better.
2961 code closed 2008 Feb mlcreech   2008 Feb danielk1977 3 3 Reproducible segfault when executing ioerr3-2
2960 code closed 2008 Feb anonymous   2009 Oct   2 1 select count(*) on large database locks the database for long time.
2959 code fixed 2008 Feb anonymous   2008 Feb   1 1 Inconsistent behavior for LIKE query on indexed COLLATE NOCASE column
2958 code closed 2008 Feb anonymous   2008 Feb anonymous 1 1 group by error
2957 code closed 2008 Feb anonymous   2008 Feb   1 1 SQL "like" select result error when string is chinese
2956 new closed 2008 Feb anonymous   2009 Oct   1 5 alter table xxx add column yyy; on empty table (no records)
2955 doc fixed 2008 Feb anonymous   2008 Feb   5 4 typo on website
2954 code closed 2008 Feb anonymous   2009 Oct drh 2 1 "database disk image is malformed" Error
2953 new defer 2008 Feb anonymous   2008 Mar   1 5 Threading, mutexes, and pthread_atfork
2952 new closed 2008 Feb anonymous   2009 Oct   4 1 "New" feature needed...
2951 code closed 2008 Feb anonymous   2008 Feb   2 1 Bug of SQLite3_open
2950 code closed 2008 Feb anonymous   2009 Oct   3 3 Windows CE can occasionally leave temp files around
2949 code fixed 2008 Feb anonymous   2008 Feb   1 1 SQLITE_OMIT_UTF16 compile error
2948 code closed 2008 Feb anonymous   2008 Mar   5 5 Compiler warnings in SQLite 3.5.6
2947 code closed 2008 Feb anonymous   2008 Feb   4 4 WIN32: .explain ON followed by .show crashes sqlite3
2946 new closed 2008 Feb anonymous   2009 Oct   4 4 16bit version of sqlite3_bind_parameter_index
2945 build closed 2008 Feb anonymous   2009 Oct   3 3 build on Windows CE 6
2944 code closed 2008 Feb anonymous   2008 Feb   4 5 sqlite3.exe has problems with line comments (Win XP)
2943 code fixed 2008 Feb anonymous   2008 Feb   4 4 group_concat + order by
2942 code fixed 2008 Feb anonymous   2008 Feb   1 2 a bug occured in output.c
2941 code closed 2008 Feb anonymous   2009 Oct   5 4 expose sqlite3VdbeMemCopy, sqlite3MemCompare, sqlite3VdbeMemRelease
2940 code review 2008 Feb anonymous   2008 Apr   3 3 error codes and messages from functions don't get through step()
2939 code closed 2008 Feb anonymous   2009 Oct   1 1 instr, locate, position, charindex etc
2938 code fixed 2008 Feb anonymous   2008 Feb   3 5 UPDATE/DELETE of views (via triggers) performs poorly
2937 code closed 2008 Feb anonymous   2009 Oct drh 1 3 insert into an attached database does not work within (temp) trigger
2936 code fixed 2008 Feb anonymous   2008 Apr danielk1977 3 4 Too many error or warning messages with BDS2006
2935 code fixed 2008 Feb anonymous   2008 Apr   3 3 fts3 and PRAGMA count_changes problems
2934 code closed 2008 Feb anonymous   2008 Feb   3 4 The optional OFFSET keyword isn't right implemented.
2933 new closed 2008 Feb anonymous   2009 Oct   5 4 shell: negative .width could right-justify columns
2932 code closed 2008 Feb anonymous   2009 Oct   4 4 sqlite3_get_table sets errno=2
2931 new closed 2008 Feb anonymous   2009 Oct   1 1 auto-detect page size
2930 new closed 2008 Feb anonymous   2009 Oct   3 3 Command line could works with multibyte chars on the current locale
2929 code closed 2008 Feb anonymous   2008 Feb   1 1 Issue with the MAX() aggregate function
2928 doc closed 2008 Feb anonymous   2008 Jun   5 4 Incorrect C example on "SQLite In 5 Minutes Or Less"
2927 code fixed 2008 Feb anonymous   2008 Feb   1 2 custom (user) function misbehaves in union-ed select statement
2926 code closed 2008 Feb anonymous   2009 Oct   5 4 set the minimum limit of pagesize even lower
2925 code closed 2008 Feb anonymous   2008 Feb danielk1977 3 1 I can't understand the code
2924 doc fixed 2008 Feb anonymous   2008 Feb   4 2 Random noise in code on web page
2923 build fixed 2008 Feb pweilbacher   2008 Feb   3 3 Duplicate symbol pager3_refinfo_enable when linking with debug & test
2922 code closed 2008 Feb anonymous   2009 Oct   2 3 sqlite3_step() doesn't pass repreparation errors back to the caller
2921 code closed 2008 Feb anonymous   2009 Nov   3 3 Use of readline interferes with pasting queries indented with tabs
2920 code fixed 2008 Feb anonymous   2008 Feb   1 3 SQLITE_FULL error is given even if the max_page_count is increased
2919 code closed 2008 Feb anonymous   2009 Oct   3 4 Shell only shows headers for first statement
2918 code closed 2008 Feb anonymous   2008 Feb danielk1977 1 1 sqlite3SelectMask() missing with SQLITE_OMIT_TRIGGER
2917 code active 2008 Feb anonymous   2008 Feb   4 4 Tcl interface - busy callback confusion script/procedure
2916 code fixed 2008 Feb anonymous   2008 Feb   1 1 sqlitedll-3_5_5.zip is older 3.5.4 binary
2915 build fixed 2008 Feb pweilbacher   2008 Mar   4 3 fix Makefile for platforms that need .exe extension
2914 code fixed 2008 Jan anonymous   2008 Feb   3 3 ATTACH returns SQLITE_ERROR when it means SQLITE_BUSY
2913 code fixed 2008 Jan anonymous   2008 Jan   3 3 vtab regression failures
2912 new closed 2008 Jan anonymous   2009 Oct   5 4 merge join
2911 code closed 2008 Jan anonymous   2009 Oct   2 2 Adding parentheses to a FROM clause
2910 new closed 2008 Jan anonymous   2008 Jan   1 2 Number of rows in result set - new API
2909 build fixed 2008 Jan aswift   2008 Feb aswift 4 4 Omit the _XOPEN_SOURCE 500 define on Mac OS-X (check for __APPLE__)
2908 code closed 2008 Jan anonymous   2009 Oct   3 3 Add support to examine whether statements modify the database
2907 code closed 2008 Jan anonymous   2009 Oct   1 1 Issues of sqlite3 with Windows Mobile 5/6
2906 code closed 2008 Jan anonymous   2008 Jan anonymous 2 2 Error in MSVC v.6.0 (optimization: Maximize Speed mode)
2905 code fixed 2008 Jan anonymous   2008 Feb pweilbacher 2 2 mutex_os2.c - incorrect mutex implementation
2904 code fixed 2008 Jan anonymous   2008 Feb pweilbacher 3 3 os_os2.c - 2 dysfunctional functions
2903 code closed 2008 Jan anonymous   2009 Oct   2 2 tclinstaller.tcl fails on path and permissions issue
2902 code closed 2008 Jan anonymous   2009 Oct drh 3 3 Add watch support to SQLite
2901 code closed 2008 Jan anonymous   2009 Oct   3 3 ROLLBACK and COMMIT statements should not expire
2900 code closed 2008 Jan anonymous   2008 Jan   3 4 Can't ESCAPE in GLOB
2899 code closed 2008 Jan anonymous   2009 Oct   4 4 sqlite3_reset() after exec() takes > 100 ms to complete
2898 code fixed 2008 Jan anonymous   2008 Mar   1 1 Latest CVS for 3.5.4 fails to build test1.c
2897 code closed 2008 Jan anonymous   2009 Oct   1 1 String or BLOB exceed size limit
2896 code closed 2008 Jan anonymous   2008 Jan   1 1 FTS3 misses document, but finds non-matching ones instead
2895 build closed 2008 Jan anonymous   2008 Jan   3 1 Please describe how to run an indvidual test out of the test suite
2894 code fixed 2008 Jan anonymous   2008 Jan   1 1 virtual table calls Next() and Column() after Eof() returns true
2893 code closed 2008 Jan anonymous   2009 Oct   1 1 incorrect integer range tests
2892 new closed 2008 Jan anonymous   2009 Oct   5 5 There should be a way in the api to read more precise error message.
2891 code closed 2008 Jan anonymous   2008 Feb   2 3 col with "NOT NULL", no default: works on table create, not col add
2890 build closed 2008 Jan anonymous   2008 Jan   1 1 Assistance request fixing six 3.5.4 i/o test failures
2889 build closed 2008 Jan anonymous   2008 Jan   3 2 Cannot disable TCL
2888 code closed 2008 Jan anonymous   2008 Jan   3 4 statement not commited
2887 code closed 2008 Jan anonymous   2008 Jan anonymous 5 5 || not outputing correctly with empty fields
2886 code closed 2008 Jan anonymous   2009 Oct   3 3 testfixture: -fPIC needed when building extension(s)
2885 code closed 2008 Jan anonymous   2009 Oct   4 4 (minor) fulltest failures
2884 new closed 2008 Jan anonymous   2009 Oct   4 4 Way to find out limits
2883 code fixed 2008 Jan anonymous   2008 Jan   1 1 compile error - missing data
2882 code closed 2008 Jan anonymous   2009 Oct   3 3 fulltest failure: ./testfixture: wrong # args: should be "cksum db"
2881 build closed 2008 Jan anonymous   2009 Oct   1 1 Latest sqlite-3.5.4 build fail on latest Fedora 2.6.23.12-52.fc7
2880 code fixed 2008 Jan anonymous   2008 Jan   1 1 problem with reals bigger then 1e18
2879 code closed 2008 Jan anonymous   2009 Oct anonymous 4 3 VACUUM enters temporary sequence numbers in sqlite_sequence
2878 code closed 2008 Jan anonymous   2008 Jun   1 1 Memory leaks with latest CVS [4693]
2877 code fixed 2008 Jan anonymous   2008 Jan   1 1 Unescaped quotation marks in mkopcodeh.awk (CVS [4693])
2876 build closed 2008 Jan anonymous   2008 Jan   1 1 3.5.4 fails to build on OpenBSD...
2875 code closed 2008 Jan anonymous   2009 Oct   3 2 LIKE does not work with lowercase swedish characters
2874 code closed 2008 Jan anonymous   2009 Oct   1 1 THREADSAFE #define HAVE_LOCALTIME_R, HAVE_GMTIME_R in os_unix.c
2873 code fixed 2008 Jan anonymous   2008 Mar   1 1 HAVE_USLEEP, HAVE_FDATASYNC=1 detected but not used by configure; make
2872 code closed 2008 Jan anonymous   2009 Oct   4 4 Some table scan operations could use an index for better data density
2871 build closed 2008 Jan anonymous   2008 Jan   3 3 SQLite 3.5.4 build process does not listen to --disable-tcl
2870 code closed 2008 Jan anonymous   2008 Jan danielk1977 5 5 Comment error
2869 new closed 2008 Jan anonymous   2009 Oct   5 5 add "sqlite3_open16_v2" to the C API
2868 code closed 2008 Jan anonymous   2008 Jan   1 1 Encryption user can't link latest SQLite
2867 code closed 2008 Jan anonymous   2009 Oct   2 2 doesn't build on Cygwin - wrong sqlite3 exe suffix
2866 build closed 2008 Jan anonymous   2009 Oct   1 3 Problems building Windows native in cygwin/mingw environment
2865 code closed 2007 Dec anonymous   2008 Jun   1 2 FTS3 does not build with amalgamation in CVS
2864 doc closed 2007 Dec anonymous   2009 Oct   5 3 ext/fts3/README.txt
2863 code closed 2007 Dec anonymous   2009 Oct   2 3 test cast-3.14, cast-3.18 and cast-3.24 fail
2862 warn closed 2007 Dec anonymous   2008 Jan   4 3 Small warning fix
2861 doc closed 2007 Dec anonymous   2008 Jan   1 1 How do I connect to Crystal Reports - I am using vs2003 & the Finisar
2860 todo closed 2007 Dec anonymous   2009 Oct   3 1 Database file fragmentation
2859 code closed 2007 Dec anonymous   2009 Oct drh 3 2 Inconsistent column names with DISTINCT
2858 build closed 2007 Dec anonymous   2008 Jan danielk1977 3 3 amalgamated sqlite3.c requires sqlite3ext.h
2857 code closed 2007 Dec anonymous   2009 Dec   2 2 GROUP BY cost estimate wrong with WHERE clause
2856 doc closed 2007 Dec anonymous   2009 Oct anonymous 4 3 SQLite Documentation - Tcl API - Link broken
2855 code closed 2007 Dec anonymous   2007 Dec drh 2 3 Get an error "11:database disk image is malformed" during queries
2854 code closed 2007 Dec danielk1977   2007 Dec danielk1977 1 1 BEGIN EXCLUSIVE does not prevent other shared-cache users from reading
2853 new active 2007 Dec anonymous   2008 Jan   2 3 optimizer fails to use an index on MAX subquery
2852 code fixed 2007 Dec anonymous   2007 Dec   4 4 sqlite library is sometimes 40K bigger when built on OpenBSD
2851 code fixed 2007 Dec anonymous   2007 Dec   1 1 make test double free or corruption error
2850 code fixed 2007 Dec anonymous   2007 Dec   2 2 CSV output missing quotes if contains equals character
2849 doc fixed 2007 Dec anonymous   2007 Dec   5 5 unary operator !
2848 code closed 2007 Dec anonymous   2007 Dec   4 4 windows CRLF is incorrectly handled by .dump
2847 new closed 2007 Dec anonymous   2008 Jun   5 4 Include major, minor, and patch version numbers in sqlite.h
2846 build fixed 2007 Dec anonymous   2007 Dec   1 1 --disable-tcl does not work
2845 code closed 2007 Dec rse   2009 Jan   3 3 SQLite 3.5.4 requires TCL during built-time
2844 build closed 2007 Dec anonymous   2009 Oct   4 1 lemon is being built without respecting LDFLAGS
2843 code fixed 2007 Dec anonymous   2007 Dec   3 4 Low memory crash in sqlite3ExprCodeAndCache
2842 code closed 2007 Dec anonymous   2008 Jun   1 1 .import does not recongnise NULL values
2841 todo closed 2007 Dec anonymous   2009 Oct   1 1 The sqlite mailing list has become overrun by trolls
2840 doc fixed 2007 Dec anonymous   2007 Dec   5 4 Punctuation errors in comment
2839 new defer 2007 Dec anonymous   2007 Dec   4 4 Deleting row from sqlite_stat1 will not take effect until next connect
2838 code fixed 2007 Dec anonymous   2007 Dec   3 3 Request: use traditional way to build CLI
2837 code closed 2007 Dec anonymous   2007 Dec   2 2 can't build testfixture in latest CVS
2836 build closed 2007 Dec anonymous   2007 Dec   1 1 Undefined symbol 'OP_StackDepth'
2835 code fixed 2007 Dec anonymous   2007 Dec   1 1 Lemon memory read/write errors
2834 event closed 2007 Dec anonymous   2007 Dec   2 1 Is Version 3.1.3 not compatible with 3.5.3 ?
2833 doc fixed 2007 Dec anonymous   2007 Dec   5 1 typo on SQLite home page
2832 code fixed 2007 Dec anonymous   2007 Dec   1 1 Data corruption with UPDATE or DELETE clause ...
2831 new closed 2007 Dec anonymous   2009 Oct   3 4 alter view
2830 code closed 2007 Dec anonymous   2007 Dec   5 5 tkt2822.test refers to tkt2820 ?
2829 code fixed 2007 Dec anonymous   2007 Dec   1 1 Win32: temp files left over in temp area
2828 code closed 2007 Dec anonymous   2007 Dec   1 2 SQLITE_OMIT_SUBQUERY compile error: sqlite3CodeSubselect() missing.
2827 code fixed 2007 Dec anonymous   2007 Dec   1 1 make test: vacuum2.test did not close all files: 1
2826 build fixed 2007 Dec anonymous   2007 Dec   4 4 test_thread.c won't build if !SQLITE_THREADSAFE || !TCL_THREADS
2825 code closed 2007 Dec anonymous   2009 Oct   3 3 FormatMessage (win32) should use extra flag and convert from Unicode
2824 code closed 2007 Dec anonymous   2007 Dec   1 1 enable shared cache problem
2823 code closed 2007 Dec anonymous   2007 Dec   1 1 query not return values
2822 code fixed 2007 Dec anonymous   2007 Dec   3 3 ORDER BY term number 1 does not match any result column in select.c
2821 new closed 2007 Dec anonymous   2009 Oct   3 4 hashtable indicies
2820 code fixed 2007 Dec anonymous   2007 Dec   1 1 rollback doesn't work
2819 code closed 2007 Dec anonymous   2007 Dec   2 1 Blocking and crashing
2818 code closed 2007 Dec anonymous   2007 Dec   2 4 Comparison of 8 bytes integer numbers is truncated
2817 code closed 2007 Dec danielk1977   2007 Dec danielk1977 1 1 Temp-tables with the same name as database tables can cause corruption
2816 code closed 2007 Dec anonymous   2007 Dec drh 4 3 .timer missing from CLI
2815 doc fixed 2007 Dec anonymous   2007 Dec   2 3 sqlite3_blob_close closes blob even when reporting error!
2814 code closed 2007 Nov anonymous   2009 Oct   3 3 _XOPEN_SOURCE again
2813 build closed 2007 Nov anonymous   2009 Oct   1 1 compile error on Windows CE
2812 new closed 2007 Nov anonymous   2007 Dec   3 4 SQLITE_SECURE_DELETE overwrites with 0, but should use random data
2811 code fixed 2007 Nov anonymous   2007 Nov   5 4 "appropriate" misspelled "approriate" on SQLite Documentation page
2810 code closed 2007 Nov anonymous   2009 Oct   1 1 Unregistered collation problems with simple subselects
2809 code closed 2007 Nov anonymous   2009 Oct   1 1 PRAGMA collation_list shows unregistered collations
2808 doc closed 2007 Nov anonymous   2009 Oct   4 2 Documentation GIF images take up too much space
2807 doc fixed 2007 Nov anonymous   2007 Nov   4 3 Link errors in Documentation
2806 code fixed 2007 Nov anonymous   2007 Nov   3 4 Low memory assert in insertCell()
2805 code fixed 2007 Nov anonymous   2007 Nov   1 1 Checkin [4573] Home grown recursive mutexes
2804 code closed 2007 Nov anonymous   2007 Dec   1 1 PRAGMA legacy_file_format=OFF setting lost with VACUUM
2803 code fixed 2007 Nov anonymous   2007 Nov   4 3 test: io-4.2.2 fails on 64-bit --- signed extension
2802 code closed 2007 Nov anonymous   2007 Dec   1 1 SELECT UNION and EXCEPT seem to have a memory allocation bug
2801 code fixed 2007 Nov anonymous   2007 Nov   5 5 superfluous -lpthread for CLI in publish_osx.sh
2800 build fixed 2007 Nov anonymous   2007 Nov   5 5 -lpthread not needed for publish.sh for CLI binary
2799 build fixed 2007 Nov anonymous   2007 Nov   3 3 'configure ' cannot locate VERSION file
2798 build closed 2007 Nov anonymous   2007 Nov   3 4 Wrong nm used when cross-compiling
2797 code fixed 2007 Nov anonymous   2007 Nov   3 3 Low memory SEGV in whereClauseClear()
2796 code fixed 2007 Nov anonymous   2007 Nov   3 3 Another low memory SEGV in exprAnalyze()
2795 code fixed 2007 Nov anonymous   2007 Nov   3 3 Low memory SEGV in exprAnalyze()
2794 code fixed 2007 Nov anonymous   2007 Nov   3 3 Low memory SEGV in isLikeOrGlob()
2793 code closed 2007 Nov anonymous   2009 Oct   3 3 fts3 lacks scoping
2792 code fixed 2007 Nov anonymous   2007 Nov   3 3 invalidateCursorsOnModifiedBtrees has no scoping
2791 code closed 2007 Nov anonymous   2009 Oct   1 1 Allow building FTS[123] as part of sqlite library with configure
2790 code closed 2007 Nov anonymous   2007 Nov danielk1977 2 2 sqlite3_compile returns NULL for empty statements
2789 code fixed 2007 Nov anonymous   2007 Nov   3 3 Low memory double free from addWhereTerm
2788 build fixed 2007 Nov anonymous   2007 Nov drh 3 3 FormatMessageA not defined for Windows Mobile
2787 build closed 2007 Nov anonymous   2009 Jan   4 5 sqlite3.pc is not remade
2786 code closed 2007 Nov anonymous   2009 Jan   4 4 sqlite3.pc does not mention -lpthread when used with --static flag
2785 doc fixed 2007 Nov anonymous   2007 Nov   3 3 Broken Anchors in C API Reference
2784 code fixed 2007 Nov anonymous   2007 Nov   1 3 Low memory double free and SEGV from flattenSubquery()
2783 doc fixed 2007 Nov anonymous   2007 Nov   5 4 Broken links into the website
2782 code closed 2007 Nov anonymous   2007 Nov   1 1 bind_text(...) into transaction
2781 doc fixed 2007 Nov anonymous   2007 Nov   5 4 Make documentation available offline (i.e. pdf, chm, etc)
2780 build fixed 2007 Nov anonymous   2007 Nov   3 3 sqliteint.h: test to disable _XOPEN_SOURCE uses wrong macro for OSX
2779 code closed 2007 Nov anonymous   2007 Nov   2 2 Performance optimizations
2778 code closed 2007 Nov anonymous   2007 Nov adixon 1 1 Error 0
2777 code closed 2007 Nov anonymous   2007 Nov shess 1 1 FTS[23] compile bug
2776 warn closed 2007 Nov anonymous   2008 Mar   5 1 mailing list
2775 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 4 Low-memory SEGV from sqlite3CodeRowTrigger()
2774 code fixed 2007 Nov shess   2007 Nov shess 1 1 Crash merging empty OR queries in fts3.
2773 code closed 2007 Nov danielk1977   2007 Nov   2 1 sqlite crashes in sqlite3_step when compiled with SQLITE_THREADS=1
2772 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 Low memory assert in analyze
2771 code active 2007 Nov anonymous   2007 Nov   4 4 Lemon: Generated parser needs stdlib.h (not in default template)
2770 code closed 2007 Nov anonymous   2009 Oct   1 1 Problem with BLOB in 3.5.x ?
2769 new closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 Enable access to the sql string used to prepare a statement
2768 code closed 2007 Nov anonymous   2007 Nov danielk1977 3 3 asserts in wrong order
2767 code fixed 2007 Nov anonymous   2007 Nov   2 1 UPDATE causes ./src/vdbe.c:503: sqlite3VdbeExec: Assertion `pTos<=&p->
2766 code active 2007 Nov drh   2007 Nov   1 1 TCL transaction started from within a query does not commit
2765 code closed 2007 Nov anonymous   2007 Nov   1 3 bad rollback if temporary table created during transaction
2764 todo closed 2007 Nov anonymous   2007 Nov   2 2 Since I installed Leopard I keep getting sqlite3 data bases in trash
2763 build closed 2007 Nov anonymous   2009 Oct   4 4 AIX build failure due to explicit _XOPEN_SOURCE definition
2762 code fixed 2007 Nov anonymous   2007 Nov   3 3 fts3 is cavalier about malloc vs sqlite3_malloc
2761 code closed 2007 Nov anonymous   2009 Sep   3 3 CLI (shell.c) should be bundled with amalgamation
2760 new closed 2007 Nov anonymous   2009 Oct   5 4 request: sqlite3_unlink() to delete db files.
2759 code closed 2007 Nov anonymous   2007 Nov danielk1977 1 2 crash due to 'select * from virtualTable where x is null'
2758 code closed 2007 Nov anonymous   2007 Dec   1 1 Why this?
2757 doc closed 2007 Nov anonymous   2007 Nov   1 1 Special characters handling in SQLite Like Query
2756 new closed 2007 Nov anonymous   2009 Oct   1 1 allow vacuum to change pragma setting instead of using existing ones
2755 code active 2007 Nov anonymous   2007 Nov   3 3 trace interfere with transaction Tcl interface
2753 code closed 2007 Nov anonymous   2009 Oct drh 3 3 Master journal files sometimes not deleted
2752 code closed 2007 Nov anonymous   2007 Nov   5 5 redundant assignment?
2751 build closed 2007 Oct anonymous   2007 Nov   2 3 Regression - Solaris/sparc throws BUS ERROR on count()/sum()/etc.
2750 code closed 2007 Oct anonymous   2007 Oct   2 1 for the new.somefield value returns the old value of it
2749 warn closed 2007 Oct anonymous   2009 Oct   3 4 SQLITE_OMIT_FLOATING_POINT, int constants too large
2748 warn closed 2007 Oct anonymous   2009 Oct   4 4 amalgamation: SQLITE_OMIT_ALTERTABLE warnings
2747 code closed 2007 Oct anonymous   2007 Nov maria.khomenko 1 1 How to use Composite Key in Sqlite
2746 code closed 2007 Oct anonymous   2007 Oct   1 1 PRIMARY KEY does not treat NULL as unique
2745 code closed 2007 Oct anonymous   2007 Oct shazow 1 1 Sharing File between two processes
2744 code closed 2007 Oct drh   2007 Nov danielk1977 1 1 Cannot quote collating sequence name
2743 doc closed 2007 Oct anonymous   2007 Oct   1 1 Comparison of SQLite against McObject Fusion
2742 code closed 2007 Oct anonymous   2007 Oct   1 1 codeInteger and codeReal
2741 code fixed 2007 Oct anonymous   2007 Oct   3 3 _XOPEN_SOURCE may be necessary for pread/pwrite as well as threads
2740 code fixed 2007 Oct anonymous   2007 Oct   4 4 incorrect assertions in vdbe.c
2739 code fixed 2007 Oct anonymous   2007 Oct   2 3 large-file enable macros should be defined before first #include
2738 code fixed 2007 Oct anonymous   2007 Oct   2 2 vfsUnlink breaks when building with OS_OTHER=1
2737 code fixed 2007 Oct anonymous   2007 Oct   4 4 save 35 bytes in VACUUM with new 2 argument substr()
2736 build closed 2007 Oct anonymous   2009 Oct   2 2 build problems on freebsd
2735 code closed 2007 Oct anonymous   2007 Oct nmadhav 3 1 Error : Unrecognized Token
2734 code closed 2007 Oct anonymous   2007 Oct   3 1 2 bug under the wince
2733 code fixed 2007 Oct anonymous   2007 Oct   1 1 OP_Real and OP_Int64 inefficient for constants
2732 code fixed 2007 Oct anonymous   2007 Oct   2 2 sqlite3Step crashes if called with a null argument (easy fix)
2731 code closed 2007 Oct anonymous   2007 Oct   1 1 sqlite3ExprCode TK_UMINUS inefficient with large negative floats
2730 code closed 2007 Oct anonymous   2007 Oct anonymous 3 2 Can't compile for WindowsCE
2729 doc active 2007 Oct anonymous   2007 Oct   1 1 Lemon: %fallback, %wildcard, and @X uncodumented
2728 code closed 2007 Oct anonymous   2009 Oct   4 4 Some indexes could contain pointers not the data
2727 build closed 2007 Oct anonymous   2009 Oct   4 4 building with -malign-double causes strange behavior
2726 code closed 2007 Oct anonymous   2007 Oct   4 3 solaris 10 compilation B_FALSE, B_TRUE clash from sys/types.h
2725 code closed 2007 Oct anonymous   2008 Jun   1 1 memory leak in sqlite3_open_v2() when it fails
2724 code closed 2007 Oct anonymous   2007 Dec drh 2 2 Load Ext api missing error_toobig function.
2723 new closed 2007 Oct anonymous   2007 Oct anonymous 5 4 After execution of SQL, the Data Returned should display the col.name
2722 code fixed 2007 Oct anonymous   2007 Oct   1 1 data mis-alignment in UTF16 collation callback arguments
2721 code closed 2007 Oct anonymous   2009 Oct   2 1 if db file is in a folder with non-ansi character some functions fail
2720 code closed 2007 Oct anonymous   2007 Oct   1 1 WinCE - Can't write
2719 code closed 2007 Oct anonymous   2007 Oct   3 1 WinCE winFullPathName doesn't return a value
2718 build closed 2007 Oct anonymous   2007 Oct   2 1 WinCE compile error
2717 doc closed 2007 Oct anonymous   2007 Dec anonymous 5 5 Document clarification around SQLITE_OMIT_MEMORY_ALLOCATION
2716 new closed 2007 Oct anonymous   2009 Oct   5 1 Create Clear Command
2715 code closed 2007 Oct anonymous   2009 Oct   1 1 no authorization needed to remove authorizer
2714 code closed 2007 Oct anonymous   2009 Oct drh 3 4 Shell cannot import large files greater than 2 GB [patch]
2713 build fixed 2007 Oct anonymous   2007 Oct   1 5 build fails for 3.5.1 on win32/cygwin - duplicate opcode labels
2712 code closed 2007 Oct anonymous   2007 Oct   5 4 Expose a function to change the journal filename location
2711 code fixed 2007 Oct anonymous   2007 Oct   1 1 WinCE: flags incorrectly checked
2710 code fixed 2007 Oct anonymous   2007 Oct   1 1 Typo in code specific to WinCE (checkin 4479)
2709 code closed 2007 Oct anonymous   2007 Oct   2 3 Some SQLITE_OMIT_* keys break the sqlite3.c amalgamation compilation
2708 code closed 2007 Oct anonymous   2008 Jun   4 2 SQL error:disk I/O error
2707 code closed 2007 Oct anonymous   2007 Oct appledev 1 3 SQLite on Mac OS X seems to have a 4GB database limit
2706 warn closed 2007 Oct anonymous   2007 Oct danielk1977 4 4 make test aborts when built with SQLITE_OMIT_ATTACH
2705 code closed 2007 Oct anonymous   2009 Oct   4 4 testfixture unresolved externals with SQLITE_OMIT_GET_TABLE
2704 code closed 2007 Oct anonymous   2009 Oct   4 4 "make test" aborts before completion with SQLITE_OMIT_BLOB_LITERAL
2703 code closed 2007 Oct anonymous   2009 Oct   3 4 make test does not work with SQLITE_OMIT_FLOATING_POINT
2702 code fixed 2007 Oct anonymous   2007 Oct   1 1 Errors in CreateFileW function use on WinCE
2701 new closed 2007 Oct anonymous   2009 Oct   5 5 Make INSERT-ing multiple rows MySQL-compatible
2700 code fixed 2007 Oct anonymous   2007 Oct   1 1 invalid name in winOpen when compiling under WinCE
2699 code fixed 2007 Oct anonymous   2007 Oct   2 2 Performance issues in 3.5.1 (Windows)
2698 code fixed 2007 Oct anonymous   2007 Oct   3 4 memory leak in WIN CE because tempfilename is not freed at WinClose
2697 code fixed 2007 Oct anonymous   2007 Oct   1 3 sqlite3_open_v2 fails then filename includes non-english chars
2696 code fixed 2007 Oct anonymous   2007 Oct   3 3 sqlite3.c with SQLITE_OMIT_FLOATING_POINT cannot compile on Linux
2695 new closed 2007 Oct anonymous   2007 Oct drh 3 3 sqlite3 CLI unresolved externals with SQLITE_OMIT_GET_TABLE
2694 code fixed 2007 Oct anonymous   2007 Oct drh 2 2 Makefile.in is missing invokation of mksqlite3internalh.tcl for a10n
2693 code fixed 2007 Oct anonymous   2007 Oct drh 2 2 mutex.h missing in a10n of sqlite3internal.h
2692 build closed 2007 Oct anonymous   2007 Oct   1 1 COmpilation of Sqlite amalgamation v3.4.2. failed
2691 code closed 2007 Oct anonymous   2007 Oct   1 1 SQLITE_OMIT_AUTHORIZATION compilation error
2690 code closed 2007 Oct anonymous   2007 Oct   3 4 "PRAGMA synchronous = OFF;" is more dangerous than documented
2689 build closed 2007 Oct anonymous   2007 Oct   3 4 make test fails in 3.5.1 - unresolved externals in testfixture
2688 build closed 2007 Oct anonymous   2007 Oct   3 1 SQLITE_OMIT_AUTHORIZATION build failure
2687 code fixed 2007 Oct anonymous   2007 Nov   3 2 Building with _UNICODE fails in Win32 (3.5.1)
2686 code fixed 2007 Oct anonymous   2007 Oct   3 3 Integrity check fails if you hit max_page_count and dont rollback
2685 code fixed 2007 Oct anonymous   2007 Oct anonymous 2 1 Compilation under MSVC gives warning on TryEnterCriticalSection
2684 code closed 2007 Oct anonymous   2008 Jun   1 1 Accessing sqlite from an NT service will lock the complete databse.
2683 code fixed 2007 Oct anonymous   2007 Oct   1 1 Windows CE won't compile, also a problem with sqlite3OsFullPath on CE
2682 code closed 2007 Oct anonymous   2007 Oct   1 1 SQLite Text Problem
2681 code fixed 2007 Oct anonymous   2007 Oct   3 3 #ifndef _XOPEN_SOURCE needed around #define _XOPEN_SOURCE 500
2680 code fixed 2007 Sep anonymous   2007 Oct   2 2 sqlite_int64 vs sqlite3_int64 type confusion in headers and docs
2679 code closed 2007 Sep anonymous   2007 Oct   2 3 locking errors lead to disk i/o failure with bulk operations on winxp
2678 code fixed 2007 Sep anonymous   2007 Oct   1 1 amalgamation zip file should include sqlite3ext.h
2677 new closed 2007 Sep anonymous   2009 Oct danielk1977 5 3 CREATE TRIGGER .. {databaseevent ON ... }+ for multiple events
2676 code closed 2007 Sep anonymous   2007 Sep   1 1 TEMP_STORE does not appear to be set by the compile time switch
2675 new closed 2007 Sep anonymous   2007 Sep   1 1 TEMP_STORE does not appear to be set by the compile time switch
2674 code closed 2007 Sep anonymous   2009 Oct   3 4 NFS fails without lock manager
2673 build fixed 2007 Sep anonymous   2007 Oct   4 4 3.5.0 amalgamation on OS X, "#define _XOPEN_SOURCE 500" fails build
2672 doc fixed 2007 Sep anonymous   2007 Oct   1 3 icu ext init failure: sqlite3_create_function returns SQLITE_BUSY
2671 code closed 2007 Sep shess   2009 Oct shess 2 4 Fts field-based queries are not correctly case-insensitive.
2670 doc closed 2007 Sep anonymous   2007 Oct   5 4 Document for EXPLAIN doesn't mention using EXPLAIN QUERY PLAN
2669 code closed 2007 Sep anonymous   2007 Sep anonymous 2 3 INSERT of Large REAL value fails with Floating Point Exception
2668 code closed 2007 Sep anonymous   2007 Oct   3 4 Build failure due to syntax error under Cygwin
2667 code closed 2007 Sep anonymous   2007 Oct   1 1 no such function: hex no such function: regexp
2666 doc fixed 2007 Sep anonymous   2007 Oct   4 4 Typos/spelling errors in sqlite3.h
2665 code closed 2007 Sep anonymous   2007 Sep   3 1 Dissapearing exclusive lock when DB is copied...
2664 code active 2007 Sep danielk1977   2007 Sep   1 1 attaching the same db twice in shared-cache mode fails
2663 code closed 2007 Sep anonymous   2007 Oct   3 3 Adding a column with default value not reflected in view
2662 code closed 2007 Sep anonymous   2007 Sep   1 1 Serious Performance Degradation from 3.3.4 to 3.3.5 & latest versions
2661 code closed 2007 Sep anonymous   2007 Sep   2 3 Single line, multi inserts
2660 code closed 2007 Sep anonymous   2007 Sep   4 4 Spelling error in comment for SQLITE_CONSTRAINT
2659 code fixed 2007 Sep rse   2007 Sep danielk1977 2 2 openDirectory function broken
2658 code fixed 2007 Sep anonymous   2007 Sep   2 3 sqlite3VtabOverloadFunction broken
2657 build closed 2007 Sep anonymous   2007 Oct anonymous 1 1 fail to compile
2656 doc closed 2007 Sep anonymous   2007 Oct   2 1 missing documentation: END TRANSACTION
2655 code closed 2007 Sep anonymous   2007 Sep   2 3 Reuse prepared statement after locked(5) gives called out of seq(21)
2654 code closed 2007 Sep anonymous   2007 Oct jadams 1 1 sqlite3_prepare return 1(fail)
2653 code closed 2007 Sep anonymous   2009 Oct   3 4 Exclusive Transactions do not work with a Database File attached twice
2652 code active 2007 Sep drh   2007 Sep   1 1 Aggregate function cannot be used from within a subquery
2651 new closed 2007 Sep anonymous   2009 Oct   5 4 Add support for overriding home directory location
2650 build closed 2007 Sep anonymous   2007 Sep   1 1 lack ; in os_win.c:1329
2649 new fixed 2007 Sep anonymous   2008 Mar   4 4 Add an "--enable-extensions" (default=no) to the configure script
2648 build fixed 2007 Sep anonymous   2007 Sep   1 1 compilation error for PocketPC/WindowsCE
2647 code closed 2007 Sep anonymous   2007 Sep   1 1 sqlite-3.5.0 Cygwin: Compilation fails on src/os_win.c - ';' missing
2646 code closed 2007 Sep anonymous   2007 Sep a.rottmann 4 1 sqlite3_get_table loses one table row
2645 build closed 2007 Sep anonymous   2009 Oct   5 4 Conflict between tclConfig.sh and tclinstaller.tcl
2644 code closed 2007 Sep anonymous   2007 Sep   1 1 sqlite
2643 code fixed 2007 Sep anonymous   2007 Sep   1 1 bestIndex: Assertion `flags!=0' failed after index creation
2642 code closed 2007 Sep anonymous   2007 Sep   5 5 CYGWIN compile error due to missing semicolon
2641 code closed 2007 Sep anonymous   2007 Sep   2 3 sqlite - Ticket #2638 continued as it was arbitrarily closed unsolved
2640 code fixed 2007 Sep anonymous   2007 Sep   1 1 sqlite doesn't treat global identifiers correctly in a subquery
2639 code closed 2007 Sep anonymous   2007 Oct   1 2 Russian charset
2638 code closed 2007 Sep anonymous   2007 Sep   2 3 selects on japanese text okay in 3.3.5 bad in later versions
2637 code closed 2007 Sep anonymous   2007 Sep   1 1 Segfault in pthread_getspecific ()
2636 code closed 2007 Sep anonymous   2007 Sep   1 1 Bug in sqlite3_prepare_v2
2635 code closed 2007 Sep anonymous   2007 Sep   3 2 problem with calculation of juliand date
2634 code closed 2007 Sep anonymous   2009 Oct   3 3 .schema uses incorrect ORDER BY giving wrong dependency order
2633 build fixed 2007 Sep anonymous   2007 Sep   1 1 building with gcc3.3.4 - undefined reference to `sqlite3KeywordCode'
2632 code fixed 2007 Sep anonymous   2008 Mar danielk1977 5 2 sqlite3* not available within loadable extension <sqlite3ext.h>
2631 code fixed 2007 Sep anonymous   2007 Sep   3 3 Comments at end of "CREATE TABLE" cause SQL error.
2630 code closed 2007 Sep anonymous   2007 Oct a.rottmann 2 2 sqlite3PagerOpen set a wrong temp file name in pPager->zFilename
2629 doc fixed 2007 Sep anonymous   2008 Jun   4 4 typo in os_unix.c for nolock
2628 code fixed 2007 Sep anonymous   2007 Sep   3 4 Bad error handling for invalid page-size
2627 code closed 2007 Sep anonymous   2009 Oct   3 2 Improper parsing of nested JOIN
2626 code closed 2007 Sep anonymous   2007 Sep   1 1 The Amalgamation compile error
2625 build closed 2007 Sep anonymous   2007 Sep   2 2 http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet has problem
2624 code fixed 2007 Sep anonymous   2007 Sep   1 1 Invalid documentation references in sqlite.h.in
2623 code fixed 2007 Sep anonymous   2007 Sep   1 1 zeroblob(-1) returns non-NULL from sqlite3_column_blob()
2622 doc fixed 2007 Sep anonymous   2007 Sep   3 3 SQLITE_OMIT_MEMORY_ALLOCATION undocumented unresolved functions
2621 code fixed 2007 Sep anonymous   2007 Sep   1 5 another typo
2620 doc closed 2007 Sep anonymous   2007 Sep   5 5 doc note needed for sqlite3_memory_alarm()
2619 doc fixed 2007 Sep anonymous   2007 Sep   5 5 typo
2618 code closed 2007 Sep anonymous   2007 Sep linus 4 1 Dabase is Locked
2617 code closed 2007 Sep anonymous   2007 Sep drh 2 3 Check in #4357 may lead to bugs in SMP aware systems in windows vfs
2616 code fixed 2007 Sep anonymous   2007 Sep   1 1 Flags parameter not honoured in openDatabase()
2615 code fixed 2007 Sep anonymous   2007 Sep   1 1 winRandomness without effect due to < vs. > mixup
2614 code closed 2007 Sep anonymous   2007 Sep   1 1 Custom VFS still calls default xRandomness
2613 new closed 2007 Sep anonymous   2009 Oct drh 3 3 replace doesn't work with blobs containing \x0, otherwise it does
2612 code fixed 2007 Sep anonymous   2007 Sep   1 1 enterMutex() misnamer
2611 code fixed 2007 Sep anonymous   2007 Sep   2 1 AV calling sqlite3_vfs_register()
2610 code fixed 2007 Sep anonymous   2007 Sep drh 4 3 SQLITE_API sqlite3_sleep function header missing in sqlite3ext.h
2609 code closed 2007 Sep anonymous   2007 Sep   1 1 Is non-thread safe binaries dangerous for multi-threaded app design ?
2608 code fixed 2007 Aug anonymous   2007 Sep   3 3 failed allocation leads to unexpected infinite loop
2607 event closed 2007 Aug anonymous   2009 Oct   2 1 Data loss, continuation to Re: [sqlite] how to flush database to disk?
2606 code fixed 2007 Aug anonymous   2007 Sep   3 3 PATCH - default configure option enable_threadsafe=yes
2605 build closed 2007 Aug anonymous   2007 Aug   1 3 Amalgamated version 3.4.2 doesn't compile (VC++6)
2604 new closed 2007 Aug anonymous   2009 Oct   4 4 CREATE VIRTUAL TABLE does not allow IF NOT EXISTS
2603 new closed 2007 Aug anonymous   2007 Oct   1 3 B-tree and B+tree allow bidirectional cursor but VDBE does not.
2602 code fixed 2007 Aug anonymous   2007 Aug   1 1 ATTACH leaks memory
2601 code closed 2007 Aug anonymous   2007 Oct   1 1 Problem with opening database with Unicode filename
2600 code fixed 2007 Aug anonymous   2007 Aug   1 1 #ifdef SQLITE_MUTEX_WIN32 naming error in mutex_w32.c?
2599 code fixed 2007 Aug anonymous   2007 Aug   1 1 OS check in mutex.h has no effect
2598 code fixed 2007 Aug anonymous   2007 Oct   3 3 Failure to delete temporary files on WINCE platforms
2597 code fixed 2007 Aug anonymous   2007 Oct   1 1 tclsqlite "db eval" with array-name doesn't have "*" entry. (tcl8.5a7)
2596 code closed 2007 Aug anonymous   2007 Aug   2 2 wrong specifier for extern char arrays
2595 doc closed 2007 Aug anonymous   2009 Oct   4 4 sqlite3_commit_hook doc typo
2594 code closed 2007 Aug anonymous   2007 Aug   5 4 ability to replace allocator
2593 code closed 2007 Aug anonymous   2007 Aug   1 1 btshared unlock bug
2592 warn closed 2007 Aug anonymous   2007 Aug   1 1 The Entry C:\Windows\Temp\sqlite_z6onAYdsVGqLG3Q is Invalid
2591 doc fixed 2007 Aug anonymous   2007 Aug   4 4 sqlite3_open() documentation should mention :memory:
2590 todo closed 2007 Aug anonymous   2007 Aug danielk1977 2 2 return value of strftime('%s', 'now') being determined as 'text'
2589 doc closed 2007 Aug anonymous   2007 Aug danielk1977 4 4 s/effected/affected/ in PRAGMA locking_mode
2588 code fixed 2007 Aug anonymous   2007 Aug   1 1 bug in sqlite3_mutex_leave
2587 build closed 2007 Aug anonymous   2009 Oct   3 4 Build problem when using the SQLITE_OMIT_FLOATING_POINT define.
2586 code closed 2007 Aug anonymous   2007 Aug   3 3 INSERT of large number fails on Windows
2585 code closed 2007 Aug anonymous   2007 Oct anonymous 1 1 Error Function GetAtomNameA
2584 new closed 2007 Aug anonymous   2007 Aug   1 2 On Windows function sqlite3WinSleep needs to dispatch messages
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
2582 doc closed 2007 Aug anonymous   2009 Oct mihailim 5 5 documenation clarification
2581 code closed 2007 Aug anonymous   2007 Aug   1 1 ./configure && make broken: new source files: mem[12].c, mutex.c, etc
2580 code closed 2007 Aug anonymous   2009 Oct anonymous 1 2 Can't open a query if text to search is Greek
2579 code fixed 2007 Aug anonymous   2007 Oct   4 3 the third parameter of substr should be optional
2578 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3BtreeEnter, sqlite3BtreeLeave threading issues
2577 code closed 2007 Aug anonymous   2007 Aug   5 5 Initilizing pointers to 0 instead of NULL.
2576 code closed 2007 Aug anonymous   2007 Aug   1 1 Check-in [4239] mutex race conditions
2575 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3_mutex_enter missing return
2574 build fixed 2007 Aug anonymous   2007 Aug anonymous 3 3 amalgamation 3.4.2 compile errors
2573 doc fixed 2007 Aug anonymous   2007 Aug   3 3 sqlite3_interrupt() + threads
2572 warn closed 2007 Aug anonymous   2007 Aug   1 1 Sqlitw error unrecognize token
2571 todo closed 2007 Aug anonymous   2007 Aug   1 1 SQLite opening in Access
2570 code fixed 2007 Aug anonymous   2007 Aug   3 3 unportable assumptions in sqlite3AtoF() / cast.test
2569 code closed 2007 Aug anonymous   2007 Aug   3 2 Executing a statement causes an AccessViolation Exception
2568 new closed 2007 Aug anonymous   2009 Oct   3 3 TEMP_STORE is ignored in some cases
2567 build closed 2007 Aug anonymous   2009 Oct   3 2 Build fails to install
2566 build closed 2007 Aug anonymous   2009 Oct   2 1 fts2 broken after vacuum
2565 code fixed 2007 Aug drh   2007 Aug   1 1 Database corruption following ROLLBACK when soft_heap_limit set
2564 event closed 2007 Aug anonymous   2007 Aug anonymous 4 4 in C:\windows\temp are 50 files like sqlite_fMyj88gwaTTNgUF and 0 kb
2563 code closed 2007 Aug anonymous   2007 Aug   1 1 sqlite3_column_database_name16() is broken
2562 code closed 2007 Aug anonymous   2007 Aug   2 3 Multithreaded transactions deadlock (Windows)
2561 code fixed 2007 Aug anonymous   2007 Dec   1 1 Parser broken -- ORDER BY fails in UNION between two databases
2560 doc fixed 2007 Aug anonymous   2007 Aug   5 4 Documentation typos
2559 code fixed 2007 Aug anonymous   2008 Mar   4 4 "make clean" does not delete sqlite3.c and tsrc/
2558 code active 2007 Aug anonymous   2007 Aug   2 3 Multiple JOIN USING() gives incorrect results
2557 build closed 2007 Aug anonymous   2007 Aug   3 3 make test errors on Rhel4 x86_64
2556 todo fixed 2007 Aug anonymous   2007 Aug   5 5 tabs instead of space in some source files
2555 new closed 2007 Aug anonymous   2009 Oct   1 1 FTS index without original text
2554 code fixed 2007 Aug anonymous   2007 Aug   3 3 Many symbols not marked private/static or SQLITE_API in amalgamation
2553 code closed 2007 Aug anonymous   2007 Aug   3 3 AUTOINCREMENT not working when primary key has multiple columns
2552 code closed 2007 Aug anonymous   2007 Aug   1 3 sqlite3_column_double causes invalid floating point operation
2551 code closed 2007 Aug anonymous   2007 Aug   3 3 sqlite3 shell gets into bad state with unexpected input
2550 code fixed 2007 Aug anonymous   2007 Oct drh 3 3 Lemon parser may accept input before EOF is seen
2549 build closed 2007 Aug anonymous   2007 Aug   1 3 3.4.1 fails to upgrade from 3.3.1.7 on freeBSD
2548 code fixed 2007 Aug anonymous   2007 Oct anonymous 4 4 Pelles C compiler for Windows ANSI prototype / K&R declaration errors
2547 code active 2007 Aug danielk1977   2007 Aug   5 3 Changing db encoding of an attached db can confuse shared cache mode.
2546 code fixed 2007 Jul anonymous   2007 Oct   4 1 Comments are not parsed correctly
2545 code active 2007 Jul anonymous   2007 Jul   1 4 Group by returns table name with field name
2544 code fixed 2007 Jul rse   2007 Jul   4 3 "sqlite3 foo.db .dump | sqlite3 bar.db" fail because of verbose output
2543 code closed 2007 Jul anonymous   2009 Oct   1 1 Chinese charset not support??
2542 code closed 2007 Jul anonymous   2007 Jul   2 1 select 3/2 * avg(x) gives wrong result
2541 doc closed 2007 Jul anonymous   2007 Jul danielk1977 4 4 ALTER TABLE <foo> RENAME TO <bar> doesn't update (all) trigger schema
2540 code closed 2007 Jul anonymous   2009 Oct   5 4 Display dlopen() errors for errors when loading modules on Unix system
2539 code closed 2007 Jul anonymous   2009 Oct   2 2 WinCE: Temporary etilqs_ files are not removed from temporary folder
2538 code closed 2007 Jul anonymous   2007 Jul   1 1 calling sqlite3_interrupt() randomly leaves db->ul.isInterrupted = 1
2537 code closed 2007 Jul anonymous   2007 Jul   4 4 sqlite3_column_type() function problem.
2536 code closed 2007 Jul anonymous   2007 Aug   2 3 Possible non-ID index corruption when max_page_count exceeded
2534 code closed 2007 Jul anonymous   2007 Jul danielk1977 2 3 sqlite3_set_auxdata may cause memory to be leaked
2533 code fixed 2007 Jul anonymous   2007 Oct   1 2 temporary files are not deleted on WinCe
2532 code closed 2007 Jul anonymous   2007 Jul   3 4 Endless loop in Parser?
2531 code closed 2007 Jul anonymous   2007 Jul a.rottmann 1 1 Can't find head files in icu.c
2530 code closed 2007 Jul anonymous   2009 Oct   2 3 Unable to write to windows share, even with exclusive lock
2529 code closed 2007 Jul anonymous   2007 Jul anonymous 1 1 Bug in sqlite3_prepare_v2( ) function
2528 doc fixed 2007 Jul anonymous   2007 Jul   3 2 PRAGMA auto_vacuum documentation mismatch
2527 doc closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_create_module() API documentation missing
2526 code fixed 2007 Jul anonymous   2007 Jul   2 4 Core dump when issuing a select statement with special having clause
2525 code fixed 2007 Jul anonymous   2007 Jul   1 3 Constraint violations fail silently with "insert or replace"
2524 code fixed 2007 Jul anonymous   2007 Jul   4 4 Missing error check in call to sqlite3PagerWrite() in autoVacuumCommit
2523 code fixed 2007 Jul anonymous   2007 Jul   3 4 Leaked memory on error return from sqlite3VdbeMemTranslate
2522 code fixed 2007 Jul anonymous   2007 Jul   4 4 wrong sizeof in vdbe.c
2521 code fixed 2007 Jul anonymous   2007 Jul   2 4 Misplaced prototypes
2520 new closed 2007 Jul anonymous   2009 Oct   4 1 User defined aggregate functions are not reentrant
2519 new closed 2007 Jul anonymous   2007 Oct   1 1 Page cache and schema should be shared between all connections/threads
2518 code fixed 2007 Jul anonymous   2007 Jul   2 1 Complex paging problem
2517 code closed 2007 Jul anonymous   2009 Oct dflam 1 1 exception on reading text in vista but not xp
2516 code closed 2007 Jul anonymous   2007 Jul   3 3 REGRESSION:sqlite3_prepare ignores nBytes parameter
2515 code closed 2007 Jul anonymous   2007 Jul   1 1 Entered to ASCII zeros as a text string was return a single zero.
2514 code fixed 2007 Jul anonymous   2007 Jul   3 3 max() and min() is wrong when DESC index exists
2513 code closed 2007 Jul anonymous   2007 Jul   1 2 Internal compiler error tclsqlite.c
2512 code closed 2007 Jul shess   2009 Oct   1 1 FTS virtual table name quoting problem
2511 code closed 2007 Jul anonymous   2009 Oct drh 3 2 Inconsistent Pragma output
2510 code closed 2007 Jul anonymous   2009 Oct   1 1 Vacuum modified FTS2 rowids
2509 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLITE_DATE
2508 code closed 2007 Jul anonymous   2009 Oct   1 1 utf8ToUnicode() does not work on some WinCE devices
2507 code fixed 2007 Jul anonymous   2007 Jul   1 1 test_expr expr-1.104 fails (64-bit int handling)
2506 new closed 2007 Jul anonymous   2009 Oct   3 2 New API to retrieve ROWID from SQLite3_stmt structire
2505 code closed 2007 Jul anonymous   2007 Jul   1 1 does not return error when use sqlite_open to open an non-sqlite db
2504 build closed 2007 Jul anonymous   2007 Jul   1 1 sqlite 3.4.0 fails to build FreeBSD 6.2 64-bit system
2503 code closed 2007 Jul anonymous   2009 Oct   3 4 sqlite3PagerReleaseMemory does not decrement page count
2502 code fixed 2007 Jul anonymous   2007 Jul   4 4 Digital Mars static library runtime problem
2501 build closed 2007 Jul anonymous   2007 Jul   2 3 limits.h confilct with visual studio limits.h
2500 code closed 2007 Jul anonymous   2007 Jul   2 4 Possible memory leak on avr32 arch
2499 build defer 2007 Jul anonymous   2007 Aug drh 1 1 undefined reference to `_WinMain@16'
2498 code closed 2007 Jul anonymous   2009 Oct   3 2 sqlite memory org on linux
2497 code closed 2007 Jul anonymous   2007 Jul   4 2 sqlite3_errcode does not return the proper error code
2496 code closed 2007 Jul anonymous   2009 Oct   5 4 "No such column" error should include table information
2495 code closed 2007 Jul anonymous   2007 Jul   4 4 standard C library Naming conflict - limits.h
2494 code closed 2007 Jul anonymous   2007 Jul   1 1 DRow["ID"] = reader.GetString(reader.GetOrdinal("ID")); fails
2493 build closed 2007 Jul anonymous   2007 Jul   2 3 Fails to build under GCC-4.1.3 on FreeBSD-6.2
2492 code closed 2007 Jul anonymous   2007 Jul   4 4 Incorrect protoype for function sqlite3_result_zeroblob
2491 code closed 2007 Jul anonymous   2008 Jun   1 1 Mingw Warnings w/ 3.4.0 Amalgamation
2490 code closed 2007 Jul anonymous   2007 Oct   1 1 Latest cvs 3.4.0 seg fault
2489 build closed 2007 Jul anonymous   2007 Jul   1 1 Latest cvs 3.4.0 make test fails related to TCL
2488 new closed 2007 Jul anonymous   2009 Oct   5 4 autosize on column output mode in sqlite3 program
2487 code closed 2007 Jul anonymous   2009 Oct   1 1 SQLite database locked error on NFS mounted home dir
2486 code closed 2007 Jul anonymous   2007 Sep   2 3 pragma index_list does not detect index created on 2nd connection
2485 code closed 2007 Jul anonymous   2007 Jul   1 2 SQLite + Python segfaults at various places in the code
2484 new closed 2007 Jul anonymous   2009 Oct   5 4 Support for RETURNING
2483 code closed 2007 Jul anonymous   2007 Jul   1 3 like clause not working
2482 code closed 2007 Jul anonymous   2007 Jul   3 4 Possible optimizer bug
2481 code closed 2007 Jul anonymous   2007 Jul   1 3 sqlite leaks memory (after 3.3.13)
2480 code closed 2007 Jun anonymous   2007 Aug   4 4 typo in faq.tcl
2479 code closed 2007 Jun anonymous   2009 Oct   1 1 WinCE regression on some systems. Any db open fails.
2478 code closed 2007 Jun anonymous   2007 Jun   2 2 LIMIT and OFFSET abbreviation to LIMIT x,y bug!
2476 todo closed 2007 Jun anonymous   2009 Oct   4 3 SQLite3 ignores ORDER BY clause when performing SELECT ... GROUP BY
2475 code fixed 2007 Jun anonymous   2007 Jul   1 3 Handles being left open on unix
2474 new closed 2007 Jun anonymous   2009 Oct   5 4 Multiple-record comma-delineated INSERT command
2473 warn closed 2007 Jun anonymous   2009 Oct anonymous 3 2 sqlite memory org. on linux
2472 code closed 2007 Jun anonymous   2007 Jun   1 1 smart quotes turning question marks while storing in oracle 9i DB
2471 secure closed 2007 Jun anonymous   2007 Jun   1 1 a bug for 64 bit driver under operation system
2470 code fixed 2007 Jun anonymous   2007 Jun   1 3 subselects causing reproducable SIGSEGV
2469 build closed 2007 Jun anonymous   2009 Oct   1 1 test fails on Solaris
2468 doc fixed 2007 Jun anonymous   2007 Jun   5 5 Spelling error in documentation
2467 code closed 2007 Jun anonymous   2009 Oct   4 4 changes() not reporting correctly after DELETE FROM table
2466 code fixed 2007 Jun anonymous   2007 Jun   5 5 ENCODING not used in Makefile.linux-gcc
2465 code fixed 2007 Jun anonymous   2007 Jun   4 4 64-bit/tcl regression failure with types3-1.3
2464 code fixed 2007 Jun anonymous   2007 Jun   5 4 error message not set by sqlite3_blob_write
2463 todo closed 2007 Jun anonymous   2007 Jun anonymous 1 1 Crash after calling sqlite_close() if SQLITE_ENABLE_MEMORY_MANAGEMENT
2462 todo closed 2007 Jun anonymous   2007 Jun   5 5 www.sqlite.org/cvstrac/tktnew suggestion
2461 code closed 2007 Jun anonymous   2007 Jun   2 3 BLOB retrieval produces garbled data in UTF-16
2460 code closed 2007 Jun anonymous   2007 Jun   1 1 VC6 Compile Error
2459 code closed 2007 Jun anonymous   2009 Oct   4 4 changes() not reporting correctly after "failed" multiline INSERT
2458 code closed 2007 Jun anonymous   2007 Jun   1 1 sqlite caching results between calls to select on an open database
2457 build closed 2007 Jun anonymous   2009 Oct drh 1 2 Build fails with internal compiler error (Windows, MS VC++ 6.0)
2456 new closed 2007 Jun anonymous   2009 Oct   5 5 REQ: use index where applicable instead of full table scan
2455 build fixed 2007 Jun anonymous   2007 Jun drh 2 3 aix linking fails due to missing library
2454 code fixed 2007 Jun drh   2007 Jun   1 1 Leading zeros cause large integers to be convert to floating point.
2453 code fixed 2007 Jun anonymous   2007 Jun   4 3 Can the amalgamation be made entirely static
2452 code closed 2007 Jun anonymous   2007 Jun drh 1 1 In Memory Query Performance
2451 code closed 2007 Jun anonymous   2007 Jun   5 5 vdbe.c comment typo
2450 code closed 2007 Jun anonymous   2007 Jun   1 1 Crashes and random wrong results with certain column names
2449 doc closed 2007 Jun anonymous   2007 Jun   1 1 BLOB and binary data
2448 new fixed 2007 Jun anonymous   2008 Mar   4 3 SQLITE needs to identify public exported symbols
2447 code closed 2007 Jun anonymous   2007 Jun   1 4 select where TABLENAME="TABLENAME" returns whole table.
2446 code fixed 2007 Jun anonymous   2007 Jun   1 2 FTS2 Limits Number of Indexed Tables to 3
2445 code closed 2007 Jun anonymous   2007 Jun   1 1 crash in sqlite3_prepare16
2444 code closed 2007 Jun anonymous   2007 Jun   2 3 SIGFPE from division of (1<<63)==9223372036854775808
2443 new closed 2007 Jun anonymous   2009 Oct   3 3 sqlite should return different exit codes for different errors
2442 doc closed 2007 Jun anonymous   2008 Jun   1 4 mailing list link doesn't always exist in website header
2441 code closed 2007 Jun anonymous   2007 Jun   2 3 Windows only error when deleting tempory files
2440 code closed 2007 Jun rse   2009 Jan   2 2 pkg-config(1) script "sqlite.pc" does not provide Autoconf's LIBS
2439 code closed 2007 Jun rse   2007 Jul   1 1 FTS1 and FTS2 use the unportable <malloc.h>
2438 new closed 2007 Jun rse   2009 Oct   3 3 More easily allow the building of SQLite with FTS1 and FTS2
2437 code fixed 2007 Jun rse   2007 Jun   3 3 Consistently use $(NAWK) in Makefile.in
2436 code fixed 2007 Jun rse   2007 Jun   1 1 SQLite has to link against -lm for isnan(3)
2435 code closed 2007 Jun anonymous   2007 Jun   1 1 Data corruption in version 3.4.0
2434 code fixed 2007 Jun anonymous   2007 Jun   5 5 comment typo in analyze.c
2433 code fixed 2007 Jun rse   2007 Jun   1 2 sqlite CLI's reading of ".sqliterc" broken in 3.4.0
2432 doc fixed 2007 Jun anonymous   2007 Jun   5 5 Documentation typo in sqlite3_sleep()
2431 code fixed 2007 Jun anonymous   2007 Jun   2 3 segfault with missing order by expression
2430 code fixed 2007 Jun anonymous   2007 Jun   3 3 date and strftime functions returns invalid year
2429 code closed 2007 Jun danielk1977   2007 Jun shess 1 3 problem with fts2 snippet() function
2428 build fixed 2007 Jun anonymous   2007 Jun   4 3 sqlite 3.4.0 ships with own 'limits.h' interfering with system one.
2427 doc closed 2007 Jun anonymous   2009 Oct   4 3 HTML Tidy warnings on new capi3ref.html
2426 code fixed 2007 Jun anonymous   2007 Jun   4 4 Access violation calling sqlite3_column_text after sqlite3_reset
2425 code fixed 2007 Jun anonymous   2007 Jun   3 3 ftruncate on platform where off_t is not 64 bit
2424 doc fixed 2007 Jun anonymous   2007 Jun   3 4 Documentation for Tcl-level access to incremental blob I/O is missing.
2423 code fixed 2007 Jun anonymous   2007 Jun   4 4 Check-in [4086] mkdll.sh no longer creates sqlite3.dll
2422 code fixed 2007 Jun anonymous   2007 Jun   1 1 pager.c, line 662: #define pager_datahash(X) 0
2421 code closed 2007 Jun anonymous   2007 Jun   1 1 unresolved external
2420 code closed 2007 Jun anonymous   2007 Jun   5 5 sqlite3_prepare() don't work in php pdo implementation
2419 build closed 2007 Jun anonymous   2009 Oct   1 2 'CP_UTF8' : undeclared identifier when trying to build the dll
2418 code fixed 2007 Jun drh   2007 Jun drh 1 1 Database corruption following malloc failure in auto-vacuum mode
2417 new closed 2007 Jun anonymous   2009 Oct drh 3 3 Idea for read write concurrency.
2416 doc fixed 2007 Jun anonymous   2007 Jun drh 5 5 Spelling error
2415 code fixed 2007 Jun anonymous   2007 Jun drh 1 1 [4061] propagates SQLITE_ABORT outside nested loops
2414 code closed 2007 Jun anonymous   2008 Jun   1 1 Unable t
2413 code active 2007 Jun anonymous   2008 Feb drh 1 1 1 bug and 2 suggestions in lemon
2412 build closed 2007 Jun anonymous   2007 Jun a.rottmann 1 1 Can't make Sqlite 3.3.17 on Solaris 10 X86
2411 new closed 2007 Jun anonymous   2009 Oct   5 3 fts2 RFE - Separate index and storage
2410 doc fixed 2007 Jun rdc   2007 Jun   5 3 typo in checkin 4053
2409 code closed 2007 Jun anonymous   2009 Oct drh 1 1 Database malformed with SQLite3.3.17 on WindowsXP
2408 code closed 2007 Jun anonymous   2009 Oct   2 1 BLOBs not output correctly in .mode insert (shell.c - isnumber)
2407 code fixed 2007 Jun anonymous   2007 Jun   1 4 Problem with ` (0x60) character in LIKE statement
2406 code fixed 2007 Jun anonymous   2007 Jun   1 3 C++ style comments unacceptable in C code.
2405 code closed 2007 Jun anonymous   2007 Jun   1 1 sqlite3_prepare() don't work in php pdo implementation
2404 code fixed 2007 Jun anonymous   2007 Jun   2 2 Values in INTEGER PRIMARY KEY always less than NULL
2403 code fixed 2007 Jun anonymous   2007 Jun   3 3 LEFT JOIN inconsistancy with NULL expression in ON clause
2402 code closed 2007 Jun anonymous   2007 Jun   3 3 Left Outer Join and Where clause
2401 warn closed 2007 Jun anonymous   2009 Oct   1 1 I can't send anything to the contrib page
2400 code closed 2007 Jun anonymous   2007 Jun   4 4 SELECT COUNT (*); returns 1 rather than 0.
2399 code fixed 2007 Jun danielk1977   2007 Jun   1 1 Compiling with msvc fails due to use of "isnan()"
2398 code closed 2007 Jun anonymous   2009 Oct   2 3 systemcalls should be restarted when they return EINTR
2397 build closed 2007 Jun anonymous   2009 Oct   2 4 make install failed on Cygwin
2396 code closed 2007 Jun anonymous   2009 Oct   1 3 -column output truncates characters from varchar field.
2395 todo closed 2007 Jun anonymous   2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
2394 todo closed 2007 Jun anonymous   2007 Jun mani 4 1 SQLite3 cmd prompt interface problem
2393 code closed 2007 May anonymous   2009 Oct   4 4 pragma cache_size not accurate when set to less than 10
2392 code closed 2007 May anonymous   2009 Oct   4 4 Reduce MemPage and PgHdr struct sizes. Better page memory utilization.
2391 todo closed 2007 May danielk1977   2007 May danielk1977 1 1 Inconsistent behaviour from explicit collate clauses.
2390 code closed 2007 May anonymous   2007 May drh 1 1 defect in select with max(id)
2389 code closed 2007 May anonymous   2007 Jun   1 1 database placed in the non ASCII named folder could not be opened
2388 code closed 2007 May anonymous   2009 Nov   1 3 ORDER BY fails on compound select
2387 code closed 2007 May anonymous   2007 May   1 1 query: problem with update anagrafica SET nome='nome' where id = '4';
2386 doc closed 2007 May anonymous   2007 May   5 4 Suggestion for wiki speed comparisson: order by, group by, subselect
2385 code closed 2007 May anonymous   2007 May   5 4 Comment for SQLITE_VERSION_NUMBER has a typo (missing zero).
2384 doc closed 2007 May anonymous   2007 May   1 5 an error in comments
2383 code closed 2007 May anonymous   2009 Oct   3 3 Inconsistent conversion of BLOB revisited
2382 doc fixed 2007 May anonymous   2007 Jul   3 3 VACUUM alters/repacks the ROWIDs if no explicit primary key is given
2381 doc closed 2007 May anonymous   2009 Oct   3 3 'VACUUM' aborts an active transaction.
2380 code closed 2007 May anonymous   2007 May   1 1 Order By Collum1, Collum2, Collum3 for Pocket PC incorrect in device
2379 code fixed 2007 May anonymous   2007 May   3 3 Concatenation with zeroblob
2378 code closed 2007 May anonymous   2009 Oct   2 2 Quoted fields come back corrupted, using GROUP BY
2377 build closed 2007 May pweilbacher   2008 Aug   4 3 Allow easy DLL build on OS/2
2376 code closed 2007 May anonymous   2009 Oct   3 3 -batch doesn't work soon enough
2375 doc closed 2007 May anonymous   2007 May   4 4 sqlite3_exec docs mentions sqlite3_reset
2374 code closed 2007 May anonymous   2009 Oct   5 5 "ALTER TABLE foo RENAME TO bar" will quote bar (ie. 'bar')
2373 new closed 2007 May anonymous   2009 Oct   4 4 "create table as explain <expr>" doesn't work
2372 code closed 2007 May anonymous   2009 Oct   4 4 sqlite3TestLockingStyle not used if SQLITE_FIXED_LOCKING_STYLE defined
2371 code new 2007 May anonymous   2009 Jul   2 2 sqlite3_errcode() and sqlite3_errmsg() return unexpected results
2370 code closed 2007 May anonymous   2007 May   3 2 Data is converted without me telling it to do so
2369 code closed 2007 May anonymous   2007 May   3 3 if you do a configure --prefix=/home/someotherdir tcl installs wrong
2368 code closed 2007 May anonymous   2007 May   1 1 vdbeblob.c missing from Makefile.in
2367 code closed 2007 May anonymous   2007 May   2 2 SQLITE_OMIT_INCRBLOB breaks default "make test"
2366 code closed 2007 May anonymous   2007 May   4 4 "make test" failures: pragma-1.15, pragma-1.16
2365 code closed 2007 May anonymous   2007 May   1 1 incrvacuum2, zeroblob regressions from check-ins on 2007-May-16
2364 code fixed 2007 May anonymous   2007 May   2 2 cast(as numeric) truncates small number of large integer
2363 code closed 2007 May anonymous   2009 Oct   3 3 Couldn't build 3.3.17 on Cygwin/Vista
2362 code closed 2007 May anonymous   2007 May   4 4 Can't add a column with ALTER TABLE
2361 new closed 2007 May anonymous   2007 May   3 3 Why is no LIMIT suported in UPDATE-queries?
2360 code fixed 2007 May anonymous   2007 May   2 2 Possible buffer overrun in some text functions
2359 code fixed 2007 May anonymous   2007 May   1 5 typo error
2358 code closed 2007 May anonymous   2007 May   3 4 Incorrect index chosen for query
2357 code closed 2007 May anonymous   2007 Jun anonymous 2 2 Crash in sqlite3PagerClose when SQLITE_ENABLE_MEMORY_MANAGEMENT is def
2356 code fixed 2007 May anonymous   2007 May   1 1 INDEX not used if column in WHERE clause refers to an alias
2355 code closed 2007 May anonymous   2007 May   3 4 Segfault with looooong sql string
2354 code fixed 2007 May anonymous   2007 May   2 1 Win32 locking problems
2353 code closed 2007 May anonymous   2007 May   1 1 Issue with selecting values of indexed column
2352 code closed 2007 May anonymous   2009 Oct   5 3 timeout just 500 msec to soon
2351 secure closed 2007 May anonymous   2009 Oct   2 2 UTF-16 convertor accepts malformed UTF-8 sequence
2350 code closed 2007 May anonymous   2009 Oct   1 1 Temp files not deleted on WinCE
2349 code fixed 2007 May anonymous   2007 May   3 3 Inconsistent conversion of BLOB to TEXT on UTF-16
2348 doc fixed 2007 May anonymous   2007 May   5 3 deteched -> detected
2347 code fixed 2007 May anonymous   2007 May   3 3 sqlite 3.3.17 crashes when doing "IN (select union select)"
2346 code closed 2007 May anonymous   2007 May   1 1 Inserting a certain integer
2345 code fixed 2007 May anonymous   2007 May   3 3 NaN is printed as '0.0'
2344 code fixed 2007 May anonymous   2007 Jun   2 3 Range of INTEGER not ANSI compliant
2343 code fixed 2007 May anonymous   2007 May drh 2 3 mallo.c typo in v 1.168/check in 3925 of Makefile.in
2342 doc closed 2007 May anonymous   2009 Oct   1 1 Document that prepared incremental vacuum needs multiple sqlite3_step
2341 code fixed 2007 May anonymous   2007 May   1 1 Potential buffer overflow in sqlite3_snprintf().
2340 code closed 2007 May anonymous   2009 Oct   3 3 "./configure && make testfixture" link problem
2339 code fixed 2007 May anonymous   2007 May   1 1 strange behavior for UNION
2338 todo closed 2007 May anonymous   2007 May   4 3 3.3.17 windows dll download gives 3.2.7
2337 code fixed 2007 May anonymous   2007 May   1 1 Unusual break of functionality (vtab-related?) after check-in 3918
2336 warn closed 2007 May anonymous   2009 Oct   4 4 Compiler warnings on strcpy(), sprintf(), et al.
2335 code fixed 2007 May anonymous   2007 May   1 2 real value corruption on different platforms
2334 code fixed 2007 May anonymous   2007 May   3 3 valgrind complains about memcpy in select.c (overlapping memory)
2333 new closed 2007 May anonymous   2009 Oct   5 4 support memory mapped files
2332 code closed 2007 May anonymous   2007 May danielk1977 1 1 incrblob: Data error writing large blobs
2331 code closed 2007 May anonymous   2007 May   1 1 Performance problem with complex where clause
2330 code closed 2007 May anonymous   2007 May drh 2 2 Usage of fieldname Session is impossible for where clause
2329 new closed 2007 Apr anonymous   2009 Oct   5 4 add a feature to .dump : partial dumps
2328 code closed 2007 Apr anonymous   2008 Jun   1 1 Makefile sqlite3.c target breakage for C++
2327 new closed 2007 Apr anonymous   2009 Oct anonymous 2 1 "DELETE" operation makes memory rise
2326 doc fixed 2007 Apr anonymous   2008 Jun mihailim 5 2 miss one word 'list'
2325 code closed 2007 Apr anonymous   2007 Apr   1 1 Link Fails w/ SQLITE_OMIT_ALTERTABLE
2324 code fixed 2007 Apr anonymous   2007 Apr   2 2 replace('abc', '', 'x') dumps core
2323 code fixed 2007 Apr anonymous   2007 Apr   3 3 invalid TRIM for multibytes
2322 code closed 2007 Apr anonymous   2009 Oct   1 1 Windows error: datetime('2000-10-29 06:00:00','localtime')
2321 code fixed 2007 Apr anonymous   2007 Apr   3 3 sqlite3_value_bytes moves pointer although there is no type conversion
2320 code closed 2007 Apr anonymous   2009 Oct drh 1 1 sqlite3_open(sFN_with_umlaut)
2319 code fixed 2007 Apr anonymous   2007 Apr   4 4 Duplicated test identifiers
2318 todo fixed 2007 Apr anonymous   2007 Apr   5 5 http://www.sqlite.org/contrib login broken
2317 code closed 2007 Apr anonymous   2007 Apr   4 4 Floats rendered to strings differently in WHERE and GROUP BY clauses.
2316 code closed 2007 Apr anonymous   2007 Apr   4 4 2 prepared statements on same database cause RC = 21
2315 code closed 2007 Apr anonymous   2007 Apr   1 1 Macro Redefinition Warning
2314 code fixed 2007 Apr anonymous   2007 Apr   1 1 SQLITE_OMIT_UTF16 Can't be Defined
2313 build closed 2007 Apr anonymous   2009 Oct   3 3 readline.h is not properly detected
2312 code closed 2007 Apr anonymous   2007 Apr mike 1 1 Using ODBC. Only saves first 5 characters of text fields. Can you help
2311 code fixed 2007 Apr anonymous   2007 Apr   4 4 redefinition of 'ARRAYSIZE'
2310 code closed 2007 Apr anonymous   2009 Oct anonymous 4 4 Problem installing on AIX 5.3, ML5 after successful compile with xlc
2309 code fixed 2007 Apr shess   2007 Apr shess 1 1 Assert failure in fts2 MATCH of certain OR cases.
2308 build closed 2007 Apr anonymous   2009 Oct   4 3 make sqlite3.c recreates sqlite3.c even though nothing changed
2307 build fixed 2007 Apr anonymous   2007 Apr   4 4 missing #ifndef SQLITE_OMIT_SHARED_CACHE breaks compilation
2306 code fixed 2007 Apr anonymous   2007 Apr   4 3 Maybe detective Boolean-expression in sqlite3Expr() ?
2305 doc closed 2007 Apr anonymous   2007 Apr   4 4 Function replace(X,Y,Z) doesn't exist ?
2304 new closed 2007 Apr anonymous   2009 Oct   1 1 resolve "databas is locked" problem under DEFERRED transaction
2303 code closed 2007 Apr anonymous   2009 Oct   1 1 Encrypted databases: No page cache due to problem in pagerSharedLock
2302 build closed 2007 Apr anonymous   2009 Oct anonymous 4 4 sqlite3 does not honor configure --disable-threads anymore
2301 build closed 2007 Apr anonymous   2009 Oct   1 1 Latest cvs 3.3.15 fails lock4-1.3 test
2300 code closed 2007 Apr anonymous   2007 Apr   1 1 compound query ORDER BY expression problem
2299 build closed 2007 Apr anonymous   2009 Oct   1 1 Cannot compile sqlite-3.3.15 on linux rhel
2298 code fixed 2007 Apr anonymous   2007 Apr anonymous 3 2 Sqlite 3.3.15 backs out performance changes introduced in 3.3.14
2297 code closed 2007 Apr anonymous   2009 Oct drh 3 3 uninitialized var (with patch)
2296 code fixed 2007 Apr anonymous   2007 Apr   3 3 IN clause of UNION of literal SELECT statements with ORDER BY
2295 code fixed 2007 Apr anonymous   2007 Apr   1 1 Subquery fails when "order by" is added
2294 code closed 2007 Apr anonymous   2009 Oct   2 1 segfault when destroying lock on WinCE with threads
2293 code closed 2007 Apr anonymous   2007 Apr   2 2 Extra file operations with sub journal when DB in MEM
2292 code closed 2007 Apr anonymous   2007 Apr   1 1 VACUUM => constraint failed
2291 code fixed 2007 Apr drh   2007 Apr   1 1 VACUUM fails when NULLs appear in a UNIQUE constraint
2290 code fixed 2007 Apr anonymous   2007 Apr   1 1 Using function result text as a function parameter
2289 code fixed 2007 Apr shess   2007 Apr shess 1 1 fts1 and fts2 crash when deleting or replacing rows with a null field.
2288 code closed 2007 Apr anonymous   2009 Oct   4 2 FTS does not support REPLACE
2287 code fixed 2007 Apr anonymous   2007 Apr   1 1 make test fails on latest 3.3.14 cvs code
2286 code fixed 2007 Apr drh   2007 Apr   1 1 Extra NULL value returned by a descending SELECT
2285 code fixed 2007 Apr drh   2007 Apr   1 1 Rolling back a CREATE TEMP TABLE wedges the database
2284 build fixed 2007 Apr anonymous   2007 Apr   1 1 make test fails with - undefined external sqlite3_xferopt_count
2283 warn closed 2007 Apr anonymous   2009 Oct   1 1 Compile warning by VCToolkit2003
2282 code active 2007 Apr anonymous   2007 Apr   3 4 Update on view with no matching trigger does not raise error
2281 build fixed 2007 Apr anonymous   2007 Apr   4 4 "CFLAGS=-DSQLITE_DEFAULT_FILE_FORMAT=4" causes alter2.test to fail
2280 new closed 2007 Mar anonymous   2009 Oct   4 3 Check constraint failure message should include field name
2279 code closed 2007 Mar anonymous   2007 Mar   3 4 sqlite3_exec NULL pointer crash
2278 code fixed 2007 Mar anonymous   2007 May   1 1 sqlite does not support mixed endian between pxa27x and i386 platforms
2277 code closed 2007 Mar anonymous   2007 Oct   1 1 Incorrect usage of CRITICAL_SECTION and TLS on Windows
2276 code fixed 2007 Mar anonymous   2007 Mar   4 3 strftime %f zero padding problem
2275 code closed 2007 Mar anonymous   2007 Mar   2 4 Can't get where clause to recognize equality with generated value
2274 todo closed 2007 Mar anonymous   2009 Oct drh 5 3 Sqlite segfaults consistently in FTS2
2273 code fixed 2007 Mar anonymous   2007 Mar   1 2 Under latest release 3.3.13 query results in crash (used to run fine)
2272 code fixed 2007 Mar anonymous   2007 Mar   5 5 btree.c doc typo
2271 doc closed 2007 Mar anonymous   2007 Mar   3 4 Can't use "limit" as column name
2270 build fixed 2007 Mar anonymous   2008 Mar   3 4 Build on Solaris 8 does not include other libs in .so build
2269 code closed 2007 Mar anonymous   2007 Mar anonymous 2 1 SQLite3_Column_decltype treat [char] (32) as 'char',but not 'char(32)'
2268 code fixed 2007 Mar shess   2007 Mar drh 1 4 SQLITE_OMIT_ATTACH doesn't disable sqlite_attach() function.
2267 doc fixed 2007 Mar anonymous   2007 Mar drh 2 1 copyright.html grammer needs fix
2266 new closed 2007 Mar anonymous   2009 Oct anonymous 3 3 Add support for Row_Number() Over
2265 doc closed 2007 Mar anonymous   2007 Mar   1 1 windows + xampp (php) + sqlite3 ... how?
2264 code fixed 2007 Mar anonymous   2007 Mar   3 1 User defined functions naming problem
2263 code closed 2007 Mar anonymous   2007 Mar   1 1 Apparent potential leak or concurrency problem when using codec
2262 code fixed 2007 Mar anonymous   2007 Mar drh 2 1 Dynamic allocation of tempory storage for pages
2261 build closed 2007 Mar anonymous   2007 Mar   1 1 Problem under Windows 95
2260 code closed 2007 Feb anonymous   2007 Mar   1 1 virtual table/vdbe does not call xFilter() making xColumn segv
2258 new closed 2007 Feb anonymous   2008 Apr   4 3 Include field name in check constraint failure message
2257 doc fixed 2007 Feb adixon   2007 Mar   4 4 Auto-vacuum documentation misleading
2256 new closed 2007 Feb anonymous   2009 Dec drh 5 1 Add POSITION() function (SQL-92 standard)
2255 code closed 2007 Feb scouten   2007 Mar   3 3 Temporary DB files are deleted twice in pager_unwritelock, once implic
2254 new closed 2007 Feb anonymous   2009 Oct   5 4 ATTACH support IF NOT ATTACHED statement
2253 code closed 2007 Feb anonymous   2007 Mar danielk1977 1 1 src/vdbe.c:3639: sqlite3VdbeExec: Assertion `pC!=0' failed.
2252 code fixed 2007 Feb drh   2007 Feb drh 1 1 New INSERT optimization bypasses CHECK constraint checks
2251 code fixed 2007 Feb anonymous   2007 Feb   1 1 sqlite3_column_type gives bad type for sum() .. group by
2250 code closed 2007 Feb anonymous   2007 Mar danielk1977 1 1 segmentation violation when using "select max(rowid)" in fts1
2249 code fixed 2007 Feb drh   2007 Feb drh 1 1 OR clause optimizer confused by column affinities
2248 code fixed 2007 Feb anonymous   2007 Feb   2 1 error evaluating IN statement
2247 doc closed 2007 Feb anonymous   2009 Oct   3 3 documentation of DEFUALT cluase in CREATE TABLE should be fixed
2246 doc closed 2007 Feb anonymous   2009 Oct   5 4 SQL docs for CREATE TABLE should include FOREIGN KEY syntax
2245 new closed 2007 Feb anonymous   2007 Feb a.rottmann 5 1 Union Problem on Empty Table
2244 code closed 2007 Feb anonymous   2007 Feb danielk1977 1 2 xUpdate in virtual table being called when no record exists
2243 code closed 2007 Feb anonymous   2007 Jul   2 3 sqlite3 authorizer cannot be exposed in garbage collected languages
2242 code fixed 2007 Feb anonymous   2007 Feb   2 3 sqlite3 authorizer is not reentrant
2241 code closed 2007 Feb scouten   2009 Oct   3 3 pragma integrity_check no longer affects command-line tool's exit code
2240 code closed 2007 Feb anonymous   2007 Feb   1 1 Parser command termination problem fails to catch illegal statements
2239 doc closed 2007 Feb anonymous   2007 Feb   1 1 Size of database in Speed Comparison?
2238 new closed 2007 Feb anonymous   2009 Oct   2 3 Streams as datbase
2237 code closed 2007 Feb anonymous   2009 Oct   4 4 Test suite regressions using Tcl 8.5
2236 code closed 2007 Feb anonymous   2007 Feb   1 1 inserts with selects do not work in 3.1.13
2235 new closed 2007 Feb anonymous   2009 Oct   4 3 Missing xml support in FTS2 for the snippet function
2234 code closed 2007 Feb anonymous   2007 Feb   1 1 3.3.13 is identical to 3.3.12 except VERSION file
2233 new closed 2007 Feb anonymous   2009 Oct   4 3 extend xBestIndex in vtables to carry the values for each contraint
2232 build closed 2007 Feb anonymous   2007 Feb   3 3 corrupt2.test fails with newer versions of Tcl
2231 new closed 2007 Feb anonymous   2009 Oct   4 4 shell should ignore leading whitespace for meta commands
2230 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Problem with virtual tables and grouping by aggregate function.
2229 code fixed 2007 Feb anonymous   2007 Feb   1 2 Complex triggers can blow up sqlite
2228 new closed 2007 Feb anonymous   2009 Oct   3 4 horizontal partitioning
2227 new defer 2007 Feb scouten   2007 Apr   5 4 Feature request: CHECKPOINT command
2226 code closed 2007 Feb scouten   2009 Oct   5 4 Report on unused indices (and tables?)
2225 code closed 2007 Feb scouten   2009 Oct   5 4 Request count of number of inserts and deletes from the free page list
2224 new closed 2007 Feb scouten   2009 Oct   4 4 Option to have one-bit "journal should exist" flag
2223 code closed 2007 Feb scouten   2009 Oct   3 3 pragma auto_vacuum doesn't survive .dump & reconstitute
2222 build closed 2007 Feb anonymous   2009 Oct   4 4 Type mismatch in fts2.c [5091] when compile as fastcall or stdcall
2221 new closed 2007 Feb anonymous   2009 Oct drh 3 4 Store blobs using inode-like lookup of pages rather than linked list
2220 new closed 2007 Feb anonymous   2009 Oct drh 2 4 fsck for database files
2219 code closed 2007 Feb shess   2009 Oct shess 2 2 Creating an fts table in an attached database works wrong.
2218 code closed 2007 Feb anonymous   2009 Oct   3 4 select columns from views with table prefix
2217 code fixed 2007 Feb anonymous   2007 Feb pamg 1 2 Incorrect result after first deleting operation (PRAGMA count_changes)
2216 code fixed 2007 Feb anonymous   2007 Feb   4 4 sqlite3ExprCompare() returns false for sqlite3ExprDup() result
2215 code closed 2007 Feb anonymous   2009 Oct   1 2 error messages in virtual table are not propagated
2214 code active 2007 Feb anonymous   2007 Feb   5 4 lemon generates bad error messages for %destructor
2213 code closed 2007 Feb danielk1977   2007 Feb danielk1977 1 1 Bug handling strings that are not nul-terminated.
2212 code closed 2007 Feb anonymous   2007 Feb   5 4 function request: sqlite3_bind_literal()
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
2210 doc fixed 2007 Feb anonymous   2007 Feb   5 4 Typos in PRAGMA legacy_file_format;
2209 doc closed 2007 Feb anonymous   2007 Feb   5 5 Wrong Comment in the change #3622
2208 todo fixed 2007 Jan anonymous   2007 Feb   1 1 SQLite CVSTrac attachment corruption?
2207 new closed 2007 Jan anonymous   2009 Oct   3 4 "CREATE TABLE foo AS SELECT * FROM bar" doesn't copy constraints
2206 new closed 2007 Jan anonymous   2009 Oct   5 4 Support for foreign key constraints in virtual tables
2205 build closed 2007 Jan anonymous   2009 Oct anonymous 1 1 Problem while using with tcl on ARM
2204 new closed 2007 Jan anonymous   2009 Oct   5 3 Stable, documented metadata interface
2203 code closed 2007 Jan anonymous   2009 Oct   2 3 table_info pragma "default" column format changed?
2202 new closed 2007 Jan anonymous   2009 Oct   5 4 function request: sqlite3_attach()
2201 code fixed 2007 Jan anonymous   2007 Feb   1 1 copy in tclsqlite doesn't work
2200 new closed 2007 Jan anonymous   2009 Oct   5 4 threadsafe status not reported in .pc file
2199 build closed 2007 Jan anonymous   2008 Mar   1 1 configure doesn't find libreadline if its in uncommon place
2198 new closed 2007 Jan anonymous   2009 Oct   5 4 API: opening only existing databases
2197 code closed 2007 Jan anonymous   2007 Jan   4 5 invalid(?) join syntax results in runnable sql code
2196 code closed 2007 Jan anonymous   2007 Jan   5 3 Bug in PRAGMA full_column_names with SELECT *
2195 code fixed 2007 Jan anonymous   2007 Feb   1 3 OS X: "database locked" when trying to use a database on DVD-ROM
2194 code fixed 2007 Jan anonymous   2007 Jan   4 4 possible multiple inclusion with vdbeInt.h
2193 code fixed 2007 Jan anonymous   2007 Jan   4 4 incorrect prototypes in tokenize.c
2192 code fixed 2007 Jan drh   2007 Jan   1 1 Assertion fault on a deeply nested view
2191 code fixed 2007 Jan anonymous   2007 Jan   4 3 Minor C++/C linkage compatibility issue in sqlite3.h
2190 code closed 2007 Jan anonymous   2007 Jan   3 4 bogus lines on "left join" with a "where right_table.column is NULL"
2189 code fixed 2007 Jan anonymous   2007 Jan   1 4 Incorrect results on LEFT JOINs with IS NULL condition in WHERE clause
2188 doc closed 2007 Jan anonymous   2009 Oct   5 4 Doc bug in src/vdbe.c, should s/P1/P2/ in NotFound
2187 todo closed 2007 Jan anonymous   2009 Oct   3 4 RAISE in trigger not being caught by CONFLICT clause in calling SQL
2186 code closed 2007 Jan anonymous   2007 Jan drh 1 1 database seems to be corrupted during a huge transaction
2185 new closed 2007 Jan anonymous   2009 Oct   5 3 API access to opened database pathname - helpful for virtual tables
2184 code fixed 2007 Jan anonymous   2007 Jan drh 1 1 OMIT_SHARED_CACHE: missing #define in loadext.c
2183 code closed 2007 Jan anonymous   2009 Oct drh 1 1 OMIT_SHARED_CACHE: AV and crash with FTS2 INSERT
2182 code closed 2007 Jan anonymous   2009 Oct   4 4 sqlite3BtreeGetMeta does not check the file format
2181 new closed 2007 Jan anonymous   2009 Oct   5 4 Generalize ON CONFLICT to failure trapping for all SQL statements
2180 new closed 2007 Jan anonymous   2009 Oct   5 4 feature request: DROP TABLE IF [EXISTS AND] EMPTY
2179 new closed 2007 Jan anonymous   2007 Jan   4 1 Odbc driver for sqlite takes more time in executing a query.
2178 code closed 2007 Jan anonymous   2007 Apr   1 1 On Windows Vista, a simple select returns different results.
2177 code fixed 2007 Jan anonymous   2007 Jan   1 3 The same query returns different answers between 3.3.7 and 3.3.9
2176 code fixed 2007 Jan anonymous   2007 Jan drh 1 2 integrity check can take very long time on large corrupted db
2175 code fixed 2007 Jan anonymous   2007 Mar   3 3 lemon calling destructors more than once
2174 code closed 2007 Jan anonymous   2007 Jan anonymous 2 3 DBD::SQLite does not return number of rows affected. Count(XXX) OK
2173 code fixed 2007 Jan anonymous   2007 Mar   4 4 Incorrect return value test for calls to fcntl()
2172 code fixed 2007 Jan anonymous   2007 Jan   5 1 crash when lemon (wireshark) is built with -DNDEBUG
2171 code review 2007 Jan anonymous   2007 Jan drh 3 3 Fix a major leakage of token minors in lemon generated parsers
2170 code closed 2007 Jan anonymous   2007 Mar anonymous 3 3 -init does not execute .exit/.quit
2169 code closed 2007 Jan anonymous   2007 Mar adamd 2 1 cast function
2168 doc fixed 2007 Jan anonymous   2007 Aug   4 1 Invalid documentation example - BLOB literal X'53514697465'
2167 new closed 2007 Jan anonymous   2009 Oct   1 3 add sqlite3_copy_bindings (parallel to sqlite3_transfer_bindings)
2166 code fixed 2007 Jan shess   2007 Jan shess 2 3 fts modules corrupt data during UPDATE.
2165 code closed 2007 Jan anonymous   2009 Oct drh 4 3 pager performance and checksum
2164 code fixed 2007 Jan anonymous   2007 Jan   4 5 Possibly a typo in lemon.c
2163 code fixed 2007 Jan anonymous   2007 Jan drh 4 3 AreFileApisANSI does not exist in Windows CE
2162 code closed 2007 Jan anonymous   2007 Jan   1 1 c code compile fails with "Undefined reference to sqlite3_open()"
2161 doc fixed 2007 Jan anonymous   2007 Jan   4 4 Typo in Documentation for callback to sqlite3_exec
2160 doc fixed 2007 Jan anonymous   2007 Jan   4 4 documentation for busy callback wrong
2159 build fixed 2007 Jan anonymous   2007 Jan pweilbacher 3 4 Interrupt OpenWatcom lang. ext. and sqlite3ext.h
2158 code closed 2007 Jan anonymous   2007 Jan   1 2 SCHEMA error still returned if SQL becomes invalid
2157 code closed 2007 Jan anonymous   2007 Jan   1 2 Profile called back too many times if a prepare_v2 statement is reused
2156 code fixed 2007 Jan anonymous   2007 Jan   1 2 Statements re-used from preparev2 crashing on vtable errors
2155 code closed 2007 Jan anonymous   2007 Jan   4 4 Should %s in strftime() be rounded up?
2154 code fixed 2007 Jan anonymous   2007 Jan   1 2 Getting core dump with reused prepare_v2 statements
2153 code fixed 2007 Jan drh   2007 Jan   1 1 Error in the strftime() function
2152 code closed 2007 Jan anonymous   2007 Jan   1 1 there is not tclsqlite.h in sqlite3.3.9
2151 code fixed 2007 Jan anonymous   2007 Jan   3 3 attach database fails
2150 code closed 2007 Jan anonymous   2007 Jan   3 3 use of %W in strftime produces unreliable results
2149 build fixed 2007 Jan pweilbacher   2007 Jan   4 3 BEXE missing for lemon in Makefile.in
2148 doc closed 2007 Jan anonymous   2009 Oct   5 5 3.3.9 changes.html addition
2147 new fixed 2007 Jan anonymous   2007 Jan   5 5 Add /contrib/download/ to robots.txt
2146 code closed 2007 Jan anonymous   2007 Jan   1 2 Correlated subqueries as columns of select return a syntax error
2145 build fixed 2007 Jan anonymous   2007 Jan   2 3 Error in "make install"
2144 doc fixed 2007 Jan anonymous   2007 Jan   5 3 Cmd shell: Add ".bail" to .help and to website
2143 doc fixed 2007 Jan anonymous   2007 Jan   3 3 sqlite3_column_name may return NULL
2142 build closed 2007 Jan anonymous   2007 Jan   2 2 make fails on cygwin
2141 code fixed 2007 Jan drh   2007 Jan   1 1 Assertion fault on valid query
2140 code closed 2007 Jan anonymous   2008 Jun   3 1 sqlite doesn't link to readline
2139 code fixed 2007 Jan anonymous   2007 Jan   1 1 recent pager_unlock change in CVS
2138 code closed 2007 Jan anonymous   2007 Jan   1 2 COLLATE and multiple order by problem
2137 code closed 2007 Jan anonymous   2007 Jan shess 4 4 I cannot find tcl.h header file. So, I am not able to compile the code
2136 new closed 2007 Jan anonymous   2009 Oct   1 3 sqlite locking does not handle afs; patch included
2135 code fixed 2007 Jan anonymous   2007 Mar anonymous 4 3 missing entry sqlite3_clear_bindings in sqlite3_apis
2134 code closed 2006 Dec anonymous   2006 Dec   2 1 is this a bug of sqlite3_prepare?
2133 build closed 2006 Dec anonymous   2009 Oct   4 4 meta ticket for outstanding autoconf issues
2132 code closed 2006 Dec anonymous   2009 Oct   3 4 table_info, index_list, index_info & friends should be virtual tables
2131 code closed 2006 Dec anonymous   2009 Oct   2 3 Add substring() function (Part of SQL 99)
2130 code closed 2006 Dec anonymous   2009 Oct   4 4 replace "long long int" type with "sqlite_int64" defined in sqlite3.h
2129 doc fixed 2006 Dec anonymous   2007 Jun   4 1 Typo in documentation for sqlite3_create_collation()
2128 code active 2006 Dec anonymous   2006 Dec   4 3 virtual table code doesn't verify type of rowid (calling xUpdate)
2127 code active 2006 Dec anonymous   2006 Dec   2 3 Virtual tables do not always free zErrmsg
2126 code closed 2006 Dec anonymous   2009 Dec   3 1 Update hook not invoked when deleteing all rows from table
2125 code closed 2006 Dec anonymous   2009 Oct   4 4 SQLite strings/blobs limited to 1GB/2GB due to 'int' in api
2124 code closed 2006 Dec anonymous   2006 Dec   1 1 default ./configure && make broken on Linux in latest CVS
2123 code fixed 2006 Dec anonymous   2006 Dec   5 5 error in new os layer loadable library code (windows ce version)
2122 code review 2006 Dec anonymous   2006 Dec   1 3 Potential wrong string could stay in with convertUtf8Filename
2121 code closed 2006 Dec anonymous   2006 Dec   3 4 Paths on Win9x following API specs (UTF-8) will fail
2120 new closed 2006 Dec anonymous   2009 Oct   5 4 Date Column support
2119 new closed 2006 Dec anonymous   2006 Dec   5 4 Unable to use place holders as part of the actual SQL query
2118 code fixed 2006 Dec anonymous   2006 Dec   3 2 xFilter is optional?
2117 code fixed 2006 Dec anonymous   2006 Dec   1 1 Bug in OP_VFilter (vdbe.c) when xFilter returns error
2116 code fixed 2006 Dec anonymous   2006 Dec   3 3 INDEX never selected for ORDER BY when INTEGER PRIMARY KEY present
2115 code closed 2006 Dec anonymous   2006 Dec   5 4 mix of allocator functions
2114 code fixed 2006 Dec anonymous   2006 Dec   5 4 strdup used
2113 code fixed 2006 Dec anonymous   2006 Dec   4 4 warning if SQLITE_OMIT_LOAD_EXTENSION
2112 code closed 2006 Dec anonymous   2009 Oct   5 4 code compatibility with C++
2111 code fixed 2006 Dec anonymous   2006 Dec   5 5 Typo
2110 build closed 2006 Dec anonymous   2009 Oct   4 3 Non-optional linking with readline makes sqlite3 binary GPL
2109 doc fixed 2006 Dec anonymous   2006 Dec   3 4 Documentation incoherence
2108 code closed 2006 Dec anonymous   2006 Dec   4 3 potential memory leak in prepare.c
2107 code fixed 2006 Dec anonymous   2006 Dec   4 4 lemon asserts if you're not careful with MULTITERMINALS
2106 doc closed 2006 Dec anonymous   2009 Oct   4 4 FtsOne wiki page neglects to mention Porter stemming
2105 new closed 2006 Dec anonymous   2009 Oct   5 5 sqlite3_exec does not return modified rows
2104 build closed 2006 Dec anonymous   2009 Oct   2 3 manual link on Mac OS X fails due to common symbol
2103 secure closed 2006 Dec anonymous   2006 Dec   2 2 No bound check for the insert string data!
2102 code closed 2006 Dec anonymous   2006 Dec   1 1 locking failing on w2k on vmware
2101 event closed 2006 Dec anonymous   2006 Dec   1 1 sqlite files filling up Temp folder 7,700 files so far can not delete
2100 code closed 2006 Dec anonymous   2009 Oct   1 1 Fixes for SQL lower() and upper()
2099 doc closed 2006 Dec anonymous   2009 Oct   3 3 virtual table xDestroy/xDisconnect and cleanups
2098 warn closed 2006 Dec anonymous   2009 Oct   1 1 php sqlite problem after commit transaction
2097 code closed 2006 Dec anonymous   2006 Dec   1 1 MAX function broken
2096 code closed 2006 Dec anonymous   2009 Oct   3 3 ATTACH DATABASE returns SQLITE_ERROR when database is locked
2095 doc closed 2006 Dec anonymous   2009 Sep   1 3 xFindFunction documentation incomplete
2094 code closed 2006 Dec anonymous   2006 Dec   1 3 Virtual table cursors are not freed (memory leak)
2093 code active 2006 Dec anonymous   2006 Dec   2 3 sqlite3_vtab_cursor doesn't have errMsg
2092 code closed 2006 Dec anonymous   2006 Dec   4 5 Bind null on an insert doesn't allow a WHERE bound with null
2091 code closed 2006 Nov anonymous   2006 Nov   3 3 thread unsafety + solution
2090 build closed 2006 Nov anonymous   2009 Oct   4 3 Test corrupt2.test fails: Solaris
2089 code active 2006 Nov anonymous   2006 Nov   3 3 Decouple sqlite_int64 from other 64bit datatypes
2088 code fixed 2006 Nov anonymous   2006 Nov   1 1 Ticket management problem : type
2087 new closed 2006 Nov anonymous   2009 Dec   3 3 Ability to add a check constraint via the alter table command
2086 code closed 2006 Nov anonymous   2009 Dec   5 4 Alias in update
2085 code closed 2006 Nov anonymous   2006 Nov   5 4 Round statement with different behavior between 3.2.8 and 3.3.7
2084 code closed 2006 Nov anonymous   2009 Oct   4 3 Add API function mapping column decl string to SQLite type
2083 code closed 2006 Nov anonymous   2009 Oct   4 4 Give more detailed extension loading error information with dlerror
2082 code closed 2006 Nov anonymous   2008 Mar   3 4 UNIX: configure script doesn't enable loading of extensions
2081 code closed 2006 Nov anonymous   2009 Dec doughenry 1 1 sqlite3_column_decltype throws exception, if selection is grouped
2080 code closed 2006 Nov anonymous   2009 Oct   4 4 Tranfering large BLOB data not efficient
2079 code closed 2006 Nov anonymous   2006 Nov   1 1 strftime doesn't work in where statement
2078 code fixed 2006 Nov anonymous   2006 Nov   2 1 Patch to make PRAGMA backward compatible with 3.3.7 and prior versions
2077 code closed 2006 Nov anonymous   2009 Dec   2 1 Problems with using ASCII symbols 0x80 - 0xFF in database path
2076 code closed 2006 Nov anonymous   2009 Oct a.rottmann 1 1 % exists as value in varchar
2075 code closed 2006 Nov anonymous   2009 Dec   3 3 Improve VACUUM speed and INDEX page locality
2074 code closed 2006 Nov anonymous   2009 Oct   4 4 feature request: .dump with page_size
2073 code closed 2006 Nov anonymous   2006 Nov   4 4 Ordering by a named expression which includes random doesn't work
2072 code fixed 2006 Nov anonymous   2006 Nov   1 1 .dump does not dump create index statements
2071 code fixed 2006 Nov anonymous   2006 Nov   1 1 VACUUM doesn't delete temp file on Windows since Check-in [3470]
2070 code closed 2006 Nov anonymous   2009 Dec   4 4 No error for ambiguous result alias in WHERE clause
2069 code fixed 2006 Nov anonymous   2007 Jan   4 3 compilation problem with SQLITE_OMIT_SHARED_CACHE
2068 code closed 2006 Nov anonymous   2009 Jan   4 4 pkgIndex.tcl contains incomplete version number
2067 code fixed 2006 Nov anonymous   2007 Dec   4 4 Bad syntax caused core dump
2066 code closed 2006 Nov anonymous   2009 Oct   2 2 Incorrect error message in the case of ENOLCK
2065 code fixed 2006 Nov anonymous   2006 Nov   4 4 Make .dump output a few percent smaller
2064 code closed 2006 Nov anonymous   2006 Nov   3 4 Table Name ignored if table Alias specified
2063 code closed 2006 Nov anonymous   2009 Oct   4 4 vtab_err.test fails if sqlite is compiled without -DSQLITE_MEMDEBUG
2062 doc closed 2006 Nov anonymous   2009 Oct mihailim 4 4 document 'pk' column of PRAGMA table_info()
2061 doc closed 2006 Nov anonymous   2009 Oct mihailim 5 5 cleanup for quickstart.html
2060 code closed 2006 Nov anonymous   2009 Oct   1 1 Table references enclosed in parenthesis become "invisible"
2059 code closed 2006 Nov anonymous   2009 Oct   1 1 Still missing .DEF file from Windows 3.3.8 source code distribution
2058 code closed 2006 Nov anonymous   2006 Nov   1 1 sum or total result in only 1 row returned
2057 code closed 2006 Nov anonymous   2009 Oct   3 1 full_column_names when 2 or more tables are joined is not working
2056 code fixed 2006 Nov anonymous   2006 Nov   2 2 unable to ".quit' or '.exit' SQLite cmdline tool
2055 code fixed 2006 Nov anonymous   2006 Nov   1 1 [patch] fix build errror (os_win.c)
2054 code closed 2006 Nov anonymous   2006 Nov   1 1 material to learn SQLite
2053 code closed 2006 Nov anonymous   2006 Nov   1 1 problem on solaris 10
2052 code closed 2006 Nov anonymous   2006 Nov   1 1 BLOBs still do not work on version 3.0
2051 code fixed 2006 Nov anonymous   2008 Jun mihailim 5 5 minor documentation bug
2050 code fixed 2006 Nov anonymous   2006 Nov   3 3 Assert typo in sqlite/src/btree.c ?
2049 code closed 2006 Oct anonymous   2006 Oct   1 1 sqlite_HrmKZy6ma4XBUGl is in my temp file and cannot be deleted.
2048 code closed 2006 Oct anonymous   2009 Oct drh 1 1 table_info on columns with no default value are returned as string
2047 code fixed 2006 Oct anonymous   2006 Oct   1 1 Mozilla Patch: Correct Unicode database names in Win95...
2046 code closed 2006 Oct anonymous   2009 Oct shess 1 1 FTS1 - Error closing database due to unfinished statements
2045 code fixed 2006 Oct anonymous   2006 Oct drh 5 4 Enhancement request: add "bail" command to sqlite3 shell
2044 code fixed 2006 Oct anonymous   2006 Oct   1 1 .dump does not dump create view or create index statements as before
2043 code closed 2006 Oct anonymous   2009 Oct   1 1 Spaces in view statement
2042 code closed 2006 Oct anonymous   2006 Oct   2 3 Subquery does not return the expected NULL
2041 code closed 2006 Oct anonymous   2009 Jan   4 4 sqlite3.pc on Solaris needs -lrt in "Libs:" entry
2040 code closed 2006 Oct anonymous   2006 Nov   1 1 Fatal reloc error: Using sqlite-3.3.6 with apache-2.2.0 on SPARC Solar
2039 code closed 2006 Oct anonymous   2006 Oct   1 1 How to delete SQLITE Temp files
2038 code fixed 2006 Oct anonymous   2006 Oct   3 3 CREATE TRIGGER IF NOT EXISTS fails
2037 code closed 2006 Oct anonymous   2009 Oct   1 1 Sqlite3 can't use datafile in Chinese path with Win2000 and WindowsXP.
2036 code fixed 2006 Oct anonymous   2006 Oct shess 1 1 fts2.c: AVs due to incorret memset() and sizeof() - plus fixes
2035 code closed 2006 Oct anonymous   2006 Oct jenglish 1 1 lazarus and sqlite3
2034 code closed 2006 Oct anonymous   2006 Oct jenglish 1 1 lazarus and sqlite3
2033 code closed 2006 Oct anonymous   2006 Oct   1 1 SQLite 3.3.8 breaks Rails 1.1.6 (SQLite 3.3.6 OK)
2032 code fixed 2006 Oct anonymous   2009 Oct   1 1 AV in btree.c running FTS2 compiled with SQLITE_OMIT_SHARED_CACHE
2031 code closed 2006 Oct anonymous   2006 Oct   1 1 .DEF file missing from 3.3.8 source code distribution
2030 code fixed 2006 Oct anonymous   2006 Oct   1 1 CSV output should convert " to "" within values
2029 code fixed 2006 Oct anonymous   2006 Oct   2 1 SECURITY: SQLite character encoding conversions are insecure
2028 code closed 2006 Oct anonymous   2009 Oct   4 2 FTS1: UNIQUE() expression and UPDATE command not working
2027 code closed 2006 Oct anonymous   2009 Oct   1 1 FTS: Phrase searches return Offsets for individual phrase words
2026 code closed 2006 Oct anonymous   2009 Oct   4 5 \n in .output is not allowed even with quote
2025 code closed 2006 Oct anonymous   2009 Oct drh 5 5 Add pragama command to return loaded extension list
2024 code closed 2006 Oct anonymous   2009 Oct drh 5 5 Add If not exist syntax to Create Virtual Table
2023 build fixed 2006 Oct anonymous   2006 Dec   3 3 sqlite (loadext.c) fails build in _UNICODE mode from v3.3.7
2022 code closed 2006 Oct anonymous   2009 Oct   1 1 .import command is not working
2021 code closed 2006 Oct anonymous   2006 Oct a.rottmann 2 1 Expression Always Returning String
2020 code closed 2006 Oct anonymous   2006 Oct   1 1 sqlite3_column_type always returns 1
2019 code closed 2006 Oct anonymous   2009 Oct   1 1 FTS1: Create table in transaction raises Out of Sequence error (21)
2018 code fixed 2006 Oct drh   2006 Oct drh 1 1 Name resolution problem in correlated compound subqueries.
2017 code closed 2006 Oct anonymous   2009 Oct   1 1 DROP TABLE fails on FTS1 utility tables with certain OMIT_s defined
2016 code fixed 2006 Oct anonymous   2006 Oct   1 1 Unremoved debug code in fts1_porter.c
2015 code closed 2006 Oct anonymous   2009 Oct anonymous 5 4 Enhancement Req: "EXPRn" PRAGMA for result set expression column names
2014 code closed 2006 Oct anonymous   2009 Oct anonymous 4 3 Enhancement Req: CREATE [TEMP | TEMPORARY] VIRTUAL TABLE
2013 code closed 2006 Oct anonymous   2009 Oct drh 4 3 Autoincrement increments on failing INSERT OR IGNORE
2012 code closed 2006 Oct anonymous   2009 Oct   4 3 trigger4.test aborts "make test" on Windows
2011 code closed 2006 Oct anonymous   2009 Oct   3 2 Escaping Porblem with .mode insert (double apostrophe)
2010 code closed 2006 Oct anonymous   2009 Oct   3 3 Timeout ignored in Shared-Cache locking model
2009 code fixed 2006 Oct anonymous   2006 Oct   4 3 sqlite3 shell won't issue prompts without isatty() true
2008 code fixed 2006 Oct anonymous   2006 Oct   3 3 Linux x86_64 sqlite3utfSelfTest fails assert -O2 gcc 4.1.1 (patch)
2007 code closed 2006 Oct anonymous   2006 Oct   1 1 Server has unexpecedly died/u've found a bug/ i cant connect to hub
2006 event closed 2006 Sep anonymous   2009 Oct   1 1 Strange data in a table.
2005 event closed 2006 Sep anonymous   2009 Oct   1 1 Multiple rows with the same primary key, and null values in "not null"
2004 warn closed 2006 Sep anonymous   2009 Oct   1 4 vtab.c:142: warning: pointer targets in initialization differ in signe
2003 warn closed 2006 Sep anonymous VDBE 2006 Sep   4 4 vdbeaux.c:1585: warning: unused variable 'sqlite3_search_count'
2002 code fixed 2006 Sep anonymous Parser 2006 Sep drh 2 2 Memory leak in select with duplicate colum names
2001 code fixed 2006 Sep anonymous Unknown 2006 Sep   2 2 Views on altered tables are defect
2000 doc closed 2006 Sep anonymous Unknown 2006 Sep   1 3 Teorical questions.
1999 code closed 2006 Sep anonymous Unknown 2006 Sep   3 3 Memmory leak and wrong passed argument to calback function
1998 build closed 2006 Sep anonymous   2009 Jun   2 3 prefix option to configure ignored in tclinstaller.tcl
1997 code closed 2006 Sep anonymous   2006 Sep   2 3 can't select rows if column name is contained in data
1996 new closed 2006 Sep anonymous Unknown 2009 Oct drh 2 3 Data type CHAR
1995 code closed 2006 Sep anonymous   2006 Oct   2 1 SHARED lock does not kick in (DEFERRED does not work ?)
1994 code closed 2006 Sep anonymous Parser 2009 Dec   1 3 Columns from nested joins aren't properly propagated
1993 event closed 2006 Sep anonymous   2006 Sep   3 1 bit operators problemm
1992 code closed 2006 Sep anonymous   2009 Oct shess 1 1 FTS1: Problems after dropping utility tables
1991 code fixed 2006 Sep anonymous Unknown 2006 Sep drh 3 3 strftime precision problem
1990 code closed 2006 Sep anonymous   2009 Sep   1 1 sqlite3_close doesn't release always the file handle
1989 build closed 2006 Sep anonymous Unknown 2006 Sep a.rottmann 2 2 100's daily in XP temp folder-Cannot delete w/out reboot-Stop create?
1988 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 linker error wih SQLITE_OMIT_VIRTUALTABLE
1987 code fixed 2006 Sep drh   2006 Sep drh 1 1 Malformed database results from changing encoding
1986 doc fixed 2006 Sep anonymous   2006 Sep   5 4 typo in documentation
1985 doc closed 2006 Sep anonymous   2006 Sep   1 4 how get table names
1984 code closed 2006 Sep anonymous   2006 Sep   1 1 sqlite3_exec problem
1983 code closed 2006 Sep anonymous   2009 Oct   2 2 I/O Error at a size of 4GB and auto_vacuum=1
1982 code fixed 2006 Sep anonymous   2006 Sep   1 1 FTS1: Database error after deleting and reinserting into FTS table
1981 code fixed 2006 Sep anonymous   2006 Sep   1 1 fts1.c uses strcasecmp instead of sqlite3StrICmp from utils.c
1980 code closed 2006 Sep drh   2009 Oct   1 1 Initializing FTS1 twice causes it to fail.
1979 doc fixed 2006 Sep anonymous   2006 Sep   4 4 Problem with full text search
1978 event fixed 2006 Sep anonymous   2006 Sep   1 1 Are e-mail addresses from check-in [3417] real ones ?
1977 code fixed 2006 Sep anonymous   2006 Sep   2 1 FTS1: Access violation creating FTS table with no column parameter
1976 code fixed 2006 Sep anonymous   2006 Sep   4 3 wrong call to set error in vacuum.c
1975 new closed 2006 Sep anonymous   2009 Oct   5 4 Request for sqlite3_table_column_metadata16
1974 code closed 2006 Sep anonymous Unknown 2009 Oct   1 1 column type not consistent in views
1973 code closed 2006 Sep anonymous Parser 2006 Nov   1 2 sqlite3_prepare (DLL 3.3.7) exception in two programs
1972 code closed 2006 Sep anonymous   2009 Oct   2 4 segfault on empty query
1971 code closed 2006 Sep anonymous Unknown 2006 Oct   4 4 66 tests fail out of 26937
1970 build closed 2006 Sep anonymous Unknown 2006 Sep   4 4 Cannot make Loadable Extensions to work for me.
1969 code closed 2006 Sep anonymous   2006 Sep   3 2 Degrade of INSERT performance between 3.3.4 and 3.3.6/3.3.7
1968 code closed 2006 Sep anonymous Unknown 2006 Sep   1 2 sqlite3_column_type() returns 1 instead of 0 since 3.3.7
1967 code closed 2006 Sep anonymous Unknown 2006 Sep   3 2 Degrade of INSERT performance between 3.3.4 and 3.3.6/3.3.7
1966 build closed 2006 Sep anonymous Unknown 2007 Feb   3 4 Add a --disable-readline option to configure
1965 code closed 2006 Sep anonymous   2006 Sep   3 3 sqlite returns wrong error code
1964 code fixed 2006 Sep anonymous Unknown 2006 Sep anonymous 3 3 datetime function broken
1963 new closed 2006 Sep anonymous   2006 Sep   2 2 sqlite3_aggregate_context() should be improved
1962 new closed 2006 Sep anonymous   2006 Sep   4 2 sqlite3_column_value() not exported
1961 build closed 2006 Sep anonymous   2009 Oct   3 3 3.3.7 : wrong readline.h path in Makefile
1960 code closed 2006 Sep anonymous   2009 Oct   4 2 Issues with .import in sqlite.exe
1959 new closed 2006 Sep anonymous   2009 Oct   4 3 Unblockable TEMP TABLES
1958 code closed 2006 Sep anonymous   2009 Oct   4 4 some printf tests fail with Tcl 8.5a5, ok with Tcl 8.4
1957 code fixed 2006 Sep anonymous   2006 Sep   4 4 Incorrect test messages: not compiled with -DSQLITE_DEBUG
1956 code closed 2006 Sep anonymous   2009 Jan   1 1 ALTER TABLE ADD COLUMN does not support asian language column names.
1955 code fixed 2006 Sep anonymous   2006 Sep   3 2 [3381] breaks MinGW ./configure && make sqlite3.dll
1954 code closed 2006 Sep anonymous Unknown 2008 Jun   1 1 Dual Core Processor Lockup
1953 code closed 2006 Sep anonymous TclLib 2009 Oct   4 3 Fix for false 64-bit comparisons "make test" failures on Cygwin
1952 code closed 2006 Sep anonymous Parser 2006 Sep   2 2 Memory leak in select with duplicate colum names
1951 build fixed 2006 Sep dougcurrie   2006 Sep   3 2 symbols missing from sqlite3.def
1950 new closed 2006 Aug anonymous   2006 Sep   4 4 AUTOINCREMENT too picky about type
1949 new closed 2006 Aug anonymous   2006 Aug   4 1 Missing 64Bit type
1948 code closed 2006 Aug anonymous Shell 2009 Oct   2 3 Double quotes are not escaped in csv mode
1947 code closed 2006 Aug anonymous Shell 2009 Oct   3 3 ".mode insert" works bad with BLOBs
1946 code closed 2006 Aug anonymous Unknown 2009 Oct   2 2 .read file fails on blob fields with end-of-file char
1945 code closed 2006 Aug anonymous   2006 Nov   1 1 symbol not found: sqlite_freemem
1944 new closed 2006 Aug anonymous Unknown 2006 Aug   4 4 no UTF16 counterpart to sqlite3_exec()
1943 event tested 2006 Aug anonymous Unknown 2006 Aug   3 2 sqlite3_malloc() not exported from sqlite3.dll
1942 new closed 2006 Aug anonymous   2009 Oct   4 4 select without left join with the *= operator
1941 code closed 2006 Aug anonymous   2008 Jun   1 1 Unrevolved _sqlite3ExprCodeAndCache with SQLITE_OMIT_TRIGGER
1940 code closed 2006 Aug anonymous   2006 Aug   3 3 insert default values
1939 event closed 2006 Aug anonymous Unknown 2009 Oct   2 1 SQLite hangs with WHERE condition in an SELECT with joined table
1938 build closed 2006 Aug anonymous   2009 Oct   4 5 Cygwin compilation of v3 fails
1937 new fixed 2006 Aug anonymous Unknown 2006 Aug drh 4 4 Tilda substitution not done on db file names.
1936 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 Altering schema seems to invalidate existing database connections
1935 event closed 2006 Aug anonymous Parser 2009 Oct   4 4 GROUP BY and ORDER BY constant expressions valid?
1934 doc closed 2006 Aug anonymous   2009 Oct   5 5 Documentation about default file format
1933 new closed 2006 Aug anonymous   2009 Oct   5 4 Add different date's separators
1932 new closed 2006 Aug anonymous   2006 Aug   3 4 I want a way to make db open fail if file does not exist
1931 new closed 2006 Aug anonymous   2006 Aug   3 3 timezone difference between PDO/Sqlite and PHP
1930 code closed 2006 Aug anonymous Unknown 2006 Aug adamd 1 1 the select command can't support NOT_FOUND.
1929 warn closed 2006 Aug anonymous   2007 Sep   4 3 3.3.7 sqlite3_index_info incompatible with C++
1928 new closed 2006 Aug anonymous Parser 2009 Oct   2 2 NULL rowid in views and subqueries
1927 doc fixed 2006 Aug anonymous Shell 2006 Aug   4 4 [doc] sqlite3.exe allows "/" as cmd terminator, not "\"
1926 new fixed 2006 Aug anonymous Shell 2006 Aug   3 4 sqlite3.exe cannot find home dir on Windows
1925 code fixed 2006 Aug anonymous Unknown 2006 Aug   3 4 soundex() function not compatible with Knuth (and PHP/Java/TCL impl.)
1924 new closed 2006 Aug anonymous Parser 2009 Dec   2 3 optimize queries on unions, constant folding
1923 doc fixed 2006 Aug anonymous   2006 Aug   4 4 INSERT syntax documentation bug
1922 code closed 2006 Aug anonymous Parser 2006 Aug   1 1 field name with space can not be specified as primary key
1921 code closed 2006 Aug anonymous   2006 Aug   4 4 misc1-10.1 failure on cygwin aborts make test
1920 code fixed 2006 Aug anonymous VDBE 2006 Aug   4 4 vdbe.c: assert( i>=0 && i<=p->nCursor );
1919 code fixed 2006 Aug anonymous Unknown 2006 Aug   3 3 PRAGMA table_info meaningless for cols with DEFAULT CURRENT_TIMESTAMP
1918 event fixed 2006 Aug anonymous VDBE 2006 Aug   4 4 "make test" results in many new false regressions with default build
1917 code fixed 2006 Aug anonymous VDBE 2006 Aug   3 3 assertion "rc==SQLITE_OK" failed: file "./src/vdbeaux.c", line 1148
1916 code fixed 2006 Aug anonymous Unknown 2006 Aug drh 4 2 #include <sqlite3.h> in sqlite3ext.h should be #include "sqlite3.h"
1915 code fixed 2006 Aug anonymous   2006 Aug   4 4 vtab2.test: ./testfixture: can't read "tcl_pkgPath": no such variable
1914 code fixed 2006 Aug anonymous   2006 Aug   4 4 btree2.test - invalid command name "btree_cursor_info"
1913 build fixed 2006 Aug anonymous Unknown 2006 Aug   4 3 Extension exports should be added to sqlite3.def in Windows source
1912 code fixed 2006 Aug anonymous Parser 2006 Aug   4 4 letters following numeric digits parsing error
1911 code fixed 2006 Aug anonymous   2006 Aug   2 3 crash if too many order by expressions
1910 event closed 2006 Aug anonymous   2006 Aug   3 4 Lost clusters generated by "create TEMP Table" (DJGPP/GCC2.953)
1909 code closed 2006 Aug anonymous VDBE 2006 Aug anonymous 3 3 cannot use sqlite3_prepare() when DB is in "BEGIN EXCLUSIVE" mode
1908 code closed 2006 Aug anonymous Unknown 2006 Aug anonymous 2 4 ORDER BY clause does not allow quoting
1907 new closed 2006 Aug anonymous   2009 Oct   4 4 date and time types
1906 new fixed 2006 Aug anonymous Unknown 2008 Mar   1 2 date.c line 417 uses non-thread safe localtime() call
1905 new closed 2006 Aug anonymous VDBE 2009 Oct   5 4 Get bound param as sqlite3_value?
1904 code closed 2006 Aug anonymous Unknown 2006 Aug   2 3 error using drop table "if exists" in exec
1903 code closed 2006 Aug anonymous   2006 Aug   2 2 LIKE string search sometimes fails
1902 new closed 2006 Jul anonymous Parser 2009 Oct   5 3 allow alternate INSERT syntax using SET foo=bar
1901 code closed 2006 Jul anonymous Unknown 2009 Oct adamd 2 2 problem in select request with a alias table
1900 code closed 2006 Jul anonymous Unknown 2009 Aug a.rottmann 1 1 CURRENT_TIMESTAMP keyword not inserting UTC date in column
1899 new fixed 2006 Jul anonymous   2006 Sep drh 5 4 Is it possible add IF NOT EXISTS Create View and Create Trigger
1898 doc closed 2006 Jul anonymous   2009 Oct   5 4 sqlite3_progress_handler still marked experimental in documentation
1897 new fixed 2006 Jul anonymous Unknown 2009 Oct   1 3 Should be able to call sqlite3_interrupt from a different thread
1896 new closed 2006 Jul drh   2009 Oct   1 1 All extensions to be statically linked
1895 doc closed 2006 Jul anonymous   2008 Jun anonymous 4 3 IS operator not documented
1894 event closed 2006 Jul anonymous Unknown 2006 Jul   4 3 "library routine called out of sequence" when using progress (TCL)
1893 code closed 2006 Jul anonymous   2009 Oct   3 3 sqlite doesn't use indexes containing primary key in prim. key selects
1892 code fixed 2006 Jul anonymous Parser 2006 Jul   4 5 Degenerate code action causes parser crash.
1891 code closed 2006 Jul anonymous Shell 2006 Jul pweilbacher 4 4 OS/2 may not have access to C:\ drive
1890 doc closed 2006 Jul anonymous Unknown 2009 Oct mihailim 3 4 double quotes ("") in a query are ambiguous
1889 new fixed 2006 Jul drh   2006 Jul   1 1 Make sqlite3_interrupt() accessible from the TCL interface
1888 code closed 2006 Jul anonymous Unknown 2006 Jul anonymous 1 1 connetion to db extremely slow
1887 code fixed 2006 Jul anonymous TclLib 2006 Jul   1 1 Bad result on empty [db onecolumn]
1886 code fixed 2006 Jul drh   2006 Jul   1 1 Memory leak when malloc fails
1885 code closed 2006 Jul anonymous Shell 2009 Oct   2 3 sqlite3 .mode insert and .dump do not list column names for selects
1884 code closed 2006 Jul anonymous   2009 Oct   3 2 pragma table_info caches results from previous query
1883 code closed 2006 Jul anonymous   2006 Jul   1 2 "no such table error" using sqlite-odbc driver
1882 code closed 2006 Jul anonymous   2009 Oct   1 1 Wrong algorithm of SQLITE_VERSION_NUMBER calculation
1881 code closed 2006 Jul anonymous Parser 2006 Jul anonymous 2 1 error in inserting strings with single quotes
1880 code closed 2006 Jul anonymous   2006 Jul   3 3 Errors testing sqlite 3.3.6
1879 doc fixed 2006 Jul anonymous   2006 Jul   4 4 Perl is spelt Pearl on the http://www.sqlite.org page
1878 code closed 2006 Jun anonymous CodeGen 2009 Dec   2 3 No index used when specifying alias name in ORDER BY clause
1877 code fixed 2006 Jun anonymous VDBE 2006 Jun   2 2 problems with compiling with -DSQLITE_OMIT_VIRTUALTABLE
1876 event closed 2006 Jun anonymous Unknown 2006 Jun   4 4 Creating table disrupts previously prepared statement
1875 code fixed 2006 Jun anonymous   2006 Jun   1 3 EXPLAIN crashes in strlen
1874 new closed 2006 Jun anonymous CodeGen 2009 Oct   2 3 IN is much slower than making separate queries
1873 code fixed 2006 Jun drh   2006 Jun   1 1 DETACH while query is running results in crash
1872 code closed 2006 Jun anonymous   2009 Oct   4 3 sqlite3_open doesn't support RFC1738 format for filename
1871 event closed 2006 Jun anonymous   2009 Oct   2 3 VACUUM should not change 3.x file format
1870 code closed 2006 Jun anonymous   2006 Jun   2 2 dbWriteTable in RSQLite can't write strings that contain commas.
1869 doc closed 2006 Jun anonymous Unknown 2008 Jun anonymous 4 4 Website typo
1868 code closed 2006 Jun anonymous Shell 2006 Jun   4 4 where a = b = c
1867 code closed 2006 Jun anonymous BTree 2009 Oct   1 3 Access Violation after set a new page_size
1866 event closed 2006 Jun anonymous   2006 Jun   1 1 SQLite.NET ExecuteNonQuery() limit of text size
1865 code closed 2006 Jun anonymous   2006 Jun   1 2 Encoding problem using order by
1864 new closed 2006 Jun anonymous   2009 Oct drh 3 3 List availabe SQL functions
1863 secure fixed 2006 Jun anonymous Unknown 2006 Jun drh 2 3 authorizing load_extension()
1862 code closed 2006 Jun anonymous TclLib 2009 Oct tclguy 1 1 SQLite cannot load/import data from file
1861 code closed 2006 Jun anonymous Pager 2009 Oct   1 1 Problem in using Triggers and multithreading
1860 code closed 2006 Jun anonymous Pager 2009 Oct danielk1977 1 1 Problem in using SQLite3 with trigger and multithreading
1859 code closed 2006 Jun anonymous Unknown 2006 Jun danielk1977 4 3 Wrong calculation og log2() in check-in [3274]
1858 doc closed 2006 Jun anonymous   2008 Jun   5 5 Typo: Pearl -> Perl
1857 code tested 2006 Jun anonymous   2009 Oct   3 4 Can't use ISO 8601 dates with time zone designator 'Z'
1856 code closed 2006 Jun anonymous   2009 Oct   2 3 SQLITE_OMIT_UTF16 breaks 'make test'
1855 doc closed 2006 Jun anonymous   2006 Jun   5 5 how to configure SQLite with jboss
1854 event closed 2006 Jun anonymous   2006 Jun   3 3 i am unable to view the tables by using .tables command
1853 code closed 2006 Jun anonymous   2009 Oct   3 4 sqlite3_analyzer-3.3.4 integer overflows on large database
1852 code closed 2006 Jun anonymous   2006 Jun   4 5 AUTOINC NOT NULL problem
1851 code closed 2006 Jun anonymous Unknown 2009 Oct   2 1 USE "ORDER BY" error on uClinux
1850 code closed 2006 Jun anonymous Unknown 2009 Oct   2 1 NUMERIC data type ERROE when read on uClinux
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)
1848 code fixed 2006 Jun anonymous Parser 2006 Jun drh 1 1 C++ ism on generated parse.c from latest CVS head
1847 new fixed 2006 Jun anonymous   2006 Jun   4 4 Unhelpful error text
1846 code closed 2006 Jun anonymous   2006 Jun   1 1 Memory leak after returning error message
1845 code fixed 2006 Jun anonymous Unknown 2006 Jun   3 3 soundex(null) causes access violation
1844 warn closed 2006 Jun anonymous   2006 Jun   2 3 compiler warnings with gcc 3.3.4 on Tru64 V5.1B
1843 code closed 2006 Jun anonymous   2006 Jun   3 2 compile with gcc 3.3.4 on Tru64 V5.1B
1842 code closed 2006 Jun anonymous Unknown 2006 Jun anonymous 1 1 The field data saved in the table is corrupt
1841 warn closed 2006 Jun anonymous   2006 Jun mani 3 2 a scan in safe mode says my sqlite file is wrong size
1840 code closed 2006 Jun anonymous Unknown 2006 Jun   4 4 sqlite3_get_table returns null pointer for aggregate queries
1839 build fixed 2006 Jun anonymous   2006 Jun   1 4 attempting to compile loadext.c fails
1838 code closed 2006 Jun anonymous   2009 Oct   5 5 test types3-1.3 fails on 64-bit Linux
1837 new closed 2006 Jun anonymous Pager 2009 Oct   4 4 Deadlock detection would be best reported using explicit error code.
1836 new fixed 2006 Jun pweilbacher Shell 2006 Jun   4 3 Further OS/2 updates
1835 code closed 2006 Jun anonymous Unknown 2006 Jun   1 2 Memory leak on sqlite3_step with Select with no result row
1834 code closed 2006 Jun anonymous   2006 Jun   5 5 Can't create database with the é name (french E)
1833 doc closed 2006 Jun anonymous Unknown 2009 Oct drh 4 3 PRAGMA legacy_file_format not documented
1832 code closed 2006 Jun anonymous   2006 Jun   1 1 Segmentation fault when placing a 0 limit on a joined subquery.
1831 code fixed 2006 Jun anonymous Unknown 2006 Jun anonymous 2 1 Crash when using a certain type of index
1830 code fixed 2006 Jun anonymous Unknown 2006 Jun   2 1 Problem with INNER JOIN following LEFT JOIN to table with UNIQUE INDEX
1829 code closed 2006 Jun anonymous   2006 Jun   1 1 Odbc driver parameter bind offset pointer does not work
1828 code closed 2006 Jun anonymous   2006 Jun   1 3 if not exists doesn't work with a qt program I'm designing.
1827 new fixed 2006 May anonymous TclLib 2006 May   4 4 Tcl-library: SQLITE_MISUSE from progress callback
1826 code closed 2006 May anonymous Parser 2006 May anonymous 4 4 Select unused table in from clause produces no results
1825 code fixed 2006 May anonymous   2006 May   1 1 Crash on ATTACH DATABASE
1824 code fixed 2006 May drh   2006 May drh 1 1 UTF-16 encoding flag not honored when using shared cache
1823 code closed 2006 May anonymous   2006 May   1 1 pysqlite2.dbapi2.OperationalError: unable to open database file
1822 code closed 2006 May anonymous   2009 Dec   3 3 Table Alias together with Subquery seems not to work proper
1821 code fixed 2006 May anonymous   2006 May   2 3 Optimizer causes IN operator to fail when comparing strings & numbers
1820 warn closed 2006 May anonymous TclLib 2009 Jan anonymous 5 1 make: *** [tclsqlite.lo] Error 1
1819 code closed 2006 May anonymous Unknown 2006 May persicom 4 3 faulty html code for concatenated field with "<" character
1818 code closed 2006 May anonymous Unknown 2006 May drh 3 3 sqlite3_mprintf() misbehaving on %*. formats
1817 new fixed 2006 May anonymous   2008 Aug   1 2 Patch to enable SQLite again on OS/2
1816 code closed 2006 May anonymous VDBE 2009 Oct   1 2 Database corruption with pragma auto_vacuum
1815 code closed 2006 May anonymous Parser 2009 Oct   3 3 Support of W3C-DTF(ISO8601 subset) is incomplete
1814 new closed 2006 May anonymous   2009 Oct   3 4 Autoconf support for MacOSX univeral binaries
1813 new closed 2006 May anonymous   2007 Nov   2 3 select distinct doesn't take advantage of existing indexes
1812 new closed 2006 May anonymous   2009 Oct   4 1 alter table add column default current_timestamp
1811 doc closed 2006 May anonymous   2009 Oct   5 3 how many open cursors are allowed for one application?
1810 new closed 2006 May anonymous   2009 Oct   3 3 localtime() not threadsafe on UNIX
1809 code active 2006 May anonymous CodeGen 2009 Jan   1 3 Huge slowdown/increased memory use when using GROUP BY on big dataset
1808 code closed 2006 May anonymous   2006 May   1 1 Wrong index is chosen
1807 code fixed 2006 May drh   2006 May drh 1 1 Assertion fault on a particular query.
1806 code fixed 2006 May anonymous TclLib 2006 May   3 4 Missing out-of-memory check at db/sqlite3/src/tclsqlite.c:1442
1805 code fixed 2006 May anonymous Shell 2006 May   3 4 missing out-of-memory check at src/shell.c:1485
1804 code closed 2006 May anonymous Unknown 2009 Oct   4 3 Inconsistent value type returned by SUM when using a GROUP BY
1803 code fixed 2006 May anonymous Unknown 2006 Jun   3 3 sqlite3WinOpenReadWrite() passes wrong share parms to CreateFile()
1802 build closed 2006 May anonymous Unknown 2009 Jan   4 4 sqlite.pc needs -lrt on Solaris for fdatasync()
1801 new closed 2006 May anonymous Pager 2009 Oct owensmk 5 4 Include Support for User-defined Lock Synchronization
1800 new closed 2006 May anonymous   2006 May linus 1 2 possible to have the lastest version of sqlite with PHP 5?????
1799 code closed 2006 May anonymous Pager 2009 Oct   2 3 temp_store=MEMORY slower than FILE for large intermediate result sets
1798 doc fixed 2006 May anonymous   2008 Jun mihailim 5 4 preprocessed is misspelled on download page
1797 code active 2006 May anonymous TclLib 2006 May drh 1 1 COPY command doesn't work in tclsqlite 3.3.5
1796 code closed 2006 May anonymous   2006 May   1 1 .import command not working in 3.3.5
1795 code closed 2006 May anonymous Unknown 2006 Aug   1 1 Incorrect result if a nested view contains a union
1794 code fixed 2006 May anonymous Parser 2006 May   3 2 Sqlite parser produces incorrect error message for missing commas
1793 code closed 2006 May anonymous   2006 May   2 3 sqlite3.dll crashes when doing an inner join with limit 0
1792 doc fixed 2006 May anonymous   2006 May   1 1 "commercial" is misspelled on the SQLite license page
1791 code closed 2006 May anonymous Unknown 2009 Oct   1 1 Native threads support for BeOS
1790 code closed 2006 May anonymous Pager 2009 Oct   3 3 :memory: performance difference between v2 and v3
1789 doc closed 2006 May anonymous Unknown 2008 Jun drh 4 4 sqlite3_result_error() not adequately documented
1788 new closed 2006 Apr anonymous   2009 Oct   5 5 memory allocator able to return with several allocated bloks at once
1787 code closed 2006 Apr anonymous   2006 Apr   1 1 Certain integer values are written/read incorrectly to/from database
1786 warn closed 2006 Apr anonymous   2009 Oct   4 4 Yet another list of compiler warnings.
1785 new closed 2006 Apr anonymous Shell 2009 Oct   4 3 rl_readline_name not set
1784 code fixed 2006 Apr anonymous   2006 Apr   3 4 LIMIT 0 in sub-query with ORDER BY in outer query causes seg fault
1783 code closed 2006 Apr anonymous Unknown 2009 Oct   3 2 insert times increase with growing table size (when indexed)
1782 code closed 2006 Apr anonymous Unknown 2009 Oct   1 1 journal file exclusion
1781 new closed 2006 Apr anonymous   2009 Oct   3 5 Interleaved sqlite_step behaves inconsistently
1780 code closed 2006 Apr anonymous BTree 2006 Apr   1 1 What's mean for "b0G1X" or "b0G0" in the head of payload in cell?
1779 new closed 2006 Apr anonymous   2007 Nov   5 4 enhancement request (+ pointer) -- group_concat() aggregate function
1778 new closed 2006 Apr anonymous Parser 2009 Oct   1 3 stdev does not work, workaround not possible due to missing sqrt
1777 code closed 2006 Apr anonymous   2009 Oct   2 4 Cygwin should be OS_UNIX target, not OS_WIN
1776 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 1 2 Max(DateTime column) returns a String, not a DateTime
1775 code closed 2006 Apr anonymous Unknown 2009 Oct   1 1 strftime() not working in Windows Mobile 2005
1774 code closed 2006 Apr ghaering   2006 Apr   1 1 sqlite3_column_decltype() stopped working in SQLite 3.3
1773 code fixed 2006 Apr anonymous   2006 Apr   2 3 heap corruption reading a corrupted database file
1772 new closed 2006 Apr anonymous TclLib 2009 Oct   5 5 db eval {QUERY} { do something } ELSE { there was no match }
1771 code fixed 2006 Apr anonymous Shell 2006 Jun   5 4 sqlite3 -version should return 0
1770 new closed 2006 Apr anonymous   2009 Oct   5 4 Request for expanded DELETE USING keyword like PostgreSQL
1769 new closed 2006 Apr anonymous Unknown 2009 Oct drh 5 5 Is there any djgpp port for 3-3-5
1768 code fixed 2006 Apr anonymous   2006 Apr drh 1 1 ORDER BY behaving differently in SQLite2 and 3
1767 warn closed 2006 Apr anonymous Unknown 2006 Apr   5 4 Unused variable in function sqlite3VdbeChangeEncoding
1766 new closed 2006 Apr anonymous Unknown 2006 Apr   3 2 Order by NO Case Sensitive
1765 code closed 2006 Apr anonymous   2006 Apr   1 2 SQLite3_BindText fails with a floating point error (explicited)
1764 code closed 2006 Apr anonymous Unknown 2006 Apr   1 2 database file format not inter-operable between 32-bit/ 64-bit systems
1763 code fixed 2006 Apr anonymous   2006 Apr   3 4 declaration after executable statement
1762 build closed 2006 Apr anonymous Unknown 2009 Oct   3 4 sqlite3_clear_bindings not exported in windows dll
1761 code closed 2006 Apr anonymous Unknown 2006 Apr   1 3 SQLite3_BindText fails with a floating point error
1760 code closed 2006 Apr anonymous   2006 Apr   4 4 sqlite3_open(), then sqlite3_close()
1759 code closed 2006 Apr anonymous   2006 Apr   3 4 "int primary key" not the same as "integer primary key"
1758 code closed 2006 Apr anonymous Unknown 2006 Apr   3 1 problem with: select ... UNION ... select .. ORDER BY LOWER(column)
1757 code closed 2006 Apr anonymous   2006 Apr   2 1 sqlite not using index
1756 code fixed 2006 Apr anonymous   2006 Apr   1 1 Is use of function atof in file func.c really intended?
1755 code fixed 2006 Apr anonymous Unknown 2006 Apr drh 3 3 datatype incorrect when using group-by
1754 code closed 2006 Apr anonymous Pager 2009 Oct anonymous 2 2 Version 3.3.5 error if SQLITE_OMIT_MEMORYDB is defined
1753 code closed 2006 Apr anonymous Unknown 2006 Apr anonymous 2 1 Order by not working on a column with random() function
1752 code closed 2006 Apr anonymous Unknown 2006 Apr   3 4 New compile warnings with default ./configure && make on MinGW
1751 code closed 2006 Apr anonymous Unknown 2006 Sep mike 1 1 sqlite doesn't work on a cifs-mounted drive
1750 doc fixed 2006 Apr anonymous   2006 Apr   5 4 typo on API reference web page
1749 doc fixed 2006 Apr anonymous   2006 Apr   5 4 typo on FAQ web page
1748 code closed 2006 Apr anonymous VDBE 2006 Apr   3 3 Memory leak in insert.c: sqlite3TableAffinityStr
1747 new closed 2006 Apr anonymous Unknown 2009 Oct   4 4 Non descriptive error message
1746 code fixed 2006 Mar anonymous Parser 2006 Apr   2 1 large number of trigger actions in trigger creation give syntax error
1745 doc fixed 2006 Mar anonymous Parser 2006 Apr drh 3 3 Missing "REVERSE" colation sequence
1744 doc fixed 2006 Mar anonymous Parser 2006 Apr drh 1 1 Missing documentation for SQLITE_ALTER_TABLE, SQLITE_REINDEX...
1743 code closed 2006 Mar anonymous Parser 2009 Oct   3 3 A very very deep IN statement failure
1742 code closed 2006 Mar anonymous Unknown 2009 Dec drh 2 3 ORDER BY on more than one column causes a big slowdown
1741 warn closed 2006 Mar anonymous VDBE 2009 Oct   5 4 unused variable with SQLITE_OMIT_UTF16 defined
1739 code closed 2006 Mar anonymous Unknown 2006 Mar   4 1 sqlite3_bind_int on UPDATE * SET COLUMN1='Test' WHERE ID=?
1738 code closed 2006 Mar anonymous Unknown 2006 Mar a.rottmann 1 1 The function "sqlite3_get_table" doen't do well with blob data.
1737 code fixed 2006 Mar anonymous Unknown 2006 Mar   1 1 Duplicate name object created
1736 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 #define SQLITE_OMIT_ALTERTABLE causes unresolved externals
1735 code closed 2006 Mar anonymous Unknown 2009 Oct   1 3 Encoding problem
1734 code closed 2006 Mar anonymous Parser 2006 Mar drh 5 5 when not null is before integer primary key, syntax error occurs
1733 code closed 2006 Mar anonymous VDBE 2009 Oct drh 4 3 Unaligned Access on ia64: aggregate_context ptr isn't 16-bytes aligned
1732 doc closed 2006 Mar anonymous   2008 Jun   5 5 Info on Home page
1731 doc fixed 2006 Mar anonymous   2008 Jun   5 5 Typo in select4.test
1730 new closed 2006 Mar anonymous   2006 Mar   2 5 referential integrity
1729 code closed 2006 Mar anonymous   2006 Mar   1 1 SQLite loses precision on 64-bit integers
1728 code fixed 2006 Mar drh VDBE 2006 Mar   1 1 Integrity_check fails after dropping tables in autovacuumed database
1727 code fixed 2006 Mar drh   2006 Mar   1 1 Assertion fault on autovacuum :memory: database
1726 code fixed 2006 Mar anonymous Unknown 2006 Apr drh 1 1 wrong reported datatype when using group-by
1725 code closed 2006 Mar anonymous   2006 Mar   2 1 sql "HAVING" fails to filter query grouping "UNION ALL" subqueries
1724 code closed 2006 Mar anonymous Shell 2006 Mar anonymous 1 1 sqlite doesn't work with "cifs-mounted-directories"
1723 code closed 2006 Mar anonymous   2006 Mar   1 1 Crash (floating point error) when dealing with BIGINT datatypes
1722 new closed 2006 Mar anonymous Unknown 2009 Oct   4 2 agregate sum() of strings
1721 code fixed 2006 Mar anonymous Parser 2006 Mar   3 3 wrong column names in a compound select when used as a subquery
1720 new closed 2006 Mar anonymous   2009 Oct   3 4 Actions made by a trigger are not triggered
1719 code closed 2006 Mar anonymous   2009 Oct   4 4 Solaris 8(SQL: bus error while creating temporary file
1718 new closed 2006 Mar anonymous   2009 Oct   1 1 allow *.sqlite as parameter to sqlite3_analyzer
1717 code fixed 2006 Mar drh CodeGen 2006 Mar drh 1 1 CHECK constraints always use ABORT conflict resolution
1716 doc fixed 2006 Mar anonymous   2006 Mar   5 4 sqlite3_db_handle() has wrong documented signature
1715 doc closed 2006 Mar anonymous   2006 Mar   5 4 int sqlite3_release_memory(int) documented but not implemented
1714 code closed 2006 Mar anonymous CodeGen 2009 Dec   4 4 Slow query when tables in 2 different files
1713 code fixed 2006 Mar anonymous Unknown 2006 Mar   2 2 Cannot open datafiles in folders with special characters
1712 code closed 2006 Mar anonymous   2006 Mar   1 1 aggregate function return empty row
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)
1710 new closed 2006 Mar anonymous   2006 Aug   1 1 when order by, performance is low
1709 code fixed 2006 Mar anonymous   2006 Mar   1 1 sqlite3_column_name not apply column alias for views
1708 code closed 2006 Mar anonymous Unknown 2006 Mar anonymous 4 3 Spurious warning: no such table: faculty(1) at dbdimp.c line 269
1707 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Internal data are not naturaly aligned, which could affect perfomance
1706 code closed 2006 Mar anonymous   2006 Mar   1 2 Group operations like ORDER BY don't work after renaming a table
1705 code closed 2006 Mar anonymous Unknown 2006 Mar   4 4 Default column constant doesn't assign value on NULL insert
1704 new closed 2006 Mar anonymous   2009 Oct   4 3 extern "C" block in sqliteInt.h
1703 new closed 2006 Mar anonymous Pager 2009 Oct   2 3 Second parameter to gettimeofday() in os_unix.c should be NULL
1702 new fixed 2006 Mar anonymous   2009 Feb   5 4 feature request: API to write in-memory DB to file.
1701 doc closed 2006 Mar anonymous   2009 Oct drh 3 1 3.3 build option not documented?
1700 code closed 2006 Mar anonymous Parser 2009 Dec   2 2 Handling column names for aliased queries is broken
1699 code fixed 2006 Mar anonymous Unknown 2006 Mar   1 2 round(X) does not work correctly when nested in some functions
1698 build closed 2006 Mar anonymous   2009 Oct   1 1 sqlite_4y6ngs9FlYvAMGO 0kb 3/1/2006 1:16 PM
1697 code fixed 2006 Mar drh CodeGen 2006 Mar drh 1 1 Segfault while executing SELECT
1696 build fixed 2006 Feb anonymous Unknown 2006 Jun   4 4 obsolete "sort +4" and friends
1695 code fixed 2006 Feb anonymous   2006 Mar anonymous 1 1 Database file not loading ...
1694 code closed 2006 Feb anonymous Parser 2006 Feb   3 3 SELECT count(distinct vnum) FROM table generates syntax error.
1693 new closed 2006 Feb anonymous Parser 2009 Oct   4 4 Parser sensitive to position of word AUTOINCREMENT
1692 code closed 2006 Feb anonymous   2006 Mar   1 2 Collation dont work in functions
1691 code closed 2006 Feb anonymous Unknown 2006 Mar   3 3 sqlite3_sleep not built
1690 code fixed 2006 Feb anonymous   2006 Feb   5 4 utf8ToUnicode allocates too large buffer
1689 new closed 2006 Feb anonymous   2009 Oct   2 4 triggers and temporary tables
1688 code fixed 2006 Feb anonymous VDBE 2006 Mar danielk1977 3 2 Incorrect column names when doing select on views
1687 todo closed 2006 Feb dougcurrie   2006 Mar   3 3 tclsqlite.c crashes MinGW/MSYS gcc 3.4.5 on WIndows
1686 code closed 2006 Feb anonymous Pager 2006 Feb   2 4 File locking and concurrency problems under Windows
1685 code defer 2006 Feb anonymous   2006 Feb   1 1 Stall on multithread application.
1684 code fixed 2006 Feb anonymous   2006 Mar   2 2 SQLITE_MIN_SLEEP_MS not defined in main.c
1683 new closed 2006 Feb anonymous Unknown 2008 Jun   4 3 .mode html produces uppercase tags
1682 code fixed 2006 Feb anonymous Unknown 2006 Feb   4 4 accessing temp database causes crash
1681 code closed 2006 Feb anonymous Unknown 2006 Mar   1 3 After upgrading from 3.2.7 to 3.3.4, problems with umlauts
1680 build fixed 2006 Feb anonymous   2006 Mar   4 3 configure --enable-debug doesn't enable verbose explain
1679 new closed 2006 Feb anonymous   2009 Oct   4 4 SQLite requires code modification to replace memory allocation funcs
1678 code closed 2006 Feb anonymous Unknown 2006 Feb   1 1 error select like
1677 new closed 2006 Feb anonymous   2007 Aug   4 3 No way to know if library was compiled with threadsafety
1676 code closed 2006 Feb anonymous   2006 Feb   2 2 When binding the wrong type sqlite3 bails out but retuns an SQLITE_OK
1675 new closed 2006 Feb anonymous   2009 Oct   5 4 sqlite3_db_dup() ?
1674 code fixed 2006 Feb anonymous   2006 Feb   3 3 sum(-9223372036854775805) returns integer -9223372036854775808
1673 code closed 2006 Feb anonymous Shell 2006 Feb   3 3 constraint using "in" -- bug 1645 revisited
1672 code fixed 2006 Feb anonymous Unknown 2006 Feb   1 1 Deadlock when multithreading on unix
1671 new fixed 2006 Feb anonymous Parser 2006 Feb drh 5 4 Support '@' as a named parameter prefix
1670 code fixed 2006 Feb anonymous   2006 Feb   1 3 sum() still returns wrong result - the sequel
1669 code fixed 2006 Feb anonymous   2006 Feb   1 3 sum() still returns wrong result
1668 event closed 2006 Feb anonymous Shell 2006 Feb drh 2 3 datetime modifiers "enf of *" and "group * by" do not work
1667 code closed 2006 Feb anonymous BTree 2006 Feb danielk1977 1 1 Database corruption when db file hits 1 GB with auto_vacuum (3.3.3)
1666 code fixed 2006 Feb anonymous   2006 Feb   3 3 sqlite3_analyzer has 32-bit overflow errors
1665 code fixed 2006 Feb anonymous Unknown 2006 Feb drh 1 1 Memory corruption using ALTER TABLE
1664 code fixed 2006 Feb anonymous   2006 Feb   1 1 sum() returns wrong result
1663 new closed 2006 Feb anonymous Unknown 2009 Oct   4 4 Suggestion: DATETYPE field type using David Tribble's work?
1662 code fixed 2006 Feb anonymous Unknown 2006 Mar drh 1 3 Wrong CAST result rsp. missing string trimming on number conversions
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;
1660 code fixed 2006 Feb anonymous   2006 Feb danielk1977 1 1 OS memory allocation functions may round-up the requested size
1659 event closed 2006 Feb anonymous Shell 2006 Feb anonymous 1 2 Sqlite.exe .import stopped working in latest 3.3.3 release (Win32)
1658 code fixed 2006 Feb anonymous   2006 Feb   3 4 SQLITE3.EXE program crash
1657 code fixed 2006 Feb anonymous   2006 Feb   1 1 Disk I/O error when used on memory filesystem
1656 doc closed 2006 Feb anonymous Parser 2009 Oct   5 4 lemon versions and changelog
1655 new closed 2006 Feb anonymous VDBE 2009 Oct   4 4 Every function can have their private data like agreagates
1654 code fixed 2006 Feb anonymous VDBE 2006 Feb   1 1 crash when executing query on Intel builds
1653 new closed 2006 Feb anonymous CodeGen 2009 Oct   4 5 SQLITE_OMIT_COST_REORDERING ?
1652 code fixed 2006 Jan anonymous CodeGen 2006 Feb   3 4 sorting ASC vs DESC changes number of returned rows
1651 code fixed 2006 Jan anonymous Shell 2006 Jan   1 1 .import doesn't work in 3.3.3
1650 code fixed 2006 Jan anonymous Unknown 2006 Jan   3 4 Third parm of sqlite3_prepare is ignored.
1649 doc fixed 2006 Jan anonymous   2006 Jan drh 4 1 changes.tcl incorrect in latest checkin
1648 new closed 2006 Jan anonymous   2009 Oct   4 3 meaningless error message: constraint failed
1647 doc closed 2006 Jan anonymous Unknown 2008 Jun   3 1 i want to use this lib in my project
1646 doc fixed 2006 Jan anonymous   2006 Jan   3 4 API doc clarification for bind_text: utf8 bytes or chars?
1645 code fixed 2006 Jan anonymous Shell 2006 Jan   2 3 constraint using "in"
1644 code fixed 2006 Jan ghaering VDBE 2006 Jan   3 3 CREATE TEMP/DROP TEMP do not modify schema cookie
1643 doc closed 2006 Jan anonymous   2009 Oct   1 2 database-name.table-name not working for "PRAGMA table_info" + friends
1642 code closed 2006 Jan anonymous   2006 Jan   4 4 single time leaks in sqlite3_prepare()
1641 doc closed 2006 Jan anonymous   2006 Jan   5 4 Very minor documentation thing
1640 code closed 2006 Jan anonymous VDBE 2006 Jan   3 2 Can't get error message from sqlite3_result_error
1639 code closed 2006 Jan anonymous Unknown 2006 Mar   3 3 pkgconfig file in 3.3.1 says version is 3.3
1638 warn closed 2006 Jan anonymous   2009 Dec   3 2 rows place change and some row element missing
1637 code closed 2006 Jan anonymous Parser 2009 Oct   4 4 Multiple JOIN USING() doesn't work.
1636 todo closed 2006 Jan anonymous Shell 2009 Oct drh 4 3 stdev does not work
1635 doc closed 2006 Jan anonymous   2009 Oct   4 4 SQLite Ticket "Version" field
1634 code fixed 2006 Jan anonymous CodeGen 2006 Jan   3 3 LIMIT in nested select not working properly
1633 code closed 2006 Jan anonymous VDBE 2009 Oct   3 3 sqlite3_step returns SQLITE_ERROR when interrupted
1632 code fixed 2006 Jan anonymous VDBE 2006 Jan   3 3 sqlite3_result_error doesn't work in user defined aggregate function
1631 code closed 2006 Jan anonymous   2006 Jan   2 3 Sqli