Errata
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted by | Date submitted |
---|---|---|---|---|
Page 40 2nd paragraph |
"mark at least one column from each PRIMARY KEY as NOT NULL." |
Anonymous | Aug 26, 2010 | |
Printed, PDF, ePub, Mobi, , Other Digital Version | Page 56 |
While browsing through your excellent book "Using SQLite" ISBN:9781449394592 under the "Save-Points" section I noticed some example sql inserts that specified "values" without parentheses, such as: |
Adam Zaremba | Feb 21, 2013 |
Page 65 Figure 5-2 |
In the result of the INNER JOIN, the 3rd row reads |
Anonymous | Jan 13, 2011 | |
Printed | Page 65 Figure 5.2 |
In the joined table in Fig 5.2, column D contains the value 7.3. This should be 2.3. Table 5.3 on P67 has the same problem. |
Tim Streater | Oct 25, 2011 |
Printed | Page 65 Paragraph after Fig 5-2. |
Author used C and D to denotes numbers of columns. As Fig 5-2 has columns named C and D, this was briefly confusing. I would suggest using x and y rather than C and D. |
Tim Streater | Oct 25, 2011 |
Page 65 Figure 5.2; note pdf version is page 87 of 528 |
In figure 5.2, the 4th column, 3rd record (of 4) the value is 7.3. It should be 2.3. |
Jim Kay | Jan 12, 2014 | |
Page 78 1st paragraph |
Last sentence reads "... the expressions present in any ORDER BY clause must be exactly match one of the result columns ..." Note from the Author or Editor: |
spiceisland | Sep 15, 2010 | |
Page 120 Last line |
The "(SQLITE_READWRITE | SQLITE_CREATE)." in the last line should be changed to "(SQLITE_OPEN_READWRITE | SQLITE_OPEN_CREATE).". |
Anonymous | Sep 23, 2010 | |
Printed | Page 438 description of "name" parameter |
The description of the "name" parameter currently reads "The name of the collation ..."; I believe the word "collation" should perhaps be replacewd with "function". If not, what does sqlite3_create_function have to do with collations? (This is probably a copy & paste error.) |
Richard H. Gumpertz | Dec 17, 2021 |
Printed | Page 471 Definition section of sqlite_rollback_hook() |
Provided description of function is: |
Dennis Amundson | Jan 12, 2013 |
ePub | Page 1313 Start of description... |
“group_concat() — Concatenate row values |
Paul Adams | Mar 09, 2015 |