Describe the bug
Do query like:
SELECT a.aid,
b.bid
FROM
(SELECT 3 AS aid)a
RIGHT JOIN
(SELECT 4 AS bid)b ON (a.aid=b.bid)
The right result is

But the Doris result is

Additional context
I Have find the problem. I will create a pull request to Fix this problem soon.