summaryrefslogtreecommitdiff
path: root/mysql-test/r/case.result
diff options
context:
space:
mode:
authorunknown <aelkin@mysql.com>2006-04-25 20:05:15 +0300
committerunknown <aelkin@mysql.com>2006-04-25 20:05:15 +0300
commit3b6263b88cbb91c38f4fcec86a5d19de604855d4 (patch)
tree96bcefe1c6d26a68dfcb4305fbf1b8de217283e4 /mysql-test/r/case.result
parent1e869b0e58207ad3d1bb992b4aa164234a71066e (diff)
parentd00a6cf46c63576abf3d0682af752ab53e3876fd (diff)
downloadmariadb-git-3b6263b88cbb91c38f4fcec86a5d19de604855d4.tar.gz
Merge mysql.com:/home/elkin/MySQL/BARE/5.0
into mysql.com:/home/elkin/MySQL/MERGE/5.1-new mysql-test/mysql-test-run.pl: Auto merged mysql-test/r/case.result: Auto merged mysql-test/r/rpl_temporary.result: Auto merged mysql-test/t/case.test: Auto merged mysql-test/t/rpl_temporary.test: Auto merged sql/item_cmpfunc.cc: Auto merged sql/item_strfunc.cc: Auto merged storage/myisam/myisam_ftdump.c: Auto merged sql/sql_base.cc: manual merge use local. Another changeset for 5.1 is following.
Diffstat (limited to 'mysql-test/r/case.result')
-rw-r--r--mysql-test/r/case.result8
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result
index d28c3af4e0b..9d2706f64fa 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));