that looks like optimiser bug, feel free to add github issue

not sure if it helps but you could try to use

with

as a workaround. something like:

with
f as (select dag_id, task_id, max(timestamp) as last_finish from ti_finish group by dag_id, task_id)
select s.*, f.*
from ti_start as s
left join f on s.dag_id = f.dag_id and s.task_id = f.task_id
where s.timestamp >= f.last_finish;

Thanks for the replies 🙂 I am aware of the left join and NULLs, the query you see was rather ad hoc and grew from some other queries executed before (and I would also not use * if we are at it 😄 ) Interesting that it behaves differently with CTEs. As for Github, please be patient; I still dont have an account there and am a little busy today

don’t forget to start us on gitbug too 😉