[Fix][2.0.6-2.0.7] Fix #11725 dependent task cannot detect target task finished across days
Purpose of the pull request
https://github.com/apache/dolphinscheduler/blob/2746f6851d90cbdda04b6dc099847454ede09550/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/TaskInstanceMapper.xml#L174-L198
Now v2.0.6 and v2.0.7 dependent task use start_time to find the target task above, when the task is blocked by preview tasks and started in after days, the dependent task will never succeed.
The same problem also occurs in complement tasks.
Brief change log
Fix #11725.
Use process_instance_id instead of start_time, and also follows the process_instance's schedule_time.
Which issue does this PR repair ?
Which issue does this PR repair ?
I added an issue:#11725