diff options
Diffstat (limited to 'mysql-test/suite/compat/oracle/t/type_varchar2.test')
-rw-r--r-- | mysql-test/suite/compat/oracle/t/type_varchar2.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/suite/compat/oracle/t/type_varchar2.test b/mysql-test/suite/compat/oracle/t/type_varchar2.test new file mode 100644 index 00000000000..bd0243713b6 --- /dev/null +++ b/mysql-test/suite/compat/oracle/t/type_varchar2.test @@ -0,0 +1,19 @@ +SET sql_mode=ORACLE; + +# VARCHAR2 is not a reserved word even in sql_mode=ORACLE +CREATE TABLE varchar2 (varchar2 INT); +SHOW CREATE TABLE varchar2; +DROP TABLE varchar2; + +CREATE TABLE t1 (a VARCHAR2(10)); +SHOW CREATE TABLE t1; +DROP TABLE t1; + + +--echo # +--echo # MDEV-11275 sql_mode=ORACLE: CAST(..AS VARCHAR(N)) +--echo # + +SELECT CAST(123 AS VARCHAR2(10)) FROM DUAL; +--error ER_PARSE_ERROR +SELECT CAST(123 AS VARCHAR2) FROM DUAL; |