[MDEV-32697] Assertion Failed in /mariadb-11.3.0/sql/handler.cc:3447 Created: 2023-11-07  Updated: 2024-01-30

Status: In Progress
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.6, 10.11, 11.0, 11.1, 11.2, 11.3

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

Ubuntu 20.04

Issue Links:
Relates
relates to MDEV-32981 SQL Simplification for the SQL Query Closed
relates to MDEV-32913 Crash when query uses recursive refer... Stalled

 Description   

Run these queries in debug build:

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

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 0x0000555557b2c32d in handler::start_psi_batch_mode (this=0x61b000050228)
at /home/wx/mariadb-11.3.0/sql/handler.cc:3447
#5 0x000055555735ffb5 in sub_select (join=0x62d00011a2a8, join_tab=0x62f00000ae78, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23437
#6 0x000055555735dadd in do_select (join=0x62d00011a2a8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#7 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011a2a8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#8 0x00005555572d93a0 in JOIN::exec (this=0x62d00011a2a8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#9 0x000055555752c2cf in st_select_lex_unit::exec_recursive (this=0x6290000f60a8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#10 0x00005555570d8d53 in TABLE_LIST::fill_recursive (this=0x629000137ca0, thd=0x62c0001d0288)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#11 0x00005555570d986b in mysql_derived_fill (thd=0x62c0001d0288, lex=0x62c0001d45f8, derived=0x629000137ca0)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#12 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001d45f8, derived=0x629000137ca0, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#13 0x000055555732a50c in st_join_table::preread_init (this=0x63100007fb38)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#14 0x000055555735f8c8 in sub_select (join=0x62d00011dfb0, join_tab=0x63100007fb38, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#15 0x000055555735dadd in do_select (join=0x62d00011dfb0, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#16 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011dfb0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#17 0x00005555572d93a0 in JOIN::exec (this=0x62d00011dfb0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#18 0x00005555572ddbab in mysql_select (thd=0x62c0001d0288, tables=0x629000137ca0, fields=..., conds=0x629000168ae8,
og_num=3, order=0x0, group=0x629000167158, having=0x62d000129e88, proc_param=0x0, select_options=2201187781377,
result=0x62d00011deb8, unit=0x62d0001044a8, select_lex=0x629000137410)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
#19 0x00005555570d9bea in mysql_derived_fill (thd=0x62c0001d0288, lex=0x62c0001d45f8, derived=0x62900016bb00)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1266
#20 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001d45f8, derived=0x62900016bb00, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#21 0x000055555732a50c in st_join_table::preread_init (this=0x631000086ac8)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#22 0x000055555735f8c8 in sub_select (join=0x62d00011d6b8, join_tab=0x631000086ac8, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#23 0x000055555735dadd in do_select (join=0x62d00011d6b8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#24 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011d6b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#25 0x00005555572d93a0 in JOIN::exec (this=0x62d00011d6b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#26 0x0000555557dce72f in subselect_single_select_engine::exec (this=0x62d000105730)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4159
#27 0x0000555557da9c85 in Item_subselect::exec (this=0x62d000105528)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#28 0x0000555557dab291 in Item_in_subselect::exec (this=0x62d000105528)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:994
#29 0x0000555557db650f in Item_in_subselect::val_bool (this=0x62d000105528)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1991
#30 0x0000555556e14cd4 in Item::val_bool_result (this=0x62d000105528) at /home/wx/mariadb-11.3.0/sql/item.h:1797
#31 0x0000555557bf3f02 in Item_in_optimizer::val_int (this=0x62d00012a310)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1664
#32 0x0000555556e14b78 in Item::val_int_result (this=0x62d00012a310) at /home/wx/mariadb-11.3.0/sql/item.h:1793
#33 0x0000555557bc30d8 in Item_cache_int::cache_value (this=0x631000088720)
at /home/wx/mariadb-11.3.0/sql/item.cc:10161
#34 0x0000555557bdad9f in Item_cache_wrapper::cache (this=0x631000088670) at /home/wx/mariadb-11.3.0/sql/item.cc:8915
#35 0x0000555557bb7dac in Item_cache_wrapper::save_val (this=0x631000088670, to=0x61a0001f9928)
at /home/wx/mariadb-11.3.0/sql/item.cc:8941
#36 0x0000555557bd1043 in Item_cache_wrapper::save_in_result_field (this=0x631000088670)
at /home/wx/mariadb-11.3.0/sql/item.h:5958
#37 0x00005555573879d1 in copy_funcs (func_ptr=0x62000003cb78, thd=0x62c0001d0288)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:28843
#38 0x000055555736c428 in end_write (join=0x62d00011c1c8, join_tab=0x62f000023e90, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24979
#39 0x00005555573a1a77 in AGGR_OP::put_record (this=0x63100008cb18, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32254
#40 0x00005555573b632d in AGGR_OP::put_record (this=0x63100008cb18) at /home/wx/mariadb-11.3.0/sql/sql_select.h:1180
#41 0x000055555735ec6a in sub_select_postjoin_aggr (join=0x62d00011c1c8, join_tab=0x62f000023e90,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23134
#42 0x000055555736194d in evaluate_join_record (join=0x62d00011c1c8, join_tab=0x62f000023a18, error=0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#43 0x00005555573601c2 in sub_select (join=0x62d00011c1c8, join_tab=0x62f000023a18, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
#44 0x000055555735dadd in do_select (join=0x62d00011c1c8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#45 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011c1c8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#46 0x00005555572d93a0 in JOIN::exec (this=0x62d00011c1c8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#47 0x00005555572ddbab in mysql_select (thd=0x62c0001d0288, tables=0x6290000f8a08, fields=..., conds=0x0, og_num=1,
order=0x62d000105798, group=0x0, having=0x0, proc_param=0x0, select_options=2199023255552,
result=0x62d000105998, unit=0x6290000f89c0, select_lex=0x629000136820)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
#48 0x000055555752ae77 in st_select_lex_unit::exec_inner (this=0x6290000f89c0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2480
#49 0x0000555557528545 in st_select_lex_unit::exec (this=0x6290000f89c0)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#50 0x0000555557dcefe5 in subselect_union_engine::exec (this=0x62d0001059d0)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4187
#51 0x0000555557da9c85 in Item_subselect::exec (this=0x62d000105830)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
#52 0x0000555557daf7a1 in Item_singlerow_subselect::val_real (this=0x62d000105830)
at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1441
#53 0x0000555557c783a0 in Item_func_div::real_op (this=0x62d000105a10)
at /home/wx/mariadb-11.3.0/sql/item_func.cc:1503
#54 0x00005555578e4952 in Item_func_hybrid_field_type::val_real_from_real_op (this=0x62d000105a10)
at /home/wx/mariadb-11.3.0/sql/item_func.h:854
#55 0x00005555578b7ed0 in Type_handler_real_result::Item_func_hybrid_field_type_val_real (
this=0x55555b7b6c00 <type_handler_double>, item=0x62d000105a10) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:5457
#56 0x0000555557181299 in Item_func_hybrid_field_type::val_real (this=0x62d000105a10)
at /home/wx/mariadb-11.3.0/sql/item_func.h:900
#57 0x0000555556e14b0c in Item::val_result (this=0x62d000105a10) at /home/wx/mariadb-11.3.0/sql/item.h:1792
#58 0x0000555557bc5850 in Item_cache_real::cache_value (this=0x62f000007d58)
at /home/wx/mariadb-11.3.0/sql/item.cc:10388
#59 0x0000555557bf3310 in Item_in_optimizer::val_int (this=0x62f000007c80)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1577
#60 0x00005555578b4b6e in Type_handler_int_result::Item_val_bool (this=0x55555b7b68c0 <type_handler_bool>,
item=0x62f000007c80) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:5082
#61 0x0000555556e147f6 in Item::val_bool (this=0x62f000007c80) at /home/wx/mariadb-11.3.0/sql/item.h:1701
#62 0x0000555557c1797a in Item_cond_and::val_int (this=0x62d00010bf30)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:5524
#63 0x0000555557beca8a in Arg_comparator::compare_int_signed (this=0x62d00010e560)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:947
#64 0x0000555557c2e1d4 in Arg_comparator::compare (this=0x62d00010e560)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.h:104
#65 0x0000555557bf5bdb in Item_func_eq::val_int (this=0x62d00010e4a8)
at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1780
#66 0x0000555557ba521f in Item::save_int_in_field (this=0x62d00010e4a8, field=0x61a0001f7b28, no_conversions=true)
at /home/wx/mariadb-11.3.0/sql/item.cc:6843
#67 0x00005555578b2242 in Type_handler_int_result::Item_save_in_field (this=0x55555b7b68c0 <type_handler_bool>,
item=0x62d00010e4a8, field=0x61a0001f7b28, no_conversions=true) at /home/wx/mariadb-11.3.0/sql/sql_type.cc:4341
#68 0x0000555557ba540b in Item::save_in_field (this=0x62d00010e4a8, field=0x61a0001f7b28, no_conversions=true)
at /home/wx/mariadb-11.3.0/sql/item.cc:6853
#69 0x0000555556ea7174 in Item_result_field::save_in_result_field (this=0x62d00010e4a8, no_conversions=true)
at /home/wx/mariadb-11.3.0/sql/item.h:3490
#70 0x00005555573879d1 in copy_funcs (func_ptr=0x620000039b78, thd=0x62c0001d0288)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:28843
#71 0x000055555736c428 in end_write (join=0x62d00011a2a8, join_tab=0x62f00000b2f0, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24979
#72 0x00005555573a1a77 in AGGR_OP::put_record (this=0x62f00001a428, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:32254
#73 0x00005555573b632d in AGGR_OP::put_record (this=0x62f00001a428) at /home/wx/mariadb-11.3.0/sql/sql_select.h:1180
#74 0x000055555735ec6a in sub_select_postjoin_aggr (join=0x62d00011a2a8, join_tab=0x62f00000b2f0,
end_of_records=false) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23134
#75 0x000055555736194d in evaluate_join_record (join=0x62d00011a2a8, join_tab=0x62f00000ae78, error=0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
#76 0x00005555573601c2 in sub_select (join=0x62d00011a2a8, join_tab=0x62f00000ae78, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
#77 0x000055555735dadd in do_select (join=0x62d00011a2a8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#78 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d00011a2a8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#79 0x00005555572d93a0 in JOIN::exec (this=0x62d00011a2a8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#80 0x000055555752c2cf in st_select_lex_unit::exec_recursive (this=0x6290000f60a8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2618
#81 0x00005555570d8d53 in TABLE_LIST::fill_recursive (this=0x62d000110b50, thd=0x62c0001d0288)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1155
#82 0x00005555570d986b in mysql_derived_fill (thd=0x62c0001d0288, lex=0x62c0001d45f8, derived=0x62d000110b50)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1250
#83 0x00005555570d27b6 in mysql_handle_single_derived (lex=0x62c0001d45f8, derived=0x62d000110b50, phases=96)
at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
#84 0x000055555732a50c in st_join_table::preread_init (this=0x62f000020578)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
#85 0x000055555735f8c8 in sub_select (join=0x62d0001190b8, join_tab=0x62f000020578, end_of_records=false)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
#86 0x000055555735dadd in do_select (join=0x62d0001190b8, procedure=0x0)
at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
#87 0x00005555572dbfe9 in JOIN::exec_inner (this=0x62d0001190b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
#88 0x00005555572d93a0 in JOIN::exec (this=0x62d0001190b8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
#89 0x0000555557529ad1 in st_select_lex_unit::exec_inner (this=0x62c0001d46d8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2389
#90 0x0000555557528545 in st_select_lex_unit::exec (this=0x62c0001d46d8)
at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2292
#91 0x0000555557514186 in mysql_union (thd=0x62c0001d0288, lex=0x62c0001d45f8, result=0x62d000115e38,
unit=0x62c0001d46d8, setup_tables_done_option=0) at /home/wx/mariadb-11.3.0/sql/sql_union.cc:45
#92 0x00005555572acea8 in handle_select (thd=0x62c0001d0288, lex=0x62c0001d45f8, result=0x62d000115e38,
setup_tables_done_option=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:618
#93 0x00005555571ce583 in execute_sqlcom_select (thd=0x62c0001d0288, all_tables=0x6290000f70c0)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:6013
#94 0x00005555571becf6 in mysql_execute_command (thd=0x62c0001d0288, is_called_from_prepared_stmt=false)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:3912
#95 0x00005555571d95e2 in mysql_parse (thd=0x62c0001d0288,
rawbuf=0x6290000f52a8 "WITH RECURSIVE x ( x ) AS ( SELECT 'x' EXCEPT SELECT x + 1 FROM x GROUP BY - 'x' >= x IS NOT NULL = ( x = 1 AND x * 1 / ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN ( SELECT x FROM ( SELECT DIS"...,
length=882, parser_state=0x7fffd163c870) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
#96 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001d0288,
packet=0x6290000eb289 "WITH RECURSIVE x ( x ) AS ( SELECT 'x' EXCEPT SELECT x + 1 FROM x GROUP BY - 'x' >= x IS NOT NULL = ( x = 1 AND x * 1 / ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN ( SELECT x FROM ( SELECT DIS"...,
packet_length=882, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
#97 0x00005555571adf7c in do_command (thd=0x62c0001d0288, blocking=true)
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
#98 0x000055555768e557 in do_handle_one_connection (connect=0x61100006f608, put_in_cache=true)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
#99 0x000055555768deb4 in handle_one_connection (arg=0x61100006f608)
at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
#100 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000005108)
at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
#101 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
#102 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6

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

