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] Created: (DERBY-2955) ERROR 42ZA2 creating table with check constraint with literal comparison
Date Thu, 19 Jul 2007 14:44:06 GMT
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