home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC10 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT37522 Status: Closed

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

product:
INFORMIX SERVER / 5725A3900 / E10 -
Problem 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.
Problem Summary:


Local Fix:




Solution




Workaround


not known / see Local fix


Timestamps


Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

07.07.2021
10.10.2022
10.10.2022


Problem solved at the following versions (IBM BugInfos)




Problem solved according to the fixlist(s) of the following version(s)