总共1个语句正依次执行...
[执行语句1]:
SELECT
sum(case when pds.severity_level =1 then 1 else 0 end ) as "defectWarning1",
sum(case when pds.severity_level =2 then 1 else 0 end ) as "defectWarning2",
sum(case when pds.severity_level =3 then 1 else 0 end ) as "defectWarning3",
sum(case when pds.severity_level =4 then 1 else 0 end ) as "defectWarning4",
sum(case when pds.severity_level =5 then 1 else 0 end ) as "defectWarning5",
SUM(pds.all_lines) as allLinesNums,
COUNT(DISTINCT pds.file_path) AS fileNums,
COUNT(pds.project_group_id) as groupNums,
COUNT(pds.sub_project_id) as subNums
FROM problem_distribution_statistics pds LEFT JOIN members m ON m.id = pds.receiver_id GROUP BY pds.receiver_id
执行失败(语句1)
第11 行附近出现错误[-2207]:
无法解析的成员访问表达式[PDS.SUB_PROJECT_ID]
1条语句执行失败
可能是大小写敏感导致的问题,查看下表结构是否表名、字段名全为小写。
大小写敏感情况下,select a1 from a;表、字段需要引起来select "a1" from "a";
否则将转化为 select A1 from A;导致报错无效的列A1或无效的表A