LP:1043845 - st_distance() results are incorrect depending on variable order

Description

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

1 2 3 4 5 6 7 8 9 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

1 2 3 4 5 6 7 8 9 10 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

Environment

None

Status

Assignee

Alexey Botchkov

Reporter

Elena Stepanova

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

5.5.25
5.3.7

Priority

Major
Configure