[
https://issues.apache.org/jira/browse/DERBY-3330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anurag Shekhar updated DERBY-3330:
----------------------------------
Attachment: derby-3330v6.diff
This patch includes hard upgrade (Upgrade test from 10.3.1.4 and 10.1.3.1runs
without fails).
Description of Hard upgrade
Hard upgrade makes following changes
1. Updates B2I class by adding extra attribute (uniquewhenNotNull)
2. Updates format id.
3. Updates ConglomerateDescriptor of all updated Conglomerates to
user new version of IndexDescriptorImpl
Unique index meant to be backing index of UniqueConstraint is updated to
become UniqueWhenNotNull index (nUniqueColumn is set to nKeyFields - 1
and uniquewhen not null is set to true). For other indexes uniqueWhenNotNull
attribute is set to false.
Hard upgrade is initiated from DataDictionaryImpl.upgradeConglomerate
(new method). This method calles another newly intoroduced method
getAllConglomerates to get the list of conglomerate and updates them
by calling TransaCtioncontroller.updateUniquenessOfConglomerate
which internally calls Conglomerate.updateUniqueness to
conglomerate attributes.
I will be posting one more patch after introducing multipage page
scan while checking for duplicates.
> provide support for unique constraint over nullable columns
> -----------------------------------------------------------
>
> Key: DERBY-3330
> URL: https://issues.apache.org/jira/browse/DERBY-3330
> Project: Derby
> Issue Type: New Feature
> Components: Store
> Affects Versions: 10.4.0.0
> Environment: all
> Reporter: Anurag Shekhar
> Assignee: Anurag Shekhar
> Attachments: BTreeController.diff, derby-3330-testcase.diff,
> derby-3330.diff, derby-3330v2.diff, derby-3330v3.diff, derby-3330v4.diff,
> derby-3330v5.diff, derby-3330v6.diff, FunctionalSpec_DERBY-3330-V2.html,
> FunctionalSpec_DERBY-3330.html, UniqueConstraint_Implementation.html
>
>
> Allow unique constraint over nullable field. Right now derby support unique
> constraint only over not null columns.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
