Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29448

mysqldump missing option to match MySQL existing options

Details

    Description

      Hello,

      To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

      Step to reproduce
      / # apk add mysql-client

      then run something like
      mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase

      Expected: dump is ran
      Actual: error: `mysqldump: unknown variable 'column-statistics=0'`

      Full example output:
      ```
      $> docker run -it alpine:latest sh
      / # apk add mysql-client
      fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
      fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
      (1/7) Installing mariadb-common (10.6.9-r0)
      (2/7) Installing libgcc (11.2.1_git20220219-r2)
      (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
      (4/7) Installing ncurses-libs (6.3_p20220521-r0)
      (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
      (6/7) Installing mariadb-client (10.6.9-r0)
      (7/7) Installing mysql-client (10.6.9-r0)
      Executing busybox-1.35.0-r13.trigger
      OK: 39 MiB in 21 packages
      / # mysqldump --version
      mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
      / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
      mysqldump: unknown variable 'column-statistics=0'
      ```

      Attachments

        Issue Links

          is part of

          Task - A task that needs to be done. MDEV-28906 MySQL 8.0 desired compatibility

          • Major - Major loss of function.
          • Open

          Activity

            Ascending order - Click to sort in descending order
            gliluaume Guillaume Salicis created issue -
            gliluaume Guillaume Salicis made changes -
            Field Original Value New Value
            Description Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            ```
            / # apk add mysql-client
            ```
            then run something like
            ```
            mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            ```
            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            ```
            ~> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'
            ```             		Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{~> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'}}
            gliluaume Guillaume Salicis made changes -
            Description Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{~> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'}}
            		Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{$> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'}}
            gliluaume Guillaume Salicis made changes -
            Description Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{$> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'}}
            		Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{
            $> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'
            }}
            gliluaume Guillaume Salicis made changes -
            Description Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            {{
            $> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'
            }}
            		Hello,

            To keep mariaDb tools compatible with MySQL tools both should share the same interface (options in CLI in this case).

            Step to reproduce
            {{/ # apk add mysql-client}}

            then run something like
            {{mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase}}

            Expected: dump is ran
            {color:#DE350B}Actual{color}: error: `mysqldump: unknown variable 'column-statistics=0'`


            Full example output:
            ```
            $> docker run -it alpine:latest sh
            / # apk add mysql-client
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/main/x86_64/APKINDEX.tar.gz
            fetch https://dl-cdn.alpinelinux.org/alpine/v3.16/community/x86_64/APKINDEX.tar.gz
            (1/7) Installing mariadb-common (10.6.9-r0)
            (2/7) Installing libgcc (11.2.1_git20220219-r2)
            (3/7) Installing ncurses-terminfo-base (6.3_p20220521-r0)
            (4/7) Installing ncurses-libs (6.3_p20220521-r0)
            (5/7) Installing libstdc++ (11.2.1_git20220219-r2)
            (6/7) Installing mariadb-client (10.6.9-r0)
            (7/7) Installing mysql-client (10.6.9-r0)
            Executing busybox-1.35.0-r13.trigger
            OK: 39 MiB in 21 packages
            / # mysqldump --version
            mysqldump Ver 10.19 Distrib 10.6.9-MariaDB, for Linux (x86_64)
            / # mysqldump --no-create-info --skip-triggers --skip-lock-tables -udbuser -pdbpassword -h mysql-dev.localtest.me --column-statistics=0 dev_mywonderfulldatabase
            mysqldump: unknown variable 'column-statistics=0'
            ```
            serg Sergei Golubchik added a comment -

            note that you write portable scripts by using --loose prefix for all options that aren't supported by one of the tools. Like
            --loose-column-statistics=0.

            serg Sergei Golubchik added a comment - note that you write portable scripts by using --loose prefix for all options that aren't supported by one of the tools. Like --loose-column-statistics=0 .
            serg Sergei Golubchik made changes -
            Affects Version/s 10.6.9 [ 27507 ]
            Environment Alpine Linux (docker)
            Issue Type Bug [ 1 ] Task [ 3 ]
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Minor [ 4 ]
            danblack Daniel Black made changes -

            People

              Unassigned Unassigned
              gliluaume Guillaume Salicis
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.