summaryrefslogtreecommitdiff
path: root/mysql-test/r
diff options
context:
space:
mode:
authorunknown <monty@mysql.com>2004-03-12 09:15:08 +0200
committerunknown <monty@mysql.com>2004-03-12 09:15:08 +0200
commitf85032f16ec19832d75d0420f9d4d2b1bb01fc75 (patch)
treee7c9535543f97d8421abd43d67bf8d708b5468a5 /mysql-test/r
parent965158f28fa9527c62b3c316c458a8753a5da4e4 (diff)
downloadmariadb-git-f85032f16ec19832d75d0420f9d4d2b1bb01fc75.tar.gz
Portability fixes & fixing of test suite
mysql-test/r/func_math.result: Updated tests after merge with 3.23 mysql-test/r/multi_update.result: Fixed not portable test mysql-test/r/mysqlbinlog.result: Fixed test after push without doing 'make test' mysql-test/t/multi_update.test: Fixed not portable test sql/sql_parse.cc: Don't use static inline, as this is not portable
Diffstat (limited to 'mysql-test/r')
-rw-r--r--mysql-test/r/func_math.result3
-rw-r--r--mysql-test/r/multi_update.result20
-rw-r--r--mysql-test/r/mysqlbinlog.result8
3 files changed, 21 insertions, 10 deletions
diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
index 1b6a0d43738..04dabcb5481 100644
--- a/mysql-test/r/func_math.result
+++ b/mysql-test/r/func_math.result
@@ -59,9 +59,12 @@ ASIN(0.8+0.2)
SELECT ASIN(1.2-0.2);
ASIN(1.2-0.2)
1.570796
+select floor(log(4)/log(2));
floor(log(4)/log(2))
2
+select floor(log(8)/log(2));
floor(log(8)/log(2))
3
+select floor(log(16)/log(2));
floor(log(16)/log(2))
4
diff --git a/mysql-test/r/multi_update.result b/mysql-test/r/multi_update.result
index df24a1cfd58..12cb965f045 100644
--- a/mysql-test/r/multi_update.result
+++ b/mysql-test/r/multi_update.result
@@ -386,17 +386,17 @@ SELECT * from t2;
a
1
DROP TABLE t1,t2;
-create table `t1` ( `p_id` int(10) unsigned NOT NULL auto_increment, `p_code` varchar(20) NOT NULL default '', `p_created` datetime NOT NULL default '0000-00-00 00:00:00', `p_active` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`p_id`) );
-create table `t2` ( `c2_id` int(10) unsigned NULL auto_increment, `c2_p_id` int(10) unsigned NOT NULL default '0', `c2_note` text NOT NULL, `c2_created` datetime NOT NULL default '0000-00-00 00:00:00', `c2_active` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`c2_id`), KEY `c2_p_id` (`c2_p_id`) );
-insert into t1 values (0,'A01-Comp',now(),1);
-insert into t1 values (0,'B01-Comp',now(),1);
-insert into t2 values (0,1,'A Note',now(),1);
+create table `t1` (`p_id` int(10) unsigned NOT NULL auto_increment, `p_code` varchar(20) NOT NULL default '', `p_active` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`p_id`) );
+create table `t2` (`c2_id` int(10) unsigned NULL auto_increment, `c2_p_id` int(10) unsigned NOT NULL default '0', `c2_note` text NOT NULL, `c2_active` tinyint(1) unsigned NOT NULL default '1', PRIMARY KEY (`c2_id`), KEY `c2_p_id` (`c2_p_id`) );
+insert into t1 values (0,'A01-Comp',1);
+insert into t1 values (0,'B01-Comp',1);
+insert into t2 values (0,1,'A Note',1);
update t1 left join t2 on p_id = c2_p_id set c2_note = 'asdf-1' where p_id = 2;
select * from t1;
-p_id p_code p_created p_active
-1 A01-Comp 2004-03-11 23:21:29 1
-2 B01-Comp 2004-03-11 23:21:29 1
+p_id p_code p_active
+1 A01-Comp 1
+2 B01-Comp 1
select * from t2;
-c2_id c2_p_id c2_note c2_created c2_active
-1 1 A Note 2004-03-11 23:21:29 1
+c2_id c2_p_id c2_note c2_active
+1 1 A Note 1
drop table t1, t2;
diff --git a/mysql-test/r/mysqlbinlog.result b/mysql-test/r/mysqlbinlog.result
index df472eb9c80..79bf46280dd 100644
--- a/mysql-test/r/mysqlbinlog.result
+++ b/mysql-test/r/mysqlbinlog.result
@@ -14,6 +14,7 @@ insert into t1 values ("Alas");
flush logs;
--- Local --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
create table t1 (word varchar(20));
@@ -31,19 +32,23 @@ LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-4-0' INTO TABLE `t1` FI
LOAD DATA LOCAL INFILE 'MYSQL_TEST_DIR/var/tmp/words.dat-5-0' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '' (word);
--- Broken LOAD DATA --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
insert into t1 values ("Alas");
--- --database --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
SET INSERT_ID=1;
--- --position --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
insert into t1 values ("Alas");
--- Remote --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
create table t1 (word varchar(20));
@@ -64,14 +69,17 @@ SET TIMESTAMP=1000000000;
insert into t1 values ("Alas");
--- Broken LOAD DATA --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
insert into t1 values ("Alas");
--- --database --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
SET INSERT_ID=1;
--- --position --
+/*!40019 SET @@session.max_insert_delayed_threads=0*/;
use test;
SET TIMESTAMP=1000000000;
insert into t1 values ("Alas");