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

Marcin Grzymski 727091 at bugs.launchpad.net
Thu Mar 3 14:09:46 UTC 2011


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
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.



More information about the Ubuntu-server-bugs mailing list