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

Assertion `0' failed in Field_blob_compressed::new_key_field

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.3(EOL), 10.4(EOL)
    • N/A
    • N/A
    • None

    Description

      Reproducible with Innodb on 10.3-10.4, with join_cache_level>2;

      --source include/have_innodb.inc
      set join_cache_level=3;
       
      create table t1 (v varchar(20)) engine=innodb;
      create table t2 (a int, b blob compressed) engine=innodb;
      insert into t2 values (1,'iqi'),(2,'icn'),(3,''),(4,'at'),(5,'dsg');
       
      select * from (t1 join t2 on t2.b = t1.v);
      

      10.3 36be0a5aef0376c526d68007da1

      mysqld: /10.3/sql/field.h:3831: virtual Field* Field_blob_compressed::new_key_field(MEM_ROOT*, TABLE*, uchar*, uint32, uchar*, uint): Assertion `0' failed.
      190131 11:11:22 [ERROR] mysqld got signal 6 ;
       
      assert/assert.c:92(__assert_fail_base)[0x7f41f846dbd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f41f846dc82]
      /10.3/sql/mysqld(+0x16520dd)[0x557ae95190dd]
      sql/sql_select.h:1843(store_key::store_key(THD*, Field*, unsigned char*, unsigned char*, unsigned int))[0x557ae8fb612f]
      sql/sql_select.h:1900(store_key_field::store_key_field(THD*, Field*, unsigned char*, unsigned char*, unsigned int, Field*, char const*))[0x557ae8fb66a9]
      sql/sql_select.cc:10089(get_store_key(THD*, keyuse_t*, unsigned long long, st_key_part_info*, unsigned char*, unsigned int))[0x557ae8f36681]
      sql/sql_select.cc:10007(create_ref_for_key(JOIN*, st_join_table*, keyuse_t*, bool, unsigned long long))[0x557ae8f35753]
      sql/sql_select.cc:9682(JOIN::get_best_combination())[0x557ae8f32a3d]
      sql/sql_select.cc:1935(JOIN::optimize_stage2())[0x557ae8ef9128]
      sql/sql_select.cc:1914(JOIN::optimize_inner())[0x557ae8ef8ecc]
      sql/sql_select.cc:1451(JOIN::optimize())[0x557ae8ef4a2c]
      sql/sql_select.cc:4225(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*))[0x557ae8f0ecdd]
      sql/sql_select.cc:385(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557ae8eea279]
      sql/sql_parse.cc:6548(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557ae8e70a58]
      sql/sql_parse.cc:3769(mysql_execute_command(THD*))[0x557ae8e5f1b3]
      sql/sql_parse.cc:8092(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557ae8e79473]
      sql/sql_parse.cc:1853(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557ae8e53f38]
      sql/sql_parse.cc:1396(do_command(THD*))[0x557ae8e510d0]
      sql/sql_connect.cc:1402(do_handle_one_connection(CONNECT*))[0x557ae91a43f7]
      sql/sql_connect.cc:1309(handle_one_connection)[0x557ae91a3dd4]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x557aea4cb207]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f41f90b26ba]
      x86_64/clone.S:111(clone)[0x7f41f854741d]
      

      Attachments

        Issue Links

          Activity

            People

              svoj Sergey Vojtovich
              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.