Snowflake - Syntax error for a correct query

创建于 2026年06月02日 06:26

This code actually errors out in DataGrip but it's syntactically correct

WITH test_cte AS (
  SELECT
    1 AS test
  UNION DISTINCT
  SELECT
    2
)

SELECT
  *
FROM test_cte
;

1 条评论

Anastasia Zhukova

创建于 2026年06月02日 13:17

Hi,

Thank you for reporting it. I've created a separate ticket to support this case: DBE-26228.

As a workaround to be able to execute the statement successfully without the EOF exception, you can right-click the query and select Execute Selection as Single Statement. This option is available since 2026.1.

请先登录再写评论。