diff options
author | monty@mashka.mysql.fi <> | 2002-12-26 15:26:32 +0200 |
---|---|---|
committer | monty@mashka.mysql.fi <> | 2002-12-26 15:26:32 +0200 |
commit | 6153b24077c83ae2552e9e43350516c2ee8cc37d (patch) | |
tree | e47a6c8e245f6df14f550e1e408b415814f73fe6 /mysql-test | |
parent | 48e03169a48bf275b8d4266fd6f7c794da06650e (diff) | |
parent | 8f046a0195202652e27000b8ed43ed760fee20e8 (diff) | |
download | mariadb-git-6153b24077c83ae2552e9e43350516c2ee8cc37d.tar.gz |
merge
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/case.result | 4 |
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; |