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: |-
-- The rule should be friendly with engine behavior(i.e. stored and resolved as uppercase characters if not quoted)
CREATE TABLE t(id INT);
changeType: 1
- statement: CREATE TABLE t(ID INT);
changeType: 1
- statement: |-
CREATE TABLE t(
name VARCHAR,
age INT,
"address" VARCHAR
);
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "address" should be upper case
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE mytable_copy (
name INT,
age INT,
"address" VARCHAR
) AS SELECT a + 1, b + 2 FROM mytable;
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "address" should be upper case
startposition:
line: 2
column: 0
endposition: null
- statement: |-
CREATE TABLE mytable_copy (
name INT,
age INT,
address VARCHAR
) AS SELECT a + 1, b + 2 FROM mytable;
changeType: 1
- statement: ALTER TABLE mytable RENAME COLUMN name TO "address";
changeType: 1
want:
- status: 2
code: 309
title: NAMING_IDENTIFIER_CASE
content: Identifier "address" should be upper case
startposition:
line: 1
column: 0
endposition: null
- statement: ALTER TABLE mytable RENAME COLUMN name TO address;
changeType: 1