diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-10-03 16:03:32 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-10-03 16:03:32 +0400 |
commit | c2d8db66be4e9a564fd3d199234a38e03035cb85 (patch) | |
tree | 0aefe84635708020d2355be3e2c5429ac2f938db /mysql-test/main/parser.test | |
parent | d168601e83dd69a229d43a577eddf2278def2bf6 (diff) | |
download | mariadb-git-c2d8db66be4e9a564fd3d199234a38e03035cb85.tar.gz |
MDEV-20735 Allow non-reserved keywords as user defined type names
Diffstat (limited to 'mysql-test/main/parser.test')
-rw-r--r-- | mysql-test/main/parser.test | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/main/parser.test b/mysql-test/main/parser.test index 2df25d4d02d..006f409e6b7 100644 --- a/mysql-test/main/parser.test +++ b/mysql-test/main/parser.test @@ -1582,5 +1582,45 @@ CREATE TABLE t1 (a DUAL); SELECT CAST(1 AS DUAL); --echo # +--echo # MDEV-20735 Allow non-reserved keywords as user defined type names +--echo # + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a ASCII); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS ASCII); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a LANGUAGE); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS LANGUAGE); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a CLOSE); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS CLOSE); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a NAMES); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS NAMES); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a END); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS END); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a GLOBAL); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS GLOBAL); + +--error ER_UNKNOWN_DATA_TYPE +CREATE TABLE t1 (a ACTION); +--error ER_UNKNOWN_DATA_TYPE +SELECT CAST(1 AS ACTION); + + +--echo # --echo # End of 10.5 tests --echo # |