From 265a7d1613d29e2bdd4c91a5a75971b331519dbe Mon Sep 17 00:00:00 2001 From: Alexander Barkov Date: Wed, 10 Jul 2019 11:55:16 +0400 Subject: MDEV-20009 Add CAST(expr AS pluggable_type) --- mysql-test/suite/compat/oracle/t/gis.test | 40 +++++++++++++++++++++++++++++++ 1 file changed, 40 insertions(+) (limited to 'mysql-test/suite/compat/oracle/t/gis.test') diff --git a/mysql-test/suite/compat/oracle/t/gis.test b/mysql-test/suite/compat/oracle/t/gis.test index 74d0f7f6ee5..cb1b869035a 100644 --- a/mysql-test/suite/compat/oracle/t/gis.test +++ b/mysql-test/suite/compat/oracle/t/gis.test @@ -31,6 +31,46 @@ SELECT WITHIN(POINT(1,1)); --error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT 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 # -- cgit v1.2.1