Thanks! I repeated as described on 10.4-11.3:
10.4:

mysqld: /10.4/src/sql/item.cc:10608: virtual my_decimal* Item_type_holder::val_decimal(my_decimal*): Assertion `0' failed.
 
231108 11:23:44 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: e5a5573f782723e40c372f38346a60b1ccc644d6
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f8f6c4bc729]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f8f6c4cdfd6]
 
sql/item.cc:10609(Item_type_holder::val_decimal(my_decimal*))[0x55d0fda4972d]
 
sql/item.h:1560(Item::val_decimal_result(my_decimal*))[0x55d0fcf1b1ad]
 
sql/item.cc:10320(Item_cache_decimal::cache_value())[0x55d0fda46555]
 
sql/item.h:6953(Item_cache::has_value())[0x55d0fd793944]
 
sql/item.cc:10329(Item_cache_decimal::val_real())[0x55d0fda466bc]
 
sql/item_subselect.cc:1378(Item_singlerow_subselect::val_real())[0x55d0fdbd762e]
 
sql/item_func.cc:1446(Item_func_div::real_op())[0x55d0fdb050ec]
 
sql/item_func.h:754(Item_func_hybrid_field_type::val_real_from_real_op())[0x55d0fd78c8cc]
 
sql/sql_type.cc:5014(Type_handler_real_result::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x55d0fd76170e]
 
sql/item_func.h:800(Item_func_hybrid_field_type::val_real())[0x55d0fd1a0495]
 
sql/item.h:1556(Item::val_result())[0x55d0fcf1b052]
 
sql/item.cc:10253(Item_cache_real::cache_value())[0x55d0fda4598f]
 
sql/item_cmpfunc.cc:1587(Item_in_optimizer::val_int())[0x55d0fda751c1]
 
sql/sql_type.cc:4638(Type_handler_int_result::Item_val_bool(Item*) const)[0x55d0fd75e3d4]
 
sql/item.h:1474(Item::val_bool())[0x55d0fcf1ad52]
 
sql/item_cmpfunc.cc:5359(Item_cond_and::val_int())[0x55d0fda9a1d0]
 
sql/item_cmpfunc.cc:953(Arg_comparator::compare_int_signed())[0x55d0fda6e1b6]
 
sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x55d0fdaafdf8]
 
sql/item_cmpfunc.cc:1790(Item_func_eq::val_int())[0x55d0fda77baf]
 
sql/item.cc:6718(Item::save_int_in_field(Field*, bool))[0x55d0fda24165]
 
sql/sql_type.cc:3847(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x55d0fd75b794]
 
sql/item.cc:6728(Item::save_in_field(Field*, bool))[0x55d0fda24349]
 
sql/item.h:3284(Item_result_field::save_in_result_field(bool))[0x55d0fd072669]
 
sql/sql_select.cc:26211(copy_funcs(Item**, THD const*))[0x55d0fd34ed3b]
 
sql/sql_select.cc:22374(end_write(JOIN*, st_join_table*, bool))[0x55d0fd332d16]
 
sql/sql_select.cc:29651(AGGR_OP::put_record(bool))[0x55d0fd36940f]
 
sql/sql_select.h:1085(AGGR_OP::put_record())[0x55d0fd378edd]
 
sql/sql_select.cc:20627(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55d0fd325ef1]
 
sql/sql_select.cc:21149(evaluate_join_record(JOIN*, st_join_table*, int))[0x55d0fd328879]
 
sql/sql_select.cc:20922(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd3271ae]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x55d0fd4acf47]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x55d0fd1071c4]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55d0fd107cce]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55d0fd100b1a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55d0fd2f5c87]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd326b23]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
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*))[0x55d0fd2b42a8]
 
sql/sql_derived.cc:1265(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55d0fd1080a5]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55d0fd100b1a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55d0fd2f5c87]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd326b23]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
sql/item_subselect.cc:4035(subselect_single_select_engine::exec())[0x55d0fdbf6b7c]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55d0fdbd1be4]
 
sql/item_subselect.cc:938(Item_in_subselect::exec())[0x55d0fdbd31e8]
 
sql/item_subselect.cc:1886(Item_in_subselect::val_bool())[0x55d0fdbde7c3]
 
sql/item.h:1561(Item::val_bool_result())[0x55d0fcf1b21a]
 
sql/item_cmpfunc.cc:1673(Item_in_optimizer::val_int())[0x55d0fda75d24]
 
sql/item.h:1557(Item::val_int_result())[0x55d0fcf1b0be]
 
sql/item.cc:10023(Item_cache_int::cache_value())[0x55d0fda43167]
 
sql/item.cc:8782(Item_cache_wrapper::cache())[0x55d0fda5bd32]
 
sql/item.cc:8808(Item_cache_wrapper::save_val(Field*))[0x55d0fda37aa7]
 
sql/item.h:5765(Item_cache_wrapper::save_in_result_field(bool))[0x55d0fda51b70]
 
sql/sql_select.cc:26211(copy_funcs(Item**, THD const*))[0x55d0fd34ed3b]
 
sql/sql_select.cc:22374(end_write(JOIN*, st_join_table*, bool))[0x55d0fd332d16]
 
sql/sql_select.cc:29651(AGGR_OP::put_record(bool))[0x55d0fd36940f]
 
sql/sql_select.h:1085(AGGR_OP::put_record())[0x55d0fd378edd]
 
sql/sql_select.cc:20627(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55d0fd325ef1]
 
sql/sql_select.cc:21149(evaluate_join_record(JOIN*, st_join_table*, int))[0x55d0fd328879]
 
sql/sql_select.cc:20922(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd3271ae]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
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*))[0x55d0fd2b42a8]
 
sql/sql_union.cc:1729(st_select_lex_unit::exec())[0x55d0fd4ab964]
 
sql/item_subselect.cc:4060(subselect_union_engine::exec())[0x55d0fdbf74df]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55d0fdbd1be4]
 
sql/item_subselect.cc:1379(Item_singlerow_subselect::val_real())[0x55d0fdbd7693]
 
sql/item_func.cc:1446(Item_func_div::real_op())[0x55d0fdb050ec]
 
sql/item_func.h:754(Item_func_hybrid_field_type::val_real_from_real_op())[0x55d0fd78c8cc]
 
sql/sql_type.cc:5014(Type_handler_real_result::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x55d0fd76170e]
 
sql/item_func.h:800(Item_func_hybrid_field_type::val_real())[0x55d0fd1a0495]
 
sql/item.h:1556(Item::val_result())[0x55d0fcf1b052]
 
sql/item.cc:10253(Item_cache_real::cache_value())[0x55d0fda4598f]
 
sql/item_cmpfunc.cc:1587(Item_in_optimizer::val_int())[0x55d0fda751c1]
 
sql/sql_type.cc:4638(Type_handler_int_result::Item_val_bool(Item*) const)[0x55d0fd75e3d4]
 
sql/item.h:1474(Item::val_bool())[0x55d0fcf1ad52]
 
sql/item_cmpfunc.cc:5359(Item_cond_and::val_int())[0x55d0fda9a1d0]
 
sql/item_cmpfunc.cc:953(Arg_comparator::compare_int_signed())[0x55d0fda6e1b6]
 
sql/item_cmpfunc.h:104(Arg_comparator::compare())[0x55d0fdaafdf8]
 
sql/item_cmpfunc.cc:1790(Item_func_eq::val_int())[0x55d0fda77baf]
 
sql/item.cc:6718(Item::save_int_in_field(Field*, bool))[0x55d0fda24165]
 
sql/sql_type.cc:3847(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x55d0fd75b794]
 
sql/item.cc:6728(Item::save_in_field(Field*, bool))[0x55d0fda24349]
 
sql/item.h:3284(Item_result_field::save_in_result_field(bool))[0x55d0fd072669]
 
sql/sql_select.cc:26211(copy_funcs(Item**, THD const*))[0x55d0fd34ed3b]
 
sql/sql_select.cc:22374(end_write(JOIN*, st_join_table*, bool))[0x55d0fd332d16]
 
sql/sql_select.cc:29651(AGGR_OP::put_record(bool))[0x55d0fd36940f]
 
sql/sql_select.h:1085(AGGR_OP::put_record())[0x55d0fd378edd]
 
sql/sql_select.cc:20627(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x55d0fd325ef1]
 
sql/sql_select.cc:21149(evaluate_join_record(JOIN*, st_join_table*, int))[0x55d0fd328879]
 
sql/sql_select.cc:20922(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd3271ae]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
sql/sql_union.cc:1872(st_select_lex_unit::exec_recursive())[0x55d0fd4acf47]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x55d0fd1071c4]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x55d0fd107cce]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x55d0fd100b1a]
 
sql/sql_select.cc:13885(st_join_table::preread_init())[0x55d0fd2f5c87]
 
sql/sql_select.cc:20884(sub_select(JOIN*, st_join_table*, bool))[0x55d0fd326b23]
 
sql/sql_select.cc:20443(do_select(JOIN*, Procedure*))[0x55d0fd324f54]
 
sql/sql_select.cc:4625(JOIN::exec_inner())[0x55d0fd2b2a9c]
 
sql/sql_select.cc:4408(JOIN::exec())[0x55d0fd2b00cc]
 
sql/sql_union.cc:1603(st_select_lex_unit::exec())[0x55d0fd4aa0e6]
 
sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x55d0fd4997ec]
 
sql/sql_select.cc:432(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55d0fd2847e7]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55d0fd1f0886]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x55d0fd1ddffd]
 
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55d0fd1f9dc5]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55d0fd1d0187]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55d0fd1cccb2]
 
 
 
Query (0x62b0000a1290): WITH RECURSIVE x ( x ) AS ( SELECT 'x' EXCEPT SELECT x + 1 FROM x GROUP BY - 'x' >= x IS NOT NULL = ( x = 1 AND x * 1 / ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN ( SELECT x FROM ( SELECT DISTINCT - x , x FROM x WHERE x = ( SELECT CASE WHEN x = 1 THEN 'x' ELSE x END FROM x WHERE ( SELECT x IN ( SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x WHERE x IS NULL AND x IN ( 1.000000 , 1 ) ) FROM x WHERE x != 'x' ) NOT BETWEEN ( SELECT x AS x FROM x AS x GROUP BY x HAVING x ) AND 1 ) GROUP BY 1 , 'x' , NULL HAVING EXISTS ( WITH RECURSIVE x AS ( SELECT 1 ) SELECT * FROM x WHERE x = x ) ) AS x ) ) IN ( WITH x ( x ) AS ( SELECT 1 EXCEPT SELECT 1.000000 + 1 FROM x ) SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x ) AND 1 + 1 ) ) SELECT 1 EXCEPT SELECT 1.000000 EXCEPT SELECT x + 1 FROM x WHERE x LIKE ( x BETWEEN 1 AND 1 ) GROUP BY x HAVING x > 'x'

10.5-11.2:

mariadbd: /10.5/src/sql/handler.cc:2985: void handler::start_psi_batch_mode(): Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed.
 
231108 11:24:30 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.5.23-MariaDB-debug-log source revision: b06ac9a8cd2146e89270cc2150d306d8ed1b33fb
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7fb2bf339729]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fb2bf34afd6]
 
sql/handler.cc:2986(handler::start_psi_batch_mode())[0x56379b5349b7]
 
sql/sql_select.cc:21172(sub_select(JOIN*, st_join_table*, bool))[0x56379ae423e5]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/sql_union.cc:2516(st_select_lex_unit::exec_recursive())[0x56379affc36d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x56379ac0e804]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x56379ac0f30e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x56379ac0815b]
 
sql/sql_select.cc:13965(st_join_table::preread_init())[0x56379ae0e62d]
 
sql/sql_select.cc:21137(sub_select(JOIN*, st_join_table*, bool))[0x56379ae41f35]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/sql_select.cc:4861(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*))[0x56379adcc409]
 
sql/sql_derived.cc:1265(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x56379ac0f68d]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x56379ac0815b]
 
sql/sql_select.cc:13965(st_join_table::preread_init())[0x56379ae0e62d]
 
sql/sql_select.cc:21137(sub_select(JOIN*, st_join_table*, bool))[0x56379ae41f35]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/item_subselect.cc:4059(subselect_single_select_engine::exec())[0x56379b788224]
 
sql/item_subselect.cc:794(Item_subselect::exec())[0x56379b762b2a]
 
sql/item_subselect.cc:974(Item_in_subselect::exec())[0x56379b764142]
 
sql/item_subselect.cc:1904(Item_in_subselect::val_bool())[0x56379b76f69d]
 
sql/item.h:1583(Item::val_bool_result())[0x56379aa1927c]
 
sql/item_cmpfunc.cc:1679(Item_in_optimizer::val_int())[0x56379b60049e]
 
sql/item.h:1579(Item::val_int_result())[0x56379aa19120]
 
sql/item.cc:10066(Item_cache_int::cache_value())[0x56379b5cd5a7]
 
sql/item.cc:8828(Item_cache_wrapper::cache())[0x56379b5e5e88]
 
sql/item.cc:8854(Item_cache_wrapper::save_val(Field*))[0x56379b5c1ed7]
 
sql/item.h:5732(Item_cache_wrapper::save_in_result_field(bool))[0x56379b5dbd88]
 
sql/sql_select.cc:26468(copy_funcs(Item**, THD const*))[0x56379ae6a067]
 
sql/sql_select.cc:22648(end_write(JOIN*, st_join_table*, bool))[0x56379ae4e21e]
 
sql/sql_select.cc:29871(AGGR_OP::put_record(bool))[0x56379ae83ecf]
 
sql/sql_select.h:1086(AGGR_OP::put_record())[0x56379ae9657d]
 
sql/sql_select.cc:20880(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x56379ae41303]
 
sql/sql_select.cc:21407(evaluate_join_record(JOIN*, st_join_table*, int))[0x56379ae43d2d]
 
sql/sql_select.cc:21177(sub_select(JOIN*, st_join_table*, bool))[0x56379ae425f2]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/sql_select.cc:4861(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*))[0x56379adcc409]
 
sql/sql_union.cc:2376(st_select_lex_unit::exec())[0x56379affad81]
 
sql/item_subselect.cc:4084(subselect_union_engine::exec())[0x56379b788b87]
 
sql/item_subselect.cc:794(Item_subselect::exec())[0x56379b762b2a]
 
sql/item_subselect.cc:1397(Item_singlerow_subselect::val_real())[0x56379b7684d7]
 
sql/item_func.cc:1457(Item_func_div::real_op())[0x56379b68710c]
 
sql/item_func.h:874(Item_func_hybrid_field_type::val_real_from_real_op())[0x56379b303560]
 
sql/sql_type.cc:5458(Type_handler_real_result::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x56379b2d5f24]
 
sql/item_func.h:920(Item_func_hybrid_field_type::val_real())[0x56379acb3269]
 
sql/item.h:1578(Item::val_result())[0x56379aa190b4]
 
sql/item.cc:10293(Item_cache_real::cache_value())[0x56379b5cfdef]
 
sql/item_cmpfunc.cc:1593(Item_in_optimizer::val_int())[0x56379b5ff7d1]
 
sql/sql_type.cc:5082(Type_handler_int_result::Item_val_bool(Item*) const)[0x56379b2d2bda]
 
sql/item.h:1498(Item::val_bool())[0x56379aa18dce]
 
sql/item_cmpfunc.cc:5534(Item_cond_and::val_int())[0x56379b62546c]
 
sql/item_cmpfunc.cc:955(Arg_comparator::compare_int_signed())[0x56379b5f8434]
 
sql/item_cmpfunc.h:102(Arg_comparator::compare())[0x56379b63cb14]
 
sql/item_cmpfunc.cc:1795(Item_func_eq::val_int())[0x56379b60240b]
 
sql/item.cc:6766(Item::save_int_in_field(Field*, bool))[0x56379b5ae47d]
 
sql/sql_type.cc:4352(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x56379b2d036a]
 
sql/item.cc:6776(Item::save_in_field(Field*, bool))[0x56379b5ae663]
 
sql/item.h:3302(Item_result_field::save_in_result_field(bool))[0x56379ab78157]
 
sql/sql_select.cc:26468(copy_funcs(Item**, THD const*))[0x56379ae6a067]
 
sql/sql_select.cc:22648(end_write(JOIN*, st_join_table*, bool))[0x56379ae4e21e]
 
sql/sql_select.cc:29871(AGGR_OP::put_record(bool))[0x56379ae83ecf]
 
sql/sql_select.h:1086(AGGR_OP::put_record())[0x56379ae9657d]
 
sql/sql_select.cc:20880(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x56379ae41303]
 
sql/sql_select.cc:21407(evaluate_join_record(JOIN*, st_join_table*, int))[0x56379ae43d2d]
 
sql/sql_select.cc:21177(sub_select(JOIN*, st_join_table*, bool))[0x56379ae425f2]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/sql_union.cc:2516(st_select_lex_unit::exec_recursive())[0x56379affc36d]
 
sql/sql_derived.cc:1154(TABLE_LIST::fill_recursive(THD*))[0x56379ac0e804]
 
sql/sql_derived.cc:1249(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x56379ac0f30e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x56379ac0815b]
 
sql/sql_select.cc:13965(st_join_table::preread_init())[0x56379ae0e62d]
 
sql/sql_select.cc:21137(sub_select(JOIN*, st_join_table*, bool))[0x56379ae41f35]
 
sql/sql_select.cc:20696(do_select(JOIN*, Procedure*))[0x56379ae40366]
 
sql/sql_select.cc:4602(JOIN::exec_inner())[0x56379adca9ba]
 
sql/sql_select.cc:4383(JOIN::exec())[0x56379adc7fc4]
 
sql/sql_union.cc:2252(st_select_lex_unit::exec())[0x56379aff9551]
 
sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x56379afe3f36]
 
sql/sql_select.cc:440(handle_select(THD*, LEX*, select_result*, unsigned long))[0x56379ad9cdd9]
 
sql/sql_parse.cc:6343(execute_sqlcom_select(THD*, TABLE_LIST*))[0x56379ad0264d]
 
sql/sql_parse.cc:4020(mysql_execute_command(THD*))[0x56379acf13b2]
 
sql/sql_parse.cc:8120(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x56379ad0d9bf]
 
sql/sql_parse.cc:1894(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x56379ace33ed]
 
sql/sql_parse.cc:1375(do_command(THD*))[0x56379acdfd55]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x56379b13e9a3]
 
sql/sql_connect.cc:1320(handle_one_connection)[0x56379b13e307]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x56379bdcab02]
 
nptl/pthread_create.c:478(start_thread)[0x7fb2bf865609]
 
 
Query (0x62b0000852a8): WITH RECURSIVE x ( x ) AS ( SELECT 'x' EXCEPT SELECT x + 1 FROM x GROUP BY - 'x' >= x IS NOT NULL = ( x = 1 AND x * 1 / ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN ( SELECT x FROM ( SELECT DISTINCT - x , x FROM x WHERE x = ( SELECT CASE WHEN x = 1 THEN 'x' ELSE x END FROM x WHERE ( SELECT x IN ( SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x WHERE x IS NULL AND x IN ( 1.000000 , 1 ) ) FROM x WHERE x != 'x' ) NOT BETWEEN ( SELECT x AS x FROM x AS x GROUP BY x HAVING x ) AND 1 ) GROUP BY 1 , 'x' , NULL HAVING EXISTS ( WITH RECURSIVE x AS ( SELECT 1 ) SELECT * FROM x WHERE x = x ) ) AS x ) ) IN ( WITH x ( x ) AS ( SELECT 1 EXCEPT SELECT 1.000000 + 1 FROM x ) SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x ) AND 1 + 1 ) ) SELECT 1 EXCEPT SELECT 1.000000 EXCEPT SELECT x + 1 FROM x WHERE x LIKE ( x BETWEEN 1 AND 1 ) GROUP BY x HAVING x > 'x'

Comment by Alice Sherepa [ 2023-12-11 ]

Currently repeatable on 10.6-11.3 

mariadbd: /10.6/src/sql/handler.cc:3324: void handler::start_psi_batch_mode(): Assertion `m_psi_batch_mode == PSI_BATCH_MODE_NONE' failed.
 
