summaryrefslogtreecommitdiff
path: root/mysql-test/r/bigint.result
diff options
context:
space:
mode:
authormonty@mysql.com <>2003-11-21 00:11:50 +0200
committermonty@mysql.com <>2003-11-21 00:11:50 +0200
commit41eda1c949671be87631255df355530da4efb745 (patch)
tree4cd9739fe1fd00afa4e9117b8d45599375b500cb /mysql-test/r/bigint.result
parentdd287a4cdf4b8937ce428678fa096134a5ae8a88 (diff)
downloadmariadb-git-41eda1c949671be87631255df355530da4efb745.tar.gz
Revert patch for bigint handling in double context as it broke normal bigint handling
The right way to fix this is to change the Field::store(longlong) method to be Field::store(longlong, bool unsigned_flag), but this is better to do in 4.1 than in 4.0
Diffstat (limited to 'mysql-test/r/bigint.result')
-rw-r--r--mysql-test/r/bigint.result8
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result
index 2b595c2b83d..308adc881f2 100644
--- a/mysql-test/r/bigint.result
+++ b/mysql-test/r/bigint.result
@@ -15,9 +15,11 @@ select 9223372036854775808+1;
9223372036854775809
drop table if exists t1;
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;
@@ -26,6 +28,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 );
@@ -69,9 +73,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;