Assertion `0' failed in Field_new_decimal::get_equal_const_item

CREATE TABLE t (a DECIMAL(5,2), b INT);

SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t);

# Cleanup

DROP TABLE t;

mysqld: /src/sql/field.cc:3624: virtual Item* Field_new_decimal::get_equal_const_item(THD*, const Value_source::Context&, Item*): Assertion `0' failed.

221118 16:32:15 [ERROR] mysqld got signal 6 ;

#7  0x00007fcd5cbae662 in __GI___assert_fail (assertion=0x55a51741fa20 "0", file=0x55a517421fc0 "/src/sql/field.cc", line=3624, function=0x55a517424620 "virtual Item* Field_new_decimal::get_equal_const_item(THD*, const Value_source::Context&, Item*)") at assert.c:101

#8  0x000055a515b95126 in Field_new_decimal::get_equal_const_item (this=0x619000081700, thd=0x62a000060208, ctx=..., const_item=0x62b000003e28) at /src/sql/field.cc:3624

#9  0x000055a515ca30f1 in Item_field::propagate_equal_fields (this=0x62b000000ba8, thd=0x62a000060208, ctx=..., arg=0x62b000004260) at /src/sql/item.cc:6552

#10 0x000055a515caaa91 in Item::propagate_equal_fields_and_change_item_tree (this=0x62b000000ba8, thd=0x62a000060208, ctx=..., cond=0x62b000004260, place=0x62b0000056f8) at /src/sql/item.cc:7593

#11 0x000055a515d690b0 in Item_args::propagate_equal_fields (this=0x62b0000056f0, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.cc:561

#12 0x000055a515392d02 in Item_func::propagate_equal_fields (this=0x62b000005668, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.h:324

#13 0x000055a515caaa91 in Item::propagate_equal_fields_and_change_item_tree (this=0x62b000005668, thd=0x62a000060208, ctx=..., cond=0x62b000004260, place=0x62b0000025f8) at /src/sql/item.cc:7593

#14 0x000055a515d690b0 in Item_args::propagate_equal_fields (this=0x62b0000025f0, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.cc:561

#15 0x000055a515392d02 in Item_func::propagate_equal_fields (this=0x62b000002568, thd=0x62a000060208, ctx=..., cond=0x62b000004260) at /src/sql/item_func.h:324

#16 0x000055a5155e274f in Item_func::build_equal_items (this=0x62b000002568, thd=0x62a000060208, inherited=0x62b000004260, link_item_fields=false, cond_equal_ref=0x0) at /src/sql/sql_select.cc:14649

#17 0x000055a5155e117e in Item_cond_and::build_equal_items (this=0x62b000004178, thd=0x62a000060208, inherited=0x62b000004260, link_item_fields=true, cond_equal_ref=0x62b000004830) at /src/sql/sql_select.cc:14504

#18 0x000055a5155e2c99 in build_equal_items (join=0x62b0000043f8, cond=0x62b000004178, inherited=0x0, join_list=0x62a000064a20, ignore_on_conds=false, cond_equal_ref=0x62b000004830, link_equal_fields=true) at /src/sql/sql_select.cc:14751

#19 0x000055a5155ec18e in optimize_cond (join=0x62b0000043f8, conds=0x62b000004178, join_list=0x62a000064a20, ignore_on_conds=false, cond_value=0x62b000004708, cond_equal=0x62b000004830, flags=1) at /src/sql/sql_select.cc:16397

#20 0x000055a51557fc27 in JOIN::optimize_inner (this=0x62b0000043f8) at /src/sql/sql_select.cc:1787

#21 0x000055a51557d256 in JOIN::optimize (this=0x62b0000043f8) at /src/sql/sql_select.cc:1542

#22 0x000055a51559a56b in mysql_select (thd=0x62a000060208, tables=0x62b0000004e0, wild_num=1, fields=..., conds=0x62b000004178, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x62b0000043c8, unit=0x62a0000640c0, select_lex=0x62a000064880) at /src/sql/sql_select.cc:4368

#23 0x000055a515570f0b in handle_select (thd=0x62a000060208, lex=0x62a000064000, result=0x62b0000043c8, setup_tables_done_option=0) at /src/sql/sql_select.cc:372

#24 0x000055a5154e5d79 in execute_sqlcom_select (thd=0x62a000060208, all_tables=0x62b0000004e0) at /src/sql/sql_parse.cc:6340

#25 0x000055a5154d3e4a in mysql_execute_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:3871

#26 0x000055a5154ef676 in mysql_parse (thd=0x62a000060208, rawbuf=0x62b000000228 "SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t)", length=88, parser_state=0x7fcd51fc4950, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:7855

#27 0x000055a5154c6cc4 in dispatch_command (command=COM_QUERY, thd=0x62a000060208, packet=0x6290000eb209 "SELECT * FROM t WHERE a <= SOME (SELECT 8 UNION SELECT 5) AND a = (SELECT SUM(b) FROM t)", packet_length=88, is_com_multi=false, is_next_command=false) at /src/sql/sql_parse.cc:1852

#28 0x000055a5154c387c in do_command (thd=0x62a000060208) at /src/sql/sql_parse.cc:1398

#29 0x000055a515887236 in do_handle_one_connection (connect=0x608000000ca8) at /src/sql/sql_connect.cc:1403

#30 0x000055a515886b32 in handle_one_connection (arg=0x608000000ca8) at /src/sql/sql_connect.cc:1308

#31 0x000055a516e3388d in pfs_spawn_thread (arg=0x615000004e08) at /src/storage/perfschema/pfs.cc:1869

#32 0x00007fcd5cd59ea7 in start_thread (arg=<optimized out>) at pthread_create.c:477

#33 0x00007fcd5cc79aef in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95