diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-12-26 15:24:40 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-12-26 15:24:40 +0200 |
| commit | 868ed1135fb1501e69f58a4792fb04e822cf754a (patch) | |
| tree | e8d255f437217a5e54d09275814bf67574bf9340 /mysql-test/r/case.result | |
| parent | 62c7449a5594972f5e940bfdf8785a70f82af82c (diff) | |
| download | mariadb-git-868ed1135fb1501e69f58a4792fb04e822cf754a.tar.gz | |
Update of test results
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index 183e2692d7a..661ffa99f2c 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -63,7 +63,12 @@ nothing 2 one 1 two 1 drop table 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; color orange yellow green +drop table if exists t; |