← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/case.test

  • Committer: Brian Aker
  • Date: 2010-09-09 21:45:53 UTC
  • mto: (1756.1.2 build) (1768.2.1 trunk)
  • mto: This revision was merged to the branch mainline in revision 1757.
  • Revision ID: brian@tangent.org-20100909214553-e687rmf5zk9478on
Force unique to just use memory and let the OS handle paging.

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
22
21
select case 1/0 when "a" then "true" else "false" END;
23
 
--error ER_DIVISION_BY_ZERO
24
22
select case 1/0 when "a" then "true" END;
25
 
--error ER_DIVISION_BY_ZERO
26
23
select (case 1/0 when "a" then "true" END);
27
 
--error ER_DIVISION_BY_ZERO
28
24
select (case 1/0 when "a" then "true" END) + 0.0;
29
25
select case when 1>0 then "TRUE" else "FALSE" END;
30
26
select case when 1<0 then "TRUE" else "FALSE" END;