[MDEV-13052] Window function aliases override table columns in OVER (ORDER BY) - Jira

XML

Word

Printable

The following examples works in PostGRES but fails in MariaDB:

create table t1 (pk varchar(10), a int);

insert into t1 values ('a', 1);

insert into t1 values ('b', 2);

insert into t1 values ('c', 3);

insert into t1 values ('d', 4);

select row_number() over (order by pk) pk, a from t1;

The select statement fails with:

Window function is not allowed in window specification

While this runs perfectly in PostGRES.

test=# select row_number() over (order by pk) pk, pk, a from test;

 pk | pk | a

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

  1 | a  | 1

  2 | b  | 2

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