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.result | |
| 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.result')
| -rw-r--r-- | mysql-test/main/parser.result | 31 |
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/main/parser.result b/mysql-test/main/parser.result index 53377142dbd..fa40ffa6942 100644 --- a/mysql-test/main/parser.result +++ b/mysql-test/main/parser.result @@ -1809,5 +1809,36 @@ ERROR HY000: Unknown data type: 'DUAL' SELECT CAST(1 AS DUAL); ERROR HY000: Unknown data type: 'DUAL' # +# MDEV-20735 Allow non-reserved keywords as user defined type names +# +CREATE TABLE t1 (a ASCII); +ERROR HY000: Unknown data type: 'ASCII' +SELECT CAST(1 AS ASCII); +ERROR HY000: Unknown data type: 'ASCII' +CREATE TABLE t1 (a LANGUAGE); +ERROR HY000: Unknown data type: 'LANGUAGE' +SELECT CAST(1 AS LANGUAGE); +ERROR HY000: Unknown data type: 'LANGUAGE' +CREATE TABLE t1 (a CLOSE); +ERROR HY000: Unknown data type: 'CLOSE' +SELECT CAST(1 AS CLOSE); +ERROR HY000: Unknown data type: 'CLOSE' +CREATE TABLE t1 (a NAMES); +ERROR HY000: Unknown data type: 'NAMES' +SELECT CAST(1 AS NAMES); +ERROR HY000: Unknown data type: 'NAMES' +CREATE TABLE t1 (a END); +ERROR HY000: Unknown data type: 'END' +SELECT CAST(1 AS END); +ERROR HY000: Unknown data type: 'END' +CREATE TABLE t1 (a GLOBAL); +ERROR HY000: Unknown data type: 'GLOBAL' +SELECT CAST(1 AS GLOBAL); +ERROR HY000: Unknown data type: 'GLOBAL' +CREATE TABLE t1 (a ACTION); +ERROR HY000: Unknown data type: 'ACTION' +SELECT CAST(1 AS ACTION); +ERROR HY000: Unknown data type: 'ACTION' +# # End of 10.5 tests # |