Skip to content

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

1.7 KB
Raw Blame
- statement: CREATE TABLE t1(name char);
- statement: CREATE TABLE t(name char(20));
- statement: CREATE TABLE t(name varchar(225));
- statement: |-
    CREATE TABLE t1(name char(20));
    CREATE TABLE t2(name char(225));
  want:
    - status: 2
      code: 415
      title: COLUMN_MAXIMUM_CHARACTER_LENGTH
      content: The length of the CHAR column `t2.name` is bigger than 20, please use VARCHAR instead
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    ALTER TABLE tech_book ADD COLUMN name_1 char(20);
    ALTER TABLE tech_book ADD COLUMN name_2 char(225);
  want:
    - status: 2
      code: 415
      title: COLUMN_MAXIMUM_CHARACTER_LENGTH
      content: The length of the CHAR column `tech_book.name_2` is bigger than 20, please use VARCHAR instead
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    ALTER TABLE tech_book CHANGE COLUMN name name char(20);
    ALTER TABLE tech_book CHANGE COLUMN name name char(225);
  want:
    - status: 2
      code: 415
      title: COLUMN_MAXIMUM_CHARACTER_LENGTH
      content: The length of the CHAR column `tech_book.name` is bigger than 20, please use VARCHAR instead
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    ALTER TABLE tech_book MODIFY COLUMN name char(20);
    ALTER TABLE tech_book MODIFY COLUMN name char(225);
  want:
    - status: 2
      code: 415
      title: COLUMN_MAXIMUM_CHARACTER_LENGTH
      content: The length of the CHAR column `tech_book.name` is bigger than 20, please use VARCHAR instead
      startposition:
        line: 2
        column: 0
      endposition: null