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

          Gavin made changes -
          Workflow jira [ 12421432 ] Default workflow, editable Closed status [ 12801598 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Myrna van Lunteren made changes -
          Fix Version/s 10.4.1.3 [ 12313111 ]
          Mike Matrigali made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Anurag Shekhar made changes -
          Link This issue is related to DERBY-3523 [ DERBY-3523 ]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Release Note Needed]
          Component/s SQL [ 11408 ]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Anurag Shekhar made changes -
          Attachment sortercomments.diff [ 12377283 ]
          Mike Matrigali made changes -
          Attachment derby-3330_followup_1_modified.diff [ 12377281 ]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Anurag Shekhar made changes -
          Attachment UniqueConstraint_Implementation_V4.html [ 12377272 ]
          Anurag Shekhar made changes -
          Link This issue relates to DERBY-3502 [ DERBY-3502 ]
          Anurag Shekhar made changes -
          Attachment derby-3330_followup_1.diff [ 12377257 ]
          Anurag Shekhar made changes -
          Attachment derby-3330-UpgradeTests.diff [ 12377142 ]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Mike Matrigali made changes -
          Description Allow unique constraint over nullable field. Right now derby support unique constraint only over not null columns. 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.
          Summary provide support for unique constraint over nullable columns provide support for unique constraint over keys that include one or more nullable columns.
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Mike Matrigali made changes -
          Derby Info [Release Note Needed, Patch Available] [Patch Available, Release Note Needed]
          Anurag Shekhar made changes -
          Attachment db2Compatibility-v2.diff [ 12376862 ]
          Anurag Shekhar made changes -
          Derby Info [Patch Available, Release Note Needed]
          Anurag Shekhar made changes -
          Attachment derby-3330v13.diff [ 12376773 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v12.diff [ 12376736 ]
          Anurag Shekhar made changes -
          Attachment db2Compatibility.diff [ 12376712 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v11.diff [ 12376711 ]
          Mike Matrigali made changes -
          Attachment derbyall_report.txt [ 12376682 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v10.diff [ 12376674 ]
          Anurag Shekhar made changes -
          Attachment UniqueConstraint_Implementation_V3.html [ 12376309 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v9.diff [ 12376302 ]
          Anurag Shekhar made changes -
          Attachment UniqueConstraint_Implementation_V2.html [ 12376251 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v8.diff [ 12376240 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v7.diff [ 12376205 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v6.diff [ 12376120 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v5.diff [ 12375565 ]
          Anurag Shekhar made changes -
          Attachment UniqueConstraint_Implementation.html [ 12374544 ]
          Anurag Shekhar made changes -
          Attachment BTreeController.diff [ 12374485 ]
          Anurag Shekhar made changes -
          Attachment FunctionalSpec_DERBY-3330-V2.html [ 12374153 ]
          Anurag Shekhar made changes -
          Attachment FunctionalSpec_DERBY-3330.html [ 12373919 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v4.diff [ 12373909 ]
          Attachment derby-3330-testcase.diff [ 12373910 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v3.diff [ 12373854 ]
          Anurag Shekhar made changes -
          Attachment derby-3330v2.diff [ 12373736 ]
          Anurag Shekhar made changes -
          Attachment derby-3330.diff [ 12373494 ]
          Anurag Shekhar made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-2212 [ DERBY-2212 ]
          Anurag Shekhar created issue -

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development