Skip to content

lower_case_table_names support

There are 5 different modes for the MatrixOne case sensitivity, and the case parameter lower_case_table_names can be set to 0, 1, 2, 3, or 4.

Parameter Explanation

Setting Parameter Value to 0

Setting lower_case_table_names to 0 stores identifiers as the original strings, and name comparisons are case sensitive.

Examples

set global lower_case_table_names = 0;
create table Tt (Aa int);
insert into Tt values (1), (2), (3);

mysql> select Aa from Tt;
+------+
| Aa   |
+------+
|    1 |
|    2 |
|    3 |
+------+
3 rows in set (0.03 sec)

Setting Parameter Value to 1

Setting lower_case_table_names to 1 stores identifiers as lowercase, and name comparisons are case insensitive.

Examples

set global lower_case_table_names = 1;
create table Tt (Aa int);
insert into Tt values (1), (2), (3);

mysql> select Aa from Tt;
+------+
| aa   |
+------+
|    1 |
|    2 |
|    3 |
+------+
3 rows in set (0.03 sec)

set global lower_case_table_names = 1;
create table t(a int);
insert into t values(1), (2), (3);

-- Column aliases display the original string when the result set is returned, but name comparisons are case insensitive, as shown in the following example:
mysql> select a as Aa from t;
+------+
| Aa   |
+------+
|    1 |
|    2 |
|    3 |
+------+
3 rows in set (0.03 sec)

Setting Parameter Value to 2

Setting lower_case_table_names to 2 stores identifiers as the original strings, and name comparisons are case insensitive.

Examples

set global lower_case_table_names = 2;
create table Tt (Aa int);
insert into tt values (1), (2), (3)