为什么此查询在MySql 8中崩溃但在Mysql 5中工作正常？

SELECT * 
FROM   `sports` 
WHERE  EXISTS (SELECT *,(SELECT `id` 
                       FROM   `sport_events` 
                       WHERE  `tournament_id` = `tournaments`.`id` 
                              AND `status` = ? 
                              AND `sport_events`.`deleted_at` IS NULL 
                       ORDER  BY `created_at` DESC 
                       LIMIT  1) AS `live_event_id` 
               FROM   `tournaments` 
               WHERE  `sports`.`id` = `tournaments`.`sport_id`)

导致崩溃的查询部分是此嵌套子选择

(SELECT `id` 
   FROM   `sport_events` 
   WHERE  `tournament_id` = `tournaments`.`id` 
          AND `status` = ? 
          AND `sport_events`.`deleted_at` IS NULL 
   ORDER  BY `created_at` DESC 
   LIMIT  1) AS `live_event_id`