Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL)
Description
I run this script:
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (a TIMESTAMP); |
DROP TABLE IF EXISTS t2; |
CREATE TABLE t2 AS SELECT |
MAX(a), |
COALESCE(a), |
COALESCE(MAX(a)), |
MAX(COALESCE(a)) |
FROM t1; |
SHOW CREATE TABLE t2; |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Table | Create Table |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| t2 | CREATE TABLE `t2` (
|
`MAX(a)` timestamp NULL DEFAULT NULL,
|
`COALESCE(a)` timestamp NULL DEFAULT NULL,
|
`COALESCE(MAX(a))` timestamp NULL DEFAULT NULL,
|
`MAX(COALESCE(a))` datetime DEFAULT NULL
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
|
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
Notice, it creates TIMESTAMP fields for all expression but MAX(COALESCE(a)). Looks confusing.
Moreover, if I run the client as:
mysql --column-type-info test
|
and execute this script:
SELECT
|
MAX(a), |
COALESCE(a), |
COALESCE(MAX(a)), |
MAX(COALESCE(a)) |
FROM t1; |
Field 1: `MAX(a)`
|
Type: TIMESTAMP
|
...
|
Field 2: `COALESCE(a)`
|
Type: TIMESTAMP
|
...
|
Field 3: `COALESCE(MAX(a))`
|
Type: TIMESTAMP
|
...
|
Field 4: `MAX(COALESCE(a))`
|
Type: TIMESTAMP
|
Collation: binary (63)
|
It correctly reports TIMESTAP for all columns.
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
-
- Closed
-
Activity
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Component/s | Temporal Types [ 11000 ] | |
| Component/s | OTHER [ 10125 ] |
| Labels | datatype |
| issue.field.resolutiondate | 2017-04-25 07:06:16.0 | 2017-04-25 07:06:16.548 |
| Fix Version/s | 10.3.1 [ 22532 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 80456 ] | MariaDB v4 [ 152008 ] |