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 | |
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 |