SQL中UNION ALL + LIMIT

SELECT * FROM (
SELECT 'collect_log' AS '表名',id, rsync_status AS '状态', error AS '错误' 
FROM universal_etl_range.`collect_log` 
WHERE  (collect_status = 3 OR compress_status = 3 OR rsync_status = 2)  
LIMIT 1
UNION ALL 
SELECT 'load_log' AS '表名',id, load_status AS '状态', error AS '错误' 
FROM universal_etl_range.`load_log` 
LIMIT 3

) tmp LIMIT 100;

结果：1表1条数据，2表3-1=2条数据