diff options
| author | unknown <kent@mysql.com/kent-amd64.(none)> | 2007-11-12 12:52:03 +0100 |
|---|---|---|
| committer | unknown <kent@mysql.com/kent-amd64.(none)> | 2007-11-12 12:52:03 +0100 |
| commit | 568f624406fb6771f5815bbe6184de6909270488 (patch) | |
| tree | 37f84794d03b6e651b90b584ba2ef2668dfd529a | |
| parent | 5c04a99e2afda8c6fddb2572cd6f9e975aa52238 (diff) | |
| download | mariadb-git-568f624406fb6771f5815bbe6184de6909270488.tar.gz | |
bigint.test, bigint.result:
Test case for Bug#30069
mysql-test/r/bigint.result:
Test case for Bug#30069
mysql-test/t/bigint.test:
Test case for Bug#30069
| -rw-r--r-- | mysql-test/r/bigint.result | 6 | ||||
| -rw-r--r-- | mysql-test/t/bigint.test | 9 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index e9a457c9dfa..a73342e1f7d 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -135,3 +135,9 @@ 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; diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 8a238d33e08..e5cd70209ea 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -107,4 +107,13 @@ 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 |