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

sql: support DECLARE SCROLL and reverse FETCH on cursors #77102

Open
rafiss opened this issue Feb 27, 2022 · 0 comments
Open

sql: support DECLARE SCROLL and reverse FETCH on cursors #77102

rafiss opened this issue Feb 27, 2022 · 0 comments
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
SQL Sessions - Deprecated

Comments

@rafiss
Copy link
Collaborator

rafiss commented Feb 27, 2022 •
edited by cockroach-jira-scripts

Split off from #41412

Scrollable cursor (reverse fetch) support allows advancing through the cursor backwards. We'd have to implement this by savings results into a buffer.

postgres docs on declare.
postgres docs on fetch.

Epic CRDB-11397

Jira issue: CRDB-13413
@rafiss rafiss added C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) A-sql-pgcompat Semantic compatibility with PostgreSQL labels Feb 27, 2022
@rafiss rafiss added this to Triage in SQL Sessions - Deprecated via automation Feb 27, 2022
@blathers-crl blathers-crl bot added the T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) label Feb 27, 2022
@rafiss rafiss mentioned this issue Feb 27, 2022
Closed
@rafiss rafiss changed the title sql: support reverse FETCH on cursors sql: support DECLARE SCROLL and reverse FETCH on cursors Feb 27, 2022
@rafiss rafiss added the X-anchored-telemetry The issue number is anchored by telemetry references. label Feb 27, 2022
@rafiss rafiss moved this from Triage to Longer term backlog in SQL Sessions - Deprecated Mar 1, 2022
@hand-crdb hand-crdb mentioned this issue Nov 15, 2022
Closed
@DrewKimball DrewKimball mentioned this issue Jan 12, 2024
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
A-sql-pgcompat Semantic compatibility with PostgreSQL C-enhancement Solution expected to add code/behavior + preserve backward-compat (pg compat issues are exception) T-sql-foundations SQL Foundations Team (formerly SQL Schema + SQL Sessions) X-anchored-telemetry The issue number is anchored by telemetry references.
Projects
No open projects
SQL Sessions - Deprecated
Longer term backlog
Milestone
No milestone
Development

No branches or pull requests
1 participant
@rafiss