diff options
| author | unknown <ramil/ram@ramil.myoffice.izhnet.ru> | 2007-10-29 13:16:26 +0400 |
|---|---|---|
| committer | unknown <ramil/ram@ramil.myoffice.izhnet.ru> | 2007-10-29 13:16:26 +0400 |
| commit | 30dab869ec370cb4850fab853fb8dde6380d4b17 (patch) | |
| tree | 82d1286179fdd8dc0b04ae78c05b66ba0bb938e6 /mysql-test/r/case.result | |
| parent | 3aaffef2c6307e7b3e8879a456bcabd0454183c2 (diff) | |
| parent | 42894ed0b870f4adfc6023404877732a08b1ec22 (diff) | |
| download | mariadb-git-30dab869ec370cb4850fab853fb8dde6380d4b17.tar.gz | |
Merge mysql.com:/home/ram/work/b30782/b30782.5.0
into mysql.com:/home/ram/work/b30782/b30782.5.1
sql/item_cmpfunc.cc:
Auto merged
mysql-test/r/case.result:
manual merge.
mysql-test/t/case.test:
manual merge.
sql/item_cmpfunc.h:
manual merge.
Diffstat (limited to 'mysql-test/r/case.result')
| -rw-r--r-- | mysql-test/r/case.result | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/mysql-test/r/case.result b/mysql-test/r/case.result index 9ee64ee6dbd..d408a0b6153 100644 --- a/mysql-test/r/case.result +++ b/mysql-test/r/case.result @@ -1,4 +1,4 @@ -drop table if exists t1,t2; +drop table if exists t1, t2; select CASE "b" when "a" then 1 when "b" then 2 END; CASE "b" when "a" then 1 when "b" then 2 END 2 @@ -200,3 +200,21 @@ CEMPNUM EMPMUM1 EMPNUM2 0.00 0 0.00 2.00 2 NULL DROP TABLE t1,t2; +End of 4.1 tests +create table t1 (a int, b bigint unsigned); +create table t2 (c int); +insert into t1 (a, b) values (1,4572794622775114594), (2,18196094287899841997), +(3,11120436154190595086); +insert into t2 (c) values (1), (2), (3); +select t1.a, (case t1.a when 0 then 0 else t1.b end) d from t1 +join t2 on t1.a=t2.c order by d; +a d +1 4572794622775114594 +3 11120436154190595086 +2 18196094287899841997 +select t1.a, (case t1.a when 0 then 0 else t1.b end) d from t1 +join t2 on t1.a=t2.c where b=11120436154190595086 order by d; +a d +3 11120436154190595086 +drop table t1, t2; +End of 5.0 tests |