diff options
| author | unknown <monty@tik.mysql.fi> | 2002-04-22 23:41:55 +0300 |
|---|---|---|
| committer | unknown <monty@tik.mysql.fi> | 2002-04-22 23:41:55 +0300 |
| commit | 64cc56125791c5e3773399b6d3a40be81510b460 (patch) | |
| tree | 5dc206eb2d428094319bb8abc982cf65ac90ad8b /mysql-test/r/func_if.result | |
| parent | 0fe75f475d2eccea44ec854476401ea926439267 (diff) | |
| download | mariadb-git-64cc56125791c5e3773399b6d3a40be81510b460.tar.gz | |
New if tests
Diffstat (limited to 'mysql-test/r/func_if.result')
| -rw-r--r-- | mysql-test/r/func_if.result | 35 |
1 files changed, 35 insertions, 0 deletions
diff --git a/mysql-test/r/func_if.result b/mysql-test/r/func_if.result new file mode 100644 index 00000000000..64ee8c67def --- /dev/null +++ b/mysql-test/r/func_if.result @@ -0,0 +1,35 @@ +IF(0,"ERROR","this") IF(1,"is","ERROR") IF(NULL,"ERROR","a") IF(1,2,3)|0 IF(1,2.0,3.0)+0 +this is a 2 2.0 +s +a +A +a +aa +AA +aaa +BBB +s +a +A +a +aa +AA +aaa +BBB +s +A +AA +BBB +a +a +aa +aaa +s +A +AA +a +a +aa +aaa +sum(if(num is null,0.00,num)) +nan |