注册

mysql迁移达梦sql报错

Nothing to say 2023/12/11 576 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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

Cause: dm.jdbc.driver.DMException: 第 1 行, 第 81 列[AS]附近出现错误:

回答 0
暂无回答
扫一扫
联系客服