[debian-mysql] Bug#1084786: mariadb-client: mariadb-dump fails on mysql 5.7 db with syntax error

[Lukas Wedeking]

Package: mariadb-client
Version: 1:11.4.3-1
Severity: normal

Dear Maintainer,

I tried to dump a mysql database (mysql is running version 5.7.44) with
mariadb-dump, but it fails with this message:

   mysqldump: Couldn't execute '/*!100100 SET WAIT_TIMEOUT=DEFAULT */':
   You have an error in your SQL syntax; check the manual that
   corresponds to your MySQL server version for the right syntax to use
   near '0 SET WAIT_TIMEOUT=DEFAULT */' at line 1 (1064)

I tried adding --compatible with mysql40 and mysql323, but the same
error occured nonetheless. Logging into the database with mariadb works
as expected.

Best regards
Lukas


-- System Information:
Debian Release: trixie/sid
  APT prefers testing
  APT policy: (500, 'testing')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 6.10.11-amd64 (SMP w/6 CPU threads; PREEMPT)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=de_DE.UTF-8 (charmap=UTF-8), LANGUAGE not set
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)
LSM: AppArmor: enabled

Versions of packages mariadb-client depends on:
ii  debianutils              5.20
ii  libc6                    2.40-2
ii  libconfig-inifiles-perl  3.000003-3
ii  libssl3t64               3.3.2-1
ii  libstdc++6               14.2.0-3
ii  mariadb-client-core      1:11.4.3-1
ii  perl                     5.38.2-5
ii  zlib1g                   1:1.3.dfsg+really1.3.1-1

Versions of packages mariadb-client recommends:
ii  libdbd-mariadb-perl   1.22-1+b3
ii  libdbi-perl           1.645-1
ii  libterm-readkey-perl  2.38-2+b3

mariadb-client suggests no packages.

-- no debconf information