Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.3.15
-
None
-
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