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

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

Rustam Gadjimuradov wrote:
> Helen Borrie>
>> Let me see....you want to change (break) the standard behaviour for inserts and "enrich" it so that "default" becomes dynamic 
>> behaviour that (1) resets existing data, (2) bypasses NOT NULL validation for updates and (3) makes the value of the defaulted 
>> field a moving target.
> 
> 
> It is just my impressions too.
> 
> What need of this moving logic from DML (current standart logic) to DDL ?
> BTW, Adriano, correct me if I am wrong - by your logic, field values will be
> "calculted" (by some algorithm) when they reads _instead of_ insert ? 

NO. That is how it works till now.

Just try to add a NOT NULL field with DEFAULT CURRENT_USER to a populated table and select from it using different user names.


Adriano