[MDEV-14933] Wrong result caused by UNSIGNED column and UNION ALL - Jira

XML

Word

Printable

SELECT returns wrong data when UNION ALL is used and first table has unsigned column and second table has signed data in this column.

Example:

CREATE TABLE `pokus` (

  `id` INT NOT NULL,

  `unsigned_column` SMALLINT UNSIGNED NOT NULL,

  PRIMARY KEY (`id`));

INSERT INTO `pokus` (`id`, `unsigned_column`) VALUES ('1', '5');

SELECT id, unsigned_column FROM pokus

UNION ALL

SELECT id, -unsigned_column FROM pokus;

result:

'1', '5'

'1', '0'

Second row has 0 in second column, it should have -5.

duplicates

MDEV-9495 Wrong field type for a UNION of a signed and an unsigned INT expression

links to

mysql

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