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

missing syntax for autogenerated keys [CORE894] #1291

Closed
firebird-automations opened this issue Aug 10, 2006 · 7 comments
Closed

missing syntax for autogenerated keys [CORE894] #1291

firebird-automations opened this issue Aug 10, 2006 · 7 comments
Labels
affect-version: 2.0 RC3 component: engine priority: minor resolution: wontfix type: improvement

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Manoel (mp)

Is replaced by CORE1385

This syntax should work

create sequence s;

create table t (
i integer default next value for s not null,
constraint pk primary key(i)
);
@firebird-automations
Copy link
Collaborator Author

Commented by: @cincuranet

Why it should work?

Firebird has for "autoinc" fields morepowerful instrument called generators.

@firebird-automations
Copy link
Collaborator Author

Commented by: Manoel (mp)

Not so. autoinc in the docs is a trigger. This is MUCH MORE VERBOSE ... besides 'default' means default so if a value is provided the sequence won't be used. The semantics seems different.

I agree triggers powerful but <literal> in the <create table> syntax chart should be made general. For example: an expression mixing sequences over some conditons.

Perhaps the actual request is substituting <literal> for <expression>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11138 ] => Firebird [ 15289 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is replaced by CORE1385 [ CORE1385 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

The IDENTITY feature has been implemented instead.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Won't Fix [ 2 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
affect-version: 2.0 RC3 component: engine priority: minor resolution: wontfix type: improvement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
1 participant
@firebird-automations