16.6.10.2. MySQL-Specific Validation

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

Copyright © 2010-2020 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout