Bug #3465 Check constraint

Submitted: 14 Apr 2004 1:07 Modified: 23 Jan 2019 16:26
Reporter: Mickael Besson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S1 (Critical)
Version:5.0.0 OS:Windows (Windows NT4)
Assigned to: 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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.