[jira] Closed: (DERBY-2919) Alter table .. Add .. Primary Key fails with Column not found when columnName contains localized characters - w/a available

["Stan Bradbury (JIRA)" <ji...@apache.org>]

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

Stan Bradbury closed DERBY-2919.
--------------------------------

    Resolution: Invalid

Opps, my mistake.  Closing as Invalid

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