[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 Data type plugin API version 1

relates to

MDEV-10317 EXCTACT(MINUTE_MICROSECOND) truncates data

MCOL-80 EXTRACT() function returned assertion error

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server