SQLSmith - errors related to the worker_partial_agg_sfunc function

[m3hm3t]

We've encountered errors related to the worker_partial_agg_sfunc function, which may indicate untested or buggy code paths in the distributed query execution flow. The following two errors were observed:

• Error: ERROR: worker_partial_agg_sfunc could not confirm type correctness

Occurrences: 1,153
Description: This suggests that the function encounters type mismatches during partial aggregation on worker nodes. It could be related to scenarios where input types are inconsistent with expected types in distributed aggregate operations.

• Error: ERROR: worker_partial_agg_sfunc received invalid null input for second argument

Occurrences: 548
Description: This appears to be a case where null inputs are improperly handled, leading to failure during execution.

These errors likely stem from:

• Insufficient validation of input arguments (e.g., type correctness or null handling) before invoking worker_partial_agg_sfunc.

• Edge cases in distributed aggregation workflows that are not covered by existing test cases, such as:
  Complex user-defined aggregates.
  Aggregates on non-standard or null values.