Subject Re: "connection lost" problem
Author christodi
--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:
> > 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.
>

Yes the view contains unions. I'll switch to 1.5.
Thanks for the info.

Christo