Segmentation fault at /mariadb-11.3.0/sql/sql_select.cc:23355

Run these queries in release build:

CREATE TABLE x ( x FLOAT ) ;
INSERT INTO x ( x ) VALUES ( 1 ) ;
UPDATE x SET x = 1 WHERE ( SELECT 1 FROM x GROUP BY x , x HAVING ( SELECT x IN ( ( SELECT 1 WHERE 1 GROUP BY x , x HAVING x IN ( x NOT LIKE ( SELECT x ) + x IS NOT NULL ) AND x NOT IN ( 1 , 1 ) ) NOT LIKE ( SELECT x FROM ( WITH x AS ( WITH x ( x ) AS ( SELECT 1 INTERSECT SELECT x ^ 1 FROM x ) SELECT * FROM x ) SELECT x FROM x UNION SELECT x FROM x ) AS x ORDER BY 1 ) , 1 ) ORDER BY 'x' ) IN ( ( WITH x ( x ) AS ( WITH x AS ( SELECT ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT x + 1 FROM ( SELECT x FROM x UNION SELECT x FROM x UNION SELECT x BETWEEN ( SELECT 1 AS x WHERE ( SELECT x AS x WHERE 1 > x ) ) AND x FROM x ORDER BY x , ( SELECT x FROM x AS x WHERE x = 'x' OR x = 'x' AND 1 + 1 / 1 GROUP BY x ) * ( SELECT x > 1.000000 ) ^ ( ( SELECT 1 FROM x WHERE ( x , x ) NOT IN ( SELECT x , x FROM x WHERE 1 NOT IN ( SELECT ( SELECT x FROM x WHERE 1 = x ) AS x FROM x GROUP BY x HAVING ( SELECT 1 FROM x ORDER BY ( SELECT x ORDER BY 1 ) , ( 1 < x AND x = 1 ) LIMIT 1 ) != 'x' ) ) GROUP BY x , x HAVING x = 1 ) NOT IN ( 1 , NOT EXISTS ( SELECT 1 FROM x ) ) ) ) AS x ) SELECT x FROM x WHERE 1 = x ) AS x FROM x WINDOW x AS ( PARTITION BY x ORDER BY x DESC ) INTERSECT SELECT x ^ 1 FROM x ) SELECT 1 UNION SELECT 1 - x FROM x ) SELECT ( SELECT x AS x WHERE 1 > x ) FROM x WHERE ( x , x ) NOT IN ( SELECT x , 'x' = 'x' AND EXISTS ( SELECT * FROM x WHERE x = x ) FROM x ) ) ) ORDER BY ( SELECT ( SELECT x FROM x WHERE 1 = x ) AS x FROM x WINDOW x AS ( PARTITION BY x ORDER BY ( SELECT ( SELECT 1 FROM x GROUP BY 'x' , ( x * 1 ) > x ) ORDER BY 1 ) RANGE BETWEEN 1 FOLLOWING AND 1 FOLLOWING ) ORDER BY ( SELECT x WHERE FALSE ORDER BY 1 ) ) ) ;

