Details
Description
running the following
create table t1 (a int) engine=myisam; |
insert into t1 values (1),(2); |
--echo t1 not const
|
|
create table t2 (b int) engine=myisam; |
|
select * from t1, t2 where b in |
( select (select a from t1 order by b) as d from t1 group by (select d) ); |
|
drop table t1, t2; |
causes the server to crash in st_select_lex::optimize_unflattened_subqueries()
JOIN::optimize_stage2 on the join for
/* select#2 */ select (subquery#3) AS d from t1 group by (subquery#4) having <cache>(t1.a) = <ref_null_helper>((subquery#3))
|
attempting to update the group list
(SUBSELECT_ITEM*)((select `d`))
|
Attachments
Issue Links
- relates to
-
MDEV-30756 Crash in get_sort_by_table / make_join_statistics / update_depend_map_for_order, UBSAN member access within null pointer in update_depend_map_for_order
- Stalled