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
Comments
Modified by: @pcisarWorkflow: jira [ 12710 ] => Firebird [ 15023 ] |
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. |
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. |
Commented by: @asfernandes Documented in doc/sql.extensions/README.identity_columns.txt. |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] |
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: |
Commented by: @asfernandes There is no unsigned type in the SQL standard. |
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
The text was updated successfully, but these errors were encountered: