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 IC78951 Status: Geschlossen

DB2EXFMT CAN GENERATE A SEGMENTATION FAULT WHEN FORMATTING an SQL STATEMENT
THAT CONTAINS TWO CONSECUTIVE SINGLE QUOTES

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The db2exfmt utility can generate a segmentation fault when 
formatting an SQL statement that contains two consecutive single 
quote marks in character string constants. 
 
 
The chance of the failure occurring will be dependent upon other 
potential factors in the SQL and where on the output line that 
subsequent part of the SQL would be written. 
 
One event occurred when handling parenthesis leading into a 
subselect. 
 
Here is an example of the key elements in the SQL (note, this 
statement however would not necessarily generate a segmentation 
fault): 
 
SELECT A.COL1, 'Test string''s', B.COL2 
FROM TABLE1 A LEFT JOIN ( SELECT COL2 from TABLE 2 ) as B 
 
 
In the above example, the two single quotes in the word: 
string''s 
and the spaces in: "JOIN ( SELECT" 
were required to allow for the potential of the segmentation 
fault. 
 
 
A work around in that case was to remove the spaces around the 
parenthesis, changing the text to: "JOIN(SELECT" 
 
 
The potential stack is: 
print_statement(context_struct*,buffered_list*,int,char*,unsigne 
d 
long,bool)(??, ??, ??, ??, ??, ??) at 0x100015850 
get_print_statement(context_struct*,int,bool)(0x9001000a0001910, 
0x0, 0x100000000000001) at 0x10001bcac 
fmt_STATEMENT(context_struct*)(??) at 0x100016b8c 
process_statements(context_struct*)(??) at 0x10000ba48 
formatExplain(context_struct*,char*,char*,char*,char*,bool*,int* 
)(??, 
??, ??, ??, ??, ??, ??) at 0x1000087ec 
main(??, ??) at 0x10000d9dc
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Problem was first fixed in Version 9.7 Fix Pack 6.           * 
****************************************************************
Local-Fix:
Change the form of the SQL being explained.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Problem was first fixed in Version 9.7 Fix Pack 6.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.09.2011
06.06.2012
06.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList