summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authormonty@mashka.mysql.fi <>2002-12-26 15:26:32 +0200
committermonty@mashka.mysql.fi <>2002-12-26 15:26:32 +0200
commit6153b24077c83ae2552e9e43350516c2ee8cc37d (patch)
treee47a6c8e245f6df14f550e1e408b415814f73fe6 /mysql-test
parent48e03169a48bf275b8d4266fd6f7c794da06650e (diff)
parent8f046a0195202652e27000b8ed43ed760fee20e8 (diff)
downloadmariadb-git-6153b24077c83ae2552e9e43350516c2ee8cc37d.tar.gz
merge
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/case.result4
1 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result
index e5fc7218c50..661ffa99f2c 100644
--- a/mysql-test/r/case.result
+++ b/mysql-test/r/case.result
@@ -63,7 +63,7 @@ nothing 2
one 1
two 1
drop table t1;
-drop table if exists t1;
+drop table if exists t;
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;
@@ -71,4 +71,4 @@ color
orange
yellow
green
-drop table if exists t1;
+drop table if exists t;