[MDEV-32603] Server crash Created: 2023-10-27  Updated: 2023-12-06

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

Type: Bug Priority: Major
Reporter: csfuzz Assignee: Sergei Petrunia
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-32701 Assertion Failed at /mariadb-11.3.0/s... Closed

 Description    

CREATE TABLE v0 ( v1 INTEGER UNSIGNED NULL ) engine=innodb;
 
INSERT INTO v0 ( v1 ) VALUES ( NULL ) ;
 
INSERT INTO v0 ( v1 ) VALUES ( 53 ) ;
 
INSERT INTO v0 ( v1 ) VALUES ( 0 ) ;
 
SELECT * FROM v0 WHERE v1 = ( SELECT * FROM v0 WHERE v1 >= 1 GROUP BY v1 , v1 HAVING v1 * 1 ORDER BY v1 / 1 ) GROUP BY v1 HAVING v1 + v1 OR v1 = 1 * ( 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + ( SELECT 1 UNION SELECT 1 UNION SELECT 1 ) * 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 IN ( SELECT 1 UNION SELECT 1 UNION SELECT 'x' ) ) ;

Stack Trace:Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x7fbdf3951880 thread_stack 0x5fc00
/usr/local/mysql/bin/mariadbd(__interceptor_backtrace+0x5b)[0x781b5b]
mysys/stacktrace.c:215(my_print_stacktrace)[0x228cfae]
sql/signal_handler.cc:0(handle_fatal_signal)[0x12bd0d2]
sigaction.c:0(__restore_rt)[0x7fbe176ec420]
sql/item_subselect.cc:1297(Item_singlerow_subselect::store(unsigned int, Item*))[0x1595719]
sql/sql_list.h:441(base_list_iterator::next_fast())[0xa1e3da]
sql/sql_select.cc:24771(end_send(JOIN*, st_join_table*, bool))[0xc3a8aa]
sql/sql_select.cc:23737(evaluate_join_record(JOIN*, st_join_table*, int))[0xca16a3]
/usr/local/mysql/bin/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x661)[0xbe6c51]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN10exec_innerEv+0x2681)[0xc48751]
sql/sql_select.cc:4721(JOIN::exec())[0xc45f19]
sql/sql_select.cc:5251(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*))[0xbe89b8]
/usr/local/mysql/bin/mariadbd(_ZN18st_select_lex_unit10exec_innerEv+0x183e)[0xdfa01e]
sql/item_subselect.cc:4188(subselect_union_engine::exec())[0x15b5c25]
sql/item_subselect.cc:817(Item_subselect::exec())[0x159115c]
sql/item_subselect.cc:1462(Item_singlerow_subselect::val_int())[0x15968a3]
/usr/local/mysql/bin/mariadbd(_ZN13Item_func_mul6int_opEv+0x7a)[0x144369a]
sql/item_func.cc:1130(Item_func_plus::int_op())[0x1441294]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item_func.cc:1126(Item_func_plus::int_op())[0x1441233]
sql/item.cc:10173(Item_cache_int::cache_value())[0x1358ef2]
sql/item_cmpfunc.cc:1483(Item_in_optimizer::invisible_mode())[0x1397082]
sql/item.h:1455(Item::to_longlong_null())[0x1443739]
sql/sql_type.cc:8682(Type_handler_int_result::Item_eq_value(THD*, Type_cmp_attributes const*, Item*, Item*) const)[0x10e7225]
sql/item_cmpfunc.cc:6931(Item_equal::add_const(THD*, Item*))[0x13d1504]
/usr/local/mysql/bin/mariadbd(_Z21check_simple_equalityP3THDRKN12Value_source7ContextEP4ItemS6_P10COND_EQUAL+0xadd)[0xc77f4d]
sql/sql_select.cc:17577(Item_func_eq::check_equality(THD*, COND_EQUAL*, List<Item>*))[0xc79631]
sql/sql_select.cc:17798(Item_func_eq::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0xc7c04f]
sql/sql_select.cc:17761(Item_cond::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0xc7bc86]
sql/opt_subselect.cc:6294(and_new_conditions_to_optimized_cond(THD*, Item*, COND_EQUAL*, List<Item>&, Item::cond_result))[0xfe89d0]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN14optimize_innerEv+0x2bad)[0xc164dd]
/usr/local/mysql/bin/mariadbd(_ZN4JOIN8optimizeEv+0x176)[0xbffb46]
sql/sql_select.cc:5237(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*))[0xbe886f]
sql/sql_select.cc:628(handle_select(THD*, LEX*, select_result*, unsigned long long))[0xbe7e59]
sql/sql_parse.cc:6041(execute_sqlcom_select(THD*, TABLE_LIST*))[0xb41bc6]
/usr/local/mysql/bin/mariadbd(_Z21mysql_execute_commandP3THDb+0x18b7)[0xb319a7]
sql/sql_class.h:2830(THD::enter_stage(PSI_stage_info_v1 const*, char const*, char const*, unsigned int))[0xb24c79]
/usr/local/mysql/bin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0x2cf8)[0xb1e648]
sql/sql_parse.cc:1407(do_command(THD*, bool))[0xb25971]
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0xf0d066]
sql/sql_connect.cc:1322(handle_one_connection)[0xf0caa9]
perfschema/pfs.cc:2203(pfs_spawn_thread)[0x19d710b]
nptl/pthread_create.c:478(start_thread)[0x7fbe176e0609]
addr2line: DWARF error: section .debug_info is larger than its filesize! (0x93ef57 vs 0x530f28)
/lib/x86_64-linux-gnu/libc.so.6(clone+0x43)[0x7fbe173f8133]

 Comments   
Comment by Alice Sherepa [ 2023-10-30 ]

Thanks! I repeated on 10.4-11.2 as described.

231030 18:42:19 [ERROR] mysqld got signal 11 ;
 
 
 
Server version: 11.1.2-MariaDB source revision: 9bc25d98209df6810f7a7d5e7dd3ae677a313ab5
 
 
 
sql/signal_handler.cc:241(handle_fatal_signal)[0x5646c8eb21f7]
 
sigaction.c:0(__restore_rt)[0x7f35540de420]
 
sql/item_subselect.cc:1297(Item_singlerow_subselect::store(unsigned int, Item*))[0x5646c8f84287]
 
sql/sql_list.h:441(base_list_iterator::next_fast())[0x5646c8c0262f]
 
sql/sql_select.cc:24705(end_send(JOIN*, st_join_table*, bool))[0x5646c8cb0d6c]
 
sql/sql_class.h:4442(THD::get_stmt_da())[0x5646c8c9b29b]
 
sql/sql_select.cc:23445(sub_select(JOIN*, st_join_table*, bool))[0x5646c8ca1986]
 
sql/sql_select.cc:22957(JOIN::exec_inner())[0x5646c8cd4fc2]
 
sql/sql_select.cc:4713(JOIN::exec())[0x5646c8cd5323]
 
sql/sql_select.cc:5243(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*))[0x5646c8cd33f6]
 
sql/sql_union.cc:2486(st_select_lex_unit::exec_inner())[0x5646c8d20509]
 
sql/item_subselect.cc:4188(subselect_union_engine::exec())[0x5646c8f8196e]
 
sql/item_subselect.cc:817(Item_subselect::exec())[0x5646c8f811aa]
 
sql/item_subselect.cc:1462(Item_singlerow_subselect::val_int())[0x5646c8f81d5e]
 
sql/item.h:1452(Item::to_longlong_null())[0x5646c8f2628e]
 
sql/item_func.cc:1130(Item_func_plus::int_op())[0x5646c8f25b2e]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item_func.cc:1125(Item_func_plus::int_op())[0x5646c8f25b1a]
 
sql/item.cc:10166(Item_cache_int::cache_value())[0x5646c8ec7627]
 
sql/item_cmpfunc.cc:1580(Item_in_optimizer::val_int())[0x5646c8ef5dcb]
 
sql/item_func.cc:1397(Item_func_mul::int_op())[0x5646c8f262b5]
 
sql/sql_type.cc:8683(Type_handler_int_result::Item_eq_value(THD*, Type_cmp_attributes const*, Item*, Item*) const)[0x5646c8df019f]
 
sql/item_cmpfunc.cc:6861(Item_equal::add_const(THD*, Item*))[0x5646c8efc804]
 
sql/sql_select.cc:17358(check_simple_equality(THD*, Value_source::Context const&, Item*, Item*, COND_EQUAL*))[0x5646c8ca2ac9]
 
sql/sql_select.cc:17517(Item_func_eq::check_equality(THD*, COND_EQUAL*, List<Item>*))[0x5646c8ca347b]
 
