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

crash with firstvalue()/over()

    XMLWordPrintable

Details

    Description

      Version: '11.0.0-preview-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server
      Thread 18 "mysqld" received signal SIGSEGV, Segmentation fault.
      (gdb) bt
      #0  in Item::save_real_in_field at ./sql/item.cc:6834
      #1  in Item::save_in_field at ./sql/item.cc:6866
      #2  in save_window_function_values at ./sql/sql_window.cc:2775
      #3  in compute_window_func at ./sql/sql_window.cc:2927
      #4  in Window_func_runner::exec at ./sql/sql_window.cc:3042
      #5  in Window_funcs_sort::exec at ./sql/sql_window.cc:3067
      #6  in Window_funcs_computation::exec at ./sql/sql_window.cc:3196
      #7  in AGGR_OP::end_send at ./sql/sql_select.cc:31045
      #8  in sub_select_postjoin_aggr at ./sql/sql_select.cc:22319
      #9  in do_select at ./sql/sql_select.cc:22156
      #10 in JOIN::exec_inner at ./sql/sql_select.cc:4866
      #11 in JOIN::exec at ./sql/sql_select.cc:4644
      #12 in mysql_select at ./sql/sql_select.cc:5124
      #13 in handle_select at ./sql/sql_select.cc:620
      #14 in execute_sqlcom_select at ./sql/sql_parse.cc:6265
      #15 in mysql_execute_command at ./sql/sql_parse.cc:3949
      #16 in mysql_parse at ./sql/sql_parse.cc:8000
      #17 in dispatch_command at ./sql/sql_parse.cc:1894
      #18 in do_command at ./sql/sql_parse.cc:1408
      #19 in do_handle_one_connection at ./sql/sql_connect.cc:1416
      #20 in handle_one_connection at ./sql/sql_connect.cc:1318
      

      How to repeat

      drop table if exists t;
      create table t (
        c0 tinyint not null,
        c1 double not null,
        primary key (c1,c0)
      );
       
      insert into t values(1,2),(3,4);
      select 
      (
       inet6_aton(@c)
       between
       decode(last_insert_id(),charset(first_value(c1) over()))
       and
       utc_date
      ),c0
      from t;
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              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.