Wrong result from a query with GROUP BY, ORDER BY and LIMIT
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
High
|
Vladislav Vaintroub |
Bug Description
The following sequence of commands gives a wrong result set:
CREATE TABLE t1 (
id BIGINT(20) , member_id_to INT(11) , r_date DATE ,
PRIMARY KEY (id,r_date), KEY r_date_idx (r_date), KEY t1_idx01 (member_id_to)
) ENGINE=InnoDB;
INSERT INTO t1 VALUES
(107924526,
(107924529,
(107924532,
(107924542,
(107924545,
(107924548,
SELECT member_id_to, COUNT(*) FROM t1
WHERE r_date = '2011-06-21' GROUP BY member_id_to ORDER BY 2 LIMIT;
MariaDB [test]> SELECT member_id_to, COUNT(*) FROM t1 WHERE r_date = '2011-06-21' GROUP BY member_id_to ORDER BY 2 LIMIT 1;
+------
| member_id_to | COUNT(*) |
+------
| NULL | 2 |
+------
(see also bug #12713907 reported for mysql-5.1)
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → High |
assignee: | nobody → Vladislav Vaintroub (wlad-montyprogram) |
milestone: | none → 5.2 |
tags: | added: wrong-result |