db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Oystein.Grov...@Sun.COM (Øystein Grøvlen)
Subject Re: [jira] Created: (DERBY-353) It is desirable to have IDENTITY_VAL_LOCAL() function return last recently user specified value for BY DEFAULT identity columns.
Date Wed, 15 Jun 2005 09:36:29 GMT
>>>>> "SB(" == Satheesh Bandaram (JIRA) <derby-dev@db.apache.org> 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


Mime
View raw message