- where
- b1.options = 'gc-on' and
- b1.compilation = 'byte' and b1.result = 'fail'
- group by b1.mark) as bench_fails,
- (select b1.mark as mark, COUNT(DISTINCT b1.test) as count
+ group by b1.mark) as bench_fails,
+ (select
+ b1.mark as mark,
+ SUM(if(b1.result='fail' and b1.compilation='opt' and b1.options='gc-on',1,0))
+ as count