CREATE TABLE x (x INT KEY );
INSERT INTO x VALUES(0),(3);
SELECT (((SELECT x FROM x WHERE x IN (SELECT x IN (SELECT (SELECT (SELECT (SELECT (SELECT (SELECT (SELECT 3 FROM x WHERE x IN (SELECT (SELECT x FROM x WHERE x IN (SELECT (SELECT (SELECT (SELECT x FROM x))) FROM x WHERE x) ORDER BY (0 IN ((SELECT x FROM x WHERE (SELECT 0) IN (SELECT x FROM x WHERE '' IN (SELECT (SELECT 3 FROM x)))))) IN (SELECT x FROM x WHERE x IN (0) ),x) FROM x)) FROM x))) WHERE x IN ( x)) ) FROM x ) FROM x WHERE x IN (x)))),x) FROM x;



ramesh@galapq:/test/mtest/MD090822-mariadb-10.9.2-linux-x86_64-dbg$ ~/stack
{noformat:title=10.9.2 bfdc4ff22ecf626eb46479e1a0dc1049d61a8d78 (Debug)}
mysqld: /test/10.9_dbg/sql/item_subselect.cc:1986: virtual bool Item_in_subselect::val_bool(): Assertion `(engine->uncacheable() & ~8) || ! engine->is_executed() || with_recursive_reference' failed.
{noformat}

{noformat:title=10.9.2 bfdc4ff22ecf626eb46479e1a0dc1049d61a8d78 (Debug)}
Core was generated by `/test/mtest/MD090822-mariadb-10.9.2-linux-x86_64-dbg/bin/mysqld --no-defaults -'.
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 0x14af06620700 (LWP 1857631))]
(gdb) bt
#0  __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:50
#1  0x000014af1ebb2859 in __GI_abort () at abort.c:79
#2  0x000014af1ebb2729 in __assert_fail_base (fmt=0x14af1ed48588 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=0x55f0dd713fc8 "(engine->uncacheable() & ~8) || ! engine->is_executed() || with_recursive_reference", file=0x55f0dd7138b8 "/test/10.9_dbg/sql/item_subselect.cc", line=1986, function=<optimized out>) at assert.c:92
#3  0x000014af1ebc3fd6 in __GI___assert_fail (assertion=assertion@entry=0x55f0dd713fc8 "(engine->uncacheable() & ~8) || ! engine->is_executed() || with_recursive_reference", file=file@entry=0x55f0dd7138b8 "/test/10.9_dbg/sql/item_subselect.cc", line=line@entry=1986, function=function@entry=0x55f0dd713f30 "virtual bool Item_in_subselect::val_bool()") at assert.c:101
#4  0x000055f0dcd6dcd4 in Item_in_subselect::val_bool (this=0x14aed80814b0) at /test/10.9_dbg/sql/item_subselect.cc:1986
#5  0x000055f0dc84dee5 in Item::val_bool_result (this=<optimized out>) at /test/10.9_dbg/sql/item.h:1783
#6  0x000055f0dccb66c0 in Item_in_optimizer::val_int (this=0x14aed80b61a8) at /test/10.9_dbg/sql/item_cmpfunc.cc:1637
#7  0x000055f0dc84dea9 in Item::val_int_result (this=<optimized out>) at /test/10.9_dbg/sql/item.h:1779
#8  0x000055f0dcc791af in Item_cache_int::cache_value (this=0x14aed80b6b48) at /test/10.9_dbg/sql/item.cc:10125
#9  0x000055f0dccb62fe in Item_in_optimizer::fix_left (this=0x14aed80b6a80, thd=<optimized out>) at /test/10.9_dbg/sql/item_cmpfunc.cc:1335
#10 0x000055f0dcd71b78 in Item_in_subselect::single_value_transformer (this=this@entry=0x14aed8082f60, join=join@entry=0x14aed80b6410) at /test/10.9_dbg/sql/item_subselect.cc:2110
#11 0x000055f0dcd739ec in Item_in_subselect::select_in_like_transformer (this=0x14aed8082f60, join=0x14aed80b6410) at /test/10.9_dbg/sql/item_subselect.cc:3483
#12 0x000055f0dcd73a61 in Item_in_subselect::select_transformer (this=<optimized out>, join=<optimized out>) at /test/10.9_dbg/sql/item_subselect.cc:2772
#13 0x000055f0dcb2df0a in check_and_do_in_subquery_rewrites (join=join@entry=0x14aed80b6410) at /test/10.9_dbg/sql/opt_subselect.cc:745
#14 0x000055f0dc9ef94b in JOIN::prepare (this=0x14aed80b6410, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=<optimized out>, having_init=<optimized out>, proc_param_init=<optimized out>, select_lex_arg=<optimized out>, unit_arg=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:1554
#15 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8083188, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#16 0x000055f0dcd7404f in Item_subselect::fix_fields (this=this@entry=0x14aed8082f60, thd_param=thd_param@entry=0x14aed8000db8, ref=ref@entry=0x14aed80831f0) at /test/10.9_dbg/sql/item_subselect.cc:295
#17 0x000055f0dcd74494 in Item_in_subselect::fix_fields (this=0x14aed8082f60, thd_arg=0x14aed8000db8, ref=0x14aed80831f0) at /test/10.9_dbg/sql/item_subselect.cc:3588
#18 0x000055f0dc9bf671 in Item::fix_fields_if_needed (ref=<optimized out>, thd=0x14aed8000db8, this=0x14aed8082f60) at /test/10.9_dbg/sql/item.h:1156
#19 Item::fix_fields_if_needed_for_scalar (ref=<optimized out>, thd=0x14aed8000db8, this=0x14aed8082f60) at /test/10.9_dbg/sql/item.h:1148
#20 Item::fix_fields_if_needed_for_order_by (ref=<optimized out>, thd=0x14aed8000db8, this=0x14aed8082f60) at /test/10.9_dbg/sql/item.h:1156
#21 find_order_in_list (thd=thd@entry=0x14aed8000db8, ref_pointer_array=<optimized out>, tables=tables@entry=0x14aed806ebe8, order=order@entry=0x14aed80831e0, fields=@0x14aed806ea20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8017aa8, last = 0x14aed8017aa8, elements = 1}, <No data fields>}, all_fields=@0x14aed80b1558: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8017aa8, last = 0x14aed8017aa8, elements = 1}, <No data fields>}, is_group_field=false, add_to_all_fields=true, from_window_spec=false) at /test/10.9_dbg/sql/sql_select.cc:25204
#22 0x000055f0dc9eb008 in setup_order (thd=thd@entry=0x14aed8000db8, ref_pointer_array=<optimized out>, tables=tables@entry=0x14aed806ebe8, fields=@0x14aed806ea20: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8017aa8, last = 0x14aed8017aa8, elements = 1}, <No data fields>}, all_fields=@0x14aed80b1558: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8017aa8, last = 0x14aed8017aa8, elements = 1}, <No data fields>}, order=0x14aed80831e0, from_window_spec=false) at /test/10.9_dbg/sql/sql_select.cc:25251
#23 0x000055f0dc9ef125 in setup_without_group (reserved=<optimized out>, hidden_group_fields=0x14aed80b1507, win_funcs=<optimized out>, win_specs=<optimized out>, group=<optimized out>, order=<optimized out>, conds=0x14aed80b1640, all_fields=@0x14aed80b1558: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8017aa8, last = 0x14aed8017aa8, elements = 1}, <No data fields>}, fields=<optimized out>, leaves=<optimized out>, tables=<optimized out>, ref_pointer_array=<optimized out>, thd=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:886
#24 JOIN::prepare (this=0x14aed80b11f8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=<optimized out>, having_init=<optimized out>, proc_param_init=<optimized out>, select_lex_arg=<optimized out>, unit_arg=<optimized out>) at /test/10.9_dbg/sql/sql_select.cc:1454
#25 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8083568, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#26 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed80833e0, thd_param=<optimized out>, ref=0x14aed80835b0) at /test/10.9_dbg/sql/item_subselect.cc:295
#27 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed80835b0, thd=0x14aed8000db8, this=0x14aed80833e0) at /test/10.9_dbg/sql/item.h:1148
#28 Item::fix_fields_if_needed_for_scalar (ref=0x14aed80835b0, thd=0x14aed8000db8, this=0x14aed80833e0) at /test/10.9_dbg/sql/item.h:1148
#29 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed80b08f0, pre_fix=0x14aed806e5d0, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#30 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed80b0590, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed806e318, unit_arg=0x14aed8084540) at /test/10.9_dbg/sql/sql_select.cc:1448
#31 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8084028, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#32 0x000055f0dcd7404f in Item_subselect::fix_fields (this=this@entry=0x14aed8083e00, thd_param=thd_param@entry=0x14aed8000db8, ref=ref@entry=0x14aed80afd20) at /test/10.9_dbg/sql/item_subselect.cc:295
#33 0x000055f0dcd74494 in Item_in_subselect::fix_fields (this=0x14aed8083e00, thd_arg=0x14aed8000db8, ref=0x14aed80afd20) at /test/10.9_dbg/sql/item_subselect.cc:3588
#34 0x000055f0dc8f9044 in Item::fix_fields_if_needed (ref=0x14aed80afd20, thd=0x14aed8000db8, this=0x14aed8083e00) at /test/10.9_dbg/sql/item.h:1152
#35 Item::fix_fields_if_needed_for_scalar (ref=0x14aed80afd20, thd=0x14aed8000db8, this=0x14aed8083e00) at /test/10.9_dbg/sql/item.h:1148
#36 Item::fix_fields_if_needed_for_bool (ref=0x14aed80afd20, thd=0x14aed8000db8, this=0x14aed8083e00) at /test/10.9_dbg/sql/item.h:1152
#37 setup_conds (thd=thd@entry=0x14aed8000db8, tables=tables@entry=0x14aed806dc30, leaves=@0x14aed8017508: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8094308, last = 0x14aed8094308, elements = 1}, <No data fields>}, conds=conds@entry=0x14aed80afd20) at /test/10.9_dbg/sql/sql_base.cc:8801
#38 0x000055f0dc9eee6d in setup_without_group (reserved=0x14aed80176ac, hidden_group_fields=0x14aed80afbe7, win_funcs=@0x14aed8017740: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f0dde55b40 <end_of_list>, last = 0x14aed8017740, elements = 0}, <No data fields>}, win_specs=@0x14aed8017728: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f0dde55b40 <end_of_list>, last = 0x14aed8017728, elements = 0}, <No data fields>}, group=0x0, order=0x0, conds=0x14aed80afd20, all_fields=@0x14aed80afc38: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed80177e8, last = 0x14aed80177e8, elements = 1}, <No data fields>}, fields=@0x14aed8017590: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed80177e8, last = 0x14aed80177e8, elements = 1}, <No data fields>}, leaves=@0x14aed8017508: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8094308, last = 0x14aed8094308, elements = 1}, <No data fields>}, tables=0x14aed806dc30, ref_pointer_array=<optimized out>, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_select.cc:882
#39 JOIN::prepare (this=0x14aed80af8d8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed80172f0, unit_arg=0x14aed8084d40) at /test/10.9_dbg/sql/sql_select.cc:1454
#40 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8084200, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#41 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8084078, thd_param=<optimized out>, ref=0x14aed8084248) at /test/10.9_dbg/sql/item_subselect.cc:295
#42 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8084248, thd=0x14aed8000db8, this=0x14aed8084078) at /test/10.9_dbg/sql/item.h:1148
#43 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8084248, thd=0x14aed8000db8, this=0x14aed8084078) at /test/10.9_dbg/sql/item.h:1148
#44 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed80aef58, pre_fix=0x14aed8017130, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#45 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed80aebf8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8016e78, unit_arg=0x14aed8085c28) at /test/10.9_dbg/sql/sql_select.cc:1448
#46 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed80843e0, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#47 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8086428, thd_param=<optimized out>, ref=0x14aed8084428) at /test/10.9_dbg/sql/item_subselect.cc:295
#48 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8084428, thd=0x14aed8000db8, this=0x14aed8086428) at /test/10.9_dbg/sql/item.h:1148
#49 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8084428, thd=0x14aed8000db8, this=0x14aed8086428) at /test/10.9_dbg/sql/item.h:1148
#50 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed80ae250, pre_fix=0x14aed8016cb8, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#51 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed80adef0, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8016a00, unit_arg=0x14aed8086680) at /test/10.9_dbg/sql/sql_select.cc:1448
#52 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8086fd8, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#53 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8086e80, thd_param=<optimized out>, ref=0x14aed8084478) at /test/10.9_dbg/sql/item_subselect.cc:295
#54 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8084478, thd=0x14aed8000db8, this=0x14aed8086e80) at /test/10.9_dbg/sql/item.h:1148
#55 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8084478, thd=0x14aed8000db8, this=0x14aed8086e80) at /test/10.9_dbg/sql/item.h:1148
#56 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed80938f8, pre_fix=0x14aed8016840, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#57 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed8093598, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8016588, unit_arg=0x14aed8087128) at /test/10.9_dbg/sql/sql_select.cc:1448
#58 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8087ab0, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#59 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8087928, thd_param=<optimized out>, ref=0x14aed8087af8) at /test/10.9_dbg/sql/item_subselect.cc:295
#60 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8087af8, thd=0x14aed8000db8, this=0x14aed8087928) at /test/10.9_dbg/sql/item.h:1148
#61 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8087af8, thd=0x14aed8000db8, this=0x14aed8087928) at /test/10.9_dbg/sql/item.h:1148
#62 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed8092b40, pre_fix=0x14aed80163c8, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#63 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed80927e0, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8016110, unit_arg=0x14aed8088078) at /test/10.9_dbg/sql/sql_select.cc:1448
#64 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed8088a00, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#65 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8088878, thd_param=<optimized out>, ref=0x14aed8088a48) at /test/10.9_dbg/sql/item_subselect.cc:295
#66 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8088a48, thd=0x14aed8000db8, this=0x14aed8088878) at /test/10.9_dbg/sql/item.h:1148
#67 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8088a48, thd=0x14aed8000db8, this=0x14aed8088878) at /test/10.9_dbg/sql/item.h:1148
#68 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed8091d60, pre_fix=0x14aed8015f50, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#69 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed8091a00, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8015c98, unit_arg=0x14aed8088b60) at /test/10.9_dbg/sql/sql_select.cc:1448
#70 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed80894e8, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#71 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed8089360, thd_param=<optimized out>, ref=0x14aed8089530) at /test/10.9_dbg/sql/item_subselect.cc:295
#72 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed8089530, thd=0x14aed8000db8, this=0x14aed8089360) at /test/10.9_dbg/sql/item.h:1148
#73 Item::fix_fields_if_needed_for_scalar (ref=0x14aed8089530, thd=0x14aed8000db8, this=0x14aed8089360) at /test/10.9_dbg/sql/item.h:1148
#74 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed8090f48, pre_fix=0x14aed8015ad8, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#75 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed8090be8, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8015820, unit_arg=0x14aed8089d80) at /test/10.9_dbg/sql/sql_select.cc:1448
#76 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed808a7a8, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#77 0x000055f0dcd7404f in Item_subselect::fix_fields (this=this@entry=0x14aed808a580, thd_param=thd_param@entry=0x14aed8000db8, ref=ref@entry=0x14aed808a7f0) at /test/10.9_dbg/sql/item_subselect.cc:295
#78 0x000055f0dcd74494 in Item_in_subselect::fix_fields (this=0x14aed808a580, thd_arg=0x14aed8000db8, ref=0x14aed808a7f0) at /test/10.9_dbg/sql/item_subselect.cc:3588
#79 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed808a7f0, thd=0x14aed8000db8, this=0x14aed808a580) at /test/10.9_dbg/sql/item.h:1148
#80 Item::fix_fields_if_needed_for_scalar (ref=0x14aed808a7f0, thd=0x14aed8000db8, this=0x14aed808a580) at /test/10.9_dbg/sql/item.h:1148
#81 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed8090068, pre_fix=0x14aed8015540, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#82 0x000055f0dc9eec1a in JOIN::prepare (this=0x14aed808fd08, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8015288, unit_arg=0x14aed808b4a8) at /test/10.9_dbg/sql/sql_select.cc:1448
#83 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed808bed0, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#84 0x000055f0dcd7404f in Item_subselect::fix_fields (this=this@entry=0x14aed808bca8, thd_param=thd_param@entry=0x14aed8000db8, ref=ref@entry=0x14aed808f1f8) at /test/10.9_dbg/sql/item_subselect.cc:295
#85 0x000055f0dcd74494 in Item_in_subselect::fix_fields (this=0x14aed808bca8, thd_arg=0x14aed8000db8, ref=0x14aed808f1f8) at /test/10.9_dbg/sql/item_subselect.cc:3588
#86 0x000055f0dc8f9044 in Item::fix_fields_if_needed (ref=0x14aed808f1f8, thd=0x14aed8000db8, this=0x14aed808bca8) at /test/10.9_dbg/sql/item.h:1152
#87 Item::fix_fields_if_needed_for_scalar (ref=0x14aed808f1f8, thd=0x14aed8000db8, this=0x14aed808bca8) at /test/10.9_dbg/sql/item.h:1148
#88 Item::fix_fields_if_needed_for_bool (ref=0x14aed808f1f8, thd=0x14aed8000db8, this=0x14aed808bca8) at /test/10.9_dbg/sql/item.h:1152
#89 setup_conds (thd=thd@entry=0x14aed8000db8, tables=tables@entry=0x14aed8014a68, leaves=@0x14aed80146a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed808f360, last = 0x14aed808f360, elements = 1}, <No data fields>}, conds=conds@entry=0x14aed808f1f8) at /test/10.9_dbg/sql/sql_base.cc:8801
#90 0x000055f0dc9eee6d in setup_without_group (reserved=0x14aed8014844, hidden_group_fields=0x14aed808f0bf, win_funcs=@0x14aed80148d8: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f0dde55b40 <end_of_list>, last = 0x14aed80148d8, elements = 0}, <No data fields>}, win_specs=@0x14aed80148c0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x55f0dde55b40 <end_of_list>, last = 0x14aed80148c0, elements = 0}, <No data fields>}, group=0x0, order=0x0, conds=0x14aed808f1f8, all_fields=@0x14aed808f110: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8014a20, last = 0x14aed8014a20, elements = 1}, <No data fields>}, fields=@0x14aed8014728: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed8014a20, last = 0x14aed8014a20, elements = 1}, <No data fields>}, leaves=@0x14aed80146a0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed808f360, last = 0x14aed808f360, elements = 1}, <No data fields>}, tables=0x14aed8014a68, ref_pointer_array=<optimized out>, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_select.cc:882
#91 JOIN::prepare (this=0x14aed808edb0, tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>, order_init=<optimized out>, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8014488, unit_arg=0x14aed808c5d0) at /test/10.9_dbg/sql/sql_select.cc:1454
#92 0x000055f0dcd74b81 in subselect_single_select_engine::prepare (this=0x14aed808c0a8, thd=0x14aed8000db8) at /test/10.9_dbg/sql/sql_lex.h:1362
#93 0x000055f0dcd7404f in Item_subselect::fix_fields (this=0x14aed808bf20, thd_param=<optimized out>, ref=0x14aed808c2b0) at /test/10.9_dbg/sql/item_subselect.cc:295
#94 0x000055f0dcd32d82 in Item::fix_fields_if_needed (ref=0x14aed808c2b0, thd=0x14aed8000db8, this=<optimized out>) at /test/10.9_dbg/sql/item.h:1144
#95 Item_row::fix_fields (this=0x14aed808c240, thd=0x14aed8000db8, ref=<optimized out>) at /test/10.9_dbg/sql/item_row.cc:46
#96 0x000055f0dc8f6ecc in Item::fix_fields_if_needed (ref=0x14aed808c2f0, thd=0x14aed8000db8, this=0x14aed808c240) at /test/10.9_dbg/sql/item.h:1148
#97 Item::fix_fields_if_needed_for_scalar (ref=0x14aed808c2f0, thd=0x14aed8000db8, this=0x14aed808c240) at /test/10.9_dbg/sql/item.h:1148
#98 setup_fields (thd=0x14aed8000db8, ref_pointer_array=<optimized out>, fields=<optimized out>, column_usage=column_usage@entry=MARK_COLUMNS_READ, sum_func_list=sum_func_list@entry=0x14aed808e118, pre_fix=0x14aed80142c8, allow_sum_func=true) at /test/10.9_dbg/sql/sql_base.cc:7975
#99 0x000055f0dc9eec1a in JOIN::prepare (this=this@entry=0x14aed808ddb8, tables_init=tables_init@entry=0x14aed808cdd0, conds_init=conds_init@entry=0x0, og_num=og_num@entry=0, order_init=order_init@entry=0x0, skip_order_by=skip_order_by@entry=false, group_init=0x0, having_init=0x0, proc_param_init=0x0, select_lex_arg=0x14aed8014010, unit_arg=0x14aed8004fd8) at /test/10.9_dbg/sql/sql_select.cc:1448
#100 0x000055f0dca06022 in mysql_select (thd=thd@entry=0x14aed8000db8, tables=0x14aed808cdd0, fields=@0x14aed80142b0: {<base_list> = {<Sql_alloc> = {<No data fields>}, first = 0x14aed808c2e8, last = 0x14aed808c2e8, elements = 1}, <No data fields>}, conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x14aed808c4e0, unit=0x14aed8004fd8, select_lex=0x14aed8014010) at /test/10.9_dbg/sql/sql_select.cc:5032
#101 0x000055f0dca06240 in handle_select (thd=thd@entry=0x14aed8000db8, lex=lex@entry=0x14aed8004f00, result=result@entry=0x14aed808c4e0, setup_tables_done_option=setup_tables_done_option@entry=0) at /test/10.9_dbg/sql/sql_select.cc:579
#102 0x000055f0dc971f62 in execute_sqlcom_select (thd=thd@entry=0x14aed8000db8, all_tables=0x14aed808cdd0) at /test/10.9_dbg/sql/sql_parse.cc:6261
#103 0x000055f0dc97e258 in mysql_execute_command (thd=thd@entry=0x14aed8000db8, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /test/10.9_dbg/sql/sql_parse.cc:3945
#104 0x000055f0dc96c23e in mysql_parse (thd=thd@entry=0x14aed8000db8, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x14af0661f330) at /test/10.9_dbg/sql/sql_parse.cc:8037
#105 0x000055f0dc97980c in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x14aed8000db8, packet=packet@entry=0x14aed800b6c9 "SELECT (((SELECT x FROM x WHERE x IN (SELECT x IN (SELECT (SELECT (SELECT (SELECT (SELECT (SELECT (SELECT 3 FROM x WHERE x IN (SELECT (SELECT x FROM x WHERE x IN (SELECT (SELECT (SELECT (SELECT x FROM"..., packet_length=packet_length@entry=456, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_class.h:1364
#106 0x000055f0dc97bf14 in do_command (thd=0x14aed8000db8, blocking=blocking@entry=true) at /test/10.9_dbg/sql/sql_parse.cc:1407
#107 0x000055f0dcadbb68 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x55f0e0392c48, put_in_cache=put_in_cache@entry=true) at /test/10.9_dbg/sql/sql_connect.cc:1418
#108 0x000055f0dcadc071 in handle_one_connection (arg=0x55f0e0392c48) at /test/10.9_dbg/sql/sql_connect.cc:1312
#109 0x000014af1f0c3609 in start_thread (arg=<optimized out>) at pthread_create.c:477
#110 0x000014af1ecaf133 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:95
{noformat}