Submitted by: pabloj (pabloj)

Duplicates CORE94

Hi, when trying to run a query on the standard employee.fdb:

select
e.emp_no, e.FIRST_NAME, e.LAST_NAME,
p.proj_name
from
employee e, project p left outer join EMPLOYEE_PROJECT ep
on e.EMP_NO = ep.EMP_NO and p.proj_id = ep.PROJ_ID;

I get the following error:

***IBPP::SQLException***
Context:Statement::Fetch
Message: isc_dsql_fetch failed.
SQL Message: -508
The cursor identified in the update or delete statement is not positioned
on a row.

Engine Code: 335544348
Engine Message: no current record for fetch operation

Firebird version is 2.1 beta and Flamerobin 0.8.3.1596 unicode.
This is what comes out from Flamerobin, but it's a Firebird issue, the same happens from the command line client (SQL Message: -508), I can get the explain plan of the query so it should be ok.
Could you please take a look at this?
Regards (and an happy new year ;-))