[MDEV-20408] Window Function using MAX hangs Created: 2019-08-22  Updated: 2021-12-08

Status: Open
Project: MariaDB Server
Component/s: Optimizer - Window functions
Affects Version/s: 10.3.15
Fix Version/s: 10.3

Type: Bug Priority: Minor
Reporter: Elizabeth M. Good Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Production



 Description   

Hello,

We try a window function using max (or min), and the query just hangs. No notification in slow log, no nothing. The same query works fine with sum, count, or avg.
We thought that MariaDB supported window functions for MAX, MIN, as of 10.2.2?

The same problem happens with MIN.

This is the following query we're trying to run:

SELECT DayOfWeek,
Origin,
MAX(Distance) OVER(PARTITION BY DayOfWeek)
FROM ontime
LIMIT 10;

Here's the database
http://stat-computing.org/dataexpo/2009/the-data.html

Is there a bug?

Thanks,
Beth


Generated at Thu Feb 08 08:59:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.