Will trigger Segmentation fault.
GDB info:
Thread 16 "mariadbd" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffd242e300 (LWP 2995)]
0x0000000000be2d67 in sub_select (join=0x63200e096960, join_tab=0x0, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23355
23355 if (join_tab->split_derived_to_update && !end_of_records)
(gdb) p join_tab
$90 = (JOIN_TAB *) 0x0

#0 0x0000555555dbf5d1 in sub_select (join=0x7fff98169428, join_tab=0x0, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23355
#1 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#2 JOIN::exec_inner (this=this@entry=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#3 0x0000555555df1d78 in JOIN::exec (this=this@entry=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#4 0x0000555555e44695 in st_select_lex_unit::exec_inner (this=this@entry=0x7fff9807e3f0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2512
#5 0x0000555555e44821 in st_select_lex_unit::exec (this=this@entry=0x7fff9807e3f0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#6 0x0000555555d2f7be in mysql_derived_fill (thd=<optimized out>, lex=0x7fff98004e08,
derived=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#7 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff98098c70, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#8 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff981d8f30)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#9 0x0000555555dbf758 in sub_select (join=0x7fff981656f8, join_tab=0x7fff981d8f30,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#10 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#11 JOIN::exec_inner (this=this@entry=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#12 0x0000555555df1d78 in JOIN::exec (this=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#13 0x0000555555e44b84 in st_select_lex_unit::exec_recursive (this=this@entry=0x7fff9807c680)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#14 0x0000555555d2f38a in TABLE_LIST::fill_recursive (this=0x7fff98089758, thd=0x7fff98000c58)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#15 0x0000555555d2f82b in mysql_derived_fill (thd=0x7fff98000c58, lex=0x7fff98004e08,
derived=0x7fff98089758) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#16 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff98089758, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#17 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff983f9858)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#18 0x0000555555dbf758 in sub_select (join=0x7fff9816eca0, join_tab=0x7fff983f9858,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#19 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff9816eca0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#20 JOIN::exec_inner (this=this@entry=0x7fff9816eca0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#21 0x0000555555df1d78 in JOIN::exec (this=0x7fff9816eca0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#22 0x00005555560b1422 in subselect_single_select_engine::exec (this=0x7fff9808ab98)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#23 0x00005555560b040c in Item_subselect::exec (this=0x7fff9808aa08)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#24 0x00005555560afd03 in Item_singlerow_subselect::val_int (this=0x7fff9808aa08)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1462
#25 0x0000555555feec93 in Item_ref_null_helper::val_int (this=0x7fff983fc088)
at /home/wx/mariadb-11.3.0/sql/item.cc:5142
#26 0x000055555601065c in Arg_comparator::compare_int_signed (this=0x7fff983fc250)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:947
#27 0x0000555556010caf in Arg_comparator::compare (this=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.h:104
#28 Item_func_eq::val_int (this=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1780
#29 0x0000555555f211e4 in Type_handler_int_result::Item_val_bool (this=<optimized out>,
item=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:5082
#30 0x00005555560219cd in Item::eval_const_cond (this=0x7fff983fc198)
at /home/wx/mariadb-11.3.0/sql/item.h:1708
#31 Item_cond::fix_fields (this=0x7fff983fc3c8, thd=0x7fff98000c58, ref=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:4950
#32 0x00005555560b2df2 in Item_in_subselect::fix_having (select_lex=0x7fff98088b90,
having=<optimized out>, this=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:2278
#33 Item_in_subselect::fix_having (this=<optimized out>, having=<optimized out>,
select_lex=0x7fff98088b90) at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:2271
#34 0x00005555560b5434 in Item_in_subselect::inject_in_to_exists_cond (
this=this@entry=0x7fff9808f210, join_arg=join_arg@entry=0x7fff9816de88)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:2927
#35 0x0000555555ee056e in JOIN::choose_subquery_plan (this=this@entry=0x7fff9816de88,
join_tables=1) at /home/wx/mariadb-11.3.0/sql/opt_subselect.cc:6962
#36 0x0000555555def89a in make_join_statistics (keyuse_array=0x7fff9816e1e8, tables_list=...,
join=0x7fff9816de88) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:6222
#37 JOIN::optimize_inner (this=this@entry=0x7fff9816de88)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:2624
#38 0x0000555555defccd in JOIN::optimize (this=this@entry=0x7fff9816de88)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1944
#39 0x0000555555d4db06 in st_select_lex::optimize_unflattened_subqueries (
this=0x7fff98087c88, const_only=const_only@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_lex.cc:4916
#40 0x0000555555ede8ae in JOIN::optimize_constant_subqueries (this=this@entry=0x7fff9816cfe8)
at /home/wx/mariadb-11.3.0/sql/opt_subselect.cc:5898
#41 0x0000555555dec36d in JOIN::optimize_inner (this=this@entry=0x7fff9816cfe8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:2274
#42 0x0000555555defccd in JOIN::optimize (this=this@entry=0x7fff9816cfe8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1944
#43 0x0000555555d4db06 in st_select_lex::optimize_unflattened_subqueries (
this=0x7fff98086ca8, const_only=const_only@entry=false)
at /home/wx/mariadb-11.3.0/sql/sql_lex.cc:4916
#44 0x0000555555ede872 in JOIN::optimize_unflattened_subqueries (
this=this@entry=0x7fff9816bfa0) at /home/wx/mariadb-11.3.0/sql/opt_subselect.cc:5864
#45 0x0000555555dea9b7 in JOIN::optimize_stage2 (this=this@entry=0x7fff9816bfa0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:3229
#46 0x0000555555ded98c in JOIN::optimize_inner (this=this@entry=0x7fff9816bfa0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:2650
#47 0x0000555555defccd in JOIN::optimize (this=this@entry=0x7fff9816bfa0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1944
#48 0x0000555555d4db06 in st_select_lex::optimize_unflattened_subqueries (
this=0x7fff9807f918, const_only=const_only@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_lex.cc:4916
#49 0x0000555555ede8ae in JOIN::optimize_constant_subqueries (this=this@entry=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/opt_subselect.cc:5898
#50 0x0000555555dec36d in JOIN::optimize_inner (this=this@entry=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:2274
#51 0x0000555555defccd in JOIN::optimize (this=this@entry=0x7fff98169428)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1944
#52 0x0000555555defdc1 in mysql_select (thd=0x7fff98000c58, tables=0x7fff9807e438,
fields=..., conds=conds@entry=0x0, og_num=2, order=0x7fff98083358, group=0x0, having=0x0,
proc_param=0x0, select_options=<optimized out>, result=0x7fff981660e0,
unit=0x7fff9807e3f0, select_lex=0x7fff9807f918)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5235
#53 0x0000555555e44534 in st_select_lex_unit::exec_inner (this=this@entry=0x7fff9807e3f0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2501
#54 0x0000555555e44821 in st_select_lex_unit::exec (this=this@entry=0x7fff9807e3f0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#55 0x0000555555d2f7be in mysql_derived_fill (thd=<optimized out>, lex=0x7fff98004e08,
derived=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#56 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff98098c70, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#57 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff981d8f30)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#58 0x0000555555dbf758 in sub_select (join=0x7fff981656f8, join_tab=0x7fff981d8f30,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#59 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#60 JOIN::exec_inner (this=this@entry=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#61 0x0000555555df1d78 in JOIN::exec (this=0x7fff981656f8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#62 0x0000555555e44b84 in st_select_lex_unit::exec_recursive (this=this@entry=0x7fff9807c680)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#63 0x0000555555d2f38a in TABLE_LIST::fill_recursive (this=0x7fff98099f80, thd=0x7fff98000c58)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#64 0x0000555555d2f82b in mysql_derived_fill (thd=0x7fff98000c58, lex=0x7fff98004e08,
derived=0x7fff98099f80) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#65 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff98099f80, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#66 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff981dbd08)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#67 0x0000555555dbf758 in sub_select (join=0x7fff981643c0, join_tab=0x7fff981dbd08,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#68 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff981643c0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#69 JOIN::exec_inner (this=this@entry=0x7fff981643c0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#70 0x0000555555df1d78 in JOIN::exec (this=0x7fff981643c0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#71 0x00005555560b1422 in subselect_single_select_engine::exec (this=0x7fff9809b458)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#72 0x00005555560b040c in Item_subselect::exec (this=0x7fff9809b2c8)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#73 0x00005555560afd03 in Item_singlerow_subselect::val_int (this=0x7fff9809b2c8)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1462
#74 0x0000555556001563 in Item::save_int_in_field (this=0x7fff9809b2c8, field=0x7fff98192ec0,
no_conversions=<optimized out>) at /home/wx/mariadb-11.3.0/sql/item.cc:6843
#75 0x0000555555ff36d7 in Item::save_in_field (this=0x7fff9809b2c8, field=0x7fff98192ec0,
no_conversions=<optimized out>) at /home/wx/mariadb-11.3.0/sql/item.cc:6853
#76 0x0000555555d0c0ba in fill_record (thd=0x7fff98000c58, table=0x7fff98192090,
ptr=0x7fff98192978, values=..., ignore_errors=ignore_errors@entry=true,
use_value=use_value@entry=false) at /home/wx/mariadb-11.3.0/sql/sql_base.cc:9320
#77 0x0000555555e412a1 in select_unit::send_data (this=0x7fff98163b28, values=...)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:122
#78 0x0000555555dd9d0c in select_result_sink::send_data_with_check (u=<optimized out>,
sent=<optimized out>, items=..., this=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_class.h:5842
#79 select_result_sink::send_data_with_check (sent=<optimized out>, u=<optimized out>,
items=..., this=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_class.h:5832
#80 end_send (join=0x7fff98163c18, join_tab=0x7fff981de9a0, end_of_records=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24710
#81 0x0000555555dad6d4 in evaluate_join_record (join=join@entry=0x7fff98163c18,
join_tab=join_tab@entry=0x7fff981de528, error=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#82 0x0000555555dbf7fb in sub_select (join=0x7fff98163c18, join_tab=0x7fff981de528,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
#83 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff98163c18)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#84 JOIN::exec_inner (this=this@entry=0x7fff98163c18)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#85 0x0000555555df1d78 in JOIN::exec (this=0x7fff98163c18)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#86 0x0000555555e444bc in st_select_lex_unit::exec_inner (this=this@entry=0x7fff9809bfe8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2389
#87 0x0000555555e44821 in st_select_lex_unit::exec (this=this@entry=0x7fff9809bfe8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#88 0x0000555555d2f7be in mysql_derived_fill (thd=<optimized out>, lex=0x7fff98004e08,
derived=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#89 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff9809f1e8, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#90 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff981e3150)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#91 0x0000555555dbf758 in sub_select (join=0x7fff98194f78, join_tab=0x7fff981e3150,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#92 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff98194f78)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#93 JOIN::exec_inner (this=this@entry=0x7fff98194f78)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#94 0x0000555555df1d78 in JOIN::exec (this=0x7fff98194f78)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#95 0x0000555555e444bc in st_select_lex_unit::exec_inner (this=this@entry=0x7fff9809e1e0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2389
#96 0x0000555555e44821 in st_select_lex_unit::exec (this=this@entry=0x7fff9809e1e0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#97 0x0000555555d2f7be in mysql_derived_fill (thd=<optimized out>, lex=0x7fff98004e08,
derived=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#98 0x0000555555d2f1fc in mysql_handle_single_derived (lex=0x7fff98004e08,
derived=derived@entry=0x7fff980a1818, phases=phases@entry=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#99 0x0000555555dbf4f0 in st_join_table::preread_init (this=this@entry=0x7fff981e6a80)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#100 0x0000555555dbf758 in sub_select (join=0x7fff981a6370, join_tab=0x7fff981e6a80,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#101 0x0000555555df19b2 in do_select (procedure=<optimized out>, join=0x7fff981a6370)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#102 JOIN::exec_inner (this=this@entry=0x7fff981a6370)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#103 0x0000555555df1d78 in JOIN::exec (this=0x7fff981a6370)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#104 0x00005555560b1422 in subselect_single_select_engine::exec (this=0x7fff980a6920)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#105 0x00005555560b040c in Item_subselect::exec (this=0x7fff980a66f0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#106 0x00005555560b0864 in Item_in_subselect::val_bool (this=0x7fff980a66f0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1991
#107 0x000055555601d3f4 in Item_in_optimizer::val_int (this=0x7fff981b7620)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1664
#108 Item_in_optimizer::val_int (this=0x7fff981b7620)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1572
#109 0x0000555555fefb79 in Item_cache_int::cache_value (this=0x7fff9821cbd0)
at /home/wx/mariadb-11.3.0/sql/item.cc:10161
#110 0x00005555560052ac in Item_cache_wrapper::cache (this=0x7fff9821cb28)
at /home/wx/mariadb-11.3.0/sql/item.cc:8915
#111 Item_cache_wrapper::val_int (this=0x7fff9821cb28)
at /home/wx/mariadb-11.3.0/sql/item.cc:8969
#112 Item_cache_wrapper::val_int (this=0x7fff9821cb28)
at /home/wx/mariadb-11.3.0/sql/item.cc:8952
#113 0x0000555555dd9c5d in end_send (join=0x7fff9819de10, join_tab=0x7fff981cfaa8,
end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24685
#114 0x0000555555dad6d4 in evaluate_join_record (join=join@entry=0x7fff9819de10,
join_tab=0x7fff981cf630, error=error@entry=0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#115 0x0000555555de7eeb in AGGR_OP::end_send (this=0x7fff9821d070)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32335
#116 0x0000555555de8150 in sub_select_postjoin_aggr (join=0x7fff9819de10,
join_tab=0x7fff981cf630, end_of_records=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23128
#117 0x0000555555df1814 in do_select (procedure=<optimized out>, join=0x7fff9819de10)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22963
#118 JOIN::exec_inner (this=this@entry=0x7fff9819de10)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#119 0x0000555555df1d78 in JOIN::exec (this=0x7fff9819de10)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#120 0x00005555560b1422 in subselect_single_select_engine::exec (this=0x7fff980aea40)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#121 0x00005555560b040c in Item_subselect::exec (this=0x7fff980ae8b0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#122 0x00005555560afd03 in Item_singlerow_subselect::val_int (this=0x7fff980ae8b0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1462
#123 0x0000555555df1491 in JOIN::exec_inner (this=this@entry=0x7fff9819b4c8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4835
#124 0x0000555555df1d78 in JOIN::exec (this=this@entry=0x7fff9819b4c8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#125 0x0000555555df1e9a in Sql_cmd_dml::execute_inner (this=this@entry=0x7fff980142b8,
thd=thd@entry=0x7fff98000c58) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33413
#126 0x0000555555e54ff7 in Sql_cmd_update::execute_inner (this=0x7fff980142b8,
thd=0x7fff98000c58) at /home/wx/mariadb-11.3.0/sql/sql_update.cc:3069
#127 0x0000555555dab46b in Sql_cmd_dml::execute (this=0x7fff980142b8, thd=0x7fff98000c58)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33350
#128 0x0000555555d7920d in mysql_execute_command (thd=thd@entry=0x7fff98000c58,
is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:4361
#129 0x0000555555d68c27 in mysql_parse (thd=0x7fff98000c58, rawbuf=<optimized out>,
length=<optimized out>, parser_state=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
#130 0x0000555555d74fdd in dispatch_command (command=command@entry=COM_QUERY,
thd=thd@entry=0x7fff98000c58,
packet=packet@entry=0x7fff98008509 "UPDATE x SET x = 1 WHERE ( SELECT 1 FROM x GROUP BY x , x HAVING ( SELECT x IN ( ( SELECT 1 WHERE 1 GROUP BY x , x HAVING x IN ( x NOT LIKE ( SELECT x ) + x IS NOT NULL ) AND x NOT IN ( 1 , 1 ) ) NOT "...,
packet_length=packet_length@entry=1647, blocking=blocking@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_class.h:251
#131 0x0000555555d7721e in do_command (thd=0x7fff98000c58, blocking=blocking@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
#132 0x0000555555e9a617 in do_handle_one_connection (connect=<optimized out>,
connect@entry=0x555557e16f48, put_in_cache=put_in_cache@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
#133 0x0000555555e9a94d in handle_one_connection (arg=arg@entry=0x555557e16f48)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
#134 0x00005555561e658d in pfs_spawn_thread (arg=0x555557dc0a08)
at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
#135 0x00007ffff7b48609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#136 0x00007ffff7719133 in clone () from /lib/x86_64-linux-gnu/libc.so.6