:) create stream t1(i int, v int);
:) explain syntax select count() over (partition by i) as x, lag(x) from changelog(t1, i);
EXPLAIN SYNTAX
SELECT
count() OVER (PARTITION BY i) AS x, lag(x)
FROM
changelog(t1, i)
Query id: d7445ff9-15a5-4986-b8e3-938c32bf3b13
┌─explain───────────────────────────────────────────┐
│ SELECT │
│ count() OVER (PARTITION BY i) AS x AS x, lag(x) │
│ FROM │
│ changelog(t1, i) │
│ GROUP BY │
│ i │
└───────────────────────────────────────────────────┘
6 rows in set. Elapsed: 0.007 sec.
unexpected result: count() OVER (PARTITION BY i) AS x AS x
Describe what's wrong
unexpected result:
count() OVER (PARTITION BY i) AS x AS x
How to reproduce
Error message and/or stacktrace
Additional context