Bug #59731 Feature request for new utility to perform automated SQL validation
Submitted: 25 Jan 2011 23:34 Modified: 26 Jan 2011 4:20
Reporter: Matthew Montgomery Email Updates:
Status: Verified Impact on me:
Category:MySQL Utilities Severity:S4 (Feature request)
Version: OS:Any
Assigned to: CPU Architecture:Any

[25 Jan 2011 23:34] Matthew Montgomery
Requested utility added to workbench suite for SQL validation.

0) Be open-sourced so others could easily extend/contribute checks back in the code.
1) Syntax check SQL
2) Validate table names
3) Optionally verify file names for load data local infile statements
4) Issue warnings on multi-row DML statements without where clauses
5) Issue warnings for problematic DDL (like columns that allow NULL values without specifying "NULL DEFAULT NULL" as part of the definition, VARCHAR(255) potentially indicating it should be a TINYTEXT column instead, INT versus INT UNSIGNED AUTO_INCREMENT columns...)
6) callable from the command line for automated testing without GUI interaction

How to repeat:

Suggested fix: