[MDEV-32403] test_if_quick_select: Segv at /mariadb-11.3.0/sql/sql_select.cc:24361 Created: 2023-10-10  Updated: 2023-11-28

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

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

Ubuntu 20.04

Issue Links:
Relates
relates to MDEV-32397 join_read_first, keyread: SEGV at /ma... Confirmed

 Description   

Run these queries in release build:

CREATE TEMPORARY TABLE t0 ( c22 TEXT , c57 BOOL ) ;
INSERT INTO t0 VALUES ( -101 , -87 ) , ( -95 , 59 ) ;
CREATE INDEX i0 ON t0 ( c22 ) ;
INSERT INTO t0 ( c57 ) SELECT 48 AS c48 ;
SELECT t4 . c16 AS c37 FROM ( WITH t1 AS ( SELECT 2743131056066857905 AS c24 , MIN( 3762089500126409270 ) AS c62 ) SELECT c22 = ( SELECT t0 . c22 AS c20 FROM ( SELECT t1 . c62 AS c27 FROM t1 LEFT OUTER JOIN t0 AS t2 ON TRUE HAVING RAND ( ) IS NOT UNKNOWN ) AS t3 JOIN t0 ON t0 . c22 = t3 . c27 EXCEPT SELECT c22 + -94 AS c36 FROM t0 WHERE c57 IN ( SELECT c22 AS c25 FROM t0 ) LIMIT 1 ) AS c16 FROM t0 ) AS t4 JOIN t0 ON t0 . c22 = t0 . c22 ;

Will trigger Segmentation fault.
GDB info:

Thread 17 "mariadbd" received signal SIGSEGV, Segmentation fault.
 
[Switching to Thread 0x7fffd1c17300 (LWP 3039)]
 
0x0000000000cce04f in test_if_quick_select (tab=0x62d000145980) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24361
 
24361	  delete tab->select->quick;
 
(gdb) p tab->select
 
$29 = (SQL_SELECT *) 0x0
 
 
 
 
 
#0  0x0000000000cce04f in test_if_quick_select (tab=0x62d0000e1a50) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24361
 
#1  0x0000000000ccd3ae in join_init_quick_read_record (tab=0x62d0000e1a50) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24337
 
#2  0x0000000000be32cc in sub_select (join=0x6290000c9430, join_tab=0x62d0000e1a50, end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23441
 
#3  0x0000000000c9e284 in evaluate_join_record (join=join@entry=0x6290000c9430, join_tab=<optimized out>, join_tab@entry=0x62d0000e15d8, error=error@entry=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
 
#4  0x0000000000be3396 in sub_select (join=0x6290000c9430, join_tab=0x62d0000e15d8, end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23444
 
#5  0x0000000000c45121 in do_select (join=0x6290000c9430, procedure=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
 
#6  JOIN::exec_inner (this=0x6290000c9430) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
 
#7  0x0000000000c428e9 in JOIN::exec (this=0x6290000c9430) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
 
#8  0x0000000000df0df7 in st_select_lex_unit::exec_inner (this=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_union.cc:2389
 
#9  0x00000000015d8bb5 in subselect_union_engine::exec (this=<optimized out>) at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:4187
 
#10 0x00000000015b3edc in Item_subselect::exec (this=0x6290000c0700) at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:812
 
#11 0x00000000015b9a0c in Item_singlerow_subselect::val_str (this=0x6290000c0700, str=0x6290000c0ae8) at /home/wx/mariadb-11.3.0/sql/item_subselect.cc:1484
 
#12 0x00000000013aa698 in Arg_comparator::compare_string (this=0x6290000c0998) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:773
 
#13 0x00000000013b5ea2 in Arg_comparator::compare (this=<optimized out>) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.h:104
 
#14 Item_func_eq::val_int (this=<optimized out>) at /home/wx/mariadb-11.3.0/sql/item_cmpfunc.cc:1780
 
#15 0x00000000013552b8 in Item::save_int_in_field (this=0x6290000c08e0, field=0x6190001013b8, no_conversions=false) at /home/wx/mariadb-11.3.0/sql/item.cc:6843
 
#16 0x00000000013554a9 in Item::save_in_field (this=0x6290000c08e0, field=0x6190001013b8, no_conversions=false) at /home/wx/mariadb-11.3.0/sql/item.cc:6853
 
#17 0x00000000009d9dc9 in fill_record (thd=<optimized out>, table=<optimized out>, ptr=0x61f000013d98, values=..., ignore_errors=<optimized out>, use_value=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_base.cc:9320
 
#18 0x0000000000de507b in select_unit::send_data (this=0x6290000c5998, values=...) at /home/wx/mariadb-11.3.0/sql/sql_union.cc:122
 
