SQL JSON functions duplicate key handling change

In IBM® i 7.2 with PTFs SI67881 and SI67815, the handling of duplicate keys in JSON functions has changed.

The JSON_TABLE, JSON_QUERY, JSON_VALUE. and JSON_TO_BSON functions will now tolerate documents containing duplicate key values and will process one of the values.

The default behavior of the JSON_OBJECT and JSON_OBJECTAGG functions has changed to allow generation of duplicate keys. A new clause has been added to the syntax, WITH UNIQUE KEYS or WITHOUT UNIQUE KEYS, to control whether keys generated by the function are enforced as unique. The default is WITHOUT UNIQUE KEYS.

Refer to the updated SQL Reference in the IBM Knowledge Center for more detail.