Subject: | MySQL parser doesn't handle "field comments" properly |
The following SQL which is legal in MySQL, generates an error:
CREATE TABLE test (
id INT,
-- comment
PRIMARY KEY (id)
);
ERROR (line 1): Invalid statement: Was expecting comment, or use, or
set, or drop, or create
Error: translate: Error with parser 'SQL::Translator::Parser::MySQL': no results at /usr/local/bin/sqlt-graph line 160.
Not sure why this isn't recognized as a 'field comment'