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

Jump to bottom

Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) [CORE4350] #4672

Closed
firebird-automations opened this issue Feb 22, 2014 · 6 comments
Closed

Support the SQL Standard ALTER SEQUENCE .. RESTART (without WITH clause) [CORE4350] #4672

firebird-automations opened this issue Feb 22, 2014 · 6 comments
Assignees
@dyemanov
Labels
component: engine fix-version: 3.0 Alpha 2 priority: minor qa: done successfully type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Lukas Eder (lukas.eder)

When using the ALTER SEQUENCE .. RESTART statement, I might want to restart the sequence to its original start value, without explictly supplying that. E.g.

ALTER SEQUENCE xxx RESTART;

This is currently not possible:
http://www.firebirdsql.org/refdocs/langrefupd20-alter-seq.html

This is possible in any of these databases...

- DB2
- HSQLDB
- PostgreSQL
- SQL Server

... and in the SQL standard:

<alter sequence generator restart option> ::=
RESTART [ WITH <sequence generator restart value> ]
@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

This is already implemented in v3. I didn't found a ticker for it.

@firebird-automations
Copy link
Collaborator Author

Commented by: Lukas Eder (lukas.eder)

That's great! I couldn't find any issue either, though...

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

It was really done without a ticket entry, my fault.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 2 [ 10560 ]

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

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 2 priority: minor qa: done successfully type: improvement
Projects
None yet
Milestone
No milestone
Development

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