bug: left outer join lateral panic

[b41sh]

Search before asking

• I had searched in the issues and found no similar issues.

Version

main

What's Wrong?

left outer join lateral panic
this bug is find by fuzz postgres test.

panicked at src/query/sql/src/planner/optimizer/decorrelate/flatten_plan.rs:76:18:
called `Option::unwrap()` on a `None` value

How to Reproduce?

root@0.0.0.0:48000/default> SELECT * FROM (SELECT 1 AS x) AS ss1 LEFT OUTER JOIN (SELECT 2 DIV 228 AS y) AS ss2 ON TRUE, LATERAL (SELECT ss2.y AS z LIMIT 1) AS ss3;
error: APIError: QueryFailed: [1104]called `Option::unwrap()` on a `None` value

Are you willing to submit PR?

• Yes I am willing to submit a PR!