diff options
| author | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-09 23:14:02 +0300 |
|---|---|---|
| committer | unknown <Sinisa@sinisa.nasamreza.org> | 2002-08-09 23:14:02 +0300 |
| commit | 9d7b069cd5cbbafa73a8297688d94dd3d5498174 (patch) | |
| tree | 6798f91768273fd1b7f7f80760084855d64d2523 /mysql-test/t | |
| parent | 1d4594ecb130bb0c5fb191699ce3aa89c396577f (diff) | |
| download | mariadb-git-9d7b069cd5cbbafa73a8297688d94dd3d5498174.tar.gz | |
A change in IF behaviour that several users asked for ...
Diffstat (limited to 'mysql-test/t')
| -rw-r--r-- | mysql-test/t/func_if.test | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/mysql-test/t/func_if.test b/mysql-test/t/func_if.test index c5cc73ecd1f..85553d1a2fd 100644 --- a/mysql-test/t/func_if.test +++ b/mysql-test/t/func_if.test @@ -28,3 +28,7 @@ create table t1 (num double(12,2)); insert into t1 values (144.54); select sum(if(num is null,0.00,num)) from t1; drop table t1; +create table t1 (x int, y int); +insert into t1 values (0,6),(10,16),(20,26),(30,10),(40,46),(50,56); +select min(if(y -x > 5,y,NULL)), max(if(y - x > 5,y,NULL)) from t1; +drop table t1; |