SHOW OPEN TABLES IN DB1 -- is case insensitive with lower-case-table-names=0

CREATE DATABASE db1;

CREATE TABLE db1.t1 (a INT);

SELECT * FROM db1.t1;

SHOW OPEN TABLES IN DB1;

+----------+-------+--------+-------------+

| Database | Table | In_use | Name_locked |

+----------+-------+--------+-------------+

| db1      | t1    |      0 |           0 |

+----------+-------+--------+-------------+