Note
This variable is available starting with V1.4.
Description
lower_case_table_names specifies whether to be case-sensitive.
Applicability
This variable is available only in MySQL-compatible mode of OceanBase Database, and applies only to database and table names.
Privilege requirements
Query variables
You can execute the
SHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL-compatible mode) to view the value of a Global system variable in thesystenant and all user tenants.Modify variables
After a tenant is created, you cannot modify the value of this variable by executing an SQL statement.
Attributes
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 1 |
| Value range |
|
| Scope | Global |
| Modifiable | No. This variable can be specified only when you execute the CREATE TENANT statement to create a tenant. After a tenant is created, you cannot modify the value by executing an SQL statement. |
Examples
The following example shows how to specify the value of the lower_case_table_names variable as 0 when you execute the CREATE TENANT statement to create a tenant:
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;