CREATE TABLE t1 (i INT);

# For 10.3 the next statement needs to be changed to VALUE(i)

CREATE TABLE t2 AS SELECT VALUES(i) AS a FROM t1;

SHOW CREATE TABLE t2;

# Cleanup

DROP TABLE IF EXISTS t1, t2;

MariaDB [test]> SHOW CREATE TABLE t2;

+-------+------------------------------------------------------------------------------------+

| Table | Create Table                                                                       |

+-------+------------------------------------------------------------------------------------+

| t2    | CREATE TABLE `t2` (

  `a` null DEFAULT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1 |

+-------+------------------------------------------------------------------------------------+

1 row in set (0.00 sec)

MariaDB [test]> CREATE TABLE t2 AS SELECT VALUES(i) AS a FROM t1;

ERROR 1005 (HY000): Can't create table `test`.`t2` (errno: 168 "Unknown (generic) error from engine")

MariaDB [test]> SHOW WARNINGS;

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+

| Level   | Code | Message                                                                                                                                      |

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+

| Warning | 1005 | Error creating table 'test/t2' with column 'a'. Please check its column type and try to re-create the table with an appropriate column type. |

| Error   | 1005 | Can't create table `test`.`t2` (errno: 168 "Unknown (generic) error from engine")                                                            |

| Warning | 1030 | Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB                                                               |

+---------+------+----------------------------------------------------------------------------------------------------------------------------------------------+

3 rows in set (0.00 sec)