[MDEV-28661] MIN(X) returns incorrect result in view - Jira

XML

Word

Printable

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.