Note
- For OceanBase Database V4.3.x, this variable was introduced in OceanBase Database V4.3.1.
- For OceanBase Database V4.2.x, this variable was introduced in OceanBase Database V4.2.2.
Description
log_row_value_options specifies whether Large Object (LOB) fields use partial updates.
Applicability
This variable is applicable to only OceanBase Database in MySQL mode.
Limitations
Query the variable
Global-level operation
In the
systenant or a user tenant, you can execute theSHOW VARIABLESstatement to query the variable at the global level or query theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) for the variable at the global level.Session-level operation
In the
systenant or a user tenant, you can execute theSHOW VARIABLESstatement to query the variable at the session level or query theinformation_schema.SESSION_VARIABLESview (in MySQL mode) for the variable at the session level.
Modify the variable
Global-level operation
In the
systenant, you can directly change the value of the variable at the global level.In a MySQL user tenant, you must have the
SUPERorALTER SYSTEMprivilege to change the value of the variable at the global level.
Session-level operation
In the
systenant or a user tenant, you can directly change the value of the variable at the session level for the current tenant.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | Empty string |
| Value range | ['', 'partial_json']''
|
| Effective scope |
|
| Modifiable | Yes. You can use the SET statement to modify the variable. |
Considerations
The value partial_json specifies to enable partial updates for JSON data. When you update JSON data by using the JSON_SET, JSON_REMOVE, or JSON_REPLACE expression, partial updates, instead of incremental updates, are performed. This can improve the performance of updating large-sized JSON data.
Examples
Enable partial updates for JSON data of LOB type.
Session-level operation
obclient> SET log_row_value_options="partial_json";Global-level operation
obclient> SET GLOBAL log_row_value_options="partial_json";