[ https://issues.apache.org/jira/browse/DERBY-3330?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anurag Shekhar updated DERBY-3330: ---------------------------------- Attachment: derby-3330v7.diff This page include the code to scan multiple slot/page if the slot identified immediate left and right returns null. It continues to scan (lef in case privious and right in case of next record) unless a valid record is found in a slot or no more pages are left to check. Every time the scan moves to a new page the latch on the privious page is released (unless the previous page has the slot identified to insert the new record). All junit test suites are running without any failure. > 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, > 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.