ob_compatibility_mode

Description

ob_compatibility_mode specifies the compatibility mode of a tenant.

Privilege requirements

• Query variables

  • Global level

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

  • Session level

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

• Modify variables

  After a tenant is created, you cannot modify the value of this variable by executing an SQL statement.

Attributes

Examples

The following example shows how to specify the value of the ob_compatibility_mode variable as MYSQL when you create a tenant by using the CREATE TENANT statement.

obclient> CREATE TENANT IF NOT EXISTS t1 zone_list = ('zone1'), primary_zone = 'zone1', resource_pool_list = ('pool1') SET ob_compatibility_mode = 'MYSQL',lower_case_table_names = 0;