alibaba / druid

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

config:druid.stat.mergeSql=true;ERROR:"Refresh MATERIALIZED VIEW CONCURRENTLY vw_m_aaa_user_details WITH DATA #2830

Open qingyilei opened 6 years ago

qingyilei commented 6 years ago

ERROR com.alibaba.druid.filter.stat.StatFilter - merge sql error, dbType postgresql, druid-1.1.11, sql : Refresh MATERIALIZED VIEW CONCURRENTLY vw_m_aaa_user_details WITH DATA com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'Refresh MATERIALIZED VIEW CONC', expect IDENTIFIER, actual IDENTIFIER pos 7, line 1, column 1, token IDENTIFIER Refresh 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.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:94) at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:77) at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:50)

DemoCap commented 3 years ago

Caused by: java.sql.SQLException: sql injection violation, dbType postgresql, , druid-version 1.2.5, syntax error: syntax error, error in :'VIEW CONCURRENTLY ? , pos 40, line 1, column 40, token ? : REFRESH MATERIALIZED VIEW CONCURRENTLY ?