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

LP:848926 - GIS functions return "GEOMETRYCOLLECTION()" instead of "GEOMETRYCOLLECTION EMPTY"

    XMLWordPrintable

Details

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

    Description

      MariaDB [test]> select astext(ST_INTERSECTION( MULTILINESTRINGFROMTEXT(' MULTILINESTRING( (3 5, 2 4, 2 5, 3 5) ) ') , LINESTRINGFROMTEXT(' LINESTRING( 5 5 , 9 3 , 5 5 , 6 1 ) ') ))\G

                                                          • 1. row ***************************
                                                            astext(ST_INTERSECTION( MULTILINESTRINGFROMTEXT(' MULTILINESTRING( (3 5, 2 4, 2 5, 3 5) ) ') , LINESTRINGFROMTEXT(' LINESTRING( 5 5 , 9 3 , 5 5 , 6 1 ) ') )): GEOMETRYCOLLECTION()
                                                            1 row in set (0.00 sec)

      GEOMETRYCOLLECTION() is not recognized by PostGIS as a valid value. PostGIS returns "GEOMETRYCOLLECTION EMPTY".

      Also, trying to use GEOMETRYCOLLECTION() in a calculation results in a totally bogus result:

      MariaDB [test]> SELECT ASTEXT(ENVELOPE(GEOMETRYFROMTEXT('GEOMETRYCOLLECTION()')))\G

                                                          • 1. row ***************************
                                                            ASTEXT(ENVELOPE(GEOMETRYFROMTEXT('GEOMETRYCOLLECTION()'))): POLYGON((1.79769313486232e+308 1.79769313486232e+308,-1.79769313486232e+308 1.79769313486232e+308,-1.79769313486232e+308 -1.79769313486232e+308,1.79769313486232e+308 -1.79769313486232e+308,1.79769313486232e+308 1.79769313486232e+308))

      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.