[MDEV-27944] View-protocol fails if database was changed Created: 2022-02-25  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.11

Type: Bug Priority: Minor
Reporter: Lena Startseva Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: view-protocol

Issue Links:
PartOf
is part of MDEV-27691 make working view-protocol Open

 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

 Comments   
Comment by Oleksandr Byelkin [ 2022-12-01 ]

It looks like problem of view protocol inself

Comment by Michael Widenius [ 2023-06-21 ]

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.

Generated at Thu Feb 08 09:56:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.