[MDEV-26164] crash in Item_subselect::init_expr_cache_tracker Created: 2021-07-16  Updated: 2021-07-16  Resolved: 2021-07-16

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.6.3
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Environment:

Linux x64


Issue Links:
Duplicate
duplicates MDEV-26047 MariaDB server crash at Item_subselec... Closed

 Description   

Version: '10.6.3-MariaDB'  MariaDB Server
Thread 14 "mysqld" received signal SIGSEGV, Segmentation fault.
 
(gdb) bt
#0  in Item_subselect::init_expr_cache_tracker at ./sql/item_subselect.cc:7003
#1  in Item_singlerow_subselect::expr_cache_insert_transformer at ./sql/item_subselect.cc:1389
#2  in JOIN::setup_subquery_caches at ./sql/sql_select.cc:4225
#3  in JOIN::optimize_stage2 at ./sql/sql_select.cc:3065
#4  in JOIN::optimize_inner at ./sql/sql_select.cc:2477
#5  in JOIN::optimize at ./sql/sql_select.cc:1807
#6  in st_select_lex::optimize_unflattened_subqueries at ./sql/sql_lex.cc:4937
#7  in JOIN::optimize_constant_subqueries at ./sql/opt_subselect.cc:5601
#8  in JOIN::optimize_inner at ./sql/sql_select.cc:2127
#9  in JOIN::optimize at ./sql/sql_select.cc:1807
#10 in mysql_select at ./sql/sql_select.cc:4968
#11 in handle_select at ./sql/sql_select.cc:556
#12 in execute_sqlcom_select at ./sql/sql_parse.cc:6252
#13 in mysql_execute_command at ./sql/sql_parse.cc:3947
#14 in mysql_parse at ./sql/sql_parse.cc:8026
#15 in dispatch_command  at ./sql/sql_parse.cc:1896
#16 in do_command at ./sql/sql_parse.cc:1405
#17 in do_handle_one_connection at ./sql/sql_connect.cc:1410
#18 in handle_one_connection at ./sql/sql_connect.cc:1312
#19 in pfs_spawn_thread at ./storage/perfschema/pfs.cc:2201
#20 in start_thread at pthread_create.c:481
#21 in clone 

Testcase

drop table if exists t;
create table t(a int);
 
select 1 from t where not exists 
( 
  select 1 from t where binary current_time()
  group by (select a),(select 1)
);



 Comments   
Comment by Alice Sherepa [ 2021-07-16 ]

Thanks!
This is the same bug as MDEV-26047 - I will add the test case there

Generated at Thu Feb 08 09:43:13 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.