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)
# FIXME: The fields output by Using are determined by JoinType.
query I
SELECT * FROM onecolumn AS a LEFT OUTER JOIN empty AS b USING(x) ORDER BY x
----
null null 2
null 42 0
null 44 1
The text was updated successfully, but these errors were encountered:
KKould
changed the title
Fix: the fields output by Using are determined by JoinType
Fix: the fields output by Using are not determined by JoinType
Apr 10, 2024
Since using will generate column with the same name, only the column that are used once should be returned at this time, and the returned column should be selected from the left table or the right table according to JoinType.
Bug Report
The text was updated successfully, but these errors were encountered: