Skip to content

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

3.2 KB
Raw Blame
- statement: CREATE TABLE UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES(ID INT);
  changeType: 1
- statement: CREATE TABLE "UPPER_CASE_TABLE_NAME_WITH_DOUBLE_QUOTES"(ID INT);
  changeType: 1
- statement: CREATE TABLE lower_case_table_name_without_double_quotes(ID INT);
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lower_case_table_name_without_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: CREATE TABLE "lower_case_table_name_with_double_quotes"(ID INT);
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lower_case_table_name_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: "CREATE TABLE \"\U0001F608EMOJI\U0001F604\"(ID INT);"
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: "\"\U0001F608EMOJI\U0001F604\" mismatches table naming convention, naming format should be \"^[A-Z]+(_[A-Z]+)*$\""
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: ALTER TABLE "lower_case_table_with_double_quotes" RENAME TO UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
  changeType: 1
- statement: ALTER TABLE UPPER_CASE_TABLE_NAME RENAME TO "lower_case_table_with_double_quotes";
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lower_case_table_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES(ID INT);
                ALTER TABLE UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES RENAME TO "lower_case_table_with_double_quotes";
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lower_case_table_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE "lower_case_table_name_with_double_quotes"(ID INT);
                ALTER TABLE "lower_case_table_name_with_double_quotes" RENAME TO UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lower_case_table_name_with_double_quotes" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: |-
    CREATE TABLE "lowercase"(ID INT);
                ALTER TABLE another_schema."lower_case" RENAME TO another_schema.UPPER_CASE_TABLE_NAME_WITHOUT_DOUBLE_QUOTES;
  changeType: 1
  want:
    - status: 2
      code: 301
      title: NAMING_TABLE
      content: '"lowercase" mismatches table naming convention, naming format should be "^[A-Z]+(_[A-Z]+)*$"'
      startposition:
        line: 1
        column: 0
      endposition: null