diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2008-12-12 18:19:33 +0400 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2008-12-12 18:19:33 +0400 |
| commit | cd42f4ba2c259be32584ed3d3235ddfd6c3f3612 (patch) | |
| tree | 8e2b50c43c7ee0afb0bd084fdac4a80810124664 /mysql-test/r/func_if.result | |
| parent | 749847686ceb2dd5a04d030bb35c84af2332678f (diff) | |
| parent | af5cf536bc5246e49a4874a225931a838659cae0 (diff) | |
| download | mariadb-git-cd42f4ba2c259be32584ed3d3235ddfd6c3f3612.tar.gz | |
auto merge 5.0-bugteam --> 5.1-bugteam (bug 40761)
Diffstat (limited to 'mysql-test/r/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index 62d34c5ce8f..955a784f04c 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -176,4 +176,13 @@ IF((ROUND(t1.a,2)=1), 2, IF((ROUND(t1.a,2)=1), 2, IF((R DROP TABLE t1; +CREATE TABLE t1 (c LONGTEXT); +INSERT INTO t1 VALUES(1), (2), (3), (4), ('12345678901234567890'); +SELECT * FROM (SELECT MAX(IF(1, CAST(c AS UNSIGNED), 0)) FROM t1) AS te; +MAX(IF(1, CAST(c AS UNSIGNED), 0)) +12345678901234567890 +SELECT * FROM (SELECT MAX(IFNULL(CAST(c AS UNSIGNED), 0)) FROM t1) AS te; +MAX(IFNULL(CAST(c AS UNSIGNED), 0)) +12345678901234567890 +DROP TABLE t1; End of 5.0 tests |