231211 11:43:12 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.6.17-MariaDB-debug-log source revision: 47f2b16a8cd6d3e50c49be4b868ac7dff9fefc88
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f2be706cfd6]
 
sql/handler.cc:3325(handler::start_psi_batch_mode())[0x558bb80d8be7]
 
sql/sql_select.cc:21824(sub_select(JOIN*, st_join_table*, bool))[0x558bb798348d]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/sql_union.cc:2514(st_select_lex_unit::exec_recursive())[0x558bb7b3d41b]
 
sql/sql_derived.cc:1170(TABLE_LIST::fill_recursive(THD*))[0x558bb774498c]
 
sql/sql_derived.cc:1265(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x558bb774546e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x558bb773e15e]
 
sql/sql_select.cc:14639(st_join_table::preread_init())[0x558bb794fa25]
 
sql/sql_select.cc:21787(sub_select(JOIN*, st_join_table*, bool))[0x558bb7982f8c]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/sql_select.cc:5141(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*))[0x558bb790b70f]
 
sql/sql_derived.cc:1281(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x558bb77457ed]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x558bb773e15e]
 
sql/sql_select.cc:14639(st_join_table::preread_init())[0x558bb794fa25]
 
sql/sql_select.cc:21787(sub_select(JOIN*, st_join_table*, bool))[0x558bb7982f8c]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/item_subselect.cc:4109(subselect_single_select_engine::exec())[0x558bb8324bea]
 
