On Tue, 2003-04-29 at 10:38, Chris wrote:
When I use UNION with a SELECT that LEFT JOIN's empty fields, I get
invalid data in the rows of the other SELECT depending on UNION operand
order.
In the case described below, family_fam has no row matching fam_ID=0, so
it should return NULL for the value of all LEFT JOIN'ed fields. This is
desired so that the UNION will work (matching columns for the SELECTs)
but without returning any data in these columns.
Chris,
Could you please send us complete repeatable example which we can test
by "mysql test < example.sql"
We have fixed one JOIN related bug in MySQL 4.0.13 but it would be nice
to make sure this test case is also tested.
It could be it is not a but as well but we need repeatable example in
order to investigate it carefully.
Thank you for cooperation.
3 messages in com.mysql.lists.bugsRe: Possible MySQL 4.0.12 bug regardi...