Issue Details (XML | Word | Printable)

Key: CORE-4634
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: advpos
Votes: 0
Watchers: 3
Operations

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

Regression: ORDER BY via an index + WHERE clause: error "no current record for fetch operation"

Created: 08/Dec/14 03:15 AM   Updated: 23/Sep/15 11:31 AM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2, 3.0 Beta 1
Fix Version/s: 3.0 Beta 2

Environment: windows 7 32

QA Status: Done successfully
Test Details:
Confirmed for WI-T3.0.0.31374 Firebird 3.0 Beta 1:
Statement failed, SQLSTATE = 22000
no current record for fetch operation


 Description  « Hide
This is a example database "EMPLOYEE" for the query


SELECT * FROM SALES WHERE
 ( ORDER_STATUS LIKE '1%' or ORDER_STATUS LIKE '%1%')

  ORDER BY ORDER_STATUS

and gives this error

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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.