diff options
| -rw-r--r-- | mysql-test/r/bigint.result | 10 | ||||
| -rw-r--r-- | mysql-test/t/bigint.test | 5 |
2 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/bigint.result b/mysql-test/r/bigint.result index d8f78cd5103..7d105cae19d 100644 --- a/mysql-test/r/bigint.result +++ b/mysql-test/r/bigint.result @@ -352,3 +352,13 @@ select c1 mod 50 as result from t1; result 6 drop table t1; +select -9223372036854775808 bi; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def bi 8 20 20 N 32897 0 63 +bi +-9223372036854775808 +select -9223372036854775809 bi; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def bi 246 20 20 N 129 0 63 +bi +-9223372036854775809 diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 6c1229db83f..47e3df74a7e 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -288,3 +288,8 @@ insert into t1 values (10000002383263201056); select c1 mod 50 as result from t1; drop table t1; +# Bug #28005 Partitions: can't use -9223372036854775808 +--enable_metadata +select -9223372036854775808 bi; +select -9223372036854775809 bi; +--disable_metadata |