[MDEV-32698] Assertion Failed in /mariadb-11.3.0/sql/sql_union.cc:74 Created: 2023-11-07  Updated: 2023-12-06

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer - CTE, 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, 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-32431 Segmentation fault at /mariadb-11.3.0... Confirmed

 Description   

Run these queries in debug build:

CREATE TABLE x ( x INT ) ;
INSERT INTO x ( x ) VALUES ( 1 ) ;
UPDATE x SET x = 1 WHERE x IN ( SELECT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x FROM x UNION SELECT 'x' FROM x ORDER BY x IN ( SELECT DISTINCT x FROM x WHERE x = ( EXISTS ( SELECT * FROM x WHERE x = x GROUP BY x IN ( SELECT DISTINCT x NOT LIKE 'x' FROM x WHERE x = x + 1 ) , 'x' , 'x' HAVING ( 1 = 1 AND CASE 1 WHEN NOT x != 1 THEN 1.000000 WHEN NOT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 ) SELECT 1 FROM x ) THEN 'x' ELSE ( ( CASE 1 WHEN ( x < 1 OR x > 1 ) AND x % 1 = 1 AND x IS NOT NULL THEN ( - x ) WHEN 1 THEN 'x' WHEN 'x' THEN 1 WHEN 'x' THEN 'x' WHEN 'x' THEN 'x' ELSE 1 / 1 END - ( SELECT x > 1.000000 ) NOT IN ( SELECT 1 FROM ( SELECT x FROM x UNION SELECT x FROM x ORDER BY 1.000000 * 1 ) AS x WHERE ( x = 'x' OR x = 'x' ) AND x IS NOT NULL GROUP BY x ) AND ( ( x , x ) > ( 'x' , 'x' ) AND x NOT BETWEEN 'x' AND 1.000000 ^ ( 1.000000 ) ) IS NOT NULL ) NOT LIKE CASE WHEN x >= 1 THEN ( - x ) ELSE ( 1 * x ) END OR x = x ) END <= CASE WHEN x = 1 THEN 'x' ELSE EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x FROM x UNION SELECT 'x' FROM x ) AS x ) SELECT * FROM x WHERE x = x ) END ) ) OR x > 'x' ) NOT LIKE 'x' ) , x ASC ) AS x ) SELECT * FROM x WHERE x = x ) AS x FROM x UNION SELECT x + 1 FROM x ) ORDER BY x * 1 ;

Will trigger Assertion Failed.
GDB info:
#0 0x00007ffff6c0c00b in raise () from /lib/x86_64-linux-gnu/libc.so.6
#1 0x00007ffff6beb859 in abort () from /lib/x86_64-linux-gnu/libc.so.6
#2 0x00007ffff6beb729 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
#3 0x00007ffff6bfcfd6 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#4 0x00005555575147d2 in select_unit::change_select (this=0x62d0001229c0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:74
#5 0x000055555752918d in st_select_lex_unit::exec_inner (this=0x629000156318)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2341
#6 0x0000555557528545 in st_select_lex_unit::exec (this=0x629000156318)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#7 0x00005555570d9898 in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x62d0001193d0)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#8 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x62d0001193d0, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#9 0x000055555732a50c in st_join_table::preread_init (this=0x62f000024098)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#10 0x000055555735f8c8 in sub_select (join=0x62d00011fe78, join_tab=0x62f000024098, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#11 0x000055555735dadd in do_select (join=0x62d00011fe78, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#12 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011fe78) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#13 0x00005555572d93a0 in JOIN::exec (this=0x62d00011fe78) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#14 0x000055555752c2cf in st_select_lex_unit::exec_recursive (this=0x6290000f7520)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#15 0x00005555570d8d53 in TABLE_LIST::fill_recursive (this=0x629000159758, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#16 0x00005555570d986b in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x629000159758)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#17 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x629000159758, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#18 0x000055555732a50c in st_join_table::preread_init (this=0x63100008ca38)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#19 0x000055555735f8c8 in sub_select (join=0x62d000126a58, join_tab=0x63100008ca38, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#20 0x000055555735dadd in do_select (join=0x62d000126a58, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#21 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d000126a58) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#22 0x00005555572d93a0 in JOIN::exec (this=0x62d000126a58) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#23 0x0000555557dce72f in subselect_single_select_engine::exec (this=0x62d000116430)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#24 0x0000555557da9c85 in Item_subselect::exec (this=0x62d000118f20)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#25 0x0000555557dab291 in Item_in_subselect::exec (this=0x62d000118f20)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:994
#26 0x0000555557db650f in Item_in_subselect::val_bool (this=0x62d000118f20)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1991
#27 0x0000555556e14cd4 in Item::val_bool_result (this=0x62d000118f20) at /home/wx/mariadb-11.3.0/sql/item.h:1797
#28 0x0000555557bf3f02 in Item_in_optimizer::val_int (this=0x62f000011f30)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1664
#29 0x0000555556e14b78 in Item::val_int_result (this=0x62f000011f30) at /home/wx/mariadb-11.3.0/sql/item.h:1793
#30 0x0000555557bc30d8 in Item_cache_int::cache_value (this=0x6310000bc508)
at /home/wx/mariadb-11.3.0/sql/item.cc:10161
#31 0x0000555557bdad9f in Item_cache_wrapper::cache (this=0x6310000bc458) at /home/wx/mariadb-11.3.0/sql/item.cc:8915
#32 0x0000555557bb7dac in Item_cache_wrapper::save_val (this=0x6310000bc458, to=0x61a0001ddd28)
at /home/wx/mariadb-11.3.0/sql/item.cc:8941
#33 0x0000555557bd1043 in Item_cache_wrapper::save_in_result_field (this=0x6310000bc458)
at /home/wx/mariadb-11.3.0/sql/item.h:5958
#34 0x00005555573879d1 in copy_funcs (func_ptr=0x620000041b78, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:28843
#35 0x000055555736c428 in end_write (join=0x62d000124898, join_tab=0x62f0000330c8, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24979
#36 0x00005555573a1a77 in AGGR_OP::put_record (this=0x6310000bc8d8, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32254
#37 0x00005555573b632d in AGGR_OP::put_record (this=0x6310000bc8d8) at /home/wx/mariadb-11.3.0/sql/sql_select.h:1180
#38 0x000055555735ec6a in sub_select_postjoin_aggr (join=0x62d000124898, join_tab=0x62f0000330c8,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23134
#39 0x000055555736194d in evaluate_join_record (join=0x62d000124898, join_tab=0x62f000032c50, error=0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#40 0x00005555573601c2 in sub_select (join=0x62d000124898, join_tab=0x62f000032c50, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
#41 0x000055555735dadd in do_select (join=0x62d000124898, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#42 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d000124898) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#43 0x00005555572d93a0 in JOIN::exec (this=0x62d000124898) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#44 0x00005555572ddbab in mysql_select (thd=0x62c0001e0288, tables=0x629000156360, fields=..., conds=0x0, og_num=2,
order=0x62d000119148, group=0x0, having=0x0, proc_param=0x0, select_options=2199023255552,
result=0x62d0001228c8, unit=0x629000156318, select_lex=0x629000157858)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
#45 0x000055555752ae77 in st_select_lex_unit::exec_inner (this=0x629000156318)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2480
#46 0x0000555557528545 in st_select_lex_unit::exec (this=0x629000156318)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#47 0x00005555570d9898 in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x62d0001193d0)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1256
#48 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x62d0001193d0, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#49 0x000055555732a50c in st_join_table::preread_init (this=0x62f000024098)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#50 0x000055555735f8c8 in sub_select (join=0x62d00011fe78, join_tab=0x62f000024098, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#51 0x000055555735dadd in do_select (join=0x62d00011fe78, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#52 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011fe78) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#53 0x00005555572d93a0 in JOIN::exec (this=0x62d00011fe78) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#54 0x000055555752c2cf in st_select_lex_unit::exec_recursive (this=0x6290000f7520)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#55 0x00005555570d8d53 in TABLE_LIST::fill_recursive (this=0x62d00011a270, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#56 0x00005555570d986b in mysql_derived_fill (thd=0x62c0001e0288, lex=0x62c0001e45f8, derived=0x62d00011a270)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#57 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001e45f8, derived=0x62d00011a270, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#58 0x000055555732a50c in st_join_table::preread_init (this=0x62f000026fa8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#59 0x000055555735f8c8 in sub_select (join=0x62f000013a98, join_tab=0x62f000026fa8, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#60 0x000055555735dadd in do_select (join=0x62f000013a98, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#61 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62f000013a98) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#62 0x00005555572d93a0 in JOIN::exec (this=0x62f000013a98) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#63 0x0000555557dce72f in subselect_single_select_engine::exec (this=0x62d00011b858)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#64 0x0000555557da9c85 in Item_subselect::exec (this=0x62d00011b6a0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#65 0x0000555557db45c3 in Item_exists_subselect::val_int (this=0x62d00011b6a0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1840
#66 0x0000555557beca8a in Arg_comparator::compare_int_signed (this=0x62f00002b980)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:947
#67 0x0000555557c2e1d4 in Arg_comparator::compare (this=0x62f00002b980)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.h:104
#68 0x0000555557bf5bdb in Item_func_eq::val_int (this=0x62f00002b8c8)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1780
#69 0x000055555735da68 in do_select (join=0x62f000013340, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22958
#70 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62f000013340) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#71 0x00005555572d93a0 in JOIN::exec (this=0x62f000013340) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#72 0x0000555557529ad1 in st_select_lex_unit::exec_inner (this=0x62d00011c070)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2389
#73 0x0000555557528545 in st_select_lex_unit::exec (this=0x62d00011c070)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#74 0x0000555557dcefe5 in subselect_union_engine::exec (this=0x62d00011dec0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4187
#75 0x0000555557da9c85 in Item_subselect::exec (this=0x62d00011dc80)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#76 0x0000555557dab291 in Item_in_subselect::exec (this=0x62d00011dc80)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:994
#77 0x0000555557db650f in Item_in_subselect::val_bool (this=0x62d00011dc80)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1991
#78 0x0000555556e14cd4 in Item::val_bool_result (this=0x62d00011dc80) at /home/wx/mariadb-11.3.0/sql/item.h:1797
#79 0x0000555557bf3f02 in Item_in_optimizer::val_int (this=0x62f000014958)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1664
#80 0x00005555570d0aa1 in SQL_SELECT::skip_record (this=0x62f000018f18, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/opt_range.h:1914
#81 0x0000555557aff70e in find_all_keys (thd=0x62c0001e0288, param=0x7fffd162a830, select=0x62f000018f18,
fs_info=0x6150000c2e00, buffpek_pointers=0x7fffd162ab30, tempfile=0x7fffd162a980, pq=0x0,
found_rows=0x6150000c2ff0) at /home/wx/mariadb-11.3.0/sql/filesort.cc:1004
#82 0x0000555557afab66 in filesort (thd=0x62c0001e0288, table=0x61900008b708, filesort=0x62f000030fa0,
tracker=0x62f000031748, join=0x62f0000129b8, first_table_bit=1) at /home/wx/mariadb-11.3.0/sql/filesort.cc:408
#83 0x00005555573791c3 in create_sort_index (thd=0x62c0001e0288, join=0x62f0000129b8, tab=0x62f000017d18,
fsort=0x62f000030fa0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:26843
#84 0x00005555573677dd in st_join_table::sort_table (this=0x62f000017d18)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24485
#85 0x0000555557366bdc in join_init_read_record (tab=0x62f000017d18)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24405
#86 0x0000555557360006 in sub_select (join=0x62f0000129b8, join_tab=0x62f000017d18, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23441
#87 0x000055555735dadd in do_select (join=0x62f0000129b8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#88 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62f0000129b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#89 0x00005555572d93a0 in JOIN::exec (this=0x62f0000129b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#90 0x00005555573a840c in Sql_cmd_dml::execute_inner (this=0x6290000f6828, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33413
#91 0x0000555557569d49 in Sql_cmd_update::execute_inner (this=0x6290000f6828, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_update.cc:3069
#92 0x00005555573a7f0d in Sql_cmd_dml::execute (this=0x6290000f6828, thd=0x62c0001e0288)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33350
#93 0x00005555571c1637 in mysql_execute_command (thd=0x62c0001e0288, is_called_from_prepared_stmt=false)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:4361
#94 0x00005555571d95e2 in mysql_parse (thd=0x62c0001e0288,
rawbuf=0x6290000f52a8 "UPDATE x SET x = 1 WHERE x IN ( SELECT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x "...,
length=1463, parser_state=0x7fffd162c870) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
#95 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0288,
packet=0x6290000eb289 "UPDATE x SET x = 1 WHERE x IN ( SELECT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x "...,
packet_length=1463, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
#96 0x00005555571adf7c in do_command (thd=0x62c0001e0288, blocking=true)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
#97 0x000055555768e557 in do_handle_one_connection (connect=0x611000049908, put_in_cache=true)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
#98 0x000055555768deb4 in handle_one_connection (arg=0x611000049908)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
#99 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000005108)
at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
#100 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#101 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

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

