Why doesn't check work?

Question

SQL

There is a column

. I create such a restriction on its filling

(checking for filling in the status of a bank cell with the words only "closed / open"),
but as we can see, it does not work during test filling

when trying to delete, a famous error is created.

What is the problem? Maybe the condition is not created at all? The syntax is correct!

Answer 1

The CHECK clause is parsed but ignored by all storage engines.