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.

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

[ bug ]开启脱敏校验,子查询无法进行[group by] #885

Closed
zhang921106163 opened this issue Sep 21, 2020 · 2 comments
Closed

[ bug ]开启脱敏校验,子查询无法进行[group by] #885

zhang921106163 opened this issue Sep 21, 2020 · 2 comments
Labels
wontfix This will not be worked on

Comments

@zhang921106163
Copy link

zhang921106163 commented Sep 21, 2020

1、在线体验--->系统管理--->QUERY_CHECK【ON】--->保存配置
2、sql查询--->在线查询--->MySQL--->weibo--->keyword_comment
3、语句如下:
select
a.comment_username,
count(a.comment_content)
from
(
select
comment_username,
comment_content
from
keyword_comment
)a
group by a.comment_username limit 10;

4、报错信息(数据脱敏异常:'errlevel'); 有些sql会出现字段不存在错误, 看样子像是无法识别子查询产生的临时表
5、其他测试: 设置QUERY_CHECK【OFF】,一些复杂sql也会出现字段不存在错误, 事实上在navicat可以正确执行

@hhyo
Copy link
Owner

hhyo commented Sep 21, 2020

#145

@stale
Copy link

stale bot commented Oct 10, 2020

你已经很久没有回复这个issue了,如果没有进一步的信息的话, 会作为不活跃issue关闭, 感谢你对本项目的贡献。
This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

@stale stale bot added the wontfix This will not be worked on label Oct 10, 2020
@stale stale bot closed this as completed Oct 13, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

2 participants