Wrong Result In SDO_UTIL.TO_WKTGEOMETRY After Applying Recommended Spatial Patch 34390759
(Doc ID 2930557.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Spatial and Graph - Version 19.15.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
Wrong result in SDO_UTIL.TO_WKTGEOMETRY after applying recommended spatial patch 34390759
This is from the 19.15 DB without merge patch 34390759:
WKTGEOMETRY: ((502470.53 68130.87, 502475.68 68114.94, 502483.03 68117.62, 502491.86 68117.87, 502491.62 68126.7, 502482.05 68126.45, 502479.6 68134.3, 502470.53 68130.87))
MDSYS.SDO_GEOMETRY: (2003,3794,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(502470.53,68130.87,502475.68,68114.94,502483.03,68117.62,502491.86,68117.87,502491.62,68126.7,502482.05,68126.45,502479.6,68134.3,502470.53,68130.87))
This is from 19.15 after applying merge patch 34390759:
WKTGEOMETRY: ((502470.53000000002794 68130.869999999995343, 502475.679999999993015 68114.940000000002328, 502483.03000000002794 68117.619999999995343, 502491.85999999998603 68117.869999999995343, 502491.619999999995343 68126.69999999999709, 502482.049999999988358 68126.44999999999709, 502479.600000000034925 68134.30000000000291, 502470.53000000002794 68130.869999999995343))
MDSYS.SDO_GEOMETRY: (2003,3794,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(502470.53,68130.87,502475.68,68114.94,502483.03,68117.62,502491.86,68117.87,502491.62,68126.7,502482.05,68126.45,502479.6,68134.3,502470.53,68130.87))
WKTGEOMETRY has lots more than two decimals 68130.869999999995343 instead of 68130.87 and this is causing problems to end users.
Changes
Apply merge patch 34390759
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |