[
https://issues.apache.org/jira/browse/DERBY-2919?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12511659
]
Mamta A. Satoor commented on DERBY-2919:
----------------------------------------
Stan, if you have the stack trace, can you please post it in this jira entry?
In the mean time, I will try to reproduce it myself.
> 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.
