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

SPs in views [CORE886] #1279

Closed
firebird-issue-importer opened this issue Aug 3, 2006 · 12 comments
Closed

SPs in views [CORE886] #1279

firebird-issue-importer opened this issue Aug 3, 2006 · 12 comments

Comments

@firebird-issue-importer
Copy link

@firebird-issue-importer firebird-issue-importer commented Aug 3, 2006

Submitted by: Michael Trowe (bubble76)

Is related to QA297

Votes: 4

If I want to run a query from a SP with limiting the result-set or with joining other tables, I have to run the query by client or in another SP. But I can' create a view using the SP:

Like:

create view MY_VIEW ( "FIELD_1" )
as
select MY_PROCEDURE."FIELD_1"
from MY_PROCEDURE('...')

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 8, 2006

Commented by: Valdir Stiebe Junior (ogecrom)

Yes! Enabling us to create a "stored procedure based editable view" will be nice for reducing the ammount of code in client application.
I will use it for translating updates in deletes or inserts in some cases.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 13, 2007

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 16, 2007

Modified by: @dyemanov

Target: 2.5.0 [ 10221 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 28, 2007

Modified by: @asfernandes

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 28, 2007

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

Workflow: jira [ 11122 ] => Firebird [ 14676 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 19, 2008

Commented by: Philip Williams (unordained)

This issue's (886) priority may be "minor" ... but to me the potential coolness factor is "major". Thanks!

Does the existing patch for 2.5 include the ability to do:

SELECT ... FROM a ... join ... EXECUTE BLOCK RETURNS (x ..., y ...) AS BEGIN ... END z ON ...

and create a VIEW from it? Seems like if we can create a view based on a stored procedure that returns rows, basing a view on an anonymous block that does the same would be logically (if not physically, I'm not saying it'd be easy!) similar ... just curious.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 19, 2008

Commented by: @dyemanov

No, there are no plans to support EXECUTE BLOCK inside select expressions.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 23, 2011

Modified by: @pcisar

Link: This issue is related to QA297 [ QA297 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 22, 2011

Modified by: @pmakowski

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

Modified by: @pavel-zotov

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants