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-3456) Allow removing not null from collumns particpating in unique constraint.
Date Mon, 25 Feb 2008 21:18:51 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Anurag Shekhar updated DERBY-3456:

    Attachment: derby-3456v1.diff

derby-3456v1.diff enables setting columns (if they are part of unique 
constraint) null able . 
If the backing index for the unique constraints are unique indexes (ie 
created before hard upgrade) it drops the index and recreates them with 
index type as duplicate and unique when not null.

Setting column null able works only after hard upgrade. If the data base
 is running in soft upgrade mode setting the column null able will 
continue to throw exception. 

modified files 

Check for Unique Constraint is now optional (only if the data dictionary 
version is not the latest one). 

added a new method () to drop backing index and recreating with type 
set to non unique and unique when not null.

Added code, while setting column to null able, to check if the column is 
participating in a unique constraint and if the unique constraint was 
created before hard upgrade (index type will be unique in this case) use 
the method in DDLSingleTableConstantAction to recreate the backing 

> Allow removing not null from collumns particpating in unique constraint.
> ------------------------------------------------------------------------
>                 Key: DERBY-3456
>                 URL: https://issues.apache.org/jira/browse/DERBY-3456
>             Project: Derby
>          Issue Type: Sub-task
>          Components: SQL, Store
>    Affects Versions:
>         Environment: all
>            Reporter: Anurag Shekhar
>            Assignee: Anurag Shekhar
>         Attachments: derby-3456v1.diff

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message