Subject RE: [firebird-support] "connection lost" problem
Author Thomas Steinmaurer
> if I try to execute the folowing query I receive "Connection lost"
> exception:
> select 1 from Table1
> where
> exists (select field1 from View1
> where <some conditions>
> )
> View1 is a view. If I exchange it with a table in the query
> everything works fine.
> I'm using Firebird 1.0.2

If the view uses one or more UNIONs, then this is a known
bug in Firebird 1.0.x and has been fixed in FB 1.5.

Best Regards,
Thomas Steinmaurer

Logging/Auditing Suite for InterBase and Firebird
Logging/Auditing Suite for Advantage Database Server