Hello, Ivan!

Ivan Prenosil wrote:

>
> > >SELECT T.*, SP.*
> > >FROM TABLE T, PROC(T.ID) SP

> > Interesting problem. Does the error occur before the
> > first row is returned?
>
> Prepare - o.k.
> Open - o.k.
> First fetch - booom.
>
> (but it perhaps depends on PLAN, so I would expect this error
> to occur during Open in some cases)

I've tested in IB_WISQL - only prepared this query without execution.
This query does not return query plan!

And there is no query plan when I add where clause and query does not
return "no current row" error.

Seems that optimizer is VERY confused :-)

p.s. IB 6.0.0.627 for Windows NT (4.0 SP6a). TCP/IP connection.

--
Dmitry Kuzmenko, Epsylon Technologies.