Skip to content

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

2.6 KB
Raw Blame
- statement: CREATE UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
- statement: |
    CREATE UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
    CREATE UNIQUE INDEX tech_book_id_name ON tech_book(id, name);
  want:
    - status: 2
      code: 304
      title: NAMING_INDEX_UK
      content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `tech_book_id_name`
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    CREATE UNIQUE INDEX uk_tech_book_id_name ON tech_book(id, name);
    CREATE UNIQUE INDEX qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy ON tech_book(id, name)
  want:
    - status: 2
      code: 304
      title: NAMING_INDEX_UK
      content: Unique key `qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy` in table `tech_book` mismatches the naming convention, its length should be within 64 characters
      startposition:
        line: 2
        column: 0
      endposition: null
    - status: 2
      code: 304
      title: NAMING_INDEX_UK
      content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `qtzmquwvlnttctfluoouxelxeliltcfzzstrtyocogwwyiyrflmrkbhbfasynlacy`
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book ADD UNIQUE uk_tech_book_id_name (id, name);
- statement: |
    CREATE TABLE t1(a INT);
    ALTER TABLE tech_book ADD UNIQUE tech_book_id_name (id, name);
  want:
    - status: 2
      code: 304
      title: NAMING_INDEX_UK
      content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `tech_book_id_name`
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book RENAME INDEX old_uk TO uk_tech_book_id_name;
- statement: |
    CREATE TABLE t1(a INT);
    ALTER TABLE tech_book RENAME INDEX old_uk TO uk_tech_book;
  want:
    - status: 2
      code: 304
      title: NAMING_INDEX_UK
      content: Unique key in table `tech_book` mismatches the naming convention, expect "^$|^uk_tech_book_id_name$" but found `uk_tech_book`
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: CREATE TABLE book(id INT PRIMARY KEY, name VARCHAR(20), UNIQUE INDEX uk_book_name (name));
- statement: |
    CREATE TABLE book(
      id INT PRIMARY KEY,
      name VARCHAR(20),
      UNIQUE KEY (name)
    );
- statement: |
    CREATE TABLE book(
      id INT PRIMARY KEY,
      name VARCHAR(20),
      UNIQUE INDEX (name)
    );