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)
    );
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`id` cannot have NULL value'
      startposition:
        line: 2
        column: 0
      endposition: null
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`name` cannot have NULL value'
      startposition:
        line: 3
        column: 0
      endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255));
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`name` cannot have NULL value'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE book(id int NOT NULL, name varchar(255));
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`name` cannot have NULL value'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE book(id int PRIMARY KEY, name varchar(255) NOT NULL);
- statement: |-
    CREATE TABLE book(a int NOT NULL);
    ALTER TABLE book ADD COLUMN (id int, name varchar(255) NOT NULL);
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`id` cannot have NULL value'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(a int NOT NULL);
    ALTER TABLE book ADD COLUMN id int, ADD COLUMN name varchar(255) NOT NULL;
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`id` cannot have NULL value'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(a int NOT NULL);
    ALTER TABLE book ADD COLUMN (id int PRIMARY KEY, name varchar(255) NOT NULL);
- statement: |-
    CREATE TABLE book(a int NOT NULL);
    ALTER TABLE book ADD COLUMN id int PRIMARY KEY, ADD COLUMN name varchar(255) NOT NULL;
- statement: |-
    CREATE TABLE book(id int NOT NULL);
    ALTER TABLE book CHANGE COLUMN id name varchar(255);
  want:
    - status: 2
      code: 402
      title: COLUMN_NO_NULL
      content: '`book`.`name` cannot have NULL value'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE book(id int NOT NULL);
    ALTER TABLE book CHANGE COLUMN id name varchar(255) NOT NULL;