Hello,

I have situation:

select
...
from
table1
left join table2 on
table1.field1 = table2.field1
join table3 on
table2.field2 = table3.field1

This query never ends on tables with 80000 records (if I change last
join to left join query executes in 10s)
Even if I terminate my application server still utilises 100% cpu
endlesly. Only way is to restart firebird. I use FBSS1.5.3 WinXP. I
wrote simplified example of my query if there is possibilitie that
this can be bug of FB I can write all query.