description: SFID: 1153278#⁠
Submitted By: pierrey

I would like to know I you can consider adding
a "DEFAULT" keyword to force the engine to set the
default value for a field if this field is present in a query
(insert or update) but user don't want to give it a value :

CREATE TABLE MY_TABLE (
TABLE_KEY INTEGER NOT NULL,
TABLE_VALUE INTEGER NOT NULL DEFAULT 0,
CONSTRAINT MY_TABLE_PK PRIMARY KEY
(TABLE_KEY));

INSERT INTO MY_TABLE (TABLE_KEY,
TABLE_VALUE) VALUES
(GEN_ID(MY_GEN_KEY), DEFAULT);

or

UPDATE MY_TABLE SET
TABLE_VALUE=DEFAULT
WHERE TABLE_KEY=:THE_ID;

Vlad Horsun also said this keyword is in SQL 2002 :

"We talk about INSERT\UPDATE syntax with explicit
defaults.

This is feauture F221 according SQL 2002 (which i has)

SQL 2002 say:

6.5 <contextually typed value specification>

Function
Specify a value whose data type is to be inferred from
its context.

Format
<contextually typed value specification> ::= <implicitly
typed value specification>
| <default specification>
...
<default specification> ::=
DEFAULT

Both INSERT and UPDATE can specify <contextually
typed value specification>"

=>

SFID: 1153278#⁠
Submitted By: pierrey

I would like to know I you can consider adding
a "DEFAULT" keyword to force the engine to set the
default value for a field if this field is present in a query
(insert or update) but user don't want to give it a value :

CREATE TABLE MY_TABLE (
TABLE_KEY INTEGER NOT NULL,
TABLE_VALUE INTEGER NOT NULL DEFAULT 0,
CONSTRAINT MY_TABLE_PK PRIMARY KEY
(TABLE_KEY));

INSERT INTO MY_TABLE (TABLE_KEY,
TABLE_VALUE) VALUES
(GEN_ID(MY_GEN_KEY), DEFAULT);

or

UPDATE MY_TABLE SET
TABLE_VALUE=DEFAULT
WHERE TABLE_KEY=:THE_ID;

Vlad Horsun also said this keyword is in SQL 2002 :

"We talk about INSERT\UPDATE syntax with explicit
defaults.

This is feauture F221 according SQL 2002 (which i has)

SQL 2002 say:

6.5 <contextually typed value specification>

Function
Specify a value whose data type is to be inferred from
its context.

Format
<contextually typed value specification> ::= <implicitly
typed value specification>
| <default specification>
...
<default specification> ::=
DEFAULT

Both INSERT and UPDATE can specify <contextually
typed value specification>"

priority: Major [ 3 ] => Minor [ 4 ]

Fix Version: 3.0 [ 10048 ]

SF_ID: 1153278 =>

Workflow: jira [ 10689 ] => Firebird [ 15071 ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Fix Version: 3.0.0 [ 10048 ] =>

Fix Version: 3.0 Beta 1 [ 10332 ]

Fix Version: 3.0 Alpha 1 [ 10331 ] =>

Fix Version: 3.0 Beta 1 [ 10332 ] =>

Link: This issue duplicates CORE5449 [ CORE5449 ]