Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20408

Window Function using MAX hangs

    XMLWordPrintable

Details

    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

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              elizabeth.good@duke.edu Elizabeth M. Good
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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