注册

请问下为什么报错:无法解析的成员访问表达式

🔞脏脏包 2023/06/19 1903 1

总共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条语句执行失败

回答 0
暂无回答
扫一扫
联系客服