Skip to content

Update array operators for Clusters::Agent

Krasimir Angelov requested to merge 438124-update-array-operator-cluster-agent into master

What does this MR do and why?

This is another change extracted from changes are extracted from Draft: Conver integer ID columns to bigint (!145752).

  • {?} works casts the array to the value of the left side, and works both when it's bigint[] or integer[].
  • ANY works the same way as @>, but does not need explicit casting.

This is needed in preparation for Use bigint for new installations (#438124), which is a prerequisite for Cells global identifiers.

See #438124 (comment 1833136499) for more context.

MR acceptance checklist

Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Screenshots or screen recordings

Screenshots are required for UI changes, and strongly recommended for all other merge requests.

Before After

How to set up and validate locally

Numbered steps to set up and validate the change are strongly suggested.

Related to #438124

Merge request reports