[MDEV-32427] Segmentation fault at /mariadb-11.3.0/sql/table.cc:7154 Created: 2023-10-10  Updated: 2023-11-28

Status: Confirmed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.4, 10.5, 10.6, 10.9, 10.10, 10.11, 11.0, 11.1, 11.2, 11.3.0
Fix Version/s: 10.4, 10.5, 10.6, 10.11, 11.0, 11.1, 11.2

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

Ubuntu 20.04

Issue Links:
Relates

 Description   

Run these queries in release build:

CREATE VIEW x AS WITH RECURSIVE x ( x ) AS ( WITH x AS ( SELECT 1 FROM x AS x NATURAL INNER JOIN x AS x ORDER BY EXISTS ( WITH x AS ( SELECT x ( x ) FROM x GROUP BY x ORDER BY x ) SELECT 1 ) DESC ) SELECT 1 UNION SELECT x IN ( 'x' = x ) FROM x ) SELECT 1 ;

Will trigger Segmentation fault.
GDB info:
Thread 17 "mariadbd" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffe011a700 (LWP 47254)]
Field_iterator_natural_join::set (this=0x7fffe0115790, table_ref=0x7fff98013d28)
at /home/wx/mariadb-11.3.0/sql/table.cc:7154
7154 cur_column_ref= column_ref_it++;
(gdb) p column_ref_it
$80 = {<base_list_iterator> =

{list = 0x0, el = 0x0, prev = 0x0, current = 0x0}

, <No data fields>}

