Repository navigation
Columns not found when joining subquery #467
Description
If you define a new column in a subquery and do a join the new column can't be referenced by the containing query. A "does not exist" error is returned.
An example:
CREATE TABLE users (
user_id INT PRIMARY KEY
);
CREATE TABLE names (
user_id INT REFERENCES users,
first_name TEXT,
last_name TEXT
);
SELECT
user_id,
full_name
FROM users
JOIN (
SELECT
user_id,
first_name || last_name AS full_name
FROM names
) AS full_names USING (user_id);Returns column "full_name" does not exist, though the query is valid.
Reacted by Jake Peyser
Activity
[-]Columns Not Found When Joining Subquery[/-][+]Columns not found when joining subquery[/+]parser: Support columns from subselect statements
parser: Support columns from subselect statements
parser: Support columns from subselect statements
parser: Support columns from subselect statements (#489)