CURRENT OF support views [CORE1213]

[firebird-issue-importer]

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

[firebird-issue-importer]

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.

[firebird-issue-importer]

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

[firebird-issue-importer]

Modified by: @dyemanov

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

[firebird-issue-importer]

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 Beta 1 [ 10141 ]

Fix Version: 2.1.0 [ 10041 ]

[firebird-issue-importer]

Modified by: @pcisar

Component: Engine [ 10000 ]

[firebird-issue-importer]

Modified by: @pcisar

Fix Version: 2.1.0 [ 10041 ] =>

[firebird-issue-importer]

Modified by: @pcisar

Link: This issue is related to QA129 [ QA129 ]

[firebird-issue-importer]

Modified by: @pcisar

Workflow: jira [ 11885 ] => Firebird [ 15546 ]

[firebird-issue-importer]

Modified by: @pmakowski

assignee: Dmitry Yemanov [ dimitr ] => Philippe Makowski [ makowski ]

[firebird-issue-importer]

Commented by: @pmakowski

sorry wrong assign

[firebird-issue-importer]

Modified by: @pmakowski

assignee: Philippe Makowski [ makowski ] => Dmitry Yemanov [ dimitr ]

[firebird-issue-importer]

Modified by: @pmakowski

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

[firebird-issue-importer]

Modified by: @pavel-zotov

QA Status: No test

[firebird-issue-importer]

Modified by: @pavel-zotov

QA Status: No test => Done successfully