[Bug 727091] Re: Select on table with two colums cause empty result.
*** This bug is a duplicate of bug 706988 *** https://bugs.launchpad.net/bugs/706988 ** This bug has been marked a duplicate of bug 706988 Major Bug in MySQL 5.1.49 up to 5.1.52 * You can subscribe to bug 706988 by following this link: https://bugs.launchpad.net/ubuntu/+source/mysql-5.1/+bug/706988/+subscribe -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
Thanks for reporting this bug and any supporting documentation. Since this bug has enough information provided for a developer to begin work, I'm going to mark it as confirmed and let them handle it from here. Thanks for taking the time to make Ubuntu better! -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
Also checked in natty - not impacted by the same issue but this is reflected in the upstream bug report. ** Bug watch added: MySQL Bug System #60231 http://bugs.mysql.com/bug.php?id=60231 ** Also affects: mysql-server via http://bugs.mysql.com/bug.php?id=60231 Importance: Unknown Status: Unknown ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Confirmed => Triaged ** Changed in: mysql-dfsg-5.1 (Ubuntu) Importance: Undecided => Low -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
** Changed in: mysql-dfsg-5.1 (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/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
[Bug 727091] Re: Select on table with two colums cause empty result.
Log of issue from clean, up-to-date maverick install ** Attachment added: "mysql-maverick.txt" https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/727091/+attachment/1898404/+files/mysql-maverick.txt -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
I was able to reproduce on Maverick (mysql-server 5.1.49-1ubuntu8.1) by following the steps in the upstream bug report. -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: Invalid => New -- 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
Re: [Bug 727091] Re: Select on table with two colums cause empty result.
W dniu 03.03.2011 11:23, Clint Byrum pisze: > Marcin, thanks for taking the time to file this bug report and help us > make Ubuntu better. > > Given that you are the only one reporting this issue, I tried to repeat > it using the test case from the mysql bug report. > > I was unable to reproduce it, with MySQL 5.1 5.1.54-1ubuntu4 on natty, > or 5.1.49-1ubuntu8.1 on maverick. > > Marcin, I'm going to close this bug as Invalid. If you have further > details that will help us reproduce the issue or further understand how > your setup differs, feel free to re-open it as Status "New". > > ** Changed in: mysql-dfsg-5.1 (Ubuntu) > Status: New => Invalid > Thank you for response. Could you double check if you recreated all steps. I have checked that on ubuntu 10.10 maverick 32 / 64 bits and debian squeeze 64 bits with mysql 5.1.49 - all systems have same result. In 10.10 maverick desktop edition 32 bit with fresh install of mysql (no config changes) with just one db - 'test'. Debian one have no changes to config too. Important bit is: INSERT INTO `a_b` VALUES (12,4); select * from a_b where a_id = 11 and b_id = 4; Empty set (0.00 sec) and how create index fix it: create unique index index_a_b_on_both_id on a_b (a_id, b_id); select * from a_b where a_id = 11 and b_id = 4; +--+--+ | a_id | b_id | +--+--+ | 11 |4 | +--+--+ Kind Regards Marcin Grzymski -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
Marcin, thanks for taking the time to file this bug report and help us make Ubuntu better. Given that you are the only one reporting this issue, I tried to repeat it using the test case from the mysql bug report. I was unable to reproduce it, with MySQL 5.1 5.1.54-1ubuntu4 on natty, or 5.1.49-1ubuntu8.1 on maverick. Marcin, I'm going to close this bug as Invalid. If you have further details that will help us reproduce the issue or further understand how your setup differs, feel free to re-open it as Status "New". ** Changed in: mysql-dfsg-5.1 (Ubuntu) Status: New => Invalid -- 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
[Bug 727091] Re: Select on table with two colums cause empty result.
-- 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