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
CURRENT OF support views [CORE1213] #1637
Comments
Commented by: Alexander Tyutik (tut) But cursors works with views in other servers without problems. For example i tried WHERE CURRENT OF with view on MS SQL 2000 and it works. |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovissuetype: New Feature [ 2 ] => Improvement [ 4 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 Beta 1 [ 10141 ] Fix Version: 2.1.0 [ 10041 ] |
Modified by: @pcisarComponent: Engine [ 10000 ] |
Modified by: @pcisarFix Version: 2.1.0 [ 10041 ] => |
Modified by: @pcisarWorkflow: jira [ 11885 ] => Firebird [ 15546 ] |
Modified by: @pmakowskiassignee: Dmitry Yemanov [ dimitr ] => Philippe Makowski [ makowski ] |
Commented by: @pmakowski sorry wrong assign |
Modified by: @pmakowskiassignee: Philippe Makowski [ makowski ] => Dmitry Yemanov [ dimitr ] |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: Alexander Tyutik (tut)
Is related to QA129
I propose to add CURRENT OF support for views in PSQL.
For example:
...
FOR SELECT ... FROM MY_VIEW INTO ... AS CURSOR VIEW_CURSOR DO
BEGIN
...
DELETE FROM MY_VIEW WHERE CURRENT OF VIEW_CURSOR;
...
END
Commits: 4eed778
The text was updated successfully, but these errors were encountered: