Subject Re: [IB-Architect] no current row for fetch operation
Author Dmitry Kuzmenko
Hello, Ivan!

Ivan Prenosil wrote:
> > >SELECT T.*, 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 for Windows NT (4.0 SP6a). TCP/IP connection.

Dmitry Kuzmenko, Epsylon Technologies.