summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-08-15 17:04:55 +0400
committerAlexander Barkov <bar@mariadb.org>2017-04-05 15:02:42 +0400
commit4940a91a5f57da21714b04dce77c425c2db6195c (patch)
tree47538e8481e6032f43799fe0d059e4e01b708bb8
parent81ba971d0334dee5dce880ea848300cc5ed45ccb (diff)
downloadmariadb-git-4940a91a5f57da21714b04dce77c425c2db6195c.tar.gz
A test clean-up for 7c78b27a33b749656cbc28091eac32bbbeee9e42
-rw-r--r--mysql-test/suite/compat/oracle/r/sp-code.result18
-rw-r--r--mysql-test/suite/compat/oracle/t/sp-code.test4
2 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/suite/compat/oracle/r/sp-code.result b/mysql-test/suite/compat/oracle/r/sp-code.result
index 56339e636c3..751549b7500 100644
--- a/mysql-test/suite/compat/oracle/r/sp-code.result
+++ b/mysql-test/suite/compat/oracle/r/sp-code.result
@@ -77,19 +77,14 @@ BEGIN
v:=123;
END;
BEGIN
-EXCEPTION
-WHEN 1002 THEN v:=225;
END;
/
SHOW PROCEDURE CODE p1;
Pos Instruction
0 hpush_jump 3 1 EXIT
1 set v@0 123
-2 hreturn 0 6
-3 hpush_jump 6 1 EXIT
-4 set v@0 225
-5 hreturn 0 6
-6 hpop 2
+2 hreturn 0 3
+3 hpop 1
set @v= 10;
CALL p1(@v);
SELECT @v;
@@ -104,14 +99,19 @@ BEGIN
v:=123;
END;
BEGIN
+EXCEPTION
+WHEN 1002 THEN v:=225;
END;
/
SHOW PROCEDURE CODE p1;
Pos Instruction
0 hpush_jump 3 1 EXIT
1 set v@0 123
-2 hreturn 0 3
-3 hpop 1
+2 hreturn 0 6
+3 hpush_jump 6 1 EXIT
+4 set v@0 225
+5 hreturn 0 6
+6 hpop 2
set @v= 10;
CALL p1(@v);
SELECT @v;
diff --git a/mysql-test/suite/compat/oracle/t/sp-code.test b/mysql-test/suite/compat/oracle/t/sp-code.test
index 229fc053c7e..ff78410540c 100644
--- a/mysql-test/suite/compat/oracle/t/sp-code.test
+++ b/mysql-test/suite/compat/oracle/t/sp-code.test
@@ -72,8 +72,6 @@ IS
v:=123;
END;
BEGIN
-EXCEPTION
- WHEN 1002 THEN v:=225;
END;
/
DELIMITER ;/
@@ -93,6 +91,8 @@ IS
v:=123;
END;
BEGIN
+EXCEPTION
+ WHEN 1002 THEN v:=225;
END;
/
DELIMITER ;/