Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

PostgreSQL 刷新物化视图语句不允许。 #4962

Closed
shenQQQ opened this issue Oct 17, 2022 · 1 comment
Closed

PostgreSQL 刷新物化视图语句不允许。 #4962

shenQQQ opened this issue Oct 17, 2022 · 1 comment
Milestone
1.2.14

Comments

@shenQQQ
Copy link
Contributor

shenQQQ commented Oct 17, 2022

之前提了一个issue，但是问题没有被解决https://github.com/alibaba/druid/issues/4931。
之前的问题是刷新物化视图的语句可以被解析识别，但是刷新物化视图语句不被允许。在发布新版本之后，即使更新到了1.2.13版本也会出现执行不被允许的情况。
Caused by: java.sql.SQLException: sql injection violation, dbType postgresql, druid-version 1.2.4, class com.alibaba.druid.sql.ast.statement.SQLRefreshMaterializedViewStatement not allow : refresh materialized view <table_name>

能不能在com.alibaba.druid.wall.WallConfig里增加一个是否允许刷新物化视图的属性，这样使用起来也方便一些。

拜托了！
@wenshao wenshao added this to the 1.2.14 milestone Oct 22, 2022
@wenshao
Copy link
Member

wenshao commented Oct 23, 2022

https://github.com/alibaba/druid/releases/tag/1.2.14
问题已修复，请用新版本

@wenshao wenshao closed this as completed Oct 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
1.2.14
Development

No branches or pull requests
2 participants
@wenshao @shenQQQ