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

Identity columns [CORE1385] #1803

Closed
firebird-automations opened this issue Jul 30, 2007 · 11 comments
Closed

Identity columns [CORE1385] #1803

firebird-automations opened this issue Jul 30, 2007 · 11 comments
Assignees
@asfernandes
Labels
component: engine fix-version: 3.0 Alpha 1 priority: major type: new feature

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: lacak (lacak)

Relate to CORE1407
Replaces CORE2816
Replaces CORE894
Is related to QA627

Votes: 10

Add support for SQL:2003 Identity columns:

<identity column specification> ::=
GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY
[ ( <common sequence generator options> ) ]

<common sequence generator options> ::= START WITH <sequence generator start value>
| INCREMENT BY <sequence generator increment>
|<sequence generator maxvalue option>
| <sequence generator minvalue option>
| <sequence generator cycle option>

Similar to MSSQL "identity", MySQL "auto_increment" or PostgreSQL "serial"

Commits: 9c1bab1
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue relate to CORE1407 [ CORE1407 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 12710 ] => Firebird [ 15023 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Leandro Rezende Coutinho (leandrolrc)

It can looks not important but to make things easy to use can be the diference between the people begin or not to use.

@firebird-automations
Copy link
Collaborator Author

Commented by: Silas Alves de Oliveira (tristan)

I find it very important to have a field auto-increment, because it helps a lot in the development of the bank and also becomes attractive for people who are beginning a work with the database.
I would also like to congratulate you for your hard work, I'm from Brazil and study at UNIFESO and has been a great help your porjeto.
Thank

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

Documented in doc/sql.extensions/README.identity_columns.txt.

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Bert Herngreen (bertherngreen)

What if there would be an option to use UNSIGNED numbers (0 scale) only for these IDENTITY columns and thus altering the range:
0 to 4294967295 (instead of −2,147,483,648 to +2,147,483,647) for a 32 bits-integer?

@firebird-automations
Copy link
Collaborator Author

Commented by: @asfernandes

There is no unsigned type in the SQL standard.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue replaces CORE2816 [ CORE2816 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue replaces CORE894 [ CORE894 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA627 [ QA627 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@asfernandes asfernandes

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
@asfernandes @firebird-automations