Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

1.4 KB
Raw Blame
- 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