WL#9776: Add/Extend mtr tests for replication with generated columns and X plugin

Affects: Server-8.0   —   Status: Complete   —   Priority: Medium

The idea of this wl is to add/extend mtr tests for replication regression suite,
some of the following areas planned for this WL are:

1) Generated columns
2) X-Plugin

FR1: Replication shall not be affected when transactions involve stored columns.

FR2: Replication shall not be affected when transactions involve virtual columns.

FR3: Replication shall not be affected when the transactions are performed through 
X-plugin setup.

FR4: Replication shall not be affected when XA transactions involve stored 
columns.

FR5: Replication shall not be affected when XA transactions involve virtual 
columns.

FR6: Replication shall not be affected when XA transactions are performed through 
X-plugin setup.
The aim of this worklog is to test the following scenarios.

1)Create the table with stored columns and do the dml's and verify if data is 
correctly replicated to the slave server.
   Test the above scenario with the following variations.
   i)   stored column genarated on primary key.
   ii)  stored column as primary key.
   iii) stored column as unique.
   iv)  stored column as foreign key.
   v)   Index on stored column.
 
2)Create the table with stored columns and do the XA transactions on it and verify 
if data is correctly replicated to the slave server.

3)Create the table with virtual columns and do the dml's and verify if data is 
correctly replicated to the slave server.
   Test the above scenario with the following variations.
   i)   stored column genarated on primary key.
   ii)  stored column as unique.
   iii) Index on virtual column.

4)Create the table with virtual columns and do the XA transactions on it and 
verify if data is correctly replicated to the slave server.

5)Create table on master and perform some dml operations on it through x-plugin 
and verify if the replication works fine.

6)Create table on master and perform some XA transactions on it through x-plugin 
and verify if the replication works fine.