← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/case.result

  • Committer: Brian Aker
  • Date: 2010-10-06 07:52:09 UTC
  • mto: (1821.1.2 build)
  • mto: This revision was merged to the branch mainline in revision 1822.
  • Revision ID: brian@tangent.org-20101006075209-0fu3u7zg9r8rw3i8
Fix issue with divide by zero not being an error.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/case.result
38
38
(CASE "two" when "one" then 1.00 WHEN "two" then 2.00 END) +0.0
39
39
2.00
40
40
select case 1/0 when "a" then "true" else "false" END;
41
 
case 1/0 when "a" then "true" else "false" END
42
 
false
43
 
Warnings:
44
 
Error   1365    Division by 0
 
41
ERROR 22012: Division by 0
45
42
select case 1/0 when "a" then "true" END;
46
 
case 1/0 when "a" then "true" END
47
 
NULL
48
 
Warnings:
49
 
Error   1365    Division by 0
 
43
ERROR 22012: Division by 0
50
44
select (case 1/0 when "a" then "true" END);
51
 
(case 1/0 when "a" then "true" END)
52
 
NULL
53
 
Warnings:
54
 
Error   1365    Division by 0
 
45
ERROR 22012: Division by 0
55
46
select (case 1/0 when "a" then "true" END) + 0.0;
56
 
(case 1/0 when "a" then "true" END) + 0.0
57
 
NULL
58
 
Warnings:
59
 
Error   1365    Division by 0
 
47
ERROR 22012: Division by 0
60
48
select case when 1>0 then "TRUE" else "FALSE" END;
61
49
case when 1>0 then "TRUE" else "FALSE" END
62
50
TRUE