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

Implement the GIS function ST_Collect

    XMLWordPrintable

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.
          • Open
          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

            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.