home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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