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

create table fails when a constraint defintion follows a column default

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.0.2.1
    • 10.1.3.1, 10.2.1.6
    • SQL
    • None
    • 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.diff
          3 kB
          Dag H. Wanvik
        2. 331b.stat
          0.2 kB
          Dag H. Wanvik

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: