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

mysqldump against MYSQL server 8 creates invalid dump

Details

    Description

      Running the following command against MYSQL Server v8.0.32

      mysqldump -h ... -u ... -p --opt --single-transaction --no-tablespaces the_database > dump.sql

      creates a dump without error messages, which look like this:

      CREATE TABLE foo (
      		 
        uid INT ...,
      		 
        tstamp INT ...,
      		 
        something VARCHAR(22) ...,
      		 
        ...
      		 
        PRIMARY KEY uid
      		 
      );
      		 
       
      		 
      INSERT INTO foo VALUES ('',153246345,1),('',1567246333,2),...;

      As one can see the VALUES part uses an incorrect order of columns. Trying to import such a dump, obviously, fails directly with "DUPLICATE KEY".

      Observation: The order of the VALUES is the alphabetical order of the column names not the one specified in the CREATE TABLE statement.

      (Note: Running the same command using mysqldump from mysql works flawlessly)

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          liayn1 M created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Key TOOLS-64 MDEV-31836
          Workflow Software Simplified Workflow for Project TOOLS [ 179397 ] MariaDB v4 [ 179399 ]
          Project MariaDB Tools [ 12900 ] MariaDB Server [ 10000 ]
          Status To Do [ 10003 ] Open [ 1 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] Needs Feedback [ 10501 ]
          serg Sergei Golubchik made changes -
          Comment [ what mariadb version was it? ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ]
          serg Sergei Golubchik made changes -
          Status Needs Feedback [ 10501 ] Open [ 1 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 10.11 [ 27614 ]
          Affects Version/s 11.0 [ 28320 ]
          Affects Version/s 11.1 [ 28549 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.0 [ 28320 ]
          Fix Version/s 11.1 [ 28549 ]
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] In Testing [ 10301 ]
          liayn1 M added a comment -

          I forgot to mention the version of mysqldump (alias mariadb-dump)

          > mysqldump Ver 10.19 Distrib 10.11.3-MariaDB, for debian-linux-gnu (x86_64)

          liayn1 M added a comment - I forgot to mention the version of mysqldump (alias mariadb-dump) > mysqldump Ver 10.19 Distrib 10.11.3-MariaDB, for debian-linux-gnu (x86_64)
          serg Sergei Golubchik made changes -
          Component/s Scripts & Clients [ 11002 ]
          Fix Version/s 10.11.5 [ 29019 ]
          Fix Version/s 11.0.3 [ 28920 ]
          Fix Version/s 11.1.2 [ 28921 ]
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.0 [ 28320 ]
          Fix Version/s 11.1 [ 28549 ]
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]

          People

            serg Sergei Golubchik
            liayn1 M
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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