In MariaDB 11.2.2, SHOW TABLES LIKE '...' can show temporary tables with names that do not match the pattern. (I haven't fully figured out yet whether it always shows all temporary tables regardless of name and pattern, or whether they are sometimes not shown after all. But it seems to show them a lot of the time.)

To reproduce on a fresh install:

CREATE DATABASE db; USE db;

CREATE TABLE realtable (a INT); CREATE TEMPORARY TABLE temptable (a INT);

SHOW TABLES LIKE 'faketable';

Expected result: 0 rows; actual result: 1 row, "temptable".

Can be tested using the official Docker images; an interactive shell can be obtained with commands like the following:

docker run --rm --env MARIADB_ROOT_PASSWORD=root --name=T352695 mariadb:11.2.2

docker exec -it T352695 mariadb -uroot -proot

For the record, we're tracking this at Wikimedia as T352695, though I don't think there's any information useful for MariaDB devs over there.

MDEV-28334 is the closest-feeling existing issue I'm aware of (but probably not the same).