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

Mike Matrigali updated DERBY-3330:
----------------------------------


do you know why the master for dml019 changed?  
Index: java/testing/org/apache/derbyTesting/functionTests/master/dml019.out
===================================================================
--- java/testing/org/apache/derbyTesting/functionTests/master/dml019.out
(revision 630309)
+++ java/testing/org/apache/derbyTesting/functionTests/master/dml019.out
(working copy)
@@ -82,18 +82,18 @@
           GROUP BY PNUM,EMPNUM,HOURS;
 EM&|PN&|HOURS
 --------------
-E1 |P1 |40
-E1 |P2 |20
-E1 |P3 |80
-E1 |P4 |20
+E2 |P1 |40
+E4 |P4 |40
 E1 |P5 |12
+E4 |P5 |80
 E1 |P6 |12
-E2 |P1 |40
-E2 |P2 |80
 E3 |P2 |20
+E1 |P4 |20
+E1 |P1 |40
 E4 |P2 |20
-E4 |P4 |40
-E4 |P5 |80
+E1 |P2 |20
+E2 |P2 |80
+E1 |P3 |80
 ij> -- PASS:0077 If 12 rows are selected ?

 -- END TEST >>> 0077 <<< END TEST
@@ -105,18 +105,18 @@
           GROUP BY EMPNUM,PNUM,HOURS;
 PN&|EM&
 -------
-P1 |E1
-P2 |E1
-P3 |E1
-P4 |E1
+P1 |E2
+P4 |E4
 P5 |E1
+P5 |E4
 P6 |E1
-P1 |E2
-P2 |E2
 P2 |E3
+P4 |E1
+P1 |E1
 P2 |E4
-P4 |E4
-P5 |E4
+P2 |E1
+P2 |E2
+P3 |E1
 ij> -- PASS:0078 If 12 rows are selected  ?

 -- END TEST >>> 0078 <<< END TEST

> 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, 
> derby-3330v9.diff, FunctionalSpec_DERBY-3330-V2.html, 
> FunctionalSpec_DERBY-3330.html, UniqueConstraint_Implementation.html, 
> UniqueConstraint_Implementation_V2.html, 
> UniqueConstraint_Implementation_V3.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.

Reply via email to