Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4
-
None
-
None
-
Unexpected results
Description
Setup:
CREATE TABLE t1 (id int PRIMARY KEY, g geometry NOT NULL, SPATIAL KEY(g)) |
ENGINE=InnoDB;
|
INSERT INTO t1 VALUES |
(1, ST_GeomFromText('POLYGON((0 0,10 0,0 10,0 0))')), |
(2, ST_GeomFromText('POLYGON((100 100,101 100,101 101,100 101,100 100))')); |
SET @p= ST_GeomFromText('POLYGON((8 8,9 8,9 9,8 9,8 8))'); |
On 11.4 we are missing a result for ST_Disjoint:
MariaDB [test]> SELECT id FROM t1 WHERE ST_Disjoint(@p,g); |
+----+ |
| id |
|
+----+ |
| 2 |
|
+----+ |
1 row in set (0.001 sec) |
Contrasted with MySQL 9.6.0:
mysql> SELECT id FROM t1 WHERE ST_Disjoint(@p,g); |
+----+ |
| id |
|
+----+ |
| 1 |
|
| 2 |
|
+----+ |
2 rows in set (0.002 sec) |
Interestingly, this appears to be specific to InnoDB. Changing the engine to MyISAM or Aria gives the same result that MySQL gives.