I_S.CHECK_CONSTRAINTS, COLUMNS etc. do not show temporary tables

create temporary table ttemp (a int check(a>=0), check(a>0));

create table tbase (b int check(b>=0), check(b>0));

select table_name, table_type, temporary from information_schema.tables where table_name in ('ttemp','tbase');

select table_name, constraint_name, level, check_clause from information_schema.check_constraints where table_name in ('ttemp','tbase');

# Cleanup

drop table tbase;

create temporary table ttemp (a int check(a>=0), check(a>0));

create table tbase (b int check(b>=0), check(b>0));

select table_name, table_type, temporary from information_schema.tables where table_name in ('ttemp','tbase');

table_name	table_type	temporary

ttemp	TEMPORARY	Y

tbase	BASE TABLE	N

select table_name, constraint_name, level, check_clause from information_schema.check_constraints where table_name in ('ttemp','tbase');

table_name	constraint_name	level	check_clause

tbase	b	Column	`b` >= 0

tbase	CONSTRAINT_1	Table	`b` > 0

drop table tbase;