bzr push into mysql-6.0 tree (marc.alff:2653 to 2653) Bug#36510, Bug#8759

[Marc Alff]

------------------------------------------------------------
revno: 2653
revision-id: marc.alff@stripped
parent: marc.alff@stripped
committer: Marc Alff <marc.alff@stripped>
branch nick: mysql-6.0-36510
timestamp: Thu 2008-06-12 14:20:47 -0600
message:
  Bug#36510 (Stored Procedures: mysql_error_code 0 should be illegal)
  
  This fix is a follow up on Bug 8759.
  DECLARE HANDLER can catch exceptions using several syntaxes:
  - by SQLSTATE (SQL Standard)
  - by error number (MySQL)
  Catching succesful completion by error number, aka catching error 0,
  is illegal, and is now prevented.
  
  Also, the SQL standard defines the completion condition as a class of
  SQLSTATE, so that any state of class '00' and any subclass is a completion
  condition. Such completion conditions (for example, '00123') can not be
  caught by an exception handler in SQL.
modified:
  mysql-test/r/sp-error.result   sp1f-sperror.result-20030305184512-euxcpn3oxmcl4dn2kqbdx73ljcbivzto
  mysql-test/t/sp-error.test     sp1f-sperror.test-20030305184512-aipdocqcicc6rgsz672mr32qowtm5ceb
  sql/sp_pcontext.cc             sp1f-sp_pcontext.cc-20021208185920-hhym4pthccfaadi55gmaob4yvk7j5nw4
  sql/sql_yacc.yy                sp1f-sql_yacc.yy-19700101030959-wvn4qyy2drpmge7kaq3dysprbhlrv27j

Attachment: [text/text/x-diff] patch-2653.diff