Checks¶
sql-lint comes with its own suite of checks. Aside from its own checks, it
also returns any errors from the SQL server you have connected to. Generally
you’ll find that the errors from sql-lint are more informative than those from
the server. That said, you will still want errors from the server as it covers
more cases and will catch things that sql-lint does not.
Reference¶
unmatched-parentheses¶
Shown when a query has an unbalanced amount of parentheses.
Example output¶
test/test-files//test.sql:16 [sql-lint: unmatched-parentheses] Unmatched parentheses.
missing-where¶
Shown when a DELETE statement is missing a WHERE clause.
Example output¶
test/test-files/test.sql:20 [sql-lint: missing-where] DELETE statement missing WHERE clause.
invalid-drop-option¶
Shown when an invalid option is given to the DROP statement.
Example output¶
test/test-files/test.sql:22 [sql-lint: invalid-drop-option] Option 'thing' is not a valid option, must be one of '["database","event","function","index","logfile","procedure","schema","server","table","view","tablespace","trigger"]'.
invalid-create-option¶
Shown when an invalid option is given to the CREATE statement.
Example output¶
:24 [sql-lint: invalid-create-option] Option 'test' is not a valid option, must be one of '["algorithm","database","definer","event","function","index","or","procedure","server","table","tablespace","temporary","trigger","user","unique","view"]'.
invalid-truncate-option¶
Shown when an invalid option is given to the TRUNCATE statement.
Example output¶
test/test-files/test.sql:26 [sql-lint: invalid-truncate-option] Option 'something' is not a valid option, must be one of '["table"]'.
invalid-alter-option¶
Shown when an invalid option is given to the ALTER statement.
Example output¶
test/test-files/test.sql:28 [sql-lint: invalid-alter-option] Option 'mlady' is not a valid option, must be one of '["column","online","offline","ignore","database","event","function","procedure","server","table","tablespace","view"]'.
odd-code-point¶
Shown when there are unsupported/unusual* code points in your code.
*This check came about whilst working Microsoft Excel. Microsoft likes to add a lot of zany characters which can subtly break your data without you realising.
Example output¶
test/test-files//test.sql:30 [sql-lint: odd-code-point] Unexpected code point.
invalid-limit-quantifier¶
Shown when you specify something other than a number to the LIMIT statement.
Example output¶
test/test-files//test.sql:32 [sql-lint: invalid-limit-quantifier] Argument 'test' is not a valid quantifier for LIMIT clause.