Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7925

Inconsistent behavior of ST_Touches with a POINT as one of arguments

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.1
        • Fix Version/s: 10.1.6
        • Component/s: GIS
        • Labels:
          None
        • Sprint:
          10.1.6-1

          Description

          Polygon and point, line and point

          ST_Touches(POLYGON,POINT) and ST_Touches(LINESTRING,POINT) in some cases return true in 10.0 and PostgreSQL and false in 10.1:

          10.1
          MariaDB [test]> select ST_Touches(ST_LineFromText('LINESTRING(0 0,5 5)'),ST_PointFromText('POINT(0 0)'));
+-----------------------------------------------------------------------------------+
| ST_Touches(ST_LineFromText('LINESTRING(0 0,5 5)'),ST_PointFromText('POINT(0 0)')) |
+-----------------------------------------------------------------------------------+
|                                                                                 0 |
+-----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> select ST_Touches(ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0))'),ST_PointFromText('POINT(0 0)'));
+-------------------------------------------------------------------------------------------------+
| ST_Touches(ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0))'),ST_PointFromText('POINT(0 0)')) |
+-------------------------------------------------------------------------------------------------+
|                                                                                               0 |
+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
          10.0
          MariaDB [test]> select ST_Touches(ST_LineFromText('LINESTRING(0 0,5 5)'),ST_PointFromText('POINT(0 0)'));
+-----------------------------------------------------------------------------------+
| ST_Touches(ST_LineFromText('LINESTRING(0 0,5 5)'),ST_PointFromText('POINT(0 0)')) |
+-----------------------------------------------------------------------------------+
|                                                                                 1 |
+-----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [test]> select ST_Touches(ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0))'),ST_PointFromText('POINT(0 0)'));
+-------------------------------------------------------------------------------------------------+
| ST_Touches(ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0))'),ST_PointFromText('POINT(0 0)')) |
+-------------------------------------------------------------------------------------------------+
|                                                                                               1 |
+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
          PostgreSQL
          pgis=# select ST_Touches(ST_LineFromText('LINESTRING(0 0,5 5)'),ST_PointFromText('POINT(0 0)'));
 st_touches 
------------
 t
(1 row)

pgis=# select ST_Touches(ST_PolygonFromText('POLYGON((0 0,0 5,5 5,5 0,0 0))'),ST_PointFromText('POINT(0 0)'));
 st_touches 
------------
 t
(1 row)

          Two identical points

          ST_Touches(POINT,POINT) returns true in 10.0 and false in 10.1.
          In PostgreSQL, it also returns false. I'm not sure which is correct, the definition of ST_Touches leaves it unclear for a degenerate object such as point.

          10.0
          MariaDB [test]> select ST_Touches(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'));
+---------------------------------------------------------------------------+
| ST_Touches(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)')) |
+---------------------------------------------------------------------------+
|                                                                         1 |
+---------------------------------------------------------------------------+
1 row in set (0.00 sec)
          10.1
          MariaDB [test]> select ST_Touches(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'));
+---------------------------------------------------------------------------+
| ST_Touches(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)')) |
+---------------------------------------------------------------------------+
|                                                                         0 |
+---------------------------------------------------------------------------+
1 row in set (0.00 sec)
          PostgreSQL
          pgis=# select ST_Touches(ST_PointFromText('POINT(0 0)'),ST_PointFromText('POINT(0 0)'));
 st_touches 
------------
 f
(1 row)

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Technical task - A technical task. MDEV-7509 Testing for GIS extensions

                • Minor - Minor loss of function, or other problem where easy workaround is present.
                • Stalled

                Task - A task that needs to be done. MDEV-7069 Fix buildbot failures in main server trees

                • Major - Major loss of function.
                • Stalled

                  Activity

                  Hide
                  Permalink
                  holyfoot Alexey Botchkov added a comment -

                  http://lists.askmonty.org/pipermail/commits/2015-June/008077.html

                  Show
                  holyfoot Alexey Botchkov added a comment - http://lists.askmonty.org/pipermail/commits/2015-June/008077.html

                    People

                    • Assignee:
                      holyfoot Alexey Botchkov
                      Reporter:
                      elenst Elena Stepanova
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved:

                        Time Tracking

                        Estimated:
                        Original Estimate - Not Specified
                        Not Specified
                        Remaining:
                        Remaining Estimate - 0 minutes
                        0m
                        Logged:
                        Time Spent - 1 day, 4 hours
                        1d 4h

                          Agile