Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <15873215.1185904432832.JavaMail.jira@brutus>
Date: Tue, 31 Jul 2007 10:53:52 -0700 (PDT)
From: "Stan Bradbury (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Closed: (DERBY-2919) Alter table .. Add .. Primary Key fails
 with Column not found when columnName contains localized characters - w/a
 available
In-Reply-To: <22857730.1184128084461.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-2919?page=3Dcom.atlassia=
n.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 column=
Name 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=3Des_MX and table with colunName Excepci=
=E2=89=A4n (taken from exception text for "ERROR XJ001: Excepci=E2=89=A4n d=
e Java:...")  trying to specify the column as the primary key using alter t=
able fails:
> Db Creation URL:  connect 'jdbc:derby:toursMx;create=3Dtrue;territory=3De=
s_MX';
> -- Create table
> Create table Ciudad_de_Mexico2
>    ( nombre   varchar(24),
>         estado  varchar(24),
>          Excepci=E2=89=A4n int );
> -- Create PK
>  ALTER TABLE Ciudad_de_Mexico2
>   ADD CONSTRAINT Mx_PK2 Primary Key (
>  Excepci=E2=89=A4n);
> -- ERROR 42831: 'EXCEPCI=E2=95=99N' no puede ser una columna de clave pri=
maria 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),
> =09estado  varchar(24),
>   =09 Excepci=E2=89=A4n int constraint mx_pk Primary Key);

--=20
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.