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

Assertion `field_max_length <= m_return_field_def.length || m_return_field_def.type_handler()->cmp_type() == INT_RESULT || (_current_thd()->stmt_arena->is_stmt_execute() && m_return_field_def.length == 8 && (m_return_field_def.pack_flag & (1024U|2048U)))'

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.1(EOL), 11.2, 11.4, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.3(EOL)
    • 10.5, 10.6, 10.11, 11.2, 11.4
    • None
    • None

    Description

      test, derived from MDEV-30766:

      CREATE TABLE playback ( session_id int PRIMARY KEY, customer_id int, start_time int, end_time int);
      insert into playback values (-1, 0, 1, 1),(0, 0, 1, 1);
       
      CREATE TABLE ads ( ad_id int PRIMARY KEY, customer_id int, TIMESTAMP int);
      insert into ads values (0, 0, 1),(1, 0, 1);
       
      delimiter //;
      create aggregate function any_value (x longblob) returns longblob
      begin
       loop
        fetch group next row;
        return x;
       end loop; 
      end //
      delimiter ;//
       
      select any_value(session_id) from playback join ads on playback.customer_id=ads.customer_id group by playback.customer_id;
      
      

      Version: '10.3.38-MariaDB-debug-log'
      mysqld: /10.3/src/sql/sp_head.cc:934: Field* sp_head::create_result_field(uint, const LEX_CSTRING*, TABLE*) const: Assertion `field_max_length <= m_return_field_def.length || m_return_field_def.type_handler()->cmp_type() == INT_RESULT || (_current_thd()->stmt_arena->is_stmt_execute() && m_return_field_def.length == 8 && (m_return_field_def.pack_flag & (1024U|2048U)))' failed.
      230302 12:12:42 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.3.38-MariaDB-debug-log source revision: 2743a510a156456fe57429032bf41c0da0f11198
       
      mysys/stacktrace.c:174(my_print_stacktrace)[0x55cff7fb0d5b]
      sql/signal_handler.cc:233(handle_fatal_signal)[0x55cff6c06c37]
      sigaction.c:0(__restore_rt)[0x7f803d9c5420]
      sql/sp_head.cc:941(sp_head::create_result_field(unsigned int, st_mysql_const_lex_string const*, TABLE*) const)[0x55cff6258710]
      sql/item.cc:3133(Item_sp::init_result_field(THD*, unsigned int, unsigned int, bool*, st_mysql_const_lex_string*))[0x55cff6c6872c]
      sql/item_sum.cc:1469(Item_sum_sp::copy_or_same(THD*))[0x55cff6e6bf32]
      sql/item_sum.cc:527(Item_sum::get_tmp_table_item(THD*))[0x55cff6e62805]
      sql/sql_select.cc:24920(change_refs_to_tmp_fields(THD*, Bounds_checked_array<Item*>, List<Item>&, List<Item>&, unsigned int, List<Item>&))[0x55cff65e88ec]
      sql/sql_select.cc:3108(JOIN::make_aggr_tables_info())[0x55cff6547bad]
      sql/sql_select.cc:2720(JOIN::optimize_stage2())[0x55cff6543000]
      sql/sql_select.cc:2026(JOIN::optimize_inner())[0x55cff653be54]
      sql/sql_select.cc:1542(JOIN::optimize())[0x55cff6537086]
      sql/sql_select.cc:4379(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*))[0x55cff655483b]
      sql/sql_select.cc:372(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55cff652aa1f]
      sql/sql_parse.cc:6340(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55cff649b708]
      sql/sql_parse.cc:3871(mysql_execute_command(THD*))[0x55cff648972e]
      sql/sql_parse.cc:7855(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cff64a53ea]
      sql/sql_parse.cc:1855(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cff647c3a7]
      sql/sql_parse.cc:1398(do_command(THD*))[0x55cff6478ec6]
      sql/sql_connect.cc:1404(do_handle_one_connection(CONNECT*))[0x55cff684f62d]
      sql/sql_connect.cc:1310(handle_one_connection)[0x55cff684eee7]
      perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55cff7e86201]
      nptl/pthread_create.c:478(start_thread)[0x7f803d9b9609]
      addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530ea0)
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7f803d8de133]
       
      Query (0x62b000000290): select any_value(session_id) from playback join ads on playback.customer_id=ads.customer_id group by playback.customer_id
      

      Attachments

        Issue Links

          Activity

            People

              sanja Oleksandr Byelkin
              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.