[MDEV-11554] Wrong result for CASE on a mixture of signed and unsigned expressions - Jira

XML

Word

Printable

This problem is similar to ~~MDEV-11497~~, but now for the simple CASE operator:

CASE suffers from the same problem:

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a BIGINT, b BIGINT UNSIGNED);

INSERT INTO t1 VALUES (-9223372036854775808,18446744073709551615);

SELECT

  CASE -1

    WHEN -9223372036854775808 THEN 'one'

    WHEN 18446744073709551615 THEN 'two'

  END;

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

| CASE -1

    WHEN -9223372036854775808 THEN 'one'

    WHEN 18446744073709551615 THEN 'two'

  END |

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

| two                                                                                             |

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

The expected result is to return NULL.

blocks

MDEV-4912 Data type plugin API version 1

relates to

MDEV-11555 CASE with a mixture of TIME and DATETIME returns a wrong result

MDEV-11497 Wrong result for (int_expr IN (mixture of signed and unsigned expressions))

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