[MDEV-10309] COALESCE(12345678900) makes a column of a wrong type and truncates the data - Jira

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 AS SELECT 12345678900 AS c1, COALESCE(12345678900) AS c2;

SELECT * FROM t1;

SHOW CREATE TABLE t1;

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

| c1          | c2         |

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

| 12345678900 | 2147483647 |

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

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

| Table | Create Table                                                                                                   |

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

| t1    | CREATE TABLE `t1` (

  `c1` bigint(11) NOT NULL,

  `c2` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1 |

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

The expected result to create a BIGINT column for both expressions, and return 12345678900 for both columns.

blocks

MDEV-4912 Add a plugin to field types (column types)

relates to

MDEV-10317 EXCTACT(MINUTE_MICROSECOND) truncates data

MCOL-80 EXTRACT() function returned assertion error