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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • None
    • None
    • None

    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))

      Attachments

        Activity

          People

            holyfoot Alexey Botchkov
            philipstoev Philip Stoev (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.