SIGSEGV in JOIN_CACHE::reset_join and Assertion `cache != __null' failed in sub_select_cache on SELECT

CREATE TABLE t(v INT);

INSERT INTO t(v) VALUES (0);

SELECT(v=(SELECT v FROM t WHERE (v,v) IN (SELECT 1,1)) IN (1,1)) AS v1 FROM t WINDOW v2 AS(PARTITION BY v ORDER BY (SELECT 1 FROM (SELECT v FROM t WHERE (v,v) NOT IN (SELECT (''=(v IN (SELECT v FROM t WHERE v=CASE WHEN v ^ (SELECT 64 FROM t AS v3 WHERE v GROUP BY (TRUE,v) NOT IN (SELECT v,(SELECT v FROM (SELECT v,(NOT ((1 ^ 1 AND (v NOT IN (NOT (NOT (v=1))) AND (v,v) NOT IN (SELECT 1,1))=1) *'')) FROM t) AS v4 NATURAL JOIN t) AS v5 FROM t),v WINDOW v6 AS(PARTITION BY v ORDER BY (1))) ^ v THEN''END))),''FROM t)) AS v7));

Core was generated by `/test/MD310522-mariadb-10.9.2-linux-x86_64-opt/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGSEGV, Segmentation fault.

#0  JOIN_CACHE::reset_join (this=0x0, j=0x1505840602a0)

    at /test/10.9_opt/sql/sql_join_cache.h:682

[Current thread is 1 (Thread 0x1505e804f700 (LWP 2974041))]

(gdb) bt

#0  JOIN_CACHE::reset_join (this=0x0, j=0x1505840602a0) at /test/10.9_opt/sql/sql_join_cache.h:682

#1  sub_select_cache (join=0x1505840602a0, join_tab=0x150584083140, end_of_records=false) at /test/10.9_opt/sql/sql_select.cc:20961

#2  0x0000562a5cf03f93 in evaluate_join_record (join=join@entry=0x1505840602a0, join_tab=join_tab@entry=0x150584082d90, error=<optimized out>) at /test/10.9_opt/sql/sql_select.cc:21421

#3  0x0000562a5cf16cdb in sub_select (end_of_records=false, join_tab=0x150584082d90, join=0x1505840602a0) at /test/10.9_opt/sql/sql_select.cc:21191

#4  sub_select (join=0x1505840602a0, join_tab=0x150584082d90, end_of_records=false) at /test/10.9_opt/sql/sql_select.cc:21120

#5  0x0000562a5cf434a1 in do_select (procedure=<optimized out>, join=0x1505840602a0) at /test/10.9_opt/sql/sql_select.cc:20736

#6  JOIN::exec_inner (this=0x1505840602a0) at /test/10.9_opt/sql/sql_select.cc:4786

#7  0x0000562a5cf43868 in JOIN::exec (this=0x1505840602a0) at /test/10.9_opt/sql/sql_select.cc:4564

#8  0x0000562a5d1e4ba6 in subselect_single_select_engine::exec (this=0x15058404cfc8) at /test/10.9_opt/sql/item_subselect.cc:4144

#9  0x0000562a5d1e41fc in Item_subselect::exec (this=0x15058404ce40) at /test/10.9_opt/sql/item_subselect.cc:854

#10 0x0000562a5d1e6634 in Item_singlerow_subselect::val_int (this=0x15058404ce40) at /test/10.9_opt/sql/item_subselect.cc:1504

#11 0x0000562a5d11f493 in Item_direct_ref::val_int (this=0x150584087668) at /test/10.9_opt/sql/item.cc:8630

#12 0x0000562a5d14290c in Arg_comparator::compare_int_signed (this=0x150584087818) at /test/10.9_opt/sql/item_cmpfunc.cc:933

#13 0x0000562a5d142f5f in Arg_comparator::compare (this=<optimized out>) at /test/10.9_opt/sql/item_cmpfunc.h:103

#14 Item_func_eq::val_int (this=<optimized out>) at /test/10.9_opt/sql/item_cmpfunc.cc:1762

#15 0x0000562a5d056cf4 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /test/10.9_opt/sql/sql_type.cc:5100

#16 0x0000562a5d144085 in Item_cond_or::val_int (this=0x150584087cf8) at /test/10.9_opt/sql/item_cmpfunc.cc:5435

#17 0x0000562a5d11fa09 in Item_cache_int::cache_value (this=0x1505840894d0) at /test/10.9_opt/sql/item.cc:10107

