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

Assertion `typeid(*copy) == typeid(*this)' failed in Item_func_or_sum::do_build_clone

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.2(EOL), 11.4, 11.6(EOL), 11.7
    • 10.5, 10.6, 10.11, 11.4, 11.7
    • Server
    • None

    Description

      Setting to critical, as the agreement was that these failures introduced by adding a new assertion will be fixed with high priority.

      CREATE VIEW v AS SELECT 1;
      SELECT * FROM v WHERE UpdateXML('<user>N/A</user>','/a',CURRENT_USER());
       
      # Cleanup
      DROP VIEW v;
      

      10.5 5673cbe0941e105eb73b5ecf651a529f8e717b52

      mariadbd: /data/bld/10.5-asan/sql/item.h:1677: Item* Item::get_copy(THD*) const: Assertion `typeid(*copy) == typeid(*this)' failed.
      241007  2:00:32 [ERROR] mysqld got signal 6 ;
       
      #9  0x00007f423d453e32 in __GI___assert_fail (assertion=0x55aa4c115260 "typeid(*copy) == typeid(*this)", file=0x55aa4c114e40 "/data/bld/10.5-asan/sql/item.h", line=1677, function=0x55aa4c1152a0 "Item* Item::get_copy(THD*) const") at ./assert/assert.c:101
      #10 0x000055aa49d5552c in Item::get_copy (this=0x62b000039360, thd=0x62b000069218) at /data/bld/10.5-asan/sql/item.h:1677
      #11 0x000055aa4a8dc55a in Item_func_or_sum::do_build_clone (this=0x62b000039360, thd=0x62b000069218) at /data/bld/10.5-asan/sql/item.cc:2736
      #12 0x000055aa49f4899d in Item::build_clone (this=0x62b000039360, thd=0x62b000069218) at /data/bld/10.5-asan/sql/item.h:1691
      #13 0x000055aa4a8dc490 in Item_func_or_sum::do_build_clone (this=0x62b000039488, thd=0x62b000069218) at /data/bld/10.5-asan/sql/item.cc:2731
      #14 0x000055aa49f4899d in Item::build_clone (this=0x62b000039488, thd=0x62b000069218) at /data/bld/10.5-asan/sql/item.h:1691
      #15 0x000055aa4a905709 in Item::build_pushable_cond (this=0x62b000039488, thd=0x62b000069218, checker=(bool (Item::*)(Item * const, uchar *)) 0x55aa49f48c8e <Item::pushable_equality_checker_for_derived(unsigned char*)>, arg=0x620000015328 "\001") at /data/bld/10.5-asan/sql/item.cc:7798
      #16 0x000055aa49f4726a in pushdown_cond_for_derived (thd=0x62b000069218, cond=0x62b000039488, derived=0x62b0000389c0) at /data/bld/10.5-asan/sql/sql_derived.cc:1527
      #17 0x000055aa4a0e6b22 in JOIN::optimize_inner (this=0x62b00003d128) at /data/bld/10.5-asan/sql/sql_select.cc:2231
      #18 0x000055aa4a0e1949 in JOIN::optimize (this=0x62b00003d128) at /data/bld/10.5-asan/sql/sql_select.cc:1765
      #19 0x000055aa4a102a0c in mysql_select (thd=0x62b000069218, tables=0x62b0000389c0, fields=..., conds=0x62b000039488, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b00003d0f8, unit=0x62b00006d3d0, select_lex=0x62b000038330) at /data/bld/10.5-asan/sql/sql_select.cc:4902
      #20 0x000055aa4a0d2efc in handle_select (thd=0x62b000069218, lex=0x62b00006d308, result=0x62b00003d0f8, setup_tables_done_option=0) at /data/bld/10.5-asan/sql/sql_select.cc:449
      #21 0x000055aa4a039e73 in execute_sqlcom_select (thd=0x62b000069218, all_tables=0x62b0000389c0) at /data/bld/10.5-asan/sql/sql_parse.cc:6438
      #22 0x000055aa4a0282b5 in mysql_execute_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:4030
      #23 0x000055aa4a044c81 in mysql_parse (thd=0x62b000069218, rawbuf=0x62b000038238 "SELECT * FROM v WHERE UpdateXML('<user>N/A</user>','/a',CURRENT_USER())", length=71, parser_state=0x7f4233cf5c10, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:8236
      #24 0x000055aa4a019f67 in dispatch_command (command=COM_QUERY, thd=0x62b000069218, packet=0x629000235219 "SELECT * FROM v WHERE UpdateXML('<user>N/A</user>','/a',CURRENT_USER())", packet_length=71, is_com_multi=false, is_next_command=false) at /data/bld/10.5-asan/sql/sql_parse.cc:1892
      #25 0x000055aa4a0168fa in do_command (thd=0x62b000069218) at /data/bld/10.5-asan/sql/sql_parse.cc:1376
      #26 0x000055aa4a46ff04 in do_handle_one_connection (connect=0x608000002ab8, put_in_cache=true) at /data/bld/10.5-asan/sql/sql_connect.cc:1417
      #27 0x000055aa4a46f8c7 in handle_one_connection (arg=0x608000002a38) at /data/bld/10.5-asan/sql/sql_connect.cc:1319
      #28 0x000055aa4b0cdc94 in pfs_spawn_thread (arg=0x615000005318) at /data/bld/10.5-asan/storage/perfschema/pfs.cc:2201
      #29 0x00007f423d4a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
      #30 0x00007f423d52861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
      

      Attachments

        Issue Links

          Activity

            People

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