Errata for MySQL Stored Procedure Programming
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 11
Example 1-5, line 14 |
Line 14 of code is missing underscore:
1 dupkey_indicator should read: 1_dupkey_indicator
Also, in example downloads, Example 1-5 file is the 1-6 code.
|
Anonymous |
|
|
| Printed |
Page 134
Table 6-1 |
MySQL error code 1312 states: 'SELECTin a storedprogram must have INTO', whereason p.
112, last paragraph but one, the text reads: '... result set is not associated with
either an INTGO clause or a cursor. We call ... unbounded.'
Contradiction?
Author's response:
The error code concerned has been reworded since that table was constructed
and now reads "PROCEDURE %s can't return a result set in the given
context". This occurs when the client program has not provided the
CLIENT_MULTI_RESULTS flag during the initial connection.
|
Anonymous |
|
|
| Printed |
Page 137
1st paragraph |
"So, for instance, in Example 6-9, the first handler will be invoked if something catastrophic
happens...while the second will fire..."
should be:
"So, for instance, in Example 6-9, the second handler will be invoked if something catastrophic
happens...while the first will fire..."
|
Anonymous |
|
|
| Printed |
Page 217
Table 9-1 |
The description of function 'DECODE' reads: 'Decrypts a string that has been
encrypted with ENCRYPT.'.
Should read:
'Decrypts a string that has been encrypted with 'ENCODE'.
|
Anonymous |
|
|
| Printed |
Page 423
First GRANT statement |
GRANT EXECUTE [ON {PROCEDURE|FUNCTION}] database.program_name TO user
should be:
GRANT EXECUTE ON [{PROCEDURE|FUNCTION}] database.program_name TO user
|
Anonymous |
|
|
| Printed |
Page 488
Figure 21-1 |
Switch legend for "index" and "no index" ("no index" should be lighter)
|
Anonymous |
|
|
| Printed |
Page 605
1st column, halfway down |
|
Anonymous |
|
|
