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

[Rafael David Tinoco]

** Also affects: mysql-8.0 (Ubuntu Focal)
   Importance: High
     Assignee: Rafael David Tinoco (rafaeldtinoco)
       Status: In Progress

** Patch added: "mysql-8.0_8.0.18-0ubuntu5.debdiff"
   https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1859100/+attachment/5319197/+files/mysql-8.0_8.0.18-0ubuntu5.debdiff

** Description changed:

+ [Impact]
+ 
+  * mysql-server-8 FTBFS in Eoan and Focal.
+ 
+ [Test Case]
+ 
+  * apt-get source mysql-server
+  * cd mysql*
+  * apt-get build-dep .
+  * dpkg-buildpackage -b -us -uc
+ 
+ [Regression Potential]
+ 
+  * patch is changing a test (executed during binary package generation)
+  * build is already broken, impact is minimum: its either good and fixes build OR not.
+ 
+ [Other Info]
+ 
  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)

-- 
You received this bug notification because you are a member of Ubuntu
Server, which is subscribed to the bug report.
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