The types of MySQL-specific validation and examples that violate validation are listed in the following.
Integrity Violation
An object name longer than the maximum allowed
A foreign key defined for an engine type that doesn't support foreign keys (not yet implemented)
A view or routine that references a nonexistent table (not yet implemented)
A default value that does not match a column's data type
An invalid partitioning scheme
Syntax Violation
A routine, trigger, or view with incorrect SQL syntax
A reserved keyword used as an identifier
Use of an invalid character