FWIW
Quote:
Originally Posted by j.p.s
...
Argh, I'm just now figuring out the value in the id column of the excerpt table is not related to the value of the id column of the entity table. It does look like the numbers in the related entries column are the id values in the entity column (seems to be the case in other books). In that case, all the values are from 777 through 809 (far too few), but entity they run 1 to 776, so no excerpt can ever be found.
|
Yep, sounds reasonable.
Quote:
Originally Posted by j.p.s
...
I am convinced that the XRAY.entities.B00JCDK5ME.asc currently being delivered by Amazon is very broken.
Thanks.
|
Me too.
Quote:
Originally Posted by j.p.s
I have tried two more experiments...
|
I have repeated your experiments.
Code:
Microsoft Windows [version 6.1.7601]
Copyright (c) 2009 Microsoft Corporation. Tous droits réservés.
sqlite3 XRAY.entities.B00JCDK5ME.asc
SQLite version 3.23.1 2018-04-10 17:39:29
Enter ".help" for usage hints.
sqlite> .output B00JCDK5ME.sql
sqlite> .dump
sqlite> .exit
dir B00JCDK5ME.sql
2018-04-26 20:07 548,088 B00JCDK5ME.sql
1 fichier(s) 548,088 octets
md5sum B00JCDK5ME.sql
dcfbcf7ae6771fd122c781f28da30185 B00JCDK5ME.sql
The 3 first lines of my B00JCDK5ME.sql have Unix "LF" newlines,
the 3032 next lines have Windows "CR LF" newlines, and
the last line 3036 terminates with no newline.
Different size and MD5.