Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <141816100.1247001014917.JavaMail.jira@brutus>
Date: Tue, 7 Jul 2009 14:10:14 -0700 (PDT)
From: "Kathey Marsden (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3523) sql states (X0Y63, X0Y63, X0Y63.S)
 related to nulls in unique constraints are associated with wrong message
 texts
In-Reply-To: <976084676.1205254246221.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-3523?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12728368#action_12728368 ] 

Kathey Marsden commented on DERBY-3523:
---------------------------------------

No I don't think this is ready to be resolved. It looks like I committed a patch and then backed it out and then there was another one posted that hasn't been committed.  Maybe it should be marked patch available and we can see if the patch still applies.

> sql states (X0Y63, X0Y63, X0Y63.S) related to nulls in unique constraints are associated with wrong message texts 
> ------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-3523
>                 URL: https://issues.apache.org/jira/browse/DERBY-3523
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.4.1.3, 10.5.1.1
>            Reporter: Anurag Shekhar
>            Assignee: Anurag Shekhar
>         Attachments: derby-3523-upgradetest.diff, derby-3523-upgradetest_v2.diff, derby-3523v1.diff, derby-3523v2.diff, derby-3523v3.diff
>
>
> There are three messages which after Derby-3330 checkin now giving wrong information. These are
> 42831:'{0}' cannot be a column of a primary key or unique key because it can contain null values.
> 42Z20:Column '{0}' cannot be made nullable. It is part of a primary key or unique constraint, which cannot have any null able columns.
> X0Y63.S:The command on table '{0}' failed because null data was found in the primary key or unique constraint/index column(s). All columns in a primary or unique index key must not be null.

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