diff -Naurp mysql-5.0.51/mysql-test/t/bigint.test mysql-5.0.51.oden/mysql-test/t/bigint.test --- mysql-5.0.51/mysql-test/t/bigint.test 2007-11-15 15:28:37.000000000 +0100 +++ mysql-5.0.51.oden/mysql-test/t/bigint.test 2008-01-25 14:27:29.000000000 +0100 @@ -113,6 +113,15 @@ t2.value64=t1.value64; drop table t1, t2; +# Test for BUG#30069, can't handle bigint -9223372036854775808 on +# x86_64, with some GCC versions and optimizations. + +create table t1 (sint64 bigint not null); +insert into t1 values (-9223372036854775808); +select * from t1; + +drop table t1; + # End of 4.1 tests # diff -Naurp mysql-5.0.51/mysql-test/r/bigint.result mysql-5.0.51.oden/mysql-test/r/bigint.result --- mysql-5.0.51/mysql-test/r/bigint.result 2007-11-15 15:28:37.000000000 +0100 +++ mysql-5.0.51.oden/mysql-test/r/bigint.result 2008-01-25 14:30:19.000000000 +0100 @@ -170,6 +170,12 @@ t2.value64=t1.value64; value64 value32 value64 value32 9223372036854775807 2 9223372036854775807 4 drop table t1, t2; +create table t1 (sint64 bigint not null); +insert into t1 values (-9223372036854775808); +select * from t1; +sint64 +-9223372036854775808 +drop table t1; create table t1 select 1 as 'a'; show create table t1; Table Create Table