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

LP:801466 - ST_INTERSECTION() returns invalid value on empty intersection 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

          If two geometries do not intersect, ST_INTERSECTION() returns a value of length 4 that is not readable with AsText(). AsText() returns NULL.

          PostGIS returns a value that ST_AsEWKT() interprets as GEOMETRYCOLLECTION EMPTY.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                philipstoev Philip Stoev added a comment -

                Re: ST_INTERSECTION() returns invalid value on empty intersection in maria-5.3-gis
                Test case:

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

                postgis:

                SELECT ST_AsEWKT(ST_INTERSECTION( EndPoint( LinestringFromText(' LINESTRING( 8 1 , 7 8 ) ') ) , GeometryFromText(' LINESTRING( 7 7 , 0 7 ) ') ));

                Show
                philipstoev Philip Stoev added a comment - Re: ST_INTERSECTION() returns invalid value on empty intersection in maria-5.3-gis Test case: SELECT AsText(ST_INTERSECTION( LinestringFromText(' LINESTRING( 1 1, 2 2 ) ') , GeometryFromText(' LINESTRING( 3 3 , 4 4 ) ') )); postgis: SELECT ST_AsEWKT(ST_INTERSECTION( EndPoint( LinestringFromText(' LINESTRING( 8 1 , 7 8 ) ') ) , GeometryFromText(' LINESTRING( 7 7 , 0 7 ) ') ));
                Hide
                Permalink
                ratzpo Rasmus Johansson added a comment -

                Launchpad bug id: 801466

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

                  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: