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

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

Alex Peshkov wrote:
> 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) ?
> 
Here is the original demonstration I sent to Interbase.

ftp://64.91.71.43/pub/outbound/bug8257.tar.Z

Ted