diff options
| author | kaa@polly.local <> | 2006-09-12 17:57:15 +0400 |
|---|---|---|
| committer | kaa@polly.local <> | 2006-09-12 17:57:15 +0400 |
| commit | e03faff3e4b38ae1e488d784c86279858d102dcf (patch) | |
| tree | 04bd01bf77e5e54c51d38c38513121bea33e0007 /mysql-test/t/case.test | |
| parent | b5f67a642fff1a57249100a3d1096a2a0a81c3f8 (diff) | |
| parent | 5df7611caa310a88666f7fd2a7f14bd23ca8e24a (diff) | |
| download | mariadb-git-e03faff3e4b38ae1e488d784c86279858d102dcf.tar.gz | |
Merge polly.local:/tmp/20924/bug20294/my41-bug20294
into polly.local:/tmp/20924/bug20294/my50-bug20294
Diffstat (limited to 'mysql-test/t/case.test')
| -rw-r--r-- | mysql-test/t/case.test | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test index fbe1ee2b8c8..a22b9cc39f1 100644 --- a/mysql-test/t/case.test +++ b/mysql-test/t/case.test @@ -133,8 +133,6 @@ select min(a), min(case when 1=1 then a else NULL end), from t1 where b=3 group by b; drop table t1; -# End of 4.1 tests - # # Tests for bug #9939: conversion of the arguments for COALESCE and IFNULL @@ -154,3 +152,12 @@ SELECT IFNULL(t2.EMPNUM,t1.EMPNUM) AS CEMPNUM, FROM t1 LEFT JOIN t2 ON t1.EMPNUM=t2.EMPNUM; DROP TABLE t1,t2; +# +# Bug #20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various +# functions +# - UNSIGNED values in CASE and COALESCE are treated as SIGNED +# +SELECT CASE 1 WHEN 1 THEN 18446744073709551615 ELSE 1 END; +SELECT COALESCE(18446744073709551615); + +--echo End of 4.1 tests |