IBM Support

IT37522: BSON_UPDATE() WITH UPDATE_DOC PARAMETER SET TO EMPTY JSON DOCUMENT '{ }' REMOVES ALL ENTRIES FROM BSON DOCUMENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as user error.

Error description

  • select
    bson_value::JSON as initial,
        bson_update_value::JSON as updated,
        bson_update_empty_set::JSON as updated_empy_set
    FROM (
        select
            data as bson_value,
            bson_update(data, '{}') as bson_update_value,
            bson_update(data, '{$set:{}}') as bson_update_empty_set
        from (
            select '{"test":"value"}'::JSON as data FROM systables
    where tabid = 1))
    
    initial           {"test":"value"}
    updated           {}
    updated_empy_set  {"test":"value"}
    
    Expected woule be that all three values contain the
    '{"test":"value"}' object.
    

Local fix

Problem summary

Problem conclusion

Temporary fix

Comments

  • Working as per designed architecture
    

APAR Information

  • APAR number

    IT37522

  • Reported component name

    INFORMIX SERVER

  • Reported component ID

    5725A3900

  • Reported release

    E10

  • Status

    CLOSED USE

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-07-07

  • Closed date

    2022-10-10

  • Last modified date

    2022-10-10

  • 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":"E10"}]

Document Information

Modified date:
10 October 2022