[
https://issues.apache.org/jira/browse/DERBY-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12576308#action_12576308
]
A B commented on DERBY-3456:
----------------------------
Minor observation: the error message 42Z20 currently says:
ERROR 42Z20: Column 'K' cannot be made nullable. It is part of a primary key
or unique constraint,
which cannot have any nullable columns.
Should this message be updated to exclude "unique constraint", since a unique
constraint can now have a nullable columns?
> Allow removing not null from collumns particpating in unique constraint.
> ------------------------------------------------------------------------
>
> Key: DERBY-3456
> URL: https://issues.apache.org/jira/browse/DERBY-3456
> Project: Derby
> Issue Type: Sub-task
> Components: SQL, Store
> Affects Versions: 10.4.0.0
> Environment: all
> Reporter: Anurag Shekhar
> Assignee: Anurag Shekhar
> Attachments: altertable.diff, derby-3456-Tests.diff,
> derby-3456-Tests_v2.diff, derby-3456v1.diff, derby-3456v2.diff,
> derby-3456v3.diff, derby-3456v4.diff, derby-3456v5.diff, setnulltest.diff,
> upgradetests.diff, upgradetests_v2.diff
>
>
> Enable alter table to change a column that participates in a unique
> constraint to allow nulls.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
