Public bug reported:
During MIR for mysql-router it was discovered that there are some tests,
executed during package build time, that are failing:
(PROBLEM #1)
CURRENT_TEST: main.events_bugs
mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01
00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'
AND
(PROBLEM #2)
CURRENT_TEST: main.subquery_sj_mat_bka
---
/home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result
2019-09-20 11:30:51.000000000 +0300
+++
/home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject
2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
-> Materialize with deduplication
- -> Filter: (t1.col_int_key is not null) (cost=3.40
rows=7)
- -> Filter: (t3.col_int is null) (cost=3.40 rows=7)
- -> Nested loop left join (cost=3.40 rows=7)
- -> Index scan on t1 using col_int_key
(cost=0.95 rows=7)
+ -> Filter: (t1.col_int_key is not null) (cost=4.15
rows=7)
+ -> Filter: (t3.col_int is null) (cost=4.15 rows=7)
+ -> Nested loop left join (cost=4.15 rows=7)
+ -> Index scan on t1 using col_int_key
(cost=1.70 rows=7)
-> Nested loop inner join (cost=1.21
rows=1)
-> Single-row index lookup on t2 using
PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
-> Filter: (t3.col_int_key =
t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3)
** Affects: mysql-8.0 (Ubuntu)
Importance: High
Assignee: Rafael David Tinoco (rafaeldtinoco)
Status: In Progress
** Changed in: mysql-8.0 (Ubuntu)
Status: New => In Progress
** Changed in: mysql-8.0 (Ubuntu)
Importance: Undecided => High
** Changed in: mysql-8.0 (Ubuntu)
Assignee: (unassigned) => Rafael David Tinoco (rafaeldtinoco)
** Description changed:
During MIR for mysql-router it was discovered that there are some tests,
executed during package build time, that are failing:
+
+ (PROBLEM #1)
CURRENT_TEST: main.events_bugs
mysqltest: At line 1036: Query 'CREATE EVENT e1 ON SCHEDULE AT '2020-01-01
00:00:00' DO SET @a = 1' succeeded, should have failed with error '1290'
AND
+ (PROBLEM #2)
+
CURRENT_TEST: main.subquery_sj_mat_bka
---
/home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/mysql-test/r/subquery_sj_mat_bka.result
2019-09-20 11:30:51.000000000 +0300
+++
/home/rafaeldtinoco/work/sources/general/ubuntu/mysql-8.0-8.0.18/builddir/mysql-test/var/9/log/subquery_sj_mat_bka.reject
2020-01-09 19:54:09.659290415 +0300
@@ -12800,10 +12800,10 @@
- -> Hash
- -> Table scan on <subquery2>
- -> Materialize with deduplication
+ -> Hash
+ -> Table scan on <subquery2>
+ -> Materialize with deduplication
- -> Filter: (t1.col_int_key is not null) (cost=3.40
rows=7)
- -> Filter: (t3.col_int is null) (cost=3.40
rows=7)
- -> Nested loop left join (cost=3.40 rows=7)
- -> Index scan on t1 using col_int_key
(cost=0.95 rows=7)
+ -> Filter: (t1.col_int_key is not null) (cost=4.15
rows=7)
+ -> Filter: (t3.col_int is null) (cost=4.15
rows=7)
+ -> Nested loop left join (cost=4.15 rows=7)
+ -> Index scan on t1 using col_int_key
(cost=1.70 rows=7)
- -> Nested loop inner join (cost=1.21
rows=1)
- -> Single-row index lookup on t2
using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
- -> Filter: (t3.col_int_key =
t2.col_int) (cost=0.09 rows=1)
+ -> Nested loop inner join (cost=1.21
rows=1)
+ -> Single-row index lookup on t2
using PRIMARY (pk=t1.pk) (cost=0.26 rows=1)
+ -> Filter: (t3.col_int_key =
t2.col_int) (cost=0.09 rows=1)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s)(failures/attempts): main.subquery_sj_mat_bka(1/3)
--
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to mysql-8.0 in Ubuntu.
https://bugs.launchpad.net/bugs/1859100
Title:
mysql-server FTBFS (focal) because of build tests
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1859100/+subscriptions
--
Ubuntu-server-bugs mailing list
Ubuntu-server-bugs@lists.ubuntu.com
Modify settings or unsubscribe at:
https://lists.ubuntu.com/mailman/listinfo/ubuntu-server-bugs
