summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.cornsilk.net>2006-11-15 12:29:24 -0500
committerunknown <cmiller@zippy.cornsilk.net>2006-11-15 12:29:24 -0500
commit5f1fc19b9e551670232909ed06c644bb8c9366ac (patch)
treef4fff13031f0930bd87d245092eda560cc8c77de /mysql-test
parent1c02e6477ed8a7ff0e3e51c8d73231e9dbe443a0 (diff)
parent011513bd4987270f35a5ba3ce1a424f8532c50b9 (diff)
downloadmariadb-git-5f1fc19b9e551670232909ed06c644bb8c9366ac.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-5.1-maint
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-maint sql/item_func.cc: Auto merged
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/bigint.result11
-rw-r--r--mysql-test/t/bigint.test9
2 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result
index c27ce18cfd3..d8f78cd5103 100644
--- a/mysql-test/r/bigint.result
+++ b/mysql-test/r/bigint.result
@@ -341,3 +341,14 @@ select * from t1 where bigint_col='17666000000000000000';
bigint_col
17666000000000000000
drop table t1;
+
+bug 19955 -- mod is signed with bigint
+select cast(10000002383263201056 as unsigned) mod 50 as result;
+result
+6
+create table t1 (c1 bigint unsigned);
+insert into t1 values (10000002383263201056);
+select c1 mod 50 as result from t1;
+result
+6
+drop table t1;
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test
index 35cda11646a..6c1229db83f 100644
--- a/mysql-test/t/bigint.test
+++ b/mysql-test/t/bigint.test
@@ -278,4 +278,13 @@ select * from t1 where bigint_col=17666000000000000000;
select * from t1 where bigint_col='17666000000000000000';
drop table t1;
+--echo
+--echo bug 19955 -- mod is signed with bigint
+
+select cast(10000002383263201056 as unsigned) mod 50 as result;
+
+create table t1 (c1 bigint unsigned);
+insert into t1 values (10000002383263201056);
+select c1 mod 50 as result from t1;
+drop table t1;