On 2017-01-19 11:35, Adriano dos Santos Fernandes wrote: > On 19/01/2017 08:22, Dimitry Sibiryakov wrote: >> 19.01.2017 11:03, Adriano dos Santos Fernandes wrote: >> >>> c) If for some n, some underlying column of the column referenced by >>> the >>> <column name> CN contained >>> in the n-th ordinal position in <insert column list> is an identity >>> column whose descriptor includes an >>> indication that values are generated by default, then if <override >>> clause> is specified, then <override >>> clause> shall specify OVERRIDING USER VALUE. >>> >>> (Seems our GENERATED BY DEFAULT is compliant) >> We have no <override clause> in insert statement. >> >> > Yes, my point is that this std. clause specifies that with GENERATED BY > DEFAULT, OVERRIDE is not *required*.
Yes, but doing "insert into (generated_by_default_column, some_column) values (null, 'some value')" will assign null to generated_by_default_column, not the identity value. That only happens with "insert into (generated_by_default_column, some_column) values (default, 'some value')" Mark ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
