diff options
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test new file mode 100644 index 00000000000..91997c811b5 --- /dev/null +++ b/mysql-test/t/bigint.test @@ -0,0 +1,14 @@ +# +# Test of reading of bigint values +# +select 0,256,00000000000000065536,2147483647,-2147483648,2147483648,+4294967296; +select 922337203685477580,92233720368547758000; +select -922337203685477580,-92233720368547758000; +select 9223372036854775807,-009223372036854775808; +select +9999999999999999999,-9999999999999999999; + +drop table if exists t1; +create table t1 (a bigint unsigned); +insert into t1 values (18446744073709551615), (0xFFFFFFFFFFFFFFFF); +select * from t1; +drop table t1; |