Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.36, 10.0.10
-
None
-
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`)); |