[Firebird-devel] [FB-Tracker] Created: (CORE-2155) Join of SP with view or table may fail with 'No current record for fetch operation'

[Pavel C. (JIRA) <tr...@fi...>]

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

                 Key: CORE-2155
                 URL: http://tracker.firebirdsql.org/browse/CORE-2155
             Project: Firebird Core
          Issue Type: Bug
          Components: Engine
    Affects Versions: 2.1.1, 2.0.4, 1.5.5, 1.0.3
            Reporter: Pavel Cisar


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


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira