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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Labels | galera |
| Labels | galera | gis |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Fix Version/s | 10.1.4 [ 18400 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v2 [ 59359 ] | MariaDB v3 [ 65777 ] |
| Workflow | MariaDB v3 [ 65777 ] | MariaDB v4 [ 148766 ] |
Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007596.html