main.signal_code fails
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/
+++ /Users/
@@ -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
Changed in percona-projects-qa: | |
assignee: | nobody → Alexey Kopytov (akopytov) |
status: | New → Fix Committed |
Changed in percona-projects-qa: | |
status: | Fix Committed → Fix Released |
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.