Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.5.22
Description
From https://mariadb.com/kb/en/converting-datetime-to-new-temporal-format/,
|
10.3,10.4 |
MariaDB [test]> CREATE OR REPLACE VIEW v1 AS SELECT timestamp'2001-01-01 10:10:10' AS c1, now() AS c2;
|
Query OK, 0 rows affected (0.001 sec)
|
 |
MariaDB [test]> SHOW COLUMNS IN v1;
|
+-------+----------+------+-----+---------------------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+----------+------+-----+---------------------+-------+
|
| c1 | datetime | NO | | 0000-00-00 00:00:00 | |
|
| c2 | datetime | NO | | 0000-00-00 00:00:00 | |
|
+-------+----------+------+-----+---------------------+-------+
|
|
10.5 |
CREATE OR REPLACE VIEW v1 AS SELECT timestamp'2001-01-01 10:10:10' AS c1, now() AS c2;
|
SHOW COLUMNS IN v1;
|
+-------+----------------------------+------+-----+---------------------+-------+
|
| Field | Type | Null | Key | Default | Extra |
|
+-------+----------------------------+------+-----+---------------------+-------+
|
| c1 | datetime /* mariadb-5.3 */ | NO | | 0000-00-00 00:00:00 | |
|
| c2 | datetime /* mariadb-5.3 */ | NO | | 0000-00-00 00:00:00 | |
|
+-------+----------------------------+------+-----+---------------------+-------+
|
Attachments
Issue Links
- relates to
-
MDEV-19906 Show internal type for TIMESTAMP, DATETIME, and TIME columns
-
- Closed
-