#18 0x0000562a5d11fad2 in Item_cache::has_value (this=0x1505840894d0) at /test/10.9_opt/sql/item.h:7080

#19 Item_cache_int::val_int (this=0x1505840894d0) at /test/10.9_opt/sql/item.cc:10140

#20 0x0000562a5cf42f81 in JOIN::exec_inner (this=0x15058405f6c8) at /test/10.9_opt/sql/sql_select.cc:4788

#21 0x0000562a5cf43868 in JOIN::exec (this=0x15058405f6c8) at /test/10.9_opt/sql/sql_select.cc:4564

#22 0x0000562a5d1e4e81 in subselect_single_select_engine::exec (this=0x150584057468) at /test/10.9_opt/sql/item_subselect.cc:4144

#23 0x0000562a5d1e41fc in Item_subselect::exec (this=0x15058404d088) at /test/10.9_opt/sql/item_subselect.cc:854

#24 0x0000562a5d1e4664 in Item_in_subselect::val_bool (this=0x15058404d088) at /test/10.9_opt/sql/item_subselect.cc:1989

#25 0x0000562a5d1502f4 in Item_in_optimizer::val_int (this=0x150584062f68) at /test/10.9_opt/sql/item_cmpfunc.cc:1637

#26 Item_in_optimizer::val_int (this=0x150584062f68) at /test/10.9_opt/sql/item_cmpfunc.cc:1545

#27 0x0000562a5d11fa09 in Item_cache_int::cache_value (this=0x15058408a1c0) at /test/10.9_opt/sql/item.cc:10107

#28 0x0000562a5d137784 in Item_cache_wrapper::cache (this=0x15058408a120) at /test/10.9_opt/sql/item.cc:8865

#29 Item_cache_wrapper::val_bool (this=0x15058408a120) at /test/10.9_opt/sql/item.cc:9051

#30 Item_cache_wrapper::val_bool (this=0x15058408a120) at /test/10.9_opt/sql/item.cc:9034

#31 0x0000562a5d1425c0 in Item_func_not::val_int (this=0x1505840574a8) at /test/10.9_opt/sql/item_cmpfunc.cc:202

#32 0x0000562a5d132e53 in Item::save_int_in_field (this=0x1505840574a8, field=0x15058409bde0, no_conversions=<optimized out>) at /test/10.9_opt/sql/item.cc:6826

#33 0x0000562a5d122c57 in Item::save_in_field (this=0x1505840574a8, field=0x15058409bde0, no_conversions=<optimized out>) at /test/10.9_opt/sql/item.cc:6836

#34 0x0000562a5cf2d5ba in copy_funcs (func_ptr=0x15058409b7a8, thd=0x150584000c58) at /test/10.9_opt/sql/sql_select.cc:26405

#35 0x0000562a5cf2d66a in end_write (join=0x15058405d068, join_tab=0x150584095d90, end_of_records=<optimized out>) at /test/10.9_opt/sql/sql_select.cc:22676

#36 0x0000562a5cf03f93 in evaluate_join_record (join=join@entry=0x15058405d068, join_tab=join_tab@entry=0x1505840959e0, error=<optimized out>) at /test/10.9_opt/sql/sql_select.cc:21421

#37 0x0000562a5cf16cdb in sub_select (end_of_records=false, join_tab=0x1505840959e0, join=0x15058405d068) at /test/10.9_opt/sql/sql_select.cc:21191

#38 sub_select (join=0x15058405d068, join_tab=0x1505840959e0, end_of_records=false) at /test/10.9_opt/sql/sql_select.cc:21120

#39 0x0000562a5cf434a1 in do_select (procedure=<optimized out>, join=0x15058405d068) at /test/10.9_opt/sql/sql_select.cc:20736

#40 JOIN::exec_inner (this=0x15058405d068) at /test/10.9_opt/sql/sql_select.cc:4786

#41 0x0000562a5cf43868 in JOIN::exec (this=this@entry=0x15058405d068) at /test/10.9_opt/sql/sql_select.cc:4564

#42 0x0000562a5cf41a71 in mysql_select (thd=0x150584000c58, tables=0x150584045330, fields=@0x150584010e18: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x150584014078, last = 0x150584014078, elements = 1}, <No data fields>}, conds=0x0, og_num=2, order=0x0, group=0x150584057558, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x15058405b870, unit=0x150584004cb8, select_lex=0x150584010b78) at /test/10.9_opt/sql/sql_select.cc:5044

