Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0.3, 5.5.32, 5.3.12
-
None
-
None
Description
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.
Attachments
Issue Links
- is blocked by
-
MDEV-4724 Some temporal functions do not preserve microseconds
- Closed