[Bug 727091] [NEW] Select on table with two colums cause empty result.

[Marcin Grzymski]

Public bug reported:

Binary package hint: mysql-server-5.1

Table with two integer columns and separate indexes on each column can cause problems
during select with conditions on both columns.
Selecting with condition on one column works ok but multiple columns in same time
generate empty result.

Creating index on two columns fixes results from select.
Version 5.0 works fine in that case.

Looks like bug has been fixed in 5.1.54  + .
http://bugs.mysql.com/bug.php?id=60231

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: mysql-server-5.1 5.1.49-1ubuntu8.1
ProcVersionSignature: Ubuntu 2.6.35-25.44-generic 2.6.35.10
Uname: Linux 2.6.35-25-generic x86_64
NonfreeKernelModules: nvidia
Architecture: amd64
Date: Tue Mar  1 10:42:40 2011
ProcEnviron:
 PATH=(custom, user)
 LANG=en_GB.utf8
 SHELL=/bin/bash
SourcePackage: mysql-5.1

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


** Tags: amd64 apport-bug maverick

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.
https://bugs.launchpad.net/bugs/727091

Title:
  Select on table with two colums cause empty result.