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

              • Assignee:
                Unassigned
                Reporter:
                sbester1 sbester1
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: