为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM18
【操作系统】:
【CPU】:
【问题描述】*:
我实在没发现到底那有问题
-2007: 第 102 行, 第 13 列[)]附近出现错误:
语法分析出错
SELECT
paraminfo.id AS fromId,
concat( base.newWind_ludpUrl, paraminfo.id, '&', paraminfo.addp ) AS newWind_addludpUrl,
concat( base.dialog_ludpUrl, paraminfo.id, '&', paraminfo.addp ) AS dialog_addludpUrl,
concat( base.newWind_ludpUrl, paraminfo.id, '&', paraminfo.p ) AS newWind_modifyludpUrl,
concat( base.dialog_ludpUrl, paraminfo.id, '&', paraminfo.p ) AS dialog_modifyludpUrl,
concat( base.menu_ludpUrl, paraminfo.id, '&', paraminfo.addp ) AS menu_addludpUrl,
concat( base.menu_modifyludpUrl, paraminfo.id, '&', paraminfo.p ) AS menu_modifyludpUrl,
concat( base.tourist_ludpUrl, paraminfo.id, '&', paraminfo.addp ) AS tourist_addludpUrl,
concat( base.tourist_ludpUrl, paraminfo.id, '&', paraminfo.p ) AS tourist_modifyludpUrl,
concat( base.newWind_ludpUrl, paraminfo.id, '&', paraminfo.approvep ) AS approve_ludpUrl,
concat( base.approve_callback_ludpUrl, paraminfo.id, '&', paraminfo.approvep ) AS approve_callback_ludpUrl
FROM ((
SELECT
concat( 'ludp/page?ludpFormId=' ) AS newWind_ludpUrl,
concat( 'ludp/main-page?ludpFormId=' ) AS menu_ludpUrl,
concat( 'ludp/src/components/dialog/dialogLudpPage.vue?ludpFormId=' ) AS dialog_ludpUrl,
concat( 'ludp/main-page?ludpFormId=' ) AS menu_modifyludpUrl,
concat( '/api/ludp/modeling/form-approve-callback?ludpFormId=' ) AS approve_callback_ludpUrl,
concat( 'ludp/form-page/middle?ludpFormId=' ) AS tourist_ludpUrl
) base
JOIN (
SELECT
result.id AS id,
COALESCE(LISTAGG(result.urlp, '&') WITHIN GROUP (ORDER BY result.urlp), '') AS p,
COALESCE(LISTAGG(result.addurlp, '&') WITHIN GROUP (ORDER BY result.addurlp), '') AS addp,
COALESCE(LISTAGG(result.approveurlp, '&') WITHIN GROUP (ORDER BY result.approveurlp), '') AS approvep
FROM
(
SELECT
fd.id AS id,
bizp.param_name AS param_name,
fdef.default_value AS default_value,(
CASE
WHEN ( bizp.param_name = 'ludpBizId' ) THEN
'ludpBizId=' ELSE concat(
bizp.param_name,
'=',
COALESCE (
fdef.default_value,
COALESCE ( bizp.remark, '实际值' )))
END
) AS addurlp,(
CASE
WHEN ( bizp.param_name = 'ludpBizId' ) THEN
'ludpBizId={业务ID}' ELSE concat(
bizp.param_name,
'=',
COALESCE (
fdef.default_value,
COALESCE ( bizp.remark, '实际值' )))
END
) AS approveurlp,
concat(
bizp.param_name,
'=',
COALESCE (
fdef.default_value,
COALESCE ( bizp.remark, '实际值' ))) AS urlp
FROM
(((
ludp_form_design fd
LEFT JOIN ludp_biz_obj_form_relation bfr ON ((
fd.id = bfr.form_id
)))
LEFT JOIN (
SELECT
ludp_biz_obj_param.id AS id,
ludp_biz_obj_param.biz_obj_id AS biz_obj_id,
ludp_biz_obj_param.param_name AS param_name,(
CASE
WHEN ( ludp_biz_obj_param.param_name = 'ludpBizId' ) THEN
'[业务主键]' ELSE '[实际值]'
END
) AS remark
FROM
ludp_biz_obj_param
) bizp ON ((
bfr.biz_obj_id = bizp.biz_obj_id
)))
LEFT JOIN (
SELECT
ludp_form_default.id AS id,
ludp_form_default.form_id AS form_id,
ludp_form_default.biz_obj_id AS biz_obj_id,
ludp_form_default.biz_obj_param_id AS biz_obj_param_id,
ludp_form_default.default_type AS default_type,
ludp_form_default.debug_mode AS debug_mode,
ludp_form_default.default_value AS default_value
FROM
ludp_form_default
WHERE
( ludp_form_default.debug_mode = 'single' )) fdef ON (((
bizp.id = fdef.biz_obj_param_id
)
AND ( fd.id = fdef.form_id ))))) result
GROUP BY
result.id
) paraminfo)
将兼容性调整下,重启后看下。另外表结构可以发出来看看
sp_set_para_value(1,'GROUP_OPT_FLAG',1);
sp_set_para_value(2,'COMPATIBLE_MOD',4);
可以分段执行sql,排查下具体问题在哪里。