Maxim Orgiyan

Right, currently we only support EMBEDDED_OID thru Mongo API (as documented [here](https://docs.oracle.com/en/database/oracle/simple-oracle-document-access/adsdi/soda-collection-metadata-components-reference.html#GUID-53AA7D85-80A9-4F98-994F-E3BD91769146)). But we're working on adding it in the SODA drivers. For SODA Java, it's currently planned for the...

Could you please give me an example of a query (just in English) you're trying to write and a JSON document or two that would be expected to match this...

We'll take a look and get back to you, can you please let us know which database release you're trying this against?

Thanks, we'll take a look and get back to you asap.

Reproduced and identified the issue, working on a fix (it's not in the setPayload ... methods). Our apologies for this bug. I'll post an update here very soon.

@aoksenholt @petteja we're working on getting the a new SODA jar out with this fix. Have you compiled SODA from source? If so, would it be helpful to commit the...

@aoksenholt ok, will do that soon (the fix is undergoing our internal testing now).

@aoksenholt @petteja I uploaded the source code fix for this issue, as well as some other efficiency improvements for merge methods. The changes only affect one file, [OracleOperationBuilderImpl.java](https://github.com/oracle/soda-for-java/blob/master/src/oracle/soda/rdbms/impl/OracleOperationBuilderImpl.java). Please feel...

Thank you for the suggestion, makes sense. Will look into adding this.

The default content column storage for SODA collection in 21c is the new [JSON](https://docs.oracle.com/en/database/oracle/oracle-database/21/adjsn/json-in-oracle-database.html#GUID-E075CA14-DC89-4F9D-AD6F-C351F774575A) data type (as long as the "compatible" database parameter is set to 20 or above, which...