[MDEV-499] LP:1043845 - st_distance() results are incorrect depending on variable order Created: 2012-08-30  Updated: 2012-08-31  Resolved: 2012-08-31

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.25, 5.3.7
Fix Version/s: 5.5.28, 5.3.9

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

https://bugs.launchpad.net/maria/+bug/1043845

select st_distance(geomfromtext('
LINESTRING(
-95.9673005697771 36.13509598461,
-95.9673057475387 36.1344478941074,
-95.9673063519371 36.134484524621,
-95.9673049102515 36.1343976584193
)
'),geomfromtext('point(-95.96269500000000000000 36.14181833333330000000)'))
;

Result: 0.000574275965624497

select st_distance(geomfromtext('point(-95.96269500000000000000 36.14181833333330000000)')
, geomfromtext('
LINESTRING(
-95.9673005697771 36.13509598461,
-95.9673057475387 36.1344478941074,
-95.9673063519371 36.134484524621,
-95.9673049102515 36.1343976584193
)
'))
;

Result: 0.00791407398682628


Generated at Thu Feb 08 06:29:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.