-
Notifications
You must be signed in to change notification settings - Fork 3.7k
Closed
Description
Search before asking
- I had searched in the issues and found no similar issues.
Version
master
What's Wrong?
CREATE TABLE nt1 (x String);
INSERT INTO nt1 (x) VALUES (NULL);
SELECT 'n fj n', t1.x, t2.x FROM nt1 AS t1 FULL JOIN nt1 AS t2 ON t1.x = t2.x ORDER BY t1.x;
result:
+----------+------+------+
| 'n fj n' | x | x |
+----------+------+------+
| n fj n | NULL | NULL |
What You Expected?
right result:
+----------+------+------+
| 'n fj n' | x | x |
+----------+------+------+
| n fj n | NULL | NULL |
| n fj n | NULL | NULL |
+----------+------+------+
How to Reproduce?
No response
Anything Else?
No response
Are you willing to submit PR?
- Yes I am willing to submit a PR!
Code of Conduct
- I agree to follow this project's Code of Conduct
Metadata
Metadata
Assignees
Labels
No labels