#43 0x0000562a5cf421b7 in handle_select (thd=thd@entry=0x150584000c58, lex=lex@entry=0x150584004be0, result=result@entry=0x15058405b870, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.9_opt/sql/sql_select.cc:578

#44 0x0000562a5cec57e1 in execute_sqlcom_select (thd=0x150584000c58, all_tables=0x150584045330) at /test/10.9_opt/sql/sql_parse.cc:6260

#45 0x0000562a5ced334d in mysql_execute_command (thd=0x150584000c58, is_called_from_prepared_stmt=<optimized out>) at /test/10.9_opt/sql/sql_parse.cc:3944

#46 0x0000562a5cec09e5 in mysql_parse (rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, thd=0x150584000c58) at /test/10.9_opt/sql/sql_parse.cc:8036

#47 mysql_parse (thd=0x150584000c58, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>) at /test/10.9_opt/sql/sql_parse.cc:7958

#48 0x0000562a5cecc4fa in dispatch_command (command=COM_QUERY, thd=0x150584000c58, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /test/10.9_opt/sql/sql_class.h:1364

#49 0x0000562a5cece422 in do_command (thd=0x150584000c58, blocking=blocking@entry=true) at /test/10.9_opt/sql/sql_parse.cc:1407

#50 0x0000562a5cfe469f in do_handle_one_connection (connect=<optimized out>, connect@entry=0x562a5f0a2138, put_in_cache=put_in_cache@entry=true) at /test/10.9_opt/sql/sql_connect.cc:1418

#51 0x0000562a5cfe497d in handle_one_connection (arg=0x562a5f0a2138) at /test/10.9_opt/sql/sql_connect.cc:1312

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

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

mysqld: /test/10.9_dbg/sql/sql_select.cc:20959: enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool): Assertion `cache != __null' failed.

Core was generated by `/test/MD310522-mariadb-10.9.2-linux-x86_64-dbg/bin/mysqld --no-defaults --core-'.

Program terminated with signal SIGABRT, Aborted.

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

[Current thread is 1 (Thread 0x14b34c8e5700 (LWP 2974602))]

(gdb) bt

#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50

#1  0x000014b366246859 in __GI_abort () at abort.c:79

#2  0x000014b366246729 in __assert_fail_base (fmt=0x14b3663dc588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x5556b7690ae9 "cache != __null", file=0x5556b76917e8 "/test/10.9_dbg/sql/sql_select.cc", line=20959, function=<optimized out>) at assert.c:92

#3  0x000014b366257fd6 in __GI___assert_fail (assertion=assertion@entry=0x5556b7690ae9 "cache != __null", file=file@entry=0x5556b76917e8 "/test/10.9_dbg/sql/sql_select.cc", line=line@entry=20959, function=function@entry=0x5556b7692950 "enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool)") at assert.c:101

#4  0x00005556b6af2deb in sub_select_cache (join=0x14b2ec0874f0, join_tab=0x14b2ec0abb68, end_of_records=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:20959

#5  0x00005556b6adcff6 in evaluate_join_record (join=join@entry=0x14b2ec0874f0, join_tab=join_tab@entry=0x14b2ec0ab7b8, error=error@entry=0) at /test/10.9_dbg/sql/sql_select.cc:21421

#6  0x00005556b6af2961 in sub_select (join=0x14b2ec0874f0, join_tab=0x14b2ec0ab7b8, end_of_records=false) at /test/10.9_dbg/sql/sql_select.cc:21191

#7  0x00005556b6b26243 in do_select (procedure=<optimized out>, join=0x14b2ec0874f0) at /test/10.9_dbg/sql/sql_select.cc:20736

#8  JOIN::exec_inner (this=this@entry=0x14b2ec0874f0) at /test/10.9_dbg/sql/sql_select.cc:4786

#9  0x00005556b6b267dc in JOIN::exec (this=0x14b2ec0874f0) at /test/10.9_dbg/sql/sql_select.cc:4564

#10 0x00005556b6e8cfbe in subselect_single_select_engine::exec (this=0x14b2ec073fc8) at /test/10.9_dbg/sql/item_subselect.cc:4144

#11 0x00005556b6e8c60c in Item_subselect::exec (this=0x14b2ec073e40) at /test/10.9_dbg/sql/item_subselect.cc:854

#12 0x00005556b6e8ac21 in Item_singlerow_subselect::val_int (this=0x14b2ec073e40) at /test/10.9_dbg/sql/item_subselect.cc:1504

