You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
statement ok
CREATE TABLE onecolumn (id INT PRIMARY KEY, x INT NULL)
statement ok
CREATE TABLE empty (e_id INT PRIMARY KEY, x INT)
statement ok
INSERT INTO onecolumn(id, x) VALUES (0, 44), (1, NULL), (2, 42)
# TODO: Full Join on nested loop join
query II
SELECT * FROM onecolumn AS a(x) FULL OUTER JOIN empty AS b(y) ON a.x = b.y ORDER BY a.x
----
42 NULL
44 NULL
NULL NULL
The text was updated successfully, but these errors were encountered:
Feature Request
The text was updated successfully, but these errors were encountered: