mysql : select 2 as selectType,null as rid 报错

Question

不知道为什么会报错，window7测试没问题，在linux上报错，但直接把语句拿到linux上的navicat执行也不报错。

环境

• linux
• mybatis 3.5
• mysql 5.6

报错语句

SELECT DISTINCT
    T.rid AS factorRid ,
    null as rid,
    2 as selectType
FROM
    TD_FACTOR T1
    LEFT JOIN TD_ITEM T ON T.RID = T1.FACTOR_ID

初步解决方案

将 null as rid, 2 as selectType 去掉了，不在报错

Answer 1

可能要加上反引号，null