Skip to content

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

1.4 KB
Raw Blame
- statement: CREATE TABLE "table"(id int, name varchar(255))
  changeType: 1
  want:
    - status: 2
      code: 309
      title: NAMING_IDENTIFIER_CASE
      content: Identifier "table" should be upper case
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE tt(id int, name varchar(255))
  changeType: 1
- statement: CREATE TABLE "Tt"(id int, name varchar(255))
  changeType: 1
  want:
    - status: 2
      code: 309
      title: NAMING_IDENTIFIER_CASE
      content: Identifier "Tt" should be upper case
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book RENAME TO analyze
  changeType: 1
- statement: |-
    create table techBook(id int);
    ALTER TABLE techBook RENAME TO tech_book_tmp;
  changeType: 1
- statement: |-
    DECLARE
      "v_Count" NUMBER;
    BEGIN
      SELECT COUNT(1) INTO "v_Count" FROM "Tt";
    END;
  changeType: 1
  want:
    - status: 2
      code: 309
      title: NAMING_IDENTIFIER_CASE
      content: Identifier "v_Count" should be upper case
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: CREATE CLUSTER "MixedCase" (id NUMBER)
  changeType: 1
  want:
    - status: 2
      code: 309
      title: NAMING_IDENTIFIER_CASE
      content: Identifier "MixedCase" should be upper case
      startposition:
        line: 1
        column: 0
      endposition: null