[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. The same problem happens with MIN. This is the following query we're trying to run:
Here's the database Is there a bug? Thanks, |