diff options
Diffstat (limited to 'mysql-test/suite/compat/oracle/r/sp.result')
| -rw-r--r-- | mysql-test/suite/compat/oracle/r/sp.result | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/r/sp.result b/mysql-test/suite/compat/oracle/r/sp.result index f0a7d2808f1..7f042825385 100644 --- a/mysql-test/suite/compat/oracle/r/sp.result +++ b/mysql-test/suite/compat/oracle/r/sp.result @@ -166,6 +166,13 @@ IF a=10 THEN NULL; ELSE NULL; END IF; END; / DROP PROCEDURE p1; +# Keywords that are OK for table names, but not for SP variables +CREATE TABLE function (function int); +INSERT INTO function SET function=10; +SELECT function.function FROM function; +function +10 +DROP TABLE function; # Testing that (some) keyword_sp are allowed in Oracle-style assignments CREATE PROCEDURE p1 (action OUT INT) AS BEGIN action:=10; END;/ DROP PROCEDURE p1/ |