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

Anurag Shekhar updated DERBY-3456:
----------------------------------

    Attachment: derby-3456-Tests.diff
                derby-3456v3.diff

Description of derby-3456v3.diff
I have regenerated the patch with latest trunk. In my last patch 
(v2) I had made a mistake, I was skipping  creating new index if the 
existing was unique index, while setting the key part to null able. It should 
be other ways. I have fixed that in this patch.

Description of derby-3456-Tests.diff
This has Test Cases for
1. Soft and Hard upgrade 
2. Index tests (created while running older version and soft upgrade and used 
during other phases).
3. New test case to test setting a column participating in unique constraint to 
null.
4. Updated lang/altertable.sql and altertable.out for setting column 
participating in unique constraint to null. (Modified to expect success)

I haven't finished running tests with these two patch. 
 



> 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: 10.4.0.0
>         Environment: all
>            Reporter: Anurag Shekhar
>            Assignee: Anurag Shekhar
>         Attachments: altertable.diff, derby-3456-Tests.diff, 
> derby-3456v1.diff, derby-3456v2.diff, derby-3456v3.diff, setnulltest.diff, 
> upgradetests.diff, upgradetests_v2.diff
>
>


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

Reply via email to