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

GIS: PointOnSurface returns NULL instead of the point

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 10.1.4
    • GIS

    Description

      10.1 tree

      		 
      MariaDB [test]> SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
      		 
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))) |
      		 
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      | NULL                                                                                                                                                            |
      		 
      +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
      		 
      1 row in set (0.00 sec)

      PostGIS

      		 
      pgis=# SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
      		 
                   st_astext             
      -----------------------------------
      		 
       POINT(-70.9510231824279 42.09385)
      		 
      (1 row)

      The shape is rather simple (see the picture).

      Attachments

        1. gis1.png
          25 kB
          Elena Stepanova

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-7509 Testing for GIS extensions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35766 ST_PointOnSurface returns NULL with Polygon in some case

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            greenman Ian Gilfillan added a comment -

            The function doesn't seem to return a point under any circumstances. It even fails for a single point:

            SET @g = ST_GEOMFROMTEXT('Point(0 5)');
            		 
             
            		 
            SELECT ST_ASTEXT(ST_POINTONSURFACE(@g));
            		 
            +----------------------------------+
            		 
            | ST_ASTEXT(ST_POINTONSURFACE(@g)) |
            		 
            +----------------------------------+
            		 
            | NULL                             |
            		 
            +----------------------------------+

            greenman Ian Gilfillan added a comment - The function doesn't seem to return a point under any circumstances. It even fails for a single point: SET @g = ST_GEOMFROMTEXT('Point(0 5)');   SELECT ST_ASTEXT(ST_POINTONSURFACE(@g)); +----------------------------------+ | ST_ASTEXT(ST_POINTONSURFACE(@g)) | +----------------------------------+ | NULL | +----------------------------------+
            holyfoot Alexey Botchkov added a comment -

            Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007595.html

            holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2015-March/007595.html
            dvohra Deepak Vohra added a comment - - edited

            The function still returns 

            NULL

            in version 10.5. 

            SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))')));
            		 
            +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
            		 
               | ST_AsText(ST_PointOnSurface(ST_PolyFromText('POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))'))) |
            		 
               +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+
            		 
               | NULL                                                                                                                                                            |
            		 
               +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+

            dvohra Deepak Vohra added a comment - - edited The function still returns NULL in version 10.5. SELECT ST_AsText(ST_PointOnSurface(ST_PolyFromText( 'POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))' ))); +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | ST_AsText(ST_PointOnSurface(ST_PolyFromText( 'POLYGON((-70.916 42.1002,-70.9468 42.0946,-70.9754 42.0875,-70.9749 42.0879,-70.9759 42.0897,-70.916 42.1002))' ))) | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+ | NULL | +-----------------------------------------------------------------------------------------------------------------------------------------------------------------+

            People

              holyfoot Alexey Botchkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.