Note
This variable is available starting with V1.4.
Description
ob_compatibility_mode specifies the compatibility mode of a tenant.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a global system variable.Session level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the value of a session system variable.
Modify variables
After a tenant is created, you cannot modify the value of this variable by executing an SQL statement.
Attributes
| Attribute | Description |
|---|---|
| Type | Enum |
| Default value | MYSQL |
| Value range |
|
| Scope |
|
| Modifiable | No. You can specify the value of this variable when you create a tenant. After a tenant is created, you cannot modify the value of this variable by executing an SQL statement. |
Examples
The following example shows how to create a tenant and set the value of the ob_compatibility_mode variable to MYSQL:
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;