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

View-protocol fails if database was changed

Details

    Description

      Test:

      create table t2 (a int);
      		 
      select count(*) from t2;
      		 
      drop table t2;
      		 
       
      		 
       
      		 
      create database mysqltest;
      		 
      use mysqltest;
      		 
      create table t1 (a int);
      		 
      select t1.a from mysqltest.t1;
      		 
      drop database mysqltest;
      		 
      use test;

      Error:

      mysqltest: At line 9: query 'select t1.a from mysqltest.t1' failed: ER_NO_SUCH_TABLE (1146): Table 'mysqltest.mysqltest_tmp_v' doesn't exist

      After fix this bug view-protocol should be enable in tests: main.lowercase_table, main.cte_nonrecursive

      Attachments

        Issue Links

          is part of

          Technical task - A technical task. MDEV-27691 make working view-protocol

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            sanja Oleksandr Byelkin added a comment -

            It looks like problem of view protocol inself

            sanja Oleksandr Byelkin added a comment - It looks like problem of view protocol inself
            monty Michael Widenius added a comment -

            sanja, there are several test cases that has a comment:
            #remove this include after fix MDEV-27944

            Would be good to get this fixed, if possible, so that we can enable the tests.

            monty Michael Widenius added a comment - sanja , there are several test cases that has a comment: #remove this include after fix MDEV-27944 Would be good to get this fixed, if possible, so that we can enable the tests.
            sanja Oleksandr Byelkin added a comment - - edited

            As I wrote above it is limitation of the view protocol, here is workaround:

            reate table t2 (a int);
            		 
            select count(*) from t2;
            		 
            drop table t2;
            		 
             
            create database mysqltest;
            		 
            use mysqltest;
            		 
            create table t1 (a int);
            		 
            --disable_service_connection 
            select t1.a from mysqltest.t1;
            		 
            --enable_service_connection 
            drop database mysqltest;
            		 
            use test;

            sanja Oleksandr Byelkin added a comment - - edited As I wrote above it is limitation of the view protocol, here is workaround: reate table t2 (a int); select count(*) from t2; drop table t2; create database mysqltest; use mysqltest; create table t1 (a int); --disable_service_connection select t1.a from mysqltest.t1; --enable_service_connection drop database mysqltest; use test;
            sanja Oleksandr Byelkin added a comment -

            lstartseva please fix it as above

            sanja Oleksandr Byelkin added a comment - lstartseva please fix it as above
            lstartseva Lena Startseva added a comment -

            Fix done in commit ad5b9c207c60d78a55ab0514432ef0421d017c1a and was merged into all versions

            lstartseva Lena Startseva added a comment - Fix done in commit ad5b9c207c60d78a55ab0514432ef0421d017c1a and was merged into all versions

            People

              lstartseva Lena Startseva
              lstartseva Lena Startseva
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.