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

function as Window function causes debug assert

    Details

      Description

      When using AVG as a Window function I get a debug assert at sql_window.cc:3054

      Window_funcs_computation::setup()
       
        if (tab->filesort && tab->filesort->select)
        {
          sel= tab->filesort->select;
          DBUG_ASSERT(!sel->quick);
        }
      

      To reproduce:

      CREATE TABLE s3 (
        k1 bigint NOT NULL,
        c1 int DEFAULT NULL,
        PRIMARY KEY (k1)
      );
       
      SELECT k1, c1, avg(c1) OVER (ORDER BY c1) FROM s3 WHERE k1 < 100 ORDER BY k1;
      

      If you leave off the final ORDER BY k1 or the WHERE clause, no assert. If k1 is not a key, no assert.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                varun Varun Gupta
                Reporter:
                David.Hall David Hall
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: