XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
    • N/A
    • Optimizer
    • None

    Description

      CREATE TABLE v0 ( v1 INTEGER UNSIGNED NULL ) engine=innodb;
      INSERT INTO v0 ( v1 ) VALUES ( NULL ) ;
      INSERT INTO v0 ( v1 ) VALUES ( 53 ) ;
      INSERT INTO v0 ( v1 ) VALUES ( 0 ) ;
      SELECT * FROM v0 WHERE v1 = ( SELECT * FROM v0 WHERE v1 >= 1 GROUP BY v1 , v1 HAVING v1 * 1 ORDER BY v1 / 1 ) GROUP BY v1 HAVING v1 + v1 OR v1 = 1 * ( 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + ( SELECT 1 UNION SELECT 1 UNION SELECT 1 ) * 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 IN ( SELECT 1 UNION SELECT 1 UNION SELECT 'x' ) ) ; 
      

      Stack Trace:Attempting backtrace. You can use the following information to find out
      where mysqld died. If you see no messages after this, something went
      terribly wrong...
      stack_bottom = 0x7fbdf3951880 thread_stack 0x5fc00
      /usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x781b5b]
      mysys/stacktrace.c:215(my_print_stacktrace)[0x228cfae]
      sql/signal_handler.cc:0(handle_fatal_signal)[0x12bd0d2]
      sigaction.c:0(__restore_rt)[0x7fbe176ec420]
      sql/item_subselect.cc:1297(Item_singlerow_subselect::store(unsigned int, Item*))[0x1595719]
      sql/sql_list.h:441(base_list_iterator::next_fast())[0xa1e3da]
      sql/sql_select.cc:24771(end_send(JOIN*, st_join_table*, bool))[0xc3a8aa]
      sql/sql_select.cc:23737(evaluate_join_record(JOIN*, st_join_table*, int))[0xca16a3]
      /usr/local/mysql/bin/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x661)[0xbe6c51]
      /usr/local/mysql/bin/mariadbd(_ZN4JOIN10exec_innerEv+0x2681)[0xc48751]
      sql/sql_select.cc:4721(JOIN::exec())[0xc45f19]
      sql/sql_select.cc:5251(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe89b8]
      /usr/local/mysql/bin/mariadbd(_ZN18st_select_lex_unit10exec_innerEv+0x183e)[0xdfa01e]
      sql/item_subselect.cc:4188(subselect_union_engine::exec())[0x15b5c25]
      sql/item_subselect.cc:817(Item_subselect::exec())[0x159115c]
      sql/item_subselect.cc:1462(Item_singlerow_subselect::val_int())[0x15968a3]
      /usr/local/mysql/bin/mariadbd(_ZN13Item_func_mul6int_opEv+0x7a)[0x144369a]
      sql/item_func.cc:1130(Item_func_plus::int_op())[0x1441294]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
      sql/item.cc:10173(Item_cache_int::cache_value())[0x1358ef2]
      sql/item_cmpfunc.cc:1483(Item_in_optimizer::invisible_mode())[0x1397082]
      sql/item.h:1455(Item::to_longlong_null())[0x1443739]
      sql/sql_type.cc:8682(Type_handler_int_result::Item_eq_value(THD*, Type_cmp_attributes const*, Item*, Item*) const)[0x10e7225]
      sql/item_cmpfunc.cc:6931(Item_equal::add_const(THD*, Item*))[0x13d1504]
      /usr/local/mysql/bin/mariadbd(_Z21check_simple_equalityP3THDRKN12Value_source7ContextEP4ItemS6_P10COND_EQUAL+0xadd)[0xc77f4d]
      sql/sql_select.cc:17577(Item_func_eq::check_equality(THD*, COND_EQUAL*, List<Item>*))[0xc79631]
      sql/sql_select.cc:17798(Item_func_eq::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0xc7c04f]
      sql/sql_select.cc:17761(Item_cond::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0xc7bc86]
      sql/opt_subselect.cc:6294(and_new_conditions_to_optimized_cond(THD*, Item*, COND_EQUAL*, List<Item>&, Item::cond_result))[0xfe89d0]
      /usr/local/mysql/bin/mariadbd(_ZN4JOIN14optimize_innerEv+0x2bad)[0xc164dd]
      /usr/local/mysql/bin/mariadbd(_ZN4JOIN8optimizeEv+0x176)[0xbffb46]
      sql/sql_select.cc:5237(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0xbe886f]
      sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
      sql/sql_parse.cc:6041(execute_sqlcom_select(THD*, TABLE_LIST*))[0xb41bc6]
      /usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x18b7)[0xb319a7]
      sql/sql_class.h:2830(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xb24c79]
      /usr/local/mysql/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2cf8)[0xb1e648]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0xb25971]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0xf0d066]
      sql/sql_connect.cc:1322(handle_one_connection)[0xf0caa9]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x19d710b]
      nptl/pthread_create.c:478(start_thread)[0x7fbe176e0609]
      addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
      /lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fbe173f8133]

      Attachments

        Issue Links

          Activity

            People

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