IBM Support

IT32447: A QUERY WITH JOIN AND UNION WHICH USES SAME ALIAS ON PROJECTION LIST GIVES 26088 ERROR

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • A query like:
    
    SELECT e.col1 , e.col2
    FROM table_e  AS e
    INNER JOIN
    (
      SELECT i.col1 AS col1
       FROM table_t t, table_a i
       WHERE t.invoice = i.invoice
        AND i.period_end = "10/15/2017"
    
    
      UNION
      SELECT i.col1 AS col1
       FROM table_t t, table_a i
       WHERE t.invoice = i.invoice
        AND i.period_end = "10/31/2017"
    
    ) AS t
    ON e.col1     = t.col1
    
    Throws:
    
    26088: A CTE must have a non-recursive sub-query and at most one
    recursive sub-query.
    
    trapping the error
    
    19:11:28  Stack for thread: 284 sqlexec
    
     base: 0x0000000048539000
      len:   102400
       pc: 0x00000000014e501d
      tos: 0x000000004854e9c0
    state: running
       vp: 8
    
    0x00000000014e501d (oninit) afstack
    0x00000000014e9d5d (oninit) afhandler
    0x00000000014ea372 (oninit) affail_interface
    0x0000000000f12f40 (oninit) check_traperror
    0x0000000000797631 (oninit) sqerr
    0x00000000006aa1b4 (oninit) union2cb
    0x00000000006a96fe (oninit) union2cb
    0x00000000006ad965 (oninit) unionsubq2cb
    0x00000000006e7c59 (oninit) usubq2expr
    0x00000000006e84ad (oninit) collsubq2expr.isra.24
    0x00000000006f5d31 (oninit) expr2expr
    0x00000000006d676a (oninit) tlgetcolltab
    0x00000000006d8c3f (oninit) tlgetddtab_trace
    0x00000000006d8fe8 (oninit) spgettab
    0x00000000006d92ba (oninit) tlp2tnode
    0x00000000006da1ac (oninit) tbl2tab
    0x00000000006a7cdd (oninit) sel2cb
    0x00000000006acf11 (oninit) qblk2cb
    0x00000000006c0fac (oninit) stmt2cb
    0x00000000006c3d9d (oninit) p_sp2cb
    0x0000000000ade335 (oninit) parsecmd
    0x0000000000adea13 (oninit) sqcmd
    0x0000000000adf09d (oninit) sq_prepare
    0x0000000000bc655e (oninit) sqmain
    0x0000000001613a7a (oninit) spawn_thread
    0x00000000014d5cf2 (oninit) th_init_initgls
    0x000000000151c00f (oninit) startup
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of Informix Server prior to 14.10.xC4.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Informix Server 14.10.xC4.                         *
    ****************************************************************
    

Problem conclusion

  • Fixed in Informix Server 14.10.xC4.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32447

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-04-03

  • Closed date

    2020-06-09

  • Last modified date

    2020-06-09

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

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

Fix information

  • Fixed component name

    INFORMIX SERVER

  • Fixed component ID

    5725A3900

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"E10","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
10 June 2020