#19 0x0000000000c36f9a in select_result_sink::send_data_with_check (this=0x0, items=..., u=<optimized out>, sent=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_class.h:5842
 
#20 end_send (join=0x6290000c5a90, join_tab=0x6290000cb858, end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:24710
 
#21 0x0000000000c9e284 in evaluate_join_record (join=join@entry=0x6290000c5a90, join_tab=<optimized out>, join_tab@entry=0x6290000cb3e0, error=error@entry=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23677
 
#22 0x0000000000be340f in sub_select (join=0x6290000c5a90, join_tab=0x6290000cb3e0, end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23481
 
#23 0x0000000000c45121 in do_select (join=0x6290000c5a90, procedure=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
 
#24 JOIN::exec_inner (this=0x6290000c5a90) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
 
#25 0x0000000000c428e9 in JOIN::exec (this=this@entry=0x6290000c5a90) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
 
#26 0x0000000000be5128 in mysql_select (thd=<optimized out>, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x6290000c5998, unit=0x6290000c12f8, select_lex=0x629000092ea8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
 
#27 0x0000000000a56eb7 in mysql_derived_fill (thd=<optimized out>, lex=<optimized out>, derived=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:1266
 
#28 0x0000000000a57cc2 in mysql_handle_single_derived (lex=0x62b0001703c8, derived=derived@entry=0x6290000c3238, phases=phases@entry=96) at /home/wx/mariadb-11.3.0/sql/sql_derived.cc:200
 
#29 0x0000000000c71b80 in st_join_table::preread_init (this=this@entry=0x62d0000e85f8) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:16029
 
#30 0x0000000000be2fea in sub_select (join=0x6290000c51c0, join_tab=0x62d0000e85f8, end_of_records=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:23392
 
#31 0x0000000000c45121 in do_select (join=0x6290000c51c0, procedure=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:22961
 
#32 JOIN::exec_inner (this=0x6290000c51c0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4941
 
#33 0x0000000000c428e9 in JOIN::exec (this=this@entry=0x6290000c51c0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:4718
 
#34 0x0000000000be5128 in mysql_select (thd=<optimized out>, thd@entry=0x62b00016c218, tables=<optimized out>, fields=..., conds=<optimized out>, og_num=<optimized out>, order=<optimized out>, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x6290000c5190, unit=0x62b0001704a8, select_lex=0x629000091610) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:5249
 
#35 0x0000000000be4596 in handle_select (thd=thd@entry=0x62b00016c218, lex=<optimized out>, lex@entry=0x62b0001703c8, result=<optimized out>, result@entry=0x6290000c5190, setup_tables_done_option=<optimized out>, setup_tables_done_option@entry=0) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:628
 
#36 0x0000000000b3df18 in execute_sqlcom_select (thd=0x62b00016c218, all_tables=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:6013
 
#37 0x0000000000b2cd51 in mysql_execute_command (thd=0x62b00016c218, is_called_from_prepared_stmt=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:3912
 
#38 0x0000000000b1fe79 in mysql_parse (thd=thd@entry=0x62b00016c218, rawbuf=<optimized out>, length=<optimized out>, parser_state=<optimized out>, parser_state@entry=0x7fffd242ca80) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
 
#39 0x0000000000b19069 in dispatch_command (command=<optimized out>, thd=0x62b00016c218, packet=<optimized out>, packet_length=<optimized out>, blocking=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
 
#40 0x0000000000b20b71 in do_command (thd=0x62b00016c218, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
 
#41 0x0000000000f03476 in do_handle_one_connection (connect=<optimized out>, put_in_cache=<optimized out>) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
 
#42 0x0000000000f02eb9 in handle_one_connection (arg=arg@entry=0x608001921d38) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
 
#43 0x0000000001a00c1b in pfs_spawn_thread (arg=0x617000005118) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
 
#44 0x00007ffff79f7609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
 
#45 0x00007ffff770f133 in clone () from /lib/x86_64-linux-gnu/libc.so.6



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

Thank you for the report!
I repeated on 10.4-11.2.

CREATE TABLE t1 ( a TEXT, b bool, index (a)) ;
 
INSERT INTO t1 VALUES ('-101',-87),('-95',59),(NULL,48);
 
 
 
SELECT 
       (SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
        union 
        SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1;


231023 17:56:45 [ERROR] mysqld got signal 11 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: babd833685e1fd1da4411a0874ba1c98bb0b631d
 
 
 
sql/signal_handler.cc:238(handle_fatal_signal)[0x5652c5021ca1]
 
sigaction.c:0(__restore_rt)[0x7f117b54d420]
 
sql/sql_select.cc:21794(test_if_quick_select(st_join_table*))[0x5652c49b462c]
 
sql/sql_select.cc:21770(join_init_quick_read_record(st_join_table*))[0x5652c49b4395]
 
sql/sql_select.cc:20899(sub_select(JOIN*, st_join_table*, bool))[0x5652c49ae1ce]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x5652c49afa55]
 
