[MDEV-280] fix LP bug#1001092 Query with GROUP BY returns an extra row Created: 2012-05-18  Updated: 2012-10-14  Resolved: 2012-10-14

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.2.12
Fix Version/s: None

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


 Description   

https://bugs.launchpad.net/maria/+bug/1001092

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

It is not repeatable on 5.3.

Comment by Oleksandr Byelkin [ 2012-10-14 ]

In 5.3 it was fixed by adding this to Cached_item_field::cmp :

/*
If value is not null and value changed (from null to not null or
becasue of value change), then copy the new value to buffer.
*/
if (! null_value && (tmp || (tmp= (field->cmp(buff) != 0))))
field->get_image(buff,length,field->charset());

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