You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by GitBox <gi...@apache.org> on 2022/04/26 09:28:38 UTC
[GitHub] [incubator-doris] hf200012 opened a new issue, #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
hf200012 opened a new issue, #9239:
URL: https://github.com/apache/incubator-doris/issues/9239
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-doris/issues?q=is%3Aissue) and found no similar issues.
### Version
1.0 no-avx2
### What's Wrong?
```
mysql> select ST_Distance_Sphere(150.092265,115.082610,150.092265 , 115.082610);
+------------------------------------------------------------------+
| st_distance_sphere(150.092265, 115.08261, 150.092265, 115.08261) |
+------------------------------------------------------------------+
| NULL |
+------------------------------------------------------------------+
```
### What You Expected?
ST_Distance_Sphere应该返回0的返回了null
### How to Reproduce?
_No response_
### Anything Else?
_No response_
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] Gabriel39 commented on issue #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
Posted by GitBox <gi...@apache.org>.
Gabriel39 commented on issue #9239:
URL: https://github.com/apache/incubator-doris/issues/9239#issuecomment-1109581084
On which engine?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] Gabriel39 commented on issue #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
Posted by GitBox <gi...@apache.org>.
Gabriel39 commented on issue #9239:
URL: https://github.com/apache/incubator-doris/issues/9239#issuecomment-1110488880
This is caused by illegal input (e.g. 115 is out of range [0, 90] for latitude) so Doris just returns NULL for this case.
Besides, in ANSI mode, a runtime error should be thrown instead of just return NULL. So if we plan to support ANSI mode in future, this behavior should be changed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] THELEMITED commented on issue #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
Posted by GitBox <gi...@apache.org>.
THELEMITED commented on issue #9239:
URL: https://github.com/apache/incubator-doris/issues/9239#issuecomment-1109657780
- [ tunc]>]
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
[GitHub] [incubator-doris] HappenLee closed issue #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
Posted by GitBox <gi...@apache.org>.
HappenLee closed issue #9239: [Bug] The geolocation function ST_Distance_Sphere should return 0 and returned null
URL: https://github.com/apache/incubator-doris/issues/9239
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org