diff options
author | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-11-06 15:04:58 +0400 |
---|---|---|
committer | unknown <holyfoot/hf@mysql.com/deer.(none)> | 2006-11-06 15:04:58 +0400 |
commit | f9c6368e485b3d7760e5ba9747f2f767bb96d4ad (patch) | |
tree | 29329cee572f5684d5b573e083d1e0188ec087d4 /mysql-test | |
parent | 10dd1a371d7c5b99f965ca0bde409baadc772240 (diff) | |
parent | c0c56d13aa8fafee9ca288d6ca7ef194a96ca24f (diff) | |
download | mariadb-git-f9c6368e485b3d7760e5ba9747f2f767bb96d4ad.tar.gz |
Merge bk@192.168.21.1:mysql-5.0-opt
into mysql.com:/home/hf/work/8663/my50-8663
mysql-test/r/type_newdecimal.result:
merging
mysql-test/t/type_newdecimal.test:
merging
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/type_newdecimal.result | 5 | ||||
-rw-r--r-- | mysql-test/t/type_newdecimal.test | 6 |
2 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/r/type_newdecimal.result b/mysql-test/r/type_newdecimal.result index 23e6f8266e9..5d2344da053 100644 --- a/mysql-test/r/type_newdecimal.result +++ b/mysql-test/r/type_newdecimal.result @@ -1420,3 +1420,8 @@ f1 20101112000000.000014 101112.000000 drop table t1; +select cast(19999999999999999999 as unsigned); +cast(19999999999999999999 as unsigned) +18446744073709551615 +Warnings: +Error 1292 Truncated incorrect DECIMAL value: '' diff --git a/mysql-test/t/type_newdecimal.test b/mysql-test/t/type_newdecimal.test index 12da41dcfd5..bcde018cfc2 100644 --- a/mysql-test/t/type_newdecimal.test +++ b/mysql-test/t/type_newdecimal.test @@ -1109,10 +1109,14 @@ select i, count(distinct j) from t1 group by i; select i+0.0 as i2, count(distinct j) from t1 group by i2; drop table t1; - create table t1(f1 decimal(20,6)); insert into t1 values (CAST('10:11:12' AS date) + interval 14 microsecond); insert into t1 values (CAST('10:11:12' AS time)); select * from t1; drop table t1; +# +# Bug #8663 (cant use bigint as input to CAST) +# +select cast(19999999999999999999 as unsigned); + |