diff options
| author | unknown <monty@hundin.mysql.fi> | 2002-04-26 08:56:28 +0300 |
|---|---|---|
| committer | unknown <monty@hundin.mysql.fi> | 2002-04-26 08:56:28 +0300 |
| commit | cacfcb6404da497b14fa8484f15ca3832cce8adb (patch) | |
| tree | 7412d050274815c36a164eb72d690b8871014e84 /mysql-test/r/func_test.result | |
| parent | 18e6569769a62d8d6e1e50670658aee139960181 (diff) | |
| download | mariadb-git-cacfcb6404da497b14fa8484f15ca3832cce8adb.tar.gz | |
Portability fixes
myisam/ft_boolean_search.c:
Portability fix
mysql-test/mysql-test-run.sh:
Added slave_net_timeout
mysql-test/r/func_if.result:
Updated results after merge from 3.23
mysql-test/r/func_test.result:
Updated results after merge from 3.23
mysql-test/r/innodb.result:
Updated results after merge from 3.23
mysql-test/r/show_check.result:
Updated results after merge from 3.23
mysql-test/r/variables.result:
Updated results after merge from 3.23
Diffstat (limited to 'mysql-test/r/func_test.result')
| -rw-r--r-- | mysql-test/r/func_test.result | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/mysql-test/r/func_test.result b/mysql-test/r/func_test.result index 0a45f9e8b5c..deea5b8bb8b 100644 --- a/mysql-test/r/func_test.result +++ b/mysql-test/r/func_test.result @@ -28,9 +28,6 @@ select "aba" regexp concat("^","a"); select !0,NOT 0=1,!(0=0),1 AND 1,1 && 0,0 OR 1,1 || NULL, 1=1 or 1=1 and 1=0; !0 NOT 0=1 !(0=0) 1 AND 1 1 && 0 0 OR 1 1 || NULL 1=1 or 1=1 and 1=0 1 1 0 1 0 1 1 1 -select IF(0,"ERROR","this"),IF(1,"is","ERROR"),IF(NULL,"ERROR","a"),IF(1,2,3)|0,IF(1,2.0,3.0)+0 ; -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 select 2 between 1 and 3, "monty" between "max" and "my",2=2 and "monty" between "max" and "my" and 3=3; 2 between 1 and 3 "monty" between "max" and "my" 2=2 and "monty" between "max" and "my" and 3=3 1 1 1 @@ -52,10 +49,3 @@ select 1 and 2 between 2 and 10, 2 between 2 and 10 and 1; select 1 and 0 or 2, 2 or 1 and 0; 1 and 0 or 2 2 or 1 and 0 1 1 -drop table if exists t1; -create table t1 (num double(12,2)); -insert into t1 values (144.54); -select sum(if(num is null,0.00,num)) from t1; -sum(if(num is null,0.00,num)) -144.54 -drop table t1; |