Wrong result from a query with duplicated field in the group list and a limit clause
Bug #1002108 reported by
Igor Babaev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
Medium
|
Timour Katchaounov |
Bug Description
The following test case gives us a wrong result in MariaDB 5.2/5.3/5.5:
CREATE TABLE t1(
col1 int,
UNIQUE INDEX idx (col1)
);
INSERT INTO t1 VALUES (1),(2)
SELECT SQL_BIG_RESULT tbl1.col1 AS field1, tbl2.col1 AS field2
FROM t1 as tbl1, t1 as tbl2
GROUP BY field1, field2
LIMIT 3;
(see also bug #53534 in bugs.mysql.com)
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Medium |
assignee: | nobody → Timour Katchaounov (timour) |
milestone: | none → 5.3 |
To post a comment you must log in.