sql/sql_select.cc:17733(Item_func_eq::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0x5646c8ca355b]
 
sql/sql_select.cc:17696(Item_cond::build_equal_items(THD*, COND_EQUAL*, bool, COND_EQUAL**))[0x5646c8c958b1]
 
sql/opt_subselect.cc:6294(and_new_conditions_to_optimized_cond(THD*, Item*, COND_EQUAL**, List<Item>&, Item::cond_result*))[0x5646c8db9f70]
 
sql/sql_select.cc:2380(JOIN::optimize_inner())[0x5646c8cd1325]
 
sql/sql_select.cc:1946(JOIN::optimize())[0x5646c8cd32a2]
 
sql/sql_select.cc:5229(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*))[0x5646c8cd33a1]
 
sql/sql_select.cc:640(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x5646c8cd3cc4]
 
sql/sql_parse.cc:6041(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5646c8af55f1]
 
sql/sql_parse.cc:3954(mysql_execute_command(THD*, bool))[0x5646c8c63910]
 
sql/sql_parse.cc:7787(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x5646c8c6591b]
 
sql/sql_parse.cc:1951(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x5646c8c67d58]
 
sql/sql_parse.cc:1407(do_command(THD*, bool))[0x5646c8c69283]
 
sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x5646c8d760c7]
 
sql/sql_connect.cc:1324(handle_one_connection)[0x5646c8d76364]
 
perfschema/pfs.cc:2204(pfs_spawn_thread)[0x5646c9101e5c]
 
nptl/pthread_create.c:478(start_thread)[0x7f35540d2609]
 
 
 
Query (0x7f34e8010c40): SELECT * FROM v0 WHERE v1 = ( SELECT * FROM v0 WHERE v1 >= 1 GROUP BY v1 , v1 HAVING v1 * 1 ORDER BY v1 / 1 ) GROUP BY v1 HAVING v1 + v1 OR v1 = 1 * ( 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + ( SELECT 1 UNION SELECT 1 UNION SELECT 1 ) * 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 + 1 IN ( SELECT 1 UNION SELECT 1 UNION SELECT 'x' ) )

the simpler test below, but this one does not crash on non-debug release:

CREATE TABLE t1 ( a int);
 
INSERT INTO t1 VALUES (53) ;
 
 
 
SELECT * FROM t1 
WHERE a = ( SELECT * FROM t1 ) 
GROUP BY a 
HAVING a =  ( SELECT 1 ) * 1 IN ( SELECT 1 UNION SELECT 1  )  ; 


Version: '10.4.32-MariaDB-debug-log' 
mysqld: /10.4/src/sql/item_func.h:803: virtual longlong Item_func_hybrid_field_type::val_int(): Assertion `fixed' failed.
 
231030 18:39:40 [ERROR] mysqld got signal 6 ;
 
 
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: 11abc2191149a76702ef5d919e2e8940e47e5ef9
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fd43fc71fd6]
 
sql/item_func.h:804(Item_func_hybrid_field_type::val_int())[0x55cc9e346bd5]
 
sql/item.h:1557(Item::val_int_result())[0x55cc9e0c20be]
 
sql/item.cc:10022(Item_cache_int::cache_value())[0x55cc9ebe93f3]
 
sql/item_cmpfunc.cc:1587(Item_in_optimizer::val_int())[0x55cc9ec1b44d]
 
sql/sql_type.cc:8306(Type_handler_int_result::Item_eq_value(THD*, Type_cmp_attributes const*, Item*, Item*) const)[0x55cc9e91a606]
 
sql/item_cmpfunc.cc:6712(Item_equal::add_const(THD*, Item*))[0x55cc9ec4c754]
 
sql/item_cmpfunc.cc:6783(Item_equal::merge(THD*, Item_equal*))[0x55cc9ec4cbad]
 
sql/item_cmpfunc.cc:6832(Item_equal::merge_with_check(THD*, Item_equal*, bool))[0x55cc9ec4cdbc]
 
sql/item_cmpfunc.cc:6885(Item_equal::merge_into_list(THD*, List<Item_equal>*, bool, bool))[0x55cc9ec4d0af]
 
sql/opt_subselect.cc:6007(and_new_conditions_to_optimized_cond(THD*, Item*, COND_EQUAL**, List<Item>&, Item::cond_result*))[0x55cc9e887eb7]
 
sql/sql_select.cc:2143(JOIN::optimize_inner())[0x55cc9e43e038]
 
sql/sql_select.cc:1711(JOIN::optimize())[0x55cc9e439359]
 
sql/sql_select.cc:4812(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*))[0x55cc9e45a343]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55cc9e42b02c]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55cc9e396dcc]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x55cc9e384543]
 
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55cc9e3a030b]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cc9e3766cd]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55cc9e3731f8]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55cc9e78276f]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x55cc9e782013]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55cc9f42de86]
 
nptl/pthread_create.c:478(start_thread)[0x7fd44018c609]
 
 
 
Query (0x62b0000a1290): SELECT * FROM t1 
WHERE a = ( SELECT * FROM t1 ) 
GROUP BY a 
HAVING a =  ( SELECT 1 ) * 1 IN ( SELECT 1 UNION SELECT 1  )

Comment by Alice Sherepa [ 2023-12-06 ]

Please check also the test case from MDEV-32701:

CREATE TABLE x ( x INT ) ;
 
INSERT INTO x ( x ) VALUES ( 1 ) ;
 
UPDATE x SET x = 1 WHERE x = 1 ;
 
INSERT INTO x ( x ) VALUES ( 1 ) , ( 1 ) ;
 
SELECT x , x FROM x GROUP BY x , x HAVING x = ( SELECT x IN ( SELECT x FROM x WHERE x LIKE 'x' ) FROM x GROUP BY x ) + 1 ^ 1 + 1 ^ 1.000000 NOT IN ( SELECT x FROM x WHERE x = 'x' ) ORDER BY x , x ;


mysqld: /10.4/src/sql/item_func.h:803: virtual longlong Item_func_hybrid_field_type::val_int(): Assertion `fixed' failed.
 
