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

GIS: ST_Relate returns unexpected results for POINT relations

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: N/A
    • Fix Version/s: 10.1.4
    • Component/s: GIS
    • Labels:

      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

              Activity

              Show
              holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007596.html

                People

                • Assignee:
                  holyfoot Alexey Botchkov
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 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 - 4 hours
                    4h