Details
Description
The following test case demonstrates the problem:
drop database test; |
create database test; |
create table test.t1 (a int); |
insert into test.t1 values (3),(7),(1); |
create view test.v2 as select * from (select * from test.t1) as t; |
select test.v2.a from test.v2; |
MariaDB [(none)]> select test.v2.a from test.v2;
|
ERROR 1356 (HY000): View 'test.v2' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
|
Attachments
Issue Links
- blocks
-
MDEV-22781 CREATE VIEW containing WITH clause Signal 11
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Link |
This issue blocks |
| Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
| Assignee | Igor Babaev [ igor ] | Oleksandr Byelkin [ sanja ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] |
if (all_tables)
|
res= check_table_access(thd,
|
privileges_requested,
|
all_tables, FALSE, UINT_MAX, FALSE);
|
else
|
correctly assign privileges and detect that all required given
| Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Igor Babaev [ igor ] | Oleksandr Byelkin [ sanja ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Fix Version/s | 10.2.37 [ 25112 ] | |
| Fix Version/s | 10.3.28 [ 25111 ] | |
| Fix Version/s | 10.4.18 [ 25110 ] | |
| Fix Version/s | 10.5.9 [ 25109 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 116339 ] | MariaDB v4 [ 158633 ] |
Sanja:
Most probably the bug exists starting from:
commit 7166069537a4e18d4c0848655fcbc0c8ee568fd4Author: Oleksandr Byelkin <sanja@mariadb.com>Date: Thu Feb 25 14:55:04 2016 +0100MDEV-3944: Allow derived tables in VIEWSI made a checkout for this commit. Yet the tree after this commit was not in a good shape as I got:
MariaDB [(none)]> create view test.v2 as select * from (select * from test.t1) as t;ERROR 1142 (42000): ANY command denied to user ''@'' for table '*'I marked this bug as "Critical" because
MDEV-22781is marked as 'Critical'.MDEV-22781is crashing, but I checked it against my fix for MDEV-22886 and there I had the same error message as forMDEV-24314.