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-automations opened this issue Aug 3, 2006 · 12 comments
Closed

SPs in views [CORE886] #1279

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

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Target: 2.5.0 [ 10221 ]

Fix Version: 2.5 Alpha 1 [ 10224 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Commented by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA297 [ QA297 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

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
Development

No branches or pull requests

2 participants