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

Server crash when table value constructor uses a subselect

    XMLWordPrintable

Details

    Description

      reporting the case separately, as requested (from MDEV-22786)

      VALUES ((SELECT 1));
      

      10.3 eaeb8ec4b87882711ecb8e1c7

      210125 10:12:15 [ERROR] mysqld got signal 11 ;
       
      Server version: 10.3.28-MariaDB-debug-log
       
      sql/item_subselect.cc:294(Item_subselect::fix_fields(THD*, Item**))[0x5632cea44047]
      sql/item.h:830(Item::fix_fields_if_needed(THD*, Item**))[0x5632cddfac53]
      sql/sql_tvc.cc:62(fix_fields_for_tvc(THD*, List_iterator_fast<List<Item> >&))[0x5632ce5fc562]
      sql/sql_tvc.cc:238(table_value_constr::prepare(THD*, st_select_lex*, select_result*, st_select_lex_unit*))[0x5632ce5fd677]
      sql/sql_union.cc:1029(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long))[0x5632ce32f405]
      sql/sql_union.cc:39(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x5632ce32538f]
      sql/sql_select.cc:360(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5632ce127023]
      sql/sql_parse.cc:6316(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5632ce0937a0]
      sql/sql_parse.cc:3847(mysql_execute_command(THD*))[0x5632ce0812e0]
      sql/sql_parse.cc:7840(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5632ce09d897]
      sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5632ce073f6c]
      sql/sql_parse.cc:1398(do_command(THD*))[0x5632ce0706a7]
      sql/sql_connect.cc:1403(do_handle_one_connection(CONNECT*))[0x5632ce461772]
      sql/sql_connect.cc:1309(handle_one_connection)[0x5632ce46102a]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5632cfbc79ff]
      nptl/pthread_create.c:487(start_thread)[0x7f1b648defa3]
      x86_64/clone.S:97(clone)[0x7f1b642624cf]
       
      Query (0x62b000000410): VALUES ((select 1))
      

      Attachments

        Issue Links

          Activity

            People

              igor Igor Babaev
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.