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 because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1111611 Title: Mysql distinct count returns wrong value in some circumstances To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1111611/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs