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, b int, c int, unique key(a, b, c));
- statement: CREATE INDEX idx_id_name on tech_book(id, name);
- statement: |-
CREATE INDEX idx_id_name_1 on tech_book(id, name);
CREATE INDEX idx_id_name_2 on tech_book(id, name);
CREATE INDEX idx_id_name_3 on tech_book(id, name);
CREATE INDEX idx_id_name_4 on tech_book(id, name);
CREATE INDEX idx_id_name_5 on tech_book(id, name);
want:
- status: 2
code: 813
title: INDEX_TOTAL_NUMBER_LIMIT
content: The count of index in table `tech_book` should be no more than 5, but found 8
startposition:
line: 5
column: 0
endposition: null
- statement: |-
CREATE TABLE t(a int PRIMARY KEY, b int, c int);
CREATE INDEX idx_a_b_1 on t(a, b);
CREATE INDEX idx_a_b_2 on t(a, b);
CREATE INDEX idx_a_b_3 on t(a, b);
CREATE INDEX idx_a_b_4 on t(a, b);
CREATE INDEX idx_a_b_5 on t(a, b);
want:
- status: 2
code: 813
title: INDEX_TOTAL_NUMBER_LIMIT
content: The count of index in table `t` should be no more than 5, but found 6
startposition:
line: 6
column: 0
endposition: null
- statement: |-
CREATE TABLE t(
a int PRIMARY KEY,
b int,
c int,
INDEX idx_a_b_1 (a, b),
INDEX idx_a_b_2 (a, b),
INDEX idx_a_b_3 (a, b),
INDEX idx_a_b_4 (a, b),
INDEX idx_a_b_5 (a, b));
want:
- status: 2
code: 813
title: INDEX_TOTAL_NUMBER_LIMIT
content: The count of index in table `t` should be no more than 5, but found 6
startposition:
line: 1
column: 0
endposition: null
- statement: |-
CREATE TABLE t (
a int PRIMARY KEY,
b int,
c int
);
ALTER TABLE t ADD INDEX idx_a_b_1 (a, b);
ALTER TABLE t ADD INDEX idx_a_b_2 (a, b);
ALTER TABLE t ADD INDEX idx_a_b_3 (a, b);
ALTER TABLE t ADD INDEX idx_a_b_4 (a, b);
ALTER TABLE t ADD INDEX idx_a_b_5 (a, b);
want:
- status: 2
code: 813
title: INDEX_TOTAL_NUMBER_LIMIT
content: The count of index in table `t` should be no more than 5, but found 6
startposition:
line: 10
column: 0
endposition: null