During MIR for mysql-router it was discovered that there are some tests, executed during package build time, that are failing:
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
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)
During MIR for mysql-router it was discovered that there are some tests, executed during package build time, that are failing:
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
CURRENT_TEST: main.subquery_ sj_mat_ bka noco/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 noco/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
-> Materialize with deduplication
-> 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)
--- /home/rafaeldti
+++ /home/rafaeldti
@@ -12800,10 +12800,10 @@
-> Hash
-> Table scan on <subquery2>
- -> 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)
mysqltest: Result content mismatch
Failing test(s): main.events_bugs
Unstable test(s) (failures/ attempts) : main.subquery_ sj_mat_ bka(1/3)