Bug #3465 Check constraint

• Submitted: 14 Apr 2004 1:07
• Modified: 23 Jan 2019 16:26
• Reporter: Mickael Besson
• Status: Closed
• Category: MySQL Server: Command-line Clients
• Severity: S1 (Critical)
• Version: 5.0.0
• OS: Windows (Windows NT4)
• CPU Architecture: Any

[14 Apr 2004 1:07] Mickael Besson

Description:

Hi,

All check contraint I tested aren't taken into account at the creation of tables.

Example :

- with IN(...,...,...)
- with >,<...
- other cases

How to repeat:

[15 Apr 2004 18:12] MySQL Verification Team

This is a current limitation:

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

New Features Planned for 5.1

- Column-level constraints.

[23 Jan 2019 16:26] Paul DuBois

Fixed in 8.0.16.

Previously, MySQL permitted a limited form of CHECK constraint
syntax, but parsed and ignored it. MySQL now implements the core
features of table and column CHECK constraints, for all storage
engines. Constraints are defined using CREATE TABLE and ALTER TABLE
statements.