[
https://issues.apache.org/jira/browse/DERBY-3502?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12576271#action_12576271
]
A B commented on DERBY-3502:
----------------------------
Thank you for the patch, Anurag--and esp. for updating the comments in
"describeSharedConglomerate()" to agree with your changes :) I'm running
suites.All and derbyall now and plan to commit if all goes well.
> Unique Constraint's backing index when shared with existing indexes doesn't
> behave as expected
> ----------------------------------------------------------------------------------------------
>
> Key: DERBY-3502
> URL: https://issues.apache.org/jira/browse/DERBY-3502
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.0.0
> Reporter: Anurag Shekhar
> Assignee: Anurag Shekhar
> Priority: Critical
> Attachments: derby-3502v1.diff, derby-3502v2.diff, derby-3502v3.diff
>
>
> Unique Constraint now uses non unique backing indexes with new attribute
> UniqueWithDuplicateNulls. This index has following sharing properties
> 1. Can use an existing unique index.
> 2. Non Unique indexes (and foreign key) can use this index.
> While dropping a unique index a new index for unique constraint should be
> created.
> when a unique constraint is dropped a new index for a non unique index or
> foreign key should be created.
> Army has found several issues in actual behavior. This problems are listed in
> DERBY-3456.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
