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

Implement Geographic functions available in MySQL 8.0

    XMLWordPrintable

    Details

    • Type: Task
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: GIS
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

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