Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
- 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