Skip to content

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

2.6 KB
Raw Blame
- statement: INSERT INTO tech_book SELECT * FROM tech_book;
- statement: |
    INSERT INTO tech_book SELECT * FROM tech_book;
    INSERT INTO tech_book SELECT * FROM tech_book LIMIT 1;
  want:
    - status: 2
      code: 1103
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book LIMIT 1;" uses
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    INSERT INTO tech_book SELECT * FROM tech_book;
    INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;
  want:
    - status: 2
      code: 1103
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;" uses
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    INSERT INTO tech_book SELECT * FROM tech_book;
    INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;
  want:
    - status: 2
      code: 1103
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book SELECT * FROM tech_book UNION SELECT * FROM tech_book LIMIT 1;" uses
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    INSERT INTO tech_book SELECT * FROM tech_book;
    INSERT INTO tech_book (SELECT * FROM tech_book LIMIT 1);
  want:
    - status: 2
      code: 1103
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "INSERT INTO tech_book (SELECT * FROM tech_book LIMIT 1);" uses
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    UPDATE tech_book SET name = 'my name';
    UPDATE tech_book SET name = 'my name' LIMIT 10;
  want:
    - status: 2
      code: 1102
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "UPDATE tech_book SET name = 'my name' LIMIT 10;" uses
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    DELETE FROM tech_book;
    DELETE FROM tech_book LIMIT 10;
  want:
    - status: 2
      code: 1106
      title: STATEMENT_DISALLOW_LIMIT
      content: LIMIT clause is forbidden in INSERT, UPDATE and DELETE statement, but "DELETE FROM tech_book LIMIT 10;" uses
      startposition:
        line: 2
        column: 0
      endposition: null