sql/item_subselect.cc:811(Item_subselect::exec())[0x558bb830066f]
 
sql/item_subselect.cc:993(Item_in_subselect::exec())[0x558bb8301c67]
 
sql/item_subselect.cc:1959(Item_in_subselect::val_bool())[0x558bb830cc6f]
 
sql/item.h:1783(Item::val_bool_result())[0x558bb754f0b0]
 
sql/item_cmpfunc.cc:1718(Item_in_optimizer::val_int())[0x558bb819fae0]
 
sql/item.h:1779(Item::val_int_result())[0x558bb754ef54]
 
sql/item.cc:10131(Item_cache_int::cache_value())[0x558bb816d9a4]
 
sql/item.cc:8888(Item_cache_wrapper::cache())[0x558bb8185f97]
 
sql/item.cc:8914(Item_cache_wrapper::save_val(Field*))[0x558bb81626d1]
 
sql/item.h:5939(Item_cache_wrapper::save_in_result_field(bool))[0x558bb817c223]
 
sql/sql_select.cc:27259(copy_funcs(Item**, THD const*))[0x558bb79ab533]
 
sql/sql_select.cc:23377(end_write(JOIN*, st_join_table*, bool))[0x558bb798f75c]
 
sql/sql_select.cc:30694(AGGR_OP::put_record(bool))[0x558bb79c584d]
 
