Skip to content

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

1.2 KB
Raw Blame
- statement: |
    CREATE TABLE book(id INT);
    INSERT INTO book(id) values (1);
- statement: |
    CREATE TABLE book(id INT);
    SELECT id FROM book;
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: '"SELECT id FROM book;" requires WHERE clause'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    CREATE TABLE book(id INT);
    SELECT id FROM book WHERE id > 0;
- statement: |
    CREATE TABLE book(id INT);
    (SELECT id FROM book);
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: '"(SELECT id FROM book);" requires WHERE clause'
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: |
    CREATE TABLE book(id INT);
    SELECT id
    FROM book
    WHERE id > (
      SELECT max(id)
      FROM book
      );
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: |-
        "SELECT id
        FROM book
        WHERE id > (
          SELECT max(id)
          FROM book
          );" requires WHERE clause
      startposition:
        line: 5
        column: 0
      endposition: null
- statement: |
    SELECT CURDATE();