导致crash的sql是
/* {`queryKey`:`d23bec6e-d18b-4e1d-a70a-6d4d7831f929`,`resourceidCode`:`6669be1b-59ac-496b-b59f-1bed708fb9d4`,`queryId`:`6669be1b-59ac-496b-b59f-1bed708fb9d4-0`} */
SELECT mocktable.userId AS `d_0`, mocktable.userName AS `d_1`, mocktable.business AS `d_2`, mocktable.department AS `d_3`, mocktable.position AS `d_4`
, mocktable.userstatus AS `d_5`, mocktable.courseId AS `d_6`, mocktable.courseName AS `d_7`, mocktable.seriesnames AS `d_8`, mocktable.beginTime AS `d_9`
, mocktable.lastTime AS `d_a0`, mocktable.process AS `d_a1`, mocktable.iscompulsory AS `d_a2`, mocktable.isoption AS `d_a3`
, round(SUM(mocktable.videolength + 60 * mocktable.txtsize) / 60, 2) AS `m_0`
FROM (
SELECT ush.userId, u.userName, u.business, u.department, u.position
, CASE
WHEN u.deleted = 1 THEN '在职'
ELSE '离职'
END AS userstatus, ush.courseId, c.courseName, ush.beginTime, ush.lastTime
, round(ush.process, 2) AS process, ush.studyTime
, (
SELECT CASE
WHEN count(DISTINCT c1.userid) > 0 THEN '是'
ELSE '否'
END
FROM ods_ihub_sr.classesusers c1
INNER JOIN ods_ihub_sr.classes c2 ON c2.classesId = c1.classesId
WHERE c1.courseId = c.courseId
AND c2.classesName != '选修班'
AND c1.userId = ush.userId
AND c1.d = '2024-04-16'
AND c2.d = '2024-04-16'
) AS iscompulsory
, (
SELECT CASE
WHEN count(DISTINCT c1.userid) > 0 THEN '是'
ELSE '否'
END
FROM ods_ihub_sr.classesusers c1
INNER JOIN ods_ihub_sr.classes c2 ON c2.classesId = c1.classesId
WHERE c1.courseId = c.courseId
AND c2.classesName = '选修班'
AND c1.userId = ush.userId
AND c1.d = '2024-04-16'
AND c2.d = '2024-04-16'
) AS isoption, u.levelid, u.leadero
, (
SELECT COALESCE(sum(v.videoLength), 0)
FROM ods_ihub_sr.coursevideo v
WHERE v.courseId = c.courseId
AND v.deleted = 0
AND v.d = '2024-04-16'
) AS videolength
, (
SELECT count(*)
FROM ods_ihub_sr.courseresource r
WHERE r.courseId = c.courseId
AND r.deleted = 0
AND r.d = '2024-04-16'
) AS txtsize
, (
SELECT array_join(array_agg(s.seriesname), ',')
FROM ods_ihub_sr.seriestabcontent ct
LEFT JOIN ods_ihub_sr.seriesmajorinfo s
ON s.id = ct.seriesid
AND s.d = '2024-04-16'
WHERE ct.reftype = 1
AND ct.refid = c.courseId
AND ct.deleted = 0
AND ct.d = '2024-04-16'
) AS seriesnames
FROM ods_ihub_sr.userstudyhistory ush
INNER JOIN ods_ihub_sr.courseinfo c
ON c.courseId = ush.courseId
AND c.deleted = 0
AND c.d = '2024-04-16'
INNER JOIN (
SELECT DISTINCT pm.collegeid AS id
FROM ods_ihub_sr.cdm_ihub_report_iam_permission pm
LEFT JOIN ods_ihub_sr.college cg
ON (cg.id = pm.collegeid
OR pm.collegeid = -1)
AND cg.deleted = 0
WHERE pm.userid = 'S63708'
AND pm.d = '2024-04-16'
AND cg.d = '2024-04-16'
AND (pm.modulecode = '001-001-001'
OR pm.modulecode = '-1')
) t
ON c.collegeid = t.id
OR t.id = -1
LEFT JOIN ods_ihub_sr.userinfo u
ON u.userid = ush.userId
AND u.d = '2024-04-16'
WHERE ush.d = '2024-04-16'
) `mocktable`
GROUP BY mocktable.userId, mocktable.userName, mocktable.business, mocktable.department, mocktable.position, mocktable.userstatus, mocktable.courseId, mocktable.courseName, mocktable.seriesnames, mocktable.beginTime, mocktable.lastTime, mocktable.process, mocktable.iscompulsory, mocktable.isoption
LIMIT 2000