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

Implement Geographic functions available in MySQL 8.0

Details

    Description

      As documented in https://mariadb.com/kb/en/function-differences-between-mariadb-rolling-and-mysql-8-0/ MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

      DISTANCE (removed in 8.0)
      GEOMCOLLECTION (synonym for GEOMETRYCOLLECTION)
      MBRCOVEREDBY
      MBRCovers
      ST_Collect (from MySQL 8.0.24)
      ST_DISTANCE_SPHERE (MDEV-13467)
      ST_GeoHash (from MySQL-5.7.4)
      ST_GeomCollFromTxt (synonym for ST_GeomCollFromText)
      ST_IsValid
      ST_LatFromGeoHash (from MySQL-5.7.4)
      ST_LongFromGeoHash (from MySQL-5.7.4)
      ST_PointFromGeoHash (from MySQL-5.7.4)
      ST_SIMPLIFY
      ST_VALIDATE
      ST_BUFFER_STRATEGY
      ST_FrechetDistance
      ST_HausdorffDistance
      ST_Latitude (from MySQL 8.0.12)
      ST_Longitude (from MySQL 8.0.12)
      ST_LineInterpolatePoint() (from MySQL 8.0.24)
      ST_LineInterpolatePoints() (from MySQL 8.0.24)
      ST_MakeEnvelope
      ST_NumInteriorRing (synonym for ST_NumInterioRings)
      ST_PointAtDistance (from MySQL 8.0.24)
      ST_SwapXY
      ST_Transform (from MySQL 8.0.13)

      The lack of these can cause problems for some MySQL users wanting to use MariaDB.

      Attachments

        Issue Links

          causes

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

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34916 Implement Distance, Interpolate GIS Functions

          • Major - Major loss of function.
          • Open
          includes

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34137 Implement the GIS function ST_Validate

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34138 Implement the GIS function MBRCoveredBy

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34141 Implement the GIS function ST_Simplify

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34158 Implement the GIS function ST_GeoHash

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34159 Implement the GIS function ST_LatFromGeoHash

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34160 Implement the GIS function ST_LongFromGeoHash

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34276 Implement the GIS function ST_IsValid

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34277 Implement the GIS function ST_PointFromGeoHash

          • Major - Major loss of function.
          • In Testing

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34278 Implement the GIS function ST_Collect

          • Major - Major loss of function.
          • In Testing
          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-8935 taking SRID into account in GIS fields and items.

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-13467 Feature request: Support for ST_Distance_Sphere()

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Dave Gosselin made transition -
            Open In Progress
            		2085d 17h 25m 1
            Dave Gosselin made transition -
            In Progress In Review
            		29d 23h 49m 1
            Dave Gosselin made transition -
            In Review In Testing
            		35d 23h 8m 1
            Ralf Gebhardt made transition -
            In Testing Stalled
            		76d 3h 20m 1

            People

              Unassigned Unassigned
              greenman Ian Gilfillan
              Votes:
              10 Vote for this issue
              Watchers:
              18 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.