diff options
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index a95975f1097..eb6ce7d1752 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -227,3 +227,7 @@ 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; |