Query information_schema.tables with table_name is case

[lizhenhuan]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
create table test(id varchar(32));
execute sql : select * from information_schema.tables where table_name = 'test';
It returns one row
execute sql : select * from information_schema.tables where table_name = 'TEST';
It returns empty

2. What did you expect to see? (Required)

Query information_schema.tables with table_name column should case insensitivity just like MySQL.
MySQL result：

3. What did you see instead (Required)

Query information_schema.tables with table_name column should case sensitivity

4. What is your TiDB version? (Required)

select tidb_version();
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version() |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v6.1.3
Edition: Community
Git Commit Hash: 6b02a5d
Git Branch: heads/refs/tags/v6.1.3
UTC Build Time: 2022-11-26 07:36:17
GoVersion: go1.19.3
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

TiDB other version also has this problem

Related issue: #7518

[lizhenhuan]

[easonn7]

lower_case_table_names will affect the string related column query behavior of information_schema.tables, we can follow the behavior of MySQL.

[kennedy8312]

/type compatibility