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

Identity columns [CORE1385] #1803

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

Identity columns [CORE1385] #1803

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Aug 7, 2007

Modified by: @dyemanov

Link: This issue relate to CORE1407 [ CORE1407 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 3, 2009

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 3, 2009

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 14, 2010

Commented by: @asfernandes

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 14, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 15, 2010

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 15, 2010

Commented by: @asfernandes

There is no unsigned type in the SQL standard.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2010

Modified by: @dyemanov

Link: This issue replaces CORE2816 [ CORE2816 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 14, 2011

Modified by: @dyemanov

Link: This issue replaces CORE894 [ CORE894 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Sep 28, 2015

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
Projects
None yet
Development

No branches or pull requests

2 participants