You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The following prql fails on 0.11.4 but works on 0.10.1.
PRQL input
from foo
derive b = a +1filter true # ensure a CTEderive c = b +1filter true # ensure another CTEgroup {c}(
aggregate {
n =(average c)})
SQL output
WITH table_1 AS (
SELECT
c AS _expr_0,
a +1AS _expr_1
FROM
foo
),
table_0 AS (
SELECT
_expr_1 +1AS c,
_expr_0
FROM
table_1
WHERE
true
)
SELECT
c,
AVG(_expr_0) AS n
FROM
table_0
WHERE
true
GROUP BY
c
Expected SQL output
WITH table_1 AS (
SELECT
a +1AS _expr_1
FROM
foo
),
table_0 AS (
SELECT
_expr_1 +1AS c,
_expr_0
FROM
table_1
WHERE
true
)
SELECT
c,
AVG(_expr_0) AS n
FROM
table_0
WHERE
true
GROUP BY
c
MVCE confirmation
Minimal example
New issue
Anything else?
No response
The text was updated successfully, but these errors were encountered:
What happened?
The following prql fails on 0.11.4 but works on 0.10.1.
PRQL input
SQL output
Expected SQL output
MVCE confirmation
Anything else?
No response
The text was updated successfully, but these errors were encountered: