LP:1010116 - Incorrect query results in subqueries

SELECT

`Derived1`.`id`,

`Derived2`.`Val1`

FROM (select 30631 as `id`) AS `Derived1` LEFT OUTER JOIN (SELECT

2 as `id`,

1 AS `Val1`

FROM (select 30631 as `id`) AS `Derived3`) AS `Derived2` ON `Derived1`.`id` = `Derived2`.`id`;

id	Val1

30631	NULL

id	Val1

30631	1

create table t1 ( id int );

insert into t1 values (30631);

create table t2 ( id int );

insert into t2 values (30631);

create algorithm=MERGE view v2 as select 2 as id, 1 as val1 from t2;

select t1.*, v2.* from t1 left join v2 on t1.id = v2.id;

id	id	val1

30631	NULL	NULL

id	id	val1

30631	2	1