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

            varun Varun Gupta (Inactive)
            varun Varun Gupta (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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