#0 Field_iterator_natural_join::set (this=0x7fffe0115790, table_ref=0x7fff98013d28)
at /home/wx/mariadb-11.3.0/sql/table.cc:7154
#1 0x0000555555d00091 in store_natural_using_join_columns (
natural_using_join=0x7fff98014bb0, natural_using_join=0x7fff98014bb0,
found_using_fields=0, using_fields=0x0, table_ref_2=0x7fff98014480,
table_ref_1=0x7fff98013d28, thd=0x7fff98000c58)
at /home/wx/mariadb-11.3.0/sql/sql_base.cc:7554
#2 store_top_level_join_columns (thd=thd@entry=0x7fff98000c58,
table_ref=table_ref@entry=0x7fff98014bb0, left_neighbor=left_neighbor@entry=0x0,
right_neighbor=0x0) at /home/wx/mariadb-11.3.0/sql/sql_base.cc:7765
#3 0x0000555555d0a249 in setup_natural_join_row_types (context=0x7fff980137d8,
from_clause=0x7fff98013948, thd=0x7fff98000c58)
at /home/wx/mariadb-11.3.0/sql/sql_base.cc:7876
#4 setup_tables (thd=thd@entry=0x7fff98000c58, context=0x7fff980137d8,
from_clause=0x7fff98013948, tables=tables@entry=0x7fff98013d28, leaves=...,
select_insert=select_insert@entry=false, full_table_list=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_base.cc:8388
#5 0x0000555555d0a434 in setup_tables_and_check_access (thd=0x7fff98000c58,
context=<optimized out>, from_clause=<optimized out>, tables=0x7fff98013d28, leaves=...,
select_insert=select_insert@entry=false, want_access_first=SELECT_ACL,
want_access=SELECT_ACL, full_table_list=false)
at /home/wx/mariadb-11.3.0/sql/sql_base.cc:8430
#6 0x0000555555ddc881 in JOIN::prepare (this=this@entry=0x7fff98073950,
tables_init=<optimized out>, conds_init=<optimized out>, og_num=1,
order_init=<optimized out>, skip_order_by=<optimized out>, group_init=0x0,
having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fff98013790,
unit_arg=0x7fff98015378) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1451
#7 0x0000555555e42e50 in st_select_lex_unit::prepare_join (this=this@entry=0x7fff98015378,
thd_arg=0x7fff98000c58, sl=sl@entry=0x7fff98013790,
tmp_result=tmp_result@entry=0x7fff98073860,
additional_options=additional_options@entry=0,
is_union_select=is_union_select@entry=false)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1103
#8 0x0000555555e45b64 in st_select_lex_unit::prepare (this=this@entry=0x7fff98015378,
derived_arg=derived_arg@entry=0x7fff98039890, sel_result=sel_result@entry=0x7fff98073860,
additional_options=additional_options@entry=0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1583
#9 0x0000555555d30444 in mysql_derived_prepare (thd=0x7fff98000c58, lex=<optimized out>,
derived=0x7fff98039890) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:840
#10 0x0000555555d2f249 in mysql_handle_single_derived (lex=lex@entry=0x7fff98004e08,
derived=derived@entry=0x7fff98039890, phases=phases@entry=2)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#11 0x0000555555e6e8ce in TABLE_LIST::handle_derived (this=this@entry=0x7fff98039890,
lex=lex@entry=0x7fff98004e08, phases=phases@entry=2)
at /home/wx/mariadb-11.3.0/sql/table.cc:9651
#12 0x0000555555d4bbb7 in LEX::handle_list_of_derived (phases=2, table_list=<optimized out>,
this=0x7fff98004e08) at /home/wx/mariadb-11.3.0/sql/sql_lex.h:4579
#13 st_select_lex::handle_derived (this=<optimized out>, lex=0x7fff98004e08,
phases=phases@entry=2) at /home/wx/mariadb-11.3.0/sql/sql_lex.cc:4989
#14 0x0000555555ddc80b in JOIN::prepare (this=this@entry=0x7fff98073058,
tables_init=<optimized out>, conds_init=<optimized out>, og_num=0,
order_init=<optimized out>, skip_order_by=<optimized out>, group_init=0x0,
having_init=0x0, proc_param_init=0x0, select_lex_arg=0x7fff98038c20,
unit_arg=0x7fff980383e8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1439
#15 0x0000555555e42e50 in st_select_lex_unit::prepare_join (this=this@entry=0x7fff980383e8,
thd_arg=0x7fff98000c58, sl=sl@entry=0x7fff98038c20,
tmp_result=tmp_result@entry=0x7fff98072e88,
additional_options=additional_options@entry=0, is_union_select=is_union_select@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1103
#16 0x0000555555e4635f in st_select_lex_unit::prepare (this=0x7fff980383e8,
derived_arg=0x7fff98016398, sel_result=sel_result@entry=0x0,
additional_options=additional_options@entry=0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1659
#17 0x0000555555f488b0 in With_element::prepare_unreferenced (this=this@entry=0x7fff98039fc0,
thd=thd@entry=0x7fff98000c58) at /home/wx/mariadb-11.3.0/sql/sql_cte.cc:1284
#18 0x0000555555f48925 in With_clause::prepare_unreferenced_elements (this=<optimized out>,
thd=0x7fff98000c58) at /home/wx/mariadb-11.3.0/sql/sql_cte.cc:923
#19 0x0000555555ddd2f3 in JOIN::prepare (this=this@entry=0x7fff98072648,
tables_init=<optimized out>, conds_init=<optimized out>, og_num=<optimized out>,
order_init=<optimized out>, skip_order_by=<optimized out>, group_init=<optimized out>,
having_init=<optimized out>, proc_param_init=<optimized out>,
select_lex_arg=<optimized out>, unit_arg=<optimized out>)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:1620
#20 0x0000555555e42e50 in st_select_lex_unit::prepare_join (this=this@entry=0x7fff98004ee8,
thd_arg=0x7fff98000c58, sl=sl@entry=0x7fff980716b8, tmp_result=tmp_result@entry=0x0,
additional_options=additional_options@entry=0,
is_union_select=is_union_select@entry=false)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1103
#21 0x0000555555e45b64 in st_select_lex_unit::prepare (this=this@entry=0x7fff98004ee8,
derived_arg=0x0, sel_result=sel_result@entry=0x0,
additional_options=additional_options@entry=0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:1583
#22 0x0000555555e589f9 in mysql_create_view (thd=thd@entry=0x7fff98000c58,
views=views@entry=0x7fff98012f00, mode=VIEW_CREATE_NEW)
at /home/wx/mariadb-11.3.0/sql/sql_view.cc:556
#23 0x0000555555d7a72f 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:5531
#24 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
#25 0x0000555555d74fdd in dispatch_command (command=command@entry=COM_QUERY,
thd=thd@entry=0x7fff98000c58,
packet=packet@entry=0x7fff98008509 "CREATE VIEW x AS WITH RECURSIVE x ( x ) AS ( WITH x AS ( SELECT 1 FROM x AS x NATURAL INNER JOIN x AS x ORDER BY EXISTS ( WITH x AS ( SELECT x ( x ) FROM x GROUP BY x ORDER BY x ) SELECT 1 ) DESC ) SE"...,
packet_length=packet_length@entry=254, blocking=blocking@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_class.h:251
#26 0x0000555555d7721e in do_command (thd=0x7fff98000c58, blocking=blocking@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
#27 0x0000555555e9a617 in do_handle_one_connection (connect=<optimized out>,
connect@entry=0x555557e16318, put_in_cache=put_in_cache@entry=true)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
#28 0x0000555555e9a94d in handle_one_connection (arg=arg@entry=0x555557e16318)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
#29 0x00005555561e658d in pfs_spawn_thread (arg=0x555557dbfdd8)
at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
#30 0x00007ffff7b48609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#31 0x00007ffff7719133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

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

