[MDEV-10184] Query with ROW_NUMBER() hangs indefinitely if ORDER or PARTITION not specified - Jira

XML

Word

Printable

10.2.0-MariaDB

The query

select blah, row_number()  over() from (select 'foo' blah) t;

hangs indefinitely. The process list shows:

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

| Id | User | Host      | db    | Command | Time | State | Info             | Progress |

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

| 17 | root | localhost | onedb | Sleep   | 958  |       |                  | 0.000    |

| 22 | root | localhost |       | Query   | 0    | init  | show processlist | 0.000    |

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

If ORDER BY or PARTITION BY (or both) is specified in OVER(), the query executes successfully.

is duplicated by

MDEV-9935 Window functions: assertion failure with empty OVER() clause

MDEV-9958 Server hangs if OVER() is empty

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