为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:centos7
【CPU】:X86
【问题描述】*:应该是红色框中的sql,蓝色框的sql是怎么回事
连接mysql就正常
是这条sql语句有什么问题嘛
SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT vr."ID",vr."VUL_NAME",vr."PROCESS_INSTANCE_ID",p."PROJECT_NAME",vr."VUL_URL",vr."VUL_DESC",vr."VUL_INFLUENCES",vr."REPAIR_SUGGESTION",vr."CREATE_TIME",vr."VUL_GRADE_ID",vr."PROCESS_STATE", (select "USERNAME" from "XFUSE"."SYS_USER" WHERE vr."FOUNDER_ID" = "XFUSE"."SYS_USER"."ID") "CREATE_USER", dsl."NAME" vulGrade, vs."NAME" sourceStage, scw."NAME" vulSourceToolName , vr."TOOL_NAME" , vr."SYNC_VUL_TYPE", wm_concat(DISTINCT art."NAME_") vulStatus FROM "XFUSE"."VUL_RESULT" vr LEFT JOIN "XFUSE"."SAFE_CALCULATION_WEIGHT" scw ON vr."VUL_SOURCE_TOOL" = scw."ID" LEFT JOIN "XFUSE"."DIC_SECURITY_LEVEL" dsl ON vr."VUL_GRADE_ID" = dsl."ID" LEFT JOIN "XFUSE"."DIC_VUL_SOURCE_STAGE" vs ON vr."SOURCE_STAGE_ID" = vs."ID" LEFT JOIN "XFUSE"."ACT_RU_TASK" art ON vr."PROCESS_INSTANCE_ID" = art."PROC_INST_ID_" LEFT JOIN "XFUSE"."PROJECT" p ON vr."PROJECT_ID" = p."ID" WHERE vr."IS_DELETED" = 0 and p."ARCHIVED" = 0 AND vr."ID" IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) GROUP BY vr."ID",vr."VUL_NAME",vr."PROCESS_INSTANCE_ID",p."PROJECT_NAME",vr."VUL_URL",vr."VUL_DESC",vr."VUL_INFLUENCES",vr."REPAIR_SUGGESTION",vr."CREATE_TIME",vr."VUL_GRADE_ID",vr."PROCESS_STATE", dsl."NAME", vs."NAME", scw."NAME", vr."TOOL_NAME" , vr."SYNC_VUL_TYPE", vr."FOUNDER_ID" order by vr."ID" desc ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ?
==> Parameters: 104513(Long), 104512(Long), 104511(Long), 104510(Long), 104509(Long), 104508(Long), 104507(Long), 104506(Long), 104505(Long), 104504(Long), 10(Long), 0(Long)
蓝色框中的sql不知道哪来的,还报错