diff options
author | monty@mysql.com <> | 2003-11-21 00:17:46 +0200 |
---|---|---|
committer | monty@mysql.com <> | 2003-11-21 00:17:46 +0200 |
commit | 32a62d506916c2f1ee34cb4494a10b66d1b4be2a (patch) | |
tree | cc5b75d68dbc553175309599add32578e09f425d /mysql-test/t/bigint.test | |
parent | b01fcb4e1438dcc1f9a31bcab30b98b578d1704a (diff) | |
parent | 41eda1c949671be87631255df355530da4efb745 (diff) | |
download | mariadb-git-32a62d506916c2f1ee34cb4494a10b66d1b4be2a.tar.gz |
Merge with 4.0 to revert patch for BIGINT assignment to double
Diffstat (limited to 'mysql-test/t/bigint.test')
-rw-r--r-- | mysql-test/t/bigint.test | 4 |
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; |