Bug #48722 SIGNAL/RESIGNAL usage and error nos. not documented ?
Submitted: 12 Nov 2009 10:36 Modified: 25 Nov 2010 10:35
Reporter: Nidhi Shrotriya Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.5.0 OS:Any
Assigned to: CPU Architecture:Any
Tags: mysql-next-mr

[12 Nov 2009 10:36] Nidhi Shrotriya
Description:
Test that uses SIGNAL/RESIGNAL functionality fails due to Result mismatch as the below error nos. seem to have changed. 
1780 to 1644
1778 to 1642
1781 to 1645

Though none of these error messages are seen in documentation available for 5.4.
Earlier msg nos. were 1778, 1780, 1781 as test expects. 
If the error nos. are changed atleast the right ones should be documented. 

 SHOW ERRORS;
 Level	Code	Message
-Error	1780	Unhandled user-defined exception condition
+Error	1644	Unhandled user-defined exception condition

 Warnings:
-Warning	1778	Unhandled user-defined warning condition
+Warning	1642	Unhandled user-defined warning condition

 SHOW ERRORS;
 Level	Code	Message
-Error	1781	RESIGNAL when handler not active
+Error	1645	RESIGNAL when handler not active

How to repeat:
As mentioned in the description.
[12 Nov 2009 11:36] Valeriy Kravchuk
Can you, please, provide a complete test case (or reference to its name in the test suite) that demonstrates the problem.
[12 Nov 2009 11:42] Valeriy Kravchuk
Also I do NOT see SIGNAL/RESIGNAL documented in current 5.4 manual. Can you give me URL to the page that explains their usage and/or error numbers for them?
[23 Nov 2009 5:58] Nidhi Shrotriya
Yes, you're right. 
SIGNAL/RESIGNAL usage doc. too is not available in 5.4 reference manual.
I have referred it from 6.0 reference manual while creating the test. 
So we need the up-to-date documentation.
[23 Nov 2009 16:36] Valeriy Kravchuk
SIGNAL/RESIGNAL are planned for MySQL 5.5, so why should we have them documented in MySQL 5.4 manual? 

I think proper status for this report is "To be fixed later".
[24 Dec 2009 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[25 Jan 2010 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[25 Nov 2010 10:35] Nidhi Shrotriya
Was included in Docs.