diff options
| author | sergefp@mysql.com <> | 2005-06-20 11:43:38 +0200 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-06-20 11:43:38 +0200 |
| commit | ef85deab927e73be671d2adc6d0b2bf72e2909a4 (patch) | |
| tree | d7414859ad9adf0e5ac7dce1ff50a30b66e1b866 /mysql-test/t/case.test | |
| parent | 917276f2541fde10e117a3e785f2b38d30cdd37d (diff) | |
| download | mariadb-git-ef85deab927e73be671d2adc6d0b2bf72e2909a4.tar.gz | |
Fix for BUG#10151: In Item_func_case::find_item don't assume that parameter str != &(this->str_value)
Diffstat (limited to 'mysql-test/t/case.test')
| -rw-r--r-- | mysql-test/t/case.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test index 87e456baba7..ac60d7298ce 100644 --- a/mysql-test/t/case.test +++ b/mysql-test/t/case.test @@ -107,3 +107,14 @@ explain extended SELECT COALESCE('a' COLLATE latin1_bin,'b'); SHOW CREATE TABLE t1; DROP TABLE t1; + +# Test for BUG#10151 +SELECT 'case+union+test' +UNION +SELECT CASE LOWER('1') WHEN LOWER('2') THEN 'BUG' ELSE 'nobug' END; + +SELECT CASE LOWER('1') WHEN LOWER('2') THEN 'BUG' ELSE 'nobug' END; + +SELECT 'case+union+test' +UNION +SELECT CASE '1' WHEN '2' THEN 'BUG' ELSE 'nobug' END; |