In the following example, the condition in the RESET WHEN clause contains SELECT as a nested subquery. This is not allowed and results in an error.
SELECT SUM(a1) OVER (ORDER BY 1 RESET WHEN 1 in (SELECT 1)) FROM t1; $ *** Failure 3706 Syntax error: SELECT clause not supported in RESET...WHEN clause.