query failed
42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_18' without begin-label
query started on line 15 of file case_evaluates_all_branches.SF-2893484.test
query text:
SELECT CASE SUM(payout_units_cpc) WHEN 0 THEN 0 ELSE 1 END AS avg_cost_cpc FROM stats_2009_week_31

query failed
42000!Error in optimizer reorder: MALException:chkFlow:user.main exit-label 'X_31' without begin-label
query started on line 20 of file case_evaluates_all_branches.SF-2893484.test
query text:
SELECT cast( CASE SUM(payout_units_cpc) WHEN 0 THEN 0 ELSE cast(SUM(payout_units_cpc * payout_cpc) as numeric(12,4)) / SUM(payout_units_cpc) END as decimal(18,4)) AS avg_cost_cpc FROM stats_2009_week_31