sql/sql_select.cc:20902(sub_select(JOIN*, st_join_table*, bool))[0x5652c49ae38a]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x5652c49ac130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x5652c4939c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x5652c49372a8]
 
sql/sql_union.cc:1603(st_select_lex_unit::exec())[0x5652c4b301ec]
 
sql/item_subselect.cc:4060(subselect_union_engine::exec())[0x5652c527d373]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x5652c5257a78]
 
sql/item_subselect.cc:1422(Item_singlerow_subselect::val_str(String*))[0x5652c525df81]
 
sql/sql_type.cc:7104(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x5652c4df0822]
 
sql/sql_type.h:4980(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x5652c4e0b216]
 
sql/item.h:1045(Item::send(Protocol*, st_value*))[0x5652c45a25e4]
 
sql/protocol.cc:1038(Protocol::send_result_set_row(List<Item>*))[0x5652c4593f63]
 
sql/sql_class.cc:3139(select_send::send_data(List<Item>&))[0x5652c4746d51]
 
sql/sql_select.cc:22098(end_send(JOIN*, st_join_table*, bool))[0x5652c49b76a7]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x5652c49afa55]
 
sql/sql_select.cc:20941(sub_select(JOIN*, st_join_table*, bool))[0x5652c49ae9f0]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x5652c49ac130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x5652c4939c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x5652c49372a8]
 
sql/sql_select.cc:4828(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*))[0x5652c493b484]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x5652c490bf7c]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x5652c4877d80]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x5652c48654f7]
 
sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x5652c488125b]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x5652c4857681]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x5652c48541ac]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x5652c4c6256d]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x5652c4c61e11]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x5652c590cd8a]
 
nptl/pthread_create.c:478(start_thread)[0x7f117b541609]
 
 
 
Query (0x62b0000a1290): SELECT 
(SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
union 
SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1

without index -> MDEV-32290 :

CREATE TABLE t1 ( a TEXT, b bool) ;
 
INSERT INTO t1 VALUES ('-101',-87),('-95',59),(NULL,48);
 
 
 
SELECT 
       (SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
        union 
        SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1;
 



Version: '10.4.32-MariaDB-debug-log' 
mysqld: /10.4/src/sql/sql_select.cc:20659: enum_nested_loop_state sub_select_cache(JOIN*, JOIN_TAB*, bool): Assertion `cache != __null' failed.
 
231023 17:57:36 [ERROR] mysqld got signal 6 ;
 
 
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: babd833685e1fd1da4411a0874ba1c98bb0b631d
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f214181a00b]
 
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f21417f9859]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f21417f9729]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f214180afd6]
 
sql/sql_select.cc:20661(sub_select_cache(JOIN*, st_join_table*, bool))[0x557a68749341]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x557a6874ba55]
 
sql/sql_select.cc:20902(sub_select(JOIN*, st_join_table*, bool))[0x557a6874a38a]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x557a68748130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x557a686d5c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x557a686d32a8]
 
sql/sql_union.cc:1603(st_select_lex_unit::exec())[0x557a688cc1ec]
 
sql/item_subselect.cc:4060(subselect_union_engine::exec())[0x557a69019373]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x557a68ff3a78]
 
sql/item_subselect.cc:1422(Item_singlerow_subselect::val_str(String*))[0x557a68ff9f81]
 
sql/sql_type.cc:7104(Type_handler::Item_send_str(Item*, Protocol*, st_value*) const)[0x557a68b8c822]
 
sql/sql_type.h:4980(Type_handler_string_result::Item_send(Item*, Protocol*, st_value*) const)[0x557a68ba7216]
 
sql/item.h:1045(Item::send(Protocol*, st_value*))[0x557a6833e5e4]
 
sql/protocol.cc:1038(Protocol::send_result_set_row(List<Item>*))[0x557a6832ff63]
 
sql/sql_class.cc:3139(select_send::send_data(List<Item>&))[0x557a684e2d51]
 
sql/sql_select.cc:22098(end_send(JOIN*, st_join_table*, bool))[0x557a687536a7]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x557a6874ba55]
 
sql/sql_select.cc:20941(sub_select(JOIN*, st_join_table*, bool))[0x557a6874a9f0]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x557a68748130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x557a686d5c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x557a686d32a8]
 
sql/sql_select.cc:4828(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*))[0x557a686d7484]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x557a686a7f7c]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x557a68613d80]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x557a686014f7]
 
sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x557a6861d25b]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x557a685f3681]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x557a685f01ac]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x557a689fe56d]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x557a689fde11]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x557a696a8d8a]
 
nptl/pthread_create.c:478(start_thread)[0x7f2141d25609]
 
 
 
Query (0x62b0000a1290): SELECT 
(SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
union 
SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1

with int instead of text -> MDEV-32397 :

CREATE TABLE t1 ( a int, b bool, index (a)) ;
 
INSERT INTO t1 VALUES ('-101',-87),('-95',59),(NULL,48);
 
 
 
SELECT 
       (SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
        union 
        SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1;


Version: '10.4.32-MariaDB-debug-log' 
mysqld: /10.4/src/sql/sql_select.cc:21905: int join_read_first(JOIN_TAB*): Assertion `table->no_keyread || !table->covering_keys.is_set(tab->index) || table->file->keyread == tab->index' failed.
 
231023 17:58:08 [ERROR] mysqld got signal 6 ;
 
 
 
Server version: 10.4.32-MariaDB-debug-log source revision: babd833685e1fd1da4411a0874ba1c98bb0b631d
 
 
 
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7f4ad857a00b]
 
/lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7f4ad8559859]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x22729)[0x7f4ad8559729]
 
