[MDEV-29647] ROW_NUMBER is not 0 for warnings in case without row in view - Jira

XML

Word

Printable

In ~~MDEV-26635~~ was changed behavior for ROW_NUMBER, but in view we still get 1 instead 0:
Test:

create view v1 as SELECT CAST('.00000000000000000000000000000000000001e111111111111111111111' AS DECIMAL(38,0)) AS a;

select * from v1;

drop view v1;

Expected result:

99999999999999999999999999999999999999

Warnings:

Warning	1916	Got overflow when converting '' to DECIMAL. Value truncated

Warning	1292	Truncated incorrect DECIMAL value: '.00000000000000000000000000000000000001e111111111111111111111'

Warning	1264	Out of range value for column 'a' at row 0

Actual result:

99999999999999999999999999999999999999

Warnings:

Warning	1916	Got overflow when converting '' to DECIMAL. Value truncated

Warning	1292	Truncated incorrect DECIMAL value: '.00000000000000000000000000000000000001e111111111111111111111'

Warning	1264	Out of range value for column 'a' at row 1

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.