Thanks! I repeated as described on 10.4-11.3

mysqld: /10.4/src/sql/sql_union.cc:71: void select_unit::change_select(): Assertion `table->file->inited == 0' failed.
 
231109 14:54:35 [ERROR] mysqld got signal 6 ;
 
 
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: 62d80652be7c19f4ad2bf68d6ffbb4e1eb1d77ea
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f062308c729]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f062309dfd6]
 
sql/sql_union.cc:72(select_unit::change_select())[0x563409190f7a]
 
sql/sql_union.cc:1555(st_select_lex_unit::exec())[0x5634091a087c]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x563408df84fd]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x563408df131c]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x563408fecdbf]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x56340901dc5b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x56340901c08c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x5634091a4083]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x563408df79c6]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x563408df84d0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x563408df131c]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x563408fecdbf]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x56340901dc5b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x56340901c08c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/item_subselect.cc:4035(subselect_single_select_engine::exec())[0x5634098ef32a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x5634098ca392]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x5634098cb996]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x5634098d6f71]
 
sql/item.h:1562(Item::val_bool_result())[0x563408c0b952]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x56340976d8f8]
 
sql/item.h:1558(Item::val_int_result())[0x563408c0b7f6]
 
sql/item.cc:10023(Item_cache_int::cache_value())[0x56340973ad3b]
 
sql/item.cc:8782(Item_cache_wrapper::cache())[0x563409753906]
 
sql/item.cc:8808(Item_cache_wrapper::save_val(Field*))[0x56340972f67b]
 
sql/item.h:5775(Item_cache_wrapper::save_in_result_field(bool))[0x563409749744]
 
sql/sql_select.cc:26211(copy_funcs(Item**, THD const*))[0x563409045e73]
 
sql/sql_select.cc:22374(end_write(JOIN*, st_join_table*, bool))[0x563409029e4e]
 
sql/sql_select.cc:29651(AGGR_OP::put_record(bool))[0x563409060547]
 
sql/sql_select.h:1085(AGGR_OP::put_record())[0x563409070015]
 
sql/sql_select.cc:20627(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x56340901d029]
 
sql/sql_select.cc:21149(evaluate_join_record(JOIN*, st_join_table*, int))[0x56340901f9b1]
 
sql/sql_select.cc:20922(sub_select(JOIN*, st_join_table*, bool))[0x56340901e2e6]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x56340901c08c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x563408fab3e0]
 
sql/sql_union.cc:1729(st_select_lex_unit::exec())[0x5634091a2aa0]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x563408df84fd]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x563408df131c]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x563408fecdbf]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x56340901dc5b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x56340901c08c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x5634091a4083]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x563408df79c6]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x563408df84d0]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x563408df131c]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x563408fecdbf]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x56340901dc5b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x56340901c08c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/item_subselect.cc:4035(subselect_single_select_engine::exec())[0x5634098ef32a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x5634098ca392]
 
sql/item_subselect.cc:1735(Item_exists_subselect::val_int())[0x5634098d4d07]
 
sql/item_cmpfunc.cc:953(Arg_comparator::compare_int_signed())[0x563409765d8a]
 
sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x5634097a79a6]
 
sql/item_cmpfunc.cc:1790(Item_func_eq::val_int())[0x56340976f783]
 
sql/sql_select.cc:20380(do_select(JOIN*, Procedure*))[0x56340901b92b]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x563408fa9bd4]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/sql_union.cc:1603(st_select_lex_unit::exec())[0x5634091a1222]
 
sql/item_subselect.cc:4060(subselect_union_engine::exec())[0x5634098efc8d]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x5634098ca392]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x5634098cb996]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x5634098d6f71]
 
sql/item.h:1562(Item::val_bool_result())[0x563408c0b952]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x56340976d8f8]
 
sql/sql_select.cc:4520(JOIN::exec_inner())[0x563408fa8af8]
 
sql/sql_select.cc:4408(JOIN::exec())[0x563408fa7204]
 
sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x563408fab3e0]
 
sql/sql_update.cc:1970(mysql_multi_update(THD*, TABLE_LIST*, List<Item>*, List<Item>*, Item*, unsigned long long, enum_duplicates, bool, st_select_lex_unit*, st_select_lex*, multi_update**))[0x5634091b9d2f]
 
sql/sql_parse.cc:4532(mysql_execute_command(THD*))[0x563408ed38ed]
 
sql/sql_parse.cc:8014(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x563408eec1d7]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x563408ec2563]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x563408ebf08e]
 
sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x5634092d367e]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x5634092d2f22]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x563409f70bb0]
 
nptl/pthread_create.c:478(start_thread)[0x7f06235b8609]
 
 
 
Query (0x62b0000a1290): UPDATE x SET x = 1 WHERE x IN ( SELECT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x FROM x UNION SELECT 'x' FROM x ORDER BY x IN ( SELECT DISTINCT x FROM x WHERE x = ( EXISTS ( SELECT * FROM x WHERE x = x GROUP BY x IN ( SELECT DISTINCT x NOT LIKE 'x' FROM x WHERE x = x + 1 ) , 'x' , 'x' HAVING ( 1 = 1 AND CASE 1 WHEN NOT x != 1 THEN 1.000000 WHEN NOT EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 ) SELECT 1 FROM x ) THEN 'x' ELSE ( ( CASE 1 WHEN ( x < 1 OR x > 1 ) AND x % 1 = 1 AND x IS NOT NULL THEN ( - x ) WHEN 1 THEN 'x' WHEN 'x' THEN 1 WHEN 'x' THEN 'x' WHEN 'x' THEN 'x' ELSE 1 / 1 END - ( SELECT x > 1.000000 ) NOT IN ( SELECT 1 FROM ( SELECT x FROM x UNION SELECT x FROM x ORDER BY 1.000000 * 1 ) AS x WHERE ( x = 'x' OR x = 'x' ) AND x IS NOT NULL GROUP BY x ) AND ( ( x , x ) > ( 'x' , 'x' ) AND x NOT BETWEEN 'x' AND 1.000000 ^ ( 1.000000 ) ) IS NOT NULL ) NOT LIKE CASE WHEN x >= 1 THEN ( - x ) ELSE ( 1 * x ) END OR x = x ) END <= CASE WHEN x = 1 THEN 'x' ELSE EXISTS ( WITH RECURSIVE x ( x ) AS ( SELECT 1 INTERSECT SELECT 1 FROM x GROUP BY x , x HAVING ( 1 = 1 AND ( x = 1 ) = 1 ) INTERSECT SELECT x + 1 FROM ( SELECT x FROM x UNION SELECT 'x' FROM x ) AS x ) SELECT * FROM x WHERE x = x ) END ) ) OR x > 'x' ) NOT LIKE 'x' ) , x ASC ) AS x ) SELECT * FROM x WHERE x = x ) AS x FROM x UNION SELECT x + 1 FROM x ) ORDER BY x * 1
 



CREATE TABLE x ( x INT ) ;
 
INSERT INTO x ( x ) VALUES ( 1 ) ;
 
 
 
UPDATE x SET x = 1 WHERE x IN ( 
	WITH RECURSIVE x AS 
	(SELECT 1 x 
	 union 
	 SELECT x + 1 FROM  ( SELECT x FROM x  UNION  SELECT 'x' FROM x ORDER BY x IN  ( SELECT  x FROM x  WHERE x =  EXISTS (SELECT * FROM x) )) dt 
	) 
	SELECT * FROM x);


mysqld: /10.4/src/sql/sql_union.cc:71: void select_unit::change_select(): Assertion `table->file->inited == 0' failed.
 
