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