[#CORE-4199] Add optional START WITH clause to identity columns

Firebird Core

Created: 30/Aug/13 03:43 PM Updated: 29/May/15 03:15 PM

Component/s:

Engine

Affects Version/s:

None

Fix Version/s:

3.0 Alpha 2

QA Status:

Done successfully

Description

« Hide

Syntax: GENERATED BY DEFAULT AS IDENTITY [ (START WITH <value>) ]

All

Comments

Change History

Subversion Commits

Sort Order:

Field	Original Value	New Value
Issue Type	Bug [ 1 ]	Improvement [ 4 ]

Status	Open [ 1 ]	Resolved [ 5 ]
Assignee		Adriano dos Santos Fernandes [ asfernandes ]
Fix Version/s		3.0 Alpha 2 [ 10560 ]
Resolution		Fixed [ 1 ]

[ Permalink | « Hide ]

Robert added a comment - 16/Sep/13 07:06 AM

Will the default value of start-with-value 0 or 1?

[ Permalink | « Hide ]

It will "starts with" 0, meaning the first (next) value will be one.

Pavel Zotov made changes - 29/May/15 03:15 PM

Status	Resolved [ 5 ]	Resolved [ 5 ]
QA Status		Done successfully