diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-02-20 19:50:39 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-04-05 15:02:57 +0400 |
commit | 915c5df865909b6801d6b5f43a48a5998a2e0de5 (patch) | |
tree | cb6bef5294fcef61cbe0b3490a16b11897f37b10 /mysql-test/suite/compat/oracle/t/exception.test | |
parent | 99df09ecaba6b889330f987fbf8adcca88ebcd70 (diff) | |
download | mariadb-git-915c5df865909b6801d6b5f43a48a5998a2e0de5.tar.gz |
MDEV-12088 sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause
Diffstat (limited to 'mysql-test/suite/compat/oracle/t/exception.test')
-rw-r--r-- | mysql-test/suite/compat/oracle/t/exception.test | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/t/exception.test b/mysql-test/suite/compat/oracle/t/exception.test index 07061abb6bc..6448a6ef627 100644 --- a/mysql-test/suite/compat/oracle/t/exception.test +++ b/mysql-test/suite/compat/oracle/t/exception.test @@ -431,3 +431,27 @@ DROP FUNCTION f1; --echo # --echo # End of MDEV-10587 sql_mode=ORACLE: User defined exceptions --echo # + +--echo # +--echo # MDEV-12088 sql_mode=ORACLE: Do not require BEGIN..END in multi-statement exception handlers in THEN clause +--echo # +CREATE TABLE t1 (a INT PRIMARY KEY); +INSERT INTO t1 VALUES (10),(20),(30); +DELIMITER $$; +CREATE PROCEDURE p1(a INT) AS +BEGIN + INSERT INTO t1 (a) VALUES (a); +EXCEPTION + WHEN DUP_VAL_ON_INDEX THEN + a:= a+1; + INSERT INTO t1 VALUES (a); + WHEN OTHERS THEN + NULL; + NULL; +END; +$$ +DELIMITER ;$$ +CALL p1(30); +SELECT * FROM t1; +DROP PROCEDURE p1; +DROP TABLE t1; |