Note
This variable was introduced in V1.4.
Description
The lower_case_table_names variable specifies whether table names are case-sensitive.
Applicability
This variable applies only to MySQL mode of OceanBase Database and takes effect only for database and table object names.
Privilege requirements
Query variables
Users in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a global system variable.Modify variables
After a tenant is created, you cannot modify the value of this variable by using an SQL statement.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 1 |
| Valid values |
|
| Scope | Global |
| Modifiable | No. This variable can be specified only when you create a tenant by using the CREATE TENANT statement. After a tenant is created, you cannot modify the value of this variable by using an SQL statement. |
Examples
The following example shows how to create a tenant by specifying the value of the lower_case_table_names variable as 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;