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

Syntax for Manage Nullability in Domains and Columns is wrong [DOC120] #126

Closed
firebird-automations opened this issue Mar 2, 2016 · 2 comments

Comments

@firebird-automations
Copy link

Submitted by: Mark Junker (fubar-coder)

The documentation of Firebird 3.0.0 rc1 (zip archive) says that the nullability of a column is changed with the following instruction:

ALTER TABLE <table name> ALTER <field name> [NOT] NULL

The correct instruction would be:

ALTER TABLE <table name> ALTER <field name> { SET | DROP } NOT NULL

I guess that the syntax for domains is wrong too and therefore should be

ALTER DOMAIN <domain name> { SET | DROP } NOT NULL

@firebird-automations
Copy link
Author

Modified by: Mark Junker (fubar-coder)

description: The documentation says that the nullability of a column is changed with the following instruction:

ALTER TABLE <table name> ALTER <field name> [NOT] NULL

The correct instruction would be:

ALTER TABLE <table name> ALTER <field name> { SET | DROP } NOT NULL

I guess that the syntax for domains is wrong too and therefore should be

ALTER DOMAIN <domain name> { SET | DROP } NOT NULL

=>

The documentation of Firebird 3.0.0 rc1 (zip archive) says that the nullability of a column is changed with the following instruction:

ALTER TABLE <table name> ALTER <field name> [NOT] NULL

The correct instruction would be:

ALTER TABLE <table name> ALTER <field name> { SET | DROP } NOT NULL

I guess that the syntax for domains is wrong too and therefore should be

ALTER DOMAIN <domain name> { SET | DROP } NOT NULL

@mrotteveel
Copy link
Member

Was already fixed

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

3 participants