# |
Type |
Status |
Created |
By |
Subsys |
Changed |
Assigned |
Svr |
Pri |
Title |
|
1268 |
build
|
closed
|
2005 May
|
anonymous
|
|
2017 Apr
|
|
1
|
1
|
/usr/include/sys/context.h:155: parse error before "sigset64_t"
|
edit |
2910 |
new
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
2
|
Number of rows in result set - new API
|
edit |
2906 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
anonymous
|
2
|
2
|
Error in MSVC v.6.0 (optimization: Maximize Speed mode)
|
edit |
2900 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
4
|
Can't ESCAPE in GLOB
|
edit |
2896 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
FTS3 misses document, but finds non-matching ones instead
|
edit |
2895 |
build
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
1
|
Please describe how to run an indvidual test out of the test suite
|
edit |
2890 |
build
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Assistance request fixing six 3.5.4 i/o test failures
|
edit |
2891 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
2
|
3
|
col with "NOT NULL", no default: works on table create, not col add
|
edit |
2887 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
anonymous
|
5
|
5
|
|| not outputing correctly with empty fields
|
edit |
2888 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
4
|
statement not commited
|
edit |
2889 |
build
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
2
|
Cannot disable TCL
|
edit |
2876 |
build
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
3.5.4 fails to build on OpenBSD...
|
edit |
2871 |
build
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
3
|
3
|
SQLite 3.5.4 build process does not listen to --disable-tcl
|
edit |
2870 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
danielk1977
|
5
|
5
|
Comment error
|
edit |
2868 |
code
|
closed
|
2008 Jan
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
Encryption user can't link latest SQLite
|
edit |
2862 |
warn
|
closed
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
4
|
3
|
Small warning fix
|
edit |
2861 |
doc
|
closed
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
|
1
|
1
|
How do I connect to Crystal Reports - I am using vs2003 & the Finisar
|
edit |
2858 |
build
|
closed
|
2007 Dec
|
anonymous
|
|
2008 Jan
|
danielk1977
|
3
|
3
|
amalgamated sqlite3.c requires sqlite3ext.h
|
edit |
2855 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
drh
|
2
|
3
|
Get an error "11:database disk image is malformed" during queries
|
edit |
2854 |
code
|
closed
|
2007 Dec
|
danielk1977
|
|
2007 Dec
|
danielk1977
|
1
|
1
|
BEGIN EXCLUSIVE does not prevent other shared-cache users from reading
|
edit |
2848 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
4
|
4
|
windows CRLF is incorrectly handled by .dump
|
edit |
2804 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
PRAGMA legacy_file_format=OFF setting lost with VACUUM
|
edit |
2758 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Why this?
|
edit |
2724 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Dec
|
drh
|
2
|
2
|
Load Ext api missing error_toobig function.
|
edit |
2717 |
doc
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Dec
|
anonymous
|
5
|
5
|
Document clarification around SQLITE_OMIT_MEMORY_ALLOCATION
|
edit |
2812 |
new
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
3
|
4
|
SQLITE_SECURE_DELETE overwrites with 0, but should use random data
|
edit |
2824 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
enable shared cache problem
|
edit |
2837 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
2
|
can't build testfixture in latest CVS
|
edit |
2836 |
build
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
Undefined symbol 'OP_StackDepth'
|
edit |
2830 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
5
|
5
|
tkt2822.test refers to tkt2820 ?
|
edit |
2834 |
event
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
1
|
Is Version 3.1.3 not compatible with 3.5.3 ?
|
edit |
2828 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
2
|
SQLITE_OMIT_SUBQUERY compile error: sqlite3CodeSubselect() missing.
|
edit |
2802 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
SELECT UNION and EXCEPT seem to have a memory allocation bug
|
edit |
2816 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
drh
|
4
|
3
|
.timer missing from CLI
|
edit |
2823 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
1
|
1
|
query not return values
|
edit |
2819 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
1
|
Blocking and crashing
|
edit |
2818 |
code
|
closed
|
2007 Dec
|
anonymous
|
|
2007 Dec
|
|
2
|
4
|
Comparison of 8 bytes integer numbers is truncated
|
edit |
2817 |
code
|
closed
|
2007 Dec
|
danielk1977
|
|
2007 Dec
|
danielk1977
|
1
|
1
|
Temp-tables with the same name as database tables can cause corruption
|
edit |
2798 |
build
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
3
|
4
|
Wrong nm used when cross-compiling
|
edit |
2777 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
shess
|
1
|
1
|
FTS[23] compile bug
|
edit |
2773 |
code
|
closed
|
2007 Nov
|
danielk1977
|
|
2007 Nov
|
|
2
|
1
|
sqlite crashes in sqlite3_step when compiled with SQLITE_THREADS=1
|
edit |
2790 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
2
|
2
|
sqlite3_compile returns NULL for empty statements
|
edit |
2782 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
bind_text(...) into transaction
|
edit |
2779 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
2
|
2
|
Performance optimizations
|
edit |
2778 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
adixon
|
1
|
1
|
Error 0
|
edit |
2775 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
3
|
4
|
Low-memory SEGV from sqlite3CodeRowTrigger()
|
edit |
2772 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
3
|
3
|
Low memory assert in analyze
|
edit |
2769 |
new
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
3
|
3
|
Enable access to the sql string used to prepare a statement
|
edit |
1813 |
new
|
closed
|
2006 May
|
anonymous
|
|
2007 Nov
|
|
2
|
3
|
select distinct doesn't take advantage of existing indexes
|
edit |
2744 |
code
|
closed
|
2007 Oct
|
drh
|
|
2007 Nov
|
danielk1977
|
1
|
1
|
Cannot quote collating sequence name
|
edit |
2768 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
3
|
3
|
asserts in wrong order
|
edit |
2765 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
3
|
bad rollback if temporary table created during transaction
|
edit |
2747 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Nov
|
maria.khomenko
|
1
|
1
|
How to use Composite Key in Sqlite
|
edit |
2764 |
todo
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
2
|
2
|
Since I installed Leopard I keep getting sqlite3 data bases in trash
|
edit |
2751 |
build
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Nov
|
|
2
|
3
|
Regression - Solaris/sparc throws BUS ERROR on count()/sum()/etc.
|
edit |
2759 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
danielk1977
|
1
|
2
|
crash due to 'select * from virtualTable where x is null'
|
edit |
2757 |
doc
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
1
|
1
|
Special characters handling in SQLite Like Query
|
edit |
1779 |
new
|
closed
|
2006 Apr
|
anonymous
|
|
2007 Nov
|
|
5
|
4
|
enhancement request (+ pointer) -- group_concat() aggregate function
|
edit |
2752 |
code
|
closed
|
2007 Nov
|
anonymous
|
|
2007 Nov
|
|
5
|
5
|
redundant assignment?
|
edit |
2750 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
1
|
for the new.somefield value returns the old value of it
|
edit |
2746 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
PRIMARY KEY does not treat NULL as unique
|
edit |
2745 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
shazow
|
1
|
1
|
Sharing File between two processes
|
edit |
2743 |
doc
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Comparison of SQLite against McObject Fusion
|
edit |
2742 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
codeInteger and codeReal
|
edit |
2731 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
sqlite3ExprCode TK_UMINUS inefficient with large negative floats
|
edit |
2663 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
3
|
3
|
Adding a column with default value not reflected in view
|
edit |
2735 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
nmadhav
|
3
|
1
|
Error : Unrecognized Token
|
edit |
2734 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
1
|
2 bug under the wince
|
edit |
2730 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
anonymous
|
3
|
2
|
Can't compile for WindowsCE
|
edit |
2679 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
2
|
3
|
locking errors lead to disk i/o failure with bulk operations on winxp
|
edit |
2726 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
4
|
3
|
solaris 10 compilation B_FALSE, B_TRUE clash from sys/types.h
|
edit |
2277 |
code
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Incorrect usage of CRITICAL_SECTION and TLS on Windows
|
edit |
2490 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Latest cvs 3.4.0 seg fault
|
edit |
2603 |
new
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
|
1
|
3
|
B-tree and B+tree allow bidirectional cursor but VDBE does not.
|
edit |
2657 |
build
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
anonymous
|
1
|
1
|
fail to compile
|
edit |
2707 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
appledev
|
1
|
3
|
SQLite on Mac OS X seems to have a 4GB database limit
|
edit |
2630 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
a.rottmann
|
2
|
2
|
sqlite3PagerOpen set a wrong temp file name in pPager->zFilename
|
edit |
2723 |
new
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
anonymous
|
5
|
4
|
After execution of SQL, the Data Returned should display the col.name
|
edit |
2720 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
WinCE - Can't write
|
edit |
2719 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
1
|
WinCE winFullPathName doesn't return a value
|
edit |
2718 |
build
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
1
|
WinCE compile error
|
edit |
2709 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
2
|
3
|
Some SQLITE_OMIT_* keys break the sqlite3.c amalgamation compilation
|
edit |
2712 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
5
|
4
|
Expose a function to change the journal filename location
|
edit |
2706 |
warn
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
danielk1977
|
4
|
4
|
make test aborts when built with SQLITE_OMIT_ATTACH
|
edit |
2695 |
new
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
drh
|
3
|
3
|
sqlite3 CLI unresolved externals with SQLITE_OMIT_GET_TABLE
|
edit |
2689 |
build
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
make test fails in 3.5.1 - unresolved externals in testfixture
|
edit |
2585 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
anonymous
|
1
|
1
|
Error Function GetAtomNameA
|
edit |
2601 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Problem with opening database with Unicode filename
|
edit |
2639 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
1
|
2
|
Russian charset
|
edit |
2692 |
build
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
COmpilation of Sqlite amalgamation v3.4.2. failed
|
edit |
2688 |
build
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
1
|
SQLITE_OMIT_AUTHORIZATION build failure
|
edit |
2691 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
SQLITE_OMIT_AUTHORIZATION compilation error
|
edit |
2690 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
"PRAGMA synchronous = OFF;" is more dangerous than documented
|
edit |
2519 |
new
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
Page cache and schema should be shared between all connections/threads
|
edit |
2656 |
doc
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
2
|
1
|
missing documentation: END TRANSACTION
|
edit |
2682 |
code
|
closed
|
2007 Oct
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
SQLite Text Problem
|
edit |
2668 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
3
|
4
|
Build failure due to syntax error under Cygwin
|
edit |
2670 |
doc
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
5
|
4
|
Document for EXPLAIN doesn't mention using EXPLAIN QUERY PLAN
|
edit |
2667 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
|
1
|
1
|
no such function: hex no such function: regexp
|
edit |
2654 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Oct
|
jadams
|
1
|
1
|
sqlite3_prepare return 1(fail)
|
edit |
2675 |
new
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
TEMP_STORE does not appear to be set by the compile time switch
|
edit |
2676 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
TEMP_STORE does not appear to be set by the compile time switch
|
edit |
2669 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
anonymous
|
2
|
3
|
INSERT of Large REAL value fails with Floating Point Exception
|
edit |
2665 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
1
|
Dissapearing exclusive lock when DB is copied...
|
edit |
2662 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Serious Performance Degradation from 3.3.4 to 3.3.5 & latest versions
|
edit |
1929 |
warn
|
closed
|
2006 Aug
|
anonymous
|
|
2007 Sep
|
|
4
|
3
|
3.3.7 sqlite3_index_info incompatible with C++
|
edit |
2661 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
Single line, multi inserts
|
edit |
2660 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
4
|
4
|
Spelling error in comment for SQLITE_CONSTRAINT
|
edit |
2655 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
Reuse prepared statement after locked(5) gives called out of seq(21)
|
edit |
2650 |
build
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
lack ; in os_win.c:1329
|
edit |
2647 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
sqlite-3.5.0 Cygwin: Compilation fails on src/os_win.c - ';' missing
|
edit |
2646 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
a.rottmann
|
4
|
1
|
sqlite3_get_table loses one table row
|
edit |
2644 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
sqlite
|
edit |
2636 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Bug in sqlite3_prepare_v2
|
edit |
2642 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
5
|
5
|
CYGWIN compile error due to missing semicolon
|
edit |
2641 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
sqlite - Ticket #2638 continued as it was arbitrarily closed unsolved
|
edit |
2638 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
selects on japanese text okay in 3.3.5 bad in later versions
|
edit |
2637 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Segfault in pthread_getspecific ()
|
edit |
2635 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
3
|
2
|
problem with calculation of juliand date
|
edit |
2626 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
The Amalgamation compile error
|
edit |
2625 |
build
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
2
|
2
|
http://www.sqlite.org/cvstrac/wiki?p=HowToCompileWithVsNet has problem
|
edit |
2617 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
drh
|
2
|
3
|
Check in #4357 may lead to bugs in SMP aware systems in windows vfs
|
edit |
2486 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Sep
|
|
2
|
3
|
pragma index_list does not detect index created on 2nd connection
|
edit |
2620 |
doc
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
5
|
5
|
doc note needed for sqlite3_memory_alarm()
|
edit |
2618 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
linus
|
4
|
1
|
Dabase is Locked
|
edit |
2614 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Custom VFS still calls default xRandomness
|
edit |
2609 |
code
|
closed
|
2007 Sep
|
anonymous
|
|
2007 Sep
|
|
1
|
1
|
Is non-thread safe binaries dangerous for multi-threaded app design ?
|
edit |
2605 |
build
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
3
|
Amalgamated version 3.4.2 doesn't compile (VC++6)
|
edit |
1677 |
new
|
closed
|
2006 Feb
|
anonymous
|
|
2007 Aug
|
|
4
|
3
|
No way to know if library was compiled with threadsafety
|
edit |
2596 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
2
|
2
|
wrong specifier for extern char arrays
|
edit |
2594 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
5
|
4
|
ability to replace allocator
|
edit |
2593 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
btshared unlock bug
|
edit |
2592 |
warn
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
The Entry C:\Windows\Temp\sqlite_z6onAYdsVGqLG3Q is Invalid
|
edit |
2589 |
doc
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
danielk1977
|
4
|
4
|
s/effected/affected/ in PRAGMA locking_mode
|
edit |
2590 |
todo
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
danielk1977
|
2
|
2
|
return value of strftime('%s', 'now') being determined as 'text'
|
edit |
2586 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
INSERT of large number fails on Windows
|
edit |
2584 |
new
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
2
|
On Windows function sqlite3WinSleep needs to dispatch messages
|
edit |
2581 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
./configure && make broken: new source files: mem[12].c, mutex.c, etc
|
edit |
2578 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
sqlite3BtreeEnter, sqlite3BtreeLeave threading issues
|
edit |
2577 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
5
|
5
|
Initilizing pointers to 0 instead of NULL.
|
edit |
2576 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
Check-in [4239] mutex race conditions
|
edit |
2575 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
sqlite3_mutex_enter missing return
|
edit |
2572 |
warn
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
Sqlitw error unrecognize token
|
edit |
2563 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
sqlite3_column_database_name16() is broken
|
edit |
2571 |
todo
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
1
|
SQLite opening in Access
|
edit |
2536 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Aug
|
|
2
|
3
|
Possible non-ID index corruption when max_page_count exceeded
|
edit |
2569 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
2
|
Executing a statement causes an AccessViolation Exception
|
edit |
2564 |
event
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
anonymous
|
4
|
4
|
in C:\windows\temp are 50 files like sqlite_fMyj88gwaTTNgUF and 0 kb
|
edit |
2562 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
2
|
3
|
Multithreaded transactions deadlock (Windows)
|
edit |
2557 |
build
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
make test errors on Rhel4 x86_64
|
edit |
2553 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
AUTOINCREMENT not working when primary key has multiple columns
|
edit |
2551 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
3
|
3
|
sqlite3 shell gets into bad state with unexpected input
|
edit |
2552 |
code
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
3
|
sqlite3_column_double causes invalid floating point operation
|
edit |
2480 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Aug
|
|
4
|
4
|
typo in faq.tcl
|
edit |
2549 |
build
|
closed
|
2007 Aug
|
anonymous
|
|
2007 Aug
|
|
1
|
3
|
3.4.1 fails to upgrade from 3.3.1.7 on freeBSD
|
edit |
2439 |
code
|
closed
|
2007 Jun
|
rse
|
|
2007 Jul
|
|
1
|
1
|
FTS1 and FTS2 use the unportable <malloc.h>
|
edit |
2542 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
1
|
select 3/2 * avg(x) gives wrong result
|
edit |
2541 |
doc
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
danielk1977
|
4
|
4
|
ALTER TABLE <foo> RENAME TO <bar> doesn't update (all) trigger schema
|
edit |
2534 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
danielk1977
|
2
|
3
|
sqlite3_set_auxdata may cause memory to be leaked
|
edit |
2538 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
calling sqlite3_interrupt() randomly leaves db->ul.isInterrupted = 1
|
edit |
2537 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
sqlite3_column_type() function problem.
|
edit |
2532 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
4
|
Endless loop in Parser?
|
edit |
2531 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
a.rottmann
|
1
|
1
|
Can't find head files in icu.c
|
edit |
2527 |
doc
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
2
|
sqlite3_create_module() API documentation missing
|
edit |
2529 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
anonymous
|
1
|
1
|
Bug in sqlite3_prepare_v2( ) function
|
edit |
2493 |
build
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
3
|
Fails to build under GCC-4.1.3 on FreeBSD-6.2
|
edit |
2516 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
3
|
REGRESSION:sqlite3_prepare ignores nBytes parameter
|
edit |
2515 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
Entered to ASCII zeros as a text string was return a single zero.
|
edit |
2513 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
2
|
Internal compiler error tclsqlite.c
|
edit |
2500 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
4
|
Possible memory leak on avr32 arch
|
edit |
2505 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
does not return error when use sqlite_open to open an non-sqlite db
|
edit |
2504 |
build
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
sqlite 3.4.0 fails to build FreeBSD 6.2 64-bit system
|
edit |
2501 |
build
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
2
|
3
|
limits.h confilct with visual studio limits.h
|
edit |
2497 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
2
|
sqlite3_errcode does not return the proper error code
|
edit |
2495 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
standard C library Naming conflict - limits.h
|
edit |
2494 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
DRow["ID"] = reader.GetString(reader.GetOrdinal("ID")); fails
|
edit |
2492 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
4
|
4
|
Incorrect protoype for function sqlite3_result_zeroblob
|
edit |
2489 |
build
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
1
|
Latest cvs 3.4.0 make test fails related to TCL
|
edit |
2243 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Jul
|
|
2
|
3
|
sqlite3 authorizer cannot be exposed in garbage collected languages
|
edit |
2485 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
2
|
SQLite + Python segfaults at various places in the code
|
edit |
2483 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
3
|
like clause not working
|
edit |
2482 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
3
|
4
|
Possible optimizer bug
|
edit |
2481 |
code
|
closed
|
2007 Jul
|
anonymous
|
|
2007 Jul
|
|
1
|
3
|
sqlite leaks memory (after 3.3.13)
|
edit |
2449 |
doc
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
BLOB and binary data
|
edit |
2461 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
BLOB retrieval produces garbled data in UTF-16
|
edit |
2478 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
2
|
LIMIT and OFFSET abbreviation to LIMIT x,y bug!
|
edit |
2472 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
smart quotes turning question marks while storing in oracle 9i DB
|
edit |
2471 |
secure
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
a bug for 64 bit driver under operation system
|
edit |
2463 |
todo
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
anonymous
|
1
|
1
|
Crash after calling sqlite_close() if SQLITE_ENABLE_MEMORY_MANAGEMENT
|
edit |
2357 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 Jun
|
anonymous
|
2
|
2
|
Crash in sqlite3PagerClose when SQLITE_ENABLE_MEMORY_MANAGEMENT is def
|
edit |
2462 |
todo
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
www.sqlite.org/cvstrac/tktnew suggestion
|
edit |
2444 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
SIGFPE from division of (1<<63)==9223372036854775808
|
edit |
2460 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
VC6 Compile Error
|
edit |
2458 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
sqlite caching results between calls to select on an open database
|
edit |
2445 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
crash in sqlite3_prepare16
|
edit |
2452 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
drh
|
1
|
1
|
In Memory Query Performance
|
edit |
2451 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
vdbe.c comment typo
|
edit |
2450 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
Crashes and random wrong results with certain column names
|
edit |
2441 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
2
|
3
|
Windows only error when deleting tempory files
|
edit |
2447 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
4
|
select where TABLENAME="TABLENAME" returns whole table.
|
edit |
2420 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
5
|
5
|
sqlite3_prepare() don't work in php pdo implementation
|
edit |
2435 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
Data corruption in version 3.4.0
|
edit |
2429 |
code
|
closed
|
2007 Jun
|
danielk1977
|
|
2007 Jun
|
shess
|
1
|
3
|
problem with fts2 snippet() function
|
edit |
2421 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
unresolved external
|
edit |
2405 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
sqlite3_prepare() don't work in php pdo implementation
|
edit |
2412 |
build
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
a.rottmann
|
1
|
1
|
Can't make Sqlite 3.3.17 on Solaris 10 X86
|
edit |
2389 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 Jun
|
|
1
|
1
|
database placed in the non ASCII named folder could not be opened
|
edit |
2402 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
3
|
3
|
Left Outer Join and Where clause
|
edit |
2400 |
code
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
|
4
|
4
|
SELECT COUNT (*); returns 1 rather than 0.
|
edit |
2395 |
todo
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
mani
|
4
|
1
|
SQLite3 cmd prompt interface problem
|
edit |
2394 |
todo
|
closed
|
2007 Jun
|
anonymous
|
|
2007 Jun
|
mani
|
4
|
1
|
SQLite3 cmd prompt interface problem
|
edit |
2390 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
drh
|
1
|
1
|
defect in select with max(id)
|
edit |
2391 |
todo
|
closed
|
2007 May
|
danielk1977
|
|
2007 May
|
danielk1977
|
1
|
1
|
Inconsistent behaviour from explicit collate clauses.
|
edit |
2385 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
4
|
Comment for SQLITE_VERSION_NUMBER has a typo (missing zero).
|
edit |
2387 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
query: problem with update anagrafica SET nome='nome' where id = '4';
|
edit |
2386 |
doc
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
5
|
4
|
Suggestion for wiki speed comparisson: order by, group by, subselect
|
edit |
2384 |
doc
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
5
|
an error in comments
|
edit |
2380 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Order By Collum1, Collum2, Collum3 for Pocket PC incorrect in device
|
edit |
2375 |
doc
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
sqlite3_exec docs mentions sqlite3_reset
|
edit |
2369 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
if you do a configure --prefix=/home/someotherdir tcl installs wrong
|
edit |
2370 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
2
|
Data is converted without me telling it to do so
|
edit |
2368 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
vdbeblob.c missing from Makefile.in
|
edit |
2367 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
2
|
2
|
SQLITE_OMIT_INCRBLOB breaks default "make test"
|
edit |
2366 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
"make test" failures: pragma-1.15, pragma-1.16
|
edit |
2365 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
incrvacuum2, zeroblob regressions from check-ins on 2007-May-16
|
edit |
2362 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
4
|
Can't add a column with ALTER TABLE
|
edit |
2361 |
new
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
3
|
Why is no LIMIT suported in UPDATE-queries?
|
edit |
2355 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
4
|
Segfault with looooong sql string
|
edit |
2358 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
3
|
4
|
Incorrect index chosen for query
|
edit |
2353 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Issue with selecting values of indexed column
|
edit |
2346 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Inserting a certain integer
|
edit |
2338 |
todo
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
4
|
3
|
3.3.17 windows dll download gives 3.2.7
|
edit |
2332 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
danielk1977
|
1
|
1
|
incrblob: Data error writing large blobs
|
edit |
2331 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
|
1
|
1
|
Performance problem with complex where clause
|
edit |
2330 |
code
|
closed
|
2007 May
|
anonymous
|
|
2007 May
|
drh
|
2
|
2
|
Usage of fieldname Session is impossible for where clause
|
edit |
2325 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Link Fails w/ SQLITE_OMIT_ALTERTABLE
|
edit |
2178 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
On Windows Vista, a simple select returns different results.
|
edit |
2317 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
Floats rendered to strings differently in WHERE and GROUP BY clauses.
|
edit |
2315 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
Macro Redefinition Warning
|
edit |
2316 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
2 prepared statements on same database cause RC = 21
|
edit |
2312 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
mike
|
1
|
1
|
Using ODBC. Only saves first 5 characters of text fields. Can you help
|
edit |
2305 |
doc
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
4
|
4
|
Function replace(X,Y,Z) doesn't exist ?
|
edit |
2300 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
compound query ORDER BY expression problem
|
edit |
2293 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
2
|
2
|
Extra file operations with sub journal when DB in MEM
|
edit |
2292 |
code
|
closed
|
2007 Apr
|
anonymous
|
|
2007 Apr
|
|
1
|
1
|
VACUUM => constraint failed
|
edit |
2279 |
code
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
3
|
4
|
sqlite3_exec NULL pointer crash
|
edit |
2170 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
anonymous
|
3
|
3
|
-init does not execute .exit/.quit
|
edit |
2169 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Mar
|
adamd
|
2
|
1
|
cast function
|
edit |
2255 |
code
|
closed
|
2007 Feb
|
scouten
|
|
2007 Mar
|
|
3
|
3
|
Temporary DB files are deleted twice in pager_unwritelock, once implic
|
edit |
2269 |
code
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
anonymous
|
2
|
1
|
SQLite3_Column_decltype treat [char] (32) as 'char',but not 'char(32)'
|
edit |
2275 |
code
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
2
|
4
|
Can't get where clause to recognize equality with generated value
|
edit |
2271 |
doc
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
3
|
4
|
Can't use "limit" as column name
|
edit |
2265 |
doc
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
1
|
1
|
windows + xampp (php) + sqlite3 ... how?
|
edit |
2263 |
code
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
1
|
1
|
Apparent potential leak or concurrency problem when using codec
|
edit |
2261 |
build
|
closed
|
2007 Mar
|
anonymous
|
|
2007 Mar
|
|
1
|
1
|
Problem under Windows 95
|
edit |
2260 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
|
1
|
1
|
virtual table/vdbe does not call xFilter() making xColumn segv
|
edit |
2253 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
danielk1977
|
1
|
1
|
src/vdbe.c:3639: sqlite3VdbeExec: Assertion `pC!=0' failed.
|
edit |
2250 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Mar
|
danielk1977
|
1
|
1
|
segmentation violation when using "select max(rowid)" in fts1
|
edit |
2245 |
new
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
a.rottmann
|
5
|
1
|
Union Problem on Empty Table
|
edit |
2244 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
danielk1977
|
1
|
2
|
xUpdate in virtual table being called when no record exists
|
edit |
2240 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
Parser command termination problem fails to catch illegal statements
|
edit |
2239 |
doc
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
Size of database in Speed Comparison?
|
edit |
2236 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
inserts with selects do not work in 3.1.13
|
edit |
2234 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
1
|
1
|
3.3.13 is identical to 3.3.12 except VERSION file
|
edit |
2232 |
build
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
3
|
3
|
corrupt2.test fails with newer versions of Tcl
|
edit |
2230 |
code
|
closed
|
2007 Feb
|
danielk1977
|
|
2007 Feb
|
danielk1977
|
1
|
1
|
Problem with virtual tables and grouping by aggregate function.
|
edit |
2212 |
code
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
4
|
function request: sqlite3_bind_literal()
|
edit |
2213 |
code
|
closed
|
2007 Feb
|
danielk1977
|
|
2007 Feb
|
danielk1977
|
1
|
1
|
Bug handling strings that are not nul-terminated.
|
edit |
2209 |
doc
|
closed
|
2007 Feb
|
anonymous
|
|
2007 Feb
|
|
5
|
5
|
Wrong Comment in the change #3622
|
edit |
2197 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
5
|
invalid(?) join syntax results in runnable sql code
|
edit |
2196 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
5
|
3
|
Bug in PRAGMA full_column_names with SELECT *
|
edit |
2190 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
3
|
4
|
bogus lines on "left join" with a "where right_table.column is NULL"
|
edit |
2186 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
drh
|
1
|
1
|
database seems to be corrupted during a huge transaction
|
edit |
2179 |
new
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
1
|
Odbc driver for sqlite takes more time in executing a query.
|
edit |
2174 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
anonymous
|
2
|
3
|
DBD::SQLite does not return number of rows affected. Count(XXX) OK
|
edit |
2162 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
1
|
c code compile fails with "Undefined reference to sqlite3_open()"
|
edit |
2158 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
2
|
SCHEMA error still returned if SQL becomes invalid
|
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 |
2155 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
4
|
4
|
Should %s in strftime() be rounded up?
|
edit |
2150 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
3
|
3
|
use of %W in strftime produces unreliable results
|
edit |
2152 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
1
|
there is not tclsqlite.h in sqlite3.3.9
|
edit |
2146 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
2
|
Correlated subqueries as columns of select return a syntax error
|
edit |
2142 |
build
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
2
|
2
|
make fails on cygwin
|
edit |
2138 |
code
|
closed
|
2007 Jan
|
anonymous
|
|
2007 Jan
|
|
1
|
2
|
COLLATE and multiple order by problem
|
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 |
2134 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
2
|
1
|
is this a bug of sqlite3_prepare?
|
edit |
2124 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
1
|
1
|
default ./configure && make broken on Linux in latest CVS
|
edit |
2121 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
3
|
4
|
Paths on Win9x following API specs (UTF-8) will fail
|
edit |
2119 |
new
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
Unable to use place holders as part of the actual SQL query
|
edit |
2115 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
5
|
4
|
mix of allocator functions
|
edit |
2108 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
4
|
3
|
potential memory leak in prepare.c
|
edit |
2094 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
1
|
3
|
Virtual table cursors are not freed (memory leak)
|
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 |
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 |
2097 |
code
|
closed
|
2006 Dec
|
anonymous
|
|
2006 Dec
|
|
1
|
1
|
MAX function broken
|
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 |
2091 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
3
|
thread unsafety + solution
|
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 |
1945 |
code
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
symbol not found: sqlite_freemem
|
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 |
2079 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
strftime doesn't work in where statement
|
edit |
2073 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
4
|
4
|
Ordering by a named expression which includes random doesn't work
|
edit |
2064 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
3
|
4
|
Table Name ignored if table Alias specified
|
edit |
2058 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
sum or total result in only 1 row returned
|
edit |
2054 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
material to learn SQLite
|
edit |
2053 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
problem on solaris 10
|
edit |
2052 |
code
|
closed
|
2006 Nov
|
anonymous
|
|
2006 Nov
|
|
1
|
1
|
BLOBs still do not work on version 3.0
|
edit |
2049 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
sqlite_HrmKZy6ma4XBUGl is in my temp file and cannot be deleted.
|
edit |
2042 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
2
|
3
|
Subquery does not return the expected NULL
|
edit |
2039 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
How to delete SQLITE Temp files
|
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 |
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 |
2031 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
.DEF file missing from 3.3.8 source code distribution
|
edit |
2021 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
a.rottmann
|
2
|
1
|
Expression Always Returning String
|
edit |
2020 |
code
|
closed
|
2006 Oct
|
anonymous
|
|
2006 Oct
|
|
1
|
1
|
sqlite3_column_type always returns 1
|
edit |
1995 |
code
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Oct
|
|
2
|
1
|
SHARED lock does not kick in (DEFERRED does not work ?)
|
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 |
1997 |
code
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
2
|
3
|
can't select rows if column name is contained in data
|
edit |
1993 |
event
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
3
|
1
|
bit operators problemm
|
edit |
1956 |
code
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
ALTER TABLE ADD COLUMN does not support asian language column names.
|
edit |
1985 |
doc
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
4
|
how get table names
|
edit |
1984 |
code
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
1
|
1
|
sqlite3_exec problem
|
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 |
1965 |
code
|
closed
|
2006 Sep
|
anonymous
|
|
2006 Sep
|
|
3
|
3
|
sqlite returns wrong error code
|
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 |
1950 |
new
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Sep
|
|
4
|
4
|
AUTOINCREMENT too picky about type
|
edit |
1949 |
new
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
1
|
Missing 64Bit type
|
edit |
1940 |
code
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
3
|
3
|
insert default values
|
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 |
1931 |
new
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
3
|
3
|
timezone difference between PDO/Sqlite and PHP
|
edit |
1710 |
new
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Aug
|
|
1
|
1
|
when order by, performance is low
|
edit |
1921 |
code
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
4
|
4
|
misc1-10.1 failure on cygwin aborts make test
|
edit |
1910 |
event
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
3
|
4
|
Lost clusters generated by "create TEMP Table" (DJGPP/GCC2.953)
|
edit |
1903 |
code
|
closed
|
2006 Aug
|
anonymous
|
|
2006 Aug
|
|
2
|
2
|
LIKE string search sometimes fails
|
edit |
1520 |
new
|
closed
|
2005 Nov
|
anonymous
|
|
2006 Jul
|
|
4
|
4
|
sqlite3_column_type do not work for empty table
|
edit |
1883 |
code
|
closed
|
2006 Jul
|
anonymous
|
|
2006 Jul
|
|
1
|
2
|
"no such table error" using sqlite-odbc driver
|
edit |
1880 |
code
|
closed
|
2006 Jul
|
anonymous
|
|
2006 Jul
|
|
3
|
3
|
Errors testing sqlite 3.3.6
|
edit |
1870 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
2
|
2
|
dbWriteTable in RSQLite can't write strings that contain commas.
|
edit |
1866 |
event
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
1
|
SQLite.NET ExecuteNonQuery() limit of text size
|
edit |
1865 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
2
|
Encoding problem using order by
|
edit |
1855 |
doc
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
5
|
5
|
how to configure SQLite with jboss
|
edit |
1854 |
event
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
3
|
3
|
i am unable to view the tables by using .tables command
|
edit |
1852 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
4
|
5
|
AUTOINC NOT NULL problem
|
edit |
1846 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
1
|
Memory leak after returning error message
|
edit |
1844 |
warn
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
2
|
3
|
compiler warnings with gcc 3.3.4 on Tru64 V5.1B
|
edit |
1843 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
3
|
2
|
compile with gcc 3.3.4 on Tru64 V5.1B
|
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 |
1834 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
5
|
5
|
Can't create database with the é name (french E)
|
edit |
1832 |
code
|
closed
|
2006 Jun
|
anonymous
|
|
2006 Jun
|
|
1
|
1
|
Segmentation fault when placing a 0 limit on a joined subquery.
|
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 |
1529 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2006 May
|
|
1
|
1
|
can not uses japanese as table name to create table
|
edit |
1823 |
code
|
closed
|
2006 May
|
anonymous
|
|
2006 May
|
|
1
|
1
|
pysqlite2.dbapi2.OperationalError: unable to open database file
|
edit |
1808 |
code
|
closed
|
2006 May
|
anonymous
|
|
2006 May
|
|
1
|
1
|
Wrong index is chosen
|
edit |
1800 |
new
|
closed
|
2006 May
|
anonymous
|
|
2006 May
|
linus
|
1
|
2
|
possible to have the lastest version of sqlite with PHP 5?????
|
edit |
1796 |
code
|
closed
|
2006 May
|
anonymous
|
|
2006 May
|
|
1
|
1
|
.import command not working in 3.3.5
|
edit |
1793 |
code
|
closed
|
2006 May
|
anonymous
|
|
2006 May
|
|
2
|
3
|
sqlite3.dll crashes when doing an inner join with limit 0
|
edit |
1787 |
code
|
closed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
1
|
1
|
Certain integer values are written/read incorrectly to/from database
|
edit |
1774 |
code
|
closed
|
2006 Apr
|
ghaering
|
|
2006 Apr
|
|
1
|
1
|
sqlite3_column_decltype() stopped working in SQLite 3.3
|
edit |
1765 |
code
|
closed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
1
|
2
|
SQLite3_BindText fails with a floating point error (explicited)
|
edit |
1757 |
code
|
closed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
2
|
1
|
sqlite not using index
|
edit |
1760 |
code
|
closed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
4
|
4
|
sqlite3_open(), then sqlite3_close()
|
edit |
1759 |
code
|
closed
|
2006 Apr
|
anonymous
|
|
2006 Apr
|
|
3
|
4
|
"int primary key" not the same as "integer primary key"
|
edit |
1539 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2006 Mar
|
|
4
|
4
|
sqlite3Realloc is a trap for the unwary
|
edit |
1499 |
code
|
closed
|
2005 Oct
|
anonymous
|
|
2006 Mar
|
anonymous
|
3
|
1
|
Sqlite 3.2.7 does not support Chinese path.
|
edit |
1563 |
code
|
closed
|
2005 Dec
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
The system crash when creating a database!
|
edit |
1706 |
code
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
2
|
Group operations like ORDER BY don't work after renaming a table
|
edit |
1712 |
code
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
aggregate function return empty row
|
edit |
1725 |
code
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
2
|
1
|
sql "HAVING" fails to filter query grouping "UNION ALL" subqueries
|
edit |
1730 |
new
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
2
|
5
|
referential integrity
|
edit |
1729 |
code
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
SQLite loses precision on 64-bit integers
|
edit |
1723 |
code
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
1
|
1
|
Crash (floating point error) when dealing with BIGINT datatypes
|
edit |
1715 |
doc
|
closed
|
2006 Mar
|
anonymous
|
|
2006 Mar
|
|
5
|
4
|
int sqlite3_release_memory(int) documented but not implemented
|
edit |
1553 |
new
|
closed
|
2005 Dec
|
anonymous
|
|
2006 Mar
|
|
5
|
4
|
API suggestion: sqlite3_has_more_rows()
|
edit |
1687 |
todo
|
closed
|
2006 Feb
|
dougcurrie
|
|
2006 Mar
|
|
3
|
3
|
tclsqlite.c crashes MinGW/MSYS gcc 3.4.5 on WIndows
|
edit |
1692 |
code
|
closed
|
2006 Feb
|
anonymous
|
|
2006 Mar
|
|
1
|
2
|
Collation dont work in functions
|
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 |
1642 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
4
|
single time leaks in sqlite3_prepare()
|
edit |
1641 |
doc
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
5
|
4
|
Very minor documentation thing
|
edit |
1581 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
3
|
incompatible pointer types lead to compilation errors
|
edit |
1631 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
2
|
3
|
Sqlite3 reports fdatasync type referenced symbol not found on Solaris
|
edit |
1624 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
OSMALLOC(int n) implementation does not allow OOM testing
|
edit |
1620 |
todo
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
1
|
1
|
error database or disk is full
|
edit |
1623 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
ThreadData instance never gets freed
|
edit |
1610 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
1
|
2
|
SQLITE_OMIT_SUBQUERY can cause access violation
|
edit |
1618 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
Problematic ENTER_MALLOC() macro definition
|
edit |
1617 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
drh
|
1
|
1
|
Memory allocation routines always return non-zero value
|
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 |
1606 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
1
|
1
|
sqlite3_prepare16 broken
|
edit |
1602 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
5
|
likely typo in shell.c
|
edit |
1599 |
doc
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
5
|
5
|
Typo in FAQ not quite fixed
|
edit |
1595 |
doc
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
1
|
tcl-devel is required to build. This requirement is not listed
|
edit |
1580 |
code
|
closed
|
2006 Jan
|
anonymous
|
|
2006 Jan
|
|
4
|
2
|
3.2.8 does not compile under Solaris 10
|
edit |
1571 |
code
|
closed
|
2005 Dec
|
anonymous
|
|
2005 Dec
|
|
1
|
1
|
SQLiteCC crashes when you rollback create table
|
edit |
1561 |
build
|
closed
|
2005 Dec
|
anonymous
|
|
2005 Dec
|
|
3
|
1
|
compile sqlite 3.2.7 failed on Unix
|
edit |
1551 |
code
|
closed
|
2005 Dec
|
anonymous
|
|
2005 Dec
|
|
1
|
1
|
sqlite3_reset seems not to be exported correctly
|
edit |
1548 |
warn
|
closed
|
2005 Dec
|
|
|
2005 Dec
|
|
1
|
1
|
Command failed for target `sqlite3'
|
edit |
1538 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
Access Violation error
|
edit |
1534 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
error:
|
edit |
1531 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
4
|
3
|
Crash when evaluating SELECT ... HAVING NOT EXISTS
|
edit |
1526 |
new
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
Unused data structure fields when trace support is omitted.
|
edit |
1490 |
code
|
closed
|
2005 Oct
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
Create Temp Index has problem
|
edit |
1492 |
code
|
closed
|
2005 Oct
|
anonymous
|
|
2005 Nov
|
|
1
|
4
|
CURRENT_TIMESTAMP bad for PM times.
|
edit |
1517 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
unable to drop a temporary table when database is locked
|
edit |
1516 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
2
|
comparison error in WHERE clause
|
edit |
1511 |
event
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
1
|
1
|
how to use the index with "order by"
|
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 |
1509 |
code
|
closed
|
2005 Nov
|
anonymous
|
|
2005 Nov
|
|
3
|
2
|
Different performance - SELECT COUNT(*) AND SELECT *
|
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 |
1482 |
code
|
closed
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
1
|
1
|
Cannot finish a transaction if a previous transaction was rolled back;
|
edit |
1472 |
build
|
closed
|
2005 Oct
|
anonymous
|
|
2005 Oct
|
|
1
|
5
|
Borland command line compiler v 5.5 and SQLite
|
edit |
1463 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
1
|
can't see views in browser 1.0
|
edit |
1459 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
Division operation
|
edit |
1452 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
2
|
segmentation fault on OS X tiger
|
edit |
1448 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
4
|
Parse Error In sqlite.c While Compiling PHP-5.0.5
|
edit |
1446 |
todo
|
closed
|
2005 Sep
|
|
|
2005 Sep
|
|
4
|
4
|
Milestones are not tagged in CVS
|
edit |
1443 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
drh
|
3
|
3
|
pragma full_column_names and short_column_names seems not working.
|
edit |
1438 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
4
|
4
|
UPDATE bug
|
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 |
1434 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
.dump dumps sqlite_stat1, which makes it impossible to load dump
|
edit |
1430 |
event
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
3
|
3
|
pragma index_list(table) doesn' twork correct with integer PKs
|
edit |
1422 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
incorrect error codes from sqlite3_errCode
|
edit |
1416 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
xdong
|
1
|
1
|
database is same size as before when we do clearing operation.
|
edit |
1309 |
build
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
make problem
|
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 |
1406 |
code
|
closed
|
2005 Sep
|
anonymous
|
|
2005 Sep
|
|
1
|
1
|
no result with order by
|
edit |
1377 |
warn
|
closed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
dwong
|
1
|
1
|
can't connect to database
|
edit |
1364 |
code
|
closed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
3
|
3
|
variable Timeout does not exist anymore in main.c
|
edit |
1317 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Aug
|
|
3
|
3
|
Aggregate aliases result in assert() failure
|
edit |
1324 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Aug
|
anonymous
|
3
|
3
|
main.c (line 301): 'Timeout' meant to be ptr->busyTimeout ?
|
edit |
1307 |
new
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Aug
|
|
1
|
1
|
BLOBs and Tcl library (again)
|
edit |
1322 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Aug
|
|
4
|
4
|
after "select * from sqlite_master;" ".databases" command doesnt work
|
edit |
1335 |
new
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Aug
|
|
5
|
3
|
AllowNull
|
edit |
1360 |
code
|
closed
|
2005 Aug
|
anonymous
|
|
2005 Aug
|
|
4
|
4
|
Unsafe casting in table.c
|
edit |
1350 |
code
|
closed
|
2005 Aug
|
|
|
2005 Aug
|
|
3
|
3
|
sqlite gives errors with valgrind
|
edit |
1310 |
event
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Aug
|
|
2
|
4
|
Problem after create a new table
|
edit |
1343 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
1
|
1
|
segmentation fault on select on view
|
edit |
1339 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
1
|
1
|
Table Create in exists db with exists table = MemoryLeak
|
edit |
1336 |
code
|
closed
|
2005 Jul
|
anonymous
|
|
2005 Jul
|
|
2
|
3
|
cannot find the symbol Timeout
|
edit |
1269 |
code
|
closed
|
2005 May
|
anonymous
|
|
2005 Jul
|
|
1
|
1
|
Bus Error during import
|
edit |
1299 |
new
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
3
|
3
|
need NOT EXISTS
|
edit |
1288 |
code
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
1
|
1
|
Win32 Resource leak - InitializeCriticalSection(...)
|
edit |
1280 |
new
|
closed
|
2005 Jun
|
anonymous
|
|
2005 Jun
|
|
5
|
4
|
Make tests can be run as root
|
edit |
1245 |
code
|
closed
|
2005 May
|
anonymous
|
|
2005 Jun
|
|
3
|
1
|
Query causes 'unable to open database' after ~1000 operations
|
edit |
1267 |
code
|
closed
|
2005 May
|
anonymous
|
|
2005 May
|
|
5
|
4
|
exists and case don't work together on an empty table
|
edit |
1237 |
code
|
closed
|
2005 May
|
anonymous
|
|
2005 May
|
anonymous
|
1
|
1
|
I like to use SQLite in php
|
edit |
1226 |
code
|
closed
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
2
|
3
|
Problem when several processes attempt inserts within on the same base
|
edit |
1215 |
code
|
closed
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
1
|
1
|
PRAGMA table_info and INTEGER UNSIGNED - sqlite3 client
|
edit |
1207 |
code
|
closed
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
anonymous
|
2
|
1
|
How to Install SQLite
|
edit |
1197 |
code
|
closed
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
1
|
1
|
race condition in sqlite3_close
|
edit |
1196 |
build
|
closed
|
2005 Apr
|
anonymous
|
|
2005 Apr
|
|
1
|
1
|
out-of memory on powerpc on linux
|
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 |
1185 |
code
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
1
|
3
|
Race condition causing crash in busily-threaded application
|
edit |
1182 |
code
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
danielk1977
|
2
|
3
|
ALTER TABLE...ADD COLUMN fails if table has user-defined collation
|
edit |
1181 |
code
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
2
|
3
|
Field types problem with INSERT
|
edit |
1180 |
code
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
2
|
3
|
Field types problem with .import
|
edit |
1015 |
doc
|
closed
|
2004 Nov
|
a.rottmann
|
|
2005 Mar
|
|
5
|
4
|
Manpage fixes for SQLite3
|
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 |
1157 |
new
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
drh
|
1
|
1
|
Is there a roadmap?
|
edit |
1155 |
doc
|
closed
|
2005 Mar
|
anonymous
|
|
2005 Mar
|
|
1
|
1
|
how i can get a month from a date with a SELECT
|
edit |
1143 |
code
|
closed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
2
|
2
|
prepare/step give incorrect results, compared to the sqlite3 tool
|
edit |
1130 |
doc
|
closed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
4
|
4
|
documentation for PRAGMA short-column-names incorrect
|
edit |
1118 |
build
|
closed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
1
|
1
|
pa
|
edit |
1106 |
code
|
closed
|
2005 Feb
|
anonymous
|
|
2005 Feb
|
|
2
|
1
|
sqlite3FinishCoding is masking errors during parsing
|
edit |
1105 |
code
|
closed
|
2005 Feb
|
|
|
2005 Feb
|
|
1
|
3
|
SQLite Crashes when do a Correlated subqueries
|
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 |
1091 |
code
|
closed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
not the function of ".export TABLE FILE"
|
edit |
1088 |
code
|
closed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
2
|
3
|
Allow Collations to work in Views
|
edit |
1086 |
code
|
closed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
|
2
|
3
|
sqlite crashes while executing query
|
edit |
747 |
code
|
closed
|
2004 May
|
anonymous
|
|
2005 Jan
|
|
3
|
3
|
database not closed if un-finalized VMs exist
|
edit |
840 |
code
|
closed
|
2004 Aug
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
Query returns invalid results (Index problem?).
|
edit |
999 |
build
|
closed
|
2004 Nov
|
anonymous
|
|
2005 Jan
|
|
5
|
4
|
CVS conflict files left in the source
|
edit |
466 |
todo
|
closed
|
2003 Sep
|
anonymous
|
|
2005 Jan
|
|
4
|
4
|
index internationalisation
|
edit |
449 |
new
|
closed
|
2003 Sep
|
anonymous
|
|
2005 Jan
|
|
3
|
4
|
Date and time functions for SELECTs
|
edit |
87 |
new
|
closed
|
2002 Jun
|
anonymous
|
|
2005 Jan
|
|
1
|
4
|
ORDER BY & ISO 8859-2
|
edit |
776 |
code
|
closed
|
2004 Jun
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
sqlite says Database is locked when database file is on Novel disk
|
edit |
981 |
code
|
closed
|
2004 Nov
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
UTF8 characters in database directory or filename not supported
|
edit |
695 |
code
|
closed
|
2004 Apr
|
anonymous
|
|
2005 Jan
|
|
3
|
3
|
CREATE INDEX and dbl-quoted index names
|
edit |
1060 |
code
|
closed
|
2005 Jan
|
anonymous
|
|
2005 Jan
|
anonymous
|
1
|
2
|
result of calcul
|
edit |
990 |
code
|
closed
|
2004 Nov
|
anonymous
|
|
2005 Jan
|
|
1
|
1
|
PRAGMA empty_result_callbacks in tclsqlite-3.0.8.so eliminated?
|
edit |
598 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2005 Jan
|
|
1
|
4
|
Joins not supported in DELETE
|
edit |
264 |
code
|
closed
|
2003 Mar
|
anonymous
|
|
2005 Jan
|
|
5
|
4
|
Result of lseek for UNIX version of sqliteOsSeek() is not checked
|
edit |
1050 |
doc
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
4
|
4
|
Correct front page information - SQLite is not ACID
|
edit |
1045 |
event
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
1
|
5
|
MAJOR Problem with accessing databases
|
edit |
1044 |
code
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
3
|
3
|
Insert an integer as a string
|
edit |
1038 |
code
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
2
|
2
|
multi-word type names confuse pragma table_info
|
edit |
1027 |
code
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
1
|
3
|
Deletion of records that don't meet the condition set
|
edit |
1024 |
code
|
closed
|
2004 Dec
|
anonymous
|
|
2004 Dec
|
|
1
|
1
|
trunk blob data
|
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 |
1021 |
code
|
closed
|
2004 Nov
|
anonymous
|
|
2004 Dec
|
|
1
|
3
|
LIKE operator % wildcarding broken
|
edit |
1016 |
code
|
closed
|
2004 Nov
|
anonymous
|
|
2004 Nov
|
|
3
|
3
|
UPDATE command with invalid SQL Syntax executes
|
edit |
993 |
new
|
closed
|
2004 Nov
|
anonymous
|
|
2004 Nov
|
|
3
|
4
|
Plug-in codec support.
|
edit |
997 |
code
|
closed
|
2004 Nov
|
anonymous
|
|
2004 Nov
|
|
2
|
4
|
Returned column names include table name or alias.
|
edit |
37 |
code
|
closed
|
2002 May
|
anonymous
|
|
2004 Nov
|
|
3
|
3
|
can't open dbfile by apache process under mod_perl env.
|
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 |
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 |
976 |
code
|
closed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
|
1
|
1
|
Locale & upper/lower
|
edit |
961 |
new
|
closed
|
2004 Oct
|
anonymous
|
|
2004 Oct
|
anonymous
|
5
|
5
|
a varchar value can be longer than its definition
|
edit |
957 |
new
|
closed
|
2004 Oct
|
ghaering
|
|
2004 Oct
|
|
1
|
1
|
Old callback-based API should still return column types
|
edit |
915 |
code
|
closed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
3
|
2
|
problem #901, but on read-only databases
|
edit |
921 |
code
|
closed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
5
|
5
|
2nd time: SQL does not support non-ASCII IO?
|
edit |
893 |
new
|
closed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
1
|
3
|
No string searches INSTR, LOCATE
|
edit |
792 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Sep
|
|
1
|
1
|
ODBC support is broken for 3.0.2
|
edit |
796 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Sep
|
|
1
|
2
|
sqlite3_open16 Unworkable
|
edit |
801 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Sep
|
|
1
|
3
|
Multiple problems with v3.0.2
|
edit |
880 |
code
|
closed
|
2004 Sep
|
anonymous
|
|
2004 Sep
|
|
1
|
1
|
dropping a temporary table locks the database
|
edit |
879 |
new
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
5
|
3
|
Makefile should produce GCC compatible import library for DLL as well
|
edit |
733 |
code
|
closed
|
2004 May
|
anonymous
|
|
2004 Aug
|
anonymous
|
3
|
3
|
About Ticket #731
|
edit |
868 |
doc
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
1
|
1
|
Conflict resolution fails when attempting to create duplicate key
|
edit |
866 |
code
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
2
|
3
|
Breakage when repeatedly creating tables in an attached database
|
edit |
856 |
code
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
1
|
1
|
memory leak within sqlite3_open()/sqlite3_close() pair
|
edit |
850 |
code
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
1
|
1
|
quoted table names not allowed in combination with *
|
edit |
836 |
code
|
closed
|
2004 Aug
|
anonymous
|
|
2004 Aug
|
|
1
|
1
|
sqlite3_prepare() fails when a temp table does not yet exists.
|
edit |
830 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
1
|
1
|
sqlite3_get_table() error
|
edit |
825 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
3
|
3
|
lower(X) / upper(X) - not work correctly on non Latin characters
|
edit |
817 |
new
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
4
|
2
|
Return size of blob
|
edit |
702 |
code
|
closed
|
2004 Apr
|
anonymous
|
|
2004 Jul
|
|
3
|
3
|
Bug in sorting: some strings sort in the middle of numerical values
|
edit |
809 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
2
|
1
|
Sqlite also fetches the hooks
|
edit |
790 |
code
|
closed
|
2004 Jul
|
anonymous
|
|
2004 Jul
|
|
1
|
1
|
Missing include file for the SQLITE distribution 3.0.x
|
edit |
779 |
code
|
closed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
4
|
1
|
duplicated declaration of sqlite3_changes() in sqlite.h.in
|
edit |
769 |
code
|
closed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
2
|
2
|
macro SQLITE_OMIT_AUTHORIZATION is not honored
|
edit |
767 |
new
|
closed
|
2004 Jun
|
anonymous
|
|
2004 Jun
|
|
1
|
1
|
Metadata of query
|
edit |
764 |
code
|
closed
|
2004 Jun
|
drh
|
|
2004 Jun
|
drh
|
1
|
1
|
ROLLBACK disables TEMP triggers.
|
edit |
731 |
code
|
closed
|
2004 May
|
anonymous
|
|
2004 May
|
|
2
|
3
|
UNIQUE constraint not working when one of the fields is null
|
edit |
730 |
new
|
closed
|
2004 May
|
anonymous
|
|
2004 May
|
|
4
|
3
|
Differentiate context-sensetive user actions and navigation in UI
|
edit |
719 |
code
|
closed
|
2004 May
|
anonymous
|
|
2004 May
|
|
2
|
3
|
index_list not reporting my indeces
|
edit |
704 |
event
|
closed
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
|
5
|
5
|
.database && .databases
|
edit |
701 |
todo
|
closed
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
drh
|
3
|
3
|
INSERT FAILED?
|
edit |
693 |
build
|
closed
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
|
1
|
1
|
Compiling for freeBSD
|
edit |
688 |
code
|
closed
|
2004 Apr
|
anonymous
|
|
2004 Apr
|
|
1
|
1
|
Scope problem in subselect
|
edit |
677 |
code
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
2
|
3
|
Failure to convert to FP on division involving a constant
|
edit |
675 |
code
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
2
|
1
|
Malformed error at GET BLOB DATA from database file
|
edit |
674 |
code
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
3
|
4
|
insert record fails mpatrol tests
|
edit |
669 |
new
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
named-field?
|
edit |
664 |
new
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
In-Memory convert to disk database file?
|
edit |
663 |
new
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
drh
|
5
|
5
|
SELECT TOP n?
|
edit |
661 |
new
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
In-Memory feature?
|
edit |
635 |
new
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Mar
|
|
5
|
5
|
ROWID as ref. number
|
edit |
639 |
event
|
closed
|
2004 Mar
|
anonymous
|
|
2004 Mar
|
|
1
|
1
|
Why fixed tickets are not closed ?
|
edit |
632 |
doc
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
2
|
2
|
fix links on wrappers page
|
edit |
578 |
code
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Feb
|
|
4
|
2
|
calling isdigit in sqliteIsNumber cause asserts (VC.NET)
|
edit |
607 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
odbc doesn't like field name date
|
edit |
606 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
odbc doesn't like datetime type - returns a null
|
edit |
600 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
unable to open database file, win32, Java jdbc
|
edit |
630 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
using uninitialized variable
|
edit |
625 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
CORE DUMPED when running sum() in DBD::SQLite
|
edit |
624 |
new
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
SQLite transaction...
|
edit |
619 |
code
|
closed
|
2004 Feb
|
anonymous
|
|
2004 Feb
|
|
1
|
1
|
Multiple BEGIN and COMMIT transaction problem...
|
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 |
586 |
code
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
2
|
1
|
Memory allocation problem ?
|
edit |
585 |
code
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
1
|
1
|
sqlite is not thread safe
|
edit |
584 |
new
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
anonymous
|
5
|
1
|
Cursor support in SQLite
|
edit |
570 |
event
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
5
|
5
|
database created on x86 can't work on arm
|
edit |
579 |
code
|
closed
|
2004 Jan
|
anonymous
|
|
2004 Jan
|
|
3
|
1
|
condition where sqlite_decode_binary will return -1
|
edit |
543 |
new
|
closed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
5
|
4
|
Feature Request: Indicate NOT NULL columns in table_info.
|
edit |
440 |
code
|
closed
|
2003 Sep
|
anonymous
|
|
2003 Dec
|
drh
|
3
|
3
|
dayofmonth("now") returns one more than actual day
|
edit |
531 |
code
|
closed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
4
|
4
|
INT is not treated the same as INTEGER
|
edit |
464 |
code
|
closed
|
2003 Sep
|
anonymous
|
|
2003 Dec
|
|
2
|
2
|
VACUUM doesn't compile with sqlite_compile
|
edit |
513 |
code
|
closed
|
2003 Dec
|
anonymous
|
|
2003 Dec
|
|
2
|
3
|
C++-style comments prevent compilation
|
edit |
506 |
code
|
closed
|
2003 Nov
|
anonymous
|
|
2003 Nov
|
|
2
|
1
|
Result tuple not formed correctly on select query
|
edit |
371 |
event
|
closed
|
2003 Jul
|
anonymous
|
|
2003 Nov
|
|
1
|
1
|
crash in conflict.test
|
edit |
476 |
doc
|
closed
|
2003 Oct
|
anonymous
|
|
2003 Nov
|
|
3
|
3
|
Define for omitting time and date functions
|
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 |
475 |
code
|
closed
|
2003 Oct
|
anonymous
|
|
2003 Oct
|
|
1
|
1
|
question:how to use the sqlite in my VC6 project?
|
edit |
455 |
doc
|
closed
|
2003 Sep
|
anonymous
|
|
2003 Sep
|
|
4
|
2
|
undocumented functions: sqlite_mprintf,and sqlite_vmprintf
|
edit |
23 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2003 Aug
|
drh
|
1
|
1
|
FieldName Returned Not Correct When Use Fast-East Chararctor Set
|
edit |
399 |
event
|
closed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
drh
|
3
|
3
|
SELECT COUNT(*) FROM TABLE
|
edit |
379 |
new
|
closed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
|
5
|
1
|
use \' and \" instead of '' and "" only
|
edit |
375 |
new
|
closed
|
2003 Jul
|
anonymous
|
|
2003 Jul
|
anonymous
|
4
|
4
|
I'm missing DB metadata.
|
edit |
119 |
doc
|
closed
|
2002 Jul
|
anonymous
|
|
2003 Jul
|
|
5
|
5
|
How to Compile Sqlite.dll With VC++
|
edit |
359 |
code
|
closed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
1
|
1
|
sum() returns incorrect value
|
edit |
320 |
doc
|
closed
|
2003 May
|
anonymous
|
|
2003 Jun
|
jplyon
|
5
|
3
|
PRAGMA documentation should include numeric values of settings
|
edit |
344 |
event
|
closed
|
2003 Jun
|
anonymous
|
|
2003 Jun
|
|
1
|
1
|
select
|
edit |
85 |
todo
|
closed
|
2002 Jun
|
drh
|
|
2003 Apr
|
|
1
|
1
|
Document and test the sqlite_open_aux_file() API.
|
edit |
260 |
doc
|
closed
|
2003 Mar
|
anonymous
|
|
2003 Mar
|
|
5
|
4
|
may i add a contributed by <mailadress> to the wiki HowToCompile ?
|
edit |
251 |
code
|
closed
|
2003 Feb
|
anonymous
|
|
2003 Mar
|
|
1
|
1
|
ORDER BY doesn't work on TIMESTAMP column type
|
edit |
188 |
todo
|
closed
|
2002 Nov
|
drh
|
|
2002 Nov
|
|
1
|
1
|
Serialize disk I/O
|
edit |
183 |
code
|
closed
|
2002 Oct
|
anonymous
|
|
2002 Nov
|
drh
|
1
|
1
|
Bug regarding grouping, left joining, aggregate functions
|
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 |
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 |
108 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
1
|
1
|
Sqlite's Windows Dll Version Still Is 2.56
|
edit |
107 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
1
|
1
|
Incorrect query results
|
edit |
104 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
1
|
2
|
error in trigger on view after closing and reopening database
|
edit |
102 |
code
|
closed
|
2002 Jul
|
drh
|
|
2002 Sep
|
|
1
|
1
|
ORDER BY ignored in subquery
|
edit |
100 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
1
|
2
|
view not properly restored after closing and reopening database
|
edit |
99 |
todo
|
closed
|
2002 Jul
|
drh
|
|
2002 Sep
|
|
1
|
1
|
Document and export the sqlite_mprintf() API.
|
edit |
92 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
2
|
2
|
max() looks boggus in a view
|
edit |
91 |
todo
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
4
|
3
|
A command-line program for windows
|
edit |
90 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Sep
|
|
1
|
1
|
table aliases in select commands stopped working
|
edit |
88 |
doc
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
4
|
4
|
Typo on web page
|
edit |
84 |
code
|
closed
|
2002 Jun
|
drh
|
|
2002 Sep
|
|
1
|
1
|
Complex left outer joins might give the wrong answer
|
edit |
83 |
todo
|
closed
|
2002 Jun
|
drh
|
|
2002 Sep
|
drh
|
1
|
1
|
Add test cases
|
edit |
80 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
2
|
2
|
Heap corruption on select with ORDER BY, LIMIT, and OFFSET
|
edit |
79 |
code
|
closed
|
2002 Jun
|
drh
|
|
2002 Sep
|
|
1
|
1
|
Tables are not being dropped correctly under certain circumstances.
|
edit |
77 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
2
|
2
|
more than one LIMIT on nested select shows 0 rows
|
edit |
76 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
1
|
3
|
sqlite corruption possibly relating to drop of index
|
edit |
72 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
1
|
1
|
malloc test in testbed fails Win32 build of 2.4.12
|
edit |
71 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
drh
|
2
|
4
|
"COPY table FROM file" expects lines to end with LF.
|
edit |
70 |
doc
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
5
|
5
|
Error in online documentation for DROP VIEW
|
edit |
66 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
drh
|
1
|
2
|
LIMIT clause ignored in subselects
|
edit |
65 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
2
|
2
|
Error in .dump'ed INSERT statements
|
edit |
59 |
doc
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
3
|
4
|
Undocumented Concatenation Operator
|
edit |
54 |
todo
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Sep
|
|
2
|
2
|
win32 binaries are missing symbols
|
edit |
53 |
new
|
closed
|
2002 May
|
anonymous
|
|
2002 Sep
|
|
5
|
4
|
Single checkpoint file enhancement
|
edit |
52 |
new
|
closed
|
2002 May
|
anonymous
|
|
2002 Sep
|
|
5
|
4
|
Backslash check on temporary file names under Win32
|
edit |
50 |
code
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
3
|
2
|
Memory leak in triggers on TEMP tables
|
edit |
47 |
code
|
closed
|
2002 May
|
anonymous
|
|
2002 Sep
|
|
5
|
4
|
Compiler Warning using MingW/gcc
|
edit |
45 |
code
|
closed
|
2002 May
|
anonymous
|
|
2002 Sep
|
|
4
|
4
|
Unique constraint problem on updating PRIMARY KEY column
|
edit |
44 |
code
|
closed
|
2002 May
|
anonymous
|
|
2002 Sep
|
|
3
|
3
|
UNIQUE constraint (incorrectly) applies to NULL
|
edit |
42 |
doc
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
1
|
1
|
Add comments to Trigger structures in sqliteInt.h
|
edit |
41 |
code
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
1
|
2
|
sqlite_complete() failure
|
edit |
40 |
code
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
3
|
3
|
Compiler warnings on RedHat 7.2
|
edit |
39 |
todo
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
5
|
1
|
Reformat the TRIGGER code for consistent style.
|
edit |
32 |
code
|
closed
|
2002 May
|
drh
|
|
2002 Sep
|
|
1
|
1
|
Columns in views are not always named correctly.
|
edit |
28 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Sep
|
drh
|
3
|
1
|
sqlite_changes not exported in sqlite.def in SQLite_source.zip
|
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 |
22 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Sep
|
drh
|
2
|
1
|
compound selects as expressions
|
edit |
17 |
new
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Sep
|
drh
|
5
|
5
|
Enhancement of %q in sqlite...printf API
|
edit |
113 |
doc
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Aug
|
|
5
|
5
|
Incorrect description of SQLite
|
edit |
125 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
2
|
1
|
Data and Category SELECT bug
|
edit |
121 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
Bug LEFT JOIN - GROUP BY
|
edit |
120 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
Strange comparison logic
|
edit |
123 |
new
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
3
|
3
|
Would like Query type info
|
edit |
122 |
new
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
3
|
3
|
BLOB support needs only an escape_string() function.
|
edit |
118 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
Under WinNT4.04 Call Opendatabase or Else Function Generate Error
|
edit |
117 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
run err with Hint Call msvcrt.dll.
|
edit |
116 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
run err with Hint Call msvcrt.dll.
|
edit |
109 |
new
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
5
|
4
|
Can the build process include a way to make a static library?
|
edit |
106 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
1
|
1
|
Bad handling of nulls
|
edit |
103 |
code
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
2
|
1
|
Memory Leak in the Server
|
edit |
101 |
new
|
closed
|
2002 Jul
|
anonymous
|
|
2002 Jul
|
|
3
|
3
|
builtin functions do not work properly with LIMIT clause
|
edit |
69 |
new
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
5
|
4
|
Sequences (some sort of auto-incremental fields...)
|
edit |
60 |
new
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
3
|
4
|
UPDATE Statement with FROM Clause FAILS
|
edit |
57 |
code
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
4
|
4
|
UPDATE Command Fails When Table Name is Part of SET Statement
|
edit |
61 |
new
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
1
|
1
|
Enhancement Request: Capability to Specify Table Join Type
|
edit |
58 |
new
|
closed
|
2002 Jun
|
anonymous
|
|
2002 Jun
|
|
4
|
4
|
Table JOIN Syntax Not Recognized
|
edit |
36 |
code
|
closed
|
2002 May
|
anonymous
|
|
2002 May
|
|
4
|
3
|
drop table doesn't clean up database
|
edit |
5 |
code
|
closed
|
2002 Mar
|
anonymous
|
|
2002 May
|
|
3
|
4
|
Bug submitter ignores severity/priority
|
edit |
27 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
2
|
2
|
incorrect result when doing select using quotes in where
|
edit |
25 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
1
|
1
|
continu ticket 23, I Direct Access Sqlite.dll
|
edit |
24 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
4
|
3
|
Make "update ... where ..." fail if where clause is false.
|
edit |
20 |
code
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
1
|
1
|
Order By clause not sorting correctly for string columns
|
edit |
18 |
event
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
1
|
1
|
The sqlite server does not run under windows xp
|
edit |
14 |
new
|
closed
|
2002 Apr
|
anonymous
|
|
2002 Apr
|
drh
|
5
|
4
|
decouple the BTREE implementaion from sqlite
|
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 |
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 |
1594 |
code
|
closed
|
2006 Jan
|
anonymous
|
BTree
|
2006 Jan
|
danielk1977
|
2
|
2
|
Schema pointer is freed twice
|
edit |
1421 |
code
|
closed
|
2005 Sep
|
anonymous
|
BTree
|
2005 Sep
|
|
2
|
2
|
Assertion when I try to create a index
|
edit |
1344 |
code
|
closed
|
2005 Jul
|
anonymous
|
BTree
|
2005 Aug
|
anonymous
|
3
|
1
|
sqlite does 40 times allocations for a single sql statement
|
edit |
1329 |
code
|
closed
|
2005 Jul
|
anonymous
|
BTree
|
2005 Jul
|
|
5
|
1
|
A bug About select from a table
|
edit |
1233 |
code
|
closed
|
2005 May
|
anonymous
|
BTree
|
2005 May
|
|
1
|
1
|
Triggers assert
|
edit |
1231 |
code
|
closed
|
2005 May
|
anonymous
|
BTree
|
2005 May
|
|
1
|
1
|
Solaris9: Bus error, alignment issues
|
edit |
1109 |
code
|
closed
|
2005 Feb
|
anonymous
|
BTree
|
2005 Feb
|
|
1
|
1
|
assert in btree
|
edit |
978 |
code
|
closed
|
2004 Oct
|
anonymous
|
BTree
|
2004 Oct
|
anonymous
|
3
|
3
|
bug in sql_step related to INTEGER PRIMARY INDEX values.
|
edit |
889 |
event
|
closed
|
2004 Sep
|
anonymous
|
BTree
|
2004 Sep
|
anonymous
|
1
|
2
|
btree.c with new malloc
|
edit |
863 |
code
|
closed
|
2004 Aug
|
anonymous
|
BTree
|
2004 Sep
|
|
2
|
2
|
Stack overflow in the btree.c module
|
edit |
821 |
code
|
closed
|
2004 Jul
|
anonymous
|
BTree
|
2004 Jul
|
|
3
|
3
|
Allows string data on indexes INTEGER fields
|
edit |
740 |
code
|
closed
|
2004 May
|
anonymous
|
BTree
|
2004 May
|
|
1
|
1
|
Unable to compile on Fedora core 1
|
edit |
436 |
code
|
closed
|
2003 Aug
|
drh
|
BTree
|
2003 Aug
|
drh
|
1
|
1
|
In-memory database backend segfaults on recursive access
|
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 |
196 |
code
|
closed
|
2002 Nov
|
anonymous
|
BTree
|
2003 Jul
|
|
4
|
3
|
there are the same record in a table,why?
|
edit |
9 |
new
|
closed
|
2002 Apr
|
anonymous
|
BTree
|
2002 Sep
|
|
1
|
3
|
platform-independent db files
|
edit |
19 |
new
|
closed
|
2002 Apr
|
danielk1977
|
BTree
|
2002 May
|
|
3
|
4
|
synchronous pragma does not effect TEMP tables
|
edit |
1160 |
code
|
closed
|
2005 Mar
|
anonymous
|
CodeGen
|
2005 Mar
|
|
4
|
4
|
GROUP BY is broken
|
edit |
1064 |
code
|
closed
|
2005 Jan
|
anonymous
|
CodeGen
|
2005 Jan
|
|
2
|
1
|
problems with queries and aggregate functions
|
edit |
287 |
new
|
closed
|
2003 Apr
|
anonymous
|
CodeGen
|
2005 Jan
|
drh
|
3
|
2
|
query execution time depend from tables order in FROM clause
|
edit |
942 |
code
|
closed
|
2004 Oct
|
anonymous
|
CodeGen
|
2004 Oct
|
|
1
|
2
|
Horrible time complexity for certain triple joins.
|
edit |
681 |
build
|
closed
|
2004 Apr
|
anonymous
|
CodeGen
|
2004 Apr
|
|
1
|
1
|
undefined reference to 'sqlite_open'
|
edit |
556 |
warn
|
closed
|
2004 Jan
|
anonymous
|
CodeGen
|
2004 Jan
|
|
3
|
4
|
double to int warnings in date.c
|
edit |
105 |
code
|
closed
|
2002 Jul
|
anonymous
|
CodeGen
|
2002 Sep
|
|
2
|
1
|
Assertion fails on UPDATE of indexed table with subquery in WHERE
|
edit |
95 |
code
|
closed
|
2002 Jul
|
drh
|
CodeGen
|
2002 Sep
|
|
1
|
1
|
DROP INDEX on an automatically created internal index is allowed
|
edit |
78 |
code
|
closed
|
2002 Jun
|
drh
|
CodeGen
|
2002 Sep
|
|
1
|
1
|
Assertion failure when closing database in the middle of a transaction
|
edit |
75 |
code
|
closed
|
2002 Jun
|
drh
|
CodeGen
|
2002 Sep
|
|
1
|
1
|
Auto-increment not working on an INSERT from a SELECT
|
edit |
73 |
code
|
closed
|
2002 Jun
|
drh
|
CodeGen
|
2002 Sep
|
drh
|
1
|
1
|
ORDER BY clause is ignored on subqueries
|
edit |
63 |
new
|
closed
|
2002 Jun
|
drh
|
CodeGen
|
2002 Sep
|
|
3
|
3
|
Add optimizations for "WHERE rowid IN (SELECT...)"
|
edit |
49 |
code
|
closed
|
2002 May
|
drh
|
CodeGen
|
2002 Sep
|
|
2
|
1
|
DELETE Trigger causes extra rows to be deleted
|
edit |
46 |
code
|
closed
|
2002 May
|
drh
|
CodeGen
|
2002 Sep
|
|
3
|
2
|
CREATE TABLE accepts duplicate column names
|
edit |
35 |
code
|
closed
|
2002 May
|
drh
|
CodeGen
|
2002 Sep
|
|
1
|
1
|
An ORDER BY clause on a subquery causes a segfault
|
edit |
34 |
code
|
closed
|
2002 May
|
drh
|
CodeGen
|
2002 Sep
|
|
1
|
1
|
Segfault when a VIEW contains an ORDER BY clause
|
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 |
31 |
code
|
closed
|
2002 Apr
|
danielk1977
|
CodeGen
|
2002 Sep
|
|
4
|
4
|
SELECT without FROM
|
edit |
51 |
doc
|
closed
|
2002 May
|
danielk1977
|
CodeGen
|
2002 May
|
danielk1977
|
5
|
3
|
Triggers problem with INTEGER PRIMARY KEY
|
edit |
16 |
code
|
closed
|
2002 Apr
|
anonymous
|
CodeGen
|
2002 May
|
|
2
|
2
|
sqlite cores
|
edit |
15 |
code
|
closed
|
2002 Apr
|
anonymous
|
CodeGen
|
2002 May
|
|
5
|
4
|
getting the number of affected lines is harder than necessary
|
edit |
11 |
code
|
closed
|
2002 Apr
|
drh
|
CodeGen
|
2002 May
|
|
1
|
1
|
Wrong number of inserts reported after an IGNORE
|
edit |
8 |
code
|
closed
|
2002 Apr
|
danielk1977
|
CodeGen
|
2002 May
|
|
2
|
1
|
More problems with where.c
|
edit |
6 |
code
|
closed
|
2002 Apr
|
danielk1977
|
CodeGen
|
2002 May
|
|
1
|
1
|
Query optimizer does not consider function arguments
|
edit |
2 |
new
|
closed
|
2002 Mar
|
drh
|
CodeGen
|
2002 May
|
|
2
|
3
|
Add support for TABLE.* in a query
|
edit |
1686 |
code
|
closed
|
2006 Feb
|
anonymous
|
Pager
|
2006 Feb
|
|
2
|
4
|
File locking and concurrency problems under Windows
|
edit |
1352 |
code
|
closed
|
2005 Aug
|
anonymous
|
Pager
|
2005 Aug
|
|
3
|
3
|
Databases created via ATTACH do not respect page_size pragma
|
edit |
1276 |
code
|
closed
|
2005 Jun
|
anonymous
|
Pager
|
2005 Jun
|
|
1
|
1
|
Failing assertion in pager.c
|
edit |
1265 |
new
|
closed
|
2005 May
|
anonymous
|
Pager
|
2005 May
|
|
3
|
3
|
10% speed improvement for huge inserts
|
edit |
964 |
code
|
closed
|
2004 Oct
|
anonymous
|
Pager
|
2004 Oct
|
|
3
|
1
|
Possible segfault from bad call
|
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 |
628 |
code
|
closed
|
2004 Feb
|
anonymous
|
Pager
|
2004 Feb
|
|
1
|
3
|
Assertion failure in syncJournal
|
edit |
553 |
code
|
closed
|
2004 Jan
|
anonymous
|
Pager
|
2004 Jan
|
|
2
|
2
|
conversion error in compiling pager.c
|
edit |
546 |
code
|
closed
|
2004 Jan
|
anonymous
|
Pager
|
2004 Jan
|
|
3
|
3
|
(Program received signal SIGSEGV) when sqlite_open()
|
edit |
536 |
code
|
closed
|
2003 Dec
|
anonymous
|
Pager
|
2003 Dec
|
|
1
|
1
|
Syscall param write(buf) contains unaddressable byte(s)
|
edit |
374 |
code
|
closed
|
2003 Jul
|
anonymous
|
Pager
|
2003 Jul
|
|
1
|
1
|
btree crash in moveto - sqlitepager_get
|
edit |
94 |
code
|
closed
|
2002 Jul
|
drh
|
Pager
|
2002 Sep
|
|
1
|
1
|
ROLLBACK fails to restore all pages
|
edit |
1973 |
code
|
closed
|
2006 Sep
|
anonymous
|
Parser
|
2006 Nov
|
|
1
|
2
|
sqlite3_prepare (DLL 3.3.7) exception in two programs
|
edit |
1988 |
code
|
closed
|
2006 Sep
|
anonymous
|
Parser
|
2006 Sep
|
|
2
|
2
|
linker error wih SQLITE_OMIT_VIRTUALTABLE
|
edit |
1952 |
code
|
closed
|
2006 Sep
|
anonymous
|
Parser
|
2006 Sep
|
|
2
|
2
|
Memory leak in select with duplicate colum names
|
edit |
1922 |
code
|
closed
|
2006 Aug
|
anonymous
|
Parser
|
2006 Aug
|
|
1
|
1
|
field name with space can not be specified as primary key
|
edit |
1881 |
code
|
closed
|
2006 Jul
|
anonymous
|
Parser
|
2006 Jul
|
anonymous
|
2
|
1
|
error in inserting strings with single quotes
|
edit |
1826 |
code
|
closed
|
2006 May
|
anonymous
|
Parser
|
2006 May
|
anonymous
|
4
|
4
|
Select unused table in from clause produces no results
|
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 |
1557 |
event
|
closed
|
2005 Dec
|
anonymous
|
Parser
|
2006 Mar
|
|
1
|
1
|
sqlite core dumps in exprNodeIsConstant
|
edit |
1694 |
code
|
closed
|
2006 Feb
|
anonymous
|
Parser
|
2006 Feb
|
|
3
|
3
|
SELECT count(distinct vnum) FROM table generates syntax error.
|
edit |
1530 |
code
|
closed
|
2005 Nov
|
anonymous
|
Parser
|
2005 Nov
|
xdong
|
2
|
1
|
error on where clause with serial-type.
|
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 |
1408 |
code
|
closed
|
2005 Sep
|
anonymous
|
Parser
|
2005 Sep
|
|
1
|
1
|
ATTACH DATABASE doesn't support *.db files
|
edit |
1341 |
code
|
closed
|
2005 Jul
|
anonymous
|
Parser
|
2005 Aug
|
|
3
|
2
|
sqlite_exec() returns always 1 on error
|
edit |
1141 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Apr
|
|
4
|
1
|
Select rowid for integer primary key does not return rowid
|
edit |
1147 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Apr
|
|
1
|
1
|
column names do not respect pragma settings
|
edit |
1174 |
build
|
closed
|
2005 Mar
|
anonymous
|
Parser
|
2005 Mar
|
|
4
|
4
|
Link problem using SQLITE_OMIT_xxx
|
edit |
1125 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Mar
|
|
1
|
2
|
Syntax error: create index with table name qualified by database name
|
edit |
1150 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Feb
|
|
4
|
4
|
'insert' is not a legal transaction name
|
edit |
1119 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Feb
|
|
4
|
3
|
Field name interpreted as SQL command. (GROUP)
|
edit |
1110 |
code
|
closed
|
2005 Feb
|
anonymous
|
Parser
|
2005 Feb
|
|
4
|
4
|
Detection of invalid create table statement
|
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 |
1087 |
event
|
closed
|
2005 Jan
|
anonymous
|
Parser
|
2005 Jan
|
|
5
|
1
|
CREATE TRIGGER with SQLite3 --> Error "near "WHEN" : syntaxe error
|
edit |
443 |
new
|
closed
|
2003 Sep
|
anonymous
|
Parser
|
2005 Jan
|
anonymous
|
3
|
3
|
LIKE ... should support ESCAPE as per SQL spec
|
edit |
970 |
code
|
closed
|
2004 Oct
|
anonymous
|
Parser
|
2005 Jan
|
|
2
|
3
|
Crush in authorization procedure
|
edit |
1006 |
new
|
closed
|
2004 Nov
|
anonymous
|
Parser
|
2004 Nov
|
|
4
|
3
|
Creation of sqlite3_exec16 ?
|
edit |
820 |
code
|
closed
|
2004 Jul
|
anonymous
|
Parser
|
2004 Oct
|
|
4
|
4
|
problem with sqlite3_prepare and variables
|
edit |
929 |
code
|
closed
|
2004 Sep
|
anonymous
|
Parser
|
2004 Sep
|
|
2
|
1
|
Inserting duplicate primary key value returns success
|
edit |
849 |
code
|
closed
|
2004 Aug
|
anonymous
|
Parser
|
2004 Sep
|
|
1
|
1
|
error(1) for Statement "PRAGMA table_info(?)"
|
edit |
884 |
new
|
closed
|
2004 Sep
|
anonymous
|
Parser
|
2004 Sep
|
|
5
|
1
|
Allow read only transactions.
|
edit |
882 |
code
|
closed
|
2004 Sep
|
anonymous
|
Parser
|
2004 Sep
|
|
1
|
1
|
crash on insert
|
edit |
874 |
code
|
closed
|
2004 Aug
|
anonymous
|
Parser
|
2004 Aug
|
|
2
|
3
|
Inconsistent treatment of quoted strings: "x" vs 'x'
|
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 |
650 |
new
|
closed
|
2004 Mar
|
anonymous
|
Parser
|
2004 Mar
|
|
4
|
4
|
DISTINCT aggregates
|
edit |
629 |
code
|
closed
|
2004 Feb
|
anonymous
|
Parser
|
2004 Feb
|
|
3
|
3
|
Variable used without having been initialized
|
edit |
581 |
code
|
closed
|
2004 Jan
|
anonymous
|
Parser
|
2004 Jan
|
|
3
|
1
|
Failure for lemon.c to compile on MacOSX (fixed as well ;-))
|
edit |
532 |
code
|
closed
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
|
2
|
3
|
crashes on gigantic query
|
edit |
441 |
code
|
closed
|
2003 Sep
|
anonymous
|
Parser
|
2003 Dec
|
drh
|
1
|
1
|
Cannot find table under Managed C++
|
edit |
516 |
code
|
closed
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
|
1
|
1
|
unrecognized token error when a string contains a \' escape sequence
|
edit |
512 |
code
|
closed
|
2003 Dec
|
anonymous
|
Parser
|
2003 Dec
|
|
2
|
2
|
order by clause is not ordering data properly in aggregate functions
|
edit |
471 |
code
|
closed
|
2003 Oct
|
anonymous
|
Parser
|
2003 Oct
|
|
5
|
1
|
Parser accepts faulty SQL
|
edit |
343 |
new
|
closed
|
2003 Jun
|
anonymous
|
Parser
|
2003 Jun
|
|
3
|
1
|
insert single quote value in SQL statement
|
edit |
325 |
code
|
closed
|
2003 May
|
anonymous
|
Parser
|
2003 May
|
|
3
|
3
|
Memory Leak with a cancelled sqlite_exec() using a callback routine
|
edit |
283 |
code
|
closed
|
2003 Apr
|
anonymous
|
Parser
|
2003 Apr
|
|
3
|
1
|
Defect in sqlite_exec_vprintf
|
edit |
265 |
new
|
closed
|
2003 Mar
|
anonymous
|
Parser
|
2003 Mar
|
drh
|
2
|
3
|
SQLITE does not like prefixed columns
|
edit |
89 |
new
|
closed
|
2002 Jun
|
chw
|
Parser
|
2002 Sep
|
|
1
|
4
|
table aliases broken
|
edit |
3 |
code
|
closed
|
2002 Mar
|
anonymous
|
Parser
|
2002 May
|
|
1
|
1
|
Rejects "view" as column name
|
edit |
1545 |
build
|
closed
|
2005 Nov
|
anonymous
|
Shell
|
2007 Feb
|
|
4
|
4
|
Solaris systems require -lrt to link sqlite3
|
edit |
1891 |
code
|
closed
|
2006 Jul
|
anonymous
|
Shell
|
2006 Jul
|
pweilbacher
|
4
|
4
|
OS/2 may not have access to C:\ drive
|
edit |
1868 |
code
|
closed
|
2006 Jun
|
anonymous
|
Shell
|
2006 Jun
|
|
4
|
4
|
where a = b = c
|
edit |
1724 |
code
|
closed
|
2006 Mar
|
anonymous
|
Shell
|
2006 Mar
|
anonymous
|
1
|
1
|
sqlite doesn't work with "cifs-mounted-directories"
|
edit |
1673 |
code
|
closed
|
2006 Feb
|
anonymous
|
Shell
|
2006 Feb
|
|
3
|
3
|
constraint using "in" -- bug 1645 revisited
|
edit |
1668 |
event
|
closed
|
2006 Feb
|
anonymous
|
Shell
|
2006 Feb
|
drh
|
2
|
3
|
datetime modifiers "enf of *" and "group * by" do not work
|
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 |
1582 |
code
|
closed
|
2006 Jan
|
anonymous
|
Shell
|
2006 Jan
|
anonymous
|
1
|
1
|
the sqlite328.exe generates Application error -memory cold not be read
|
edit |
1579 |
code
|
closed
|
2006 Jan
|
anonymous
|
Shell
|
2006 Jan
|
anonymous
|
1
|
1
|
database locked
|
edit |
1574 |
event
|
closed
|
2005 Dec
|
anonymous
|
Shell
|
2005 Dec
|
|
1
|
3
|
corrupt database due to .dump process
|
edit |
1523 |
code
|
closed
|
2005 Nov
|
anonymous
|
Shell
|
2005 Nov
|
danielk1977
|
5
|
1
|
size of database dose not change smaller after delete records
|
edit |
1450 |
code
|
closed
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
|
1
|
1
|
Unable to compile on SCO Openserver(gcc)
|
edit |
1411 |
code
|
closed
|
2005 Sep
|
anonymous
|
Shell
|
2005 Sep
|
anonymous
|
3
|
1
|
how to change database name
|
edit |
589 |
new
|
closed
|
2004 Jan
|
anonymous
|
Shell
|
2005 Sep
|
|
5
|
4
|
HTML tags in shell.c should be lower case
|
edit |
1369 |
new
|
closed
|
2005 Aug
|
anonymous
|
Shell
|
2005 Aug
|
drh
|
5
|
5
|
Inefficient restoration of indexed dumps
|
edit |
1367 |
new
|
closed
|
2005 Aug
|
anonymous
|
Shell
|
2005 Aug
|
peter
|
1
|
1
|
connection string for SQLite with some examples
|
edit |
1330 |
code
|
closed
|
2005 Jul
|
anonymous
|
Shell
|
2005 Aug
|
|
2
|
5
|
The internal function max doesn't work properly
|
edit |
1333 |
code
|
closed
|
2005 Jul
|
anonymous
|
Shell
|
2005 Jul
|
|
2
|
3
|
sqlite3 command line interfaces segfaults when getpwd() fails
|
edit |
1148 |
new
|
closed
|
2005 Feb
|
anonymous
|
Shell
|
2005 Mar
|
|
5
|
5
|
patch to print query execute time on shell.c
|
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 |
1089 |
code
|
closed
|
2005 Jan
|
anonymous
|
Shell
|
2005 Jan
|
|
1
|
1
|
Segmentation fault
|
edit |
1077 |
code
|
closed
|
2005 Jan
|
anonymous
|
Shell
|
2005 Jan
|
|
1
|
1
|
auto_increment and insert into ~ select
|
edit |
402 |
code
|
closed
|
2003 Jul
|
anonymous
|
Shell
|
2005 Jan
|
anonymous
|
2
|
3
|
linebreake
|
edit |
1073 |
code
|
closed
|
2005 Jan
|
anonymous
|
Shell
|
2005 Jan
|
|
2
|
3
|
Windows Shell: .read commands need '/' in filenames to work
|
edit |
1071 |
code
|
closed
|
2005 Jan
|
anonymous
|
Shell
|
2005 Jan
|
|
4
|
3
|
Typo in .help
|
edit |
894 |
code
|
closed
|
2004 Sep
|
anonymous
|
Shell
|
2004 Sep
|
|
3
|
3
|
COUNT does not work with DISTINCT SUBSTR
|
edit |
649 |
code
|
closed
|
2004 Mar
|
anonymous
|
Shell
|
2004 Mar
|
|
1
|
1
|
sqlite-2.8.12 segmentation fault in shell command-line usage
|
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 |
631 |
code
|
closed
|
2004 Feb
|
anonymous
|
Shell
|
2004 Feb
|
|
2
|
3
|
command line SQL paramater doesn't work on windows pre-compiled binary
|
edit |
527 |
code
|
closed
|
2003 Dec
|
anonymous
|
Shell
|
2004 Feb
|
|
3
|
3
|
Sqlite shell: lack of checks
|
edit |
549 |
code
|
closed
|
2004 Jan
|
anonymous
|
Shell
|
2004 Jan
|
|
1
|
1
|
number of week change in wendesday/thursday
|
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 |
389 |
event
|
closed
|
2003 Jul
|
anonymous
|
Shell
|
2003 Jul
|
|
1
|
1
|
Undefined symbol
|
edit |
392 |
event
|
closed
|
2003 Jul
|
anonymous
|
Shell
|
2003 Jul
|
anonymous
|
1
|
1
|
Unable to link libsqlite.so file on SunOS 5.8
|
edit |
390 |
code
|
closed
|
2003 Jul
|
anonymous
|
Shell
|
2003 Jul
|
|
3
|
4
|
database creation
|
edit |
304 |
code
|
closed
|
2003 May
|
anonymous
|
Shell
|
2003 May
|
|
3
|
3
|
DELETE on read-only db reporting error inconsistently
|
edit |
167 |
new
|
closed
|
2002 Oct
|
anonymous
|
Shell
|
2002 Dec
|
|
5
|
4
|
Difficult to quickly quit sqlite
|
edit |
64 |
code
|
closed
|
2002 Jun
|
danielk1977
|
Shell
|
2002 Sep
|
|
5
|
5
|
TEMP tables in a read-only db using the shell tool
|
edit |
21 |
code
|
closed
|
2002 Apr
|
anonymous
|
Shell
|
2002 May
|
|
1
|
1
|
2.4.8 SQLITE.EXE: out of memory! (Windows98)
|
edit |
4 |
new
|
closed
|
2002 Mar
|
persicom
|
Shell
|
2002 May
|
|
2
|
3
|
Change prompt of 'sqlite' query tool.
|
edit |
1505 |
code
|
closed
|
2005 Nov
|
anonymous
|
TclLib
|
2005 Nov
|
|
2
|
3
|
Sqlite3 tcl bindings return "{}" instead of {} for the empty result
|
edit |
1230 |
event
|
closed
|
2005 Apr
|
anonymous
|
TclLib
|
2005 May
|
|
1
|
1
|
coredump in tclsqlite on HPUX 11.11 64 bit
|
edit |
1179 |
code
|
closed
|
2005 Mar
|
anonymous
|
TclLib
|
2005 Mar
|
|
2
|
1
|
Unable to use NULL for an AUTOINCREMENT field in TclSQLite
|
edit |
696 |
code
|
closed
|
2004 Apr
|
anonymous
|
TclLib
|
2005 Jan
|
|
1
|
1
|
tclsqlite does not build on RH 7.3
|
edit |
1067 |
code
|
closed
|
2005 Jan
|
anonymous
|
TclLib
|
2005 Jan
|
anonymous
|
2
|
4
|
Tcl parsing failure in SQL statement DELETE?
|
edit |
547 |
code
|
closed
|
2004 Jan
|
anonymous
|
TclLib
|
2005 Jan
|
|
3
|
4
|
tcl array not cleared between queries
|
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 |
795 |
new
|
closed
|
2004 Jul
|
anonymous
|
TclLib
|
2004 Oct
|
|
5
|
3
|
Separate TCL library from libsqlite3
|
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 |
671 |
build
|
closed
|
2004 Mar
|
anonymous
|
TclLib
|
2004 Mar
|
|
4
|
4
|
Missing tcl.h from /src
|
edit |
170 |
code
|
closed
|
2002 Oct
|
anonymous
|
TclLib
|
2002 Oct
|
anonymous
|
2
|
2
|
Insert / select text with cp1250 characters
|
edit |
1966 |
build
|
closed
|
2006 Sep
|
anonymous
|
Unknown
|
2007 Feb
|
|
3
|
4
|
Add a --disable-readline option to configure
|
edit |
1971 |
code
|
closed
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Oct
|
|
4
|
4
|
66 tests fail out of 26937
|
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 |
1477 |
code
|
closed
|
2005 Oct
|
anonymous
|
Unknown
|
2006 Sep
|
|
1
|
2
|
first "select count(*) from mytable" takes a very long time
|
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 |
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 |
1970 |
build
|
closed
|
2006 Sep
|
anonymous
|
Unknown
|
2006 Sep
|
|
4
|
4
|
Cannot make Loadable Extensions to work for me.
|
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 |
1751 |
code
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Sep
|
mike
|
1
|
1
|
sqlite doesn't work on a cifs-mounted drive
|
edit |
1944 |
new
|
closed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
4
|
4
|
no UTF16 counterpart to sqlite3_exec()
|
edit |
1936 |
code
|
closed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
2
|
3
|
Altering schema seems to invalidate existing database connections
|
edit |
1930 |
code
|
closed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
adamd
|
1
|
1
|
the select command can't support NOT_FOUND.
|
edit |
1795 |
code
|
closed
|
2006 May
|
anonymous
|
Unknown
|
2006 Aug
|
|
1
|
1
|
Incorrect result if a nested view contains a union
|
edit |
1908 |
code
|
closed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
anonymous
|
2
|
4
|
ORDER BY clause does not allow quoting
|
edit |
1904 |
code
|
closed
|
2006 Aug
|
anonymous
|
Unknown
|
2006 Aug
|
|
2
|
3
|
error using drop table "if exists" in exec
|
edit |
1894 |
event
|
closed
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Jul
|
|
4
|
3
|
"library routine called out of sequence" when using progress (TCL)
|
edit |
1888 |
code
|
closed
|
2006 Jul
|
anonymous
|
Unknown
|
2006 Jul
|
anonymous
|
1
|
1
|
connetion to db extremely slow
|
edit |
1876 |
event
|
closed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
4
|
4
|
Creating table disrupts previously prepared statement
|
edit |
1859 |
code
|
closed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
danielk1977
|
4
|
3
|
Wrong calculation og log2() in check-in [3274]
|
edit |
1842 |
code
|
closed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
anonymous
|
1
|
1
|
The field data saved in the table is corrupt
|
edit |
1840 |
code
|
closed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
4
|
4
|
sqlite3_get_table returns null pointer for aggregate queries
|
edit |
1835 |
code
|
closed
|
2006 Jun
|
anonymous
|
Unknown
|
2006 Jun
|
|
1
|
2
|
Memory leak on sqlite3_step with Select with no result row
|
edit |
1819 |
code
|
closed
|
2006 May
|
anonymous
|
Unknown
|
2006 May
|
persicom
|
4
|
3
|
faulty html code for concatenated field with "<" character
|
edit |
1818 |
code
|
closed
|
2006 May
|
anonymous
|
Unknown
|
2006 May
|
drh
|
3
|
3
|
sqlite3_mprintf() misbehaving on %*. formats
|
edit |
1776 |
code
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
anonymous
|
1
|
2
|
Max(DateTime column) returns a String, not a DateTime
|
edit |
1767 |
warn
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
5
|
4
|
Unused variable in function sqlite3VdbeChangeEncoding
|
edit |
1766 |
new
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
3
|
2
|
Order by NO Case Sensitive
|
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 |
1761 |
code
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
1
|
3
|
SQLite3_BindText fails with a floating point error
|
edit |
1758 |
code
|
closed
|
2006 Apr
|
anonymous
|
Unknown
|
2006 Apr
|
|
3
|
1
|
problem with: select ... UNION ... select .. ORDER BY LOWER(column)
|
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 |
1739 |
code
|
closed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
4
|
1
|
sqlite3_bind_int on UPDATE * SET COLUMN1='Test' WHERE ID=?
|
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 |
1736 |
code
|
closed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
4
|
4
|
#define SQLITE_OMIT_ALTERTABLE causes unresolved externals
|
edit |
1592 |
code
|
closed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Mar
|
|
1
|
2
|
[patch] fixes for mbcs in os_win.c
|
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 |
1707 |
code
|
closed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
4
|
4
|
Internal data are not naturaly aligned, which could affect perfomance
|
edit |
1568 |
code
|
closed
|
2005 Dec
|
anonymous
|
Unknown
|
2006 Mar
|
|
1
|
1
|
sqlite3_column_decltype( ) returning BadPointer with "UNION"
|
edit |
1639 |
code
|
closed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Mar
|
|
3
|
3
|
pkgconfig file in 3.3.1 says version is 3.3
|
edit |
1691 |
code
|
closed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Mar
|
|
3
|
3
|
sqlite3_sleep not built
|
edit |
1705 |
code
|
closed
|
2006 Mar
|
anonymous
|
Unknown
|
2006 Mar
|
|
4
|
4
|
Default column constant doesn't assign value on NULL insert
|
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 |
1678 |
code
|
closed
|
2006 Feb
|
anonymous
|
Unknown
|
2006 Feb
|
|
1
|
1
|
error select like
|
edit |
1296 |
new
|
closed
|
2005 Jun
|
anonymous
|
Unknown
|
2006 Feb
|
|
5
|
5
|
Nested Transactions needed
|
edit |
679 |
code
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2006 Jan
|
a.rottmann
|
2
|
1
|
database closed
|
edit |
1609 |
code
|
closed
|
2006 Jan
|
anonymous
|
Unknown
|
2006 Jan
|
|
2
|
3
|
ALTER TABLE ADD COLUMN failed if table name has multibyte character
|
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 |
1556 |
event
|
closed
|
2005 Dec
|
anonymous
|
Unknown
|
2005 Dec
|
anonymous
|
1
|
1
|
database locked if used on mounted nfs shares (linux)
|
edit |
1540 |
code
|
closed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
2
|
3
|
Failure to create a primary key
|
edit |
1535 |
code
|
closed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
2
|
3
|
Segmentation fault on query
|
edit |
1518 |
code
|
closed
|
2005 Nov
|
anonymous
|
Unknown
|
2005 Nov
|
|
4
|
4
|
can not vacuum an empty db-file
|
edit |
1470 |
new
|
closed
|
2005 Oct
|
anonymous
|
Unknown
|
2005 Oct
|
anonymous
|
2
|
4
|
International support
|
edit |
1456 |
code
|
closed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
4
|
4
|
get_table16 ?
|
edit |
1439 |
code
|
closed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
3
|
3
|
Format String inserting a text
|
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 |
1404 |
event
|
closed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
1
|
1
|
pragma case_sensitive_like is broken?
|
edit |
1410 |
code
|
closed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
2
|
3
|
count(*) confused by newlines in data
|
edit |
1402 |
code
|
closed
|
2005 Sep
|
anonymous
|
Unknown
|
2005 Sep
|
|
1
|
2
|
(Windows 2K) file handle on file not released after use
|
edit |
1326 |
code
|
closed
|
2005 Jul
|
anonymous
|
Unknown
|
2005 Aug
|
|
4
|
1
|
using callbacks with two exact queries duplicate results
|
edit |
1349 |
code
|
closed
|
2005 Aug
|
anonymous
|
Unknown
|
2005 Aug
|
anonymous
|
4
|
4
|
NULL handling UNIQUE indexes is not consistent
|
edit |
1281 |
code
|
closed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
1
|
1
|
Errors testing sqlite 3.2.1
|
edit |
1238 |
code
|
closed
|
2005 May
|
anonymous
|
Unknown
|
2005 Jun
|
|
1
|
3
|
Failure to compile with SQLITE_OMIT_... macros enabled
|
edit |
1273 |
code
|
closed
|
2005 Jun
|
anonymous
|
Unknown
|
2005 Jun
|
|
3
|
3
|
Numeric affinity problem with views + coalesce (maybe all functions?)
|
edit |
1144 |
code
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 May
|
|
1
|
3
|
Changing page_size causes a GPF on memory databases
|
edit |
1218 |
code
|
closed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
2
|
1
|
'select rowid' does not return 'rowid' as column title
|
edit |
1225 |
code
|
closed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
3
|
3
|
Empty resultset when unreferenced empty "table AS name" is given.
|
edit |
1195 |
code
|
closed
|
2005 Apr
|
anonymous
|
Unknown
|
2005 Apr
|
|
3
|
3
|
memory leak
|
edit |
1192 |
code
|
closed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
2
|
3
|
Defaults not Respected by View Triggers
|
edit |
1183 |
code
|
closed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
danielk1977
|
3
|
2
|
Memory coruption related to syntax errors
|
edit |
1175 |
code
|
closed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
1
|
1
|
busy handler is not being called
|
edit |
1107 |
new
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Mar
|
|
5
|
3
|
please add function to query endianness match/mismatch for BLOB
|
edit |
1139 |
code
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Mar
|
|
1
|
1
|
error while loading shared libraries
|
edit |
1156 |
new
|
closed
|
2005 Mar
|
anonymous
|
Unknown
|
2005 Mar
|
|
3
|
1
|
Cant fetch records in between one DATE to another DATE
|
edit |
1136 |
code
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
3
|
3
|
make test: syntax error in alter-1.8.2
|
edit |
1131 |
new
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
2
|
3
|
triggers don't seem to work across databases
|
edit |
1129 |
new
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
drh
|
4
|
3
|
allow having the same object in several open databases
|
edit |
1113 |
code
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
2
|
2
|
Problem with TYPEOF function in triggers
|
edit |
1096 |
new
|
closed
|
2005 Feb
|
|
Unknown
|
2005 Feb
|
|
3
|
3
|
? placeholder not allowed in LIMIT or OFFSET clause
|
edit |
1093 |
doc
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
5
|
4
|
possible mistake in a comment sqlite3_get_table sqlite3.h:~line312
|
edit |
1092 |
code
|
closed
|
2005 Feb
|
anonymous
|
Unknown
|
2005 Feb
|
|
1
|
2
|
wrong result of a query
|
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 |
470 |
code
|
closed
|
2003 Oct
|
anonymous
|
Unknown
|
2005 Jan
|
|
2
|
3
|
Unnecessary 31-character name limit on Mac
|
edit |
199 |
new
|
closed
|
2002 Dec
|
anonymous
|
Unknown
|
2005 Jan
|
drh
|
4
|
4
|
Encryption
|
edit |
1076 |
todo
|
closed
|
2005 Jan
|
anonymous
|
Unknown
|
2005 Jan
|
|
2
|
3
|
data loss possible with fsync on Mac OS X 10.3
|
edit |
1074 |
code
|
closed
|
2005 Jan
|
anonymous
|
Unknown
|
2005 Jan
|
drh
|
3
|
3
|
CREATE INDEX and dbl-quoted index names
|
edit |
1018 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2005 Jan
|
|
1
|
3
|
Some functions not defined for OS_MAC
|
edit |
847 |
code
|
closed
|
2004 Aug
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
1
|
sqlite3_changes doesn't reset to zero after inserts
|
edit |
1065 |
new
|
closed
|
2005 Jan
|
anonymous
|
Unknown
|
2005 Jan
|
|
3
|
3
|
Uppercase and foreign chars problems in searches
|
edit |
787 |
code
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
4
|
Bad free() ignored (PERL_CORE)
|
edit |
1019 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2005 Jan
|
|
1
|
3
|
Improper handling of 8bit data
|
edit |
438 |
code
|
closed
|
2003 Aug
|
anonymous
|
Unknown
|
2005 Jan
|
|
1
|
4
|
Minute function off between 11:16 and 11:20
|
edit |
418 |
code
|
closed
|
2003 Jul
|
anonymous
|
Unknown
|
2005 Jan
|
|
4
|
4
|
sometimes web page returns error, hitting refresh makes it work
|
edit |
1055 |
code
|
closed
|
2004 Dec
|
anonymous
|
Unknown
|
2005 Jan
|
|
3
|
3
|
Please archive files in PACKAGE-VERSION/ directory
|
edit |
1042 |
code
|
closed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
1
|
2
|
where does not work
|
edit |
1041 |
code
|
closed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
1
|
1
|
select x<2 from table does not work anymore
|
edit |
1037 |
code
|
closed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
1
|
1
|
.Net Interop Problem
|
edit |
1028 |
new
|
closed
|
2004 Dec
|
anonymous
|
Unknown
|
2004 Dec
|
|
2
|
2
|
Without COPY: need alt. method to import data (not .import)
|
edit |
1023 |
new
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Dec
|
|
4
|
4
|
don't link against pthreads if not configured with --enable-threadsafe
|
edit |
1017 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
1
|
1
|
error while loading shared libraries: /lib/libsqlite.so.0
|
edit |
1013 |
build
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
peter
|
1
|
1
|
undefined reference to sqlite_open
|
edit |
935 |
code
|
closed
|
2004 Sep
|
anonymous
|
Unknown
|
2004 Nov
|
|
4
|
4
|
several crash.test tests fail (spuriously) when [sqlite3 -has-codec]
|
edit |
728 |
code
|
closed
|
2004 May
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
4
|
3
|
.schema table fails if followed by a semicolon
|
edit |
753 |
code
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Nov
|
drh
|
4
|
4
|
view always report numeric as data type
|
edit |
986 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
4
|
indexed "between" is slower than manually typing out constraints
|
edit |
958 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Nov
|
drh
|
3
|
2
|
sqlite3_create_function() dose not really delete an user function
|
edit |
977 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
View Bug
|
edit |
992 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
sqliteStrRealloc: Return early under malloc failure.
|
edit |
989 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
Followup to #984, same issue with hexToInt
|
edit |
994 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
Brackets in JOIN statements break <table>.<column> SELECT syntax
|
edit |
996 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
2
|
4
|
Error in primary key fields for temp tables
|
edit |
1000 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
1
|
1
|
use popen function and sqlite3_open is dummy..
|
edit |
1009 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
3
|
3
|
sqlite3RunVacuum: "forever" loop exists in error code path.
|
edit |
1005 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
1
|
1
|
No error from sqlite3_exec
|
edit |
998 |
event
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
anonymous
|
2
|
1
|
Database table is locked accessing SQLite through QT library.
|
edit |
988 |
code
|
closed
|
2004 Nov
|
anonymous
|
Unknown
|
2004 Nov
|
|
4
|
4
|
column type "int primary key" doesn't autoincrement
|
edit |
968 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
anonymous
|
5
|
5
|
Access overrun (sometimes) with use of SELECT DISTINCT
|
edit |
963 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
3
|
3
|
PRIMARY KEY
|
edit |
729 |
new
|
closed
|
2004 May
|
anonymous
|
Unknown
|
2004 Oct
|
|
5
|
3
|
Support wiki-style bulleted lists in tickets
|
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 |
909 |
code
|
closed
|
2004 Sep
|
anonymous
|
Unknown
|
2004 Oct
|
|
1
|
1
|
Inconsistent unordered and ordered selects (index corruption?)
|
edit |
950 |
new
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
2
|
4
|
No access to sqlite3ErrStr and sqlite3_temp_directory
|
edit |
949 |
new
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
3
|
3
|
add user-level test for file validity
|
edit |
945 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
2
|
2
|
sqlite3 opens sqlite2 databases without complaining
|
edit |
941 |
code
|
closed
|
2004 Oct
|
anonymous
|
Unknown
|
2004 Oct
|
|
2
|
3
|
Updates are not atomic with respect to unique constraints
|
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 |
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 |
920 |
code
|
closed
|
2004 Sep
|
anonymous
|
Unknown
|
2004 Sep
|
anonymous
|
3
|
3
|
group by without having not supported
|
edit |
861 |
code
|
closed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Sep
|
anonymous
|
1
|
1
|
SqLite is accent-sensitive?
|
edit |
876 |
code
|
closed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Aug
|
|
1
|
3
|
select from ... where ... or ... is dead slow on indexed column
|
edit |
775 |
code
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Aug
|
|
1
|
1
|
windows sqlite3.dll corrupt?
|
edit |
858 |
code
|
closed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Aug
|
|
2
|
3
|
core dump when peforming bind
|
edit |
854 |
code
|
closed
|
2004 Aug
|
anonymous
|
Unknown
|
2004 Aug
|
anonymous
|
3
|
1
|
Index don't work with NULL field
|
edit |
835 |
doc
|
closed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Aug
|
|
4
|
4
|
Locks reference on the FAQ - Read while writing?
|
edit |
750 |
code
|
closed
|
2004 May
|
anonymous
|
Unknown
|
2004 Jul
|
|
2
|
3
|
copy command does not work with existing table
|
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 |
808 |
code
|
closed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
1
|
1
|
Lower() function with UNICODE
|
edit |
799 |
build
|
closed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
|
5
|
4
|
Missing exports in 3.0.2 Win32 DLL
|
edit |
803 |
new
|
closed
|
2004 Jul
|
anonymous
|
Unknown
|
2004 Jul
|
drh
|
1
|
1
|
sqlite3_create_function needs a userdata parameter
|
edit |
781 |
code
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
|
4
|
4
|
unable to run malloc test even with -DMEMORY_DEBUG
|
edit |
773 |
code
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
|
3
|
4
|
user-defined sql function called unexpected number of times
|
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 |
759 |
event
|
closed
|
2004 Jun
|
anonymous
|
Unknown
|
2004 Jun
|
a.rottmann
|
2
|
1
|
record can't be inserted
|
edit |
715 |
code
|
closed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
|
2
|
3
|
reference counted file locking attempts to unlock on different thread
|
edit |
706 |
build
|
closed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
|
1
|
1
|
undefined reference
|
edit |
694 |
code
|
closed
|
2004 Apr
|
anonymous
|
Unknown
|
2004 Apr
|
|
3
|
4
|
uninitialised or unaddressable byte(s) in os.c
|
edit |
672 |
warn
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
1
|
1
|
THE DLL FILE FOR WINDOWS IS CURRUPTED
|
edit |
657 |
code
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
1
|
1
|
Wrong reported columncount in CallBack routine
|
edit |
653 |
code
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
1
|
1
|
sqlite db 'create table t(f)' dumps core
|
edit |
643 |
code
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
3
|
2
|
local variable 'db' used without having been initialized
|
edit |
636 |
new
|
closed
|
2004 Mar
|
anonymous
|
Unknown
|
2004 Mar
|
|
1
|
1
|
Retaining autoincrement (Primary key) generated values
|
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 |
618 |
code
|
closed
|
2004 Feb
|
anonymous
|
Unknown
|
2004 Feb
|
|
3
|
3
|
fails test btree-1.1.1
|
edit |
597 |
code
|
closed
|
2004 Feb
|
anonymous
|
Unknown
|
2004 Feb
|
|
3
|
2
|
SELECT * FROM TB_LINFPSP_CONFIG WHERE LINFPSP_CUST_CODE='HBC'
|
edit |
571 |
code
|
closed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
1
|
1
|
Execution of comment via sqlite_step raise Access violation
|
edit |
562 |
code
|
closed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
2
|
3
|
System needs to rename duplicate named columns.
|
edit |
559 |
code
|
closed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
1
|
1
|
Very slow insert into ... under Win2K
|
edit |
557 |
code
|
closed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
3
|
1
|
sqlite_close SQLITE_MAGIC_ERROR reply.
|
edit |
554 |
code
|
closed
|
2004 Jan
|
anonymous
|
Unknown
|
2004 Jan
|
|
3
|
1
|
sqlite_close SQLITE_MAGIC_ERROR
|
edit |
535 |
code
|
closed
|
2003 Dec
|
anonymous
|
Unknown
|
2003 Dec
|
|
1
|
1
|
Use of uninitialised value of size 4
|
edit |
161 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2003 Dec
|
|
1
|
1
|
Left join with 3 tables bug ?
|
edit |
528 |
code
|
closed
|
2003 Dec
|
anonymous
|
Unknown
|
2003 Dec
|
|
4
|
2
|
compiled c code shows queries in executable
|
edit |
423 |
code
|
closed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Dec
|
|
1
|
1
|
'data schema has been changed error' how will overcome this
|
edit |
422 |
code
|
closed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Dec
|
|
4
|
1
|
Memory leak in src/build.c
|
edit |
522 |
code
|
closed
|
2003 Dec
|
anonymous
|
Unknown
|
2003 Dec
|
|
1
|
1
|
Error in comparision equal and less-equal
|
edit |
507 |
code
|
closed
|
2003 Nov
|
anonymous
|
Unknown
|
2003 Nov
|
|
2
|
4
|
string comparison in where-clause of select
|
edit |
497 |
new
|
closed
|
2003 Nov
|
anonymous
|
Unknown
|
2003 Nov
|
|
3
|
3
|
not able to escape quotes
|
edit |
248 |
code
|
closed
|
2003 Feb
|
anonymous
|
Unknown
|
2003 Nov
|
|
1
|
2
|
SQLColumn function in ODBC returns incorrect datatype
|
edit |
201 |
doc
|
closed
|
2002 Dec
|
anonymous
|
Unknown
|
2003 Nov
|
|
1
|
1
|
it is very well if there is a table lock! but ...
|
edit |
115 |
new
|
closed
|
2002 Jul
|
anonymous
|
Unknown
|
2003 Nov
|
|
1
|
5
|
table_info() missing datatypes
|
edit |
492 |
code
|
closed
|
2003 Nov
|
anonymous
|
Unknown
|
2003 Nov
|
|
2
|
4
|
database image is malformed
|
edit |
474 |
code
|
closed
|
2003 Oct
|
anonymous
|
Unknown
|
2003 Oct
|
|
4
|
1
|
Problem with showing the datatypes of columns of a empty table
|
edit |
467 |
code
|
closed
|
2003 Sep
|
anonymous
|
Unknown
|
2003 Oct
|
|
2
|
1
|
Problem with renaming fields
|
edit |
437 |
code
|
closed
|
2003 Aug
|
anonymous
|
Unknown
|
2003 Aug
|
|
3
|
3
|
Wrong order for results of SELECT
|
edit |
417 |
code
|
closed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Aug
|
|
4
|
4
|
Resultset differs between ..LIMIT 20 OFFSET 100 and ..LIMIT 20, 100
|
edit |
382 |
code
|
closed
|
2003 Jul
|
|
Unknown
|
2003 Jul
|
|
2
|
2
|
Triggers stop firing under certain situations
|
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 |
380 |
code
|
closed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
|
2
|
2
|
"uniqueness constraint failed" on insertion of distinct rows
|
edit |
261 |
code
|
closed
|
2003 Mar
|
anonymous
|
Unknown
|
2003 Jul
|
|
2
|
3
|
Non Callback Finalize Bug
|
edit |
372 |
event
|
closed
|
2003 Jul
|
anonymous
|
Unknown
|
2003 Jul
|
anonymous
|
1
|
1
|
tcl.h missing in windows source code
|
edit |
358 |
code
|
closed
|
2003 Jun
|
anonymous
|
Unknown
|
2003 Jun
|
|
1
|
1
|
Problems with inserting file (.bmp; .jpg) in BLOB field
|
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 |
319 |
code
|
closed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
1
|
1
|
Large Encoded Strings Get Truncated
|
edit |
314 |
event
|
closed
|
2003 May
|
anonymous
|
Unknown
|
2003 May
|
|
4
|
4
|
Memory usage
|
edit |
274 |
code
|
closed
|
2003 Mar
|
anonymous
|
Unknown
|
2003 Apr
|
|
2
|
3
|
bug in sqlite_free_table
|
edit |
267 |
code
|
closed
|
2003 Mar
|
anonymous
|
Unknown
|
2003 Mar
|
anonymous
|
1
|
4
|
sqlite.dll / sqlite.def does not export an Init function
|
edit |
214 |
code
|
closed
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Jan
|
|
1
|
1
|
segmentation fault on ETRAX board - started in version 2.7.4
|
edit |
127 |
event
|
closed
|
2002 Jul
|
anonymous
|
Unknown
|
2003 Jan
|
|
4
|
5
|
testfixture crashes with bus error following misuse-5.3 test
|
edit |
228 |
event
|
closed
|
2003 Jan
|
anonymous
|
Unknown
|
2003 Jan
|
drh
|
1
|
1
|
The size of database file is not decreased .
|
edit |
182 |
event
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
1
|
1
|
Win32 DBI Interface crashes Perl.exe
|
edit |
181 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
anonymous
|
5
|
5
|
MAX Function on NULL Values
|
edit |
162 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
anonymous
|
3
|
2
|
mismatch in response column and Group by column is ignored
|
edit |
158 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
3
|
2
|
Union doesn't check for data types
|
edit |
157 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
anonymous
|
3
|
2
|
Doesn't check for data types
|
edit |
156 |
code
|
closed
|
2002 Oct
|
anonymous
|
Unknown
|
2002 Oct
|
|
1
|
1
|
Cannot log in to CVSTraq because no "create account page"
|
edit |
124 |
code
|
closed
|
2002 Jul
|
anonymous
|
Unknown
|
2002 Sep
|
anonymous
|
2
|
1
|
Segfault on a join using an INTEGER PRIMARY KEY.
|
edit |
114 |
code
|
closed
|
2002 Jul
|
anonymous
|
Unknown
|
2002 Sep
|
|
2
|
3
|
Concurrency problem in sqlite_open when automatic upgrading
|
edit |
110 |
new
|
closed
|
2002 Jul
|
anonymous
|
Unknown
|
2002 Sep
|
anonymous
|
5
|
4
|
Refuse multiple begin transaction or commit
|
edit |
149 |
new
|
closed
|
2002 Sep
|
anonymous
|
Unknown
|
2002 Sep
|
|
5
|
4
|
SELECT UNIQUE
|
edit |
148 |
code
|
closed
|
2002 Sep
|
anonymous
|
Unknown
|
2002 Sep
|
anonymous
|
3
|
3
|
sqlHashFind() segfaults in a created function
|
edit |
145 |
code
|
closed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
|
1
|
1
|
Tests failing
|
edit |
144 |
new
|
closed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
|
4
|
3
|
Read/Write Locks under Windows NT/2000/XP (simul. access)
|
edit |
143 |
code
|
closed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
anonymous
|
1
|
3
|
order by and null columns
|
edit |
141 |
code
|
closed
|
2002 Aug
|
anonymous
|
Unknown
|
2002 Aug
|
|
1
|
3
|
Using the incorrect format inhibits record update
|
edit |
1460 |
code
|
closed
|
2005 Sep
|
anonymous
|
VDBE
|
2008 Jan
|
drh
|
2
|
2
|
sqlite3_clear_bindings not implemented in sources
|
edit |
2003 |
warn
|
closed
|
2006 Sep
|
anonymous
|
VDBE
|
2006 Sep
|
|
4
|
4
|
vdbeaux.c:1585: warning: unused variable 'sqlite3_search_count'
|
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 |
1909 |
code
|
closed
|
2006 Aug
|
anonymous
|
VDBE
|
2006 Aug
|
anonymous
|
3
|
3
|
cannot use sqlite3_prepare() when DB is in "BEGIN EXCLUSIVE" mode
|
edit |
1748 |
code
|
closed
|
2006 Apr
|
anonymous
|
VDBE
|
2006 Apr
|
|
3
|
3
|
Memory leak in insert.c: sqlite3TableAffinityStr
|
edit |
1640 |
code
|
closed
|
2006 Jan
|
anonymous
|
VDBE
|
2006 Jan
|
|
3
|
2
|
Can't get error message from sqlite3_result_error
|
edit |
1507 |
code
|
closed
|
2005 Nov
|
anonymous
|
VDBE
|
2005 Nov
|
|
2
|
2
|
Embarassing buffer overflow in sqlite3VdbeMemPrettyPrint( )
|
edit |
1462 |
code
|
closed
|
2005 Sep
|
anonymous
|
VDBE
|
2005 Sep
|
drh
|
1
|
2
|
sqlite3_bind_parameter_name() always return nulls
|
edit |
1383 |
code
|
closed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
|
1
|
1
|
Whole doubles get a dot zero when promoted to string
|
edit |
1366 |
code
|
closed
|
2005 Aug
|
anonymous
|
VDBE
|
2005 Aug
|
|
3
|
3
|
not getting SQLITE_CORRUPT when corruption detected in a SELECT
|
edit |
1290 |
new
|
closed
|
2005 Jun
|
anonymous
|
VDBE
|
2005 Jun
|
drh
|
1
|
1
|
optimize VBDE, reordening ID numbers of OP_????? codes
|
edit |
1266 |
code
|
closed
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
2
|
2
|
crash when using instead of update triggers on views
|
edit |
1261 |
new
|
closed
|
2005 May
|
anonymous
|
VDBE
|
2005 May
|
|
5
|
3
|
Optimization
|
edit |
1178 |
code
|
closed
|
2005 Mar
|
anonymous
|
VDBE
|
2005 Mar
|
|
1
|
1
|
sqlite 3 returns SQLITE_ERROR instead of SQLITE_SCHEMA
|
edit |
1154 |
event
|
closed
|
2005 Mar
|
anonymous
|
VDBE
|
2005 Mar
|
|
1
|
1
|
PRIMARY KEY AUTOINCREMENT and TRIGGER problem
|
edit |
1104 |
code
|
closed
|
2005 Feb
|
anonymous
|
VDBE
|
2005 Feb
|
|
1
|
1
|
Integer overflow
|
edit |
1102 |
code
|
closed
|
2005 Feb
|
anonymous
|
VDBE
|
2005 Feb
|
|
3
|
3
|
uninitialized memory copy in sqlite3VdbeExec
|
edit |
1 |
new
|
closed
|
2002 Mar
|
drh
|
VDBE
|
2005 Feb
|
|
3
|
4
|
Make the LIKE operator a user-installable function
|
edit |
745 |
code
|
closed
|
2004 May
|
anonymous
|
VDBE
|
2005 Jan
|
|
5
|
3
|
no error message when two statements cause a conflict
|
edit |
751 |
code
|
closed
|
2004 Jun
|
anonymous
|
VDBE
|
2005 Jan
|
|
1
|
2
|
sqliteVdbeExec: Assertion `db->magic==***' failed.
|
edit |
324 |
todo
|
closed
|
2003 May
|
anonymous
|
VDBE
|
2005 Jan
|
|
1
|
4
|
ESCAPE clause in LIKE predicate not implemented
|
edit |
937 |
code
|
closed
|
2004 Oct
|
anonymous
|
VDBE
|
2004 Oct
|
drh
|
2
|
4
|
mixed wildcard "?" and ":abc" cause msvcrt.dll raise a exception.
|
edit |
928 |
code
|
closed
|
2004 Sep
|
anonymous
|
VDBE
|
2004 Sep
|
drh
|
3
|
3
|
delete record by rowid would core dump
|
edit |
917 |
code
|
closed
|
2004 Sep
|
anonymous
|
VDBE
|
2004 Sep
|
drh
|
1
|
1
|
bug with named parameters
|
edit |
722 |
code
|
closed
|
2004 May
|
anonymous
|
VDBE
|
2004 Jul
|
drh
|
2
|
1
|
long long format specifier in sqlite_exec_printf missing
|
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 |
580 |
code
|
closed
|
2004 Jan
|
anonymous
|
VDBE
|
2004 Jan
|
|
2
|
3
|
Incorrect Select when specifying same field value as column name
|
edit |
555 |
code
|
closed
|
2004 Jan
|
anonymous
|
VDBE
|
2004 Jan
|
|
1
|
1
|
sqlite_step and sqlite_compile cause locking problem
|
edit |
537 |
code
|
closed
|
2003 Dec
|
anonymous
|
VDBE
|
2003 Dec
|
|
1
|
2
|
Problems using sqlite_bind() with INSERT INTO ... SELECT statements
|
edit |
415 |
code
|
closed
|
2003 Jul
|
anonymous
|
VDBE
|
2003 Dec
|
|
3
|
3
|
Stringify can loose digits in doubles
|
edit |
426 |
code
|
closed
|
2003 Aug
|
anonymous
|
VDBE
|
2003 Dec
|
|
2
|
3
|
TIME produces JDs off by 12 hours
|
edit |
511 |
code
|
closed
|
2003 Nov
|
anonymous
|
VDBE
|
2003 Nov
|
|
1
|
1
|
confused error of nested calling of "sqlite_compile"
|
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 |
165 |
code
|
closed
|
2002 Oct
|
anonymous
|
VDBE
|
2002 Oct
|
anonymous
|
1
|
1
|
can create and change tickets, without logged in
|
edit |
62 |
code
|
closed
|
2002 Jun
|
danielk1977
|
VDBE
|
2002 Sep
|
|
3
|
4
|
TEMP tables with a read-only database
|
edit |
10 |
code
|
closed
|
2002 Apr
|
drh
|
VDBE
|
2002 May
|
|
1
|
1
|
Stack grows without bound on UPDATE OR IGNORE
|
edit |
7 |
code
|
closed
|
2002 Apr
|
danielk1977
|
VDBE
|
2002 May
|
|
5
|
2
|
VDBE trace prints out garbage for P3 of Function opcodes
|
edit |