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 Bugs, which is subscribed to 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-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs