|
Problem IT35581
|
Status: Closed |
SEGV OCCURS WHILE PREPARING A QUERY WITH AN XML PREDICATE THAT CONTAINS ANY EMPTY STRING LITERAL, RESULTS IN SQL1224N.
|
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
The segv/trap occurs when:
The XML search condition includes an empty string e.g.
/book[price=""]
/book[price>""]
/book[price/text()!=""]
An XML index with DOUBLE data type exists on the expression used
in the predicate e.g. CREATE INDEX ON
bookstore(bookdetails) GENERATE KEY USING XMLPATTERN
'/book/price' AS SQL double;
XML histogram statistics exist for the expression used in the
predicate and the index. XML statistics are not visible in the
system catalog views so db2cat must be used to display them.
The trap is sustainable. The application will receive:
SQL1224N The database manager is not able to accept new
requests,
has terminated all requests in progress, or has terminated the
specified
request because of an error or a forced interrupt.
SQLSTATE=55032
The stack trace will include
sqlno_xml_stats_interface11convLiteral |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* The segv/trap occurs when: *
* The XML search condition includes an empty string e.g. *
* /book[price=""] *
* /book[price>""] *
* /book[price/text()!=""] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v111m4fp7 or v11.5(already fixed). *
**************************************************************** |
| Local Fix: |
Either of these approaches will avoid the trap:
- Exclude XML statistics by issuing RUNSTATS with the EXCLUDING
XML COLUMNS clause
- Drop the index on the XML expression |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* all *
****************************************************************
* PROBLEM DESCRIPTION: *
* The segv/trap occurs when: *
* The XML search condition includes an empty string e.g. *
* /book[price=""] *
* /book[price>""] *
* /book[price/text()!=""] *
****************************************************************
* RECOMMENDATION: *
* Upgrade to db2_v111m4fp7 or v11.5(already fixed). *
**************************************************************** |
| Comment |
First fixed in db2_v111m4fp7 |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.01.2021
02.09.2021
02.09.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
