Anything wrong with this MySQL syntax?

Question

select 
    (`Setup` + `run` + `cleanup`) / `QNTY`
from 
    the_table 
where 
    date_field >= "2012-01-01" and
    Num = 4;

Every time I execute this query in MySQL workbench, the workbench application crashes immediately. Looks like something that I have done many times before, not sure what the problem is.

Only thing I can think of is a problem with null values. Sometimes (Setup + run + cleanup) will return a null, and sometimes QNTY is null also.

I just checked, and this query also causes a crash:

select 
    (`Setup` + `run` + `cleanup`) / `QNTY`
from 
    the_table
where 
    date_field >= "2012-01-01" and
    (`Setup` + `run` + `cleanup`) is not null and
    `QNTY` is not null and
    `QNTY` != 0 and
    Num = 4

Thanks.

Answer 1

I would try

select 
    (coalesce(Setup, 0) + coalesce(run, 0) + coalesce(cleanup, 0)) / QNTY
from 
    the_table
where 
    date_field >= '2012-01-01' and
    Num = 4 and
    coalesce(QNTY, 0) <>0

Answer 2

Looks like a bug in workbench as suggested by Darkwater23 in the comments. I tried on the old MySQL Query Browser and it executed fine with nulls and zeros and everything.