[debian-mysql] Bug#1029163: mariadb: FTBFS on armel, armhf, mipsel, mips64el: builds, but test suite fails in main.explain_json_format mismatches

[Otto Kekäläinen]

Source: mariadb
Version: 1:10.11.1-1
Tags: upstream, confirmed, ftbfs
User: debian-arm at lists.debian.org
Usertags: eabi, mipsel, mips64el, armhf, armel
X-Debbugs-CC: debian-arm at lists.debian.org, debian-mips at lists.debian.org
Forwarded: https://jira.mariadb.org/browse/MDEV-30411

Several tests that use ANALYZE format=json fail with mismatched output
after upload of MariaDB 11.10 to Debian (this is a regression from
10.6).

Example:

CURRENT_TEST: main.except_all
--- /<<PKGBUILDDIR>>/mysql-test/main/except_all.result 2022-11-14
18:10:21.000000000 +0000
+++ /<<PKGBUILDDIR>>/mysql-test/main/except_all.reject 2023-01-12
20:20:18.132443098 +0000
@@ -115,13 +115,9 @@
 ANALYZE format=json select * from ((select a,b from t1) except all
(select c,d from t2)) a;
 ANALYZE
 {
-  "query_optimization": {
-    "r_total_time_ms": "REPLACED"
-  },
   "query_block": {
     "select_id": 1,
     "r_loops": 1,
-    "r_total_time_ms": "REPLACED",
     "nested_loop": [


The likely fix would go into
https://github.com/MariaDB/server/tree/10.11/include/my_rdtsc.h

Several people already suggested various ways to do it:

* https://alioth-lists.debian.net/pipermail/pkg-mysql-maint/2023-January/016183.html
* https://lists.debian.org/debian-arm/2023/01/msg00007.html
* https://lists.debian.org/debian-arm/2023/01/msg00008.html

What is missing is for somebody to do an optimal change and validate
that it works.


Merge requests welcome!

https://salsa.debian.org/mariadb-team/mariadb-server/-/wikis/Contributing-to-MariaDB-packaging-in-Debian