Thank you for the report! I repeated as described:

Version: '10.4.32-MariaDB-debug-log'  
mysqld: /10.4/src/sql/table.cc:6761: void Field_iterator_table_ref::set_field_iterator(): Assertion `table_ref->is_natural_join || table_ref->nested_join || (table_ref->join_columns && ((table_ref->field_translation && table_ref->join_columns->elements == (ulong)(table_ref->field_translation_end - table_ref->field_translation)) || (!table_ref->field_translation && table_ref->join_columns->elements == table_ref->table->s->fields)))' failed.
 
231102 15:03:07 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: b4de67da451b580989843fd63c0d248f7b8b3a53
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f8f8d8f6fd6]
 
sql/table.cc:6761(Field_iterator_table_ref::set_field_iterator())[0x55e4aa988af0]
 
sql/table.cc:6805(Field_iterator_table_ref::set(TABLE_LIST*))[0x55e4aa9893c6]
 
sql/sql_base.cc:7227(store_natural_using_join_columns(THD*, TABLE_LIST*, TABLE_LIST*, TABLE_LIST*, List<String>*, unsigned int))[0x55e4aa4c95e6]
 
sql/sql_base.cc:7438(store_top_level_join_columns(THD*, TABLE_LIST*, TABLE_LIST*, TABLE_LIST*))[0x55e4aa4ca8c8]
 
sql/sql_base.cc:7549(setup_natural_join_row_types(THD*, List<TABLE_LIST>*, Name_resolution_context*))[0x55e4aa4cb249]
 
sql/sql_base.cc:8052(setup_tables(THD*, Name_resolution_context*, List<TABLE_LIST>*, TABLE_LIST*, List<TABLE_LIST>&, bool, bool))[0x55e4aa4cf44a]
 
sql/sql_base.cc:8091(setup_tables_and_check_access(THD*, Name_resolution_context*, List<TABLE_LIST>*, TABLE_LIST*, List<TABLE_LIST>&, bool, unsigned long, unsigned long, bool))[0x55e4aa4cf87e]
 
sql/sql_select.cc:1255(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55e4aa6f6fa4]
 
sql/sql_union.cc:662(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long, bool))[0x55e4aa90982e]
 
sql/sql_union.cc:1009(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long))[0x55e4aa90cfcd]
 
sql/sql_derived.cc:824(mysql_derived_prepare(THD*, LEX*, TABLE_LIST*))[0x55e4aa56e739]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55e4aa56ab0a]
 
sql/table.cc:9090(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x55e4aa9998a7]
 
sql/sql_lex.h:4403(LEX::handle_list_of_derived(TABLE_LIST*, unsigned int))[0x55e4aa5b3050]
 
sql/sql_lex.cc:4307(st_select_lex::handle_derived(LEX*, unsigned int))[0x55e4aa5d51b3]
 
sql/sql_select.cc:1243(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55e4aa6f6cb4]
 
sql/sql_union.cc:662(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long, bool))[0x55e4aa90982e]
 
sql/sql_union.cc:1089(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long))[0x55e4aa90dbb5]
 
sql/sql_cte.cc:1246(With_element::prepare_unreferenced(THD*))[0x55e4aac1b220]
 
sql/sql_cte.cc:921(With_clause::prepare_unreferenced_elements(THD*))[0x55e4aac198a0]
 
sql/sql_select.cc:1443(JOIN::prepare(TABLE_LIST*, unsigned int, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55e4aa6f963f]
 
sql/sql_union.cc:662(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long, bool))[0x55e4aa90982e]
 
sql/sql_union.cc:1009(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long))[0x55e4aa90cfcd]
 
sql/sql_view.cc:541(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x55e4aa93d64c]
 
sql/sql_parse.cc:6033(mysql_execute_command(THD*))[0x55e4aa657074]
 
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55e4aa663d6f]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55e4aa63a131]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55e4aa636c5c]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55e4aaa4655f]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x55e4aaa45e03]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55e4ab6e2498]
 
nptl/pthread_create.c:478(start_thread)[0x7f8f8de11609]
 
 
 
Query (0x62b0000a1290): CREATE VIEW x AS WITH RECURSIVE x ( x ) AS ( WITH x AS ( SELECT 1 FROM x AS x NATURAL INNER JOIN x AS x ORDER BY EXISTS ( WITH x AS ( SELECT x ( x ) FROM x GROUP BY x ORDER BY x ) SELECT 1 ) DESC ) SELECT 1 UNION SELECT x IN ( 'x' = x ) FROM x ) SELECT 1

on 10.5-11.2

 
 
 
 
Version: '10.5.23-MariaDB-debug-log'  
mariadbd: /10.5/src/sql/sql_select.cc:18839: TABLE* Create_tmp_table::start(THD*, TMP_TABLE_PARAM*, const LEX_CSTRING*): Assertion `m_alloced_field_count' failed.
 
