Cherry-pick orca and gpopt commits till 16Jun2022

[leborchuk]

Important notes:

• The file select_parallel_optimizer.out was deleted in the "Initial Cloudberry code dump 2" commit. The reason - this is because orca planner not support parallel feature

• I cherry-picked in time-based fashion, from older to newer, and skipped "fix incorrect RTE's rellockmode in the process of translating DX" because I didn't know if the issue still existed or not.

• Some fixes were already merged https://github.com/cloudberrydb/cloudberryDB/pull/603.

---

Change logs

2nd iteration: gporca Apr 15, 2022 Fix subquery all subquery context (#13377) https://github.com/open-gpdb/gpdb/commit/f5e3a589a06d90c3ecc70840f7781633fe40d9af - conflicts with https://github.com/cloudberrydb/cloudberrydb/commit/22fc48b08eaf48d93e90b9c21462d1604cf4f621 Apr 28, 2022 Remove overload raise function with severity_level (#13376) https://github.com/open-gpdb/gpdb/commit/94db8a1aa833f5d9b0ac91133f2cd2cbf0e60aeb May 10 [ORCA] Enable more HashAggregate alternative plans (#13421) https://github.com/open-gpdb/gpdb/commit/0276e5ce0ddaaf94c4b7e5e87b4db8e2f4242f0f Jun 1, 2022 Fix missing Redistribute on top of Split Update with Orca https://github.com/open-gpdb/gpdb/commit/f47b262779de1d940e47e109be0aa483f4494957 Jun 3, 2022 Materialize aggregations in NL Join inner child https://github.com/open-gpdb/gpdb/commit/6420b60dd400b6dfc6c9104204b86c9099597fb6

gpopt Mar 23, 2022 Fix testexpr translation of outer expr (#13296) https://github.com/open-gpdb/gpdb/commit/fd9e35bbeab3c7e0691be8336abda5d89b8f9671 Mar 24, 2022 Fix paramcollid for param in ORCA translator (#13302) https://github.com/open-gpdb/gpdb/commit/d03632b6c0a389944ca50ddc788b1d5fbc2a4308 Apr 27, 2022 Avoid opening table in CondUpgradeRelLock() when possible https://github.com/open-gpdb/gpdb/commit/73e50fbaf1578be81522f2d1eaf70f5905554d5a - conflicts with https://github.com/cloudberrydb/cloudberrydb/commit/16b0b9d346557021abe50ef509bed8ea60d3fd5b May 6, 2022 Clean up logic in CdbTryOpenTable. https://github.com/open-gpdb/gpdb/commit/43a5e58dfa471471624003e5e1d2b15f0dd2d56f - dangerous, need more thorougly review Jun 16, 2022 [ORCA] Fix memory leaks in translator (#13656) https://github.com/open-gpdb/gpdb/commit/6bbef9ec1228e4212e226a13804a2c5503a93403

Why are the changes needed?

Describe why the changes are necessary.

Does this PR introduce any user-facing change?

If yes, please clarify the previous behavior and the change this PR proposes.

How was this patch tested?

Please detail how the changes were tested, including manual tests and any relevant unit or integration tests.

Contributor's Checklist

Here are some reminders and checklists before/when submitting your pull request, please check them:

• [ ] Make sure your Pull Request has a clear title and commit message. You can take git-commit template as a reference.
• [ ] Sign the Contributor License Agreement as prompted for your first-time contribution(One-time setup).
• [ ] Learn the coding contribution guide, including our code conventions, workflow and more.
• [ ] List your communication in the GitHub Issues or Discussions (if has or needed).
• [ ] Document changes.
• [ ] Add tests for the change
• [ ] Pass make installcheck
• [ ] Pass make -C src/test installcheck-cbdb-parallel
• [ ] Feel free to request cloudberrydb/dev team for review and approval when your PR is ready🥳

[CLAassistant]

Thank you for your submission! We really appreciate it. Like many open source projects, we ask that you all sign our Contributor License Agreement before we can accept your contribution.
1 out of 7 committers have signed the CLA.

:white_check_mark: leborchuk
:x: dgkimura
:x: khannaekta
:x: sambitesh
:x: huansong
:x: orhankislal
:x: kainwen
_{You have signed the CLA already but the status is still pending? Let us recheck it.}

[leborchuk]

I will fix tests, see failed pipelines

[yjhjstz]

select_parallel_optimizer.out was deleted

this is because orca planner not support parallel feature.

[leborchuk]

Rebased to resolve merge conflicts. Still need to fix tests and some review issues. I will take some time, because some test issues do not reproduce in my local development environment. I will let you know when I'm finished.