Re: Mysql 5.7.27 ST_INTERSECTS Problem

[Fantasy Black]

Here the create sql:

CREATE TABLE IF NOT EXISTS geom_test (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
data_id BIGINT,
geom BLOB
);
INSERT INTO geom_test (data_id, geom) VALUES (1, GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,0 1,0 0))'))
INSERT INTO geom_test (data_id, geom) VALUES (2, GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,0 1,0 0))'))
SELECT * FROM geom_test WHERE ST_INTERSECTS(geom, GEOMFROMTEXT('POLYGON((0 0,0 2,1 1,0 1,0 0))'))