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)
)
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "id" in "public"."book" cannot have NULL value
startposition:
line: 2
column: 0
endposition: null
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "name" in "public"."book" cannot have NULL value
startposition:
line: 3
column: 0
endposition: null
- statement: CREATE TABLE book(id int, name varchar(255), PRIMARY KEY (id))
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "name" in "public"."book" cannot have NULL value
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255))
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "name" in "public"."book" cannot have NULL value
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int NOT NULL, name varchar(255))
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "name" in "public"."book" cannot have NULL value
startposition:
line: 1
column: 0
endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255) NOT NULL)
changeType: 1
- statement: ALTER TABLE tech_book ADD COLUMN reader int
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "reader" in "public"."tech_book" cannot have NULL value
startposition:
line: 1
column: 0
endposition: null
- statement: |-
ALTER TABLE tech_book DROP COLUMN id;
ALTER TABLE tech_book DROP COLUMN name;
ALTER TABLE tech_book ADD COLUMN id int PRIMARY KEY, ADD COLUMN name varchar(255) NOT NULL;
changeType: 1
- statement: ALTER TABLE tech_book ALTER COLUMN id SET NOT NULL
changeType: 1
- statement: ALTER TABLE tech_book ALTER COLUMN name DROP NOT NULL
changeType: 1
want:
- status: 2
code: 402
title: COLUMN_NO_NULL
content: Column "name" in "public"."tech_book" cannot have NULL value
startposition:
line: 1
column: 0
endposition: null
- statement: /* this is a comment */
changeType: 1