Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and
privacy statement. We’ll occasionally send you account related emails.
Already on GitHub?
to your account
Submitted by: @pcisar
Is duplicated by CORE6361
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
====== Test Details ======
See also: CORE4344
The text was updated successfully, but these errors were encountered:
assignee: Dmitry Yemanov [ dimitr ]
Sorry, something went wrong.
Version: 2.5 Alpha 1 [ 10224 ]
Fix Version: 3.0.0 [ 10048 ]
Fix Version: 3.0 Alpha 1 [ 10331 ]
Fix Version: 3.0.0 [ 10048 ] =>
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Fixed [ 1 ]
status: Resolved [ 5 ] => Resolved [ 5 ]
QA Status: Done successfully
Test Details: See also: CORE4344
status: Resolved [ 5 ] => Closed [ 6 ]
Link: This issue is duplicated by CORE6361 [ CORE6361 ]
No branches or pull requests