使用Atlas时shardingkey使用=时，select没有数据，但用in时有

[jmbkeyes]

我有一张表center_trainee_month_checkin,
CREATE TABLE center_trainee_month_checkin (
id BIGINT(20) NOT NULL AUTO_INCREMENT,
centerId BIGINT(20) NULL DEFAULT NULL,
checkInCount SMALLINT(6) NULL DEFAULT NULL,
checkInDayCount TINYINT(4) NULL DEFAULT NULL,
createTime DATETIME NULL DEFAULT NULL,
month MEDIUMINT(9) NULL DEFAULT NULL,
traineeId BIGINT(20) NULL DEFAULT NULL,
PRIMARY KEY (id),
INDEX UK_kyv8gri8lp2mpjcflnq295cob (centerId, month, traineeId)
)

根据分表键centerId分表之后有4个子表center_trainee_month_checkin_0,center_trainee_month_checkin_1,center_trainee_month_checkin_2, center_trainee_month_checkin_3。

连接到atlas执行sql语句
select * from center_trainee_month_checkin where centerId=264;没有数据返回
但是执行select * from center_trainee_month_checkin where centerId in(264);有数据返回