On Jun 16, 2009, at 6:03 PM, Kalyani Phadke wrote:
>
> if I create dump using sqlite3.5.4 and recreate DB using that dump
> data
> using sqlite3.5.4,everything works fine. if I create dump using
> sqlite3.5.4 and recreate DB using that dump data using
> sqlite3.6.15,gets
> error.
>
> The text generated from .dump command of sqlite3 version 3.5.4.
> CREATE TABLE Users
> (
> ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ,
> name VARCHAR(50) NOT NULL COLLATE NOCASE,
> Page VARCHAR(255) NULL DEFAULT ("../xyz/main.asp")
>
> );
>
> Changed text to
>
> CREATE TABLE Users
> (
> ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ,
> name VARCHAR(50) NOT NULL COLLATE NOCASE,
> Page VARCHAR(255) NULL DEFAULT ('../xyz/main.asp')
> );
>
> After changing everything seems to be fine.
The bug was in 3.5.4. It should never have accepted the double-quoted
string as a default value. SQL always uses single quotes for string
literals.
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
