diff options
| author | unknown <sanja@montyprogram.com> | 2012-09-06 00:14:33 +0300 |
|---|---|---|
| committer | unknown <sanja@montyprogram.com> | 2012-09-06 00:14:33 +0300 |
| commit | caedd1992c0926f41e3fb5f8b6f430d9a2a827a9 (patch) | |
| tree | 608480bb375937718737c67d12dd3ec0edca303a /mysql-test/t/gis.test | |
| parent | 24b9d7e43f8251263863f52bfefb00eacf2523ae (diff) | |
| parent | 54bb28d4a151d0eb5c3b74edb40ddf6e118c124b (diff) | |
| download | mariadb-git-caedd1992c0926f41e3fb5f8b6f430d9a2a827a9.tar.gz | |
merge 5.3->5.5
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index f4c9de4e7da..b0ad8329cfb 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -1293,6 +1293,21 @@ WHERE ST_Contains(ST_Buffer(bridges.position, 15.0), buildings.footprint) = 1; #WHERE lakes.name = 'Blue Lake'; DROP DATABASE gis_ogs; + +--echo # +--echo # BUG #1043845 st_distance() results are incorrect depending on variable order +--echo # + +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)')) ; +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) ')) ; USE test; @@ -1344,4 +1359,3 @@ SELECT 1 FROM g1 WHERE a >= ANY DROP TABLE g1; --echo End of 5.5 tests - |