Wrong result from a query with duplicated field in the group list and a limit clause

[Igor Babaev]

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),(3),(4),(5),(6),(7),(8),(9),(10);

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)