Subject | Re: [firebird-support] Domain check constraint fails |
---|---|
Author | Helen Borrie |
Post date | 2006-03-31T23:14:05Z |
At 08:24 AM 1/04/2006, you wrote:
./heLen
>I found a value of '17' in a column defined with the following domain:Neither. '17' meets this constraint.
>
>CREATE DOMAIN D_CUST_GRP AS
> CHAR(3)
> CHECK (VALUE IS NULL OR
>(
>/*LTRIM(RTRIM(STRLEN(VALUE))) = 3 AND*/
> UPPER(VALUE) = VALUE AND
> VALUE BETWEEN '001' AND 'ZZZ'))
> COLLATE ISO8859_1;
>
>Bug or badly written domain? Or both?
./heLen