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

[Alex P. <pes...@ya...>]

On Wednesday 11 June 2008 16:47, Ted Miglautsch wrote:
> 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?

There were many bugs fixed in Firebird, can you provide a test case (SQL 
script) ?