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. Pls find attached file.
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.
Thanks,
-Kalyani
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of D. Richard Hipp
Sent: Tuesday, June 16, 2009 12:23 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15
issue
On Jun 16, 2009, at 3:10 PM, Kalyani Phadke wrote:
> But before entering the bug , I would like to find out how this
> happened. Whats the cause of it. Because I am not able to duplicate it
> all the time. IS there any way to find out what went wrong?
> Thanks,
>> I have to go manually and edit sql ,make changes so that everything
>> works fine.
>>
What do you have to manually edit to make it work. Please show us the
text before and after you edit.
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
