MDEV-30653 : With wsrep_mode=REPLICATE_ARIA only part of mixed-engine…

[janlindstrom]

… transactions is replicated

• [x] The Jira issue number for this PR is: MDEV-30653

Description

Replication of non-transactional engines is experimental and uses TOI. This naturally means that if there is open transaction with transactional engine it's changes will be rolled back.

Fixed by adding error message if non-transactional engine is part of multi-engine transaction with warning.

Release Notes

Replication of non-transactional engines like MyISAM or Aria is experimental. and transaction should not contain DML to both transactional and non-transactional engines. Unfortunately, this is not possible to enforce in all cases e.g. in procedures and triggers. In this change simple cases are enforced.

How can this PR be tested?

TODO: modify the automated test suite to verify that the PR causes MariaDB to behave as intended. Consult the documentation on "Writing good test cases".

If the changes are not amenable to automated testing, please explain why not and carefully describe how to test manually.

Basing the PR against the correct MariaDB version

• [ ] This is a new feature or a refactoring, and the PR is based against the latest MariaDB development branch.
• [ x] This is a bug fix, and the PR is based against the earliest maintained branch in which the bug can be reproduced.

PR quality check

• [ x] I checked the CODING_STANDARDS.md file and my PR conforms to this where appropriate.
• [x ] For any trivial modifications to the PR, I am ok with the reviewer making the changes themselves.