db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2955) ERROR 42ZA2 creating table with check constraint with literal comparison
Date Thu, 19 Jul 2007 14:52:07 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2955?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12513913
] 

Kathey Marsden commented on DERBY-2955:
---------------------------------------

Here is another error that can occur with check constraint from the temp_schema10 test.
ij>  CREATE TABLE RET_CATALOG (
     VENDOR_ID INT,
     PRODUCT_ID INT,
     WHOLESALE NUMERIC (10,2),
     RETAIL NUMERIC (10,2),
     MARKUP NUMERIC (10,2),
     EXPORT_CODE CHAR(2),
     EXPORT_LICNSE_DATE CHAR(20),
     CHECK (EXPORT_LICNSE_DATE IS NULL OR (
       EXPORT_CODE = 'F1' OR
       EXPORT_CODE = 'F2' OR
       EXPORT_CODE = 'F3'                  )),
     CHECK (EXPORT_CODE <> 'F2' OR WHOLESALE > 10000.00),
     CHECK (RETAIL >= WHOLESALE),
     CHECK (RETAIL = WHOLESALE + MARKUP));
ERROR 42818: Comparisons between 'CHAR' and 'CHAR' are not supported.

> ERROR 42ZA2 creating table with check constraint with literal comparison
> ------------------------------------------------------------------------
>
>                 Key: DERBY-2955
>                 URL: https://issues.apache.org/jira/browse/DERBY-2955
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.0.0
>            Reporter: Kathey Marsden
>
> I cannot create the following table with a collated database.  
> EMPNAME should be TERRITORY_BASED collation I think, but perhaps is not initialized in
time for the check constraint processing.
> ij> connect 'jdbc:derby:nordb;create=true;territory=no_NO;collation=TERRITORY_BASED';
> ij> CREATE TABLE STAFF9 (EMPNUM    CHAR(3) NOT NULL
>             CONSTRAINT STAFF9_PK PRIMARY KEY,
>             EMPNAME  CHAR(20),
>             GRADE DECIMAL(4),
>             CITY   CHAR(15),
>             CONSTRAINT STAFF9_EMPNAME CHECK (EMPNAME NOT LIKE 'T%'));
> ERROR 42ZA2: Operand of LIKE predicate with type CHAR(20) and collation UCS_BASIC is
not compatable with LIKE pattern op
> erand with type CHAR(2) and collation TERRITORY_BASED.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message