231206 13:37:56 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.33-MariaDB-debug-log source revision: d8e6bb00888b1f82c031938f4c8ac5d97f6874c3
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f60fdaadfd6]
 
sql/sql_union.cc:72(select_unit::change_select())[0x55ac68fc2d04]
 
sql/sql_union.cc:1555(st_select_lex_unit::exec())[0x55ac68fd2606]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55ac68c2927b]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55ac68c2209a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55ac68e1e261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55ac68e4f03b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55ac68e4d46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55ac68ddb076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55ac68dd86a6]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x55ac68fd5e0d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x55ac68c28744]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55ac68c2924e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55ac68c2209a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55ac68e1e261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55ac68e4f03b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55ac68e4d46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55ac68ddb076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55ac68dd86a6]
 
sql/item_subselect.cc:4039(subselect_single_select_engine::exec())[0x55ac6972168a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55ac696fc414]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x55ac696fda18]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x55ac69708ff3]
 
sql/item.h:1562(Item::val_bool_result())[0x55ac68a3b962]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x55ac6959f74c]
 
sql/item.h:1558(Item::val_int_result())[0x55ac68a3b806]
 
sql/item.cc:10023(Item_cache_int::cache_value())[0x55ac6956cb8f]
 
sql/item.cc:8782(Item_cache_wrapper::cache())[0x55ac6958575a]
 
