Re: BUG #17925: Incorrect select query result

Since this is corporation data I cannot provide much data in this public mailing list unfortunately. And I have not yet been able to reproduce this behaviour on dummy data. 
  with ae_trainings as (
    select * from trainings.activity_events
    where training_id in (709))
  select tb.training_id, tb.block, count(ae.trial_time_stimuli_start is not null) suspicions_column_result
  from trainings.training_blocks tb
  left join ae_trainings ae
    on ae.training_id = tb.training_id
      and ae.block = tb.block
      and ae.activity = tb.activity
      and ae.event = 'trial'
  where tb.training_id in (709)
    and tb.block < 23
  group by tb.training_id, tb.block
  order by tb.training_id, tb.block desc
  limit 10


  with ae_trainings as (
    select * from trainings.activity_events
    where training_id in (891))
  select tb.training_id, tb.block, count(ae.trial_time_stimuli_start is not null) suspicions_column_result
  from trainings.training_blocks tb
  left join ae_trainings ae
    on ae.training_id = tb.training_id
      and ae.block = tb.block
      and ae.activity = tb.activity
      and ae.event = 'trial'
  where tb.training_id in (891)
    and tb.block < 23
  group by tb.training_id, tb.block
  order by tb.training_id, tb.block desc
  limit 10
  select tb.training_id, tb.block, count(ae.trial_time_stimuli_start is not null) suspicions_column_result
  from trainings.training_blocks tb
  left join trainings.activity_events ae
    on ae.training_id = tb.training_id
      and ae.block = tb.block
      and ae.activity = tb.activity
      and ae.event = 'trial'
  where tb.training_id in (709,891)
    and tb.block < 23
  group by tb.training_id, tb.block
  order by tb.training_id, tb.block desc
  limit 10