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.

Sign up for GitHub

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

Jump to bottom

Server Bi-directional cursors [CORE803] #1189

Closed
firebird-automations opened this issue Sep 17, 2003 · 11 comments
Closed

Server Bi-directional cursors [CORE803] #1189

firebird-automations opened this issue Sep 17, 2003 · 11 comments
Assignees
@dyemanov
Labels
component: engine fix-version: 3.0 Alpha 1 priority: major type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pcisar

Votes: 8

SFID: 807918#⁠
Submitted By: pcisar

Enable Bi-directional cursors for server processing
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10827 ] => Firebird [ 15259 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: BGoebel (a2b2)

...to be more precise this feature is listed under

F431 Read-only scrollable cursors - -
F431-01 FETCH with explicit NEXT - -
F431-02 FETCH FIRST - -
F431-03 FETCH LAST - -
F431-04 FETCH PRIOR - -
F431-05 FETCH ABSOLUTE - -
F431-06 FETCH RELATIVE - -

It's an basic SQL 92 feature: DECLARE <cursorname> SCROLL CURSOR FOR <cursor specification>
I'm quite sure i could collect some money for a donation from our managers if this could be realized.
Even a FETCH ABSOLUTE with the lowest cursor stabilitiy would be fine.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Alpha 1 [ 10331 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Scrollability for PSQL cursors will be available in v3.0 Alpha 1 with the aforementioned syntax. Scrollability at the DSQL/API level (for regular SELECTs) will be introduced in the new OO API interfaces, but the underlying implementation will be done for Beta.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Beta 1 [ 10332 ]

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 Beta 2 [ 10586 ]

Fix Version: 3.0 Beta 1 [ 10332 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0 RC 1 [ 10584 ]

Fix Version: 3.0 Beta 2 [ 10586 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0.0 [ 10048 ]

Fix Version: 3.0 RC 1 [ 10584 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: In Progress [ 3 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0 RC2 [ 10048 ] =>

@dyemanov dyemanov mentioned this issue Nov 25, 2021
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dyemanov dyemanov

Labels
component: engine fix-version: 3.0 Alpha 1 priority: major type: new feature
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dyemanov @firebird-automations