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
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) or 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 theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (MySQL-compatible mode) to view the values of session system variables.
Modify variables
After a tenant is created, you cannot modify the value of this variable by using an SQL statement.
Attributes
| Attribute | Description |
|---|---|
| Type | Enum |
| Default value | MYSQL |
| Value range |
|
| Scope |
|
| Modifiable | No. You can specify this variable when you create a tenant. After a tenant is created, you cannot modify the value by using an SQL statement. |
Examples
Here is an example of creating a tenant by using the CREATE TENANT statement and setting 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;