json_float_full_precision

Description

json_float_full_precision specifies the precision mode for parsing JSON numbers.

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement, or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE (Oracle mode) or information_schema.GLOBAL_VARIABLES (MySQL mode) view to obtain the values of Global system variables.

  • Session level

    sys tenant and all user tenants can execute the SHOW VARIABLES statement, or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE (Oracle mode) or information_schema.SESSION_VARIABLES (MySQL mode) view to obtain the values of Session system variables.

• Modify variables

  • Global level

    • sys tenant can modify the values of Global system variables.
    • MySQL user tenants need to have the SUPER or ALTER SYSTEM privilege to modify the values of Global system variables.
    • Oracle user tenants need to have the ALTER SYSTEM privilege to modify the values of Global system variables.

  • Session level

    sys tenant and all user tenants can modify the values of Session system variables in their own tenant.

Attributes

Use cases

json_float_full_precision is for compatibility with databases, such as PolarDB, that support similar options. Valid values:

• True: specifies high precision. The parsing speed is slower.
• False: specifies low precision. The parsing speed is faster.

Examples

• Session level

  • Use low precision to parse JSON numbers, which increases parsing speed.

    obclient> SET json_float_full_precision = False;
    

  • Use high precision to parse JSON numbers, which decreases parsing speed.

    obclient> SET json_float_full_precision = True;
    

• Global level

  • Use low precision to parse JSON numbers, which increases parsing speed.

    obclient> SET GLOBAL json_float_full_precision = False;
    

  • Use high precision to parse JSON numbers, which decreases parsing speed.

    obclient> SET GLOBAL json_float_full_precision = True;