CREATE_TIME is not populated for temporary InnoDB tables

--source include/have_innodb.inc

drop table if exists tbase_innodb, ttmp_innodb;

create table tbase_innodb (a int) engine=InnoDB;

create temporary table ttmp_innodb (a int) engine=InnoDB;

select table_name, table_type, create_time, update_time from information_schema.tables where table_schema = 'test' order by table_name;

--sleep 2

insert into tbase_innodb values (1);

insert into ttmp_innodb values (1);

select table_name, table_type, create_time, update_time from information_schema.tables where table_schema = 'test' order by table_name;

# Cleanup

drop table if exists tbase_innodb, ttmp_innodb;

create temporary table ttmp_innodb (a int) engine=InnoDB;

select table_name, table_type, create_time, update_time from information_schema.tables where table_schema = 'test' order by table_name;

table_name	table_type	create_time	update_time

tbase_innodb	BASE TABLE	2022-04-17 21:55:00	NULL

ttmp_innodb	TEMPORARY	NULL	NULL

insert into tbase_innodb values (1);

insert into ttmp_innodb values (1);

select table_name, table_type, create_time, update_time from information_schema.tables where table_schema = 'test' order by table_name;

table_name	table_type	create_time	update_time

tbase_innodb	BASE TABLE	2022-04-17 21:55:00	2022-04-17 21:55:02

ttmp_innodb	TEMPORARY	NULL	2022-04-17 21:55:02