--- mysql-5.1/mysql-test/t/func_math.test 2007-05-08 12:26:06.000000000 +0200 +++ mysql-5.1-truncate/mysql-test/t/func_math.test 2007-05-08 16:08:07.000000000 +0200 @@ -10,8 +10,8 @@ explain extended select floor(5.5),floor(-5.5); select ceiling(5.5),ceiling(-5.5); explain extended select ceiling(5.5),ceiling(-5.5); -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); -explain extended 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 truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2), truncate(-52.64,1),truncate(-52.64,-1),truncate(52.64),truncate(-52.64); +explain extended 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),truncate(52.64),truncate(-52.64); select round(5.5),round(-5.5); explain extended select round(5.5),round(-5.5); select round(5.64,1),round(5.64,2),round(5.64,-1),round(5.64,-2); diff -x .bzr -urN mysql-5.1/mysql-test/r/func_math.result mysql-5.1-truncate/mysql-test/r/func_math.result --- mysql-5.1/mysql-test/r/func_math.result 2007-05-08 12:26:03.000000000 +0200 +++ mysql-5.1-truncate/mysql-test/r/func_math.result 2007-05-08 16:08:36.000000000 +0200 @@ -15,14 +15,14 @@ 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: Note 1003 select ceiling(5.5) AS `ceiling(5.5)`,ceiling(-(5.5)) AS `ceiling(-5.5)` -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); -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 -explain extended 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 truncate(52.64,1),truncate(52.64,2),truncate(52.64,-1),truncate(52.64,-2), truncate(-52.64,1),truncate(-52.64,-1),truncate(52.64),truncate(-52.64); +truncate(52.64,1) truncate(52.64,2) truncate(52.64,-1) truncate(52.64,-2) truncate(-52.64,1) truncate(-52.64,-1) truncate(52.64) truncate(-52.64) +52.6 52.64 50 0 -52.6 -50 52 -52 +explain extended 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),truncate(52.64),truncate(-52.64); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: -Note 1003 select truncate(52.64,1) AS `truncate(52.64,1)`,truncate(52.64,2) AS `truncate(52.64,2)`,truncate(52.64,-(1)) AS `truncate(52.64,-1)`,truncate(52.64,-(2)) AS `truncate(52.64,-2)`,truncate(-(52.64),1) AS `truncate(-52.64,1)`,truncate(-(52.64),-(1)) AS `truncate(-52.64,-1)` +Note 1003 select truncate(52.64,1) AS `truncate(52.64,1)`,truncate(52.64,2) AS `truncate(52.64,2)`,truncate(52.64,-(1)) AS `truncate(52.64,-1)`,truncate(52.64,-(2)) AS `truncate(52.64,-2)`,truncate(-(52.64),1) AS `truncate(-52.64,1)`,truncate(-(52.64),-(1)) AS `truncate(-52.64,-1)`,truncate(52.64,0) AS `truncate(52.64)`,truncate(-(52.64),0) AS `truncate(-52.64)` select round(5.5),round(-5.5); round(5.5) round(-5.5) 6 -6