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

mariadb-dump: INVISIBLE columns from MySQL become regular visible columns on MariaDB

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4, 11.8, 12.3
    • None
    • None

    Description

      Source: MySQL 8.x. Target: MariaDB.
      Client: mariadb-dump / mariadb from MariaDB client package on RHEL 9

      mariadb-dump copies the INVISIBLE column attribute from a MySQL source verbatim, as MySQL writes it, inside a /*!80023 ... */ version comment.

      MariaDB ignores MySQL-style version comments numbered 50700 to 99999 (MDEV-5009), so the attribute is discarded before the parser sees it.

      The column is created as a normal visible column.

      No error and no warning is raised. The restore completes with exit code 0.
      Column data is preserved, because mariadb-dump writes explicit column lists when a table has invisible columns, so the only loss is the attribute itself.

      Impact: MySQL to MariaDB migration
      A column hidden from SELECT * on the MySQL source is returned by SELECT * when imported to MariaDB.

      Attachments

        Issue Links

          Activity

            People

              alice Alice Sherepa
              manoj.vakeel Manoj
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.