The following list names the MySQL-specific validation types and gives examples of specific violations:
-
Integrity Violation
An object name longer than the maximum permitted
A foreign key defined for an engine type that does not 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