Details
Description
A query using the = SOME (or = ANY) operator produces an incorrect result when the subquery's column is an integer type (e.g., INT, BIGINT, or DECIMAL) with a UNIQUE index and is compared against a literal.
drop TABLE IF EXISTS t6; |
CREATE TABLE t6 (c2 int); |
INSERT t6 () VALUES (1.009); |
SELECT (0.9 = SOME (SELECT t6.c2 FROM t6))FROM t6; |
-- 0
|
drop TABLE IF EXISTS t6; |
CREATE TABLE t6 (c2 int UNIQUE); |
INSERT t6 () VALUES (1.009); |
SELECT (0.9 = SOME (SELECT t6.c2 FROM t6))FROM t6; |
-- 1 |
Attachments
Issue Links
- relates to
-
MDEV-38200 Incorrect Result for IN Subquery on indexed CHAR Column
-
- Confirmed
-