Skip to content

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

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