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

LP:802376 - ST_INTERSECTION returns wrong result on two overlapping linestrings in maria-5.3-gis

        Details

        • Type: Bug
        • Status: Closed
        • Resolution: Fixed
        • Affects Version/s: None
        • Fix Version/s: None
        • Component/s: None
        • Labels:

          Description

          Calling ST_INTERSECTION() on two partially overlapping linestrings returns a single POINT , rather than the list of overlapping segments.

          For example:

          SELECT AsText( ST_INTERSECTION(
          LinestringFromText('LINESTRING( 3 5, 2 5, 2 4, 3 4, 3 5 ) ') ,
          LinestringFromText('LINESTRING( 3 5, 2 4, 2 5, 3 5 ) ')
          ));

          Note that the two linestrings share (3 5 , 2 5) and (2 5 , 2 4) and yet ST_INTERSECTION returns only POINT(2 5). Postgis returns MULTILINESTRING((3 5,2 5),(2 5,2 4))

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 802376

                Show
                ratzpo Rasmus Johansson added a comment - Launchpad bug id: 802376

                  People

                  • Assignee:
                    holyfoot Alexey Botchkov
                    Reporter:
                    philipstoev Philip Stoev
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    0 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: