Skip to content
New issue

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? Sign in to your account

Views based on procedures can't be created if the proc's output fields participate in an expression [CORE2806] #3194

Closed
firebird-automations opened this issue Jan 14, 2010 · 6 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Claudio Valderrama C. (robocop)

Is related to QA427

While testing my extensions to table rdb$view_relations to close an ambiguity in the definition of views based on procedures, I found this:

F:\fb3dev\fbbuild\firebird30\temp\Win32\Debug\firebird\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database 'procview.fdb';
SQL> set term ^;
SQL> create procedure p returns(rc int) as begin rc = 1; suspend; end^
SQL> create view v2(dosrc) as select rc * 2 from p^
Statement failed, SQLSTATE = HY000
invalid request BLR at offset 3
-context not defined (BLR error)

Commits: b560538 e66a151

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

reporter: Pavel Cisar [ pcisar ] => Claudio Valderrama C. [ robocop ]

security: Managers [ 10013 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5 RC2 [ 10372 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA427 [ QA427 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment