diff options
| author | Gleb Shchepa <gshchepa@mysql.com> | 2008-12-12 15:13:11 +0400 |
|---|---|---|
| committer | Gleb Shchepa <gshchepa@mysql.com> | 2008-12-12 15:13:11 +0400 |
| commit | 749847686ceb2dd5a04d030bb35c84af2332678f (patch) | |
| tree | 186a712bab08112017b7d95af55abc0a8847fea6 /mysql-test | |
| parent | a4467c97981714631deef5685d6d2f790e877695 (diff) | |
| parent | 5ff1bcbc2a3cf3b28ce11673d89a1d2b3d8ad376 (diff) | |
| download | mariadb-git-749847686ceb2dd5a04d030bb35c84af2332678f.tar.gz | |
rollback of bug #40761 fix
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/func_if.result | 9 | ||||
| -rw-r--r-- | mysql-test/t/func_if.test | 13 |
2 files changed, 0 insertions, 22 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result index 955a784f04c..62d34c5ce8f 100644 --- a/mysql-test/r/func_if.result +++ b/mysql-test/r/func_if.result @@ -176,13 +176,4 @@ 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 diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test index 68728d6697e..8da10f36cbe 100644 --- a/mysql-test/t/func_if.test +++ b/mysql-test/t/func_if.test @@ -150,17 +150,4 @@ FROM t1; DROP TABLE t1; -# -# Bug #40761: Assert on sum func on IF(..., CAST(longtext AS UNSIGNED), signed) -# (was: LEFT JOIN on inline view crashes server) -# - -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; -SELECT * FROM (SELECT MAX(IFNULL(CAST(c AS UNSIGNED), 0)) FROM t1) AS te; - -DROP TABLE t1; - --echo End of 5.0 tests |