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

Server crash in Field_iterator_table::set or Assertion `table_ref->table || table_ref->view' failed in Field_iterator_table_ref::set_field_iterator

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.3, 10.4
    • 10.4
    • None
    • None

    Description

      create table t1 (v1 varchar(1));
      insert into t1 values ('a'),('b'),('c');
       
      DELIMITER ##;
      create  procedure sp () 
      begin 
      select 1 from t1 group by left((values(v1)), null) ; 
      end ;##
       
      DELIMITER ;##
      --error 4100
      call sp;
      call sp;
      

      10.3 705fd4e94304215454ef7c35

      mysqld: /git/10.3/sql/table.cc:6040: void Field_iterator_table_ref::set_field_iterator(): Assertion `table_ref->table || table_ref->view' failed.
       
      stdlib/abort.c:91(__GI_abort)[0x7fe330d9802a]
      assert/assert.c:92(__assert_fail_base)[0x7fe330d8ebd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7fe330d8ec82]
      sql/table.cc:6041(Field_iterator_table_ref::set_field_iterator())[0x5557a0958326]
      sql/table.cc:6058(Field_iterator_table_ref::set(TABLE_LIST*))[0x5557a095872f]
      sql/sql_base.cc:7854(insert_fields(THD*, Name_resolution_context*, char const*, char const*, List_iterator<Item>*, bool, unsigned int*))[0x5557a0582c79]
      sql/sql_base.cc:7309(setup_wild(THD*, TABLE_LIST*, List<Item>&, List<Item>*, unsigned int, unsigned int*))[0x5557a057f626]
      sql/sql_select.cc:1091(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5557a074466e]
      sql/item_subselect.cc:3667(subselect_single_select_engine::prepare(THD*))[0x5557a0f8e1fe]
      sql/item_subselect.cc:276(Item_subselect::fix_fields(THD*, Item**))[0x5557a0f6e307]
      sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x5557a048c445]
      sql/item_func.cc:363(Item_func::fix_fields(THD*, Item**))[0x5557a0eb27fd]
      sql/item_strfunc.cc:106(Item_str_func::fix_fields(THD*, Item**))[0x5557a0f2f1f9]
      sql/item.h:825(Item::fix_fields_if_needed(THD*, Item**))[0x5557a048c445]
      sql/item.h:828(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x5557a048c473]
      sql/item.h:837(Item::fix_fields_if_needed_for_order_by(THD*, Item**))[0x5557a0800b11]
      sql/sql_select.cc:23141(find_order_in_list(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, st_order*, List<Item>&, List<Item>&, bool, bool, bool))[0x5557a07de152]
      sql/sql_select.cc:23244(setup_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<Item>&, List<Item>&, st_order*, bool*, bool))[0x5557a07de909]
      sql/sql_select.cc:669(setup_without_group(THD*, Bounds_checked_array<Item*>, TABLE_LIST*, List<TABLE_LIST>&, List<Item>&, List<Item>&, Item**, st_order*, st_order*, List<Window_spec>&, List<Item_window_func>&, bool*, unsigned int*))[0x5557a0740288]
      sql/sql_select.cc:1107(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5557a0744c48]
      sql/sql_select.cc:4217(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*))[0x5557a0762b58]
      sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5557a073e11f]
      sql/sql_parse.cc:6547(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5557a06c48a3]
      sql/sql_parse.cc:3768(mysql_execute_command(THD*))[0x5557a06b2ffd]
      sql/sp_head.cc:3594(sp_instr_stmt::exec_core(THD*, unsigned int*))[0x5557a04d535c]
      sql/sp_head.cc:3322(sp_lex_keeper::reset_lex_and_exec_core(THD*, unsigned int*, bool, sp_instr*))[0x5557a04d3c8f]
      sql/sp_head.cc:3500(sp_instr_stmt::execute(THD*, unsigned int*))[0x5557a04d4b44]
      sql/sp_head.cc:1354(sp_head::execute(THD*, bool))[0x5557a04c7f13]
      sql/sp_head.cc:2294(sp_head::execute_procedure(THD*, List<Item>*))[0x5557a04cd0d5]
      sql/sql_parse.cc:2950(do_execute_sp(THD*, sp_head*))[0x5557a06adaff]
      sql/sql_parse.cc:3190(Sql_cmd_call::execute(THD*))[0x5557a06af542]
      sql/sql_parse.cc:6284(mysql_execute_command(THD*))[0x5557a06c2639]
      sql/sql_parse.cc:8091(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5557a06cd2bf]
      sql/sql_parse.cc:1852(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5557a06a7d82]
      sql/sql_parse.cc:1395(do_command(THD*))[0x5557a06a4f1a]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x5557a09f7937]
      sql/sql_connect.cc:1309(handle_one_connection)[0x5557a09f7314]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x5557a1d1e727]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7fe3319d36ba]
      x86_64/clone.S:111(clone)[0x7fe330e6841d]
       
      Query (0x62500016f988): select 1 from t1 group by left((values(v1)), null)
      
      

      Attachments

        Issue Links

          Activity

            People

              igor Igor Babaev
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.