Details
Description
Select from view fails if definition of view has TVC containing subquery used as a subselect.
Test:
create table t1 (a int) engine=myisam; |
insert into t1 values (3), (7), (1); |
create table t2 (b int) engine=myisam; |
insert into t2 values (1), (2); |
|
create view v1 as select (values ((select * from t1 where a > 10))) from t2; |
select * from v1; |
|
drop view v1; |
drop table t1,t2; |
Actual result:
At line 7: query 'select * from v1' failed: 1356: View 'test.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them |
Expected result:
(values ((select * from t1 where a > 10))) |
NULL
|
NULL |
Attachments
Issue Links
- is part of
-
MDEV-27691 make working view-protocol
- Open