Sophie

Sophie

distrib > Mandriva > 2009.0 > i586 > by-pkgid > 50e207e3762cb571d9ee7d4fe7e2cdcc > files > 20

solidmysql-5.0.51-1mdv2009.0.src.rpm

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