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

Feature request: Support for ST_Distance_Sphere()

Details

    Description

      Spatial Convenience Function:

      This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. ST_Distance_Sphere makes use for calculating the distance of coordinates from points.

      For more information reference MySQL's documentation directly at:
      https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

      Source Code Reference (thanks to Daniel Black for the commit number):
      https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-17398 Implement Geographic functions available in MySQL 8.0

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26161 crash in Gis_point::calculate_haversine

          • Major - Major loss of function.
          • Stalled

          Activity

            Ascending order - Click to sort in descending order
            tfont Travis van der Font created issue -
            tfont Travis van der Font made changes -
            Field Original Value New Value
            Description Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html             		Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

            Source Code Reference ~(thanks to Daniel Black for commit number)~:
            https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9
            tfont Travis van der Font made changes -
            Description Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

            Source Code Reference ~(thanks to Daniel Black for commit number)~:
            https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9             		Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

            Source Code Reference ??(thanks to Daniel Black for commit number)??:
            https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9
            tfont Travis van der Font made changes -
            Description Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

            Source Code Reference ??(thanks to Daniel Black for commit number)??:
            https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9             		Spatial Convenience Function:

            This function does not exist in any version of MariaDB but does on MySQL 5.7+ and is critical for spatial conversions. *_ST_Distance_Sphere_* makes use for calculating the distance of coordinates from points.

            For more information reference MySQL's documentation directly at:
            https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html

            Source Code Reference ??(thanks to Daniel Black for the commit number)??:
            https://github.com/mysql/mysql-server/commit/60e7f702ac3929c0e38afa7e6dd75fcd5a54c6a9
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Alexey Botchkov [ holyfoot ]
            anel Anel Husakovic made changes -
            Assignee Alexey Botchkov [ holyfoot ] Anel Husakovic [ anel ]
            anel Anel Husakovic made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            anel Anel Husakovic made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Alexey Botchkov [ holyfoot ]
            Status Confirmed [ 10101 ] In Review [ 10002 ]
            danblack Daniel Black made changes -
            Assignee Alexey Botchkov [ holyfoot ] Daniel Black [ danblack ]
            danblack Daniel Black made changes -
            Assignee Daniel Black [ danblack ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Assignee Anel Husakovic [ anel ] Daniel Black [ danblack ]
            Status Stalled [ 10000 ] In Review [ 10002 ]
            greenman Ian Gilfillan made changes -
            anel Anel Husakovic made changes -
            Assignee Daniel Black [ danblack ] Alexey Botchkov [ holyfoot ]
            holyfoot Alexey Botchkov made changes -
            Assignee Alexey Botchkov [ holyfoot ] Anel Husakovic [ anel ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            anel Anel Husakovic made changes -
            Fix Version/s 10.2.38 [ 25207 ]
            Fix Version/s 10.3.29 [ 25206 ]
            Fix Version/s 10.4.19 [ 25205 ]
            Fix Version/s 10.5.10 [ 25204 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            anel Anel Husakovic made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 81942 ] MariaDB v4 [ 133320 ]
            mariadb-jira-automation Jira Automation (IT) made changes -
            Zendesk Related Tickets 130331

            People

              anel Anel Husakovic
              tfont Travis van der Font
              Votes:
              29 Vote for this issue
              Watchers:
              33 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.