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

window functions crash

    XMLWordPrintable

Details

    Description

      Version: '10.3.6-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
      180427 18:45:31 [ERROR] mysqld got exception 0xc0000005 ;
      Item_field::Item_field()[item.cc:3075]
      Window_funcs_sort::setup()[sql_window.cc:3006]
      Window_funcs_computation::setup()[sql_window.cc:3045]
      JOIN::make_aggr_tables_info()[sql_select.cc:3216]
      JOIN::optimize_stage2()[sql_select.cc:2565]
      JOIN::optimize_inner()[sql_select.cc:1859]
      JOIN::optimize()[sql_select.cc:1433]
      mysql_select()[sql_select.cc:4138]
      handle_select()[sql_select.cc:370]
      execute_sqlcom_select()[sql_parse.cc:6539]
      mysql_execute_command()[sql_parse.cc:3768]
      mysql_parse()[sql_parse.cc:8006]
      dispatch_command()[sql_parse.cc:1848]
      do_command()[sql_parse.cc:1390]
      threadpool_process_request()[threadpool_common.cc:358]
      tp_callback()[threadpool_common.cc:186]
      

      How to Repeat:

      drop table if exists t;
      create table t(a int)engine=innodb;
      insert into t values(1),(2),(3);
      select ntile(124)over() from t 
      where @g not like 1
      group by @f 
      order by a;
      

      Attachments

        Issue Links

          Activity

            People

              cvicentiu Vicențiu Ciorbaru
              sbester1 sbester1
              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.