在x86_64 上执行下面这段可以正常执行
UPDATE SYS_MENU S
INNER JOIN (
SELECT
PB.ID NEW_ID,
PA.ID OLD_ID
FROM
SYS_CUS_PAGE_BASE_INFO PA
INNER JOIN SYS_CUS_PAGE_BASE_INFO PB ON PB.PG_CODE = PA.PG_CODE
WHERE
PA.YEAR_ID =‘402881266f37bc4f016f385cfc970001’
AND PB.YEAR_ID =‘ff8080817a17aa8b017a17aa8b5e0000’
) B ON B.OLD_ID = S.CUS_PAGE_ID
AND S. YEAR =‘ff8080817a17aa8b017a17aa8b5e0000’
SET S.CUS_PAGE_ID = B.NEW_ID,
S.URL = concat(
‘/admin/CusPageModel/toCusPageSample.do?cusId=’,
B.NEW_ID
)
截图如下:
但是安装在ARM上的达梦执行却报错,同一段sql:
求教各位大佬
select id_code,* from v$version
看下版本是否一致。