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

Server crashes when Analyze format=json is run with a window function with empty PARTITION BY and ORDER BY clauses

    XMLWordPrintable

    Details

      Description

      The mtr test

      create table t1 (a int);
      insert into t1 values (1),(2),(3);
      analyze format=json
      SELECT DISTINCT BIT_OR(100) OVER () FROM t1
      GROUP BY LEFT('2018-08-24', 100) ;
      drop table t1;
      

      The query runs fine without the ANALYZE format=json

        Attachments

          Activity

            People

            Assignee:
            varun Varun Gupta
            Reporter:
            varun Varun Gupta
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: