-
Notifications
You must be signed in to change notification settings - Fork 1.3k
Closed
Labels
WITH clauseRelated to the WITH clause implementation.Related to the WITH clause implementation.
Description
It is possible to execute a CTE query without columns in H2:
WITH A AS (SELECT) TABLE A;
> one row, no columnsBut it isn't possible to execute a view with such query:
CREATE VIEW V AS
WITH A AS (SELECT) TABLE A;
> ok
TABLE V;
> view is invalidThis issue is caused by empty <with column list> in persisted query:
WITH "A"() AS (
SELECT
)
TABLE "A"Metadata
Metadata
Assignees
Labels
WITH clauseRelated to the WITH clause implementation.Related to the WITH clause implementation.