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.
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
| Version |
Location |
Description |
Submitted By |
| Printed |
Page 1
mosql2_data.sql |
no data in LINE_ITEM table
|
Anonymous |
| Printed |
Page 5
Figure 1-1 |
Please refer the url below for the example.
http://examples.oreilly.com/mastorasql2/mosql2_data.sql
Error1:-
If you run the above script, it does not generate the part distributor model as mentioned in chapter 1 figure 1-1.
The foreign key and primary key contraints are missing in the script, hence only standalone tables are created.
Error2:
In the part distributor model, refer the diagram for the relationship between the employee and employee comment table, the association cardinality from employee to employee_comment is many to 1.
The actual cardinality should be 1(Employee) to Many(employee_comment) as per the foreign key contraint on the employee_comment table, refer the diagram in figure 1-1 chapter 1 page 5.
Please check the above errors.
Thanks in advance.
Rhushikesh.
|
Rhushikesh Velankar |
| Printed |
Page 54
bottom of page |
the select statement within the view should not include: "c.salesperson_id"
|
Anonymous |
| Printed |
Page 83
The first paragraph under the query |
The paragraph reads:
SELECT fname, lname
FROM employee
WHERE dept_id = 30 AND salary >= ALL
(SELECT salary
FROM employee
WHERE dept_id = 30);
The subquery returns the set of salaries for department 30, and the containing query checks each employee in the department to see if her salary is greater OR equal to every salary returned by the subquery.
Here is where the problem is:
Look at at the query it reads: WHERE dept_id = 30 AND salary >= ALL
So it is using an AND, and not an OR
but in the paragraph describing language it is refering it to as an OR, should that be changed to an AND ?
|
Anonymous |
| Printed |
Page 174
1st paragraph |
The alias "c1" is missing for the customer_known_good table.
|
Anonymous |
| Printed |
Page 174
1st paragraph |
The alias "c1" is missing for the customer_known_good table.
|
Anonymous |
| Printed |
Page 357
Code at top of page and description in bullet point 1. |
Code says:
FROM job j LEFT OUTER JOIN employee e ON e.job_id = j.job_id
Bullet says:
1. Connect an outer join from employee to job with employee as the required table.
This is in direct conflict with page 43 para 4 "In each case, the directional word, either LEFT or RIGHT, points toward the anchor table, the table that is required."
Also the example at the bottom of page 42 in bold is a bit confusing when the first example on 43 is the other way around...
|
Anonymous |
| Printed |
Page 374
last paragraph |
The insert statement should be:
insert into line_item
(order_nbr, part_nbr, qty)
select 7101, extractValue(extract(itm.column_value, '/item/part_number'),'/part_number'),
extractValue(extract(itm.column_value,'/item/quantity'),'/quantity')
from table(select xmlsequence(extract(po.purchase_order_doc,
'/purchase_order//item'))
from purchase_order po
where po.po_id = 1000) itm;
|
George Curran |