231102 15:07:02 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.5.23-MariaDB-debug-log source revision: b06ac9a8cd2146e89270cc2150d306d8ed1b33fb
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7ffa68da9fd6]
 
sql/sql_select.cc:18840(Create_tmp_table::start(THD*, TMP_TABLE_PARAM*, st_mysql_const_lex_string const*))[0x5589509a1a31]
 
sql/sql_select.cc:19697(create_tmp_table(THD*, TMP_TABLE_PARAM*, List<Item>&, st_order*, bool, bool, unsigned long long, unsigned long long, st_mysql_const_lex_string const*, bool, bool))[0x5589509ad3a9]
 
sql/sql_union.cc:351(select_unit::create_result_table(THD*, List<Item>*, bool, unsigned long long, st_mysql_const_lex_string const*, bool, bool, bool, unsigned int))[0x558950b5c24e]
 
sql/sql_derived.cc:697(mysql_derived_prepare(THD*, LEX*, TABLE_LIST*))[0x55895077fcbb]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55895077d15b]
 
sql/table.cc:9312(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x558950bf5933]
 
sql/sql_lex.h:4455(LEX::handle_list_of_derived(TABLE_LIST*, unsigned int))[0x5589507c748c]
 
sql/sql_lex.cc:4922(st_select_lex::handle_derived(LEX*, unsigned int))[0x5589507eda1f]
 
sql/table.cc:9309(TABLE_LIST::handle_derived(LEX*, unsigned int))[0x558950bf58a5]
 
sql/sql_lex.h:4455(LEX::handle_list_of_derived(TABLE_LIST*, unsigned int))[0x5589507c748c]
 
sql/sql_lex.cc:4922(st_select_lex::handle_derived(LEX*, unsigned int))[0x5589507eda1f]
 
sql/sql_select.cc:1250(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55895091a269]
 
sql/sql_union.cc:1103(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x558950b62f01]
 
sql/sql_union.cc:1576(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x558950b67715]
 
sql/sql_cte.cc:1283(With_element::prepare_unreferenced(THD*))[0x558950eb432d]
 
sql/sql_cte.cc:922(With_clause::prepare_unreferenced_elements(THD*))[0x558950eb231c]
 
sql/sql_select.cc:1429(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x55895091c95c]
 
sql/sql_union.cc:1103(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x558950b62f01]
 
sql/sql_union.cc:1496(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x558950b66b35]
 
sql/sql_view.cc:547(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x558950b9872b]
 
sql/sql_parse.cc:5887(mysql_execute_command(THD*))[0x558950873e29]
 
sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5589508829bf]
 
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5589508583ed]
 
sql/sql_parse.cc:1375(do_command(THD*))[0x558950854d55]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x558950cb39a3]
 
sql/sql_connect.cc:1320(handle_one_connection)[0x558950cb3307]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55895193fb02]
 
nptl/pthread_create.c:478(start_thread)[0x7ffa692c4609]
 
 
 
