Issue Details (XML | Word | Printable)

Key: CORE-3210
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Miroslav Djorov
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

The cursor identified in the UPDATE or DELETE statement is not positioned on a row. no current record for fetch operation in SELECT query

Created: 02/Nov/10 09:17 AM   Updated: 04/Feb/11 01:14 PM
Component/s: Engine
Affects Version/s: 2.5.0
Fix Version/s: 2.5.1

Time Tracking:
Not Specified

File Attachments: 1. File db.fbk (315 kB)

Environment: Windows XP SP3 2GB RAM CPU: AMD Athlon 64X2 4000+

Planning Status: Unspecified


 Description  « Hide
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(BULGARIANS.NAME,'') || ' ' || COALESCE(BULGARIANS.FAMILY,''), COALESCE(FOREIGNERS.NAME_CYR,FOREIGNERS.NAME_LAT))
-- ,'')
     AS NAME
FROM
    DEPOZIT LEFT JOIN NAST ON NAST.ID = DEPOZIT.NAST_ID
    LEFT JOIN BULGARIANS ON BULGARIANS.ID = NAST.BUL_ID
    LEFT JOIN FOREIGNERS ON FOREIGNERS.ID = NAST.FOR_ID
--ORDER BY 1

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Miroslav Djorov added a comment - 02/Nov/10 09:18 AM
This is a test database for the query.

Dmitry Yemanov added a comment - 02/Nov/10 09:40 AM
Please try with the latest snapshot build.

Miroslav Djorov added a comment - 02/Nov/10 10:40 AM
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.

Dmitry Yemanov added a comment - 02/Nov/10 11:20 AM
The fix will be available in the next snapshot build.