DB2 - Problembeschreibung
Problem IC63707 | Status: Geschlossen |
INVALID WKT IS BEING RETURNED FOR SOME COMPLEX MULTIPOLYGON GEOMETRIES | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
A customer reported a problem getting invalid WKT format data from the ST_AsText() spatial function. For the following multipolygon geometry the wrong value is returned: VALUES VARCHAR(db2gse.ST_GEOMETRY('MULTIPOLYGON (((10 10, 15 15, 5 15, 10 10)),((5 5, 15 5, 10 10, 5 5)))',0)..ST_AsText(),200) 1 ---------------------------------------------------------------- ---------------------------------------------------------------- ---------------------------------------------------------------- -------- MULTIPOLYGON (((10 10, 15 15, 5 15, 10 10),((5 5, 15 5, 10 10, 5 5))) In the above output there is a missing right-paren after '10 10'. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All Spatial Extender * **************************************************************** * PROBLEM DESCRIPTION: * * The ST_AsText spatial function might return and invalid * * well-known text (WKT) representation in some cases for * * multipolygon geometries. * * * * For the following multipolygon geometry the wrong value is * * returned: * * * * VALUES VARCHAR(db2gse.ST_GEOMETRY('MULTIPOLYGON (((10 10, 15 * * 15,5 15, 10 10)),((5 5, 15 5, 10 10, 5 * * 5)))',0)..ST_AsText(),200) * * 1 * * -------------------------------------------------------------- * * * MULTIPOLYGON (((10 10, 15 15, 5 15, 10 10),((5 5, 15 5, 10 * * 10, 5 5))) * * * * In the above output there is a missing right-paren after '10 * * 10'. * **************************************************************** * RECOMMENDATION: * * Install V9.5 FP6 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
Install V9.5 FP6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC64941 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 12.10.2009 02.12.2009 17.09.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |