IBM Support

IT29337: 'SQL0901 BAD PLAN; UNRESOLVED QNC FOUND' WHEN CALLING A TABLE FUNCTION WITH CSE REFERENCING A FUNCTION ARGUMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as returned (APAR cannot be resolved without additional info from IBM or customer.)

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

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
    

Problem summary

Problem conclusion

Temporary fix

Comments

  • Defect returned since the problem cannot recreated and the
    diagnostic data is no long available
    

APAR Information

  • APAR number

    IT29337

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED RET

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-06-04

  • Closed date

    2021-12-07

  • Last modified date

    2021-12-07

  • APAR is sysrouted FROM one or more of the following:

    IT29145

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 May 2022