DataEase 版本：V1；
部署方式：通过 panel 部署在 linux 服务器；
详细报错：点击仪表板的分享按钮，会报2个错，错误如下 –
-
接口：api/share/treeList，参数：{}，报错：
{
“success”: false,
“message”: “\n### Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT\n### The error may exist in io/dataease/ext/ExtPanelShareMapper.xml\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: select distinct s.panel_group_id as id, u.nick_name as creator, g.name, u.user_id, g.status from panel_share s left join panel_group g on g.id = s.panel_group_id left join sys_user u on u.username = IFNULL(s.granter,g.create_by) where ( s.target_id = ? and s.type = 0 ) or ( s.target_id = ? and s.type = 2 ) or ( s.target_id in ( ? ) and s.type = 1 ) order by s.create_time desc\n### Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT\n; uncategorized SQLException; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT; nested exception is java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT”,
“data”: null
} -
接口：api/share/shareOut，参数：无，报错：
{
“success”: false,
“message”: “\n### Error querying database. Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT\n### The error may exist in io/dataease/ext/ExtPanelShareMapper.xml\n### The error may involve defaultParameterMap\n### The error occurred while setting parameters\n### SQL: select distinct id, name, status from (select distinct s.panel_group_id as id, g.name, g.status, ( CASE s.type WHEN 0 THEN (select nick_name from sys_user where user_id = s.target_id) WHEN 1 THEN (select name from sys_role where role_id = s.target_id) WHEN 2 THEN (select name from sys_dept where dept_id = s.target_id) END ) as target_name from panel_share s left join panel_group g on g.id = s.panel_group_id where (s.granter is not null and s.granter = ?) or (s.granter is null and g.create_by = ?) order by s.create_time desc) query_temp where target_name is not null\n### Cause: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT\n; uncategorized SQLException; SQL state [HY000]; error code [3065]; Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT; nested exception is java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column ‘dataease.s.create_time’ which is not in SELECT list; this is incompatible with DISTINCT”,
“data”: null
}