db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: default (0)
Date Wed, 15 Aug 2007 14:57:51 GMT
Dag H. Wanvik wrote:
> Mark Thornton <mthornton@optrak.co.uk> writes:
>
>   
>> Derby 10.2.2 appears to reject constant expressions enclosed in
>> parentheses (which should still be constant).
>>     
>
> I think this is correct according to the SQL standard; in section
> "11.5 <default clause>" of ISO/IEC 9075-2:2003, the syntax is shown
> as:
>
> <default clause> ::= DEFAULT <default option>
>
> <default option> ::=
>   <literal>
> | <datetime value function>
> | USER
> | CURRENT_USER
> | CURRENT_ROLE
> | SESSION_USER
> | SYSTEM_USER
> | CURRENT_PATH
> | <implicitly typed value specification>
>
> and once you add parentheses around the zero, it is no longer a
> literal, although constant.
>
> Dag
>   

The Derby documentation (10.3 
http://db.apache.org/derby/docs/10.3/ref/rrefsqlj30540.html#rrefsqlj30540) 
has this
[ [ WITH ] DEFAULT { ConstantExpression | NULL }

Which indicates that something more than just a literal is accepted. So 
perhaps that documentation should be updated.

Regards,
Mark Thornton


Mime
View raw message