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

Assertion `!is_null()' failed in FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt()

    XMLWordPrintable

Details

    Description

      CREATE TABLE t1 ( i6 inet6, a1 time, a2 varchar(10));
      INSERT INTO t1 VALUES ('::','09:43:12','uw'), ('70:ef59::46:c7b:f:678:bd9f','00:00:00','a');
       
      SELECT group_concat( if(a1, i6, a2) ORDER BY 1) FROM t1;
       
      drop table t1;
      

      10.7 06988bdcaa2d1af2c178c199b7

       
      /10.7/sql/sql_type_fixedbin.h:1204: FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt() const [with FbtImpl = Inet6]: Assertion `!is_null()' failed.
      211110 13:45:54 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.7.2-MariaDB-debug-log
       
      ??:0(__assert_fail)[0x7f5a1ac48f36]
      sql/sql_type_fixedbin.h:1205(FixedBinTypeBundle<Inet6>::Field_fbt::to_fbt() const)[0x559bbc3df5c3]
      sql/sql_type_fixedbin.h:1210(FixedBinTypeBundle<Inet6>::Field_fbt::val_str(String*, String*))[0x559bbc3dc6fc]
      sql/field.h:1030(Field::val_str(String*))[0x559bba1d3916]
      sql/field.h:1582(Field::val_str(String*, unsigned char const*))[0x559bbaacbc82]
      sql/item_sum.h:2007(Item_func_group_concat::get_str_from_field(Item*, Field*, String*, unsigned char const*, unsigned long))[0x559bbb07c8c4]
      sql/item_sum.cc:3849(dump_leaf_key)[0x559bbb06de13]
      mysys/tree.c:590(tree_walk_left_root_right)[0x559bbc278eb8]
      mysys/tree.c:576(tree_walk)[0x559bbc278d29]
      sql/item_sum.cc:4451(Item_func_group_concat::val_str(String*))[0x559bbb074fb9]
      sql/sql_type.cc:7455(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x559bbab349c2]
      sql/sql_type.h:5441(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x559bba92e4ac]
      sql/item.h:1228(Item::send(Protocol*, st_value*))[0x559bba148b54]
      sql/protocol.cc:1324(Protocol::send_result_set_row(List<Item>*))[0x559bba200c37]
      sql/sql_class.cc:3060(select_send::send_data(List<Item>&))[0x559bba3a9442]
      sql/sql_class.h:5605(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x559bba6c2d2d]
      sql/sql_select.cc:22457(end_send_group(JOIN*, st_join_table*, bool))[0x559bba67f63a]
      sql/sql_select.cc:21010(sub_select(JOIN*, st_join_table*, bool))[0x559bba673d1a]
      sql/sql_select.cc:20614(do_select(JOIN*, Procedure*))[0x559bba672826]
      sql/sql_select.cc:4735(JOIN::exec_inner())[0x559bba5fed9d]
      sql/sql_select.cc:4514(JOIN::exec())[0x559bba5fc2a2]
      sql/sql_select.cc:4995(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*))[0x559bba60080b]
      sql/sql_select.cc:545(handle_select(THD*, LEX*, select_result*, unsigned long))[0x559bba5d0cc7]
      sql/sql_parse.cc:6253(execute_sqlcom_select(THD*, TABLE_LIST*))[0x559bba4f7e0c]
      sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x559bba4e6903]
      sql/sql_parse.cc:8028(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x559bba5030ab]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x559bba4d91ba]
      sql/sql_parse.cc:1402(do_command(THD*, bool))[0x559bba4d5ede]
      sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x559bba97645b]
      sql/sql_connect.cc:1314(handle_one_connection)[0x559bba975ce7]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x559bbb616f49]
      nptl/pthread_create.c:478(start_thread)[0x7f5a1b161609]
      ??:0(clone)[0x7f5a1ad34293]
       
      Query (0x61000000ae70): SELECT group_concat( if(a1, i6, a2) ORDER BY 1) FROM t1
      

      and the same with uuid:

      CREATE TABLE t1 ( i6 uuid, a1 time, a2 varchar(10));
      INSERT INTO t1 VALUES ('ffffffff-ffff-ffff-ffff-fffffffffffe','09:43:12','uw'), (uuid(),'00:00:00','a');
       
      SELECT group_concat( if(a1, i6, a2) ORDER BY 1) FROM t1;
       
      drop table t1;
      

      10.7 06988bdcaa2d1af2c178c199b7

      /10.7/sql/sql_type_fixedbin.h:1204: FixedBinTypeBundle<FbtImpl>::Fbt FixedBinTypeBundle<FbtImpl>::Field_fbt::to_fbt() const [with FbtImpl = UUID]: Assertion `!is_null()' failed.
      211110 13:42:49 [ERROR] mysqld got signal 6 ;
       
      Server version: 10.7.2-MariaDB-debug-log
       
      ??:0(__assert_fail)[0x7fc85c578f36]
      sql/sql_type_fixedbin.h:1205(FixedBinTypeBundle<UUID>::Field_fbt::to_fbt() const)[0x55e6a6c15f89]
      sql/sql_type_fixedbin.h:1210(FixedBinTypeBundle<UUID>::Field_fbt::val_str(String*, String*))[0x55e6a6c131ea]
      sql/field.h:1030(Field::val_str(String*))[0x55e6a49f0916]
      sql/field.h:1582(Field::val_str(String*, unsigned char const*))[0x55e6a52e8c82]
      sql/item_sum.h:2007(Item_func_group_concat::get_str_from_field(Item*, Field*, String*, unsigned char const*, unsigned long))[0x55e6a58998c4]
      sql/item_sum.cc:3849(dump_leaf_key)[0x55e6a588ae13]
      mysys/tree.c:590(tree_walk_left_root_right)[0x55e6a6a95eb8]
      mysys/tree.c:576(tree_walk)[0x55e6a6a95d29]
      sql/item_sum.cc:4451(Item_func_group_concat::val_str(String*))[0x55e6a5891fb9]
      sql/sql_type.cc:7455(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x55e6a53519c2]
      sql/sql_type.h:5441(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x55e6a514b4ac]
      sql/item.h:1228(Item::send(Protocol*, st_value*))[0x55e6a4965b54]
      sql/protocol.cc:1324(Protocol::send_result_set_row(List<Item>*))[0x55e6a4a1dc37]
      sql/sql_class.cc:3060(select_send::send_data(List<Item>&))[0x55e6a4bc6442]
      sql/sql_class.h:5605(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x55e6a4edfd2d]
      sql/sql_select.cc:22457(end_send_group(JOIN*, st_join_table*, bool))[0x55e6a4e9c63a]
      sql/sql_select.cc:21010(sub_select(JOIN*, st_join_table*, bool))[0x55e6a4e90d1a]
      sql/sql_select.cc:20614(do_select(JOIN*, Procedure*))[0x55e6a4e8f826]
      sql/sql_select.cc:4735(JOIN::exec_inner())[0x55e6a4e1bd9d]
      sql/sql_select.cc:4514(JOIN::exec())[0x55e6a4e192a2]
      sql/sql_select.cc:4995(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*))[0x55e6a4e1d80b]
      sql/sql_select.cc:545(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55e6a4dedcc7]
      sql/sql_parse.cc:6253(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55e6a4d14e0c]
      sql/sql_parse.cc:3944(mysql_execute_command(THD*, bool))[0x55e6a4d03903]
      sql/sql_parse.cc:8028(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55e6a4d200ab]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55e6a4cf61ba]
      sql/sql_parse.cc:1402(do_command(THD*, bool))[0x55e6a4cf2ede]
      sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x55e6a519345b]
      sql/sql_connect.cc:1314(handle_one_connection)[0x55e6a5192ce7]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55e6a5e33f49]
      nptl/pthread_create.c:478(start_thread)[0x7fc85ca91609]
      ??:0(clone)[0x7fc85c664293]
       
      Query (0x61000000ae70): SELECT group_concat( if(a1, i6, a2) ORDER BY 1) FROM t1
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.