Jerry Krinock wrote: > On 2014 Jun 23, at 21:49, Igor Tandetnik <i...@tandetnik.org> wrote: >> The data corruption happens to affect the area of the file where >> this index is stored. > > The culprit is byte 2048, the first byte in the 3rd page. In the Good > file, it is 0x0A and in the Bad file, itÂ’s 0x0D.
<http://www.sqlite.org/fileformat2.html#cell_payload> says: | B-tree Page Header Format: Offset: 0, Size: 1, Description: | A flag indicating the b-tree page type [...] A value of 10 means the | page is a leaf index b-tree page. A value of 13 means the page is | a leaf table b-tree page. So the bad index claims to be a table. > looks like a Mac vs. Unix line ending clash. Is there any other 0x0A byte in the good file? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
