exists with DISTINCT & ORDER BY returns incorrect result
Bug #883976 reported by
Oleksandr "Sanja" Byelkin
This bug affects 1 person
| Affects | Status | Importance | Assigned to | Milestone | |
|---|---|---|---|---|---|
| MariaDB |
Fix Released
|
High
|
Igor Babaev | ||
Bug Description
CREATE TABLE t1(pk INT PRIMARY KEY, a INT, INDEX idx(a));
INSERT INTO t1 VALUES (1, 10), (3, 30), (2, 20);
CREATE TABLE t2(pk INT PRIMARY KEY, a INT, b INT, INDEX idxa(a));
INSERT INTO t2 VALUES (2, 20, 700), (1, 10, 200), (4, 10, 100);
SELECT * FROM t1
WHERE EXISTS (SELECT DISTINCT a FROM t2 WHERE t1.a < t2.a ORDER BY b);
returns 3 rows but should return only one. Without DISTINCT or ORDER BY result is correct.
repeatable in 5.1 (actually incorrect result present in test suite results)
| Changed in maria: | |
| assignee: | nobody → Oleksandr "Sanja" Byelkin (sanja-byelkin) |
| status: | New → Confirmed |
| importance: | Undecided → Medium |
| milestone: | none → 5.2 |
Revision history for this message
| Igor Babaev (igorb-seattle) wrote | #1 |
| Changed in maria: | |
| assignee: | Oleksandr "Sanja" Byelkin (sanja-byelkin) → Igor Babaev (igorb-seattle) |
| importance: | Medium → High |
| status: | Confirmed → Fix Committed |
Revision history for this message
| Elena Stepanova (elenst) wrote | #2 |
| Changed in maria: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
This is a duplicate of the bug #906322.