tidb 执行查询 LIMIT 不能返回正确的结果

这看着是个bug，子查询结合limit的bug，改成关联就没问题了，SELECT
t1.NAME AS GenderName,
t2.id AS SugarNav_Id,
t2.gender_id AS SugarNav_GenderId,
t2.account AS NAME,
t2.id AS Id
FROM t2
LEFT JOIN t1 ON t2.gender_id = t1.id
ORDER BY t2.id ASC
LIMIT 20, 20;