[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

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL)
Fix Version/s: 10.11.2, 11.0.0, 10.3.38, 10.4.28, 10.5.19, 10.6.12, 10.7.8, 10.9.5, 10.10.3
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

Transition	Time In Source Status	Execution Times

Alexander Barkov made transition - 2022-12-01 11:05

Open

In Progress

185d 4h 41m

Alexander Barkov made transition - 2022-12-01 11:06

In Progress

In Review

1m 14s

Oleksandr Byelkin made transition - 2022-12-01 11:41

In Review

Stalled

34m 12s

Alexander Barkov made transition - 2022-12-02 07:29

Stalled

Closed

19h 48m

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

Git Integration

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

MariaDB Server