PXC node eviction due to CHECK CONSTRAINT

PXC node disconnected/evicted from the cluster due to CHECK CONSTRAINT with the following scenarios :

1) ERROR 3819 : New CHECK CONSTRAINT is created and it has a rule violation upon creation.
2) ERROR 3822 : New CHECK CONSTRAINT with Duplicate check constraint name.
3) No ERROR : After a successful DROP of CHECK CONSTRAINT

How to reproduce :

1) Create the cluster :

2) Login to any node :

Create the table :

Scenario 1)

ERROR 3819 : New CHECK CONSTRAINT is created and it has a rule violation upon creation.

Insert a record that will violate the rule and then create the check constraint.

Error log :

Suggested fix :

It should only return error but not make the node inconsistent and get disconnected/evicted from the cluster.

Workaround :

Ensure that there is no new check constraint rule violation before creating the check constraint.

Scenario 2)

ERROR 3822 : New CHECK CONSTRAINT with Duplicate check constraint name.

Execute same ADD CHECK CONSTRAINT twice :

Node logfile :

Suggested fix :

It should only return error but not make the node inconsistent and get disconnected/evicted from the cluster.

Workaround :

Ensure that there is no same CHECK CONSTRAINT name existing before creating a new one.

Scenario 3)

3) No ERROR : After a successful DROP of CHECK CONSTRAINT

CREATE then DROP the CHECK CONSTRAINT :

Node Logfile :

Suggested fix :

A successful DROP of CHECK CONSTRAINT should not make the node inconsistent and get disconnected/evicted from the cluster.

Workaround :

None