[
https://issues.apache.org/jira/browse/DERBY-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12573031#action_12573031
]
Anurag Shekhar commented on DERBY-3456:
---------------------------------------
After applying 3330. A unique constraint won't be using a unique index
but will use a non unique backing index with special case of
uniqueWhenNotNull. So Case 3 needs to modified.
Thanks for pointing out.
There is one more minor change in CreateIndexConstantAction required (to
fetch new attribute uniqueWhenNotNull) while creating a replacement index.
I will make these two changes in a separate patch.
> 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: derby-3456v1.diff, upgradetests.diff
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.