[MDEV-28661] MIN(X) returns incorrect result in view - 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

Test:

create view v1 as SELECT min(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;

select * from v1;

drop view v1;

Number is less than it should be
Actual result:

foo

99999999999999999999999999999999999999999999999999999999999999999

Expected result:

foo

999999999999999999999999999999999999999999999999999999999999999999999999999999999

It looks like the problem is in the allowed number of digits, because in the next test the same problem:

Test:

create view v1 as SELECT -(999999999999999999999999999999999999999999999999999999999999999999999999999999999) AS foo;

select * from v1;

drop view v1;

Number is less than it should be
Actual result:

foo

-99999999999999999999999999999999999999999999999999999999999999999

Expected result:

foo

-999999999999999999999999999999999999999999999999999999999999999999999999999999999

is part of

MDEV-27691 make working view-protocol

relates to

MDEV-28651 quote(NULL) returns incorrect result in view ('NU' instead of 'NULL')

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