diff options
| author | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-05-10 08:14:53 +0500 |
|---|---|---|
| committer | unknown <holyfoot/hf@mysql.com/hfmain.(none)> | 2007-05-10 08:14:53 +0500 |
| commit | a6da564a1d15925780f45d4bef439d4ae548f70d (patch) | |
| tree | 8fc0cc1fc8750bb40522a13dab9695341add40ac | |
| parent | f2a52dd0f021b02177c10443cb1ee6b7ad20281a (diff) | |
| download | mariadb-git-a6da564a1d15925780f45d4bef439d4ae548f70d.tar.gz | |
bug 27921 (Views ignore precision for CAST)
test result fixed
| -rw-r--r-- | mysql-test/r/cast.result | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 454a3766572..15fa05da384 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -103,7 +103,7 @@ Warnings: Warning 1292 Truncated incorrect DOUBLE value: 'a' select 10.0+cast('a' as decimal); 10.0+cast('a' as decimal) -10.00 +10.0 Warnings: Warning 1292 Truncated incorrect DECIMAL value: 'a' select 10E+0+'a'; @@ -386,7 +386,7 @@ 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 +1 2 3 4 5 DROP TABLE t1; select cast(NULL as decimal(6)) as t1; t1 |