[MDEV-11745] Wrong results upon using window function with min/max aggregation - Jira

Note: results below are from 10.2 348ccb6f038a6c1.

create table t1 (i int);

insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10);

select i, Min(i) OVER (PARTITION BY i) as f from (select * from t1) as tt order by i;

Without the subquery, the result is different:

MariaDB [test]> select i, Min(i) OVER (PARTITION BY i) as f from t1 as tt order by i;

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

| i    | f    |

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

|    1 |    1 |

|    2 |    2 |

|    3 |    3 |

|    4 |    4 |

|    5 |    5 |

|    6 |    6 |

|    7 |    7 |

|    8 |    8 |

|    9 |    9 |

|   10 |   10 |

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

10 rows in set (0.01 sec)

PostgreSQL 9.4 returns the same for both queries:

postgres=# select i, Min(i) OVER (PARTITION BY i) as f from t1 as tt order by i;

 i  | f

----+----

  1 |  1

  2 |  2

  3 |  3

  4 |  4

  5 |  5

  6 |  6

  7 |  7

  8 |  8

  9 |  9

 10 | 10

(10 rows)

postgres=# select i, Min(i) OVER (PARTITION BY i) as f from (select * from t1) as tt order by i;

 i  | f

----+----

  1 |  1

  2 |  2

  3 |  3

  4 |  4

  5 |  5

  6 |  6

  7 |  7

  8 |  8

  9 |  9

 10 | 10

(10 rows)

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