From e2a116411e7b293b5d0d920c8a94794dd75dd334 Mon Sep 17 00:00:00 2001
From: "monty@hundin.mysql.fi" <>
Date: Fri, 31 May 2002 15:22:38 +0300
Subject: Portability fixes for SCO and HPUX Change TRUNCATE(number) to
 truncate towards zero for negative numbers Fix NULL handling for DESCRIBE
 table_name

---
 mysql-test/r/func_math.result | 4 ++--
 mysql-test/t/func_math.test   | 2 +-
 2 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'mysql-test')

diff --git a/mysql-test/r/func_math.result b/mysql-test/r/func_math.result
index cee67a3e25c..e2723311682 100644
--- a/mysql-test/r/func_math.result
+++ b/mysql-test/r/func_math.result
@@ -2,8 +2,8 @@ floor(5.5)	floor(-5.5)
 5	-6
 ceiling(5.5)	ceiling(-5.5)
 6	-5
-truncate(52.64,1)	truncate(52.64,2)	truncate(52.64,-1)	truncate(52.64,-2)
-52.6	52.64	50	0
+truncate(52.64,1)	truncate(52.64,2)	truncate(52.64,-1)	truncate(52.64,-2)	truncate(-52.64,1)	truncate(-52.64,-1)
+52.6	52.64	50	0	-52.6	-50
 round(5.5)	round(-5.5)
 6	-6
 round(5.64,1)	round(5.64,2)	round(5.64,-1)	round(5.64,-2)
diff --git a/mysql-test/t/func_math.test b/mysql-test/t/func_math.test
index ab7990eea79..5299897d0f0 100644
--- a/mysql-test/t/func_math.test
+++ b/mysql-test/t/func_math.test
@@ -4,7 +4,7 @@
 
 select floor(5.5),floor(-5.5);
 select ceiling(5.5),ceiling(-5.5);
-select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2);
+select truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2), truncate(-52.64,1),truncate(-52.64,-1);
 select round(5.5),round(-5.5);
 select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2);
 select abs(-10), sign(-5), sign(5), sign(0);
-- 
cgit v1.2.1


From fc52e079d07b7fdf9d5768303b58b63275c1475d Mon Sep 17 00:00:00 2001
From: "nick@nick.leippe.com" <>
Date: Fri, 31 May 2002 16:56:02 -0700
Subject: fixed 'load table from master' hang when host is empty added
 respective test case

---
 mysql-test/r/rpl_empty_master_crash.result | 2 ++
 mysql-test/t/rpl_empty_master_crash.test   | 8 ++++++++
 2 files changed, 10 insertions(+)
 create mode 100644 mysql-test/r/rpl_empty_master_crash.result
 create mode 100644 mysql-test/t/rpl_empty_master_crash.test

(limited to 'mysql-test')

diff --git a/mysql-test/r/rpl_empty_master_crash.result b/mysql-test/r/rpl_empty_master_crash.result
new file mode 100644
index 00000000000..e9111fdb401
--- /dev/null
+++ b/mysql-test/r/rpl_empty_master_crash.result
@@ -0,0 +1,2 @@
+Master_Host	Master_User	Master_Port	Connect_retry	Log_File	Pos	Slave_Running	Replicate_do_db	Replicate_ignore_db	Last_errno	Last_error	Skip_counter
+		0	0		0	No			0		0
diff --git a/mysql-test/t/rpl_empty_master_crash.test b/mysql-test/t/rpl_empty_master_crash.test
new file mode 100644
index 00000000000..7c4437a3657
--- /dev/null
+++ b/mysql-test/t/rpl_empty_master_crash.test
@@ -0,0 +1,8 @@
+source include/master-slave.inc;
+connection master;
+use test;
+drop table if exists t1;
+show slave status;
+#--error 1218 # for mysql-4.0
+--error 1042
+load table t1 from master;
-- 
cgit v1.2.1