Bug #48599 Check constraints missing implementation

• Submitted: 6 Nov 2009 16:17
• Modified: 9 Nov 2009 16:29
• Reporter: Karsten Wutzke
• Status: Duplicate
• Category: MySQL Server: General
• Severity: S2 (Serious)
• Version: Any
• OS: Any
• CPU Architecture: Any
• Tags: check constraint, DDL

[6 Nov 2009 16:17] Karsten Wutzke

Description:
Please implement check constraints. Currently, they only get by the parser because they are ignored.

We really need these basics before anything else. ENUM isn't a replacement for checks. Check constraints improve data quality when used correctly. Checks aren't just a fancy extension, they're vital.

This item has been reported before, but that was 3 years ago:

http://bugs.mysql.com/bug.php?id=25660

How to repeat:
-

Suggested fix:
Implement checks :-)

[6 Nov 2009 16:22] Karsten Wutzke

Change category to general, version is any.

[6 Nov 2009 16:38] Valeriy Kravchuk

I'd say this is a duplicate of many reports, the oldest one being bug #3464.

[7 Nov 2009 17:01] Karsten Wutzke

Well, then do something about it instead of flagging every subsequent bug report as duplicate...

[7 Nov 2009 20:27] Valeriy Kravchuk

I'll try...

[9 Nov 2009 16:29] Karsten Wutzke

Note I don't mean you specifically, but the MySQL people who decide what to implement.