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 [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