sql/sql_select.h:1096(AGGR_OP::put_record())[0x558bb79dad6f]
 
sql/sql_select.cc:21523(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x558bb79822b7]
 
sql/sql_select.cc:22059(evaluate_join_record(JOIN*, st_join_table*, int))[0x558bb7984dd5]
 
sql/sql_select.cc:21829(sub_select(JOIN*, st_join_table*, bool))[0x558bb798369a]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/sql_select.cc:5141(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*))[0x558bb790b70f]
 
sql/sql_union.cc:2374(st_select_lex_unit::exec())[0x558bb7b3be06]
 
sql/item_subselect.cc:4134(subselect_union_engine::exec())[0x558bb832554d]
 
sql/item_subselect.cc:811(Item_subselect::exec())[0x558bb830066f]
 
sql/item_subselect.cc:1452(Item_singlerow_subselect::val_real())[0x558bb830625d]
 
sql/item_func.cc:1450(Item_func_div::real_op())[0x558bb82270a8]
 
sql/item_func.h:888(Item_func_hybrid_field_type::val_real_from_real_op())[0x558bb7e933f4]
 
sql/sql_type.cc:5493(Type_handler_real_result::Item_func_hybrid_field_type_val_real(Item_func_hybrid_field_type*) const)[0x558bb7e66368]
 
