1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
# name: test/sql/subquery/scalar/nested_subquery_window.test
# description: Fuzzer issue - nested subquery inside a window function
# group: [scalar]
query I
SELECT (SELECT max((SELECT subq_0.c0 AS c1))) FROM (SELECT NULL AS c0) AS subq_0;
----
NULL
query I
SELECT (SELECT max(42) OVER (PARTITION BY (SELECT subq_0.c0 AS c1)) AS c6) FROM (SELECT NULL AS c0) AS subq_0;
----
42
query I
SELECT (SELECT max((SELECT subq_0.c0 AS c1)) OVER () AS c6) FROM (SELECT NULL AS c0) AS subq_0;
----
NULL
|
