Open
Description
版本使用:1.2.24
测试方法
class CreateTableUtilTest {
public static void main(String[] args) {
try {
String sql = "CREATE TABLE t1 (`clustered` tinyint(1) DEFAULT NULL COMMENT 'abc');";
List<SQLStatement> stmtList = SQLUtils.parseStatements(sql, DbType.mysql);
} catch (Exception e) {
e.printStackTrace();
}
}
}
异常信息
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'(`clustered` tinyint(1) DEFAULT NULL COMMEN', expect ), actual null, pos 36, line 1, column 30, token IDENTIFIER tinyint
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:881)
at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:889)
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlCreateTableParser.parseCreateTable(MySqlCreateTableParser.java:496)
at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseCreateTable(MySqlStatementParser.java:114)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseCreate(SQLStatementParser.java:3957)
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:281)
at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:656)
at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:677)
如果将 clustered 改成 clustered1,则可以执行成功。
Metadata
Metadata
Assignees
Labels
No labels