Run optimizer tests with system versioned tables

Run optimizer tests on tables with system versioning, at least InnoDB and MyISAM, if there is time, then also Aria and RocksDB:

• "traditional" optimizer tests for crashes;
• transformation tests with most common transformers;
• result comparison between versioned and not versioned tables on the same branch/revision;
• CTE tests (see MDEV-14820, probably need to wait till it's fixed);
• Window functions;
• anything else you can think of in context of optimizer;

Nice to do:

• poor man's rough optimizer performance comparison for versioned vs non-versioned tables, see for example lib/GenTest/Validator/ExecutionTimeComparator.pm