select * from a subquery selects all columns for all tables in the subquery #2569Description
Version
1.20.0
What happened?
When selecting * from a subquery, the generated query selects all columns from all tables referenced in the subquery, not all fields selected by the subquery.
With the example provided below, the following query is generated:
SELECT t.id, authors.id, name, bio FROM (select id from authors) tThe generated query should be:
SELECT t.id FROM (select id from authors) tIf you modify the query to be:
SELECT t.* FROM (select id from authors) t;then the generated query is correct.
Relevant log output
No response
Database schema
CREATE TABLE authors (
id BIGSERIAL PRIMARY KEY,
name text NOT NULL,
bio text
);SQL queries
SELECT * FROM (select id from authors) t;Configuration
{
"version": "1",
"packages": [
{
"path": "db",
"engine": "postgresql",
"schema": "query.sql",
"queries": "query.sql"
}
]
}Playground URL
https://play.sqlc.dev/p/40aa4c5ab1bd5efb90024e9b35a08cdc83d28237ba2bfdc2f3ecf4ec47da4c68
What operating system are you using?
Linux
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go