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

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

          Transition Time In Source Status Execution Times
          Varun Gupta (Inactive) made transition -
          Open In Progress
          		6h 15m 1
          Varun Gupta (Inactive) made transition -
          In Progress In Review
          		742d 19h 1m 1
          Sergei Petrunia made transition -
          In Review Stalled
          		1d 8h 14m 1
          Varun Gupta (Inactive) made transition -
          Stalled Closed
          		15h 36m 1

          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.