db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mike Matrigali <mikem_...@sbcglobal.net>
Subject Re: [jira] Updated: (DERBY-3330) provide support for unique constraint over nullable columns
Date Fri, 22 Feb 2008 18:12:55 GMT
Why are you upgrading the backing indexes of existing unique 
constraints, those that exist should only be on non-nullable columns
so should not need to be changed.  I have not read through the new
code yet, but I assume also that new constraints on non-nullable columns
also don't use the "new" code - they should not pay the left/right 
search cost.


Anurag Shekhar (JIRA) wrote:
>      [ https://issues.apache.org/jira/browse/DERBY-3330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
> 
> Anurag Shekhar updated DERBY-3330:
> ----------------------------------
> 
>     Attachment: derby-3330v8.diff
> 
> In this patch (derby-3330v8.diff) I have modified upgrade routine to 
> upgrade only the backing indexes of unique constraint. Other 
> indexes are left unchanged.
> 
> DataDictionaryImpl.getAllConglomerates (introduced in derby-3330v6.dif) is 
> no more required so I have taken it off.
> 
> Tests are running without any error or failures. 
> 
>> 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,
derby-3330v7.diff, derby-3330v8.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.
> 


Mime
View raw message