Cherry-pick AOCS related work that changes catalog version

[reshke]

While working on issue https://github.com/apache/cloudberry/issues/989 I realized we need to cherry-pick a couple of valuable contributions from GP7 to resolve diff easily. Also, there is a benefit of cherry-picking catalog-changing contributions before CBDB 2.0 release.

What does this PR do?

Type of Change

• [ ] Bug fix (non-breaking change)
• [ ] New feature (non-breaking change)
• [ ] Breaking change (fix or feature with breaking changes)
• [ ] Documentation update

Breaking Changes

Test Plan

• [ ] Unit tests added/updated
• [ ] Integration tests added/updated
• [ ] Passed make installcheck
• [ ] Passed make -C src/test installcheck-cbdb-parallel

Impact

Performance:

User-facing changes:

Dependencies:

Checklist

• [ ] Followed contribution guide
• [ ] Added/updated documentation
• [ ] Reviewed code for security implications
• [ ] Requested review from cloudberry committers

Additional Context

CI Skip Instructions

---

[yjhjstz]

cool, need a rebase.

[tuhaihe]

Hi @reshke would you like to include this PR in the coming 2.0.0? If so, welcome to add this PR to the GitHub project.

[reshke]

big thanks to @gfphoenix78 for taking care of it.... LGTM

[reshke]

Hi @reshke would you like to include this PR in the coming 2.0.0? If so, welcome to add this PR to the GitHub project.

HI! lets approve it and merge

[reshke]

Did a rebase on fresh master