diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-07-10 11:55:16 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-07-10 11:55:16 +0400 |
commit | 265a7d1613d29e2bdd4c91a5a75971b331519dbe (patch) | |
tree | b053ea8bc389ff1bd7a6a8d9a750cdc71c0d8f43 /mysql-test/main/gis.test | |
parent | e37d7a37151f1aa53e102d24af5d234c2ccfa392 (diff) | |
download | mariadb-git-265a7d1613d29e2bdd4c91a5a75971b331519dbe.tar.gz |
MDEV-20009 Add CAST(expr AS pluggable_type)
Diffstat (limited to 'mysql-test/main/gis.test')
-rw-r--r-- | mysql-test/main/gis.test | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/main/gis.test b/mysql-test/main/gis.test index a48fd8cf019..48f2803b27d 100644 --- a/mysql-test/main/gis.test +++ b/mysql-test/main/gis.test @@ -3141,5 +3141,45 @@ SELECT WITHIN(POINT(1,1)); SELECT WITHIN(POINT(1,1), POINT(1,1), POINT(1,1)); --echo # +--echo # MDEV-20009 Add CAST(expr AS pluggable_type) +--echo # + +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS GEOMETRY); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS GEOMETRYCOLLECTION); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS POINT); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS LINESTRING); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS POLYGON); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS MULTIPOINT); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS MULTILINESTRING); +--error ER_UNKNOWN_OPERATOR +SELECT CAST(1 AS MULTIPOLYGON); + + +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, GEOMETRY); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, GEOMETRYCOLLECTION); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, POINT); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, LINESTRING); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, POLYGON); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, MULTIPOINT); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, MULTILINESTRING); +--error ER_UNKNOWN_OPERATOR +SELECT CONVERT(1, MULTIPOLYGON); + + +--echo # --echo # End of 10.5 tests --echo # |