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 book(
id int,
name varchar(255)
);
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`id` cannot have NULL value'
startposition:
line: 2
column: 0
endposition: null
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`name` cannot have NULL value'
startposition:
line: 3
column: 0
endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255));
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`name` cannot have NULL value'
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int NOT NULL, name varchar(255));
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`name` cannot have NULL value'
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255) NOT NULL);
- statement: |-
CREATE TABLE book(a int NOT NULL);
ALTER TABLE book ADD COLUMN (id int, name varchar(255) NOT NULL);
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`id` cannot have NULL value'
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE book(a int NOT NULL);
ALTER TABLE book ADD COLUMN id int, ADD COLUMN name varchar(255) NOT NULL;
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`id` cannot have NULL value'
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE book(a int NOT NULL);
ALTER TABLE book ADD COLUMN (id int PRIMARY KEY, name varchar(255) NOT NULL);
- statement: |-
CREATE TABLE book(a int NOT NULL);
ALTER TABLE book ADD COLUMN id int PRIMARY KEY, ADD COLUMN name varchar(255) NOT NULL;
- statement: |-
CREATE TABLE book(id int NOT NULL);
ALTER TABLE book CHANGE COLUMN id name varchar(255);
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: '`book`.`name` cannot have NULL value'
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE book(id int NOT NULL);
ALTER TABLE book CHANGE COLUMN id name varchar(255) NOT NULL;