[
https://issues.apache.org/jira/browse/DERBY-3502?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar resolved DERBY-3502.
-----------------------------------
Resolution: Fixed
Patch committed in revision #634852
There is no outstanding patch for this issue.
> 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
> Fix For: 10.4.0.0
>
> Attachments: d3502v3_modified_1.diff, 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.
