type_temporal_innodb.test fails with --mysqld=--big-tables=1

--echo # MDEV-17969 Assertion `name' failed in THD::push_warning_truncated_value_for_field

CREATE TABLE t1 (c1 DATE , c2 TIMESTAMP) ENGINE=InnoDB;

INSERT INTO t1  VALUES ('2006-07-17','0000-00-00 00:00:00');

CREATE TABLE t2 (pk INT, a1 TIME) Engine=InnoDB;

INSERT INTO t2 VALUES (6,'00:00:00');

SET SESSION sql_mode= 'strict_all_tables,no_zero_date';

--error ER_TRUNCATED_WRONG_VALUE

CREATE TABLE tbl SELECT * FROM t1 WHERE t1.c1 = (SELECT c2 FROM t2 WHERE pk = 6);

# ^^^ there is no column c2 in table t2