Issue Details (XML | Word | Printable)

Key: CORE-1385
Type: New Feature New Feature
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: lacak
Votes: 10
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Identity columns

Created: 30/Jul/07 05:33 AM   Updated: 28/Sep/15 01:08 PM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 1

Issue Links:
Relate
Replace
 


 Description  « Hide
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"

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Leandro Rezende Coutinho added a comment - 03/Dec/09 06:43 AM
It can looks not important but to make things easy to use can be the diference between the people begin or not to use.

Silas Alves de Oliveira added a comment - 03/Dec/09 12:07 PM
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

Adriano dos Santos Fernandes added a comment - 14/Jan/10 02:49 PM
Documented in doc/sql.extensions/README.identity_columns.txt.

Bert Herngreen added a comment - 15/Jan/10 01:40 PM
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?

Adriano dos Santos Fernandes added a comment - 15/Jan/10 01:45 PM
There is no unsigned type in the SQL standard.