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

Mariadb-dump improper view creation

    XMLWordPrintable

Details

    Description

      Script, created by mariadb-dump, got execution errors due to improper view creation sequence. The reason is initial view creation by such type commands:

      CREATE VIEW `...` AS SELECT
      1 AS `...`,
      1 AS `...`,
      

      After that view columns defined as numeric despite original column types.
      Then comes second view creation that uses function on underlying view columns and it hits an error of wrong type argument. This could be fixed if initial view would use corresponding type constant (for example, now() for datetime columns, '' for char columns), not only 1 for columns of all types.

      Attachments

        Activity

          People

            bar Alexander Barkov
            balta Tadas Balaišis
            Votes:
            0 Vote for this issue
            Watchers:
            5 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.