mirror of
https://github.com/MariaDB/server.git
synced 2025-01-27 09:14:17 +01:00
34a909806c
Validates that the two geometries passed to ST_OVERLAPS have the same number of dimensions.
14 lines
533 B
Text
14 lines
533 B
Text
--echo #
|
|
--echo # MDEV-35765 ST_OVERLAPS returns true despite dim(originalInput1) <> dim(originalInput2)
|
|
--echo #
|
|
DROP table if EXISTS t1;
|
|
DROP table if EXISTS t2;
|
|
CREATE TABLE t1(geom geometry NOT NULL);
|
|
CREATE TABLE t2(geom geometry NOT NULL);
|
|
INSERT INTO t1 (geom) VALUES(ST_GeomFromText('POLYGON ((0 0, 0 1, 1 1, 1 0, 0 0))'));
|
|
INSERT INTO t2 (geom) VALUES(ST_GeomFromText('LINESTRING (1 1, 1 2, 2 2, 2 1, 1 1)'));
|
|
SELECT ST_OVERLAPS(t1.geom, t2.geom) FROM t1, t2;
|
|
DROP TABLE t1, t2;
|
|
--echo #
|
|
--echo # End of 10.6 tests
|
|
--echo #
|