#11 CREATE TABLE doesn't allow to have column names in quotes

[Anonymous]

CREATE TABLE FOO ("My Column" BIGINT)

gives me something like

Caused by: net.sf.jsqlparser.JSQLParserException
at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:40)
at net.pcal.sqlsheet.XlsStatement.executeQuery(XlsStatement.java:103)
... 24 more
Caused by: net.sf.jsqlparser.parser.TokenMgrError: Lexical error at line 3, column 1. Encountered: "\\" (92), after : ""
at net.sf.jsqlparser.parser.CCJSqlParserTokenManager.getNextToken(CCJSqlParserTokenManager.java:1292)
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:4354)
at net.sf.jsqlparser.parser.CCJSqlParser.CreateTable(CCJSqlParser.java:2215)
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:120)
at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:38)

[David Rosenstrauch]

Ugh. This is a big problem. It prevents the grammar from parsing Mysql dumps.

I get this error:

net.sf.jsqlparser.parser.ParseException: Encountered " <S_QUOTED_IDENTIFIER> "`bar` "" at line 1, column 21.
Was expecting:
<S_IDENTIFIER> ...

... when parsing this statement:

CREATE TABLE `FOO` (`bar` INT DEFAULT NULL)

[David Rosenstrauch]

Don't know if this is useful or not, but I've produced a patch containing some of the changes I had to make locally to get the parser to parser MySQL dumps.

http://www.darose.net/JSqlParserMySQLDumpChanges.patch

It patches v0.7.0.