Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.7 KB
Raw Blame
- statement: CREATE TABLE t (a INT, PRIMARY KEY (a));
  changeType: 1
- statement: |-
    CREATE TABLE t (
            a int,
            PRIMARY KEY (a, a));
  changeType: 1
  want:
    - status: 2
      code: 812
      title: INDEX_NO_DUPLICATE_COLUMN
      content: PRIMARY KEY "" has duplicate column "t"."a"
      startposition:
        line: 3
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(a int);
    CREATE INDEX idx_a on t(a, a);
  changeType: 1
  want:
    - status: 2
      code: 812
      title: INDEX_NO_DUPLICATE_COLUMN
      content: INDEX "idx_a" has duplicate column "t"."a"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(a int);
    ALTER TABLE t ADD CONSTRAINT uk_a UNIQUE (a, a);
  changeType: 1
  want:
    - status: 2
      code: 812
      title: INDEX_NO_DUPLICATE_COLUMN
      content: UNIQUE KEY "uk_a" has duplicate column "t"."a"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(a int);
    ALTER TABLE t ADD CONSTRAINT pk_a PRIMARY KEY (a, a);
  changeType: 1
  want:
    - status: 2
      code: 812
      title: INDEX_NO_DUPLICATE_COLUMN
      content: PRIMARY KEY "pk_a" has duplicate column "t"."a"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE t(a int);
    ALTER TABLE t ADD CONSTRAINT fk_a FOREIGN KEY (a, a) REFERENCES t1(a, b);
  changeType: 1
  want:
    - status: 2
      code: 812
      title: INDEX_NO_DUPLICATE_COLUMN
      content: FOREIGN KEY "fk_a" has duplicate column "t"."a"
      startposition:
        line: 2
        column: 0
      endposition: null