db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Stan Bradbury (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-2919) Alter table .. Add .. Primary Key fails with Column not found when columnName contains localized characters - w/a available
Date Wed, 11 Jul 2007 04:28:04 GMT
Alter table .. Add .. Primary Key fails with Column not found when columnName contains localized
characters - w/a available
---------------------------------------------------------------------------------------------------------------------------

                 Key: DERBY-2919
                 URL: https://issues.apache.org/jira/browse/DERBY-2919
             Project: Derby
          Issue Type: Bug
          Components: Localization
    Affects Versions: 10.3.1.1
            Reporter: Stan Bradbury
            Priority: Minor


Database created with territory=es_MX and table with colunName Excepci≤n (taken from exception
text for "ERROR XJ001: Excepci≤n de Java:...")  trying to specify the column as the primary
key using alter table fails:

Db Creation URL:  connect 'jdbc:derby:toursMx;create=true;territory=es_MX';
-- Create table
Create table Ciudad_de_Mexico2
   ( nombre   varchar(24),
        estado  varchar(24),
         Excepci≤n int );
-- Create PK
 ALTER TABLE Ciudad_de_Mexico2
  ADD CONSTRAINT Mx_PK2 Primary Key (
 Excepci≤n);
-- ERROR 42831: 'EXCEPCI╙N' no puede ser una columna de clave primaria o clave - nica porque
puede contener valores nulos.

-- WORKAROUND:  create the primary key when the table is created:

Create table Ciudad_de_Mexico
   ( nombre   varchar(24),
	estado  varchar(24),
  	 Excepci≤n int constraint mx_pk Primary Key);


-- 
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