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.

In such a case, always supply the execution plan and if you are using
some kind of Fetch All or not.


Just a wild guess, but what happens if you are trying this:


select
...
from
table3 t3 join table2 t2 on (t3.field1 = t2.field2)
right join table1 t1 on (t2.field1 = t1.field1)


--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com