diff options
| author | knielsen@mysql.com <> | 2006-04-24 23:51:47 +0200 |
|---|---|---|
| committer | knielsen@mysql.com <> | 2006-04-24 23:51:47 +0200 |
| commit | 854cbe88b62a5ca0529ce8d7d18a71a967ba4641 (patch) | |
| tree | c36acaddf0636985ab3b939b2bbad6b73d79d9c4 /mysql-test/r/case.result | |
| parent | 497b91d60d353dc72e3f0da49b9a81e26e247e4f (diff) | |
| parent | 17a80c9da4b70af717c5620445f0275c824be47f (diff) | |
| download | mariadb-git-854cbe88b62a5ca0529ce8d7d18a71a967ba4641.tar.gz | |
Merge mysql.com:/usr/local/mysql/mysql-4.1
into mysql.com:/usr/local/mysql/mysql-5.0-mtr-fix
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index ea80695ad7b..8349d6e9338 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -175,6 +175,14 @@ SELECT CASE '1' WHEN '2' THEN 'BUG' ELSE 'nobug' END; case+union+test case+union+test nobug +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; +min(a) min(case when 1=1 then a else NULL end) min(case when 1!=1 then NULL else a end) +2 2 2 +drop table t1; CREATE TABLE t1 (EMPNUM INT); INSERT INTO t1 VALUES (0), (2); CREATE TABLE t2 (EMPNUM DECIMAL (4, 2)); |