IBM Support

IC79661: SQL412N IS RETURNED WHEN A PREDICATE THAT ALLOWS MULTIPLE COLUMNS CONTAINS MORE THAN ONE SCALAR SUBSELECTS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • SQL412N is incorrectly returned when more than one scalar
    subselects are specified in a predicate that allows multiple
    columns.
    
    Example:
    
    select *
    from t1
    where ((select i1 from t1 where i1 = 1), (select i2 from t1
    where i1 =2)) = (2,3);
    

Local fix

Problem summary

  • Fixed in v9.7 fixpack 6
    

Problem conclusion

  • Uprade to v9.7 fixpack 6
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC79661

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-11-07

  • Closed date

    2012-06-12

  • Last modified date

    2012-06-12

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

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

    IC84220

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC79661

Modified date: 12 June 2012