1. In the following, s/less than/less than or equal to/
"""
2.3.3.4 Index B-Tree Cell Format
[snip 2 paragraphs]
If the record is small enough, it is stored verbatim in the cell. A
record is deemed to be small enough to be completely stored in the cell
if it consists of less than:
max-local := (usable-size - 12) * max-embedded-fraction / 255 - 23
bytes.
"""
2. The formula in the following is incorrect.
"""
[H31190] When a table B-Tree cell is stored partially in an overflow
page chain, the prefix stored on the B-Tree leaf page consists of the
two variable length integer fields, followed by the first N bytes of the
database record, where N is determined by the following algorithm:
min-local := (usable-size - 12) * 255 / 32 - 23
"""
It should be:
min-local := (usable-size - 12) * 32 / 255 - 23
3. In description of first 100 bytes of file: """The number of unused
bytes on each page (single byte field, byte offset 20), is always set to
0x01.""" ... should be 0x00.
4. In section 2.3.2 Database Record Format, in the table describing
type/size codes:
"""Even values greater than 12 are used to signify a blob of data (type
SQLITE_BLOB) (n-12)/2 bytes in length, where n is the integer value
stored in the record header."""
s/greater than/greater than or equal to/
5. In section 2.3.1 Variable Length Integer Format, in the examples
"""
Decimal Hexadecimal Variable Length Integer
[snip]
-78056 0xFFFFFFFFFFFECD56 0xFF 0xFF 0xFF 0xFF 0xFF 0xFF 0xFD 0xCD 0x56
"""
s/78056/78506/
6. In description of sqlite_master:
"""[H30300] If the associated database table is a virtual table, the
fourth field of the schema table record shall contain an SQL NULL value."""
Looks like an integer zero to me:
DOS-prompt>sqlite3
SQLite version 3.6.14
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create virtual table foo using fts3(yadda yadda);
sqlite> select typeof(rootpage),* from sqlite_master where name = 'foo';
integer|table|foo|foo|0|CREATE VIRTUAL TABLE foo using fts3(yadda yadda)
Cheers,
John
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
