--echo #
--echo # Bug#55826: create table .. select crashes with when KILL_BAD_DATA 
--echo #  is returned
--echo #
-- source include/have_innodb.inc
CREATE TABLE t1(a INT) ENGINE=innodb;
INSERT INTO t1 VALUES (0);
SET SQL_MODE='STRICT_ALL_TABLES';
--error ER_TRUNCATED_WRONG_VALUE
CREATE TABLE t2 
  SELECT LEAST((SELECT '' FROM t1),NOW()) FROM `t1`;
DROP TABLE t1;  
SET SQL_MODE=DEFAULT;