[MDEV-32431] Segmentation fault at /mariadb-11.3.0/sql/sql_select.cc:23355 Created: 2023-10-10  Updated: 2023-12-06

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer, Optimizer - CTE
Affects Version/s: 11.2, 11.3
Fix Version/s: 11.2, 11.3

Type: Bug Priority: Major
Reporter: Xin Wen Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Ubuntu 20.04

Issue Links:
Relates
relates to MDEV-32698 Assertion Failed in /mariadb-11.3.0/s... Confirmed

 Description   

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

 Comments   
Comment by Alice Sherepa [ 2023-11-02 ]

Thanks! I repeated on 11.2-11.3, on 10.4-11.1 - ERROR 23000: Column 'x' in group statement is ambiguous
Probably the same as MDEV-32698

mariadbd: /11.2/src/sql/sql_union.cc:74: virtual void select_unit::change_select(): Assertion `table->file->inited == 0' failed.
 
231206 17:33:33 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 11.2.3-MariaDB-debug-log source revision: 96250c82691169921a38a38bc24910294294eb24
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f933a77dfd6]
 
sql/sql_union.cc:75(select_unit::change_select())[0x5629d0a4f148]
 
sql/sql_union.cc:2342(st_select_lex_unit::exec_inner())[0x5629d0a63b0b]
 
sql/sql_union.cc:2292(st_select_lex_unit::exec())[0x5629d0a62ec3]
 
sql/sql_derived.cc:1263(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d06147c0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_union.cc:2618(st_select_lex_unit::exec_recursive())[0x5629d0a66c17]
 
sql/sql_derived.cc:1162(TABLE_LIST::fill_recursive(THD*))[0x5629d0613c7c]
 
sql/sql_derived.cc:1257(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d0614793]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/item_subselect.cc:4170(subselect_single_select_engine::exec())[0x5629d1310b9b]
 
sql/item_subselect.cc:812(Item_subselect::exec())[0x5629d12ec383]
 
sql/item_subselect.cc:1480(Item_singlerow_subselect::val_int())[0x5629d12f2401]
 
sql/item.h:1457(Item::to_longlong_null())[0x5629d0e244f4]
 
sql/item.h:1467(Item::to_longlong_hybrid_null())[0x5629d0e246fb]
 
sql/item_func.cc:1394(Item_func_mul::int_op())[0x5629d11b962f]
 
sql/item_func.h:853(Item_func_hybrid_field_type::val_int_from_int_op())[0x5629d0e26cf2]
 
sql/sql_type.cc:5440(Type_handler_int_result::Item_func_hybrid_field_type_val_int(Item_func_hybrid_field_type*) const)[0x5629d0df9e24]
 
sql/item_func.h:909(Item_func_hybrid_field_type::val_int())[0x5629d06bc5cd]
 
sql/item.cc:6878(Item::save_int_in_field(Field*, bool))[0x5629d10e70f5]
 
sql/sql_type.cc:4349(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x5629d0df464c]
 
sql/item.cc:6888(Item::save_in_field(Field*, bool))[0x5629d10e72e1]
 
sql/item.h:3477(Item_result_field::save_in_result_field(bool))[0x5629d03e4a22]
 
sql/sql_select.cc:29071(copy_funcs(Item**, THD const*))[0x5629d08c3fe2]
 
sql/sql_select.cc:25168(end_write(JOIN*, st_join_table*, bool))[0x5629d08a8598]
 
sql/sql_select.cc:32490(AGGR_OP::put_record(bool))[0x5629d08de3e9]
 
sql/sql_select.h:1186(AGGR_OP::put_record())[0x5629d08f39c7]
 
sql/sql_select.cc:23278(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x5629d089ac90]
 
sql/sql_select.cc:23827(evaluate_join_record(JOIN*, st_join_table*, int))[0x5629d089da27]
 
sql/sql_select.cc:23594(sub_select(JOIN*, st_join_table*, bool))[0x5629d089c29c]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_select.cc:5301(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*))[0x5629d0818fd5]
 
sql/sql_union.cc:2480(st_select_lex_unit::exec_inner())[0x5629d0a657c0]
 
sql/sql_union.cc:2292(st_select_lex_unit::exec())[0x5629d0a62ec3]
 
sql/sql_derived.cc:1263(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d06147c0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_union.cc:2618(st_select_lex_unit::exec_recursive())[0x5629d0a66c17]
 
sql/sql_derived.cc:1162(TABLE_LIST::fill_recursive(THD*))[0x5629d0613c7c]
 
sql/sql_derived.cc:1257(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d0614793]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/item_subselect.cc:4170(subselect_single_select_engine::exec())[0x5629d1310b9b]
 
sql/item_subselect.cc:812(Item_subselect::exec())[0x5629d12ec383]
 
sql/item_subselect.cc:1480(Item_singlerow_subselect::val_int())[0x5629d12f2401]
 
sql/item.cc:6878(Item::save_int_in_field(Field*, bool))[0x5629d10e70f5]
 
sql/sql_type.cc:4349(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x5629d0df464c]
 
sql/item.cc:6888(Item::save_in_field(Field*, bool))[0x5629d10e72e1]
 
sql/sql_base.cc:9338(fill_record(THD*, TABLE*, Field**, List<Item>&, bool, bool))[0x5629d0567f95]
 
sql/sql_union.cc:124(select_unit::send_data(List<Item>&))[0x5629d0a4f5d2]
 
sql/sql_class.h:5856(select_result_sink::send_data_with_check(List<Item>&, st_select_lex_unit*, unsigned long long))[0x5629d08f05d9]
 
sql/sql_select.cc:24899(end_send(JOIN*, st_join_table*, bool))[0x5629d08a5cd6]
 
sql/sql_select.cc:23033(do_select(JOIN*, Procedure*))[0x5629d0899333]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_union.cc:2389(st_select_lex_unit::exec_inner())[0x5629d0a6444f]
 
sql/sql_union.cc:2292(st_select_lex_unit::exec())[0x5629d0a62ec3]
 
sql/sql_derived.cc:1263(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d06147c0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_union.cc:2389(st_select_lex_unit::exec_inner())[0x5629d0a6444f]
 
sql/sql_union.cc:2292(st_select_lex_unit::exec())[0x5629d0a62ec3]
 
sql/sql_derived.cc:1263(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x5629d06147c0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5629d060d60e]
 
sql/sql_select.cc:16171(st_join_table::preread_init())[0x5629d0866326]
 
sql/sql_select.cc:23541(sub_select(JOIN*, st_join_table*, bool))[0x5629d089b951]
 
sql/sql_select.cc:23105(do_select(JOIN*, Procedure*))[0x5629d0899b03]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/item_subselect.cc:4170(subselect_single_select_engine::exec())[0x5629d1310b9b]
 
sql/item_subselect.cc:812(Item_subselect::exec())[0x5629d12ec383]
 
sql/item_subselect.cc:994(Item_in_subselect::exec())[0x5629d12ed985]
 
sql/item_subselect.cc:2009(Item_in_subselect::val_bool())[0x5629d12f8d27]
 
sql/item.h:1802(Item::val_bool_result())[0x5629d0351108]
 
sql/item_cmpfunc.cc:1712(Item_in_optimizer::val_int())[0x5629d11361fa]
 
sql/item.h:1798(Item::val_int_result())[0x5629d0350fac]
 
sql/item.cc:10202(Item_cache_int::cache_value())[0x5629d1104fd0]
 
sql/item.cc:8952(Item_cache_wrapper::cache())[0x5629d111ccad]
 
sql/item.cc:9006(Item_cache_wrapper::val_int())[0x5629d10fa2a3]
 
sql/sql_select.cc:25061(end_send_group(JOIN*, st_join_table*, bool))[0x5629d08a7564]
 
sql/sql_select.cc:23035(do_select(JOIN*, Procedure*))[0x5629d089935f]
 
sql/sql_select.cc:4986(JOIN::exec_inner())[0x5629d08173bf]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/item_subselect.cc:4170(subselect_single_select_engine::exec())[0x5629d1310b9b]
 
sql/item_subselect.cc:812(Item_subselect::exec())[0x5629d12ec383]
 
sql/item_subselect.cc:1480(Item_singlerow_subselect::val_int())[0x5629d12f2401]
 
sql/sql_select.cc:4879(JOIN::exec_inner())[0x5629d08161ac]
 
sql/sql_select.cc:4763(JOIN::exec())[0x5629d081476a]
 
sql/sql_select.cc:33649(Sql_cmd_dml::execute_inner(THD*))[0x5629d08e4d7e]
 
sql/sql_update.cc:3076(Sql_cmd_update::execute_inner(THD*))[0x5629d0aa465c]
 
sql/sql_select.cc:33586(Sql_cmd_dml::execute(THD*))[0x5629d08e487f]
 
sql/sql_parse.cc:4406(mysql_execute_command(THD*, bool))[0x5629d06fcd68]
 
sql/sql_parse.cc:7808(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5629d07146e7]
 
sql/sql_parse.cc:1895(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5629d06ec9f0]
 
sql/sql_parse.cc:1406(do_command(THD*, bool))[0x5629d06e973a]
 
sql/sql_connect.cc:1418(do_handle_one_connection(CONNECT*, bool))[0x5629d0bca9ca]
 
sql/sql_connect.cc:1322(handle_one_connection)[0x5629d0bca327]
 
 
 
Trying to get some variables.
 
Some pointers may be invalid and cause the dump to abort.
 
Query (0x6290001092a8): 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 ) ) )
 
 

Generated at Thu Feb 08 10:31:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.