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

Crash with order by expression containing window functions

    XMLWordPrintable

Details

    Description

      create table t1 (i int);
      insert into t1 values (1),(2),(3);
       
      CREATE TABLE t2 ( id int) ;
      INSERT INTO t2 values (1),(2),(3);
       
      SELECT * FROM t1 WHERE (i) IN (SELECT 1 FROM t2 ORDER BY benchmark(1, sum(id) over ()));
      

      +test cases from MDEV-14791, wrapped as WHERE IN ()

      CREATE TABLE t2 ( id int) ;
      INSERT INTO t2 values (1),(2),(3);
       
      CREATE TABLE t1 (b1 BIT, b2 BIT, b3 BIT, b4 BIT , b5 BIT, b6 BIT);
      INSERT INTO t1 VALUES (1,0,0,1,0,1),(0,1,0,0,1,0);
       
      SELECT * FROM t2 WHERE (id) IN  
      (SELECT b1 from t1 order by row_number() over (ORDER BY b6) + 1);
       
      # Cleanup
      DROP TABLE t1,t2;
      

      Fails on non-debug and debug builds, on 10.2-10.5

      10.2 2db6eb142956cd1744cf5

       
      201209  9:49:55 [ERROR] mysqld got signal 11 ;
      Server version: 10.2.37-MariaDB-debug-log
       
      sql/field.h:1151(Field::set_notnull(long long))[0x556b282b2243]
      sql/item.cc:6415(Item::save_in_field(Field*, bool))[0x556b28b8992c]
      sql/sql_window.cc:2534(save_window_function_values(List<Item_window_func>&, TABLE*, unsigned char*))[0x556b2898b5cf]
      sql/sql_window.cc:2681(compute_window_func(THD*, List<Item_window_func>&, List<Cursor_manager>&, TABLE*, SORT_INFO*))[0x556b2898c002]
      sql/sql_window.cc:2782(Window_func_runner::exec(THD*, TABLE*, SORT_INFO*))[0x556b2898c645]
      sql/sql_window.cc:2810(Window_funcs_sort::exec(JOIN*, bool))[0x556b2898c896]
      sql/sql_window.cc:2937(Window_funcs_computation::exec(JOIN*, bool))[0x556b2898d555]
      sql/sql_select.cc:26853(AGGR_OP::end_send())[0x556b28628f6b]
      sql/sql_select.cc:18577(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x556b285ea1e4]
      sql/sql_select.cc:18813(sub_select(JOIN*, st_join_table*, bool))[0x556b285ead8a]
      sql/sql_select.cc:18408(do_select(JOIN*, Procedure*))[0x556b285e9264]
      sql/sql_select.cc:3641(JOIN::exec_inner())[0x556b2858023a]
      sql/sql_select.cc:3437(JOIN::exec())[0x556b2857ddac]
      sql/opt_subselect.cc:5405(join_tab_execution_startup(st_join_table*))[0x556b2893f100]
      sql/sql_select.cc:18851(sub_select(JOIN*, st_join_table*, bool))[0x556b285eb2db]
      sql/sql_select.cc:19082(evaluate_join_record(JOIN*, st_join_table*, int))[0x556b285ece6f]
      sql/sql_select.cc:18862(sub_select(JOIN*, st_join_table*, bool))[0x556b285eb660]
      sql/sql_select.cc:18406(do_select(JOIN*, Procedure*))[0x556b285e9173]
      sql/sql_select.cc:3641(JOIN::exec_inner())[0x556b2858023a]
      sql/sql_select.cc:3437(JOIN::exec())[0x556b2857ddac]
      sql/sql_select.cc:3838(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x556b2858140c]
      sql/sql_select.cc:361(handle_select(THD*, LEX*, select_result*, unsigned long))[0x556b2855df80]
      sql/sql_parse.cc:6247(execute_sqlcom_select(THD*, TABLE_LIST*))[0x556b284d2057]
      sql/sql_parse.cc:3558(mysql_execute_command(THD*))[0x556b284bd3f1]
      sql/sql_parse.cc:7762(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x556b284db3a6]
      sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x556b284b21f2]
      sql/sql_parse.cc:1381(do_command(THD*))[0x556b284aec17]
      sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x556b288560e3]
      sql/sql_connect.cc:1242(handle_one_connection)[0x556b288559a4]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x556b29cee012]
      nptl/pthread_create.c:487(start_thread)[0x7f041ba1cfa3]
      x86_64/clone.S:97(clone)[0x7f041b3a04cf]
       
      Query (0x62b000000290): SELECT * FROM t1 WHERE (i) IN (SELECT 1 FROM t2 ORDER BY benchmark(1, sum(id) over ()))
      
      

      Attachments

        Issue Links

          Activity

            People

              varun Varun Gupta (Inactive)
              alice Alice Sherepa
              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.