running-elephant / datart

Datart is a next generation Data Visualization Open Platform
https://running-elephant.github.io/datart-docs/
Apache License 2.0
1.94k stars 583 forks source link

clickhouse数据源组织owner 用户,使用行权限出现Missing columns: #2322

Open cnmrzhou opened 5 months ago

cnmrzhou commented 5 months ago

Datart Version 1.0.0-rc3

Describe the bug 对于owner 角色的用户使用权限变量做行权限出现异常 image Code: 47, e.displayText() = DB::Exception: Missing columns: '$zone_new$' while processing query: 但用非此组织用户,可以正常使用,但提示sql 解析失败,但可以正常执行

To Reproduce Steps to reproduce the behavior:

  1. 添加数据视图
  2. sql 视图
  3. clickhouse 数据集
  4. 即可复现此bug

Expected behavior 新建一个非Owner 用户,不出现问题. 非clickhouse 数据集,也不出现问题

Screenshots If applicable, add screenshots to help explain your problem.

Environmental details: (optional, depending on where the bug occurs)

Additional context Add any other context about the problem here.