Open davidshiz opened 1 year ago
Same as #887 .
The query results of the following SQL statements are correct
select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t2.a = t3.a) left join t4 on (t4.a = t3.a) left join t5 on (t5.a = t4.a);
select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t2.a = t3.a and t3.a = t1.a);
select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t2.a = t3.a) left join t4 on (t4.a = t3.a and t1.a = t4.a);
select * from t1 left join t2 on (t1.a = t2.a) left join t3 on (t2.a = t3.a) left join t4 on (t4.a = t3.a and t2.a = t4.a);
ACK
SELECT
*
FROM
t1
LEFT JOIN t2 ON
(t1.a = t2.a)
LEFT JOIN t3 ON
(t1.a = t3.a)
LEFT JOIN t4 ON
(t1.a = t4.a)
LEFT JOIN t5 ON
(t1.a = t5.a);
Have you read the Contributing Guidelines on issues?
Please confirm if bug report does NOT exists already ?
Describe the problem
The wrong result is as follows:
Expected behavior
How To Reproduce
Environment
Are you interested in submitting a PR to solve the problem?