>>>>> "SB(" == Satheesh Bandaram (JIRA) <[email protected]> writes:
SB(> It is desirable to have IDENTITY_VAL_LOCAL() function return last
recently user specified value for BY DEFAULT identity columns.
SB(>
--------------------------------------------------------------------------------------------------------------------------------
SB(> Key: DERBY-353
SB(> URL: http://issues.apache.org/jira/browse/DERBY-353
SB(> Project: Derby
SB(> Type: Bug
SB(> Components: SQL
SB(> Versions: 10.1.0.0
SB(> Environment: Generic
SB(> Reporter: Satheesh Bandaram
SB(> Derby was recently enhanced to support BY DEFAULT identity
SB(> column. While the behavior of this feature is not documented
SB(> yet, I think, it is desirable for IDENTITY_VAL_LOCAL()
SB(> function, that is used to retrieve last single statement
SB(> insert value for identity column, to return user specified
SB(> value for the default column.
SB(> For GENERATED ALWAYS identity columns, this issue doesn't
SB(> apply, since users can't provide a value. But for GENERATED
SB(> BY DEFAULT identity columns, users can optionally specify a
SB(> value. IDENTITY_VAL_LOCAL() function should return this
SB(> value. Derby currently doesn't support this behavior.
To me your description, especially the title, is not quite clear. I
assume you mean that IDENTITY_VAL_LOCAL() should return the value for
the last insert statement, regardless of whether it was user-specified
or a default value. However, the title may be interpreted as that you
think it should return the last user-specified value even if the last
insert statement used a default value.
--
�ystein