#13 0x00005556b6d97107 in Item_direct_ref::val_int (this=0x14b2ec0b0220) at /test/10.9_dbg/sql/item.cc:8630

#14 0x00005556b6dc487c in Arg_comparator::compare_int_signed (this=0x14b2ec0b03d0) at /test/10.9_dbg/sql/item_cmpfunc.cc:933

#15 0x00005556b6dc6e94 in Arg_comparator::compare (this=0x14b2ec0b03d0) at /test/10.9_dbg/sql/item_cmpfunc.h:103

#16 Item_func_eq::val_int (this=0x14b2ec0b0320) at /test/10.9_dbg/sql/item_cmpfunc.cc:1762

#17 0x00005556b6c8ca06 in Type_handler_int_result::Item_val_bool (this=<optimized out>, item=<optimized out>) at /test/10.9_dbg/sql/sql_type.cc:5100

#18 0x00005556b696ce32 in Item::val_bool (this=0x14b2ec0b0320) at /test/10.9_dbg/sql/item.h:1687

#19 0x00005556b6dc7313 in Item_cond_or::val_int (this=0x14b2ec0b08b0) at /test/10.9_dbg/sql/item_cmpfunc.cc:5435

#20 0x00005556b696cec5 in Item::val_int_result (this=<optimized out>) at /test/10.9_dbg/sql/item.h:1779

#21 0x00005556b6d97945 in Item_cache_int::cache_value (this=0x14b2ec0b2108) at /test/10.9_dbg/sql/item.cc:10107

#22 0x00005556b6d979e2 in Item_cache::has_value (this=0x14b2ec0b2108) at /test/10.9_dbg/sql/item.h:7080

#23 Item_cache_int::val_int (this=0x14b2ec0b2108) at /test/10.9_dbg/sql/item.cc:10140

#24 0x00005556b6b26b0d in Item_func_trig_cond::val_int (this=<optimized out>) at /test/10.9_dbg/sql/item_cmpfunc.h:688

#25 0x00005556b6b26b0d in Item_func_trig_cond::val_int (this=<optimized out>) at /test/10.9_dbg/sql/item_cmpfunc.h:688

#26 0x00005556b6b257e9 in JOIN::exec_inner (this=this@entry=0x14b2ec086918) at /test/10.9_dbg/sql/sql_select.cc:4668

#27 0x00005556b6b267dc in JOIN::exec (this=0x14b2ec086918) at /test/10.9_dbg/sql/sql_select.cc:4564

#28 0x00005556b6e8d1ec in subselect_single_select_engine::exec (this=0x14b2ec07e5d8) at /test/10.9_dbg/sql/item_subselect.cc:4144

#29 0x00005556b6e8c60c in Item_subselect::exec (this=this@entry=0x14b2ec074088) at /test/10.9_dbg/sql/item_subselect.cc:854

#30 0x00005556b6e918d9 in Item_in_subselect::exec (this=0x14b2ec074088) at /test/10.9_dbg/sql/item_subselect.cc:1036

#31 0x00005556b6e8b7b3 in Item_in_subselect::val_bool (this=0x14b2ec074088) at /test/10.9_dbg/sql/item_subselect.cc:1989

#32 0x00005556b696cf01 in Item::val_bool_result (this=<optimized out>) at /test/10.9_dbg/sql/item.h:1783

#33 0x00005556b6dd4a06 in Item_in_optimizer::val_int (this=0x14b2ec08a1b8) at /test/10.9_dbg/sql/item_cmpfunc.cc:1637

#34 0x00005556b696cec5 in Item::val_int_result (this=<optimized out>) at /test/10.9_dbg/sql/item.h:1779

#35 0x00005556b6d97945 in Item_cache_int::cache_value (this=0x14b2ec0b2e80) at /test/10.9_dbg/sql/item.cc:10107

#36 0x00005556b6db53b8 in Item_cache_wrapper::cache (this=0x14b2ec0b2de0) at /test/10.9_dbg/sql/item.cc:8865

#37 Item_cache_wrapper::val_bool (this=0x14b2ec0b2de0) at /test/10.9_dbg/sql/item.cc:9051

#38 0x00005556b6dc609a in Item_func_not::val_int (this=0x14b2ec07e618) at /test/10.9_dbg/sql/item_cmpfunc.cc:202

#39 0x00005556b6db0315 in Item::save_int_in_field (this=0x14b2ec07e618, field=0x14b2ec0c7460, no_conversions=<optimized out>) at /test/10.9_dbg/sql/item.cc:6826

#40 0x00005556b6c8f92c in Type_handler_int_result::Item_save_in_field (this=<optimized out>, item=<optimized out>, field=<optimized out>, no_conversions=<optimized out>) at /test/10.9_dbg/sql/sql_type.cc:4359

#41 0x00005556b6d96a6f in Item::save_in_field (this=0x14b2ec07e618, field=0x14b2ec0c7460, no_conversions=<optimized out>) at /test/10.9_dbg/sql/item.cc:6836

#42 0x00005556b6998286 in Item_result_field::save_in_result_field (this=<optimized out>, no_conversions=<optimized out>) at /test/10.9_dbg/sql/item.h:3441

#43 0x00005556b6b0b386 in copy_funcs (func_ptr=0x14b2ec0c6db8, thd=0x14b2ec000db8) at /test/10.9_dbg/sql/sql_select.cc:26405

#44 0x00005556b6b0b41d in end_write (join=0x14b2ec0842b8, join_tab=0x14b2ec0c2170, end_of_records=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:22676

#45 0x00005556b6b19641 in AGGR_OP::put_record (this=this@entry=0x14b2ec0c2f18, end_of_records=end_of_records@entry=false) at /test/10.9_dbg/sql/sql_select.cc:29579

#46 0x00005556b6b19b31 in AGGR_OP::put_record (this=0x14b2ec0c2f18) at /test/10.9_dbg/sql/sql_select.h:1058

#47 sub_select_postjoin_aggr (join=0x14b2ec0842b8, join_tab=0x14b2ec0c2170, end_of_records=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:20907

#48 0x00005556b6adcff6 in evaluate_join_record (join=join@entry=0x14b2ec0842b8, join_tab=join_tab@entry=0x14b2ec0c1dc0, error=error@entry=0) at /test/10.9_dbg/sql/sql_select.cc:21421

#49 0x00005556b6af2961 in sub_select (join=0x14b2ec0842b8, join_tab=0x14b2ec0c1dc0, end_of_records=false) at /test/10.9_dbg/sql/sql_select.cc:21191

#50 0x00005556b6b26243 in do_select (procedure=<optimized out>, join=0x14b2ec0842b8) at /test/10.9_dbg/sql/sql_select.cc:20736

#51 JOIN::exec_inner (this=this@entry=0x14b2ec0842b8) at /test/10.9_dbg/sql/sql_select.cc:4786

#52 0x00005556b6b267dc in JOIN::exec (this=this@entry=0x14b2ec0842b8) at /test/10.9_dbg/sql/sql_select.cc:4564

#53 0x00005556b6b24560 in mysql_select (thd=thd@entry=0x14b2ec000db8, tables=0x14b2ec06c2c0, fields=@0x14b2ec014338: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14b2ec017598, last = 0x14b2ec017598, elements = 1}, <No data fields>}, conds=0x0, og_num=2, order=0x0, group=0x14b2ec07e6c8, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14b2ec082a50, unit=0x14b2ec004fd8, select_lex=0x14b2ec014098) at /test/10.9_dbg/sql/sql_select.cc:5044

#54 0x00005556b6b24d56 in handle_select (thd=thd@entry=0x14b2ec000db8, lex=lex@entry=0x14b2ec004f00, result=result@entry=0x14b2ec082a50, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.9_dbg/sql/sql_select.cc:578

#55 0x00005556b6a90b34 in execute_sqlcom_select (thd=thd@entry=0x14b2ec000db8, all_tables=0x14b2ec06c2c0) at /test/10.9_dbg/sql/sql_parse.cc:6260

#56 0x00005556b6a9ce46 in mysql_execute_command (thd=thd@entry=0x14b2ec000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.9_dbg/sql/sql_parse.cc:3944

#57 0x00005556b6a8ae10 in mysql_parse (thd=thd@entry=0x14b2ec000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14b34c8e4470) at /test/10.9_dbg/sql/sql_parse.cc:8036

#58 0x00005556b6a983f8 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14b2ec000db8, packet=packet@entry=0x14b2ec00b6c9 "", packet_length=packet_length@entry=524, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_class.h:1364

#59 0x00005556b6a9ab02 in do_command (thd=0x14b2ec000db8, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:1407

#60 0x00005556b6bfa360 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5556b91990b8, put_in_cache=put_in_cache@entry=true) at /test/10.9_dbg/sql/sql_connect.cc:1418

#61 0x00005556b6bfa869 in handle_one_connection (arg=0x5556b91990b8) at /test/10.9_dbg/sql/sql_connect.cc:1312

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

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