Re: [Firebird-devel] Adding NOT NULL fields with DEFAULT

[Adriano d. S. F. <adr...@gm...>]

Claudio Valderrama C. wrote:
>> -----Original Message-----
>> From: Adriano dos Santos Fernandes [mailto:adr...@gm...] 
>> Sent: Sábado, 14 de Noviembre de 2009 17:31
>>
>> Current behavior is not good. Imagine a default expression 
>> with a generator being incremented every time a record is read.
> 
> But this is because you want to go beyond constant values that are the only
> ones allowed now (except the current_* expressions). I don't think generator
> usage for defaults is part of the standard.
> 
Except literals all expressions supported are CURRENT_*. Also do not forget that NOT-NULL field can be changed to NULL and that "smart" logic of evaluate DEFAULT at read will suck.


Adriano