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

            Ascending order - Click to sort in descending order
            View 4 older comments
            anel Anel Husakovic added a comment -

            greenman seems there is no DISTANCE in MySQL or I couldn't find it.
            Probably should remove from https://mariadb.com/kb/en/function-differences-between-mariadb-106-and-mysql-80/

            anel Anel Husakovic added a comment - greenman seems there is no DISTANCE in MySQL or I couldn't find it. Probably should remove from https://mariadb.com/kb/en/function-differences-between-mariadb-106-and-mysql-80/
            greenman Ian Gilfillan added a comment -

            Thanks anel - this existed in 5.7 as a synonym for ST_DISTANCE, but was removed in 8.0 - I'll update the docs.

            greenman Ian Gilfillan added a comment - Thanks anel - this existed in 5.7 as a synonym for ST_DISTANCE, but was removed in 8.0 - I'll update the docs.
            ChrisHSandN Chris Hewett added a comment -

            I note this is tagged with the “compat80” label but I also think it deserves the “compat57” as the following functions were added in 5.7.5

            ST_GeoHash
            ST_LongFromGeoHash()
            ST_LatFromGeoHash()
            ST_PointFromGeoHash()

            ChrisHSandN Chris Hewett added a comment - I note this is tagged with the “compat80” label but I also think it deserves the “compat57” as the following functions were added in 5.7.5 ST_GeoHash ST_LongFromGeoHash() ST_LatFromGeoHash() ST_PointFromGeoHash()
            fan sehep added a comment -

            Hi, @anelAnel Husakovic, I want to try this task. I've compiled this project mariadb and run it successfully.
            But I'm gonna need some help figuring some things out, I noticed that some of the functions mysql has already implemented, but they inherit from a different class.

            fan sehep added a comment - Hi, @anelAnel Husakovic, I want to try this task. I've compiled this project mariadb and run it successfully. But I'm gonna need some help figuring some things out, I noticed that some of the functions mysql has already implemented, but they inherit from a different class.
            anel Anel Husakovic added a comment -

            Hi fan,
            great, feel free to ask questions here.
            Also note that there is implementation of ST_GeoHash PR 2570 and you can see how that feature is implemented and choose your feature and starti implementing.

            anel Anel Husakovic added a comment - Hi fan , great, feel free to ask questions here. Also note that there is implementation of ST_GeoHash PR 2570 and you can see how that feature is implemented and choose your feature and starti implementing.

            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.