Incorrect LEFT JOIN result using table and derived constant subquery [CORE3090] #3469
Submitted by: Smirnoff Serg (wildsery)
recreate table test_err (id int);
Result must be
But, result is
However, the second LEFT JOIN works fine
============ ============ ============
The text was updated successfully, but these errors were encountered:
Commented by: Thomas Beckmann (thbeckmann)
This might be due to the same reason:
returns 'well' - which is fine with me.
returns nothing - which I am pretty sure, is a bug...