Testing of MDEV-36055

Branch for testing:
https://github.com/mariaDB/server/commits/bb-12.2-mdev-36055-basic

Testing should include

• Correctness testing
• Performance testing

Correctness

Pick an RQG grammar that generates a lot of outer joins.
Run two servers

• One with optimizer_switch='reorder_outer_joins=OFF' - this will produce the correct results
• One with optimizer_switch='reorder_outer_joins=ON' - this will be checked.

Watch for the checked server to crash or produce wrong results.

We need to also check if the queries produce different query plans. That's because I expect that possible bugs with reorder_outer_joins=ON will work like this:
they produce an incorrect query plan, which causes a crash or wrong result. If the checked server ends up with the same query plan as the base server, we are unlikely to see any problems.

SO, please also compare EXPLAIN (or even EXPLAIN FORMAT=JSON) outputs between the servers. A good test run would show that the checked server and base server used different query plans.

Performance

(Please share results of your performance testing here)