MySQL Casting Gotcha Works SELECT 409.95 = (1 + 408.95) Doesn’t SELECT 409.95 = (a + b) Works SELECT 409.95 = CAST((a + b) as decimal)