ODBC Driver for Couchbase

Build 23.0.8839

UpdateNullValues

Determines whether an UPDATE writes NULL values as NULL, or removes them.

データ型

bool

デフォルト値

true

解説

By default the 本製品 will use NULL values provided in an UPDATE statement and set the field in Couchbase to NULL.

If this option is disabled SQL NULL values in an UPDATE will cause the 本製品 to mark the field as MISSING. This removes the field from the object containing it, or if the field is contained in an array (per FlattenArrays) then that element is set to NULL.

This option should be used with care as the 本製品 may not detect that the field exists if it is removed from enough documents within a bucket.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839