Errata
The errata list is a list of errors and their corrections that were found after the product was released.
The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.
Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update
Version | Location | Description | Submitted by | Date submitted |
---|---|---|---|---|
ePub | Page na SQL Statement Command Reference - Merge Statement Overview |
Sorry, I can't provide a detailed page reference as I can't see the page number in my software. |
Charlie Clark | Jun 17, 2013 |
Printed | Page 4 Figure 1-1` |
The table states that a Column can "contain one or many" DOMAIN and USER DEFINED TYPES. I have read elsewhere that every value in a column must be of the same type. Which is correct? |
Anonymous | Aug 22, 2010 |
Printed | Page 9 next to last paragraph, right before ANSI and Theta style SELECT examples |
Paragraph refers to "employee" base table and "jobs" base table, but SELECT examples are working with "authors" and "titleauthors" base tables. |
Patrick Marcell | Mar 22, 2011 |
Printed | Page 64 Bottom of page, Oracle example of using a list of values instead of a subquery |
I believe that in order to find all employees who have a job_lvl value equal to 9 -OR- 14, the example should be using the ANY or SOME operator, not the ALL operator, as it would not be possible for job_lvl to equal both 9 and 14 simultaneously. As I'm just learning SQL, perhaps I am wrong in my interpretation of the sample command? |
Patrick Marcell | Mar 22, 2011 |
Printed | Page 203 in the example, beginning with 'CREATE TRIGGER' |
In the example code, you have: |
Stephen Pilon | Oct 18, 2012 |
309 3rd paragraph (join type) under FULL OUTER JOIN and UNION JOIN |
This is how the section reads: |
Christoffer Swanstroem | Jan 11, 2012 | |
Printed | Page 417 5th paragraph query body |
Instead of query |
nazar | Apr 07, 2014 |
Printed, PDF | Page 422 MySQL section |
The book states that the Union SQL syntax in MySQL is "Not Supported." |
Anders Wallgren | Apr 01, 2011 |