Overview
lower_case_table_names specifies whether to be case-sensitive.
Applicability
This variable takes effect only for database and table object names.
Privilege requirements
Query variables
Both the
systenant and all user tenants can use theSHOW VARIABLESstatement or theinformation_schema.GLOBAL_VARIABLESview (in MySQL-compatible mode) to view the values of global system variables.Modify variables
After a tenant is created, this variable cannot be modified using SQL statements.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | int |
| Default Value | 1 |
| Value range |
|
| Effective Scope | Global |
| Modifiable | No, this variable can only be used withCREATE TENANTThe tenant name is specified when the tenant is created and cannot be modified via SQL statements after the tenant is created. |
Configuration example
The following example shows how to use the CREATE TENANT statement to create a tenant with the lower_case_table_names variable set to 0:
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;