Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3330 provide support for unique constraint over keys that include one or more nullable columns.
  3. DERBY-3456

Allow removing not null from collumns particpating in unique constraint.

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.4.1.3
    • 10.4.1.3
    • SQL, Store
    • None
    • all

    Description

      Enable alter table to change a column that participates in a unique constraint to allow nulls.

      Attachments

        1. altertable.diff
          2 kB
          Anurag Aggarwal
        2. derby-3456-Tests_v2.diff
          10 kB
          Anurag Aggarwal
        3. derby-3456-Tests.diff
          19 kB
          Anurag Aggarwal
        4. derby-3456v1.diff
          6 kB
          Anurag Aggarwal
        5. derby-3456v2.diff
          6 kB
          Anurag Aggarwal
        6. derby-3456v3.diff
          6 kB
          Anurag Aggarwal
        7. derby-3456v4.diff
          9 kB
          Anurag Aggarwal
        8. derby-3456v5.diff
          6 kB
          Anurag Aggarwal
        9. setnulltest.diff
          6 kB
          Anurag Aggarwal
        10. upgradetests_v2.diff
          10 kB
          Anurag Aggarwal
        11. upgradetests.diff
          4 kB
          Anurag Aggarwal

        Activity

          People

            anurag Anurag Aggarwal
            anurag Anurag Aggarwal
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: