Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3330

provide support for unique constraint over keys that include one or more nullable columns.

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.1.3
    • Fix Version/s: 10.4.1.3
    • Component/s: SQL, Store
    • Labels:
      None
    • Environment:
      all
    • Issue & fix info:
      Release Note Needed

      Description

      Allow unique constraint over keys which include one or more nullable fields. Prior to this change Derby only supported unique constraints on keys that included no nullable columns. The new constraint will allow unlimited inserts of any key with one more null columns, but will limit insert of keys with no null columns to 1 unique value per table.

      There is no change to existing or newly created unique indexes on null columns (as opposed to unique constraints on null columns). Also there is no change to existing or newly created constraints on keys with no nullable columns.

        Attachments

        1. derby-3330.diff
          29 kB
          Anurag Shekhar
        2. derby-3330v2.diff
          38 kB
          Anurag Shekhar
        3. derby-3330v3.diff
          39 kB
          Anurag Shekhar
        4. derby-3330v4.diff
          39 kB
          Anurag Shekhar
        5. derby-3330-testcase.diff
          19 kB
          Anurag Shekhar
        6. FunctionalSpec_DERBY-3330.html
          7 kB
          Anurag Shekhar
        7. FunctionalSpec_DERBY-3330-V2.html
          7 kB
          Anurag Shekhar
        8. BTreeController.diff
          10 kB
          Anurag Shekhar
        9. UniqueConstraint_Implementation.html
          15 kB
          Anurag Shekhar
        10. derby-3330v5.diff
          84 kB
          Anurag Shekhar
        11. derby-3330v6.diff
          102 kB
          Anurag Shekhar
        12. derby-3330v7.diff
          103 kB
          Anurag Shekhar
        13. derby-3330v8.diff
          101 kB
          Anurag Shekhar
        14. UniqueConstraint_Implementation_V2.html
          12 kB
          Anurag Shekhar
        15. derby-3330v9.diff
          86 kB
          Anurag Shekhar
        16. UniqueConstraint_Implementation_V3.html
          10 kB
          Anurag Shekhar
        17. derby-3330v10.diff
          86 kB
          Anurag Shekhar
        18. derbyall_report.txt
          19 kB
          Mike Matrigali
        19. derby-3330v11.diff
          82 kB
          Anurag Shekhar
        20. db2Compatibility.diff
          2 kB
          Anurag Shekhar
        21. derby-3330v12.diff
          82 kB
          Anurag Shekhar
        22. derby-3330v13.diff
          88 kB
          Anurag Shekhar
        23. db2Compatibility-v2.diff
          3 kB
          Anurag Shekhar
        24. derby-3330-UpgradeTests.diff
          10 kB
          Anurag Shekhar
        25. derby-3330_followup_1.diff
          5 kB
          Anurag Shekhar
        26. UniqueConstraint_Implementation_V4.html
          13 kB
          Anurag Shekhar
        27. derby-3330_followup_1_modified.diff
          6 kB
          Mike Matrigali
        28. sortercomments.diff
          1 kB
          Anurag Shekhar

          Issue Links

            Activity

              People

              • Assignee:
                anurag Anurag Shekhar
                Reporter:
                anurag Anurag Shekhar
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: