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

Assertion `typeid(*copy) == typeid(*this)' failed in Item::get_copy

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Duplicate
    • 10.6, 10.11
    • 10.5.26
    • Server
    • None

    Description

      CREATE TABLE t1 ( c0 date) ;
      CREATE ALGORITHM=TEMPTABLE VIEW v1 AS SELECT * FROM t1;
       
      SELECT c0  FROM v1 WHERE  c0 IN ( 'a', 'b', 'c' )  ;
      

      bb-10.6-release 534524297d5171d638a7c0e9f1f446cab1311845

      Version: '10.6.19-MariaDB-debug-log'  
      mariadbd: /git/10.6/sql/item.h:1885: Item* Item::get_copy(THD*) const: Assertion `typeid(*copy) == typeid(*this)' failed.
      240801 21:32:34 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.6.19-MariaDB-debug-log source revision: 534524297d5171d638a7c0e9f1f446cab1311845
       
      /lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f42d1262fd6]
      sql/item.h:1887(Item::get_copy(THD*) const)[0x5566f6541eab]
      sql/item.h:5263(Item_date_literal::do_build_clone(THD*) const)[0x5566f709aeb9]
      sql/item.h:1899(Item::build_clone(THD*) const)[0x5566f673e463]
      sql/item_cmpfunc.cc:7902(Item_equal::create_pushable_equalities(THD*, List<Item>*, bool (Item::*)(unsigned char*), unsigned char*, bool))[0x5566f71dcb70]
      sql/item.cc:7847(Item::build_pushable_cond(THD*, bool (Item::*)(unsigned char*), unsigned char*))[0x5566f715cc3c]
      sql/sql_derived.cc:1544(pushdown_cond_for_derived(THD*, Item*, TABLE_LIST*))[0x5566f673cce8]
      sql/sql_select.cc:2407(JOIN::optimize_inner())[0x5566f68ea321]
      sql/sql_select.cc:1913(JOIN::optimize())[0x5566f68e4c7d]
      sql/sql_select.cc:5158(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*))[0x5566f69070bc]
      sql/sql_select.cc:559(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5566f68d60cf]
      sql/sql_parse.cc:6380(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5566f68355c6]
      sql/sql_parse.cc:3988(mysql_execute_command(THD*, bool))[0x5566f68239f4]
      sql/sql_parse.cc:8165(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5566f684079c]
      sql/sql_parse.cc:1899(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5566f6815cc9]
      sql/sql_parse.cc:1410(do_command(THD*, bool))[0x5566f6812a0a]
      sql/sql_connect.cc:1417(do_handle_one_connection(CONNECT*, bool))[0x5566f6c9d511]
      sql/sql_connect.cc:1321(handle_one_connection)[0x5566f6c9ce6e]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x5566f793d722]
      nptl/pthread_create.c:478(start_thread)[0x7f42d177d609]
       
      Query (0x62b0000852a8): SELECT c0  FROM v1 WHERE  c0 IN ( 'a', 'b', 'c' )
       
      
      

      Attachments

        Issue Links

          Activity

            People

              oleg.smirnov Oleg Smirnov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.