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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 5.5.25, 5.3.7
        • Fix Version/s: 5.5.28, 5.3.9
        • Component/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    holyfoot Alexey Botchkov
                    Reporter:
                    elenst Elena Stepanova
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 4 hours
                      4h