Details
Description
Two identical points
ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)')
Equals (T*F**FFF*)
MariaDB
MariaDB [test]> select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'),'T*F**FFF*') AS equals;
+--------+
| equals |
+--------+
| 0 |
+--------+
1 row in set (0.00 sec)
PostGIS
pgis=# select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'),'T*F**FFF*') AS equals;
equals
--------
t
(1 row)
Same for Contains (T*****FF*), Covers (T*****FF*), Within (T*F**F***), Covered by (T*F**F***).
Two different points
ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)')
Disjoint
MariaDB
MariaDB [test]> select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)'),'FF*FF****') as disjoint;
+----------+
| disjoint |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
PostGIS
pgis=# select ST_Relate(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(1 1)'),'FF*FF****') as disjoint;
disjoint
----------
t
(1 row)
Gliffy Diagrams
Attachments
Issue Links
- relates to
-
MDEV-7509
Testing for GIS extensions
-
- Stalled
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007596.html