[MDEV-20532] Tests fail massively in buildbot on rhel8-ppc64le with floating point differences - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5
Fix Version/s: 10.5
Component/s: Data types, Tests
Labels:
None

Description

http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-rhel8-ppc64le/builds/120/steps/mtr/logs/stdio

10.3 f80e02e043103ab4e6ca12d9efffec6eb9aa3b74
main.ps w4 [ fail ]
Test ended at 2019-09-07 12:37:15

CURRENT_TEST: main.ps
/usr/bin/mysqltest: Error on delete of '/dev/shm/var/4/tmp/f1.txt' (Errcode: 2 "No such file or directory")
--- /usr/share/mysql-test/main/ps.result 2019-09-07 09:08:23.000000000 +0000
+++ /dev/shm/var/4/log/ps.reject 2019-09-07 12:37:15.313985734 +0000
@@ -3509,7 +3509,7 @@
) ENGINE=MyISAM DEFAULT CHARSET=latin1
SELECT @a, @a - 123.4567 < 0.00001;
@a @a - 123.4567 < 0.00001
-123.45670318603516 1
+123.45669555664062 1
DROP TEMPORARY TABLE tmp1;
DROP PROCEDURE p1;


mysqltest: Result content mismatch

main.select_pkeycache                    w2 [ fail ]

        Test ended at 2019-09-07 12:45:11

CURRENT_TEST: main.select_pkeycache

--- /usr/share/mysql-test/main/select_pkeycache.result	2019-09-07 09:08:23.000000000 +0000

+++ /dev/shm/var/2/log/select_pkeycache.reject	2019-09-07 12:45:11.110488630 +0000

@@ -2804,7 +2804,7 @@

 0.6158	1.3762

 select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;

 max(key1)

-0.3845

+0.6158

 select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;

 min(key1)

 0.3845

mysqltest: Result content mismatch

main.select                              w2 [ fail ]

        Test ended at 2019-09-07 12:49:22

CURRENT_TEST: main.select

--- /usr/share/mysql-test/main/select.result	2019-09-07 09:08:23.000000000 +0000

+++ /dev/shm/var/2/log/select.reject	2019-09-07 12:49:21.943951635 +0000

@@ -2804,7 +2804,7 @@

 0.6158	1.3762

 select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;

 max(key1)

-0.3845

+0.6158

 select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;

 min(key1)

 0.3845

mysqltest: Result content mismatch

main.select_jcl6                         w2 [ fail ]

        Test ended at 2019-09-07 12:49:27

CURRENT_TEST: main.select_jcl6

--- /usr/share/mysql-test/main/select_jcl6.result	2019-09-07 09:08:23.000000000 +0000

+++ /dev/shm/var/2/log/select_jcl6.reject	2019-09-07 12:49:26.854019423 +0000

@@ -2815,7 +2815,7 @@

 0.6158	1.3762

 select max(key1) from t1 where key1 <= 0.6158 and rand() + 0.5 >= 0.5;

 max(key1)

-0.3845

+0.6158

 select min(key1) from t1 where key1 >= 0.3762 and rand() + 0.5 >= 0.5;

 min(key1)

 0.3845

mysqltest: Result content mismatch

main.sp w2 [ fail ]
Test ended at 2019-09-07 12:49:41

CURRENT_TEST: main.sp
/usr/bin/mysqltest: Error on delete of '/dev/shm/var/2/tmp//t1.frm' (Errcode: 2 "No such file or directory")
/usr/bin/mysqltest: Error on delete of '/dev/shm/var/2/tmp//t1.MYD' (Errcode: 2 "No such file or directory")
— /usr/share/mysql-test/main/sp.result 2019-09-07 09:08:23.000000000 +0000
+++ /dev/shm/var/2/log/sp.reject 2019-09-07 12:49:41.434220717 +0000
@@ -5996,9 +5996,9 @@
INSERT INTO t3 VALUES (1, 3.4), (1, 2), (1, 0.9), (2, 8), (2, 7)|
SELECT SUM(f2), bug25373(f1) FROM t3 GROUP BY bug25373(f1) WITH ROLLUP|
SUM(f2) bug25373(f1)
-6.300000071525574 1
+6.299999833106995 1
15 2
-21.300000071525574 NULL
+21.299999833106995 NULL
DROP FUNCTION bug25373|
DROP TABLE t3|
DROP DATABASE IF EXISTS mysqltest1|

mysqltest: Result content mismatch

main.derived_cond_pushdown               w1 [ fail ]

        Test ended at 2019-09-07 12:49:54

CURRENT_TEST: main.derived_cond_pushdown

--- /usr/share/mysql-test/main/derived_cond_pushdown.result	2019-09-07 09:08:23.000000000 +0000

+++ /dev/shm/var/1/log/derived_cond_pushdown.reject	2019-09-07 12:49:54.364399231 +0000

@@ -7894,7 +7894,7 @@

             "access_type": "ALL",

             "rows": 3,

             "filtered": 100,

-            "attached_condition": "t1.i = 2.7100000381469727"

+            "attached_condition": "t1.i = 2.7099997997283936"

mysqltest: Result content mismatch

main.type_float w2 [ fail ]
Test ended at 2019-09-07 12:50:39

CURRENT_TEST: main.type_float
— /usr/share/mysql-test/main/type_float.result 2019-09-07 09:08:24.000000000 +0000
+++ /dev/shm/var/2/log/type_float.reject 2019-09-07 12:50:39.495022304 +0000
@@ -385,12 +385,12 @@
Warning 1264 Out of range value for column 'f1' at row 2
select f1 + 0e0 from t1;
f1 + 0e0
-1.0000000150474662e29
--1.0000000150474662e29
-1.0000000150474662e30
--1.0000000150474662e30
-1.0000000150474662e30
--1.0000000150474662e30
+9.999999206001366e28
+-9.999999206001366e28
+9.999999394896025e29
+-9.999999394896025e29
+9.999999394896025e29
+-9.999999394896025e29
drop table t1;
create table t1 (c char(6));
insert into t1 values (2e6),(2e-5);
@@ -818,20 +818,20 @@
INSERT INTO t1 VALUES (1.1);
SELECT f FROM t1 UNION SELECT 1;
f
-1.100000023841858
+1.0999999046325684
1
SELECT 1 UNION SELECT f FROM t1;
1
1
-1.100000023841858
+1.0999999046325684
SELECT f FROM t1 UNION SELECT 2147483647;
f
-1.100000023841858
+1.0999999046325684
2147483647
SELECT 2147483647 UNION SELECT f FROM t1;
2147483647
2147483647
-1.100000023841858
+1.0999999046325684
SELECT CASE WHEN 0 THEN (SELECT f FROM t1) ELSE 2147483647 END AS c1,
CASE WHEN 1 THEN 2147483647 ELSE (SELECT f FROM t1) END AS c2;
c1 c2

mysqltest: Result length mismatch

Attachments

Issue Links

relates to

MDEV-20530 binlog.binlog_mysqlbinlog_row_innodb and binlog.binlog_mysqlbinlog_row_myisam fail in buildbot on rhel8-ppc64le, binary files differ

Stalled

MDEV-20531 innodb.temporary_table_optimization fails in buildbot on kvm-rpm-rhel8-ppc64le with wrong result

Closed

Activity

People

Assignee:: Oleksandr Byelkin

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2019-09-08 15:00

Updated:: 2024-09-10 15:08

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.