Issue Details (XML | Word | Printable)

Key: CORE-2155
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Cisar
Votes: 3
Watchers: 2

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

Join of SP with view or table may fail with 'No current record for fetch operation'

Created: 28/Oct/08 09:42 AM   Updated: 28/Sep/15 12:52 PM
Component/s: Engine
Affects Version/s: 1.0.3, 1.5.5, 2.0.4, 2.5 Alpha 1, 2.1.1
Fix Version/s: 3.0 Alpha 1

QA Status: Done successfully
Test Details: See also: CORE-4344

 Description  « Hide
The optimizer always (if possible) tries to start a join order with a procedure. If SP depends on some other streams via input parameters, this error happens.

The workaround is trivial, force the join order via a left join. For example:

select * from A_VIEW A left join A_SP(A.VAL1, A.VAL2) on 1=1

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