db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mike Matrigali (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3330) provide support for unique constraint over nullable columns
Date Wed, 27 Feb 2008 19:09:53 GMT

     [ 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.


Mime
View raw message