diff options
| author | unknown <igor@rurik.mysql.com> | 2005-06-15 08:39:00 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2005-06-15 08:39:00 -0700 |
| commit | 24de70926ea325dafe1c81aa64a6d86ed4ad85c3 (patch) | |
| tree | 73f29489128453f0db18442788c45626544ff71f /mysql-test/r/cast.result | |
| parent | 2ec50db87c1c46f575c82560d7935879e769da0e (diff) | |
| parent | 1575df007448a62bec690e6842cd576cc96a3cb5 (diff) | |
| download | mariadb-git-24de70926ea325dafe1c81aa64a6d86ed4ad85c3.tar.gz | |
Manual merge
sql/field.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/cast.result')
| -rw-r--r-- | mysql-test/r/cast.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 66a1a26ee95..1b5bdf98afd 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -344,6 +344,14 @@ select cast(s1 as decimal(7,2)) from t1; cast(s1 as decimal(7,2)) 111111.00 drop table t1; +CREATE TABLE t1 (v varchar(10), tt tinytext, t text, +mt mediumtext, lt longtext); +INSERT INTO t1 VALUES ('1.01', '2.02', '3.03', '4.04', '5.05'); +SELECT CAST(v AS DECIMAL), CAST(tt AS DECIMAL), CAST(t AS DECIMAL), +CAST(mt AS DECIMAL), CAST(lt AS DECIMAL) from t1; +CAST(v AS DECIMAL) CAST(tt AS DECIMAL) CAST(t AS DECIMAL) CAST(mt AS DECIMAL) CAST(lt AS DECIMAL) +1.01 2.02 3.03 4.04 5.05 +DROP TABLE t1; select cast(NULL as decimal(6)) as t1; t1 NULL |