[MDEV-12875] Wrong VIEW column data type for COALESCE(int_column) - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a INT);

CREATE OR REPLACE VIEW v1 AS SELECT COALESCE(a) FROM t1;

DESCRIBE v1;

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

| Field       | Type       | Null | Key | Default | Extra |

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

| COALESCE(a) | bigint(11) | YES  |     | NULL    |       |

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

Notice, the column data type is bigint. The expected data type is int, like in the table t1.

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