DB2 - Problem description
Problem IT29145 | Status: Closed |
'SQL0901 BAD PLAN; UNRESOLVED QNC FOUND' WHEN CALLING A TABLE FUNCTION WITH CSE REFERENCING A FUNCTION ARGUMENT. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
User might observe SQL0901 error when running a select statement with the following characteristics: 1) The query calls a table function with an argument 2) The query is joining the result of the table function with another table, and the joining column is passed to the table function as an input argument. 3) The input argument is being referenced by the subquery inside the table function. 4) The subquery inside the table function has outer joins. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems on all Linux, Unix and Windows platforms at * * service levels Version 10.5 GA through to Version 10.5 Fix * * Pack 10 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 11 or higher. See * * "Local Fix" portion for other suggestions. * **************************************************************** | |
Local Fix: | |
Workaround: Modify the join predicate between the table function and the table like: table_function.c1 = table.c1 -> table_function.c1 + 0 = table.c1 + 0 | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : follow-up : IT29337 | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 15.05.2019 28.06.2020 28.06.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |