Details
-
Type:
Bug
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 10.5, 10.6, 10.7
-
Component/s: Data types, Plugin - INET6, Temporal Types
-
Labels:None
Description
The problem reported in MDEV-27098 for TIME is repeatable with the INET6 data type.
DROP TABLE IF EXISTS t1; |
CREATE TABLE t1 (d INET6); |
INSERT INTO t1 VALUES ('1::0'), ('12::0'); |
SELECT * FROM t1 WHERE d >= ALL (SELECT * FROM t1); |
+------+
|
| d |
|
+------+
|
| 1:: |
|
| 12:: |
|
+------+
|
The expected result should contain only one with with the maximum value '12::'.
Attachments
Issue Links
- relates to
-
MDEV-27100 Subquery using the ALL keyword on UUID columns produces a wrong result
-
- Open
-
-
MDEV-27101 Subquery using the ALL keyword on TIMESTAMP columns produces a wrong result
-
- Open
-
-
MDEV-27098 Subquery using the ALL keyword on TIME columns produces a wrong result
-
- Closed
-