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

sys.create_synonym_db fails when a temporary table masks a base table

    XMLWordPrintable

    Details

      Description

      create database db;
      use db;
      create table t (b int);
      create temporary table t (a int);
       
      call sys.create_synonym_db('db','db_copy');
      

      10.6 7da351d8

      mysqltest: At line 6: query 'call sys.create_synonym_db('db','db_copy')' failed: ER_VIEW_SELECT_TMPTABLE (1352): View's SELECT refers to a temporary table 't'
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              anel Anel Husakovic
              Reporter:
              elenst Elena Stepanova
              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.