Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 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