~drizzle-trunk/drizzle/development

Viewing changes to tests/t/case.test

Merge Brian - fixu bug #655558: SELECT 102/(1-1) should error on divide by zero

added added

removed removed

select CASE 2.0 when 1 then "one" WHEN 2.0 then "two" ELSE "more" END;

select (CASE "two" when "one" then "1" WHEN "two" then "2" END);

select (CASE "two" when "one" then 1.00 WHEN "two" then 2.00 END) +0.0;

--error ER_DIVISION_BY_ZERO

select case 1/0 when "a" then "true" else "false" END;

--error ER_DIVISION_BY_ZERO

select case 1/0 when "a" then "true" END;

--error ER_DIVISION_BY_ZERO

select (case 1/0 when "a" then "true" END);

--error ER_DIVISION_BY_ZERO

select (case 1/0 when "a" then "true" END) + 0.0;

select case when 1>0 then "TRUE" else "FALSE" END;

select case when 1<0 then "TRUE" else "FALSE" END;