summaryrefslogtreecommitdiff
path: root/mysql-test/t/case.test
diff options
context:
space:
mode:
authorunknown <monty@mashka.mysql.fi>2002-12-26 15:55:22 +0200
committerunknown <monty@mashka.mysql.fi>2002-12-26 15:55:22 +0200
commitad22d0cbacd59f7dcac4ccc121486c614e609b93 (patch)
treeef6694cd7850443a84092fad2ab87403436d801b /mysql-test/t/case.test
parentc00e5efc20041704b074f8f0186cd39c7f4420d3 (diff)
downloadmariadb-git-ad22d0cbacd59f7dcac4ccc121486c614e609b93.tar.gz
Test cleanup
mysql-test/r/case.result: Removed unnecessary drop commands mysql-test/t/case.test: Removed unnecessary drop commands
Diffstat (limited to 'mysql-test/t/case.test')
-rw-r--r--mysql-test/t/case.test8
1 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/t/case.test b/mysql-test/t/case.test
index b5a1a60f15b..3ba3a292c77 100644
--- a/mysql-test/t/case.test
+++ b/mysql-test/t/case.test
@@ -30,8 +30,12 @@ insert into t1 values(1),(2),(3),(4);
select case a when 1 then 2 when 2 then 3 else 0 end as fcase, count(*) from t1 group by fcase;
select case a when 1 then "one" when 2 then "two" else "nothing" end as fcase, count(*) from t1 group by fcase;
drop table t1;
-drop table if exists t1;
+
+#
+# Test MAX(CASE ... ) that can return null
+#
+
create table t1 (row int not null, col int not null, val varchar(255) not null);
insert into t1 values (1,1,'orange'),(1,2,'large'),(2,1,'yellow'),(2,2,'medium'),(3,1,'green'),(3,2,'small');
select max(case col when 1 then val else null end) as color from t1 group by row;
-drop table if exists t1;
+drop table t1;