A validation was added to prevent the aggregates, such as string_agg, xmlagg, jsonarray_agg, etc. from working with an over order by clause - because most of them are destructive when the value is created and don't allow for rolling processing.