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

mysqldump generate "create Table" by Views

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 10.2.36
    • N/A
    • Scripts & Clients
    • None

    Description

      mysqldump dumps views as tables when there is only one view

      dump create this:

      /*!50001 CREATE TABLE `VIEW1` (
      `id` tinyint NOT NULL,
      `c` tinyint NOT NULL
      ) ENGINE=MyISAM */;

      i have also test it on Windows Version 10.5.8 with the same error

      In the attachment is the create, use and the mysqldump output.

      Regards

      Bernd

      Attachments

        Activity

          People

            serg Sergei Golubchik
            Bernd Buffen Bernd Buffen
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.