--
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.
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.
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
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
--
** Changed in: mysql-dfsg-5.1 (Ubuntu)
Status: Invalid => New
--
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
