Skip to content

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

3.4 KB
Raw Blame
- statement: |-
    ALTER TABLE tech_book DROP CONSTRAINT old_pk;
    ALTER TABLE tech_book ADD CONSTRAINT pk_tech_book_id_name PRIMARY KEY (id, name)
  changeType: 1
- statement: |-
    ALTER TABLE tech_book DROP CONSTRAINT old_pk;
    ALTER TABLE tech_book ADD CONSTRAINT tech_book_id_name PRIMARY KEY (id, name)
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "tech_book" mismatches the naming convention, expect "^$|^pk_tech_book_id_name$" but found "tech_book_id_name"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    ALTER TABLE tech_book DROP CONSTRAINT old_pk;
    ALTER TABLE tech_book ADD CONSTRAINT udmhjtnsaablcmjhqcznfiwtnevcehcvw PRIMARY KEY (id, name)
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "tech_book" mismatches the naming convention, expect "^$|^pk_tech_book_id_name$" but found "udmhjtnsaablcmjhqcznfiwtnevcehcvw"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: CREATE TABLE book(id INT, name VARCHAR(20), CONSTRAINT pk_book_name PRIMARY KEY (name))
  changeType: 1
- statement: |-
    -- this is the first line.
            CREATE TABLE book(
              id INT,
              name VARCHAR(20),
              CONSTRAINT tech_book_name PRIMARY KEY (name)
            )
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "book" mismatches the naming convention, expect "^$|^pk_book_name$" but found "tech_book_name"
      startposition:
        line: 5
        column: 0
      endposition: null
- statement: CREATE TABLE book(id INT, name VARCHAR(20), PRIMARY KEY (name))
  changeType: 1
- statement: CREATE TABLE book(id INT, name VARCHAR(20) PRIMARY KEY)
  changeType: 1
- statement: |-
    ALTER TABLE tech_book DROP CONSTRAINT old_pk;
    ALTER TABLE tech_book ADD CONSTRAINT pk_tech_book_id_name PRIMARY KEY USING INDEX old_index
  changeType: 1
- statement: |-
    ALTER TABLE tech_book DROP CONSTRAINT old_pk;
    ALTER TABLE tech_book ADD CONSTRAINT pk_tech_book PRIMARY KEY USING INDEX old_index
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "tech_book" mismatches the naming convention, expect "^$|^pk_tech_book_id_name$" but found "pk_tech_book"
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: ALTER TABLE tech_book RENAME CONSTRAINT old_pk TO pk_tech_book_id_name
  changeType: 1
- statement: ALTER TABLE tech_book RENAME CONSTRAINT old_pk TO pk_tech_book
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "tech_book" mismatches the naming convention, expect "^$|^pk_tech_book_id_name$" but found "pk_tech_book"
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER INDEX old_pk RENAME TO pk_tech_book_id_name
  changeType: 1
- statement: ALTER INDEX old_pk RENAME TO pk_tech_book
  changeType: 1
  want:
    - status: 2
      code: 306
      title: NAMING_INDEX_PK
      content: Primary key in table "tech_book" mismatches the naming convention, expect "^$|^pk_tech_book_id_name$" but found "pk_tech_book"
      startposition:
        line: 1
        column: 0
      endposition: null