Default is only supposed to apply on insert, and if no value is specified.
If you explicitly insert a null it should be null, not the default.


On 3/3/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Is the DEFAULT value for a column suppose to replace
> an explicit NULL value?  Or does the DEFAULT value only
> get used if no values for an insert is specified?  What
> is the correct SQL behavior?
>
> SQLite does the latter - the DEFAULT value is only used
> if no value is given for the column.  If you insert an
> explicit NULL value then a NULL value is inserted instead
> of the DEFAULT value.  Ticket #1705 says this is
> incorrect.
>
> Which is right?  The current SQLite implementation or
> ticket #1705?

Reply via email to