版本:8.5
数据库:MSsqlserver
重现环境 172.17.6.78 11033 8080 NEWyiGe
关联提单:R20190127-0036
报错日志如下
错误详细堆栈信息:com.kingdee.bos.BOSException: Sql3 execute exception : SELECT ………………………………
merge.FNAME_l2 as mergesoloname
FROM t_csl_CslReport t1
INNER JOIN t_org_baseunit t2 ON t1.FORGUNITID = t2.FID
LEFT OUTER JOIN T_CSL_FastMergeTemplate f ON f.FTEMPLATEID = t1.FTemplateID
LEFT OUTER JOIN T_CSL_FastMergeSolu merge ON merge.FID = f.FFASTMERGESOLUID
Caused exception message is: 关键字 'FROM' 附近有语法错误。
at com.kingdee.eas.util.app.DbUtil.executeQuery(DbUtil.java:137)
at com.kingdee.eas.fi.newrpt.app.DbUtil.executeQuery(DbUtil.java:57)
at com.kingdee.eas.fi.gr.cslrpt.app.VersionCheckFacadeControllerBean.constructCheckLog(VersionCheckFacadeControllerBean.java:124)
问题原因:
使用的是MSSQLSERVER 数据库merge 是其一个函数,不能用来做别名
推荐阅读