Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
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: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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 d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
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 d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
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. Thanks, -Kalyani -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] 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 d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
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 d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
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, -Kalyani -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of D. Richard Hipp Sent: Tuesday, June 16, 2009 12:02 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 2:53 PM, Kalyani Phadke wrote: > I am using sqlite version 3.6.15.I upgraded my database from sqlite > 3.5.4 to 3.6.15. I am not able to open database from sqlite3.exe cmd > utility . > I can do sqlite3.exe test.DB but if type .database ,it gives me error > malformed database schema. > pragma integrity_check , gives error malformed database schema So I > took the dump of db in test.sql using .dump command. If try to create > database using test.sql I get bunch of errors. > default value of column is not constant, no such table etc. > I have to go manually and edit sql ,make changes so that everything > works fine. > > I am just curious why my database structure get corrupted / changed > .Will changing database engine cause schema to change or is it dump > command changing my database schema. SQLite version 3.6.15 should be able to read and write any SQLite database back through version 3.0.0. If you find an instance where this is not the case, then that is a bug. Please report it. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
On Jun 16, 2009, at 2:53 PM, Kalyani Phadke wrote: > I am using sqlite version 3.6.15.I upgraded my database from sqlite > 3.5.4 to 3.6.15. I am not able to open database from sqlite3.exe cmd > utility . > I can do sqlite3.exe test.DB but if type > .database ,it gives me error malformed database schema. > pragma integrity_check , gives error malformed database schema > So I took the dump of db in test.sql using .dump command. If try to > create database using test.sql I get bunch of errors. > default value of column is not constant, no such table etc. > I have to go manually and edit sql ,make changes so that everything > works fine. > > I am just curious why my database structure get corrupted / > changed .Will > changing database engine cause schema to change or is it dump command > changing my database schema. SQLite version 3.6.15 should be able to read and write any SQLite database back through version 3.0.0. If you find an instance where this is not the case, then that is a bug. Please report it. D. Richard Hipp d...@hwaci.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Sqlite3 database upgrade from 3.5.4 to 3.6.15 issue
I am using sqlite version 3.6.15.I upgraded my database from sqlite 3.5.4 to 3.6.15. I am not able to open database from sqlite3.exe cmd utility . I can do sqlite3.exe test.DB but if type .database ,it gives me error malformed database schema. pragma integrity_check , gives error malformed database schema So I took the dump of db in test.sql using .dump command. If try to create database using test.sql I get bunch of errors. default value of column is not constant, no such table etc. I have to go manually and edit sql ,make changes so that everything works fine. I am just curious why my database structure get corrupted /changed .Will changing database engine cause schema to change or is it dump command changing my database schema. Thanks, -Kalyani ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users