[MDEV-5991] crash in Item_field::used_tables Created: 2014-03-31  Updated: 2014-04-16  Resolved: 2014-04-16

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 5.5.36, 10.0.10
Fix Version/s: 5.5.38, 10.0.11

Type: Bug Priority: Major
Reporter: sbester1 Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: None


 Description   

mysqld.exe!Item_field::used_tables()[item.cc:2768]
mysqld.exe!Item::const_item()[item.h:1048]
mysqld.exe!Item_in_subselect::const_item()[item_subselect.h:606]
mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3457]
mysqld.exe!JOIN::optimize_constant_subqueries()[opt_subselect.cc:4986]
mysqld.exe!JOIN::optimize_inner()[sql_select.cc:1118]
mysqld.exe!JOIN::optimize()[sql_select.cc:1013]
mysqld.exe!st_select_lex::optimize_unflattened_subqueries()[sql_lex.cc:3489]
mysqld.exe!mysql_update()[sql_update.cc:369]
mysqld.exe!mysql_execute_command()[sql_parse.cc:3334]
mysqld.exe!mysql_parse()[sql_parse.cc:6457]
mysqld.exe!dispatch_command()[sql_parse.cc:1311]
mysqld.exe!do_command()[sql_parse.cc:1012]
mysqld.exe!threadpool_process_request()[threadpool_common.cc:233]
mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

How to repeat:

drop table if exists `r`;
create table `r`(`c` int)engine=innodb;
select exists(select 1 from `r`
group by `c` in (select `c` from `r`));



 Comments   
Comment by Elena Stepanova [ 2014-04-01 ]

Shane, thank you.

Comment by Jorge Manuel Silva [ 2014-04-01 ]

I can also reproduce this in 10.0.9 with myisam and aria engines, so this doesn't seem to be innodb related.

Comment by Oleksandr Byelkin [ 2014-04-12 ]

Sent for review

Generated at Thu Feb 08 07:08:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.