IBM Support

IT29270: GENBSON() CAN CREATE INVALID BSON BUT SHOULD RETURN AN ERROR INSTEAD

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error description

  • Example:
    
    SELECT genbson(row("longname", "shortname"), 1, 1)::JSON FROM (
         (SELECT 'AA' as shortname, 'BB' as longname
             FROM systables WHERE tabid = 1) as a);
    
    generates
    
    (expression)  {"":"longname","":"shortname"}
    
    but {"":"longname","":"shortname"} is invalid bson.
    genbson() should return an error instead.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * see Error Description                                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * see Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • see Error Description
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT29270

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    C10

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-05-27

  • Closed date

    2022-07-26

  • Last modified date

    2022-09-08

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

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"C10"}]

Document Information

Modified date:
08 September 2022