Comment 3 for bug 951937

Sergey Petrunia (sergefp) wrote :

the wrong result is caused by the following:

this part of WHERE condition:

 "(`j2`.`t1a`.`b` >= `j2`.`t1a`.`a`)"

is attached to table v (i.e. <derived3>), and it evaluates to FALSE. This is wrong because the dataset has t1.a=t1.b for all rows.