We try to keep our books accurate, but sometimes mistakes creep in. This page lists the errors submitted by our astute readers. If you've found a new error, please submit it.

The latest version of the book is P3.0, released about 2 years ago. If you've bought a PDF of the book and would like to upgrade it to this version (for free), visit your home page.

Key: Typo Tech. Error Suggestion Not a problem Next edition

By default this page displays the errata for the latest version of the book. If you have a previous version, select it here:  

(To find out what version you have, look at the copyright page, a few pages in from the front of the book. If it says (say) 'Second Printing', then here it'll be P2.0. If there are interim PDF releases in that printing, they'll be 2.1, 2.2, and so on.)

PDF Paper Description Found in Fixed in
15
#49748: By default, MySQL does not allow '||' as string concatenation operator but works like 'Logical OR' operator. So MySQL users should use CONCAT ...more...
P3.0
28-Aug-12
27
#49745: Column 'author' is FK with NOT NULL referencing Account table. Column 'comment_date' is NOT NULL. Reply author may not be 'Kukla' but 'Ollie...more...
P3.0
28-Aug-12
32
#49746: Ditto with p.27. Column 'author' is FK with NOT NULL referencing Account table. Column 'comment_date' is NOT NULL. In code file Trees/sol...more...
P3.0
28-Aug-12
32
#49749: MySQL causes ERROR 1093 (HY000) on UPDATE when running Trees/soln/path-enum/insert.sql. ========== mysql> UPDATE Comments -> SET pat...more...
P3.0
28-Aug-12
33
#49750: TYPO in table name. Should be 'Comments'. TYPOs are in p.33: Trees/soln/nested-sets/ancestors.sql p.34: Trees/soln/nested-sets/depth.sql...more...
P3.0
28-Aug-12
34
#49755: First query reports depth = 4 and second query reports depth = 3 TYPO in table name. Should be 'Comments' (as I reported in #49750). In co...more...
P3.0
28-Aug-12
35
#49747: Column 'author' is FK with NOT NULL referencing Accounts table. Column 'bug_id' is FK with NOT NULL referencing Bugs table. Column 'comment_...more...
P3.0
28-Aug-12
35
#49756: For immediate parent search, parent.sql in p.35 returns empty set. Should use > and < instead of BETWEEN since > and < are exclusive. TYPO i...more...
P3.0
28-Aug-12
106
#49752: Missing comma after "resolution VARCHAR(1000)". In code file Metadata-Tribbles/soln/separate-fixed-length.sql: ========== CREATE TABLE ...more...
P3.0
28-Aug-12
128
#49753: Missing comma after "account_id SERIAL PRIMARY KEY". In code file Phantom-Files/anti/create-accounts.sql: ========== CREATE TABLE Accou...more...
P3.0
28-Aug-12
246
#49754: Wrong variable name '$dbh' In code file See-No-Evil/anti/no-check.php: ========== ... ② $stmt = $dbh->prepare($sql); ... ========== ...more...
P3.0
28-Aug-12
413
#49707: Appendix 1.1; Figure 26 (Third Normal Form). Table Accounts has tuple {Moe, moe@example.com} repeated. A typo, but technically violates PK {ac...more...
P3.0
16-Aug-12

Stuff To Be Considered in the Next Edition

PDF Paper Description Found in Fixed in
168
#48485: The book recommends to use separate queries for achieving the goal ("Follow the Single-Value Rule to avoid ambiguous query result"). Sugges...more...
Bill Karwin says: Using windowing functions is a valid solution, thanks for the suggestion. But unfortunately space restrictions prevent me from adding another solution to the chapter.
P2.0
10-Jan-12