| Bug #55958 | GeomFromText is returning wrong data | ||
|---|---|---|---|
| Submitted: | 12 Aug 2010 23:23 | Modified: | 8 May 2015 12:25 |
| Reporter: | Derrick Egersdorfer | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server: GIS | Severity: | S1 (Critical) |
| Version: | 5.1.49 | OS: | MacOS (10.6.4) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | GeomFromText latitude longitude | ||
[12 Aug 2010 23:27]
Derrick Egersdorfer
There seems to be some info missing from my post:
Create a table with a field name of latlng and type 'geometry' and insert a point:
INSERT INTO table SET latLng=PointFromText(CONCAT('POINT(','-26.375604475402035 29.63798828124999',')'))
[12 Aug 2010 23:29]
Derrick Egersdorfer
Then run the following query: SELECT latlng, X(GeomFromText(AsText(latLng))) AS lat, Y(GeomFromText(AsText(latLng))) AS lng FROM table On mysql ver: 5.1.49 Mac OS X you get: lat = ''-1.25005517983264e+16'' and lng = '2.50800520576627e+135' the numbers and the e+16 etc are wrong On mysql ver 5.0.51 ubuntu you get: lat = '-26.375604475402' and lng = '29.63798828125' (correct geo location)
[14 Aug 2010 10:08]
Hartmut Holzgraefe
Can't reproduce with 5.1.49 on Linux/Intel 32bit. What version of MacOS X and what architecture (PowerPC, Intel) are you using?
[14 Aug 2010 11:12]
Derrick Egersdorfer
Mac OS X version 10.6.3, build: 10D2235 Intel Processor - not using powerPc Thanks
[14 Aug 2010 11:17]
Derrick Egersdorfer
Upgrading to MAC OS X 10.6.4 now... will let you know.
[14 Aug 2010 12:27]
Derrick Egersdorfer
Same problem on 10.6.4 unfortunately.
[15 Aug 2010 9:08]
Sveta Smirnova
Thank you for the report. I can not repeat described behavior on Mac box too. Which MySQL package do you use?
[15 Aug 2010 9:37]
Derrick Egersdorfer
its the Mac OS X ver. 10.6 (x86, 32-bit), DMG Archive.
[15 Aug 2010 9:49]
Sveta Smirnova
Thank you for the feedback. But I ask about MySQL version, not about Mac OSX version. Please paste file name with package you downloaded.
[15 Aug 2010 9:57]
Derrick Egersdorfer
sure, link details below Link: http://dev.mysql.com/downloads/mirror.php?id=392051 fileName: mysql-5.1.49-osx10.6-x86.dmg thanks
[23 Aug 2010 1:37]
MySQL Verification Team
Cannot reproduce either at this time. Can you try the following method to insert for tests and see if you get the same result? INSERT INTO t1 VALUES (POINT(-26.375604475402035,29.63798828124999)); Then query it using; SELECT AsText(latLng) FROM t1; If you get errors, can you send the output of the following query for each server: mysql> SELECT version();
[23 Sep 2010 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[8 May 2015 12:25]
Norvald Ryeng
Posted by developer: Closed. Can't reproduce.
Description: Ive got tables that store geo location data as type 'Geometry' on two servers. Both servers have the same structure and data etc. But each return different values for the exact same query. How to repeat: Create a table with a field name of latlng and type 'geometry' and insert a point: INSERT INTO table SET latLng=PointFromText(CONCAT('POINT(','-26.375604475402035 29.63798828124999',')')) Suggested fix: Not a clue...