diff options
| author | Alexander Barkov <bar@mariadb.com> | 2018-11-12 00:01:12 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2018-11-12 00:01:12 +0400 |
| commit | 7f4aee22335c24a410d59978bf1cf20fc3fe90e3 (patch) | |
| tree | 8adb827acaab033d4537ece20747cff11f4d5eff /mysql-test/suite/compat | |
| parent | f5855ba03deef188516453b71e56d4239f74a653 (diff) | |
| download | mariadb-git-7f4aee22335c24a410d59978bf1cf20fc3fe90e3.tar.gz | |
MDEV-17666 sql_mode=ORACLE: Keyword ELSEIF should not be reserved
Diffstat (limited to 'mysql-test/suite/compat')
| -rw-r--r-- | mysql-test/suite/compat/oracle/r/parser.result | 14 | ||||
| -rw-r--r-- | mysql-test/suite/compat/oracle/t/parser.test | 23 |
2 files changed, 37 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/r/parser.result b/mysql-test/suite/compat/oracle/r/parser.result index 4ee34e5e2b3..7540763696f 100644 --- a/mysql-test/suite/compat/oracle/r/parser.result +++ b/mysql-test/suite/compat/oracle/r/parser.result @@ -532,3 +532,17 @@ BEGIN NULL; END; / +# +# MDEV-17666 sql_mode=ORACLE: Keyword ELSEIF should not be reserved +# +DECLARE +ELSEIF INT; +BEGIN +ELSEIF:=1; +END; +/ +BEGIN +<<ELSEIF>> +NULL; +END; +/ diff --git a/mysql-test/suite/compat/oracle/t/parser.test b/mysql-test/suite/compat/oracle/t/parser.test index b3387b3f922..dabd7956c44 100644 --- a/mysql-test/suite/compat/oracle/t/parser.test +++ b/mysql-test/suite/compat/oracle/t/parser.test @@ -316,3 +316,26 @@ BEGIN END; / DELIMITER ;/ + + +--echo # +--echo # MDEV-17666 sql_mode=ORACLE: Keyword ELSEIF should not be reserved +--echo # + +DELIMITER /; +DECLARE + ELSEIF INT; +BEGIN + ELSEIF:=1; +END; +/ +DELIMITER ;/ + +DELIMITER /; +BEGIN +<<ELSEIF>> + NULL; +END; +/ +DELIMITER ;/ + |