/lib/x86_64-linux-gnu/libc.so.6(+0x33fd6)[0x7f4ad856afd6]
 
sql/sql_select.cc:21908(join_read_first(st_join_table*))[0x55bf58a95af7]
 
sql/sql_select.cc:20899(sub_select(JOIN*, st_join_table*, bool))[0x55bf58a8e1ce]
 
sql/opt_subselect.cc:5712(join_tab_execution_startup(st_join_table*))[0x55bf58e45933]
 
sql/sql_select.cc:20891(sub_select(JOIN*, st_join_table*, bool))[0x55bf58a8e08a]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bf58a8fa55]
 
sql/sql_select.cc:20902(sub_select(JOIN*, st_join_table*, bool))[0x55bf58a8e38a]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x55bf58a8c130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x55bf58a19c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x55bf58a172a8]
 
sql/sql_union.cc:1603(st_select_lex_unit::exec())[0x55bf58c101ec]
 
sql/item_subselect.cc:4060(subselect_union_engine::exec())[0x55bf5935d373]
 
sql/item_subselect.cc:758(Item_subselect::exec())[0x55bf59337a78]
 
sql/item_subselect.cc:1400(Item_singlerow_subselect::val_int())[0x55bf5933d9e1]
 
sql/sql_type.cc:7137(Type_handler::Item_send_long(Item*, Protocol*, st_value*) const)[0x55bf58ed0e6c]
 
sql/sql_type.h:5198(Type_handler_long::Item_send(Item*, Protocol*, st_value*) const)[0x55bf58eeb578]
 
sql/item.h:1045(Item::send(Protocol*, st_value*))[0x55bf586825e4]
 
sql/protocol.cc:1038(Protocol::send_result_set_row(List<Item>*))[0x55bf58673f63]
 
sql/sql_class.cc:3139(select_send::send_data(List<Item>&))[0x55bf58826d51]
 
sql/sql_select.cc:22098(end_send(JOIN*, st_join_table*, bool))[0x55bf58a976a7]
 
sql/sql_select.cc:21129(evaluate_join_record(JOIN*, st_join_table*, int))[0x55bf58a8fa55]
 
sql/sql_select.cc:20941(sub_select(JOIN*, st_join_table*, bool))[0x55bf58a8e9f0]
 
sql/sql_select.cc:20423(do_select(JOIN*, Procedure*))[0x55bf58a8c130]
 
sql/sql_select.cc:4605(JOIN::exec_inner())[0x55bf58a19c78]
 
sql/sql_select.cc:4388(JOIN::exec())[0x55bf58a172a8]
 
sql/sql_select.cc:4828(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*))[0x55bf58a1b484]
 
sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x55bf589ebf7c]
 
sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55bf58957d80]
 
sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x55bf589454f7]
 
sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55bf5896125b]
 
sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55bf58937681]
 
sql/sql_parse.cc:1378(do_command(THD*))[0x55bf589341ac]
 
sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x55bf58d4256d]
 
sql/sql_connect.cc:1325(handle_one_connection)[0x55bf58d41e11]
 
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55bf599ecd8a]
 
nptl/pthread_create.c:478(start_thread)[0x7f4ad8a85609]
 
 
 
Query (0x62b0000a1290): SELECT 
(SELECT 1 FROM  (SELECT 1 HAVING rand() ) dt1	
union 
SELECT a FROM t1  WHERE b IN  (SELECT a FROM t1) LIMIT 1) 
FROM t1

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