alibaba / druid

阿里云计算平台DataWorks(https://help.aliyun.com/document_detail/137663.html) 团队出品,为监控而生的数据库连接池
https://github.com/alibaba/druid/wiki
Apache License 2.0
27.91k stars 8.57k forks source link

DB2语法解析报错 #2769

Open IRoye opened 6 years ago

IRoye commented 6 years ago

环境: druid版本: 1.1.10 DB: DB2 SQL: select * from final table ( update audit.user2 set USERPASS='2' where id in (1,21) ) 报错信息: Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'inal table ( update audit.user2 set', expect TABLE, actual TABLE pos 25, line 1, column 20, token TABLE at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:433) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:72) at com.alibaba.druid.sql.SQLUtils.parseStatements(SQLUtils.java:464) at cn.newdt.audit.MyTest.main(MyTest.java:117)

IRoye commented 6 years ago

@wenshao

wenshao commented 6 years ago

这个一个特别的语法,你们用在什么场景?

IRoye commented 6 years ago

@wenshao 谢谢温老师:). 这个是抓取的客户DB上的一条SQL,我们拿来做的解析,具体场景目前还不清楚。