Errata for The Art of SQL
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 |
| Printed |
Page 40
Table 2-2 |
Table 2.2 does not agree with the commentary. The table says that squeeze1/squeeze3
= .86/.39 (= 2.2), and squeeze1/squeeze2 = .86/.48 (= 1.8), but the commentary say
squeeze3 is 1.8 times as fast, and squeeze2 is 2.2 times as fast. Either the table
or the commentary is backwards.
AUTHOR'S RESPONSE:
THE TEXT IS CORRECT,
THE TABLE ISN'T.
I have rerun the test (I still have the scripts). The fastest routine
(by a small margin) is actually squeeze2.
The times in table 2-2 have been permuted and there should be 0.39
seconds for squeeze2 and 0.48 seconds for squeeze3.
|
Anonymous |
|
May 01, 2008 |
| Other Digital Version |
40
Table 2-2 |
Table 2.2 does not agree with the commentary. The table says that squeeze1/squeeze3
= .86/.39 (= 2.2), and squeeze1/squeeze2 = .86/.48 (= 1.8), but the commentary say
squeeze3 is 1.8 times as fast, and squeeze2 is 2.2 times as fast. Either the table
or the commentary is backwards.
AUTHOR'S RESPONSE:
THE TEXT IS CORRECT,
THE TABLE ISN'T.
I have rerun the test (I still have the scripts). The fastest routine
(by a small margin) is actually squeeze2.
The times in table 2-2 have been permuted and there should be 0.39
seconds for squeeze2 and 0.48 seconds for squeeze3.
|
Anonymous |
|
May 01, 2008 |
| Printed |
Page 91
figure 4-5 |
The primary key of table "orders" should be "ordid" instead of "ordtid".
|
Anonymous |
|
|
| Printed |
Page 92
Last line of first SQL example |
"and a.ordered >= somefunc"
should read
"and o.ordered >= somefunc"
|
Anonymous |
|
May 01, 2008 |
| Other Digital Version |
92
Last line of first SQL example |
"and a.ordered >= somefunc"
should read
"and o.ordered >= somefunc"
|
Anonymous |
|
May 01, 2008 |
| Printed |
Page 239
Paragraph under "Contention", second sentence |
"Exactly the same statements where (sic) executed and committed." Should be: "were"
|
Anonymous |
Feb 20, 2012 |
|
