求解 MySQL 8.0 Left Join 的表使用 PARTITION 分区的问题

SELECT mhy_order.id AS id, mhy_order.id AS orderId, mhy_trademark.id AS trademarkId, mhy_trademark_type.id AS typeId, mhy_order.order_type AS type, mhy_trademark_type.type AS category, mhy_trademark.`name` AS trademark, mhy_trademark_type.registration_number AS registrationNumber, mhy_applicant.`name` AS applicantName, mhy_applicant.message_corp AS messageCorp, IFNULL( mhy_order.complete, '否' ) AS isComplete, mhy_applicant.custom_name AS contactUser, mhy_order.charge AS charge, mhy_order.notification_method AS noticeType, mhy_order.notification_time AS noticeTime, sys_user.username AS salesman, mhy_order_progress.gen_time AS messageTime, ROW_NUMBER() over ( PARTITION BY mhy_order_progress.order_id ORDER BY mhy_order_progress.gen_time DESC ) RowNum, FROM `mhy_trademark_type` JOIN mhy_trademark ON `mhy_trademark_type`.trademark_id = mhy_trademark.id JOIN mhy_order ON mhy_trademark.order_id = mhy_order.id JOIN mhy_applicant ON mhy_order.applicant_id = mhy_applicant.id JOIN `sys_user` ON `sys_user`.user_id = mhy_order.create_user_id -- JOIN mhy_applicant as tp ON mhy_order.transferor_id = tp.id LEFT JOIN mhy_order_progress ON mhy_order_progress.order_id = mhy_order.id 

目前的 SQL 就是这样 还是比较简单的，关键在于待分组的表 mhy_order_progress 是 left join 的，可能关联不到这张表。 导致 ```PARTITION BY mhy_order_progress.order_id`` 执行时，数据都跑一个分区里了，因为 mhy_order_progress.order_id 都是 null 。

数据库是 mysql8.0 最新版本。这个 SQL 还有个非常长的 where 以及分页。