You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query [CORE3210]
#3584
In this query if you uncomment all 3 lines Firebird gives this errror:
"The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation."
But if you comment one or more of the lines - ORDER BY, the most outer coalesce or the first line the query runs without problems.
Under 2.1.3 there is no problem with the query.
SELECT
-- DEPOZIT.NUMBER || ' ' ||
-- COALESCE(
IIF(NAST.BUL_ID IS NOT NULL, COALESCE(http://BULGARIANS.NAME,'') || ' ' || COALESCE(BULGARIANS.FAMILY,''), COALESCE(FOREIGNERS.NAME_CYR,FOREIGNERS.NAME_LAT))
-- ,'')
AS NAME
FROM
DEPOZIT LEFT JOIN NAST ON http://NAST.ID = DEPOZIT.NAST_ID
LEFT JOIN BULGARIANS ON http://BULGARIANS.ID = NAST.BUL_ID
LEFT JOIN FOREIGNERS ON http://FOREIGNERS.ID = NAST.FOR_ID
--ORDER BY 1
This is what I've did:
I've downloaded the archive with Firebird-2.5.0.26108 build. I've replaced the files from the original installation with these from the archive. Also I've replaced the fbclient.dll in Windows\system32. But the gds32.dll is the old one from 26074 build. After that I've tried the query but it doesn't work - the error still exists.
Submitted by: Miroslav Djorov (miro)
Attachments:
db.fbk
In this query if you uncomment all 3 lines Firebird gives this errror:
"The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation."
But if you comment one or more of the lines - ORDER BY, the most outer coalesce or the first line the query runs without problems.
Under 2.1.3 there is no problem with the query.
SELECT
-- DEPOZIT.NUMBER || ' ' ||
-- COALESCE(
IIF(NAST.BUL_ID IS NOT NULL, COALESCE(http://BULGARIANS.NAME,'') || ' ' || COALESCE(BULGARIANS.FAMILY,''), COALESCE(FOREIGNERS.NAME_CYR,FOREIGNERS.NAME_LAT))
-- ,'')
AS NAME
FROM
DEPOZIT LEFT JOIN NAST ON http://NAST.ID = DEPOZIT.NAST_ID
LEFT JOIN BULGARIANS ON http://BULGARIANS.ID = NAST.BUL_ID
LEFT JOIN FOREIGNERS ON http://FOREIGNERS.ID = NAST.FOR_ID
--ORDER BY 1
Commits: 85ba1c7
The text was updated successfully, but these errors were encountered: