The Art of SQL Confirmed Errata

Errata

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 "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

Version	Location	Description	Submitted By	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 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 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 2008
Other Digital Version	92 Last line of first SQL example	"and a.ordered >= somefunc" should read "and o.ordered >= somefunc"	Anonymous	May 2008