diff options
| author | unknown <kaa@polly.local> | 2006-09-12 18:43:38 +0400 |
|---|---|---|
| committer | unknown <kaa@polly.local> | 2006-09-12 18:43:38 +0400 |
| commit | 910c0075531b594d573589580216a88bb7d02ddb (patch) | |
| tree | a1ab7ce7e23389ace763af0cac91864b1c37039c /mysql-test/t/case.test | |
| parent | 51e8434e4d9f1644a1ba132d6ec1ab1f9e695df7 (diff) | |
| parent | d31a3434650a9991bcc16478e65efd7d2ea23c76 (diff) | |
| download | mariadb-git-910c0075531b594d573589580216a88bb7d02ddb.tar.gz | |
Merge polly.local:/tmp/20924/bug20294/my50-bug20294
into polly.local:/tmp/20924/bug20294/my51-bug20294
mysql-test/r/case.result:
Auto merged
mysql-test/r/func_if.result:
Auto merged
mysql-test/r/func_test.result:
Auto merged
mysql-test/t/case.test:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/item_cmpfunc.h:
Auto merged
sql/log_event.cc:
Auto merged
sql/sql_class.h:
Auto merged
mysql-test/r/user_var.result:
Manual merge
mysql-test/t/user_var.test:
Manual merge
sql/item_func.cc:
Manual merge
sql/item_func.h:
Manual merge
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 1bdfc5cc10f..effe165ed1a 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 |