Re: [sqlite] sqlite crash info
On 1 Jan 2012, at 3:49pm, Lalitkumar Choudhary wrote: > I want to know one thing about sqlite crashing, you had mentioned in your > document which i had found in your website(www.sqlite.org). > Sqlite database will crash if you write some garbage value into the file. Which document on that site did you find this information in ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite crash info
On Sun, Jan 1, 2012 at 10:49 AM, Lalitkumar Choudhary < lalitkumar.choudh...@lnties.com> wrote: > Hi, > > I want to know one thing about sqlite crashing, you had mentioned in your > document which i had found in your website(www.sqlite.org). > Sqlite database will crash if you write some garbage value into the file. > May i know exactly what is the garbage value? Is it any value different > from datatype or anything else, can u please give one example? > The SQLite database engine will not crash or segfault or otherwise cause your program to stop running if it encounters garbage data in a file. But it will return SQLITE_CORRUPT, indicating that your database is corrupt. > > Thanks & Regards > Lalit Kumar Choudhary > Software Engineer > L Integrated Engineering Services > KIADB, Hebbal Industrial Area > Hootagalli, Mysore 570018, Karnataka > Mob +91 9731003527 > > > > > > > Larsen & Toubro Limited > > www.larsentoubro.com > > This Email may contain confidential or privileged information for the > intended recipient (s) If you are not the intended recipient, please do not > use or disseminate the information, notify the sender and delete it from > your system. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite crash info
On Sun, Jan 1, 2012 at 4:49 PM, Lalitkumar Choudhary < lalitkumar.choudh...@lnties.com> wrote: > ...Sqlite database will crash if you write some garbage value into the > file. May i know exactly what is the garbage value? Is it any value > different from datatype or anything else, can u please give one example? > That wording does not mean a specific value, but is intended to mean something like "if you modify the database file from outside the sqlite3 API, results are undefined" where "undefined" means "almost certainly corruption." For example: echo "123" >> mydbfile that could effectively corrupt it even though it doesn't actually modify any bytes used by the db. (Whether or not that _does_ corrupt it depends largely on how sqlite3 tracks the logical end-of-file.) -- - stephan beal http://wanderinghorse.net/home/stephan/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] sqlite crash info
Hi, I want to know one thing about sqlite crashing, you had mentioned in your document which i had found in your website(www.sqlite.org). Sqlite database will crash if you write some garbage value into the file. May i know exactly what is the garbage value? Is it any value different from datatype or anything else, can u please give one example? Thanks & Regards Lalit Kumar Choudhary Software Engineer L Integrated Engineering Services KIADB, Hebbal Industrial Area Hootagalli, Mysore 570018, Karnataka Mob +91 9731003527 Larsen & Toubro Limited www.larsentoubro.com This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users