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

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

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

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

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

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

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

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

          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.
          • Stalled
          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
            greenman Ian Gilfillan created issue -
            greenman Ian Gilfillan made changes -
            Field Original Value New Value
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-103-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

                DISTANCE
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                ST_DISTANCE_SPHERE
                ST_GeoHash
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

                DISTANCE
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

                DISTANCE
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               - DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               - DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 89977 ] MariaDB v4 [ 130914 ]
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                ST_Collect (from MySQL 8.0.24)
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Labels Compatibility
            greenman Ian Gilfillan made changes -
            Labels Compatibility Compatibility compat80
            monty Michael Widenius made changes -
            danblack Daniel Black made changes -
            Labels Compatibility compat80 Compatibility compat57 compat80
            danblack Daniel Black made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                ST_Collect (from MySQL 8.0.24)
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash
                ST_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)
                ST_LongFromGeoHash
                ST_PointFromGeoHash
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                ST_Collect (from MySQL 8.0.24)
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash (from MySQL-5.7.4)
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash (from MySQL-5.7.4)
                ST_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)
                ST_LongFromGeoHash (from MySQL-5.7.4)
                ST_PointFromGeoHash (from MySQL-5.7.4)
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            monty Michael Widenius made changes -
            Assignee Alexey Botchkov [ holyfoot ]
            serg Sergei Golubchik made changes -
            Labels Compatibility compat57 compat80 Compatibility compat57 compat80 gsoc24
            Gosselin Dave Gosselin made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Stefano Petrilli Stefano Petrilli made changes -
            Gosselin Dave Gosselin made changes -
            Assignee Alexey Botchkov [ holyfoot ] 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 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 130331
            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 ]
            Gosselin Dave Gosselin made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                MBRCOVEREDBY
                ST_BUFFER_STRATEGY
                ST_Collect (from MySQL 8.0.24)
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                ST_FrechetDistance
                ST_GeoHash (from MySQL-5.7.4)
                ST_HausdorffDistance
                ST_IsValid
                ST_LatFromGeoHash (from MySQL-5.7.4)
                ST_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)
                ST_LongFromGeoHash (from MySQL-5.7.4)
                ST_PointFromGeoHash (from MySQL-5.7.4)
                ST_SIMPLIFY
                ST_VALIDATE

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            Gosselin Dave Gosselin made changes -
            elenst Elena Stepanova made changes -
            Assignee Dave Gosselin [ JIRAUSER52216 ] Alice Sherepa [ alice ]
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in https://mariadb.com/kb/en/library/function-differences-between-mariadb-106-and-mysql-80 MySQL 8.0 has quite a few Geographic functions not available in MariaDB:

               -DISTANCE- (removed in 8.0)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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_LineInterpolatePoint() (from MySQL 8.0.24)
                ST_LineInterpolatePoints() (from MySQL 8.0.24)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in 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)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in 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)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in 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)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                ST_Covered
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in 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)
                -MBRCOVEREDBY-
                -ST_Collect (from MySQL 8.0.24)-
                ST_Covered
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		As documented in 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)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            Description As documented in 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)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            alice Alice Sherepa made changes -
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.8 [ 29921 ]
            Fix Version/s 11.7 [ 29815 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Fix Version/s 11.8 [ 29921 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            ralf.gebhardt Ralf Gebhardt made changes -
            Assignee Alice Sherepa [ alice ]
            greenman Ian Gilfillan made changes -
            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)
                -MBRCOVEREDBY-
                MBRCovers
                -ST_Collect (from MySQL 8.0.24)-
                -ST_DISTANCE_SPHERE (MDEV-13467)-
                -ST_GeoHash (from MySQL-5.7.4)-
                -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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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_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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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_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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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)

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            greenman Ian Gilfillan made changes -
            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

            The lack of these can cause problems for some MySQL users wanting to use MariaDB.
            		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.
            svoj Sergey Vojtovich made changes -
            Labels Compatibility compat57 compat80 gsoc24 Compatibility compat57 compat80 contribution gsoc24

            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.