[MDEV-27100] Subquery using the ALL keyword on UUID columns produces a wrong result - Jira

XML

Word

Printable

The problem reported in ~~MDEV-27098~~ for TIME is repeatable with the UUID data type.

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (d UUID);

INSERT INTO t1 VALUES ('00000000-0000-0000-0000-111111111111'), ('11111111-0000-0000-0000-000000000000');

SELECT * FROM t1 WHERE d >= ALL (SELECT * FROM t1);

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

| d                                    |

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

| 00000000-0000-0000-0000-111111111111 |

| 11111111-0000-0000-0000-000000000000 |

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

The expected result should contain only one with with the maximum value '00000000-0000-0000-0000-111111111111'.

SELECT * FROM t1 WHERE d <= ALL (SELECT * FROM t1);

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

| d                                    |

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

| 00000000-0000-0000-0000-111111111111 |

| 11111111-0000-0000-0000-000000000000 |

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

The expected result should contain only one with with the maximum value '11111111-0000-0000-0000-000000000000'.

relates to

MDEV-27101 Subquery using the ALL keyword on TIMESTAMP columns produces a wrong result

MDEV-27098 Subquery using the ALL keyword on TIME columns produces a wrong result

MDEV-27099 Subquery using the ALL keyword on INET6 columns produces a wrong result

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