Errata

MySQL Stored Procedure Programming

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

SOUCE should be SOURCE

 Anonymous