[MDEV-9925] Wrong result with aggregate function as a window function - Jira

create table t4 (i int);

insert into t4 values (1),(2);

select i, sum(i) over (partition by i) from t4;

Expected result
postgres=# select i, sum(i) over (partition by i) from t4;
i \| sum
---+-----
1 \| 1
2 \| 2
(2 rows)

If I add ORDER BY, the result becomes correct:

MariaDB [test]> select i, sum(i) over (partition by i order by i) from t4;

+------+-----------------------------------------+

| i    | sum(i) over (partition by i order by i) |

+------+-----------------------------------------+

|    1 |                                       1 |

|    2 |                                       2 |

+------+-----------------------------------------+

2 rows in set (0.00 sec)

relates to

MDEV-9896 Testing for window functions

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

MariaDB Server