Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
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)
|
Attachments
Issue Links
- relates to
-
MDEV-7509 Testing for GIS extensions
- Closed