fastsql版本: 最新的520 sql语句以及Exception:
case 1 : sql_6 = "CREATE INDEX idx_t_uid on stu_score (uid) COMMENT '' ALGORITHM DEFAULT LOCK DEFAULT "; Exception in thread "main" com.alibaba.fastsql.sql.parser.ParserException: syntax error, error in :'ITHM DEFAULT LOCK DEFAULT, pos 134, line 1, column 136, token IDENTIFIER null at com.alibaba.fastsql.sql.parser.SQLParser.printError(SQLParser.java:363) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:520) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:92) at com.test.HelloWorld.main(HelloWorld.java:266)
case 2: sql = "alter table test COLLATE utf8mb4_unicode_ci" ; Exception in thread "main" com.alibaba.fastsql.sql.parser.ParserException: syntax error, error in :'LATE utf8mb4_unicode_ci', expect =, actual null, pos 44, line 1, column 27, token IDENTIFIER utf8mb4_unicode_ci at com.alibaba.fastsql.sql.parser.SQLParser.printError(SQLParser.java:363) at com.alibaba.fastsql.sql.parser.SQLParser.accept(SQLParser.java:371) at com.alibaba.fastsql.sql.dialect.mysql.parser.MySqlStatementParser.parseAlterTable(MySqlStatementParser.java:4818) at com.alibaba.fastsql.sql.dialect.mysql.parser.MySqlStatementParser.parseAlter(MySqlStatementParser.java:3544) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:264) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:92) at com.test.HelloWorld.main(HelloWorld.java:266)
case 3: sql_8 = "alter table task AUTO_INCREMENT = 20000000 COMMENT ='自增起始值'" ; Exception in thread "main" com.alibaba.fastsql.sql.parser.ParserException: syntax error, error in :'0000 COMMENT ='自增起始值'', expect ON, actual =, pos 52, line 1, column 52, token = at com.alibaba.fastsql.sql.parser.SQLParser.printError(SQLParser.java:363) at com.alibaba.fastsql.sql.parser.SQLParser.accept(SQLParser.java:371) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseComment(SQLStatementParser.java:3488) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:354) at com.alibaba.fastsql.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:92) at com.test.HelloWorld.main(HelloWorld.java:266)
原提问者GitHub用户hyy613
这些是有一些问题,已反馈做修改,建议先绕过
alter table test COLLATE = utf8mb4_unicode_ci alter table task AUTO_INCREMENT = 20000000 , COMMENT ='自增起始值'
原回答者GitHub用户agapple
版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。