sql/item.cc:8808(Item_cache_wrapper::save_val(Field*))[0x55ac695614cf]
 
sql/item.h:5775(Item_cache_wrapper::save_in_result_field(bool))[0x55ac6957b598]
 
sql/sql_select.cc:26211(copy_funcs(Item**, THD const*))[0x55ac68e77253]
 
sql/sql_select.cc:22374(end_write(JOIN*, st_join_table*, bool))[0x55ac68e5b22e]
 
sql/sql_select.cc:29651(AGGR_OP::put_record(bool))[0x55ac68e91927]
 
sql/sql_select.h:1085(AGGR_OP::put_record())[0x55ac68ea13f5]
 
sql/sql_select.cc:20627(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55ac68e4e409]
 
sql/sql_select.cc:21149(evaluate_join_record(JOIN*, st_join_table*, int))[0x55ac68e50d91]
 
sql/sql_select.cc:20922(sub_select(JOIN*, st_join_table*, bool))[0x55ac68e4f6c6]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55ac68e4d46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55ac68ddb076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55ac68dd86a6]
 
sql/sql_select.cc:4848(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55ac68ddc882]
 
sql/sql_union.cc:1729(st_select_lex_unit::exec())[0x55ac68fd482a]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55ac68c2927b]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55ac68c2209a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55ac68e1e261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55ac68e4f03b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55ac68e4d46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55ac68ddb076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55ac68dd86a6]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x55ac68fd5e0d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x55ac68c28744]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55ac68c2924e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55ac68c2209a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55ac68e1e261]
 
