[MDEV-29295] Double convert of ',' in view definition gives incorrect result - Jira

XML

Word

Printable

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
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
Component/s: None
Labels:
- view-protocol

Expected that "select from table" and "select from view" give the same result:
Test:

select convert(convert(',' using filename) using binary);

create view vv as select convert(convert(',' using filename) using binary);

select * from vv;

drop view vv;

Actual result:

select convert(convert(',' using filename) using binary);

convert(convert(',' using filename) using binary)

@002c

create view vv as select convert(convert(',' using filename) using binary);

select * from vv;

convert(convert(',' using filename) using binary)

Expected result:

select convert(convert(',' using filename) using binary);

convert(convert(',' using filename) using binary)

@002c

create view vv as select convert(convert(',' using filename) using binary);

select * from vv;

convert(convert(',' using filename) using binary)

@002c

is part of

MDEV-27691 make working view-protocol

relates to

MDEV-31553 Double convert of ',' with cursor-protocol gives incorrect result

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