Show tables Compatibility differences

[unhappydepig]

We use tidb and elastic-job。
We have create job_execution_log in tidb。However, at startup, the program will also try to rebuild the table, because the table already exists, so the program will report an error.

By checking the source code, it is found that elastic job uses 【SHOW FULL TABLES LIKE 'JOB_EXECUTION_LOG';】 No results were returned。when we use lowercase [SHOW FULL TABLES LIKE 'job_execution_log';]It can return normally。

When we use MySQL。Whether in large or lowercase It can return normally。

[hawkingrei]

/assign

[hawkingrei]

dup of #29910

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.