ob_compatibility_mode specifies the compatibility mode of a tenant.
| Attribute | Description |
|---|---|
| Type | ENUM |
| Default value | MYSQL |
| Value range | MYSQL: compatible with MySQLORACLE: compatible with Oracle |
| Effective scope | |
| Modifiable | You can set the variable when you create a tenant. After the tenant is created, you cannot modify the variable by executing SQL statements. |
| Involved in serialization | Yes |
The following example shows how to set the value of the ob_capability_mode variable to MYSQL when you use the CREATE TENANT statement to create a tenant:
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;