Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
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
-
MDEV-27691
make working view-protocol
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue is part of |
| Description |
Test:
{code} 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; {code} Error: {code} 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 {code} *After fix this bug view-protocol should be enable in tests: main.lowercase_table* |
Test:
{code} 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; {code} Error: {code} 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 {code} *After fix this bug view-protocol should be enable in tests: main.lowercase_table, main.cte_nonrecursive* |
| Labels | view-protocol |
| Assignee | Lena Startseva [ JIRAUSER50478 ] | Oleksandr Byelkin [ sanja ] |
| Priority | Major [ 3 ] | Minor [ 4 ] |
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.
| Fix Version/s | 10.11 [ 27614 ] |
| Fix Version/s | 10.9 [ 26905 ] |
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;
|
| Assignee | Oleksandr Byelkin [ sanja ] | Lena Startseva [ JIRAUSER50478 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Fix Version/s | 11.6 [ 29515 ] | |
| Fix Version/s | 11.7 [ 29815 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
Fix done in commit ad5b9c207c60d78a55ab0514432ef0421d017c1a and was merged into all versions
| Component/s | Tests [ 10800 ] | |
| Fix Version/s | 10.5.27 [ 29902 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Fix Version/s | 10.11 [ 27614 ] | |
| Fix Version/s | 11.2 [ 28603 ] | |
| Fix Version/s | 11.4 [ 29301 ] | |
| Fix Version/s | 11.6 [ 29515 ] | |
| Fix Version/s | 11.7 [ 29815 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.6.20 [ 29903 ] | |
| Fix Version/s | 10.11.10 [ 29904 ] | |
| Fix Version/s | 11.2.6 [ 29906 ] | |
| Fix Version/s | 11.4.4 [ 29907 ] |
| Fix Version/s | 11.6.2 [ 29908 ] | |
| Fix Version/s | 11.7.1 [ 29913 ] |
It looks like problem of view protocol inself