sql/item_func.h:934(Item_func_hybrid_field_type::val_real())[0x558bb77ec04d]
 
sql/item.h:1778(Item::val_result())[0x558bb754eee8]
 
sql/item.cc:10358(Item_cache_real::cache_value())[0x558bb8170106]
 
sql/item_cmpfunc.cc:1632(Item_in_optimizer::val_int())[0x558bb819ee44]
 
sql/sql_type.cc:5117(Type_handler_int_result::Item_val_bool(Item*) const)[0x558bb7e63006]
 
sql/item.h:1688(Item::val_bool())[0x558bb754ebb8]
 
sql/item_cmpfunc.cc:5610(Item_cond_and::val_int())[0x558bb81c393c]
 
sql/item_cmpfunc.cc:996(Arg_comparator::compare_int_signed())[0x558bb81983e6]
 
sql/item_cmpfunc.h:117(Arg_comparator::compare())[0x558bb81da8ec]
 
sql/item_cmpfunc.cc:1834(Item_func_eq::val_int())[0x558bb81a17b9]
 
sql/item.cc:6829(Item::save_int_in_field(Field*, bool))[0x558bb814fe39]
 
sql/sql_type.cc:4350(Type_handler_int_result::Item_save_in_field(Item*, Field*, bool) const)[0x558bb7e60694]
 
