IBM Support

IT02702: A SELECT STATEMENT FROM A VIEW WITH A SUBSELECT RETURNS ERROR -392

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

  • Running a select against a view that has a correlated subquery
    and IFX_FOLDVIEW is enabled (default), might fail with error
    -392
    
        392: System error - unexpected null pointer encountered.
      Error in line 1
      Near character position 52
    
    With a trap enabled for error -392, the following stack is
    observed:
    
     11:07:30  Stack for thread: 3037 sqlexec
    
     oninit :: afstack
     oninit :: afhandler
     oninit :: affail_interface
     oninit :: check_traperror
     oninit :: sqerr
     oninit :: opcsqp
     oninit :: op_opinit
     oninit :: sqoptim
     oninit :: bldstructs
     oninit :: sqcmd
     oninit :: sq_cmnd
     oninit :: sq_prepare
     oninit :: sqmain
     oninit :: listen_verify
     oninit :: spawn_thread
     oninit :: th_init_initgls
     oninit :: startup
    

Local fix

  • If you disable IFX_FOLDVIEW so the view cannot be folded /
    merged into the optimized query or you remove the views
    subquery, the select runs successfully.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to IDS-12.10.xC5                                      *
    ****************************************************************
    

Problem conclusion

  • Problem Fixed In IDS-12.10.xC5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT02702

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-20

  • Closed date

    2015-10-16

  • Last modified date

    2015-10-16

  • 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

  • RA10 PSN

       UP

  • RA10 PSY

       UP

  • RB10 PSN

       UP

  • RB10 PSY

       UP

  • RB50 PSN

       UP

  • RB50 PSY

       UP

  • RB70 PSN

       UP

  • RB70 PSY

       UP

  • RC10 PSN

       UP

  • RC10 PSY

       UP

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

Document Information

Modified date:
16 October 2015