mirror of
https://github.com/MariaDB/server.git
synced 2025-01-27 17:33:44 +01:00
34a909806c
Validates that the two geometries passed to ST_OVERLAPS have the same number of dimensions.
20 lines
611 B
Text
20 lines
611 B
Text
#
|
|
# MDEV-35765 ST_OVERLAPS returns true despite dim(originalInput1) <> dim(originalInput2)
|
|
#
|
|
DROP table if EXISTS t1;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.t1'
|
|
DROP table if EXISTS t2;
|
|
Warnings:
|
|
Note 1051 Unknown table 'test.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;
|
|
ST_OVERLAPS(t1.geom, t2.geom)
|
|
0
|
|
DROP TABLE t1, t2;
|
|
#
|
|
# End of 10.6 tests
|
|
#
|