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

Implement the GIS function ST_IsValid

Details

    Description

      Returns 1 if the argument is geometrically valid, 0 if the argument is not geometrically valid. The rules used to state if a geometry is valid or not are the same as MySQL and PostGIS and can be found here.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35126 Wrong results from st_isvalid or st_validate function, while using multipolygon

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35127 Wrong result from st_isvalid() and polygon

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is part of

          Task - A task that needs to be done. MDEV-17398 Implement Geographic functions available in MySQL 8.0

          • Major - Major loss of function.
          • Stalled

          Task - A task that needs to be done. MDEV-34120 GSoC 2024, Spatial (GIS) functions in MariaDB

          • Major - Major loss of function.
          • In Testing
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35960 st_isvalid(NULL) should not end up with an error, but return NULL

          • Critical - Crashes, loss of data, severe memory leak.
          • In Testing

          Activity

            Ascending order - Click to sort in descending order
            Stefano Petrilli Stefano Petrilli created issue -
            Stefano Petrilli Stefano Petrilli made changes -
            Field Original Value New Value
            Stefano Petrilli Stefano Petrilli made changes -
            serg Sergei Golubchik made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ]
            Stefano Petrilli Stefano Petrilli made changes -
            Description Returns 1 if the argument is geometrically valid, 0 if the argument is not geometrically valid. A geometry is valid when:

            * *Simple*: The geometry must not self-intersect.
            * *Properly Closed*: For polygons, the geometry must form a closed ring.
            * *Consistent Orientation*: The exterior boundary of a polygon must be counterclockwise, and interior boundaries (holes) must be clockwise.
            * *No Repeated Points*: Points should not be repeated in the definition of the geometry.
            * *Proper Nesting*: Holes must be properly nested within the exterior boundary and must not overlap.
            * *Non-Empty*: The geometry cannot be empty. The only valid empty geometry is represented in the form of an empty geometry collection value.             		Returns 1 if the argument is geometrically valid, 0 if the argument is not geometrically valid. The rules used to state if a geometry is valid or not are the same as MySQL and PostGIS and can be found [here| https://postgis.net/docs/using_postgis_dbmanagement.html#OGC_Validity].
            Gosselin Dave Gosselin made changes -
            Fix Version/s 11.7 [ 29815 ]
            Gosselin Dave Gosselin made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Alexey Botchkov [ holyfoot ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            holyfoot Alexey Botchkov added a comment -

            ok to push.

            holyfoot Alexey Botchkov added a comment - ok to push.
            holyfoot Alexey Botchkov made changes -
            Status In Review [ 10002 ] Stalled [ 10000 ]
            Gosselin Dave Gosselin made changes -
            Assignee Alexey Botchkov [ holyfoot ] Dave Gosselin [ JIRAUSER52216 ]
            Gosselin Dave Gosselin made changes -
            Status Stalled [ 10000 ] In Progress [ 3 ]
            Gosselin Dave Gosselin made changes -
            Status In Progress [ 3 ] In Review [ 10002 ]
            Gosselin Dave Gosselin made changes -
            Status In Review [ 10002 ] In Testing [ 10301 ]
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility GIS gsoc24 Compatibility GIS Preview_11.7 gsoc24
            alice Alice Sherepa made changes -
            alice Alice Sherepa made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.8 [ 29921 ]
            Fix Version/s 11.7 [ 29815 ]
            Assignee Dave Gosselin [ JIRAUSER52216 ] Alice Sherepa [ alice ]
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            serg Sergei Golubchik made changes -
            alice Alice Sherepa made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility GIS Preview_11.7 gsoc24 Compatibility GIS Preview_11.7 Preview_11.8 gsoc24
            serg Sergei Golubchik made changes -
            Fix Version/s 12.0 [ 29945 ]
            Fix Version/s 11.8 [ 29921 ]

            People

              alice Alice Sherepa
              Stefano Petrilli Stefano Petrilli
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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