[Bug 667700] [NEW] Simple MySQL queries return wrong result after update from 5.1.41 (10.04, Lucid Lynx) to 5.1.49 (10.10, Maverick Meerkat)

[Martin Thorsen Ranang]

Public bug reported:

Hi.

I would just like to inform you that I discovered a severe bug in the
MySQL server version 5.1.49, which  is included in Ubuntu 10.10,
Maverick Meerkat.

The severity of the bug should be apparent by studying the attached
file, which only sets up a simple table configuration and performs some
simple queries that work OK against MySQL server 5.1.41, as shipped with
Ubuntu 10.04 Lucid Lynx, but not with versions 5.1.49 (Maverick Meerkat)
and 5.1.51 (latest available source release from MySQL).

I have already filed a bug report at MySQL,
http://bugs.mysql.com/bug.php?id=57795 ,  and they have verified it.  I
do not wish to duplicate the whole bug report here; I only report it
here because the bug is potentially disastrous to systems that rely on
MySQL as a consistent database.

In my MySQL bug report, I also present a possible workaround for Ubuntu
users, based on downgrading to the mysql-server-5.1 packages shipped
with Lucid Lynx.

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: mysql-server-5.1 5.1.49-1ubuntu8
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
Architecture: i386
Date: Thu Oct 28 12:12:39 2010
EcryptfsInUse: Yes
ProcEnviron:
 LANGUAGE=nb:nb_NO
 PATH=(custom, user)
 LANG=nb_NO.utf8
 SHELL=/bin/bash
SourcePackage: mysql-5.1

** Affects: mysql-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386 maverick

-- 
Simple MySQL queries return wrong result after update from 5.1.41 (10.04, Lucid Lynx) to 5.1.49 (10.10, Maverick Meerkat)
https://bugs.launchpad.net/bugs/667700
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-5.1 in ubuntu.