Details
-
Bug
-
Status: In Progress (View Workflow)
-
Critical
-
Resolution: Unresolved
-
11.8.1, 10.5, 10.6, 10.11, 11.4
Description
I run the following statements, in which the query returns an incorrect result.
CREATE TABLE t1 (c1 TINYBLOB, UNIQUE (c1(2))); |
INSERT INTO t1 (c1) VALUES (1); |
SELECT c1 FROM t1 WHERE 'a' BETWEEN 0 AND (c1); -- actual: {}, expected: {1} |
I got the following query plan.
mysql> EXPLAIN SELECT c1 FROM t1 WHERE 'a' BETWEEN 0 AND (c1);
|
+------+-------------+-------+-------+---------------+------+---------+------+------+-------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+-------+---------------+------+---------+------+------+-------------+
|
| 1 | SIMPLE | t1 | range | c1 | c1 | 5 | NULL | 1 | Using where |
|
+------+-------------+-------+-------+---------------+------+---------+------+------+-------------+
|
Attachments
Issue Links
- relates to
-
-
- In Review
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.6 [ 24028 ] | |
| Affects Version/s | 10.11 [ 27614 ] | |
| Affects Version/s | 11.4 [ 29301 ] |
| Link | This issue relates to MDEV-36211 [ MDEV-36211 ] |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Fix Version/s | 11.8 [ 29921 ] |
| Assignee | Sergei Petrunia [ psergey ] |
| Labels | wrong_result |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Assignee | Sergei Petrunia [ psergey ] | Dave Gosselin [ JIRAUSER52216 ] |
| Status | Confirmed [ 10101 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Labels | wrong_result | upstream wrong_result |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Summary | Incorrect query result | Incorrect result for BETWEEN on over unique blob prefix |
| Assignee | Dave Gosselin [ JIRAUSER52216 ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Alexander Barkov [ bar ] | Dave Gosselin [ JIRAUSER52216 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Summary | Incorrect result for BETWEEN on over unique blob prefix | Incorrect result for BETWEEN over unique blob prefix |