Query with GROUP BY returns an extra row
Bug #1001092 reported by
Igor Babaev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Confirmed
|
Medium
|
Oleksandr "Sanja" Byelkin |
Bug Description
The following test case produces a wrong result in MariaDB 5.2:
CREATE TABLE t1 (vc varchar(1), INDEX vc_idx (vc)) ;
INSERT INTO t1 VALUES (NULL), ('o'), (NULL), ('p'), ('c');
FLUSH TABLE t1;
SELECT vc FROM t1 GROUP BY vc;
MariaDB [test]> SELECT vc FROM t1 GROUP BY vc;
+------+
| vc |
+------+
| NULL |
| NULL |
| c |
| o |
| p |
+------+
5 rows in set (0.01 sec)
(See also bug #12837714 in mysql-trunk)
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → High |
assignee: | nobody → Oleksandr "Sanja" Byelkin (sanja-byelkin) |
milestone: | none → 5.2 |
To post a comment you must log in.
It is not repeatable on 5.3