diff options
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index 741c7ec360b..5c06ef89676 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -105,3 +105,14 @@ t2.value64=t1.value64; drop table t1, t2; # End of 4.1 tests + +# +# Test of CREATE ... SELECT and unsigned integers +# +create table t1 select 1 as 'a'; +show create table t1; +drop table t1; +create table t1 select 9223372036854775809 as 'a'; +show create table t1; +select * from t1; +drop table t1; |