diff options
author | Alexander Barkov <bar@mariadb.org> | 2017-04-04 17:59:48 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.org> | 2017-04-04 17:59:48 +0400 |
commit | 17309c4c1234a2b8eb42c48c0c8f68142bbf1ee0 (patch) | |
tree | f27ad1a324c24199c2cda6b6495cacdf8fe75c65 /mysql-test/r/gis.result | |
parent | f1b0b046515b8afe2aab6612465d6228c09b05bd (diff) | |
download | mariadb-git-17309c4c1234a2b8eb42c48c0c8f68142bbf1ee0.tar.gz |
MDEV-12303 Add Type_handler::Item_xxx_fix_length_and_dec() for CAST classes
Diffstat (limited to 'mysql-test/r/gis.result')
-rw-r--r-- | mysql-test/r/gis.result | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result index 4213a5bf791..ea1736d7aa3 100644 --- a/mysql-test/r/gis.result +++ b/mysql-test/r/gis.result @@ -3778,5 +3778,64 @@ SELECT STDDEV(COALESCE(a)) FROM t1; ERROR HY000: Illegal parameter data type geometry for operation 'std(' DROP TABLE t1; # +# MDEV-12303 Add Type_handler::Item_xxx_fix_length_and_dec() for CAST classes +# +CREATE TABLE t1 (a GEOMETRY); +SELECT CAST(POINT(1,1) AS SIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_signed' +SELECT CAST(POINT(1,1) AS UNSIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_unsigned' +SELECT CAST(POINT(1,1) AS DOUBLE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'double_typecast' +SELECT CAST(POINT(1,1) AS DECIMAL(10,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'decimal_typecast' +SELECT CAST(POINT(1,1) AS CHAR) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_char' +SELECT CAST(POINT(1,1) AS TIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_time' +SELECT CAST(POINT(1,1) AS DATE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_date' +SELECT CAST(POINT(1,1) AS DATETIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_datetime' +SELECT CAST(a AS SIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_signed' +SELECT CAST(a AS UNSIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_unsigned' +SELECT CAST(a AS DOUBLE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'double_typecast' +SELECT CAST(a AS DECIMAL(10,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'decimal_typecast' +SELECT CAST(a AS CHAR) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_char' +SELECT CAST(a AS TIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_time' +SELECT CAST(a AS DATE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_date' +SELECT CAST(a AS DATETIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_datetime' +SELECT CAST(COALESCE(a) AS SIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_signed' +SELECT CAST(COALESCE(a) AS UNSIGNED) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_unsigned' +SELECT CAST(COALESCE(a) AS DOUBLE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'double_typecast' +SELECT CAST(COALESCE(a) AS DECIMAL(10,1)) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'decimal_typecast' +SELECT CAST(COALESCE(a) AS CHAR) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_char' +SELECT CAST(COALESCE(a) AS TIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_time' +SELECT CAST(COALESCE(a) AS DATE) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_date' +SELECT CAST(COALESCE(a) AS DATETIME) FROM t1; +ERROR HY000: Illegal parameter data type geometry for operation 'cast_as_datetime' +SELECT LENGTH(CAST(POINT(1,1) AS BINARY)) FROM t1; +LENGTH(CAST(POINT(1,1) AS BINARY)) +SELECT LENGTH(CAST(a AS BINARY)) FROM t1; +LENGTH(CAST(a AS BINARY)) +SELECT LENGTH(CAST(COALESCE(a) AS BINARY)) FROM t1; +LENGTH(CAST(COALESCE(a) AS BINARY)) +DROP TABLE t1; +# # End of 10.3 tests # |