summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_test.test
diff options
context:
space:
mode:
authorunknown <kaa@polly.local>2006-09-12 17:57:15 +0400
committerunknown <kaa@polly.local>2006-09-12 17:57:15 +0400
commitdb141b6b45ba2a0ea2d7bb8d2f25f105ca0bf867 (patch)
tree04bd01bf77e5e54c51d38c38513121bea33e0007 /mysql-test/t/func_test.test
parentbd8309cce6793352cebcf54459fa301eaab0b3b8 (diff)
parent5aa6e8615e0aeb3babafcd5e93e67b72027fcdaa (diff)
downloadmariadb-git-db141b6b45ba2a0ea2d7bb8d2f25f105ca0bf867.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/func_test.test')
-rw-r--r--mysql-test/t/func_test.test12
1 files changed, 10 insertions, 2 deletions
diff --git a/mysql-test/t/func_test.test b/mysql-test/t/func_test.test
index f2ff47704c9..83432dcc7fc 100644
--- a/mysql-test/t/func_test.test
+++ b/mysql-test/t/func_test.test
@@ -108,8 +108,6 @@ select 5.1 mod 3, 5.1 mod -3, -5.1 mod 3, -5.1 mod -3;
select 5 mod 3, 5 mod -3, -5 mod 3, -5 mod -3;
-# End of 4.1 tests
-
#
# Bug#6726: NOT BETWEEN parse failure
#
@@ -127,3 +125,13 @@ SELECT GREATEST(1,NULL) FROM DUAL;
SELECT LEAST('xxx','aaa',NULL,'yyy') FROM DUAL;
SELECT LEAST(1.1,1.2,NULL,1.0) FROM DUAL;
SELECT GREATEST(1.5E+2,1.3E+2,NULL) FROM DUAL;
+
+#
+# Bug #20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various
+# functions
+# - UNSIGNED values in GREATEST() and LEAST() are treated as SIGNED
+#
+SELECT GREATEST(1, 18446744073709551615);
+SELECT LEAST(1, 18446744073709551615);
+
+--echo End of 4.1 tests