Derby
  1. Derby
  2. DERBY-3330

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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.

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

        Issue Links

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development