-- source include/have_geometry.inc

SET sql_mode=ORACLE;


SELECT CONTAINS(POINT(1,1), POINT(1,1));
SELECT CONTAINS(POINT(1,1), POINT(0,0));

SELECT WITHIN(POINT(1,1), POINT(1,1));
SELECT WITHIN(POINT(1,1), POINT(0,0));

--echo #
--echo # Start of 10.5 tests
--echo #

--echo #
--echo # MDEV-19994 Add class Function_collection
--echo #

--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
SELECT CONTAINS();
--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
SELECT CONTAINS(POINT(1,1));
--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
SELECT CONTAINS(POINT(1,1), POINT(1,1), POINT(1,1));

--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
SELECT WITHIN();
--error ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT
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 #