diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2012-08-27 18:13:17 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2012-08-27 18:13:17 +0200 |
| commit | 9a64d0794c3dce1652839820350a8c4b9b510e99 (patch) | |
| tree | 33ebd07354a15944288a071bd9319dfa34f226ef /mysql-test/r/case.result | |
| parent | ced3907c02dfa3b237e14d79aa800b3a0769e94a (diff) | |
| parent | e988c4dde6c1b88523b1d4e748cbd4f5025b128d (diff) | |
| download | mariadb-git-9a64d0794c3dce1652839820350a8c4b9b510e99.tar.gz | |
5.3 merge
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index eb6ce7d1752..3852da5d4b0 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -220,6 +220,10 @@ a d 3 11120436154190595086 drop table t1, t2; End of 5.0 tests +CREATE TABLE t1(a YEAR); +SELECT 1 FROM t1 WHERE a=1 AND CASE 1 WHEN a THEN 1 ELSE 1 END; +1 +DROP TABLE t1; create table t1 (f1 time); insert t1 values ('00:00:00'),('00:01:00'); select case t1.f1 when '00:00:00' then 1 end from t1; @@ -227,7 +231,3 @@ case t1.f1 when '00:00:00' then 1 end 1 NULL drop table t1; -CREATE TABLE t1(a YEAR); -SELECT 1 FROM t1 WHERE a=1 AND CASE 1 WHEN a THEN 1 ELSE 1 END; -1 -DROP TABLE t1; |