FEDERATED表的left join问题_MySQL

bitsCN.com

Address 为Innodb表，AppUser 为FEDERATED表，下面的连接查询如果用INNER JOIN 就正常，用left join连接的结果Name全为null，即使有匹配的行，怀疑是mysql的bug

select a.*,b.Name from Address AS a
LEFT JOIN AppUser AS b ON b.AID = a.CheckAdminID
where a.AID=1006948

暂时解决办法：将AppUser改名AppUser1，建个视图AppUser引用AppUser1，结果正常。

bitsCN.com