[Firebird-devel] Was the left join error ever fixed in FireBird?

[Ted M. <th...@mi...>]

Many years ago Interbase added LEFT JOINS capability to queries. 
However, I quickly found there was a problem. With a normal join and no 
indexes Interbase would quickly create sort files of both tables and 
return the resulting answer. However, with the LEFT JOINS Interbase 
would quickly create sort files of both tables but then it ignored them 
and went sequentially through one table and repeatedly reading the 
entire other table looking for matches.

A few years ago I mentioned this problem on this forum and some people 
looked at the code to discover the programing to do the matching of the 
two sort files for a LEFT JOIN was never written. So all it could do was 
do a sequential scan.

This bug has finally been fixed in Interbase after almost 10 years. I am 
wondering if anybody fixed it in FireBird?

Ted