[MDEV-4843] Wrong data type for TIMESTAMP('2001-01-01','10:10:10') - Jira

XML

Word

Printable

This script

drop table if exists t1;

create table t1 as  select timestamp('2001-01-01','10:10:10') as a;

show columns from t1;

creates a VARCHAR(26) column:

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

| Field | Type        | Null | Key | Default | Extra |

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

| a     | varchar(26) | YES  |     | NULL    |       |

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

The expected result is a DATETIME column.

Note: MySQL-5.6 correctly creates a DATETIME column in this scenario.

is blocked by

MDEV-4724 Some temporal functions do not preserve microseconds