← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/case.test

  • Committer: lbieber
  • Date: 2010-10-08 01:11:05 UTC
  • mfrom: (1821.1.4 build)
  • Revision ID: lbieber@orisndriz08-20101008011105-1tbwbvz9me9fy7ua
Merge Monty - Fixed the last of the ICC warnings. Turned on warnings=errors
Merge Brian - fixu bug #655558: SELECT 102/(1-1) should error on divide by zero          
Merge Brian - fix bug #654219: information_schema.key_column_usage does not contain information about FKs

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/case.test
18
18
select CASE 2.0 when 1 then "one" WHEN 2.0 then "two" ELSE "more" END;
19
19
select (CASE "two" when "one" then "1" WHEN "two" then "2" END);
20
20
select (CASE "two" when "one" then 1.00 WHEN "two" then 2.00 END) +0.0;
 
21
--error ER_DIVISION_BY_ZERO
21
22
select case 1/0 when "a" then "true" else "false" END;
 
23
--error ER_DIVISION_BY_ZERO
22
24
select case 1/0 when "a" then "true" END;
 
25
--error ER_DIVISION_BY_ZERO
23
26
select (case 1/0 when "a" then "true" END);
 
27
--error ER_DIVISION_BY_ZERO
24
28
select (case 1/0 when "a" then "true" END) + 0.0;
25
29
select case when 1>0 then "TRUE" else "FALSE" END;
26
30
select case when 1<0 then "TRUE" else "FALSE" END;