← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/case.test

[patch 112/129] Merge patch for revision 1925 from InnoDB SVN:
revno: 1925
revision-id: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6169
parent: svn-v4:16c675df-0fcb-4bc9-8058-dcc011a37293:branches/zip:6163
committer: calvin
timestamp: Thu 2009-11-12 12:40:43 +0000
message:
  branches/zip: add test case for bug#46676
  
  This crash is reproducible with InnoDB plugin 1.0.4 + MySQL 5.1.37.
  But no longer reproducible after MySQL 5.1.38 (with plugin 1.0.5).
  Add test case to catch future regression.
added:
  mysql-test/innodb_bug46676.result 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.result
  mysql-test/innodb_bug46676.test 6169@16c675df-0fcb-4bc9-8058-dcc011a37293:branches%2Fzip%2Fmysql-test%2Finnodb_bug46676.test
diff:
=== added file 'mysql-test/innodb_bug46676.result'

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;