Bug #43020 main.func_math fails on FreeBSD in PB2
Submitted: 19 Feb 2009 13:24 Modified: 18 May 2017 13:40
Reporter: Alexander Nozdrin Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Server Severity:S3 (Non-critical)
Version:M3 (Celosia), M4 (Dahlia), 6.0 OS:FreeBSD
Assigned to: CPU Architecture:Any
Tags: experimental, pb2, test failure
Triage: Triaged: D3 (Medium)

[19 Feb 2009 13:24] Alexander Nozdrin
Description:
Symptoms:
-------------------------------------------------------------
CURRENT_TEST: main.func_math
--- /export/home/pb2/test/sb_1-333326-1234889074.72/mysql-6.0.10-alpha-freebsd7.0-x86_64-test/mysql-test/r/func_math.result	2009-02-17 15:50:04.000000000 +0300
+++ /export/home/pb2/test/sb_1-333326-1234889074.72/mysql-6.0.10-alpha-freebsd7.0-x86_64-test/mysql-test/r/func_math.reject	2009-02-17 22:29:23.000000000 +0300
@@ -44,7 +44,7 @@
 Note	1003	select abs(-(10)) AS `abs(-10)`,sign(-(5)) AS `sign(-5)`,sign(5) AS `sign(5)`,sign(0) AS `sign(0)`
 select log(exp(10)),exp(log(sqrt(10))*2),log(-1),log(NULL),log(1,1),log(3,9),log(-1,2),log(NULL,2);
 log(exp(10))	exp(log(sqrt(10))*2)	log(-1)	log(NULL)	log(1,1)	log(3,9)	log(-1,2)	log(NULL,2)
-10	10.000000000000002	NULL	NULL	NULL	2	NULL	NULL
+10	10.000000000000002	NULL	NULL	NULL	2.0000000000000004	NULL	NULL
 explain extended select log(exp(10)),exp(log(sqrt(10))*2),log(-1),log(NULL),log(1,1),log(3,9),log(-1,2),log(NULL,2);
 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

mysqltest: Result content mismatch

Warnings from just before the error:
Warning 1292 Truncated incorrect DECIMAL value: '' 
Error 1264 Out of range value for column 'x' at row 1
-------------------------------------------------------------

Reported after a failure on 2009-02-17 in PB2.

How to repeat:
XRef2: http://tinyurl.com/bpjlze
[4 May 2010 12:22] Alexander Nozdrin
The test case was marked experimental due to this bug.

Requesting re-triage because it's happening in mysql-trunk (M3) too.
[6 May 2010 12:58] Alexey Kopytov
This is an OS issue (log() implementation on FreeBSD/x86_64 leads to different results as compared to other platforms). See the discussion in bug #46577 and Drizzle bug http://bugs.launchpad.net/drizzle/+bug/408694
[18 May 2017 13:40] Paul Dubois
Posted by developer:
 
Fixed in 8.0.2.

Work was done for test suite. No changelog entry needed.