231107 18:44:33 [ERROR] mysqld got signal 6 ;
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: e5a5573f782723e40c372f38346a60b1ccc644d6
 
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7fd4ca1f7fd6]
 
sql/item_func.h:804(Item_func_hybrid_field_type::val_int())[0x56141577c58f]
 
sql/item.h:1557(Item::val_int_result())[0x5614154f70be]
 
sql/item.cc:10023(Item_cache_int::cache_value())[0x56141601f167]
 
sql/item_cmpfunc.cc:1587(Item_in_optimizer::val_int())[0x5614160511c1]
 
sql/sql_type.cc:4638(Type_handler_int_result::Item_val_bool(Item*) const)[0x561415d3a3d4]
 
sql/item.h:1474(Item::val_bool())[0x5614154f6d52]
 
sql/item_cmpfunc.cc:200(Item_func_not::val_int())[0x56141603fdfc]
 
sql/sql_type.cc:8305(Type_handler_int_result::Item_eq_value(THD*, Type_cmp_attributes const*, Item*, Item*) const)[0x561415d50912]
 
sql/item_cmpfunc.cc:6712(Item_equal::add_const(THD*, Item*))[0x5614160824c8]
 
sql/item_cmpfunc.cc:6838(Item_equal::merge_with_check(THD*, Item_equal*, bool))[0x561416082b75]
 
sql/sql_select.cc:17513(propagate_new_equalities(THD*, Item*, List<Item_equal>*, COND_EQUAL*, bool*))[0x5614158e7f5b]
 
sql/opt_subselect.cc:6089(and_new_conditions_to_optimized_cond(THD*, Item*, COND_EQUAL**, List<Item>&, Item::cond_result*))[0x561415cbeb70]
 
sql/sql_select.cc:2163(JOIN::optimize_inner())[0x561415873dac]
 
sql/sql_select.cc:1731(JOIN::optimize())[0x56141586f0cd]
 
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*))[0x5614158900b7]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x561415860b1e]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5614157cc886]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x5614157b9ffd]
 
sql/sql_parse.cc:8013(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5614157d5dc5]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5614157ac187]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x5614157a8cb2]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x561415bb85b5]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x561415bb7e59]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x56141685447e]
 
nptl/pthread_create.c:478(start_thread)[0x7fd4ca712609]
 
 
Query (0x62b0000a1290): SELECT x , x FROM x GROUP BY x , x HAVING x = ( SELECT x IN ( SELECT x FROM x WHERE x LIKE 'x' ) FROM x GROUP BY x ) + 1 ^ 1 + 1 ^ 1.000000 NOT IN ( SELECT x FROM x WHERE x = 'x' ) ORDER BY x , x

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