[MDEV-663] LP:1001092 - Query with GROUP BY returns an extra row Created: 2012-05-18  Updated: 2013-02-25  Resolved: 2013-02-25

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.30, 5.2.15, 5.3.13

Type: Bug Priority: Minor
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Won't Fix Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1001092.xml    

 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)

 Comments   
Comment by Oleksandr Byelkin [ 2012-05-18 ]

Re: Query with GROUP BY returns an extra row
It is not repeatable on 5.3

Comment by Rasmus Johansson (Inactive) [ 2012-05-18 ]

Launchpad bug id: 1001092

Comment by Oleksandr Byelkin [ 2013-02-25 ]

The bug is not repetable in 5.3, 5.5, 10.0

Comment by Oleksandr Byelkin [ 2013-02-25 ]

We can't repeat the bug any more

Generated at Thu Feb 08 06:30:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.