Note
This variable is available starting with V1.4.
Description
div_precision_increment specifies the increment of the precision of the result of a division operation based on the precision of the dividend.
Applicability
This variable is applicable only to OceanBase Database in MySQL-compatible mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the values of global system variables.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the values of session system variables.
Modify variables
Global level
systenant can directly modify the values of global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of global system variables.
Session level
systenant and all user tenants can directly modify the values of session system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 4 |
| Value range | [0, 30] |
| Scope |
|
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the increment of the precision of the result of a division operation based on the precision of the dividend to 4.
Global level
obclient> SET GLOBAL div_precision_increment =4;Session level
obclient> SET div_precision_increment =4;