Errata

Using SQLite

Errata for Using SQLite

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
PDF
Page xv
Last paragraph

First sentence includes "book coves SQLite". Probably wants "covers" instead of "coves".

Note from the Author or Editor:
Typo verified in DocBook XML.

Resolution: In section id="I_sect1_d1e150", change "coves" to "covers" in first sentience of first paragraph.

spiceisland  Aug 31, 2010 
PDF
Page 25
Last paragraph

Last sentence refers reader to Appendix A for a "complete list of all the sqlite3 command-line options and dot-commands".

This should refer to Appendix B.

Note from the Author or Editor:
Verified in the source DocBook XML. At the end of the last sentience in paragraph id="ch03_id2312457", the XREF "linkend" attribute is "ap_build_id". It should be "ap_cli_id".

spiceisland  Sep 03, 2010 
PDF
Page 34
5th paragraph

Last sentence states "Rather, SQLite depends on datatype
permissions to define who can open and access a database."

Shouldn't this say "filesystem" instead of "datatype" ?

This would then match up with the "Access Control" section on page 14.

Note from the Author or Editor:
Verified in the source DocBook XML. In paragraph id="ch04_id2316405", the last sentience, "SQLite depends on datatype permissions to define who can open and access a database.", should be:

"SQLite depends on filesystem permissions to define who can open and access a database."

spiceisland  Sep 03, 2010 
PDF
Page 42
3rd paragraph

Fourth sentence seems to be garbled or missing a word(s):

"Any result column that is a direct column reference will inherit the column?s affinity, but and all columns are given a NONE affinity."

"... but and all ..." ?

Note from the Author or Editor:
Verified in the DocBook XML. In paragraph id="ch04_id2304845", the sentience:

Any result column that is a direct column reference will inherit the column's affinity, but and all columns are given a NONE affinity.

Should be:

Any result column that is a direct column reference will inherit the column's affinity, but all other columns are given a NONE affinity.

spiceisland  Sep 07, 2010 
PDF
Page 58
4th paragraph

The 4th sentence begins "Most of the time, SQLite deviates from the standard, it does so in an attempt to ...".

This makes it sound like SQLite deviates from the standard most of the time ?!

Perhaps "Most of the time, when SQLite deviates from the standard, it does so in an attempt to ..." would be better ?

Note from the Author or Editor:
Verified in DocBook XML. In paragraph id="ch04_id2344950", the sentience "Most of the time, SQLite deviates from the standard, it..." would make more sense as "Most of the time when SQLite deviates from the standard, it...." I'm not sure if the comma should be retained or not. I want to say not.

spiceisland  Sep 09, 2010 
PDF
Page 68
3rd line

"in the cause of a self-join"

cause -> case

Note from the Author or Editor:
Verified in the DocBook XML. In paragraph id="ch05_id2331258" the phrase:
"...in the cause of a self-join..."

should be:
"...in the case of a self-join..."

Anonymous  Sep 08, 2010