Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.8.1, 10.5(EOL), 10.6, 10.11, 11.4, 11.8
-
None
Description
I run the following statements, in which an incorrect result is returned.
CREATE TABLE t1 (c1 BLOB, UNIQUE (c1(4))); |
INSERT INTO t1 (c1) VALUES (9); |
INSERT INTO t1 (c1) VALUES (110); |
SELECT ca4 AS ca1 |
FROM (SELECT c1 as ca4 FROM t1) AS ta1 |
INNER JOIN (SELECT c1 AS ca7 FROM t1) AS ta2 ON (ca4 BETWEEN 1 AND ca7); -- actual: {9, 110}, expected: {9, 9, 110} |