Skip to content

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

2.4 KB
Raw Blame
- statement: SELECT * FROM (SELECT * FROM TARGET_TABLE) AS a WHERE a.id = 1;
  changeType: 1
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: SELECT * FROM t;
  changeType: 1
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 1
        column: 0
      endposition: null
- statement: SELECT * FROM t WHERE b = 2;
  changeType: 1
- statement: |-
    with
       album_info_1976 as (select m.album_ID, m.album_name, b.band_name
          from music_albums as m inner join music_bands as b
          where m.band_id = b.band_id and album_year = 1976),
       Journey_album_info_1976 as (select *
          from album_info_1976
       )
    select album_name, band_name
       from Journey_album_info_1976;
  changeType: 1
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 5
        column: 0
      endposition: null
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 8
        column: 0
      endposition: null
- statement: |-
    MERGE INTO target_table USING (
      SELECT id, description FROM source_table
    ) AS filtered_source_table
    ON target_table.id = filtered_source_table.id
    WHEN MATCHED THEN UPDATE SET target_table.a = filtered_source_table.b;
  changeType: 1
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 2
        column: 0
      endposition: null
- statement: SELECT 1;
  changeType: 1
# Lock: CTE bodies ARE visited (omni walker post-#294 covers SelectStmt.With);
# the inner WHERE-less CTE SELECT flags even when the outer SELECT has WHERE.
- statement: WITH c AS (SELECT x FROM t) SELECT a FROM c WHERE id = 1;
  changeType: 1
  want:
    - status: 2
      code: 202
      title: STATEMENT_WHERE_REQUIRE_SELECT
      content: WHERE clause is required for SELECT statement.
      startposition:
        line: 1
        column: 0
      endposition: null