CODEWITHSUNDEEP
mysqldatabasemariadb
Peloponeso31
Peloponeso31

Reputation: 25

Why CHECK statement on MariaDB works on windows and not in linux?

So, i was on database class yesterday on the college and the theacher tell us to make a simple excercise to show us how foreign keys work, so, i carry a laptop with antergos to the college, previuously i have installed MariaDB, but my fellows had MySQL on windows, we made the tables with a CHECK constraint to verify age >= 18, but it didn't work for everyone, i came across in MySQL manual that:

CHECK is parsed but ignored.

BUT in my windows machine CHECK works with MariaDB and i don't know why.

MariaDB prompt my Linux machine

MariaDB prompt on my windows machine

Version in windows: 10.3.7-MariaDB Version in linux: 10.1.36-MariaDB

Upvotes: 2

Views: 105

Answers (1)

nos
nos

Reputation: 229184

CHECK constraints was added to MariaDB version 10.2.1

See the docs for more info

Upvotes: 4

Related Questions