[Bug 1859100] [NEW] mysql-server FTBFS (focal) because of build tests

[Rafael David Tinoco]

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