Note
This variable is available starting with V4.0.0.
Description
log_row_value_options specifies whether to enable partial updates for LOB data.
Applicability
This variable is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to obtain the values of global system variables.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL mode) to obtain the values of session system variables.
Modify variables
Global level
systenant can directly modify the values of global system variables.MySQL user tenants can modify the values of global system variables only if they have the
SUPERorALTER SYSTEMprivilege.
Session level
systenant and all user tenants can directly modify the values of session system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | Empty string |
| Value range | ['', 'partial_json']
|
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Usage
When the value is set to partial_json, partial updates are enabled. When you use the json_set, json_remove, or json_replace expression to update JSON data, partial updates are used instead of incremental updates. This improves the performance of updating large JSON data.
Examples
Enable partial updates for LOB data.
Session level
obclient> SET log_row_value_options="partial_json";Global level
obclient> SET GLOBAL log_row_value_options="partial_json";