summaryrefslogtreecommitdiff
path: root/mysql-test/t/user_var.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/user_var.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/user_var.test')
-rw-r--r--mysql-test/t/user_var.test11
1 files changed, 9 insertions, 2 deletions
diff --git a/mysql-test/t/user_var.test b/mysql-test/t/user_var.test
index e1b23a1782f..837b310b36e 100644
--- a/mysql-test/t/user_var.test
+++ b/mysql-test/t/user_var.test
@@ -144,8 +144,6 @@ select @@version;
--replace_column 1 #
select @@global.version;
-# End of 4.1 tests
-
#
# Bug #6598: problem with cast(NULL as signed integer);
#
@@ -171,3 +169,12 @@ set @first_var= cast(NULL as CHAR);
create table t1 select @first_var;
show create table t1;
drop table t1;
+#
+# Bug #20924: CAST(expr as UNSIGNED) returns SIGNED value when used in various
+# functions
+# - SET on a user variable saves UNSIGNED as SIGNED
+#
+set @a=18446744073709551615;
+select @a;
+
+--echo End of 4.1 tests