pingcap / pingcap/tidb

Error using Geolocation Function like ST_Distance_Sphere, Point, etc

Open
#38,300 2 comments 0 reactions 0 assignees View on GitHub
sig/execution type/feature-request
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Bug Report

How to use geolocation function like on mysql - for example ST_Distance_Sphere or point.

### 1. Minimal reproduce step (Required)
```
SELECT ST_Distance_Sphere(
point(106.829458, -6.144241),
point(107.628336, -6.936575)
);

```

### 2. What did you expect to see? (Required)
Return distance from location A to B

### 3. What did you see instead (Required)
[42000][1305] FUNCTION devdb.st_distance_sphere does not exist
[42000][1305] FUNCTION devdb.point does not exist

### 4. What is your TiDB version? (Required)
Release Version: v6.1.1
Edition: Community
Git Commit Hash: 5263a0abda61f102122735049fd0dfadc7b7f8b2
Git Branch: heads/refs/tags/v6.1.1
UTC Build Time: 2022-08-25 10:42:41
GoVersion: go1.18.5
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.