mirror of
https://github.com/MariaDB/server.git
synced 2025-02-09 23:24:11 +01:00
76 lines
1.8 KiB
Text
76 lines
1.8 KiB
Text
-- 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 #
|