为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:7
【操作系统】:11
【CPU】:
【问题描述】*:[执行语句1]:
SELECT
r.id AS id,
‘2’ AS type,
r.name AS label,
r.report_name AS name,
‘’ AS dsName,
‘’ AS tabSchema,
t.subject_label AS topic,
ls.subject_label AS lvl,
GROUP_CONCAT( l.name ORDER BY l.create_time DESC SEPARATOR ‘,’ ) AS labelName,
r.create_time AS createTime
FROM
pdi_meta_report r
LEFT JOIN pdi.pdi_meta_subject t ON t.subject_name = r.topic
LEFT JOIN pdi.pdi_meta_subject ls ON ls.subject_name = r.lvl
LEFT JOIN pdi.pdi_asset_label_rel ar ON ar.asset_id = r.id
LEFT JOIN pdi.pdi_label l ON l.id = ar.label_id
WHERE
1 = 1
AND r.publish_flag = ‘1’
AND (
COALESCE (?, NULL ) IS NULL
OR ar.label_id IN (?))
GROUP BY
r.id
执行失败(语句1)
第 10 行, 第 47 列[ORDER]附近出现错误[-2007]:
语法分析出错
1条语句执行失败
达梦没有group_concat函数,推荐使用 listagg/listagg2。