summaryrefslogtreecommitdiff
path: root/mysql-test/t/case.test
diff options
context:
space:
mode:
authorunknown <kaa@polly.local>2006-09-13 15:18:14 +0400
committerunknown <kaa@polly.local>2006-09-13 15:18:14 +0400
commitb419501e0df3201cb9d188ffd56fe84c468b3d17 (patch)
treedcd7f028408454113afb7f3e54560e4d265eae1d /mysql-test/t/case.test
parentd31a3434650a9991bcc16478e65efd7d2ea23c76 (diff)
parent418ae41b4867e53e770d79f66e6d9ba3f7b8974b (diff)
downloadmariadb-git-b419501e0df3201cb9d188ffd56fe84c468b3d17.tar.gz
Merge polly.local:/tmp/20924/bug20294/my41-bug20294
into polly.local:/tmp/20924/bug20294/my50-bug20294 sql/item_cmpfunc.cc: Auto merged sql/item_cmpfunc.h: Auto merged sql/item_func.h: Auto merged sql/log_event.cc: Auto merged sql/sql_class.h: Auto merged mysql-test/r/case.result: Manual merge mysql-test/r/func_if.result: Manual merge mysql-test/r/func_test.result: Manual merge mysql-test/r/user_var.result: Manual merge mysql-test/t/case.test: Manual merge mysql-test/t/func_if.test: Manual merge mysql-test/t/func_test.test: Manual merge mysql-test/t/user_var.test: Manual merge sql/item_func.cc: Manual merge
Diffstat (limited to 'mysql-test/t/case.test')
-rw-r--r--mysql-test/t/case.test10
1 files changed, 1 insertions, 9 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
index a22b9cc39f1..0e9e141f6d8 100644
--- a/mysql-test/t/case.test
+++ b/mysql-test/t/case.test
@@ -152,12 +152,4 @@ 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
+# End of 4.1 tests