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 Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/727091 Title: Select on table with two colums cause empty result. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs