[jira] Assigned: (DERBY-2955) ERROR 42ZA2 creating table with check constraint with literal comparison

["Mamta A. Satoor (JIRA)" <ji...@apache.org>]

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

Mamta A. Satoor reassigned DERBY-2955:
--------------------------------------

    Assignee: Mamta A. Satoor

> 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
>            Assignee: Mamta A. Satoor
>
> 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.