Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL)
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
- relates to
-
MDEV-4958 Adding datatype UUID
- Closed
-
MDEV-27207 Assertion `!m_null_value' failed in int FixedBinTypeBundle<FbtImpl>::cmp_item_fbt::compare or in cmp_item_inet6::compare
- Closed