~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/case.test

• browse files at revision 1755.3.1
• compare with another revision
• download diff
• download tarball
• view history from revision 1755.3.1

• reverse the comparison (1755.3.1 to 1819.5.262)
• stop comparing with revision 1819.5.262

Show diffs side-by-side

added

removed

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;

• Older »

Loggerhead is a web-based interface for Breezy
Version: 2.0.1