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

Implement Geographic functions available in MySQL 8.0

    XMLWordPrintable

Details

    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.

      Attachments

        Issue Links

          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-13467 Feature request: Support for ST_Distance_Sphere()

          • Major - Major loss of function.
          • Closed

          Activity

            People

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