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