sql/item.cc:6839(Item::save_in_field(Field*, bool))[0x558bb8150025]
 
sql/item.h:3456(Item_result_field::save_in_result_field(bool))[0x558bb76acffc]
 
sql/sql_select.cc:27259(copy_funcs(Item**, THD const*))[0x558bb79ab533]
 
sql/sql_select.cc:23377(end_write(JOIN*, st_join_table*, bool))[0x558bb798f75c]
 
sql/sql_select.cc:30694(AGGR_OP::put_record(bool))[0x558bb79c584d]
 
sql/sql_select.h:1096(AGGR_OP::put_record())[0x558bb79dad6f]
 
sql/sql_select.cc:21523(sub_select_postjoin_aggr(JOIN*, st_join_table*, bool))[0x558bb79822b7]
 
sql/sql_select.cc:22059(evaluate_join_record(JOIN*, st_join_table*, int))[0x558bb7984dd5]
 
sql/sql_select.cc:21829(sub_select(JOIN*, st_join_table*, bool))[0x558bb798369a]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/sql_union.cc:2514(st_select_lex_unit::exec_recursive())[0x558bb7b3d41b]
 
sql/sql_derived.cc:1170(TABLE_LIST::fill_recursive(THD*))[0x558bb774498c]
 
sql/sql_derived.cc:1265(mysql_derived_fill(THD*, LEX*, TABLE_LIST*))[0x558bb774546e]
 
