Known errata are listed by printing date below. If you find a mistake that is not listed below, please report it by filling in the errata reporting form!
The date of printing is written on the backside of the first sheet ("copyright page") on the bottom right.
| Printing | Page | Paragraph | Description |
|---|---|---|---|
| 2012-07-13, 2012-11-15 | 47 | 3(2x), 4 | "full- text search" |
| 2012-07-13, 2012-11-15 | 2 | 1 |
"…for the |
| 2012-07-13, 2012-11-15 | 3 | 1 | "…is stored in a database block…" (missing 'a') |
| 2012-07-13 | 3 | last |
…column 2)… (poorly placed line break) |
| 2012-07-13, 2012-11-15 | 5 | last |
"…greater than or equal to (>=) |
| 2012-07-13 | 6 | 2 |
“degenerated index |
| 2012-07-13 | 6 | 3 |
“57 |
| 2012-07-13, 2012-11-15 | 7 | 4 |
"Databases |
| 2012-07-13, 2012-11-15 | 8 | 3 |
"This is the fall |
| 2012-07-13, 2012-11-15 | 12 | 5 |
"…into accountSUBSIDARY_ID…" (em-dash instead of comma, missing comma) |
| 2012-07-13, 2012-11-15 | 13 | 1 |
"…the database can use an INDEX …" |
| 2012-07-13, 2012-11-15 | 14 | 4 | "two-column index" (hyphen missing, two times) |
| 2012-07-13, 2012-11-15 | 15 | 2 |
SELECT <INDEX |
| 2012-07-13, 2012-11-15 | 16 | 5 | "two-index solution" and "single-index solution" (missing hypens) |
| 2012-07-13, 2012-11-15 | 18 | 1 |
"…considered |
| 2012-07-13, 2012-11-15 | 18 | 2 |
"—regardless |
| 2012-07-13, 2012-11-15 | 18 | 4 |
"Cost-b |
| 2012-07-13, 2012-11-15 | 18 | 5 |
"Rule-b |
| 2012-07-13, 2012-11-15 | 19 | 1 | "…as the cause for…" |
| 2012-07-13, 2012-11-15 | 20 | 6 |
"…operation |
| 2012-07-13, 2012-11-15 | 21 | 2 |
"…one for each employee |
| 2012-07-13, 2012-11-15 | 22 | 1 | "…(again, see Example…" (missing comma) |
| 2012-07-13, 2012-11-15 | 24, 25-27, 28, 31 | (various) | "function-based index[es|ing]" (missing hypen, generally) |
| 2012-07-13, 2012-11-15 | 25 | last | "right-hand side" (missing hyphen) |
| 2012-07-13, 2012-11-15 | 28 | 2 |
"updat |
| 2012-07-13, 2012-11-15 | 29 | 6 | "…42-year-old…" (hyphens missing) |
| 2012-07-13, 2012-11-15 | 30 | last | "…42-year-old…" (hyphens missing) |
| 2012-07-13, 2012-11-15 | 31 | 1 | "Over-Indexing" (hyphen missing). |
| 2012-07-13, 2012-11-15 | 31 | 2 | "…case-insensitive…" (hyphen missing) |
| 2012-07-13, 2012-11-15 | 31 | 4 |
"We could,…, but that |
| 2012-07-13, 2012-11-15 | 31 | 4 | "…the same function throughout your application." |
| 2012-07-13, 2012-11-15 | 32 | 1 |
"This section covers a topic that is skipped in most SQL textbooks |
| 2012-07-13 | 35 | 2 | Database vendors try to solve… (missing word). |
| 2012-07-13, 2012-11-15 | 35 | 4 | "Unevenly distributed status codes…" (missing 's') |
| 2012-07-13, 2012-11-15 | 35 | penultimate |
"…if in |
| 2012-07-13, 2012-11-15 | 36-38 | multiple |
"Without bind parameters."
" |
| 2012-07-13, 2012-11-15 | 37 | 5 | "See: Programming the Perl DBI." |
| 2012-07-13, 2012-11-15 | 38 | 6 | "…an “at” symbol…" (missing quotes) |
| 2012-07-13, 2012-11-15 | 40 | 4 |
"The start and stop conditions |
| 2012-07-13, 2012-11-15 | 40 | last |
"The ordering of SUBSIDIARY_ID |
| 2012-07-13, 2012-11-15 | 41 | last |
"…is sorted according to the second column |
| 2012-07-13 | 43 | 4 | "…the database tells us how…" (missing 's') |
| 2012-07-13, 2012-11-15 | 44 | 6 |
"…specify the upper and lower bounds in |
| 2012-07-13, 2012-11-15 | 45 | 1 | "…that can be indexed very well, but others can not." |
| 2012-07-13, 2012-11-15 | 45 | 4 |
"…two predicate |
| 2012-07-13, 2012-11-15 | 45 | 4 | "…as an access predicate; (2) the other characters as a filter predicate." |
| 2012-07-13, 2012-11-15 | 46 | 2, last | "…as an access predicate." |
| 2012-07-13, 2012-11-15 | 46 | 3 | "non-matching" |
| 2012-07-13, 2012-11-15 | 47 | 2 |
"…has to guess |
| 2012-07-13 | 48 | last | "…at the beginning of the search term…" |
| 2012-07-13 | 49 | 6 |
" |
| 2012-07-13 | 50 | last | "…are almost unusable for…" |
| 2012-07-13, 2012-11-15 | 51 | 7 | "two-column index" (missing hyphen) |
| 2012-07-13 | 62 | 3 | "…yesterday's sales." (ampersand missing) |
| 2012-07-13, 2012-11-15 | 62, 66 | 4,10 |
"IN |
| 2012-07-13 | 82 | 3 |
"…the cost values reflect |
| 2012-07-13 | 87 | 1 |
"More often tha |
| 2012-07-13 | 87 | 3 | "… new car models consistently going twice as fast…" |
| 2012-07-13 | 88 | last |
"…because "…because the additional complexity might accumulate more latencies." |
| 2012-07-13 | 90 | 2 | "…storage technology that uses no…" (missing 's') |
| 2012-07-13, 2012-11-15 | 97 | 4 |
q |
| 2012-07-13 | 106 | 4 | "…fetch all employee details via prefetch…" |
| 2012-07-13, 2012-11-15 | 112 | 3 |
"Index Filter |
| 2012-07-13 | 115 | penultimate |
"…can be use |
| 2012-07-13 | 124 | Fig 5.2 | Figure shows dates in the year 2011, although text refers to 2012. |
| 2012-07-13, 2012-11-15 | 152 | 5 |
OR "SALE_ID"<TO_NUMBER( |
| 2012-07-13, 2012-11-15 | 153 | 6 |
" |
| 2012-07-13 | 159 | 1 | "It supports data manipulation as well." (missing 's') |
| 2012-07-13 | 163 | 3 |
“deleted |
| 2012-07-13 | 171 | 1 |
|
| 2012-07-13 | 178 | 5 |
“Index Cond |
| 2012-07-13, 2012-11-15 | 178 | 5 |
"—regardless |
| 2012-07-13 | 180 | 3 |
|
| 2012-07-13 | 188 | 6 |
|
| 2012-07-13, 2012-11-15 | 188 | 6 |
"The meaning of the type value |
| 2012-07-13 | 189 | 5 |
|
| 2012-07-13 | 190 | 2 |
“using filesort |
If you find a mistake that is not listed above, please report it by filling in the errata reporting form!