db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Anurag Shekhar (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3330) provide support for unique constraint over nullable columns
Date Thu, 21 Feb 2008 11:53:19 GMT

     [ 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.


Mime
View raw message