SHOW TABLE STATUS shows all temporary tables ignoring database and conditions

create temporary table test.tmp_in_test (a int);

create database db;

use db;

# This should show tables from currently used DB and it is 'db'  - no temporary tables should be visible

show table status;

# The same as before

show table status in db;

# This shouldn't give any results

show table status like 'nonexisting';

# Cleanup

drop database db;

# This should be empty (since db is used)

show table status;

Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment	Max_index_length	Temporary

tmp_in_test	MyISAM	10	Fixed	0	0	0	1970324836974591	1024	0	NULL	2022-04-17 23:46:11	2022-04-17 23:46:11	NULL	latin1_swedish_ci	NULL			17179868160	Y

# This should be empty

show table status in db;

Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment	Max_index_length	Temporary

tmp_in_test	MyISAM	10	Fixed	0	0	0	1970324836974591	1024	0	NULL	2022-04-17 23:46:11	2022-04-17 23:46:11	NULL	latin1_swedish_ci	NULL			17179868160	Y

# This should be empty

show table status like 'nonexisting';

Name	Engine	Version	Row_format	Rows	Avg_row_length	Data_length	Max_data_length	Index_length	Data_free	Auto_increment	Create_time	Update_time	Check_time	Collation	Checksum	Create_options	Comment	Max_index_length	Temporary

tmp_in_test	MyISAM	10	Fixed	0	0	0	1970324836974591	1024	0	NULL	2022-04-17 23:46:11	2022-04-17 23:46:11	NULL	latin1_swedish_ci	NULL			17179868160	Y