main.signal_code fails

Bug #746513 reported by Alexey Kopytov
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
Fix Released
Undecided
Alexey Kopytov

Bug Description

I get the following failure in 5.5.10:

main.signal_code [ fail ]
        Test ended at 2011-03-31 19:35:18

CURRENT_TEST: main.signal_code
--- /Users/kaa/src/percona/5.5/Percona-Server/mysql-test/r/signal_code.result 2011-03-09 18:11:39.000000000 +0300
+++ /Users/kaa/src/percona/5.5/Percona-Server/mysql-test/r/signal_code.reject 2011-03-31 18:35:18.000000000 +0300
@@ -20,16 +20,16 @@
 end $$
 show procedure code signal_proc;
 Pos Instruction
-0 stmt 131 "SIGNAL foo"
-1 stmt 131 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
-2 stmt 132 "RESIGNAL foo"
-3 stmt 132 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
+0 stmt 132 "SIGNAL foo"
+1 stmt 132 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
+2 stmt 133 "RESIGNAL foo"
+3 stmt 133 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
 drop procedure signal_proc;
 show function code signal_func;
 Pos Instruction
-0 stmt 131 "SIGNAL foo"
-1 stmt 131 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
-2 stmt 132 "RESIGNAL foo"
-3 stmt 132 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
+0 stmt 132 "SIGNAL foo"
+1 stmt 132 "SIGNAL foo SET MESSAGE_TEXT = "This i..."
+2 stmt 133 "RESIGNAL foo"
+3 stmt 133 "RESIGNAL foo SET MESSAGE_TEXT = "This..."
 4 freturn 3 0
 drop function signal_func;

mysqltest: Result content mismatch

Related branches

Revision history for this message
Alexey Kopytov (akopytov) wrote :

The reason for this failure is show_temp.patch. It adds a new command, SQLCOM_SHOW_TEMPORARY_TABLES *before* SQL_COM_SIGNAL and SQL_COM_RESIGNAL, so those commands get new numeric codes as compared to the upstream server.

The solution is to move SQLCOM_SHOW_TEMPORARY_TABLES after all commands from the upstream server.

Changed in percona-projects-qa:
assignee: nobody → Alexey Kopytov (akopytov)
status: New → Fix Committed
Changed in percona-projects-qa:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.