>
Thanks very much for catching these. Document is now updated with the fixes in the fossil docsrc repository. Dan. > 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: _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users