|
Problem IC66028
|
Status: Closed |
ALLOW SIMPLIFICATION OF EXPRESSIONS AS " COL LIKE (CASE WHEN EXPRESSION THEN ACTION ELSE ELSE END)." |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
This apar will allow predicates with the following pattern :
col LIKE (CASE WHEN expression THEN action ELSE else END).
to be simplified by the query rewrite component of the query
compiler if the "expression" in the case statement can be
evaluated at compile time.
This will improve filter factor estimates for the compiler and
will avoid non optimal access plans. |
| Problem Summary: |
This apar will allow predicates with the following pattern :
col LIKE (CASE WHEN expression THEN action ELSE else END).
to be simplified by the query rewrite component of the query
compiler if the "expression" in the case statement can be
evaluated at compile time.
This will improve filter factor estimates for the compiler and
will avoid non optimal access plans. |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
apar IC66028
module engn_sqnr
fixed >= v97 fpk2 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 02.02.2010
06.07.2010
06.07.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FPk2
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
