[MDEV-28696] View created as "select b''; " references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5(EOL), 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 11.0.0, 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.9.5, 10.10.3, 10.11.2
Component/s: Data types
Labels:
- view-protocol

Description

Test:

CREATE VIEW v1 as select b'';

SELECT * FROM v1;

DROP VIEW v1;

Actual value:

At line 3: 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 value:

b''

Attachments

Issue Links

is part of

MDEV-27691 make working view-protocol

Closed

Activity

People

Assignee:: Alexander Barkov

Reporter:: Lena Startseva

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2022-05-30 06:24

Updated:: 2022-12-02 07:29

Resolved:: 2022-12-02 07:29

Time Tracking

Estimated:

Not Specified

Remaining:

Logged:

1h 25m

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.