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 |
