diff options
| author | unknown <knielsen@mysql.com> | 2006-04-24 23:51:47 +0200 |
|---|---|---|
| committer | unknown <knielsen@mysql.com> | 2006-04-24 23:51:47 +0200 |
| commit | 413256c814ad5099b07540bd064a83e37c09f24f (patch) | |
| tree | c36acaddf0636985ab3b939b2bbad6b73d79d9c4 /mysql-test/t/case.test | |
| parent | 3e1ff238a7b67d04e721c3c89a7ccce57b0ea507 (diff) | |
| parent | f9216cdf8d40c0552382fd0788d03dc20db2d94c (diff) | |
| download | mariadb-git-413256c814ad5099b07540bd064a83e37c09f24f.tar.gz | |
Merge mysql.com:/usr/local/mysql/mysql-4.1
into mysql.com:/usr/local/mysql/mysql-5.0-mtr-fix
mysql-test/mysql-test-run.pl:
Auto merged
mysql-test/t/case.test:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
mysql-test/r/case.result:
SCCS merged
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 555e34d5cf2..fbe1ee2b8c8 100644 --- a/mysql-test/t/case.test +++ b/mysql-test/t/case.test @@ -122,6 +122,17 @@ SELECT 'case+union+test' UNION SELECT CASE '1' WHEN '2' THEN 'BUG' ELSE 'nobug' END; +# +# Bug #17896: problem with MIN(CASE...) +# + +create table t1(a float, b int default 3); +insert into t1 (a) values (2), (11), (8); +select min(a), min(case when 1=1 then a else NULL end), + min(case when 1!=1 then NULL else a end) +from t1 where b=3 group by b; +drop table t1; + # End of 4.1 tests |