groupArray & aggregate_functions_null_for_empty = DB::Exception

[den-crane]

SELECT groupArray(number)
FROM numbers(10)
SETTINGS aggregate_functions_null_for_empty = 1

Query id: ab4c14d4-4d32-4baa-99f5-d2dd91dde25c


0 rows in set. Elapsed: 0.023 sec.

Received exception from server (version 22.7.1):
Code: 43. DB::Exception: Received from localhost:9000. 
DB::Exception: Nested type Array(UInt64) cannot be inside Nullable type. (ILLEGAL_TYPE_OF_ARGUMENT)

[Alex-Cheng]

The aggregate_functions_null_for_empty brainlessly add -OrNull suffix to every aggregate functions, including groupArray, but groupArray cannot be with -OrNull because the result type Array cannot be Nullable(Array).

[den-crane]

solved #48593

[den-crane]

reverted #49971