今天遇到一个惊天大bug,
查询数据库版本select version();
mysql 5.6
SELECT aa.worker_status,aa.worker_id,aa.create_time,aa.project_id FROM(
SELECT twe.worker_id,twe.worker_status,twe.project_id,twe.create_time from t_worker_exitorentre twe
WHERE twe.project_id = '0e50***************4eba544' AND worker_id is not null AND worker_id != '' order by twe.create_time desc,twe.id desc
) aa GROUP BY aa.worker_id
但是生产环境mysql变成8.0.16
重点来了,在原子查询上面加LIMIT 99999
SELECT aa.worker_status,aa.worker_id,aa.create_time,aa.project_id FROM(
SELECT twe.worker_id,twe.worker_status,twe.project_id,twe.create_time from t_worker_exitorentre twe
WHERE twe.project_id = '0e50***************4eba544' AND worker_id is not null AND worker_id != '' order by twe.create_time desc,twe.id desc LIMIT 99999
) aa GROUP BY aa.worker_id