| Bug #117811 | Incorrect query results for BLOB type | ||
|---|---|---|---|
| Submitted: | 27 Mar 15:19 | Modified: | 28 Mar 4:34 |
| Reporter: | John Jove | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Optimizer | Severity: | S1 (Critical) |
| Version: | 8.4.4, 8.0.41, 9.2.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[28 Mar 4:34]
MySQL Verification Team
Hello John, Thank you for the report and test case. Verified as described. regards, Umesh
[3 Apr 14:22]
huahua xu
The collation between `Item_func_between` operator and B-tree index is inconsistent, what caused the phantom.
Description: I run the following statements, in which an incorrect result is returned. How to repeat: 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}