Query (0x62b0000852a8): CREATE VIEW x AS WITH RECURSIVE x ( x ) AS ( WITH x AS ( SELECT 1 FROM x AS x NATURAL INNER JOIN x AS x ORDER BY EXISTS ( WITH x AS ( SELECT x ( x ) FROM x GROUP BY x ORDER BY x ) SELECT 1 ) DESC ) SELECT 1 UNION SELECT x IN ( 'x' = x ) FROM x ) SELECT 1
 



231102 14:54:44 [ERROR] mysqld got signal 11 ;
 
 
 
Server version: 11.1.2-MariaDB source revision: 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5
 
 
 
mysys/stacktrace.c:216(my_print_stacktrace)[0x5633ee8bfc3e]
 
sql/signal_handler.cc:241(handle_fatal_signal)[0x5633ee2b21f7]
 
sigaction.c:0(__restore_rt)[0x7f4104118420]
 
sql/sql_list.h:441(base_list_iterator::next_fast())[0x5633ee136c83]
 
sql/sql_base.cc:7564(store_top_level_join_columns(THD*, TABLE_LIST*, TABLE_LIST*, TABLE_LIST*))[0x5633edff98d5]
 
sql/sql_base.cc:7886(setup_tables(THD*, Name_resolution_context*, List<TABLE_LIST>*, TABLE_LIST*, List<TABLE_LIST>&, bool, bool))[0x5633edffa089]
 
sql/sql_base.cc:8440(setup_tables_and_check_access(THD*, Name_resolution_context*, List<TABLE_LIST>*, TABLE_LIST*, List<TABLE_LIST>&, bool, privilege_t, privilege_t, bool))[0x5633edffa222]
 
sql/sql_select.cc:1450(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5633ee0bc924]
 
sql/sql_union.cc:1115(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x5633ee11edbc]
 
sql/sql_union.cc:1583(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x5633ee122c7c]
 
sql/sql_derived.cc:840(mysql_derived_prepare(THD*, LEX*, TABLE_LIST*))[0x5633ee02116d]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x5633ee01fc7d]
 
sql/sql_lex.h:4552(LEX::handle_list_of_derived(TABLE_LIST*, unsigned int))[0x5633ee03b9b7]
 
sql/sql_select.cc:1439(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5633ee0bc386]
 
sql/sql_union.cc:1115(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x5633ee11edbc]
 
sql/sql_union.cc:1659(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x5633ee121e51]
 
sql/sql_cte.cc:1283(With_element::prepare_unreferenced(THD*))[0x5633ee217838]
 
sql/sql_cte.cc:922(With_clause::prepare_unreferenced_elements(THD*))[0x5633ee2178ad]
 
sql/sql_select.cc:1620(JOIN::prepare(TABLE_LIST*, Item*, unsigned int, st_order*, bool, st_order*, Item*, st_order*, st_select_lex*, st_select_lex_unit*))[0x5633ee0bd0aa]
 
sql/sql_union.cc:1115(st_select_lex_unit::prepare_join(THD*, st_select_lex*, select_result*, unsigned long long, bool))[0x5633ee11edbc]
 
sql/sql_union.cc:1583(st_select_lex_unit::prepare(TABLE_LIST*, select_result*, unsigned long long))[0x5633ee122c7c]
 
sql/sql_view.cc:556(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x5633ee132d1b]
 
sql/sql_parse.cc:5584(mysql_execute_command(THD*, bool))[0x5633ee062213]
 
sql/sql_parse.cc:7787(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5633ee06591b]
 
sql/sql_parse.cc:1951(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5633ee067d58]
 
sql/sql_parse.cc:1407(do_command(THD*, bool))[0x5633ee069283]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x5633ee1760c7]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x5633ee176364]
 
perfschema/pfs.cc:2204(pfs_spawn_thread)[0x5633ee501e5c]
 
nptl/pthread_create.c:478(start_thread)[0x7f410410c609]
 
 
 
Query (0x7f4080010c40): CREATE VIEW x AS WITH RECURSIVE x ( x ) AS ( WITH x AS ( SELECT 1 FROM x AS x NATURAL INNER JOIN x AS x ORDER BY EXISTS ( WITH x AS ( SELECT x ( x ) FROM x GROUP BY x ORDER BY x ) SELECT 1 ) DESC ) SELECT 1 UNION SELECT x IN ( 'x' = x ) FROM x ) SELECT 1

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