RootCauseunvalidated
group by r.product_group_id, r.group_name, r.class, label — case when r.name='tomato' then 'invalid' else 'valid' end label. Outcome: case when max(case when r.name ='tomato' then r.name end) = 'tomato' then 'invalid' else 'valid' end label.
cbdc8e80-8161-4113-b091-c05483d58446
group by r.product_group_id, r.group_name, r.class, label — case when r.name='tomato' then 'invalid' else 'valid' end label. Outcome: case when max(case when r.name ='tomato' then r.name end) = 'tomato' then 'invalid' else 'valid' end label.