Errata

The Art of SQL

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