[MDEV-11868] min ( distinct ) over ( ) returns wrong value - Jira

10.2.3 beta

The following query works

select TDEC.CDEC, min( distinct TDEC.CDEC ) over () from TDEC

CDEC min( distinct TDEC.CDEC ) over ()
<null> -1
-1 -1
0 -1
1 -1
0.1 -1
10 -1

The same query applied to a simple view that projects the table does not

select `tdec`.`RNUM` AS `RNUM`,`tdec`.`CDEC` AS `CDEC` from `tdec`


select VDEC.CDEC, min( distinct VDEC.CDEC ) over () from VDEC

CDEC min( distinct VDEC.CDEC ) over ()
<null> 10
-1 10
0 10
1 10
0.1 10
10 10

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

MariaDB Server