为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:统信uos
【CPU】:arrch64
【问题描述】*:mysql迁移达梦sql报错
SELECT cb.C_ID as buttonId,
cb.C_BUTTON_NAME as buttonName,
cbc.C_ID IS NOT NULL AS isSelect (这行报错 列[AS]附近出现错误)
FROM qrda.t_cim_button cb
INNER JOIN qrda.t_cim_button_level cbl
ON cb.C_ID = cbl.C_BUTTON_ID
AND cb.C_BUTTON_STATUS = 1
AND cbl.C_BUTTON_TYPE_LEVEL = 1
INNER JOIN t_cim_button_model cbm
ON cb.C_ID = cbm.C_BUTTON_ID
AND cbm.C_MODEL_TYPE = 1
LEFT JOIN qrda.t_cim_button_config cbc
ON cbc.C_BUTTON_ID = cb.C_ID
AND cbc.C_ARCHIVE_TYPE_ID = 1
AND cbc.C_TYPE_LEVEL = 1
AND cbc.C_MODEL_TYPE = 1
ORDER BY cb.C_ORDER_NO ASC
改为 nvl2(cbc.C_ID,1,0) as isselect
is not null去掉再试试