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.
          • In Review
          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

            Transition Time In Source Status Execution Times
            Dave Gosselin made transition -
            Open In Progress
            		39d 15h 2m 1
            Dave Gosselin made transition -
            In Progress In Review
            		6d 2h 43m 1
            Dave Gosselin made transition -
            In Review In Testing
            		42d 20h 49m 1

            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.