datart icon indicating copy to clipboard operation
datart copied to clipboard

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

Open cnmrzhou opened this issue 1 year ago • 0 comments

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)

  • OS: [e.g. Windows 10]
  • Source Database: [e.g. MySQL 8.0.26]
  • Browser: [e.g. chrome 94, safari 15]

Additional context Add any other context about the problem here.

cnmrzhou avatar May 07 '24 06:05 cnmrzhou