information_schema.tables return wrong results with count(*)

[joechenrh]

Bug Report

Please answer these questions before submitting your issue. Thanks!

Queries for infoschema tables still have some case-sensitivity related problems.

1. Minimal reproduce step (Required)

create database test1;
create table test1.Table1;
select count(*) from information_schema.tables where upper(table_name) = "TABLE1";

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

+----------+
| count(*) |
+----------+
|        1 |
+----------+

3. What did you see instead (Required)

+----------+
| count(*) |
+----------+
|        0 |
+----------+

4. What is your TiDB version? (Required)

[joechenrh]

/severity major

[ti-chi-bot]

@joechenrh: These labels are not set on the issue: may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5, may-affects-8.1.

In response to this:

/remove-label may-affects-5.4
/remove-label may-affects-6.1
/remove-label may-affects-6.5
/remove-label may-affects-7.1
/remove-label may-affects-7.5
/remove-label may-affects-8.1

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.