db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <qoz...@sbcglobal.net>
Subject Re: DERBY-318(Re: DERBY-308 just be done and .... (Re: [jira] Updated: (DERBY-308) Modify dblook to support "GENERATED BY DEFAULT AS IDENTITY"))
Date Wed, 01 Jun 2005 16:04:00 GMT
TomohitoNakayama wrote:

> I concluded as next.
> Thinking "GENERATED BY DEFAULT AS IDENTITY" is a kind of default,
> returning not null value for that column does not cause problem.
> On the contrast , returning null value for column of "GENERATED BY 
> may cause some inconsistency, because the column is a column with 
> special default value.

Well, a GENERATED ALWAYS AS IDENTITY column is also "a column with special 
default value", and yet Derby currently returns null for the default of that 
kind of column.  So to make GENERATED BY DEFAULT columns match this behavior (by 
returning null) is, I think, the most consistent thing.

On the other hand, I agree that a non-null string such as "GENERATED_BY_DEFAULT" 
has its benefits, as well.  Since no one else has commented one way or the 
other, and since I think we should get this issue resolved sooner rather than 
later, I think you can go ahead and do things the way you think is best.

So please feel free to make the change as you prefer, and to post the patch to 
the list so we can proceed.


View raw message