diff options
| author | monty@mysql.com <> | 2005-04-30 03:14:42 +0300 |
|---|---|---|
| committer | monty@mysql.com <> | 2005-04-30 03:14:42 +0300 |
| commit | 129c604032af4b86f7bf23bb06f4223795f75b61 (patch) | |
| tree | 0f9fb389faa0f7571636772439feae0aabc53252 /mysql-test/t/bigint.test | |
| parent | 215be0264b55029cdacf4ae3b30dae3ec910ad8f (diff) | |
| download | mariadb-git-129c604032af4b86f7bf23bb06f4223795f75b61.tar.gz | |
Setting a variable to CAST(NULL as X) set the result type of the variable to X. (Bug #6598)
Diffstat (limited to 'mysql-test/t/bigint.test')
| -rw-r--r-- | mysql-test/t/bigint.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/bigint.test b/mysql-test/t/bigint.test index a26b78254e7..99c8a13d0b5 100644 --- a/mysql-test/t/bigint.test +++ b/mysql-test/t/bigint.test @@ -104,3 +104,13 @@ t2.value64=t1.value64; drop table t1, t2; +# +# 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; |