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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users