main.signal_code fails

Bug #746513 reported by Alexey Kopytov on 2011-03-31
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
percona-projects-qa
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

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  Edit
Everyone can see this information.

Other bug subscribers