Bug #28941 the "Check" constrain is no use
Submitted: 7 Jun 2007 9:43 Modified: 6 Nov 2009 16:52
Reporter: ming lu Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:5.1 OS:Any
Assigned to: CPU Architecture:Any

[7 Jun 2007 9:43] ming lu
The MySQL server is not support the "check" constrain now, the Key words "check" can be used, but it has no effect.

How to repeat:
create a table with "check" constrain and insert some data that disobey the rules, it can be inserted successfully.

Suggested fix:
I think the "check" constrain is a very useful character, Why don't add the support for the "check" constrain in the MySQL Server's new version.
[9 Jun 2007 1:42] MySQL Verification Team
Thank you for the bug feature request.
[6 Nov 2009 16:53] Valeriy Kravchuk
This is actually a duplicate of Bug #3464.