summaryrefslogtreecommitdiff
path: root/mysql-test/t/bigint.test
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2003-11-21 00:17:46 +0200
committerunknown <monty@mysql.com>2003-11-21 00:17:46 +0200
commited63732bb3068a482aad6c89f08879973c8beaea (patch)
treecc5b75d68dbc553175309599add32578e09f425d /mysql-test/t/bigint.test
parent411b610e7169405ba1fbd8d3c8d4d30fb204dd14 (diff)
parent7c6ed734438fe7f473c045f89ae8d2b1dce8c4b6 (diff)
downloadmariadb-git-ed63732bb3068a482aad6c89f08879973c8beaea.tar.gz
Merge with 4.0 to revert patch for BIGINT assignment to double
mysql-test/r/bigint.result: Auto merged mysql-test/t/bigint.test: Auto merged
Diffstat (limited to 'mysql-test/t/bigint.test')
-rw-r--r--mysql-test/t/bigint.test4
1 files changed, 3 insertions, 1 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test
index 67009386282..5c977983087 100644
--- a/mysql-test/t/bigint.test
+++ b/mysql-test/t/bigint.test
@@ -22,7 +22,7 @@ select -(0-3),round(-(0-3)), round(9999999999999999999);
#
create table t1 (a bigint unsigned not null, primary key(a));
-insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE);
+insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFE), (18446744073709551613), (18446744073709551612);
select * from t1;
select * from t1 where a=18446744073709551615;
# select * from t1 where a='18446744073709551615';
@@ -58,10 +58,12 @@ drop table t1;
#
# Item_uint::save_to_field()
# BUG#1845
+# This can't be fixed in MySQL 4.0 without loosing precisions for bigints
#
CREATE TABLE t1 ( quantity decimal(60,0));
insert into t1 values (10000000000000000000);
+insert into t1 values (10000000000000000000.0);
insert into t1 values ('10000000000000000000');
select * from t1;
drop table t1;