diff options
| author | unknown <monty@mysql.com> | 2003-11-21 00:17:46 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2003-11-21 00:17:46 +0200 |
| commit | ed63732bb3068a482aad6c89f08879973c8beaea (patch) | |
| tree | cc5b75d68dbc553175309599add32578e09f425d /mysql-test/r/bigint.result | |
| parent | 411b610e7169405ba1fbd8d3c8d4d30fb204dd14 (diff) | |
| parent | 7c6ed734438fe7f473c045f89ae8d2b1dce8c4b6 (diff) | |
| download | mariadb-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/r/bigint.result')
| -rw-r--r-- | mysql-test/r/bigint.result | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index 3d02a32e4a4..4c6e1645451 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -18,9 +18,11 @@ select -(0-3),round(-(0-3)), round(9999999999999999999); -(0-3) round(-(0-3)) round(9999999999999999999) 3 3 10000000000000000000 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; a +18446744073709551612 +18446744073709551613 18446744073709551614 18446744073709551615 select * from t1 where a=18446744073709551615; @@ -29,6 +31,8 @@ a delete from t1 where a=18446744073709551615; select * from t1; a +18446744073709551612 +18446744073709551613 18446744073709551614 drop table t1; create table t1 ( a int not null default 1, big bigint ); @@ -72,9 +76,11 @@ id a drop table t1; 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; quantity +-8446744073709551616 10000000000000000000 10000000000000000000 drop table t1; |