Server Crash on Execute of SQL Statement

Either of the following Windowing function constructs do not get an error but crash the server:

– Case 1
SUM( CASE WHEN
SUM( CASE WHEN

{test} THEN 1 ELSE 0 END ) OVER ( PARTITION BY {field} ) > 0
AND
SUM( CASE WHEN {test}

THEN 1 ELSE 0 END ) OVER ( PARTITION BY

{field} ) > 0
THEN 1
ELSE 0
END
)
– Case 2
SUM( IF( SUM( IF( {test}, 1 , 0 ) ) OVER ( PARTITION BY {field}

) > 0 AND SUM( IF(

{test}

, 1 , 0 ) ) OVER ( PARTITION BY

{field}

) > 0,1, 0 ) )