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

window functions crash

    XMLWordPrintable

Details

    Description

      Version: '10.4.8-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      [ERROR] mysqld got exception 0xc0000005 ;
      terribly wrong...
      mysqld.exe!Item_field::used_tables()[item.cc:3324]
      mysqld.exe!Item_window_func::update_used_tables()[item_windowfunc.cc:73]
      mysqld.exe!Item_sum::update_used_tables()[item_sum.cc:553]
      mysqld.exe!Item_sum::check_sum_func()[item_sum.cc:321]
      mysqld.exe!Item_sum_hybrid_simple::fix_fields()[item_windowfunc.cc:365]
      mysqld.exe!Item_window_func::fix_fields()[item_windowfunc.cc:118]
      mysqld.exe!setup_fields()[sql_base.cc:7640]
      mysqld.exe!JOIN::prepare()[sql_select.cc:1198]
      mysqld.exe!mysql_select()[sql_select.cc:4568]
      mysqld.exe!handle_select()[sql_select.cc:413]
      mysqld.exe!execute_sqlcom_select()[sql_parse.cc:6357]
      mysqld.exe!mysql_execute_command()[sql_parse.cc:3899]
      mysqld.exe!mysql_parse()[sql_parse.cc:7914]
      mysqld.exe!dispatch_command()[sql_parse.cc:1845]
      mysqld.exe!do_command()[sql_parse.cc:1359]
      mysqld.exe!threadpool_process_request()[threadpool_common.cc:366]
      mysqld.exe!tp_callback()[threadpool_common.cc:193]
      

      How to Repeat:

       drop table if exists t;
       create table t(a int) engine=innodb;
       select ntile(5) over(), 
        last_value(std(0) over(w2 partition by a)) 
        over(order by a) 
       from t window w1 as (w2 order by a);
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sbester1 sbester1
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.