sql/item_subselect.cc:4382(subselect_indexsubquery_engine::exec())[0x55ac6972407a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55ac696fc414]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x55ac696fda18]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x55ac69708ff3]
 
sql/item.h:1562(Item::val_bool_result())[0x55ac68a3b962]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x55ac6959f74c]
 
sql/opt_range.h:1665(SQL_SELECT::skip_record(THD*))[0x55ac68ff8f55]
 
sql/sql_update.cc:1010(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x55ac68fe3a50]
 
sql/sql_parse.cc:4453(mysql_execute_command(THD*))[0x55ac68d043f5]
 
sql/sql_parse.cc:8062(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55ac68d1d679]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55ac68cf3825]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55ac68cf0350]
 
sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x55ac69105420]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x55ac69104cc4]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55ac69da32d4]
 
nptl/pthread_create.c:478(start_thread)[0x7f60fdfc8609]
 
 
 
Query (0x62b0000a1290): UPDATE x SET x = 1 WHERE x IN ( 
WITH RECURSIVE x AS 
(SELECT 1 x 
union 
SELECT x + 1 FROM  ( SELECT x FROM x  UNION  SELECT 'x' FROM x ORDER BY x IN  ( SELECT  x FROM x  WHERE x =  EXISTS (SELECT * FROM x) )) dt 
) 
SELECT * FROM x)
 



CREATE TABLE x ( x INT ) ;
 
INSERT INTO x ( x ) VALUES ( 1 ) ;
 
 
 
UPDATE x SET x = 1 WHERE x IN ( 
	WITH RECURSIVE x AS 
	(SELECT 1 x 
	 union 
	 SELECT x + 1 FROM  ( SELECT x FROM x  UNION  SELECT 'x' FROM x ORDER BY x IN  ( SELECT  x FROM x  WHERE EXISTS (SELECT * FROM x) )) dt 
	) 
	SELECT * FROM x);


 
 
