diff options
author | sergefp@mysql.com <> | 2005-06-23 19:05:36 +0200 |
---|---|---|
committer | sergefp@mysql.com <> | 2005-06-23 19:05:36 +0200 |
commit | f1085fb3bef15ffc49d01b7b7ab93f0e44efa15d (patch) | |
tree | e0afc2c296413ff6fa8f5eea640a265be1b2cc77 /mysql-test/r/case.result | |
parent | 7e7987eed9fcae293e24bc204ca30c3a4582902e (diff) | |
parent | ef85deab927e73be671d2adc6d0b2bf72e2909a4 (diff) | |
download | mariadb-git-f1085fb3bef15ffc49d01b7b7ab93f0e44efa15d.tar.gz |
Merge
Diffstat (limited to 'mysql-test/r/case.result')
-rw-r--r-- | mysql-test/r/case.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index a854cf4c7b0..b02f85132aa 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -160,6 +160,21 @@ t1 CREATE TABLE `t1` ( `COALESCE('a' COLLATE latin1_bin,'b')` varchar(1) character set latin1 collate latin1_bin NOT NULL default '' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1; +SELECT 'case+union+test' +UNION +SELECT CASE LOWER('1') WHEN LOWER('2') THEN 'BUG' ELSE 'nobug' END; +case+union+test +case+union+test +nobug +SELECT CASE LOWER('1') WHEN LOWER('2') THEN 'BUG' ELSE 'nobug' END; +CASE LOWER('1') WHEN LOWER('2') THEN 'BUG' ELSE 'nobug' END +nobug +SELECT 'case+union+test' +UNION +SELECT CASE '1' WHEN '2' THEN 'BUG' ELSE 'nobug' END; +case+union+test +case+union+test +nobug CREATE TABLE t1 (EMPNUM INT); INSERT INTO t1 VALUES (0), (2); CREATE TABLE t2 (EMPNUM DECIMAL (4, 2)); |