db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: Problem with CHECK constraints
Date Wed, 12 Nov 2008 23:31:43 GMT

Hi,

I found this in section 4.27.2 Characteristics of SQL-invoked routines:

> If a <routine invocation> is contained in a <query expression> of a
> view, a check constraint, or an assertion, the <triggered action> of a
        ****************
> trigger, or in an <SQL-invoked routine>, then the subject routine for
> that invocation is determined at the time the view is created, the
> check constraint is defined, the assertion is created, the trigger is
> created, or the SQL-invoked routine is created.

So it would appear that Derby's present behavior is wrong.

Thanks,
Dag

Mime
View raw message