PR #98171 - sql: introduce array_cat_agg aggregate builtin

[cockroach-teamcity]

Exalate commented:

Related PR: cockroachdb/cockroach#98171
Commit: cockroachdb/cockroach@02fb46e
Fixes: cockroachdb/cockroach#97502

---

Release note (sql change): New aggregate builtin function
array_cat_agg is introduced. It behaves similar to how
array_agg(unnest(array_column)) would - namely, it takes arrays as its
input, unnests them into the array elements which are then aggregated
into a single result array (i.e. it's similar to concatenating all input
arrays into a single one).

Jira Issue: DOC-7178

[exalate-issue-sync]

Mike Lewis (mikeCRL) commented:
Routed to SQL Sessions based on cockroach package (builtins). For now, Product Change issues for other packages' changes will still need to be routed manually by managers. https://cockroachlabs.atlassian.net/wiki/spaces/ED/pages/2934931562/Routing+issues+to+Product+Areas Richard Loveland Ian Evans