sql/sql_derived.cc:200(mysql_handle_single_derived(LEX*, TABLE_LIST*, unsigned int))[0x558bb773e15e]
 
sql/sql_select.cc:14639(st_join_table::preread_init())[0x558bb794fa25]
 
sql/sql_select.cc:21787(sub_select(JOIN*, st_join_table*, bool))[0x558bb7982f8c]
 
sql/sql_select.cc:21352(do_select(JOIN*, Procedure*))[0x558bb79813f0]
 
sql/sql_select.cc:4882(JOIN::exec_inner())[0x558bb7909cbc]
 
sql/sql_select.cc:4661(JOIN::exec())[0x558bb79071bc]
 
sql/sql_union.cc:2250(st_select_lex_unit::exec())[0x558bb7b3a5c5]
 
sql/sql_union.cc:42(mysql_union(THD*, LEX*, select_result*, st_select_lex_unit*, unsigned long))[0x558bb7b24fc8]
 
sql/sql_select.cc:551(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558bb78da793]
 
sql/sql_parse.cc:6285(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558bb783b446]
 
sql/sql_parse.cc:3961(mysql_execute_command(THD*, bool))[0x558bb7829e0f]
 
sql/sql_parse.cc:8051(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x558bb784684f]
 
sql/sql_parse.cc:1898(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x558bb781c4b1]
 
sql/sql_parse.cc:1409(do_command(THD*, bool))[0x558bb78191f2]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x558bb7c9cfd9]
 
sql/sql_connect.cc:1320(handle_one_connection)[0x558bb7c9c936]
 
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x558bb893fcee]
 
nptl/pthread_create.c:478(start_thread)[0x7f2be7587609]
 
 
 
Query (0x62b0000c42a8): WITH RECURSIVE x ( x ) AS ( SELECT 'x' EXCEPT SELECT x + 1 FROM x GROUP BY - 'x' >= x IS NOT NULL = ( x = 1 AND x * 1 / ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN ( SELECT x FROM ( SELECT DISTINCT - x , x FROM x WHERE x = ( SELECT CASE WHEN x = 1 THEN 'x' ELSE x END FROM x WHERE ( SELECT x IN ( SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x WHERE x IS NULL AND x IN ( 1.000000 , 1 ) ) FROM x WHERE x != 'x' ) NOT BETWEEN ( SELECT x AS x FROM x AS x GROUP BY x HAVING x ) AND 1 ) GROUP BY 1 , 'x' , NULL HAVING EXISTS ( WITH RECURSIVE x AS ( SELECT 1 ) SELECT * FROM x WHERE x = x ) ) AS x ) ) IN ( WITH x ( x ) AS ( SELECT 1 EXCEPT SELECT 1.000000 + 1 FROM x ) SELECT x FROM ( SELECT x FROM x UNION SELECT x FROM x ) AS x ) AND 1 + 1 ) ) SELECT 1 EXCEPT SELECT 1.000000 EXCEPT SELECT x + 1 FROM x WHERE x LIKE ( x BETWEEN 1 AND 1 ) GROUP BY x HAVING x > 'x'

10.4 and 10.5 return 4008: Restrictions imposed on recursive definitions are violated for table 'x'
simplification via Wangdada :

CREATE TABLE x ( x BOOLEAN ) ;
 
INSERT INTO x ( x ) VALUES ( 1 ), ( 1 ) , ( 1 ) ;
 
 
WITH RECURSIVE x ( x ) AS 
( SELECT 'x' EXCEPT SELECT x + 1 
    FROM x 
    GROUP BY - 'x' >= x IS NOT NULL = 
        ( SELECT 1 AS x UNION SELECT 1.000000 ORDER BY x IN( 
            SELECT x FROM ( SELECT   x FROM x  ) AS x )  ) 
) 
      
SELECT x + 1 FROM x ;

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