From 0ceaf6d2c28f4f639a0ba5c329964e4dbe71cb7f Mon Sep 17 00:00:00 2001 From: unknown 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 Docs/manual.texi: Update of TRUNCATE() information configure.in: Fix for HPUX extra/resolveip.c: Fix for SCO include/my_net.h: Fix for HPUX libmysql/libmysql.c: Removed warning on HPUX 10.20 mysql-test/r/func_math.result: Test of new TRUNCATE handling mysql-test/t/func_math.test: Test of new TRUNCATE handling mysys/my_gethostbyname.c: Portability fix sql/item_func.cc: Change TRUNCATE(number) to truncate towards zero for negative numbers sql/sql_show.cc: 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 169a4d9282b6186dd41419ba396b2aaaf4d04a2b Mon Sep 17 00:00:00 2001 From: unknown Date: Fri, 31 May 2002 16:56:02 -0700 Subject: fixed 'load table from master' hang when host is empty added respective test case sql/slave.cc: fixed load table from master hang when host is empty --- 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