** Tags added: needs-upstream-sync
** Changed in: mysql-5.5 (Ubuntu)
Status: Confirmed = Triaged
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/611
Title:
Mysql distinct count returns
I can confirm that this bug is fixed by upstream in 5.5.36 (latest). I
believe it might be http://bugs.mysql.com/bug.php?id=68749
Here's the results of the testcase showing expected output:
morgo@Rbook:~/sandboxes/msb_5_5_36$ ./use ~/Desktop/testdump6.sql.txt
count(distinct(testtab.foo))
111
I can confirm that this bug is fixed by upstream in 5.5.36 (latest). I
believe it might be http://bugs.mysql.com/bug.php?id=68749
Here's the results of the testcase showing expected output:
morgo@Rbook:~/sandboxes/msb_5_5_36$ ./use ~/Desktop/testdump6.sql.txt
count(distinct(testtab.foo))
111
Status changed to 'Confirmed' because the bug affects multiple users.
** Changed in: mysql-5.5 (Ubuntu)
Status: New = Confirmed
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/611
Title:
I can confirm this bug occurs for me in 12.04 with the following mysql
version:
mysql Ver 14.14 Distrib 5.5.29, for debian-linux-gnu (x86_64) using
readline 6.2
I did a bit of Googling and found this bug, which might be related:
http://bugs.mysql.com/bug.php?id=65053
The final comment
I see the same behaviour on mysql 5.5.28 on Cygwin. So the issue is not
Ubuntu-specific. The comparison therefore is between Mysql5.1 and
Mysql5.5. 5.1 was available in the 12.04 repository as a non-default
install, but it has subsequently been removed.
--
You received this bug notification
Thank you for taking the time to report this bug and helping to make
Ubuntu better.
I've confirmed that I can reproduce this in Precise, Quantal and Raring.
It certainly looks wrong to me. But with it being MySQL I'm half
expecting someone to tell me that this is expected behaviour for some