diff options
| author | unknown <monty@mashka.mysql.fi> | 2002-12-26 15:55:22 +0200 |
|---|---|---|
| committer | unknown <monty@mashka.mysql.fi> | 2002-12-26 15:55:22 +0200 |
| commit | ad22d0cbacd59f7dcac4ccc121486c614e609b93 (patch) | |
| tree | ef6694cd7850443a84092fad2ab87403436d801b /mysql-test/r/case.result | |
| parent | c00e5efc20041704b074f8f0186cd39c7f4420d3 (diff) | |
| download | mariadb-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/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index 661ffa99f2c..4c16b375400 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -63,7 +63,6 @@ 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; @@ -71,4 +70,4 @@ color orange yellow green -drop table if exists t; +drop table t1; |