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

Implement the GIS function ST_Collect

Details

    Description

      The GIS function ST_Collect takes as input multiple geometries and returns the aggregation of the distinct geometry arguments.
      This function also supports the DISTINCT option. If the DISTINCT case is used, it returns the aggregation of the distinct geometry arguments.

      The resulting value type is choosen using the following policy:

      • If all arguments are Point values, the result is a MultiPoint value.
      • If all arguments are LineString values, the result is a MultiLineString value.
      • If all arguments are Polygon values, the result is a MultiPolygon value.
      • Otherwise, the result is a GeometryCollection value.

      If there are multiple geometry arguments and those arguments are in the same SRS, the return value is in that SRS. If those arguments are not in the same SRS, an ER_GIS_DIFFERENT_SRIDS_AGGREGATION error occurs.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35102 CREATE TABLE AS SELECT ST_collect ... does not work

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35975 Server crashes after CREATE VIEW as SELECT ST_COLLECT...

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36167 Assertion `0' failed in Item_sum_str::reset_field after selecting st_collect + group by

          • Major - Major loss of function.
          • 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

          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 ]
            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 ]
            Gosselin Dave Gosselin made changes -
            Assignee Alexey Botchkov [ holyfoot ] Dave Gosselin [ JIRAUSER52216 ]
            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 Preview_11.7 gis gsoc24
            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 -
            serg Sergei Golubchik made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Labels Compatibility Preview_11.7 gis gsoc24 Compatibility Preview_11.7 Preview_11.8 gis gsoc24
            alice Alice Sherepa made changes -
            serg Sergei Golubchik made changes -
            Fix Version/s 12.0 [ 29945 ]
            Fix Version/s 11.8 [ 29921 ]
            alice Alice Sherepa made changes -

            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.