mysqld: /10.4/src/sql/sql_select.cc:4423: void JOIN::exec_inner(): Assertion `optimization_state == JOIN::OPTIMIZATION_DONE' failed.
 
231206 13:39:47 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.33-MariaDB-debug-log source revision: d8e6bb00888b1f82c031938f4c8ac5d97f6874c3
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fcd39dcffd6]
 
sql/sql_select.cc:4425(JOIN::exec_inner())[0x557501f09a8d]
 
sql/sql_select.cc:4408(JOIN::exec())[0x557501f096a6]
 
sql/sql_union.cc:1769(st_select_lex_unit::exec())[0x557502105c70]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x557501d5a27b]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x557501d5309a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x557501f4f261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x557501f8003b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x557501f7e46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x557501f0c076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x557501f096a6]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x557502106e0d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x557501d59744]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x557501d5a24e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x557501d5309a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x557501f4f261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x557501f8003b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x557501f7e46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x557501f0c076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x557501f096a6]
 
sql/item_subselect.cc:4039(subselect_single_select_engine::exec())[0x55750285268a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55750282d414]
 
sql/item_subselect.cc:1793(Item_exists_subselect::val_bool())[0x5575028384d3]
 
sql/item.h:1483(Item::eval_const_cond())[0x557501fc9f58]
 
sql/sql_select.cc:17873(Item::remove_eq_conds(THD*, Item::cond_result*, bool))[0x557501f6741c]
 
sql/sql_select.cc:17423(optimize_cond(JOIN*, Item*, List<TABLE_LIST>*, bool, Item::cond_result*, COND_EQUAL**, int))[0x557501f648a6]
 
sql/sql_select.cc:2133(JOIN::optimize_inner())[0x557501ef0d0f]
 
sql/sql_select.cc:1731(JOIN::optimize())[0x557501eec6a7]
 
sql/sql_lex.cc:4344(st_select_lex::optimize_unflattened_subqueries(bool))[0x557501dbd6b8]
 
sql/opt_subselect.cc:5611(JOIN::optimize_unflattened_subqueries())[0x5575023392d3]
 
sql/sql_select.cc:2962(JOIN::optimize_stage2())[0x557501ef9a25]
 
sql/sql_select.cc:2414(JOIN::optimize_inner())[0x557501ef399c]
 
sql/sql_select.cc:1731(JOIN::optimize())[0x557501eec6a7]
 
sql/sql_select.cc:4832(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x557501f0d691]
 
sql/sql_union.cc:1729(st_select_lex_unit::exec())[0x55750210582a]
 
sql/sql_derived.cc:1255(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x557501d5a27b]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x557501d5309a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x557501f4f261]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x557501f8003b]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x557501f7e46c]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x557501f0c076]
 
sql/sql_select.cc:4408(JOIN::exec())[0x557501f096a6]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x557502106e0d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x557501d59744]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x557501d5a24e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x557501d5309a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x557501f4f261]
 
sql/item_subselect.cc:4382(subselect_indexsubquery_engine::exec())[0x55750285507a]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55750282d414]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x55750282ea18]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x557502839ff3]
 
sql/item.h:1562(Item::val_bool_result())[0x557501b6c962]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x5575026d074c]
 
sql/opt_range.h:1665(SQL_SELECT::skip_record(THD*))[0x557502129f55]
 
sql/sql_update.cc:1010(mysql_update(THD*, TABLE_LIST*, List<Item>&, List<Item>&, Item*, unsigned int, st_order*, unsigned long long, bool, unsigned long long*, unsigned long long*))[0x557502114a50]
 
sql/sql_parse.cc:4453(mysql_execute_command(THD*))[0x557501e353f5]
 
sql/sql_parse.cc:8062(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557501e4e679]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557501e24825]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x557501e21350]
 
sql/sql_connect.cc:1419(do_handle_one_connection(CONNECT*))[0x557502236420]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x557502235cc4]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x557502ed42d4]
 
nptl/pthread_create.c:478(start_thread)[0x7fcd3a2ea609]
 
 
 
Query (0x62b0000a1290): UPDATE x SET x = 1 WHERE x IN ( 
WITH RECURSIVE x AS 
(SELECT 1 x 
union 
SELECT x + 1 FROM  ( SELECT x FROM x  UNION  SELECT 'x' FROM x ORDER BY x IN  ( SELECT  x FROM x  WHERE EXISTS (SELECT * FROM x) )) dt 
) 
SELECT * FROM x)

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