|
In MySQL 5.6, the syntax TIME 'str' and alike is recognized and the type is taken into account.
In previous versions of MySQL and in MariaDB, including 10.0, the syntax is accepted, but the type is ignored, and the str is treated as a string. It can cause various incompatibilities between MySQL 5.6 and MariaDB 10.0.
MariaDB 10.0:
CREATE TABLE t1 AS SELECT TIME'12:12:12' AS t, DATE'2012-12-12' AS d, TIMESTAMP'2012-12-12 12:12:12' AS ts;
|
SHOW CREATE TABLE t1;
|
+-------+-------------------------------------------------------+
|
| Table | Create Table |
|
+-------+-------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`t` varchar(8) NOT NULL DEFAULT '',
|
`d` varchar(10) NOT NULL DEFAULT '',
|
`ts` varchar(19) NOT NULL DEFAULT ''
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+-------------------------------------------------------+
|
MySQL 5.6:
CREATE TABLE t1 AS SELECT TIME'12:12:12' AS t, DATE'2012-12-12' AS d, TIMESTAMP'2012-12-12 12:12:12' AS ts;
|
SHOW CREATE TABLE t1;
|
+-------+----------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------+
|
| t1 | CREATE TABLE `t1` (
|
`t` time NOT NULL DEFAULT '00:00:00',
|
`d` date NOT NULL DEFAULT '0000-00-00',
|
`ts` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------+
|
|