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

create table fails when a constraint defintion follows a column default

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.1
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Windows XP

      Description

      The following statement fails with syntax error.

      ij> create table t (a int not null, b int default 0, unique (a));
      ERROR 42X01: Syntax error: Encountered "0" at line 1, column 47.

      And it will work if I remove either default 0 or unique(a).

        Attachments

        1. 331b.stat
          0.2 kB
          Dag H. Wanvik
        2. 331b.diff
          3 kB
          Dag H. Wanvik

          Activity

            People

            • Assignee:
              dagw Dag H. Wanvik
              Reporter:
              ginng Gin Ng
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: